home / xpn_countdown

countdown_genres

27 rows where genre_id = 175

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
260,175 260 260 soul 175
292,175 292 292 soul 175
299,175 299 299 soul 175
300,175 300 300 soul 175
305,175 305 305 soul 175
323,175 323 323 soul 175
339,175 339 339 soul 175
342,175 342 342 soul 175
345,175 345 345 soul 175
370,175 370 370 soul 175
417,175 417 417 soul 175
446,175 446 446 soul 175
450,175 450 450 soul 175
475,175 475 475 soul 175
478,175 478 478 soul 175
524,175 524 524 soul 175
540,175 540 540 soul 175
558,175 558 558 soul 175
587,175 587 587 soul 175
618,175 618 618 soul 175
621,175 621 621 soul 175
657,175 657 657 soul 175
690,175 690 690 soul 175
742,175 742 742 soul 175
764,175 764 764 soul 175
827,175 827 827 soul 175
834,175 834 834 soul 175

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