countdown
1 row where originalYear = 1967, releaseDate = 1979 and song = "So You Want To Be A Rock And Roll Star"
This data as json, CSV (advanced)
Suggested facets: timeslice (date)
song 1
- So You Want To Be A Rock And Roll Star · 1 ✖
releaseDate 1
- 1979 · 1 ✖
originalYear 1
- 1967 · 1 ✖
originalArtist 1
artist 1
| rank ▼ | artist | song | album | releaseDate | albumArt | timeslice | originalYear | originalArtist |
|---|---|---|---|---|---|---|---|---|
| 420 | Patti Smith | So You Want To Be A Rock And Roll Star | Wave | 1979 | 2025-12-08 15:44:55 | 1967 | The Byrds |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE countdown (
rank INTEGER PRIMARY KEY,
artist TEXT NOT NULL,
song TEXT NOT NULL,
album TEXT,
releaseDate TEXT,
albumArt TEXT,
timeslice TEXT,
originalYear TEXT,
originalArtist TEXT
);
CREATE INDEX idx_artist ON countdown(artist);