countdown_genres

11 rows where genre_id = 197

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
370,197 370 370 vocal jazz 197
417,197 417 417 vocal jazz 197
450,197 450 450 vocal jazz 197
475,197 475 475 vocal jazz 197
493,197 493 493 vocal jazz 197
621,197 621 621 vocal jazz 197
626,197 626 626 vocal jazz 197
654,197 654 654 vocal jazz 197
657,197 657 657 vocal jazz 197
742,197 742 742 vocal jazz 197
882,197 882 882 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);