home / xpn_countdown

countdown_genres

5 rows where genre_id = 195

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
514,195 514 514 underground hip hop 195
590,195 590 590 underground hip hop 195
693,195 693 693 underground hip hop 195
758,195 758 758 underground hip hop 195
807,195 807 807 underground hip hop 195

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.928ms