home / xpn_countdown

countdown

9 rows where originalYear = 1987

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

releaseDate 9

  • 1992 1
  • 1994 1
  • 1997 1
  • 2003 1
  • 2007 1
  • 2008 1
  • 2016 1
  • 2019 1
  • 2022 1

artist 9

  • AnnenMayKantereit & Giant Rooks 1
  • David Byrne 1
  • Limp Bizkit 1
  • Luka Bloom 1
  • Pet Shop Boys 1
  • The Lumineers 1
  • The Mavericks 1
  • The War on Drugs 1
  • The Watson Twins 1

song 8

  • Just Like Heaven 2
  • All That Heaven Will Allow 1
  • Faith 1
  • I Need Love 1
  • I Wanna Dance with Somebody (Who Loves Me) 1
  • Tom's Diner 1
  • Touch Of Grey 1
  • Where The Streets Have No Name (Can't Take My Eyes Off Of You) 1

originalArtist 8

  • The Cure 2
  • Bruce Springsteen 1
  • George Michael 1
  • Grateful Dead 1
  • LL Cool J 1
  • Suzanne Vega 1
  • U2 1
  • Whitney Houston 1

originalYear 1

  • 1987 · 9 ✖
rank ▼ artist song album releaseDate albumArt timeslice originalYear originalArtist
288 Luka Bloom I Need Love The Acoustic Motorbike 1992 2025-12-09 16:14:54 1987 LL Cool J
424 The Lumineers Just Like Heaven Brightside Bonus Tracks 2022 2025-12-08 15:30:16 1987 The Cure
447 The War on Drugs Touch Of Grey Day of the Dead 2016 2025-12-08 13:22:38 1987 Grateful Dead
486 Limp Bizkit Faith Three Dollar Bill, Y'all 1997 2025-12-08 10:04:35 1987 George Michael
583 Pet Shop Boys Where The Streets Have No Name (Can't Take My Eyes Off Of You) Discography: The Complete Singles Collection 2003 2025-12-07 11:07:38 1987 U2
704 The Mavericks All That Heaven Will Allow The Definitive Collection 1994 2025-12-05 12:46:47 1987 Bruce Springsteen
769 The Watson Twins Just Like Heaven Fire Songs 2008 2025-12-04 17:08:19 1987 The Cure
829 AnnenMayKantereit & Giant Rooks Tom's Diner (single) 2019 2025-12-04 12:16:43 1987 Suzanne Vega
832 David Byrne I Wanna Dance with Somebody (Who Loves Me) Live At Carnegie hall 2007 2025-12-04 12:01:58 1987 Whitney Houston

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