home / xpn_countdown

countdown_genres

7 rows where genre_id = 74

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
310,74 310 310 garage rock 74
565,74 565 565 garage rock 74
632,74 632 632 garage rock 74
653,74 653 653 garage rock 74
700,74 700 700 garage rock 74
718,74 718 718 garage rock 74
791,74 791 791 garage rock 74

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