home / xpn_countdown

countdown_genres

10 rows where genre_id = 19

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
263,19 263 263 baroque pop 19
283,19 283 283 baroque pop 19
320,19 320 320 baroque pop 19
362,19 362 362 baroque pop 19
453,19 453 453 baroque pop 19
522,19 522 522 baroque pop 19
740,19 740 740 baroque pop 19
747,19 747 747 baroque pop 19
842,19 842 842 baroque pop 19
856,19 856 856 baroque pop 19

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