countdown

2 rows where artist = "Rod Stewart" and originalYear = 1966

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

rank ▼	artist	song	album	releaseDate	albumArt	timeslice	originalYear	originalArtist
268	Rod Stewart	(I Know) I'm Losing You	Every Picture Tells A Story	1971		2025-12-09 17:57:00	1966	The Temptations
602	Rod Stewart	Reason To Believe	Every Picture Tells A Story	1971		2025-12-06 15:31:19	1966	Tim Hardin

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