home / xpn_countdown

countdown_genres

28 rows where genre_id = 156

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
271,156 271 271 rock 156
278,156 278 278 rock 156
291,156 291 291 rock 156
326,156 326 326 rock 156
366,156 366 366 rock 156
419,156 419 419 rock 156
440,156 440 440 rock 156
479,156 479 479 rock 156
496,156 496 496 rock 156
516,156 516 516 rock 156
555,156 555 555 rock 156
559,156 559 559 rock 156
575,156 575 575 rock 156
635,156 635 635 rock 156
653,156 653 653 rock 156
674,156 674 674 rock 156
684,156 684 684 rock 156
700,156 700 700 rock 156
707,156 707 707 rock 156
714,156 714 714 rock 156
728,156 728 728 rock 156
791,156 791 791 rock 156
805,156 805 805 rock 156
808,156 808 808 rock 156
819,156 819 819 rock 156
822,156 822 822 rock 156
840,156 840 840 rock 156
853,156 853 853 rock 156

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