home / xpn_countdown

countdown_genres

17 rows where genre_id = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
317,2 317 317 acid rock 2
348,2 348 348 acid rock 2
398,2 398 398 acid rock 2
401,2 401 401 acid rock 2
409,2 409 409 acid rock 2
427,2 427 427 acid rock 2
506,2 506 506 acid rock 2
535,2 535 535 acid rock 2
564,2 564 564 acid rock 2
607,2 607 607 acid rock 2
661,2 661 661 acid rock 2
812,2 812 812 acid rock 2
813,2 813 813 acid rock 2
815,2 815 815 acid rock 2
823,2 823 823 acid rock 2
845,2 845 845 acid rock 2
863,2 863 863 acid rock 2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE countdown_genres (
            rank INTEGER,
            genre_id INTEGER,
            FOREIGN KEY (rank) REFERENCES countdown(rank),
            FOREIGN KEY (genre_id) REFERENCES genres(id),
            PRIMARY KEY (rank, genre_id)
        );
CREATE INDEX idx_countdown_genres_genre ON countdown_genres(genre_id);
Powered by Datasette · Queries took 3.634ms