home / xpn_countdown

countdown

2 rows where originalYear = 1986 and releaseDate = 2006

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

song 2

  • Also Sprach Zarthustra (2001) 1
  • Orion 1

originalArtist 2

  • Metallica 1
  • Richard Strauss 1

artist 2

  • Phish 1
  • Rodrigo Y Gabriela 1

releaseDate 1

  • 2006 · 2 ✖

originalYear 1

  • 1986 · 2 ✖
rank ▼ artist song album releaseDate albumArt timeslice originalYear originalArtist
328 Phish Also Sprach Zarthustra (2001) Live Phish, Vol. 4 2006 2025-12-09 12:59:57 1986 Richard Strauss
828 Rodrigo Y Gabriela Orion Rodrigo Y Gabriela 2006 2025-12-04 12:21:45 1986 Metallica

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.212ms