home / xpn_countdown

countdown_genres

20 rows where genre_id = 103

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
294,103 294 294 jam band 103
306,103 306 306 jam band 103
317,103 317 317 jam band 103
328,103 328 328 jam band 103
390,103 390 390 jam band 103
401,103 401 401 jam band 103
409,103 409 409 jam band 103
429,103 429 429 jam band 103
506,103 506 506 jam band 103
535,103 535 535 jam band 103
564,103 564 564 jam band 103
605,103 605 605 jam band 103
607,103 607 607 jam band 103
731,103 731 731 jam band 103
802,103 802 802 jam band 103
812,103 812 812 jam band 103
823,103 823 823 jam band 103
824,103 824 824 jam band 103
845,103 845 845 jam band 103
863,103 863 863 jam band 103

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 4.068ms