A larger version of the Billboard 200 database. The first two tables are included in the smaller version of the database:
- 574,000 rows containing all albums in the Billboard 200 from 1/5/1963 to 1/19/2019. Each row contains the album’s place in the charts, the week of the chart, album name, artist name, and where available from Spotify and not null in the table, the number of tracks, and length of the album in milliseconds. This table is titled “albums”.
- 340,000 rows containing acoustic data for tracks from Billboard 200 albums from 1/5/1963 to 1/19/2019. Each row contains track ID on Spotify, track name, album name, artist name, values for Spotify EchoNest acoustic data (acousticness, danceability, energy, instrumentalness, liveness, loudness, speechiness, key, time signature, and valence), duration in milliseconds, album ID on Spotify, and release date of the album. Contains no null values. This table is titled “acoustic_features”.
- 2,821,061 rows of segment data from songs on Billboard 200 albums. Each song on Spotify typically contains upwards of 1000 segments; this table is constituted from a sample of 20 of those segments for each song or the max number of segments, whichever is smaller. Each row contains track ID on Spotify, track name, album name, artist name, the album ID on Spotify, 12-dimensional timbral data, confidence value, duration of the segment, max loudness, time of max loudness, and the start time of max loudness. For more information on these values, see Spotify’s documentation on segments.