countdown

3 rows where originalYear = 1970 and releaseDate = 2017

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

rank ▼	artist	song	album	releaseDate	albumArt	timeslice	originalYear	originalArtist
559	Joan Jett	Love is All Around	single	2017		2025-12-07 13:03:30	1970	Sonny Curtis
587	Aretha Franklin with the Royal Philharmonic Orchestra	Border Song	A Brand New Me	2017		2025-12-07 10:46:36	1970	Elton John
812	Grateful Dead	Me and Bobby McGee	Grateful Dead (Skull & Roses)	2017		2025-12-04 13:43:08	1970	Kris Kristofferson

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);