Created
January 1, 2024 19:29
-
-
Save nanotaboada/f83df749e9b91842668f870f6590d148 to your computer and use it in GitHub Desktop.
SQLite 3 DDL for a mid-sized collection of Albums. The rank matches Rolling Stone's list of The 500 Greatest Albums of All Time.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
BEGIN TRANSACTION; | |
DROP TABLE IF EXISTS "albums"; | |
CREATE TABLE IF NOT EXISTS "albums" ( | |
"rank" INTEGER NOT NULL, | |
"album" TEXT NOT NULL, | |
"artist" TEXT NOT NULL, | |
"label" TEXT NOT NULL, | |
"year" INTEGER NOT NULL, | |
PRIMARY KEY("rank") | |
); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (1,'Whats Going On','Marvin Gaye','Tamla/Motown',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (2,'Pet Sounds','The Beach Boys','Capitol',1966); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (3,'Blue','Joni Mitchell','Reprise',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (4,'Songs in the Key of Life','Stevie Wonder','Tamla/Motown',1976); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (5,'Abbey Road','The Beatles','Apple',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (6,'Nevermind','Nirvana','Geffen',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (7,'Rumours','Fleetwood Mac','Warner Bros.',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (8,'Purple Rain','Prince and the Revolution','Warner Bros.',1984); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (9,'Blood on the Tracks','Bob Dylan','Columbia',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (10,'The Miseducation of Lauryn Hill','Lauryn Hill','Ruffhouse/Columbia',1998); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (11,'Revolver','The Beatles','Apple',1966); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (12,'Thriller','Michael Jackson','Epic',1982); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (13,'I Never Loved a Man the Way I Love You','Aretha Franklin','Atlantic',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (14,'Exile on Main Street','The Rolling Stones','Rolling Stones Records',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (15,'It Takes a Nation of Millions to Hold Us Back','Public Enemy','Def Jam',1988); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (16,'London Calling','The Clash','CBS',1979); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (17,'My Beautiful Dark Twisted Fantasy','Kanye West','Roc-A-Fella',2010); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (18,'Highway 61 Revisited','Bob Dylan','Columbia',1965); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (19,'To Pimp a Butterfly','Kendrick Lamar','TDE',2015); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (20,'Kid A','Radiohead','Parlophone',2000); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (21,'Born to Run','Bruce Springsteen','Columbia',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (22,'Ready to Die','The Notorious B.I.G.','Bad Boy',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (23,'The Velvet Underground and Nico','The Velvet Underground','Verve',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (24,'Sgt. Pepper’s Lonely Hearts Club Band','The Beatles','Capitol',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (25,'Tapestry','Carole King','Sony',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (26,'Horses','Patti Smith','Arista',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (27,'Enter the Wu-Tang(36 Chambers)','Wu-Tang Clan','Loud',1993); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (28,'Voodoo','D’Angelo','EMI',2000); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (29,'White Album','The Beatles','Apple',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (30,'Are You Experienced','Jimi Hendrix','Track',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (31,'Kind of Blue','Miles Davis','Columbia',1959); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (32,'Lemonade','Beyoncé','Parkwood/Columbia',2016); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (33,'Back to Black','Amy Winehouse','Island',2006); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (34,'Innervisions','Stevie Wonder','Tamla/Motown',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (35,'Rubber Soul','The Beatles','Parlophone',1965); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (36,'Off the Wall','Michael Jackson','Epic',1979); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (37,'The Chronic','Dr. Dre','Deathrow',1992); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (38,'Blonde on Blonde','Bob Dylan','Columbia',1966); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (39,'Remain in Light','Talking Heads','Sire',1980); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (40,'The Rise and Fall of Ziggy Stardust and the Spiders From Mars','David Bowie','RCA',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (41,'Let It Bleed','The Rolling Stones','ABKCO',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (42,'OK Computer','Radiohead','Capitol',1997); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (43,'The Low End Theory','A Tribe Called Quest','Jive',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (44,'Illmatic','Nas','Columbia',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (45,'Sign O the Times','Prince','Paisley Park/Warner Bros.',1987); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (46,'Graceland','Paul Simon','Columbia',1986); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (47,'Ramones','Ramones','Sire',1976); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (48,'Legend','Bob Marley and the Wailers','Island',1984); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (49,'Aquemini','OutKast','LaFace',1998); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (50,'The Blueprint','Jay-Z','Roc-A-Fella',2001); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (51,'The Great Twenty-Eight','Chuck Berry','Chess',1982); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (52,'Station to Station','David Bowie','RCA',1976); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (53,'Electric Ladyland','Jimi Hendrix','Reprise',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (54,'Star Time','James Brown','Polydor',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (55,'The Dark Side of the Moon','Pink Floyd','EMI',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (56,'Exile in Guyville','Liz Phair','Matador',1993); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (57,'The Band','The Band','Capitol',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (58,'Led Zeppelin IV','Led Zeppelin','Atlantic',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (59,'Talking Book','Stevie Wonder','Tamla/Motown',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (60,'Astral Weeks','Van Morrison','Warner Bros.',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (61,'Paid in Full','Eric B. and Rakim','4th & B’way',1987); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (62,'Appetite for Destruction','Guns N’ Roses','Geffen',1987); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (63,'Aja','Steely Dan','ABC',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (64,'Stankonia','OutKast','LaFace',2000); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (65,'Live at the Apollo','James Brown','King',1963); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (66,'A Love Supreme','John Coltrane','Impulse!',1965); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (67,'Reasonable Doubt','Jay-Z','Roc-A-Fella',1996); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (68,'Hounds of Love','Kate Bush','EMI',1985); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (69,'Jagged Little Pill','Alanis Morissette','Maverick',1995); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (70,'Straight Outta Compton','N.W.A','Ruthless',1988); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (71,'Exodus','Bob Marley and the Wailers','Island',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (72,'Harvest','Neil Young','Reprise',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (73,'Loveless','My Bloody Valentine','Sire',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (74,'The College Dropout','Kanye West','Roc-A-Fella',2004); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (75,'Lady Soul','Aretha Franklin','Atlantic',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (76,'Superfly','Curtis Mayfield','Curtom',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (77,'Whos Next','The Who','Decca',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (78,'The Sun Sessions','Elvis Presley','RCA',1976); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (79,'Blond','Frank Ocean','Boys Don’t Cry',2016); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (80,'Never Mind the Bollocks Here’s the Sex Pistols','The Sex Pistols','Warner Bros.',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (81,'Beyoncé','Beyoncé','Parkwood/Columbia',2013); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (82,'There’s a Riot Goin’ On','Sly and the Family Stone','Epic',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (83,'Dusty in Memphis','Dusty Springfield','Atlantic',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (84,'Back in Black','AC/DC','Atlantic',1980); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (85,'Plastic Ono Band','John Lennon','Apple',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (86,'The Doors','The Doors','Elektra',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (87,'Bitches Brew','Miles Davis','Columbia',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (88,'Hunky Dory','David Bowie','RCA',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (89,'Baduizm','Erykah Badu','Kedar',1997); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (90,'After the Gold Rush','Neil Young','Reprise',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (91,'Darkness on the Edge of Town','Bruce Springsteen','Columbia',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (92,'Axis: Bold as Love','The Jimi Hendrix Experience','Track',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (93,'Supa Dupa Fly','Missy “Misdemeanor” Elliott','Goldmind',1997); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (94,'Fun House','The Stooges','Elektra',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (95,'Take Care','Drake','Cash Money',2011); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (96,'Automatic for the People','R.E.M.','Warner Bros.',1992); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (97,'Master of Puppets','Metallica','Elektra',1986); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (98,'Car Wheels on a Gravel Road','Lucinda Williams','Mercury',1998); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (99,'Red','Taylor Swift','Big Machine',2012); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (100,'Music From Big Pink','The Band','Capitol',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (101,'Led Zeppelin','Led Zeppelin','Atlantic',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (102,'The Clash','The Clash','CBS',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (103,'Three Feet High And Rising','De La Soul','Tommy Boy',1989); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (104,'Sticky Fingers','The Rolling Stones','Rolling Stones',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (105,'At Fillmore East','The Allman Brothers','Capricorn',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (106,'Live Through This','Hole','Geffen',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (107,'Marquee Moon','Television','Elektra',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (108,'When the Pawn ...','Fiona Apple','Epic',1999); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (109,'Transformer','Lou Reed','RCA',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (110,'Court and Spark','Joni Mitchell','Asylum',1974); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (111,'Control','Janet Jackson','A&M',1986); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (112,'Goodbye Yellow Brick Road','Elton John','MCA',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (113,'The Queen Is Dead','The Smiths','Sire',1986); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (114,'Is This It','The Strokes','RCA',2001); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (115,'good kid','Kendrick Lamar','TDE',2012); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (116,'Disintegration','The Cure','Fiction',1989); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (117,'Late Registration','Kanye West','Roc-A-Fella',2005); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (118,'Hotel California','The Eagles','Asylum',1976); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (119,'Stand!','Sly and the Family Stone','Epic',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (120,'Moondance','Van Morrison','Warner Bros.',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (121,'This Year’s Model','Elvis Costello','Columbia',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (122,'The Downward Spiral','Nine Inch Nails','Nothing/Interscope',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (123,'Led Zeppelin II','Led Zeppelin','Atlantic',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (124,'Achtung Baby','U2','Island',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (125,'Pauls Boutique','Beastie Boys','Capitol',1989); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (126,'My Life','Mary J. Blige','Uptown',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (127,'Modern Sounds in Country and Western Music','Ray Charles','ABC-Paramount',1962); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (128,'A Night at the Opera','Queen','Elektra',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (129,'The Wall','Pink Floyd','Columbia',1979); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (130,'1999','Prince','Warner Bros.',1982); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (131,'Dummy','Portishead','Go! Beat',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (132,'40 Greatest Hits','Hank Williams','Polydor',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (133,'Hejira','Joni Mitchell','Asylum',1976); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (134,'The Score','Fugees','Columbia',1996); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (135,'The Joshua Tree','U2','Island',1987); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (136,'Maggot Brain','Funkadelic','Westbound',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (137,'21','Adele','Columbia',2011); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (138,'The Immaculate Collection','Madonna','Sire',1990); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (139,'Paranoid','Black Sabbath','Vertigo',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (140,'Catch a Fire','Bob Marley and the Wailers','Island',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (141,'Doolittle','Pixies','4AD/Elektra',1989); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (142,'Born in the U.S.A.','Bruce Springsteen','Columbia',1984); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (143,'The Velvet Underground','The Velvet Underground','MGM',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (144,'Physical Graffiti','Led Zeppelin','Swan Song',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (145,'The Marshall Mathers LP','Eminem','Interscope',2000); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (146,'Parallel Lines','Blondie','Chrysalis',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (147,'Grace','Jeff Buckley','Columbia',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (148,'Channel Orange','Frank Ocean','Def Jam',2012); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (149,'John Prine','John Prine','Atlantic',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (150,'Nebraska','Bruce Springsteen','Columbia',1982); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (151,'Faith','George Michael','Columbia',1987); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (152,'Pretenders','The Pretenders','Sire',1980); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (153,'Rid of Me','PJ Harvey','Island',1993); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (154,'Amazing Grace','Aretha Franklin','Atlantic',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (155,'The Black Album','Jay-Z','Roc-A-Fella',2003); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (156,'Let It Be','The Replacements','Twin/Tone',1984); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (157,'(Whats the Story) Morning Glory?','Oasis','Epic',1995); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (158,'Mamas Gun','Erykah Badu','Motown',2000); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (159,'Synchronicity','The Police','A&M',1983); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (160,'Ten','Pearl Jam','Epic',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (161,'Stills & Nash','Crosby','Atlantic',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (162,'Different Class','Pulp','Island',1995); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (163,'Saturday Night Fever','Various Artists','RSO',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (164,'At Folsom Prison','Johnny Cash','Columbia',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (165,'Murmur','R.E.M.','I.R.S.',1983); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (166,'20 Golden Greats','Buddy Holly','MCA',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (167,'Violator','Depeche Mode','Sire',1990); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (168,'Can’t Buy a Thrill','Steely Dan','ABC',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (169,'The Stranger','Billy Joel','Columbia',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (170,'Disraeli Gears','Cream','Reaction',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (171,'Daydream Nation','Sonic Youth','Enigma',1988); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (172,'Bridge Over Troubled Water','Simon and Garfunkel','Columbia',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (173,'In Utero','Nirvana','Geffen',1993); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (174,'The Harder They Come: Original Soundtrack','Jimmy Cliff and Various Artists','Mango',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (175,'DAMN.','Kendrick Lamar','TDE',2017); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (176,'Fear of a Black Planet','Public Enemy','Def Jam/Columbia',1990); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (177,'Every Picture Tells a Story','Rod Stewart','Mercury',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (178,'Otis Blue','Otis Redding','Volt',1965); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (179,'Life After Death','Notorious B.I.G.','Bad Boy',1997); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (180,'Forever Changes','Love','Elektra',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (181,'Bringing It All Back Home','Bob Dylan','Columbia',1965); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (182,'Sweet Baby James','James Taylor','Warner Bros.',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (183,'Brown Sugar','D''Angelo','EMI',1995); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (184,'She’s So Unusual','Cyndi Lauper','Portrait',1983); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (185,'Beggars Banquet','The Rolling Stones','Decca',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (186,'Blood Sugar Sex Magik','Red Hot Chili Peppers','Warner Bros.',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (187,'AmeriKKKa’s Most Wanted','Ice Cube','Priority',1990); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (188,'Electric Warrior','T. Rex','Reprise',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (189,'Dig Me Out','Sleater-Kinney','Kill Rock Stars',1997); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (190,'Tommy','The Who','Decca',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (191,'At Last!','Etta James','Argo',1961); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (192,'Licensed to Ill','Beastie Boys','Def Jam/Columbia',1986); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (193,'Willy and the Poor Boys','Creedence Clearwater Revival','Fantasy',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (194,'Bad','Michael Jackson','Epic',1987); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (195,'Songs of Leonard Cohen','Leonard Cohen','Columbia',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (196,'Body Talk','Robyn','Konichiwa',2010); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (197,'Meet the Beatles!','The Beatles','Capitol',1964); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (198,'The B-52s','The B-52''s','Warner Bros.',1979); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (199,'Slanted and Enchanted','Pavement','Matador',1993); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (200,'Diamond Life','Sade','Epic',1984); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (201,'Midnight Marauders','A Tribe Called Quest','Jive',1993); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (202,'Homogenic','Björk','Elektra',1997); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (203,'Pink Moon','Nick Drake','Island',1979); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (204,'Graduation','Kanye West','Roc-A-Fella',2007); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (205,'Tea for the Tillerman','Cat Stevens','A&M',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (206,'Low','David Bowie','RCA',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (207,'Eagles','Eagles','Asylum',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (208,'Tha Carter III','Lil Wayne','Cash Money/Universal Motown',2008); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (209,'Raising Hell','Run-DMC','Profile',1986); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (210,'The Birth of Soul','Ray Charles','Atlantic',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (211,'Unknown Pleasures','Joy Divison','Factory',1980); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (212,'Wild Is the Wind','Nina Simone','Philips',1966); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (213,'The Idler Wheel','Fiona Apple','Epic',2012); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (214,'Wildflowers','Tom Petty','Warner Bros.',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (215,'American Beauty','Grateful Dead','Warner Bros.',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (216,'Either/Or','Elliott Smith','Kill Rock Stars',1997); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (217,'Definitely Maybe','Oasis','Epic',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (218,'CrazySexyCool','TLC','LaFace',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (219,'Only Built 4 Cuban Linx','Raekwon','Loud/RCA',1995); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (220,'Stills','Crosby','Epic',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (221,'Rage Against the Machine','Rage Against the Machine','Epic',1992); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (222,'Ray of Light','Madonna','Maverick',1998); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (223,'Imagine','John Lennon','Apple',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (224,'Fly','Dixie Chicks','Monument',1999); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (225,'Yankee Hotel Foxtrot','Wilco','Nonesuch',2001); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (226,'Layla and Other Assorted Love Songs','Derek and the Dominos','Atco',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (227,'Here’s Little Richard','Little Richard','Specialty',1957); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (228,'De La Soul Is Dead','De La Soul','Tommy Boy',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (229,'The Ultimate Collection','Patsy Cline','Universal',2000); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (230,'Anti','Rihanna','Roc Nation',2016); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (231,'Damn the Torpedoes','Tom Petty and the Heartbreakers','Backstreet',1979); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (232,'Giant Steps','John Coltrane','Atlantic',1960); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (233,'Little Earthquakes','Tori Amos','Atlantic',1992); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (234,'Master of Reality','Black Sabbath','Veritgo',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (235,'Metallica (The Black Album)','Metallica','Elektra',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (236,'Discovery','Daft Punk','Virgin',2001); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (237,'Red Headed Stranger','Willie Nelson','Columbia',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (238,'Trans Europe Express','Kraftwerk','Kling Klang',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (239,'Criminal Minded','Boogie Down Productions','B-Boy',1987); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (240,'Live at the Harlem Square Club','Sam Cooke','RCA',1985); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (241,'Blue Lines','Massive Attack','Wildbunch/Virgin',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (242,'Loaded','The Velvet Underground','Cotillion',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (243,'Odessey and Oracle','The Zombies','Date',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (244,'808s & Heartbreak','Kanye West','Roc-A-Fella',2008); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (245,'Heaven or Las Vegas','Cocteau Twins','4AD',1990); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (246,'Mama Said Knock You Out','LL Cool J','Def Jam/Columbia',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (247,'Love Deluxe','Sade','Epic',1992); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (248,'American Idiot','Green Day','Reprise',2004); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (249,'Whitney Houston','Whitney Houston','Arista',1985); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (250,'Singles Going Steady','Buzzcocks','I.R.S.',1979); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (251,'Honky Château','Elton John','Uni',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (252,'Q: Are We Not Men? A: We Are Devo!','Devo','Warner Bros.',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (253,'The Piper at the Gates of Dawn','Pink Floyd','EMI/Columbia',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (254,'Head Hunters','Herbie Hancock','Columbia',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (255,'The Freewheelin Bob Dylan','Bob Dylan','Columbia',1963); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (256,'Tracy Chapman','Tracy Chapman','Elektra',1988); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (257,'Coat of Many Colors','Dolly Parton','RCA',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (258,'The Hissing of Summer Lawns','Joni Mitchell','Asylum',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (259,'Pearl','Janis Joplin','Columbia',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (260,'Cut','The Slits','Antilles',1979); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (261,'Check Your Head','Beastie Boys','Capitol',1992); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (262,'Power','New Order','Factory',1983); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (263,'Hard Days Night','The Beatles','United Artists',1964); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (264,'Wish You Were Here','Pink Floyd','Columbia',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (265,'Wowee Zowee','Pavement','Matador',1995); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (266,'Help!','The Beatles','Capitol',1965); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (267,'Double Nickels on the Dime','Minutemen','SST',1984); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (268,'Sail Away','Randy Newman','Reprise',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (269,'Yeezus','Kanye West','Roc-A-Fella',2013); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (270,'Golden Hour','Kacey Musgraves','MCA Nashville',2018); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (271,'What’s the 411?','Mary J. Blige','Uptown/MCA',1992); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (272,'White Light/White Heat','The Velvet Underground','Verve',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (273,'Entertainment!','Gang of Four','Warner Bros.',1979); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (274,'Sweetheart of the Rodeo','The Byrds','Columbia',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (275,'Curtis','Curtis Mayfield','Curtom',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (276,'The Bends','Radiohead','Capitol',1995); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (277,'The Diary of Alicia Keys','Alicia Keys','J Records',2003); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (278,'Houses of the Holy','Led Zeppelin','Atlantic',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (279,'MTV Unplugged in New York','Nirvana','Geffen',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (280,'Get Rich or Die Tryin','50 Cent','Interscope',2002); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (281,'Nilsson Schmilsson','Harry Nilsson','RCA',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (282,'In the Wee Small Hours','Frank Sinatra','Capitol',1955); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (283,'Bad Girls','Donna Summer','Casablanca',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (284,'Down Every Road 1962-1994','Merle Haggard','Capitol',1996); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (285,'Third/Sister Lovers','Big Star','PVC',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (286,'Californication','Red Hot Chili Peppers','Warner Bros.',1999); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (287,'Mr. Tambourine Man','The Byrds','Columbia',1965); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (288,'The Modern Lovers','The Modern Lovers','Beserkley',1976); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (289,'Post','Björk','Elektra',1995); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (290,'Speakerboxxx/The Love Below','OutKast','LaFace',2003); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (291,'The Writing’s on the Wall','Destiny''s Child','Columbia',1999); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (292,'Van Halen','Van Halen','Warner Bros.',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (293,'Last Splash','The Breeders','Elektra',1993); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (294,'Weezer (The Blue Album)','Weezer','Geffen',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (295,'Random Access Memories','Daft Punk','Columbia',2013); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (296,'Rust Never Sleeps','Neil Young','Reprise',1979); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (297,'So','Peter Gabriel','Geffen',1986); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (298,'Full Moon Fever','Tom Petty','MCA',1989); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (299,'Live at the Regal','B.B. King','ABC-Paramount',1965); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (300,'Come on Over','Shania Twain','Mercury',1997); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (301,'New York Dolls','New York Dolls','Mercury',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (302,'Tonights the Night','Neil Young','Reprise',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (303,'The Definitive Collection','ABBA','Universal',2001); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (304,'Just As I Am','Bill Withers','Sussex',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (305,'Alive!','Kiss','Casablanca',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (306,'Im Still in Love With You','Al Green','Hi',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (307,'Portrait of a Legend','Sam Cooke','ABKCO',2003); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (308,'Here Come the Warm Jets','Brian Eno','Island',1974); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (309,'Closer','Joy Divison','Factory',1980); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (310,'Pink Flag','Wire','Harvest',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (311,'On the Beach','Neil Young','Reprise',1974); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (312,'A Seat at the Table','Solange','Saint/Columbia',2016); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (313,'Stories From the City','PJ Harvey','Island',2000); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (314,'One in a Million','Aaliyah','Blackground/Atlantic',1996); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (315,'El Mal Querer','Rosalía','Sony',2018); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (316,'The Who Sell Out','The Who','Decca',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (317,'Lady in Satin','Billie Holiday','Columbia',1958); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (318,'The Velvet Rope','Janet Jackson','Virgin',1997); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (319,'The Stone Roses','The Stone Roses','Silvertone',1989); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (320,'Los Angeles','X','Slash',1980); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (321,'Norman Fucking Rockwell!','Lana Del Rey','Polydor/Interscope',2019); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (322,'From Elvis in Memphis','Elvis Presley','RCA',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (323,'Sandinista!','The Clash','Epic',1980); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (324,'A Rush of Blood to the Head','Coldplay','Capitol',2002); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (325,'All Killer No Filler!','Jerry Lee Lewis','Rhino',1993); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (326,'Dirty Mind','Prince','Warner Bros.',1980); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (327,'Live at Leeds','The Who','Decca',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (328,'Modern Vampires of the City','Vampire Weekend','XL',2013); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (329,'Endtroducing.....','DJ Shadow','Mo’ Wax',1996); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (330,'Aftermath','The Rolling Stones','London',1966); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (331,'Like a Prayer','Madonna','Sire',1989); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (332,'Elvis Presley','Elvis Presley','RCA',1956); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (333,'Still Bill','Bill Withers','Sussex',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (334,'Abraxas','Santana','Columbia',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (335,'The Basement Tapes','Bob Dylan and the Band','Columbia',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (336,'Avalon','Roxy Music','E.G./Warner Bros.',1982); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (337,'John Wesley Harding','Bob Dylan','Columbia',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (338,'Another Green World','Brian Eno','Island',19755); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (339,'Rhythm Nation 1814','Janet Jackson','A&M',1989); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (340,'Doggystyle','Snoop Doggy Dogg','Death Row/Interscope',1993); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (341,'Siamese Dream','The Smashing Pumpkins','Virgin',1993); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (342,'Let It Be','The Beatles','Apple',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (343,'Greatest Hits','Sly and the Family Stone','Epic',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (344,'Funky Kingston','Toots and the Maytals','Island',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (345,'The Wild','Bruce Springsteen','Columbia',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (346,'AM','Arctic Monkeys','Domino',2013); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (347,'Liquid Swords','GZA','Geffen',1995); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (348,'Time (The Revelator)','Gillian Welch','Acony',2001); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (349,'Kick Out the Jams','MC5','Elektra',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (350,'Music of My Mind','Stevie Wonder','Tamla/Motown',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (351,'For Your Pleasure','Roxy Music','Warner Bros.',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (352,'The Slim Shady LP','Eminem','Interscope',1999); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (353,'The Cars','The Cars','Elektra',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (354,'Germfree Adolescents','X-Ray Spex','EMI',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (355,'Black Sabbath','Black Sabbath','Warner Bros.',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (356,'Gris-Gris','Dr. John','Atco',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (357,'Rain Dogs','Tom Waits','Island',1985); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (358,'Goo','Sonic Youth','Geffen',1990); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (359,'Radio City','Big Star','Ardent',1974); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (360,'One Nation Under a Groove','Funkadelic','Warner Bros.',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (361,'The Black Parade','My Chemical Romance','Reprise',2006); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (362,'Never Too Much','Luther Vandross','Epic',1981); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (363,'The Mothership Connection','Parliament','Casablanca',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (364,'More Songs About Buildings and Food','Talking Heads','Sire',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (365,'Madvillainy','Madvillain','Stones Throw',2004); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (366,'Rocks','Aerosmith','Columbia',1976); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (367,'If Youre Reading This Its Too Late','Drake','Cash Money',2015); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (368,'All Things Must Pass','George Harrison','Apple',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (369,'The Infamous','Mobb Deep','Loud',1995); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (370,'Tha Carter II','Lil Wayne','Cash Money/Universal',2005); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (371,'Anthology','The Temptations','Tamla/Motown',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (372,'Cheap Thrills','Big Brother and the Holding Company','Columbia',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (373,'Hot Buttered Soul','Isaac Hayes','Enterprise',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (374,'King of the Delta Blues Singers','Robert Johnson','Columbia',1961); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (375,'Dookie','Green Day','Reprise',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (376,'In the Aeroplane Over the Sea','Neutral Milk Hotel','Merge',1998); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (377,'Fever to Tell','Yeah Yeah Yeahs','Interscope',2003); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (378,'Run-D.M.C.','Run-DMC','Profile',1983); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (379,'Moving Pictures','Rush','Anthem',1981); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (380,'Mingus Ah Um','Charles Mingus','Columbia',1959); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (381,'(Pronounced Lĕh-nérd Skin-nérd)','Lynyrd Skynyrd','MCA',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (382,'Currents','Tame Impala','Interscope',2015); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (383,'Mezzanine','Massive Attack','Circa/Virgin',1998); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (384,'The Kinks Are the Village Green Preservation Society','The Kinks','Reprise',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (385,'Rocket to Russia','Ramones','Sire',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (386,'Donuts','J Dilla','Stones Throw',2006); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (387,'In Rainbows','Radiohead','XL',2007); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (388,'Young','Aretha Franklin','Atlantic',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (389,'The Emancipation of Mimi','Mariah Carey','Island',2005); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (390,'Surfer Rosa','Pixies','4AD',1988); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (391,'Kaleidoscope','Kelis','Virgin',1999); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (392,'Proud Mary: The Best of Ike and Tina Turner','Ike and Tina Turner','EMI',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (393,'1989','Taylor Swift','Big Machine',2014); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (394,'Diana','Diana Ross','Motown',1980); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (395,'Black Messiah','D’Angelo and the Vanguard','RCA',2014); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (396,'Something/Anything?','Todd Rundgren','Bearsville',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (397,'When We All Fall Asleep','Billie Eilish','Interscope',2019); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (398,'The Raincoats','The Raincoats','Rough Trade',1979); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (399,'Smile','Brian Wilson','Nonesuch',2004); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (400,'Beauty and the Beat','The Go-Go’s','I.R.S.',1981); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (401,'Blondie','Blondie','Private Stock',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (402,'Expensive Shit','Fela Kuti and Africa 70','Sounds Workshop',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (403,'Supreme Clientele','Ghostface Killah','Epic',2000); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (404,'Rapture','Anita Baker','Elektra',1986); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (405,'Nuggets: Original Artyfacts from the First Psychedelic Era','Various','Elektra',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (406,'69 Love Songs','Magnetic Fields','Merge',1999); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (407,'Everybody Knows This Is Nowhere','Neil Young','Reprise',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (408,'Ace of Spades','Motörhead','Bronze',1980); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (409,'Workingman’s Dead','Grateful Dead','Warner Bros.',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (410,'Wild Honey','The Beach Boys','Capitol',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (411,'Love and Theft','Bob Dylan','Columbia',2001); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (412,'Going to a Go Go','Smokey Robinson and the Miracles','Tamla/Motown',1965); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (413,'Cosmos Factory','Creedence Clearwater Revival','Fantasy',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (414,'Risqué','Chic','Atlantic',1979); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (415,'Looka Py Py','The Meters','Josie',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (416,'Things Fall Apart','The Roots','MCA',1999); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (417,'The Shape of Jazz to Come','Ornette Coleman','Atlantic',1959); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (418,'Brothers in Arms','Dire Straits','Warner Bros.',1985); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (419,'Chief','Eric Church','EMI Nashville',2011); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (420,'Wind and Fire','Earth','Columbia',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (421,'Arular','M.I.A.','Interscope',2005); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (422,'Lets Get It On','Marvin Gaye','Tamla/Motown',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (423,'I Can Hear the Heart Beating As One','Yo La Tengo','Matador',1997); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (424,'Odelay','Beck','Geffen',1996); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (425,'Paul Simon','Paul Simon','Columbia',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (426,'Lucinda Williams','Lucinda Williams','Rough Trade',1988); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (427,'Call Me','Al Green','Hi',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (428,'New Day Rising','Hüsker Dü','SST',1985); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (429,'Reach Out','The Four Tops','Tamla/Motown',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (430,'My Aim Is True','Elvis Costello','Columbia',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (431,'How Will the Wolf Survive?','Los Lobos','Slash/Warner Bros.',1984); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (432,'Confessions','Usher','Arista',2004); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (433,'Sound of Silver','LCD Soundsystem','DFA/Capitol',2007); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (434,'Crooked Rain','Pavement','Matador',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (435,'Actually','Pet Shop Boys','EMI Manhattan',1987); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (436,'All Eyez on Me','2Pac','Death Row',1996); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (437,'Screamadelica','Primal Scream','Sire',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (438,'Parklife','Blur','Food',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (439,'Sex Machine','James Brown','King',1970); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (440,'Coal Miners Daughter','Loretta Lynn','Decca',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (441,'Blackout','Britney Spears','Jive',2007); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (442,'Beauty Behind the Madness','The Weeknd','XO',2015); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (443,'Scary Monsters','David Bowie','RCA',1980); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (444,'Extraordinary Machine','Fiona Apple','Epic',2005); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (445,'Close to the Edge','Yes','Atlantic',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (446,'Journey in Satchidanada','Alice Coltrane','Impulse!',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (447,'X 100pre','Bad Bunny','Rimas',2018); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (448,'Dictionary of Soul','Otis Redding','Volt',1966); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (449,'Elephant','The White Stripes','V2/XL/Third Man',2003); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (450,'Ram','Paul and Linda McCartney','Apple',1971); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (451,'First Take','Roberta Flack','Atlantic',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (452,'Anthology','Diana Ross and the Supremes','Tamla/Motown',1974); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (453,'Pretty Hate Machine','Nine Inch Nails','TVT',1989); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (454,'Ege Bamyasi','Can','United Artists',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (455,'Bo Diddley/Go Bo Diddley','Bo Diddley','Chess',1958); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (456,'Greatest Hits','Al Green','Hi/EMI',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (457,'I Do Not Want What I Haven’t Got','Sinéad O’Connor','Ensign/Chrysalis',1990); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (458,'Southeastern','Jason Isbell','Southeastern',2013); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (459,'Man on the Moon: The End of the Day','Kid Cudi','Dream On',2009); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (460,'Melodrama','Lorde','Universal',2017); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (461,'For Emma','Bon Iver','Jagjaguwar',2008); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (462,'The Gilded Palace of Sin','The Flying Burrito Brothers','A&M',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (463,'Eli & the 13th Confession','Laura Nyro','Columbia',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (464,'3 + 3','The Isley Brothers','T-Neck',1973); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (465,'The Best of the Classic Years','King Sunny Adé','Shanachie',2003); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (466,'The Beach Boys Today!','The Beach Boys','Capitol',1965); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (467,'BLACKsummers’night','Maxwell','Columbia',2009); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (468,'Some Girls','The Rolling Stones','Rolling Stones',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (469,'Clandestino','Manu Chao','Virgin',1998); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (470,'400 Degreez','Juvenile','Cash Money',1998); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (471,'Surrealistic Pillow','Jefferson Airplane','RCA',1967); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (472,'Ctrl','SZA','RCA',2017); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (473,'Barrio Fino','Daddy Yankee','V.I. Music',2004); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (474,'#1 Record','Big Star','Ardent',1972); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (475,'Sheryl Crow','Sheryl Crow','A&M',1996); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (476,'Kimono My House','Sparks','Island',1974); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (477,'Moanin in the Moonlight','Howlin’ Wolf','Chess',1959); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (478,'Something Else by the Kinks','The Kinks','Pye',1968); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (479,'Amor Prohibido','Selena','EMA Latin',1994); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (480,'The Weight of These Wings','Miranda Lambert','eRCA Nashville',2016); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (481,'If You’re Feeling Sinister','Belle and Sebastian','Jeepster',1996); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (482,'Bizarre Ride II the Pharcyde','The Pharcyde','Delicious Vinyl',1992); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (483,'The Anthology','Muddy Waters','MCA',2001); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (484,'Born This Way','Lady Gaga','Interscope',2011); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (485,'I Want to See the Bright Lights Tonight','Richard and Linda Thompson','Island',1974); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (486,'Continuum','John Mayer','Columbia',2006); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (487,'Damaged','Black Flag','SST',1981); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (488,'The Stooges','The Stooges','Elektra',1969); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (489,'Back to Mono (1958-1969)','Phil Spector and Various Artists','ABKCO',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (490,'Heart Like a Wheel','Linda Ronstadt','Capitol',1975); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (491,'Fine Line','Harry Styles','Columbia',2019); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (492,'Nick of Time','Bonnie Raitt','Capitol',1989); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (493,'Here','Marvin Gaye','Tamla/Motown',1978); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (494,'Presenting the Fabulous Ronettes','The Ronettes','Philles',1964); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (495,'II','Boyz II Men','Motown',1991); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (496,'Dónde Están los Ladrones','Shakira','Columbia',1998); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (497,'The Indestructible Beat of Soweto','Various Artists','Earthworks',1985); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (498,'Suicide','Suicide','Red Star',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (499,'Chaka Khan','Rufus','ABC',1977); | |
INSERT INTO "albums" ("rank","album","artist","label","year") VALUES (500,'Funeral','Arcade Fire','Merge',2004); | |
COMMIT; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
All trademarks, registered trademarks, service marks, product names, company names or logos are property of their respective owners and are used for educational purposes only.