countdown_genres
16 rows where genre_id = 140
This data as json, CSV (advanced)
| Link | rank | genre_id |
|---|---|---|
| 284,140 | 284 284 | proto-punk 140 |
| 310,140 | 310 310 | proto-punk 140 |
| 315,140 | 315 315 | proto-punk 140 |
| 343,140 | 343 343 | proto-punk 140 |
| 348,140 | 348 348 | proto-punk 140 |
| 362,140 | 362 362 | proto-punk 140 |
| 410,140 | 410 410 | proto-punk 140 |
| 420,140 | 420 420 | proto-punk 140 |
| 426,140 | 426 426 | proto-punk 140 |
| 485,140 | 485 485 | proto-punk 140 |
| 498,140 | 498 498 | proto-punk 140 |
| 520,140 | 520 520 | proto-punk 140 |
| 593,140 | 593 593 | proto-punk 140 |
| 685,140 | 685 685 | proto-punk 140 |
| 780,140 | 780 780 | proto-punk 140 |
| 873,140 | 873 873 | proto-punk 140 |
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);