countdown
1 row where originalYear = 1967 and song = "David Watts"
This data as json, CSV (advanced)
Suggested facets: timeslice (date)
song 1
- David Watts · 1 ✖
releaseDate 1
- 1978 1
originalYear 1
- 1967 · 1 ✖
originalArtist 1
artist 1
- The Jam 1
| rank ▼ | artist | song | album | releaseDate | albumArt | timeslice | originalYear | originalArtist |
|---|---|---|---|---|---|---|---|---|
| 708 | The Jam | David Watts | All Mod Cons | 1978 | 2025-12-05 11:54:50 | 1967 | The Kinks |
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);