countdown_genres
9 rows where genre_id = 187
This data as json, CSV (advanced)
| Link | rank | genre_id |
|---|---|---|
| 272,187 | 272 272 | synthpop 187 |
| 297,187 | 297 297 | synthpop 187 |
| 365,187 | 365 365 | synthpop 187 |
| 538,187 | 538 538 | synthpop 187 |
| 583,187 | 583 583 | synthpop 187 |
| 615,187 | 615 615 | synthpop 187 |
| 765,187 | 765 765 | synthpop 187 |
| 768,187 | 768 768 | synthpop 187 |
| 790,187 | 790 790 | synthpop 187 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);