xpn_countdown: countdown: 14 rows where originalYear = 1988

14 rows where originalYear = 1988

descending

rank ▼	artist	song	album	releaseDate	timeslice	originalYear	originalArtist
334	Tom Petty & the Heartbreakers	Changed The Locks	She's The One (soundtrack)	1996	2025-12-09 12:37:35	1988	Lucinda Williams
402	Concrete Blonde	Everybody Knows	Pump Up The Volume Soundtrack	1992	2025-12-08 17:21:29	1988	Leonard Cohen
411	Johnny Cash	The Mercy Seat	American III: Solitary Man	2000	2025-12-08 16:37:00	1988	Nick Cave
414	Maxwell	This Woman's Work	MTV Unplugged	1997	2025-12-08 16:19:46	1988	Kate Bush
460	Guster	(Nothing But) Flowers	Bonnaroo Music Festival 2004	2024	2025-12-08 12:08:15	1988	Talking Heads
552	Thom Yorke	All For The Best	Ciao My Shining Star - The Songs Of Mark Mulcahy	2017	2025-12-07 13:39:41	1988	Miracle Legion
619	Alison Krauss & Union Station	When You Say Nothing At All	Keith Whitley: A Tribute Album	1995	2025-12-06 14:06:24	1988	Keith Whitley
664	Jenny Lewis With The Watson Twins	Handle With Care	Rabbit Fur Coat	2006	2025-12-06 10:23:10	1988	Traveling Wilburys
677	Black Pumas	Fast Car	single	2020	2025-12-05 15:23:06	1988	Tracy Chapman
686	Sixpence None The Richer	There She Goes	Sixpence None The Richer	1997	2025-12-05 14:35:45	1988	The La's
739	David Bowie	Cactus	Heathen	2002	2025-12-05 09:23:44	1988	Pixies
775	Tina Turner	The Best	Foreign Affair	1989	2025-12-04 16:32:58	1988	Bonnie Tyler
809	Trampled by Turtles	Where Is My Mind?	(single)	2011	2025-12-04 13:58:05	1988	The Pixies
840	Nirvana	Molly's Lips	Incesticide	1992	2025-12-04 11:25:53	1988	The Vasolines

Advanced export

JSON shape: default, array, newline-delimited, object

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