countdown
3 rows where originalArtist = "The Beatles" and originalYear = 1966
This data as json, CSV (advanced)
Suggested facets: timeslice (date)
song 3
artist 3
- 801 1
- Aretha Franklin 1
- The Black Keys 1
originalYear 1
- 1966 · 3 ✖
originalArtist 1
- The Beatles · 3 ✖
| rank ▼ | artist | song | album | releaseDate | albumArt | timeslice | originalYear | originalArtist |
|---|---|---|---|---|---|---|---|---|
| 323 | Aretha Franklin | Eleanor Rigby | This Girl's In Love With You | 1970 | 2025-12-09 13:33:33 | 1966 | The Beatles | |
| 451 | 801 | Tomorrow Never Knows | 801 Live | 1984 | 2025-12-08 13:00:23 | 1966 | The Beatles | |
| 653 | The Black Keys | She Said, She Said | The Big Come Up | 2002 | 2025-12-06 11:12:42 | 1966 | The Beatles |
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);