home / xpn_countdown

countdown

3 rows where originalYear = 1967 and releaseDate = 1973

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

song 3

  • Ain't Nothin' But A Houseparty 1
  • Let's Spend The Night Together 1
  • These Days 1

originalArtist 3

  • Nico 1
  • The Rolling Stones 1
  • The Showstoppers 1

artist 3

  • David Bowie 1
  • Gregg Allman 1
  • The J. Geils Band 1

releaseDate 1

  • 1973 · 3 ✖

originalYear 1

  • 1967 · 3 ✖
rank ▼ artist song album releaseDate albumArt timeslice originalYear originalArtist
364 Gregg Allman These Days Laid Back 1973 2025-12-09 10:25:56 1967 Nico
539 The J. Geils Band Ain't Nothin' But A Houseparty Bloodshot 1973 2025-12-07 14:50:31 1967 The Showstoppers
567 David Bowie Let's Spend The Night Together Aladdin Sane 1973 2025-12-07 12:27:11 1967 The Rolling Stones

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 9.369ms