home / xpn_countdown

countdown_genres

7 rows where genre_id = 128

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
304,128 304 304 old school hip hop 128
503,128 503 503 old school hip hop 128
518,128 518 518 old school hip hop 128
585,128 585 585 old school hip hop 128
627,128 627 627 old school hip hop 128
634,128 634 634 old school hip hop 128
776,128 776 776 old school hip hop 128

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