home / xpn_countdown

countdown

3 rows where originalYear = 1968 and releaseDate = 2018

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

song 3

  • Blackbird 1
  • Sympathy For The Devil 1
  • Wichita Lineman 1

originalArtist 3

  • Glen Campbell 1
  • The Beatles 1
  • The Rolling Stones 1

artist 3

  • Bobby McFerrin 1
  • Freedy Johnston 1
  • Jane's Addiction 1

releaseDate 1

  • 2018 · 3 ✖

originalYear 1

  • 1968 · 3 ✖
rank ▼ artist song album releaseDate albumArt timeslice originalYear originalArtist
799 Jane's Addiction Sympathy For The Devil Sons Of Anarchy, Vol. II 2018 2025-12-04 14:46:42 1968 The Rolling Stones
817 Freedy Johnston Wichita Lineman Unlucky 2018 2025-12-04 13:20:46 1968 Glen Campbell
858 Bobby McFerrin Blackbird THE VOICE 2018 2025-12-04 10:03:37 1968 The Beatles

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