home / xpn_countdown

countdown_genres

14 rows where genre_id = 106

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
299,106 299 299 jazz blues 106
323,106 323 323 jazz blues 106
370,106 370 370 jazz blues 106
417,106 417 417 jazz blues 106
450,106 450 450 jazz blues 106
475,106 475 475 jazz blues 106
587,106 587 587 jazz blues 106
621,106 621 621 jazz blues 106
654,106 654 654 jazz blues 106
657,106 657 657 jazz blues 106
742,106 742 742 jazz blues 106
764,106 764 764 jazz blues 106
841,106 841 841 jazz blues 106
882,106 882 882 jazz blues 106

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