home / xpn_countdown

countdown_genres

7 rows where genre_id = 153

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
300,153 300 300 retro soul 153
570,153 570 570 retro soul 153
618,153 618 618 retro soul 153
677,153 677 677 retro soul 153
760,153 760 760 retro soul 153
766,153 766 766 retro soul 153
834,153 834 834 retro soul 153

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