home / xpn_countdown

countdown_genres

22 rows where genre_id = 24

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
265,24 265 265 blues rock 24
294,24 294 294 blues rock 24
307,24 307 307 blues rock 24
344,24 344 344 blues rock 24
364,24 364 364 blues rock 24
398,24 398 398 blues rock 24
442,24 442 442 blues rock 24
525,24 525 525 blues rock 24
566,24 566 566 blues rock 24
632,24 632 632 blues rock 24
653,24 653 653 blues rock 24
687,24 687 687 blues rock 24
698,24 698 698 blues rock 24
700,24 700 700 blues rock 24
701,24 701 701 blues rock 24
718,24 718 718 blues rock 24
727,24 727 727 blues rock 24
741,24 741 741 blues rock 24
753,24 753 753 blues rock 24
791,24 791 791 blues rock 24
800,24 800 800 blues rock 24
861,24 861 861 blues rock 24

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