home / xpn_countdown

countdown

3 rows where originalArtist = "Lou Reed"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

releaseDate 3

  • 1995 1
  • 2013 1
  • 2023 1

artist 3

  • Al Green 1
  • Duran Duran 1
  • Puddles Pity Party 1

song 1

  • Perfect Day 3

originalYear 1

  • 1972 3

originalArtist 1

  • Lou Reed · 3 ✖
rank ▼ artist song album releaseDate albumArt timeslice originalYear originalArtist
292 Al Green Perfect Day Perfect Day (single) 2023 2025-12-09 15:55:52 1972 Lou Reed
538 Duran Duran Perfect Day Thank You 1995 2025-12-07 14:56:56 1972 Lou Reed
693 Puddles Pity Party Perfect Day (live in Tokyo) 2013 2025-12-05 13:48:40 1972 Lou Reed

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