countdown
2 rows where originalYear = 1967 and releaseDate = 1978
This data as json, CSV (advanced)
Suggested facets: timeslice (date)
song 2
- David Watts 1
- Soul Man 1
originalArtist 2
- Sam & Dave 1
- The Kinks 1
artist 2
releaseDate 1
- 1978 · 2 ✖
originalYear 1
- 1967 · 2 ✖
| rank ▼ | artist | song | album | releaseDate | albumArt | timeslice | originalYear | originalArtist |
|---|---|---|---|---|---|---|---|---|
| 566 | The Blues Brothers | Soul Man | Briefcase Full Of Blues | 1978 | 2025-12-07 12:30:20 | 1967 | Sam & Dave | |
| 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);