Dataset

This dataset was created using Spotify developer API. It consists of user-created as well as Spotify-curated playlists.
The dataset consists of 1 million playlists, 3 million unique tracks, 3 million unique albums, 1.3 million artists and 2680 genres.
The data is stored in a SQL database, with the primary entities being songs, albums, artists, and playlists.
Each of the aforementioned entities are represented by unique IDs (Spotify URI).
Data is stored into following tables:

  1. Album
  2. Artist
  3. Playlist
  4. Track
  5. Track_Artist1
  6. Track_Playlist1
  7. Genre_Master_Spotify
  8. Artist_Genre
Album

| Id | Name | Uri |


Spotify Album Documentation

Id: Album ID as provided by Spotify
Name: Album Name as provided by Spotify
URI: Album URI as provided by Spotify


Artist

| Id | Name | Uri |


Spotify Artist Documentation

Id: Artist ID as provided by Spotify
Name: Artist Name as provided by Spotify
URI: Artist URI as provided by Spotify


Track

| Id | Name | Duration | Popularity | Explicit | Preview_Url | Uri | Album_id |


Spotify Track Documentation

Id: Track ID as provided by Spotify
Name: Track Name as provided by Spotify
Duration: Track Duration (in milliseconds) as provided by Spotify
Popularity: Track Popularity as provided by Spotify
Explicit: Whether the track has explicit lyrics or not. (true or false)
Preview_Url: A link to a 30 second preview (MP3 format) of the track. Can be null
Uri: Track Uri as provided by Spotify
Album_id: Album Id to which the track belongs


Playlist

| Id | Name | Followers | Uri | Total_tracks |


Spotify Playlist Documentation

Id: Playlist ID as provided by Spotify
Name: Playlist Name as provided by Spotify
Followers: Playlist Followers as provided by Spotify
Uri: Playlist Uri as provided by Spotify
Total_tracks: Total number of tracks in the playlist.


Track_Playlist1

| Track_Id | Playlist_id |


Track_Id: Track ID as provided by Spotify
Playlist_id: Playlist ID as provided by Spotify


Track_Artist1

| Track_Id | Artist_id |


Track_Id: Track ID as provided by Spotify
Artist_Id: Artist ID as provided by Spotify


Genre_Master_Spotify

| Id | Name |


Id: Unique ID assigned to each genre.
Name: Genre names sourced from Everynoise.com


Artist_Genre

| Artist_Id | Genre_id | Priority |


Artist_Id: Artist ID as provided by Spotify
Genre_id: Genre ID as assigned in Genre_Master_Spotify table.
Priority: Genre Priority assigned on the basis of order of the particular genre in the genre list for an artist as provided by Spotify.


To access the dataset, please send an email request to ppapreja [at] asu [dot] edu.