home / xpn_countdown

countdown_genres

7 rows where genre_id = 37

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
325,37 325 325 christmas 37
383,37 383 383 christmas 37
557,37 557 557 christmas 37
654,37 654 654 christmas 37
795,37 795 795 christmas 37
850,37 850 850 christmas 37
882,37 882 882 christmas 37

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