countdown_genres

5 rows where genre_id = 198

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
304,198 304 304 west coast hip hop 198
363,198 363 363 west coast hip hop 198
518,198 518 518 west coast hip hop 198
585,198 585 585 west coast hip hop 198
874,198 874 874 west coast hip hop 198

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