home / xpn_countdown

countdown

7 rows where originalArtist = "David Bowie"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: album, albumArt, timeslice (date)

song 6

  • Heroes 2
  • Let's Dance 1
  • Life On Mars? 1
  • Rebel Rebel 1
  • Space Oddity 1
  • Ziggy Stardust 1

releaseDate 6

  • 2004 2
  • 1980 1
  • 2003 1
  • 2010 1
  • 2012 1
  • 2022 1

originalYear 6

  • 1977 2
  • 1969 1
  • 1971 1
  • 1972 1
  • 1974 1
  • 1983 1

artist 6

  • Seu Jorge 2
  • Bauhaus 1
  • Brandi Carlile 1
  • M. Ward 1
  • Peter Gabriel 1
  • The Wallflowers 1

originalArtist 1

  • David Bowie · 7 ✖
rank ▼ artist song album releaseDate albumArt timeslice originalYear originalArtist
312 Bauhaus Ziggy Stardust single 1980 2025-12-09 14:23:36 1972 David Bowie
359 Peter Gabriel Heroes Scratch My Back 2010 2025-12-09 10:46:40 1977 David Bowie
382 Seu Jorge Life On Mars? The Life Aquatic Soundtrack 2004 2025-12-09 09:01:03 1971 David Bowie
392 The Wallflowers Heroes Godzilla OST 2012 2025-12-09 08:01:50 1977 David Bowie
494 M. Ward Let's Dance Transfiguration of Vincent 2003 2025-12-08 09:28:13 1983 David Bowie
505 Brandi Carlile Space Oddity In The Canyon Haze 2022 2025-12-08 08:30:56 1969 David Bowie
527 Seu Jorge Rebel Rebel The Life Aquatic Soundtrack 2004 2025-12-07 15:58:32 1974 David Bowie

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 15.251ms