home / xpn_countdown

countdown_genres

5 rows where genre_id = 186

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
477,186 477 477 swing music 186
654,186 654 654 swing music 186
697,186 697 697 swing music 186
735,186 735 735 swing music 186
882,186 882 882 swing music 186

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