countdown
1 row where originalYear = 1943 and song = "Fanfare for the Common Man"
This data as json, CSV (advanced)
Suggested facets: timeslice (date)
song 1
- Fanfare for the Common Man · 1 ✖
releaseDate 1
- 2016 1
originalYear 1
- 1943 · 1 ✖
originalArtist 1
artist 1
| rank ▼ | artist | song | album | releaseDate | albumArt | timeslice | originalYear | originalArtist |
|---|---|---|---|---|---|---|---|---|
| 571 | Emerson Lake & Palmer | Fanfare for the Common Man | Works, Volume 1 | 2016 | 2025-12-07 12:01:01 | 1943 | Aaron Copeland |
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);