countdown
1 row where originalArtist = "John Lennon", originalYear = 1975 and song = "Working Class Hero"
This data as json, CSV (advanced)
Suggested facets: timeslice (date)
song 1
- Working Class Hero · 1 ✖
releaseDate 1
- 2007 1
originalYear 1
- 1975 · 1 ✖
originalArtist 1
- John Lennon · 1 ✖
artist 1
| rank ▼ | artist | song | album | releaseDate | albumArt | timeslice | originalYear | originalArtist |
|---|---|---|---|---|---|---|---|---|
| 721 | Green Day | Working Class Hero | Instant Karma - The Campaign To Save Darfur | 2007 | 2025-12-05 10:52:33 | 1975 | John Lennon |
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);