countdown_genres

5 rows where rank = 574

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
574,57 574 574 dub 57
574,146 574 574 ragga 146
574,151 574 574 reggae 151
574,159 574 574 rocksteady 159
574,160 574 574 roots reggae 160

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