home / xpn_countdown

countdown

3 rows where artist = "Grateful Dead" and releaseDate = 2017

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

song 3

  • Big River 1
  • Mama Tried 1
  • Me and Bobby McGee 1

originalYear 3

  • 1958 1
  • 1968 1
  • 1970 1

originalArtist 3

  • Johnny Cash 1
  • Kris Kristofferson 1
  • Merle Haggard 1

releaseDate 1

  • 2017 · 3 ✖

artist 1

  • Grateful Dead · 3 ✖
rank ▼ artist song album releaseDate albumArt timeslice originalYear originalArtist
409 Grateful Dead Mama Tried Grateful Dead 2017 2025-12-08 16:46:45 1968 Merle Haggard
607 Grateful Dead Big River Dick's Picks Volume 36: The Spectrum, Philadelphia, PA 9/21/72 2017 2025-12-06 14:57:09 1958 Johnny Cash
812 Grateful Dead Me and Bobby McGee Grateful Dead (Skull & Roses) 2017 2025-12-04 13:43:08 1970 Kris Kristofferson

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