countdown
2 rows where originalArtist = "The Doors" and originalYear = 1967
This data as json, CSV (advanced)
Suggested facets: timeslice (date)
song 2
artist 2
- Jose Feliciano 1
- X 1
releaseDate 1
- 2011 2
originalYear 1
- 1967 · 2 ✖
originalArtist 1
- The Doors · 2 ✖
| rank ▼ | artist | song | album | releaseDate | albumArt | timeslice | originalYear | originalArtist |
|---|---|---|---|---|---|---|---|---|
| 325 | Jose Feliciano | Light My Fire | Light My Fire - Best Of Jose Feliciano | 2011 | 2025-12-09 13:23:48 | 1967 | The Doors | |
| 363 | X | Soul Kitchen | Los Angeles | 2011 | 2025-12-09 10:29:45 | 1967 | The Doors |
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);