countdown
1 row where releaseDate = 1970 and song = "Up On The Roof"
This data as json, CSV (advanced)
Suggested facets: timeslice (date)
song 1
- Up On The Roof · 1 ✖
releaseDate 1
- 1970 · 1 ✖
originalYear 1
- 1964 1
originalArtist 1
artist 1
| rank ▼ | artist | song | album | releaseDate | albumArt | timeslice | originalYear | originalArtist |
|---|---|---|---|---|---|---|---|---|
| 788 | Laura Nyro | Up On The Roof | Christmas And The Beads Of Sweat | 1970 | 2025-12-04 15:39:42 | 1964 | The Drifters |
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);