Skip to content

Instantly share code, notes, and snippets.

@turbodog

turbodog/Rolling Stone Former 500.csv

Last active October 30, 2024 15:44
Show Gist options
  • Save turbodog/5886df650acd3b6c4f4cbbe64fc013c6 to your computer and use it in GitHub Desktop.
Save turbodog/5886df650acd3b6c4f4cbbe64fc013c6 to your computer and use it in GitHub Desktop.
Download ZIP
Songs that once were on the Rolling Stone 500 Best Albums but are no longer on the current list. Source data from https://liveduq-my.sharepoint.com/:x:/g/personal/longr3_duq_edu/EWRasWlT_81ArS8f_AEa8AMBxC28wGf8s25zFefsVcceUw?rtime=T2JwRBL23Eg
Raw
Rolling Stone Former 500.csv
Artist Album 2003 Rank 2012 Rank Release Year
The Beatles Please Please Me 39 39 1963
Captain Beefheart & His Magic Band Trout Mask Replica 58 60 1969
Creedence Clearwater Revival Green River 95 1969
Cream Fresh Cream 101 102 1966
Rolling Stones Out of Our Heads 114 116 1965
Moby Grape Moby Grape 121 124 1967
The Byrds Younger Than Yesterday 124 127 1967
The Stooges Raw Power 125 128 1973
The Mamas and the Papas If You Can Believe Your Eyes and Ears 127 112 1966
Elton John Greatest Hits 135 136 1974
The Replacements Tim 136 137 1985
The Meters Rejuvenation 138 139 1974
U2 All That You Can't Leave Behind 139 280 2000
Phil Spector A Christmas Gift for You From Phil Spector 142 142 1963
Otis Redding Dreams to Remember: The Otis Redding Anthology, Otis Redding 147 1998
Santana Santana 150 149 1969
Elton John Captain Fantastic and the Brown Dirt Cowboy 158 158 1975
Otis Redding The Dock of the Bay 161 161 1968
Elvis Costello Imperial Bedroom 166 166 1982
The Byrds The Notorious Byrd Brothers 171 171 1968
Bob Dylan Desire 174 174 1976
The Carpenters Close to You 175 175 1970
The Byrds Greatist Hits 178 1967
Curtis Mayfield The Anthology: 1961-1977 179 178 1992
Rolling Stones The Rolling Stones, Now! 181 180 1965
Bob Marley Natty Dread 182 181 1974
Fleetwood Mac Fleetwood Mac 183 182 1975
Sly & The Family Stone Fresh 186 186 1973
Buffalo Springfield Buffalo Springfield Again 188 188 1967
Quicksilver Messenger Service Happy Trails 189 189 1969
John Mayall & the Bluesbreakers Bluesbreakers 195 195 1966
Little Walter The Best of Little Walter 198 198 1967
AC/DC Highway to Hell 199 200 1979
Simon & Garfunkel Parsley, Sage, Rosemary and Thyme 201 202 1966
Cream Wheels of Fire 203 205 1968
Rolling Stones Tattoo You 211 213 1981
Bobby "Blue" Bland Two Steps From the Blues 215 217 1961
Professor Longhair New Orleans Piano 220 222 1972
U2 War 221 223 1983
Neil Diamond The Neil Diamond Collection 222 224 1999
Howlin' Wolf Howlin' Wolf 223 238 1962
Hank Williams The Complete Hank Williams 225 1998
Aerosmith Toys in the Attic 228 229 1975
The Kinks The Kink Kronikles 231 232 1972
Simon & Garfunkel Bookends 233 234 1968
Jackie Wilson Mr. Excitement! 235 236 1992
The Who My Generation 236 237 1965
The Mothers of Invention Freak Out! 243 246 1966
Grateful Dead Live/Dead 244 247 1969
Nick Drake Bryter Later 245 1971
Bruce Springsteen The River 250 253 1980
Willie Nelson Stardust 257 260 1978
Buena Vista Social Club Buena Vista Social Club 260 1997
Ray Charles The Genius of Ray Charles 263 265 1959
Blood, Sweat & Tears Child Is Father to the Man 264 266 1968
The Who Quadrophenia 266 267 1973
The Jesus and Mary Chain Psychocandy 268 269 1985
LaBelle Nightbirds 272 274 1974
Various Artists Anthology of American Folk Music 276 278 1997
David Bowie Aladdin Sane 277 279 1973
Muddy Waters Folk Singer 280 282 1964
Barry White Can't Get Enough 281 283 1974
Nick Drake Five Leaves Left 283 1969
Grateful Dead Anthem of the Sun 287 288 1968
Talking Heads Talking Heads: 77 290 291 1977
Simon & Garfunkel Greatest Hits 293 1972
The Smiths Meat Is Murder 295 296 1985
The Mothers of Invention We're Only in It for the Money 296 297 1968
Frank Sinatra Songs for Swingin' Lovers! 306 308 1956
Various Artists The Sun Records Collection 308 311 1994
Jane's Addiction Nothing's Shocking 309 312 1988
No Doubt Rock Steady 316 2001
Eminem The Eminem Show 317 2002
The O'Jays Back Stabbers 318 318 1972
Bob Marley Burnin' 319 319 1973
The Police Ghost in the Machine 322 323 1981
Linda Ronstadt The Very Best of Linda Ronstadt 324 164 2002
Eric Clapton Slowhand 325 325 1977
James Brown In the Jungle Groove 330 329 1986
Richard & Linda Thompson Shoot Out the Lights 333 332 1982
X Wild Gift 334 333 1981
Graham Parker Squeezing Out Sparks 335 334 1979
Soundgarden Superunknown 336 335 1994
Jethro Tull Aqualung 337 337 1971
Tom Waits The Heart of Saturday Night 339 339 1974
Moby Play 341 341 1999
Meat Loaf Bat Out of Hell 343 343 1977
Lou Reed Berlin 344 344 1973
Talking Heads Stop Making Sense 345 345 1984
Muddy Waters Muddy Waters at Newport 1960 348 348 1960
The Yardbirds Roger the Engineer 349 350 1966
Billy Joel 52nd Street 352 354 1978
The Yardbirds Having a Rave Up 353 355 1965
Randy Newman 12 Songs 354 356 1970
Rolling Stones Between the Buttons 355 357 1967
Miles Davis Sketches of Spain 356 358 1960
New Order Substance 1987 361 363 1987
The Doors L.A. Woman 362 364 1971
Johnny Cash American Recordings 364 366 1994
The Smiths Louder Than Bombs 365 369 1987
Mott the Hoople Mott 366 370 1973
The Police Reggatta de Blanc 369 372 1979
Jefferson Airplane Volunteers 370 373 1969
Roxy Music Siren 371 374 1975
Jackson Browne Late for the Sky 372 375 1974
John Lee Hooker The Ultimate Collection: 1948-1990 375 377 1991
Bruce Springsteen Greetings from Asbury Park, NJ 379 1973
The Beach Boys Sunflower 380 1970
The Who A Quick One 383 384 1966
Def Leppard Pyromania 384 1983
Steely Dan Pretzel Logic 385 386 1974
Roxy Music Country Life 387 1974
Don Henley The End of the Innocence 389 389 1989
Jackson Browne The Pretender 391 391 1976
Randy Newman Good Old Boys 393 394 1974
ZZ Top Eliminator 396 398 1983
Dr. John Dr. John's Gumbo 402 404 1972
The Doors Strange Days 407 409 1967
Bob Dylan Time Out of Mind 408 410 1997
Eric Clapton 461 Ocean Boulevard 409 411 1974
James Brown Greatest Hits 414 1991
Tom Waits Mule Variations 416 416 1999
U2 Boy 417 417 1980
Paul McCartney Band on the Run 418 418 1973
The Beatles With the Beatles 420 1963
Buddy Holly The "Chirping" Crickets 421 420 1957
Various Artists The Best of the Girl Groups, Volume 1 422 421 1990
The Mamas and the Papas Greatest Hits 423 1998
Robert Johnson King of the Delta Blues Singers, vol 2 424 1970
David Bowie ChangesOneBowie 425 1976
Rage Against the Machine The Battle of Los Angeles 426 1999
Gram Parsons Grievous Angel 429 425 1974
Cheap Trick Cheap Trick at Budokan 430 426 1978
Peter Wolf Sleepless 432 427 2002
The Police Outlandos d'Amour 434 428 1978
PJ Harvey To Bring You My Love 435 1995
Beck Sea Change 440 436 2002
No Doubt Tragic Kingdom 441 1995
The Cure Boys Don't Cry 442 438 1979
The Pogues Rum Sodomy & the Lash 445 440 1985
Cheap Trick In Color 448 443 1977
War The World Is a Ghetto 449 444 1972
Steve Miller Fly Like an Eagle 450 445 1976
MC5 Back in the USA 451 446 1970
Madonna Music 452 2000
Jane's Addiction Ritual de lo Habitual 453 1990
Getz & Gilberto Getz / Gilberto 454 447 1964
Jackson Browne For Everyman 457 450 1973
EPMD Strictly Business 459 453 1988
Alice Cooper Love It to Death 460 454 1971
Elton John Tumbleweed Connection 463 458 1970
The Drifters The Drifters' Golden Hits 465 459 1968
Elton John Elton John 468 1970
Public Image Ltd. Metal Box 469 461 1979
R.E.M. Document 470 462 1987
Echo and The Bunnymen Heaven Up Here 471 463 1981
Def Leppard Hysteria 472 464 1987
Otis Redding Live in Europe 474 1967
Bruce Springsteen Tunnel of Love 475 467 1987
Paul Butterfield Blues Band The Paul Butterfield Blues Band 476 468 1965
LL Cool J Radio 478 470 1985
The Smiths The Smiths 481 473 1984
Elvis Costello Armed Forces 482 475 1979
Merle Haggard Branded Man 484 1967
Loretta Lynn All Time Greatest Hits 485 478 2002
The Smashing Pumpkins Mellon Collie and the Infinite Sadness 487 1995
Steve Earle Guitar Town 489 482 1986
Mott the Hoople All the Young Dudes 491 484 1972
Pearl Jam Vitalogy 493 485 1994
KISS Destroyer 496 489 1976
Public Enemy Yo! Bum Rush the Show 497 1987
ZZ Top Tres Hombres 498 490 1973
Albert King Born Under a Bad Sign 499 491 1967
Eurythmics Touch 500 492 1983
Robert Johnson The Complete Recordings 22 1990
Creedence Clearwater Revival Chronicle: The 20 Greatest Hits 59 1976
Bob Dylan Modern Times 204 2006
Radiohead Amnesiac 320 2001
Arctic Monkeys Whatever People Say I Am, That's What I'm Not 371 2006
The Beach Boys The Smile Sessions 381 2011
M.I.A. Kala 393 2007
Bruce Springsteen The Rising 424 2002
Vampire Weekend Vampire Weekend 430 2008
My Morning Jacket Z 457 2005
Manu Chao Proxima estacion: Esperanza 474 2001
MGMT Oracular Spectacular 494 2007
Bonnie Raitt Give It Up 495 1972
Boz Scaggs Boz Scaggs 496 1969
The White Stripes White Blood Cells 497 2001
B.B. King Live in Cook County Jail 499 1971
Ian Dury and the Blockheads New Boots & Panties!! 1977
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment