home / xpn_countdown

countdown

6 rows where releaseDate = 1970

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

song 6

  • (I Know) I'm Losing You 1
  • Cry Me a River 1
  • Eleanor Rigby 1
  • Gimme Shelter 1
  • Oye Como Va 1
  • Up On The Roof 1

originalArtist 6

  • Julie London 1
  • The Beatles 1
  • The Drifters 1
  • The Rolling Stones 1
  • The Temptations 1
  • Tito Puente 1

artist 6

  • Aretha Franklin 1
  • Joe Cocker 1
  • Laura Nyro 1
  • Merry Clayton 1
  • Rare Earth 1
  • Santana 1

originalYear 5

  • 1966 2
  • 1955 1
  • 1962 1
  • 1964 1
  • 1969 1

releaseDate 1

  • 1970 · 6 ✖
rank ▼ artist song album releaseDate albumArt timeslice originalYear originalArtist
275 Santana Oye Como Va Abraxas 1970 2025-12-09 17:18:33 1962 Tito Puente
323 Aretha Franklin Eleanor Rigby This Girl's In Love With You 1970 2025-12-09 13:33:33 1966 The Beatles
658 Joe Cocker Cry Me a River Mad Dogs and Englishmen 1970 2025-12-06 10:49:00 1955 Julie London
661 Rare Earth (I Know) I'm Losing You Ecology 1970 2025-12-06 10:34:47 1966 The Temptations
788 Laura Nyro Up On The Roof Christmas And The Beads Of Sweat 1970 2025-12-04 15:39:42 1964 The Drifters
851 Merry Clayton Gimme Shelter Gimme Shelter 1970 2025-12-04 10:33:52 1969 The Rolling Stones

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