countdown

4 rows where originalArtist = "Elton John" and originalYear = 1972

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

releaseDate 4

song 2

originalYear 1

  • 1972 · 4 ✖

originalArtist 1

  • Elton John · 4 ✖
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
508 My Morning Jacket Rocket Man Chapter 1: The Sandworm Cometh 2004 2025-12-08 08:14:07 1972 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);