countdown
2 rows where originalArtist = "Mamas and Papas", originalYear = 1965 and song = "California Dreamin'"
This data as json, CSV (advanced)
Suggested facets: timeslice (date)
artist 2
song 1
- California Dreamin' · 2 ✖
originalYear 1
- 1965 · 2 ✖
originalArtist 1
- Mamas and Papas · 2 ✖
| rank ▼ | artist | song | album | releaseDate | albumArt | timeslice | originalYear | originalArtist |
|---|---|---|---|---|---|---|---|---|
| 690 | Bobby Womack | California Dreamin' | Fly Me To The Moon | 1969 | 2025-12-05 14:08:45 | 1965 | Mamas and Papas | |
| 756 | Eddie Hazel | California Dreamin' | Game, Dames And Guitar Thangs | 1977 | 2025-12-05 07:59:25 | 1965 | Mamas and Papas |
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);