home / xpn_countdown

countdown_genres

6 rows where genre_id = 116

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
307,116 307 307 modern blues 116
344,116 344 344 modern blues 116
525,116 525 525 modern blues 116
653,116 653 653 modern blues 116
698,116 698 698 modern blues 116
741,116 741 741 modern blues 116

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