home / xpn_countdown

countdown_genres

14 rows where genre_id = 180

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
265,180 265 265 southern rock 180
294,180 294 294 southern rock 180
344,180 344 344 southern rock 180
351,180 351 351 southern rock 180
364,180 364 364 southern rock 180
399,180 399 399 southern rock 180
469,180 469 469 southern rock 180
510,180 510 510 southern rock 180
525,180 525 525 southern rock 180
556,180 556 556 southern rock 180
620,180 620 620 southern rock 180
698,180 698 698 southern rock 180
741,180 741 741 southern rock 180
868,180 868 868 southern rock 180

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