Dataset: The Rolling Stone Album Rankings

About this Dataset

The Rolling Stone Album Rankings

Context

The RS 500 list is a product of meticulous selection by Rolling Stone's editors, who drew upon the insights from two comprehensive surveys. Initially, in 2003, a diverse panel comprising 271 notable figures from the music industry, including artists, producers, and journalists, was tasked with identifying the most influential albums ever produced. Subsequently, in 2009, a similar assembly of 100 specialists was convened to determine the standout albums of the 2000s. The outcomes of these polls were instrumental in shaping Rolling Stone's esteemed compilation of the all-time greatest albums.

Content

Geography: United Kingdom

Time period: 2003-2020

Unit of analysis: The Rolling Stone Album Rankings

Dataset: The dataset contains details information of The Pudding compares Rolling Stone’s “500 Greatest Albums of All Time” lists from 2003, 2012, and 2020.

Variables:

Sort name: Name used for sorting
clean name: Clean name
album: Album name
rank_2003: Rank in 2003. NA if album not released yet or not in top 500
rank_2012: Rank in 2012. NA if album not released yet or not in top 500
rank_2020: Rank in 2020. NA if not in top 500
differential: 2020-2003 Differential. Negative value if it went down in the chart. Positive value if it went up
release_year: Release Year
genre: Album genre
type: Album type
weeks_on_billboard: Weeks on Billboard
peak_billboard_position: Peak Billboard Position
spotify_popularity: Spotify Popularity. NA if not on Spotify
spotify_url: Spotify URL. NA if not on Spotify
artist_member_count: Number of artists in the group
artist_gender: Gender of the artist(s). Male/Female if it's a mixed-gender group
artist_birth_year_sum: Sum of the artists birth year. e.g. for a 2 member group, with one person born 1945 and
another 1950, the value is 3895.
debut_album_release_year: Debut Album Release Year
avg_age_at_top_500: Average age at top 500 Album
years_between: Years Between Debut and Top 500 Album
album_id: Album ID. NOS at the beginning of the ID if not on Spotify

Data Source

The data in this dataset was collected from various sources and thank to all researchers who collected it.
At album rankings from Rolling Stone. h/t Data is plural. A visual essay from The Pudding looks at what makes an album the greatest of all time, and shares the data they put together for the essay.

Please note that this description is a template, and you should adapt it based on the actual data sources and specific details of your dataset when creating it for Kaggle or any other platform.

Tables

Rolling Stone

@kaggle.umerhaddii_rolling_stone_album_rankings.rolling_stone

92.09 KB
691 rows
21 columns


CREATE TABLE rolling_stone (
  "sort_name" VARCHAR,
  "clean_name" VARCHAR,
  "album" VARCHAR,
  "rank_2003" DOUBLE,
  "rank_2012" DOUBLE,
  "rank_2020" DOUBLE,
  "differential" BIGINT,
  "release_year" BIGINT,
  "genre" VARCHAR,
  "type" VARCHAR,
  "weeks_on_billboard" DOUBLE,
  "peak_billboard_position" BIGINT,
  "spotify_popularity" DOUBLE,
  "spotify_url" VARCHAR,
  "artist_member_count" DOUBLE,
  "artist_gender" VARCHAR,
  "artist_birth_year_sum" DOUBLE,
  "debut_album_release_year" DOUBLE,
  "ave_age_at_top_500" DOUBLE,
  "years_between" DOUBLE,
  "album_id" VARCHAR
);