countdown_genres

6 rows where rank = 621

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
621,23 621 621 blues 23
621,41 621 621 classic soul 41
621,106 621 621 jazz blues 106
621,175 621 621 soul 175
621,176 621 621 soul blues 176
621,197 621 621 vocal jazz 197

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