home / xpn_countdown

countdown

8 rows where releaseDate = 1985

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

song 8

  • Dancing In The Street 1
  • Dirty Old Town 1
  • Get It On (Bang A Gong) 1
  • I Got You Babe 1
  • Love Is All Around 1
  • Running Up That Hill (A Deal with God) 1
  • Spanish Harlem 1
  • Time After Time 1

originalYear 8

  • 1952 1
  • 1960 1
  • 1964 1
  • 1965 1
  • 1970 1
  • 1971 1
  • 1984 1
  • 1985 1

originalArtist 8

  • Ben E. King 1
  • Cyndi Lauper 1
  • Ewan Macoll 1
  • Kate Bush 1
  • Martha Reeves & The Vandellas 1
  • Sonny Curtis 1
  • Sonny and Cher 1
  • T Rex 1

artist 8

  • Aretha Franklin 1
  • David Bowie & Mick Jagger 1
  • Husker Du 1
  • Meg Myers 1
  • Miles Davis 1
  • The Pogues 1
  • The Power Station 1
  • UB40 & Chrissie Hynde 1

releaseDate 1

  • 1985 · 8 ✖
rank ▼ artist song album releaseDate albumArt timeslice originalYear originalArtist
383 The Pogues Dirty Old Town Rum Sodomy & The Lash 1985 2025-12-09 08:56:46 1952 Ewan Macoll
520 Husker Du Love Is All Around (single) 1985 2025-12-07 16:23:31 1970 Sonny Curtis
562 David Bowie & Mick Jagger Dancing In The Street Bowie: The Singles 1985 2025-12-07 12:50:09 1964 Martha Reeves & The Vandellas
580 UB40 & Chrissie Hynde I Got You Babe Baggariddim 1985 2025-12-07 11:20:18 1965 Sonny and Cher
764 Aretha Franklin Spanish Harlem Aretha's Greatest Hits 1985 2025-12-04 17:28:12 1960 Ben E. King
837 The Power Station Get It On (Bang A Gong) The Power Station 1985 2025-12-04 11:39:42 1971 T Rex
841 Miles Davis Time After Time You're Under Arrest 1985 2025-12-04 11:21:05 1984 Cyndi Lauper
842 Meg Myers Running Up That Hill (A Deal with God) single 1985 2025-12-04 11:17:27 1985 Kate Bush

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