home / xpn_countdown

countdown

3 rows where artist = "Tori Amos"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: album, timeslice (date)

song 3

  • Famous Blue Raincoat 1
  • I Don't Like Mondays 1
  • Time 1

releaseDate 3

  • 1995 1
  • 1998 1
  • 2007 1

originalYear 3

  • 1971 1
  • 1973 1
  • 1979 1

originalArtist 3

  • Boomtown Rats 1
  • Leonoard Cohen 1
  • Tom Waits 1

artist 1

  • Tori Amos · 3 ✖
rank ▼ artist song album releaseDate albumArt timeslice originalYear originalArtist
464 Tori Amos Time Strange Little Girls 1998 2025-12-08 11:46:13 1973 Tom Waits
717 Tori Amos Famous Blue Raincoat Tower Of Song - The Songs Of Leonard Cohen 1995 2025-12-05 11:10:57 1971 Leonoard Cohen
821 Tori Amos I Don't Like Mondays Strange Little Girls 2007 2025-12-04 13:02:07 1979 Boomtown Rats

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