countdown

2 rows where artist = "The Mamas & The Papas"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timeslice (date)

rank ▼	artist	song	album	releaseDate	albumArt	timeslice	originalYear	originalArtist
397	The Mamas & The Papas	Dream a Little Dream of Me	The Papas & The Mamas	1968		2025-12-08 17:46:57	1931	Ozzie Nelson
734	The Mamas & The Papas	Dedicated To The One I Love	16 Of Their Greatest Hits	1967		2025-12-05 09:47:33	1957	The "5" Royales

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