countdown_genres

7 rows where rank = 841

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
841,20 841 841 bebop 20
841,44 841 841 cool jazz 44
841,67 841 841 free jazz 67
841,85 841 841 hard bop 85
841,105 841 841 jazz 105
841,106 841 841 jazz blues 106
841,108 841 841 jazz fusion 108

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);