home / xpn_countdown

countdown

4 rows where originalYear = 2007

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

song 4

  • Don't You Evah 1
  • Skinny Love 1
  • The Story 1
  • umbrella 1

originalArtist 4

  • Bon Iver 1
  • Brandi Carlile 1
  • Rihanna 1
  • The Natural History 1

artist 4

  • Birdy 1
  • Dolly Parton 1
  • Spoon 1
  • The Baseballs 1

releaseDate 3

  • 2017 2
  • 2009 1
  • 2011 1

originalYear 1

  • 2007 · 4 ✖
rank ▼ artist song album releaseDate albumArt timeslice originalYear originalArtist
434 Dolly Parton The Story Cover Stories: Brandi Carlile Celebrates 10 Years of The Story - An Album to Benefit War Child 2017 2025-12-08 14:29:51 2007 Brandi Carlile
436 Birdy Skinny Love Birdy 2011 2025-12-08 14:21:54 2007 Bon Iver
803 Spoon Don't You Evah Ga Ga Ga Ga Ga 2017 2025-12-04 14:26:10 2007 The Natural History
862 The Baseballs umbrella Strike! 2009 2025-12-04 09:48:49 2007 Rihanna

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