home / xpn_countdown

countdown_genres

12 rows where genre_id = 66

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
274,66 274 274 folk rock 66
314,66 314 314 folk rock 66
388,66 388 388 folk rock 66
397,66 397 397 folk rock 66
488,66 488 488 folk rock 66
515,66 515 515 folk rock 66
620,66 620 620 folk rock 66
630,66 630 630 folk rock 66
666,66 666 666 folk rock 66
734,66 734 734 folk rock 66
754,66 754 754 folk rock 66
878,66 878 878 folk rock 66

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