home / xpn_countdown

countdown

7 rows where originalArtist = "Elton John"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

releaseDate 7

  • 2002 1
  • 2004 1
  • 2012 1
  • 2013 1
  • 2017 1
  • 2018 1
  • 2019 1

artist 7

  • Aretha Franklin with the Royal Philharmonic Orchestra 1
  • Ben Folds 1
  • Florence + the Machine 1
  • Kate Bush 1
  • My Morning Jacket 1
  • Sara Bareilles 1
  • Yola 1

song 4

  • Goodbye Yellow Brick Road 2
  • Rocket Man 2
  • Tiny Dancer 2
  • Border Song 1

originalYear 3

  • 1972 4
  • 1973 2
  • 1970 1

originalArtist 1

  • Elton John · 7 ✖
rank ▼ artist song album releaseDate albumArt timeslice originalYear originalArtist
283 Florence + the Machine Tiny Dancer Revamp: The Songs of Elton John and Bernie Taupin 2018 2025-12-09 16:38:44 1972 Elton John
356 Sara Bareilles Goodbye Yellow Brick Road Brave Enough: Live At The Variety Playhouse 2013 2025-12-09 10:56:59 1973 Elton John
508 My Morning Jacket Rocket Man Chapter 1: The Sandworm Cometh 2004 2025-12-08 08:14:07 1972 Elton John
570 Yola Goodbye Yellow Brick Road Walk Through Fire (Deluxe) 2019 2025-12-07 12:12:53 1973 Elton John
587 Aretha Franklin with the Royal Philharmonic Orchestra Border Song A Brand New Me 2017 2025-12-07 10:46:36 1970 Elton John
748 Kate Bush Rocket Man The Other Sides 2012 2025-12-05 08:42:45 1972 Elton John
783 Ben Folds Tiny Dancer Ben Folds Live 2002 2025-12-04 15:58:38 1972 Elton John

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