home / xpn_countdown

countdown_genres

20 rows where genre_id = 22

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
270,22 270 270 bluegrass 22
285,22 285 285 bluegrass 22
295,22 295 295 bluegrass 22
321,22 321 321 bluegrass 22
336,22 336 336 bluegrass 22
346,22 346 346 bluegrass 22
377,22 377 377 bluegrass 22
406,22 406 406 bluegrass 22
408,22 408 408 bluegrass 22
418,22 418 418 bluegrass 22
444,22 444 444 bluegrass 22
531,22 531 531 bluegrass 22
579,22 579 579 bluegrass 22
601,22 601 601 bluegrass 22
619,22 619 619 bluegrass 22
725,22 725 725 bluegrass 22
770,22 770 770 bluegrass 22
796,22 796 796 bluegrass 22
809,22 809 809 bluegrass 22
836,22 836 836 bluegrass 22

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