home / xpn_countdown

countdown_genres

29 rows where genre_id = 141

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
317,141 317 317 psychedelic rock 141
329,141 329 329 psychedelic rock 141
348,141 348 348 psychedelic rock 141
350,141 350 350 psychedelic rock 141
361,141 361 361 psychedelic rock 141
398,141 398 398 psychedelic rock 141
401,141 401 401 psychedelic rock 141
404,141 404 404 psychedelic rock 141
409,141 409 409 psychedelic rock 141
423,141 423 423 psychedelic rock 141
427,141 427 427 psychedelic rock 141
448,141 448 448 psychedelic rock 141
506,141 506 506 psychedelic rock 141
535,141 535 535 psychedelic rock 141
564,141 564 564 psychedelic rock 141
565,141 565 565 psychedelic rock 141
607,141 607 607 psychedelic rock 141
740,141 740 740 psychedelic rock 141
749,141 749 749 psychedelic rock 141
754,141 754 754 psychedelic rock 141
756,141 756 756 psychedelic rock 141
812,141 812 812 psychedelic rock 141
813,141 813 813 psychedelic rock 141
815,141 815 815 psychedelic rock 141
823,141 823 823 psychedelic rock 141
843,141 843 843 psychedelic rock 141
845,141 845 845 psychedelic rock 141
863,141 863 863 psychedelic rock 141
866,141 866 866 psychedelic rock 141

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