home / xpn_countdown

countdown

3 rows where artist = "David Bowie" and releaseDate = 1973

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: album, albumArt, timeslice (date)

song 3

  • Friday On My Mind 1
  • Let's Spend The Night Together 1
  • Sorrow 1

originalYear 3

  • 1965 1
  • 1966 1
  • 1967 1

originalArtist 3

  • The Easybeats 1
  • The McCoys 1
  • The Rolling Stones 1

releaseDate 1

  • 1973 · 3 ✖

artist 1

  • David Bowie · 3 ✖
rank ▼ artist song album releaseDate albumArt timeslice originalYear originalArtist
384 David Bowie Sorrow Pinups 1973 2025-12-09 08:53:58 1965 The McCoys
512 David Bowie Friday On My Mind Pinups 1973 2025-12-07 16:54:30 1966 The Easybeats
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.052ms