home / xpn_countdown

countdown_genres

41 rows where genre_id = 40

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
265,40 265 265 classic rock 40
271,40 271 271 classic rock 40
282,40 282 282 classic rock 40
291,40 291 291 classic rock 40
294,40 294 294 classic rock 40
314,40 314 314 classic rock 40
329,40 329 329 classic rock 40
334,40 334 334 classic rock 40
350,40 350 350 classic rock 40
361,40 361 361 classic rock 40
381,40 381 381 classic rock 40
398,40 398 398 classic rock 40
399,40 399 399 classic rock 40
404,40 404 404 classic rock 40
419,40 419 419 classic rock 40
423,40 423 423 classic rock 40
442,40 442 442 classic rock 40
448,40 448 448 classic rock 40
469,40 469 469 classic rock 40
489,40 489 489 classic rock 40
496,40 496 496 classic rock 40
510,40 510 510 classic rock 40
516,40 516 516 classic rock 40
528,40 528 528 classic rock 40
539,40 539 539 classic rock 40
556,40 556 556 classic rock 40
635,40 635 635 classic rock 40
648,40 648 648 classic rock 40
649,40 649 649 classic rock 40
681,40 681 681 classic rock 40
701,40 701 701 classic rock 40
707,40 707 707 classic rock 40
728,40 728 728 classic rock 40
779,40 779 779 classic rock 40
805,40 805 805 classic rock 40
808,40 808 808 classic rock 40
815,40 815 815 classic rock 40
819,40 819 819 classic rock 40
843,40 843 843 classic rock 40
853,40 853 853 classic rock 40
866,40 866 866 classic rock 40

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