Spotify Music Dataset

Popular and Not so popular songs

@kaggle.solomonameh_spotify_music_dataset

Table List

2 tables(1.14 MB)

Low Popularity Spotify Data

@kaggle.solomonameh_spotify_music_dataset.low_popularity_spotify_data

778.72 KB
3145 rows
29 columns

time_signature Time Signature	track_popularity Track Popularity	speechiness Speechiness	danceability Danceability	playlist_name Playlist Name	track_artist Track Artist	duration_ms Duration Ms	energy Energy	playlist_genre Playlist Genre	playlist_subgenre Playlist Subgenre	track_href Track Href	track_name Track Name	mode Mode	uri Uri	type Type	track_album_release_date Track Album Release Date	analysis_url Analysis Url	id Id	instrumentalness Instrumentalness	track_album_id Track Album Id	playlist_id Playlist Id	track_id Track Id	valence Valence	key Key	tempo Tempo	loudness Loudness	acousticness Acousticness	liveness Liveness	track_album_name Track Album Name
4	23	0.0393	0.636	Rock Classics	Creedence Clearwater Revival	138053	0.746	rock	classic	https://api.spotify.com/v1/tracks/5e6x5YRnMJIKvYpZxLqdpH	Fortunate Son	1	spotify:track:5e6x5YRnMJIKvYpZxLqdpH	audio_features	Wed Dec 14 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	https://api.spotify.com/v1/audio-analysis/5e6x5YRnMJIKvYpZxLqdpH	5e6x5YRnMJIKvYpZxLqdpH	0.29	4A8gFwqd9jTtnsNwUu3OQx	37i9dQZF1DWXRqgorJj26U	5e6x5YRnMJIKvYpZxLqdpH	0.432		132.31	-3.785	0.0648	0.173	The Long Road Home - The Ultimate John Fogerty / Creedence Collection
4	53	0.0317	0.572	Rock Classics	Van Halen	241600	0.835	rock	classic	https://api.spotify.com/v1/tracks/5FqYA8KfiwsQvyBI4IamnY	Jump - 2015 Remaster	1	spotify:track:5FqYA8KfiwsQvyBI4IamnY	audio_features	Fri Mar 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	https://api.spotify.com/v1/audio-analysis/5FqYA8KfiwsQvyBI4IamnY	5FqYA8KfiwsQvyBI4IamnY	0.000377	2c965LEDRNrXXCeBOAAwns	37i9dQZF1DWXRqgorJj26U	5FqYA8KfiwsQvyBI4IamnY	0.795		129.981	-6.219	0.171	0.0702	The Collection
4	55	0.0454	0.591	Rock Classics	Stevie Nicks	329413	0.804	rock	classic	https://api.spotify.com/v1/tracks/5LNiqEqpDc8TuqPy79kDBu	Edge of Seventeen - 2016 Remaster	1	spotify:track:5LNiqEqpDc8TuqPy79kDBu	audio_features	Fri Nov 04 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	https://api.spotify.com/v1/audio-analysis/5LNiqEqpDc8TuqPy79kDBu	5LNiqEqpDc8TuqPy79kDBu	0.00000598	3S404OgKoVQSJ3xXrDVlp8	37i9dQZF1DWXRqgorJj26U	5LNiqEqpDc8TuqPy79kDBu	0.658		111.457	-7.299	0.327	0.0818	Bella Donna (Deluxe Edition)
4	64	0.101	0.443	Jazz Classics	Ella Fitzgerald, Louis Armstrong	185160	0.104	jazz	classic	https://api.spotify.com/v1/tracks/78MI7mu1LV1k4IA2HzKmHe	Dream A Little Dream Of Me - Single Version	1	spotify:track:78MI7mu1LV1k4IA2HzKmHe	audio_features	Thu May 03 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	https://api.spotify.com/v1/audio-analysis/78MI7mu1LV1k4IA2HzKmHe	78MI7mu1LV1k4IA2HzKmHe		1y5KGkUKO0NG32MhIIagCA	37i9dQZF1DXbITWG1ZJKYt	78MI7mu1LV1k4IA2HzKmHe	0.394		76.474	-17.042	0.913	0.191	Love, Ella
4	62	0.0298	0.685	Jazz Classics	Galt MacDermot	205720	0.472	jazz	classic	https://api.spotify.com/v1/tracks/6MN6yRVriszuyAVlyF8ndB	Coffee Cold		spotify:track:6MN6yRVriszuyAVlyF8ndB	audio_features	Sat Jan 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	https://api.spotify.com/v1/audio-analysis/6MN6yRVriszuyAVlyF8ndB	6MN6yRVriszuyAVlyF8ndB	0.284	6f4b9wVTkKAf096k4XG6x5	37i9dQZF1DXbITWG1ZJKYt	6MN6yRVriszuyAVlyF8ndB	0.475	9	80.487	-9.691	0.785	0.224	Shapes of Rhythm/Woman Is Sweeter
4	61	0.0566	0.67	Jazz Classics	Frank Sinatra, Count Basie	147147	0.365	jazz	classic	https://api.spotify.com/v1/tracks/2dR5WkrpwylTuT3jRWNufa	Fly Me To The Moon	1	spotify:track:2dR5WkrpwylTuT3jRWNufa	audio_features	Fri Apr 17 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	https://api.spotify.com/v1/audio-analysis/2dR5WkrpwylTuT3jRWNufa	2dR5WkrpwylTuT3jRWNufa		7gmak9ZGm10y4PtZa9SBQn	37i9dQZF1DXbITWG1ZJKYt	2dR5WkrpwylTuT3jRWNufa	0.45		119.347	-10.158	0.525	0.0575	Ultimate Sinatra
4	60	0.0914	0.663	Jazz Classics	Ella Fitzgerald, Louis Armstrong	354533	0.264	jazz	classic	https://api.spotify.com/v1/tracks/33jt3kYWjQzqn3xyYQ5ZEh	Cheek To Cheek	1	spotify:track:33jt3kYWjQzqn3xyYQ5ZEh	audio_features	Tue May 20 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	https://api.spotify.com/v1/audio-analysis/33jt3kYWjQzqn3xyYQ5ZEh	33jt3kYWjQzqn3xyYQ5ZEh		2uqlkJu6vckJahCsp6Hfcn	37i9dQZF1DXbITWG1ZJKYt	33jt3kYWjQzqn3xyYQ5ZEh	0.657		122.482	-14.571	0.706	0.1	The Complete Ella And Louis On Verve
4	55	0.0373	0.525	Jazz Classics	Benny Goodman	195533	0.222	jazz	classic	https://api.spotify.com/v1/tracks/1xUJ1mdLAysxNBtO9w3J2g	Stompin At The Savoy		spotify:track:1xUJ1mdLAysxNBtO9w3J2g	audio_features	Mon Jan 01 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	https://api.spotify.com/v1/audio-analysis/1xUJ1mdLAysxNBtO9w3J2g	1xUJ1mdLAysxNBtO9w3J2g	0.0799	33oCBSZiLbfqyOnTTQ4Tct	37i9dQZF1DXbITWG1ZJKYt	1xUJ1mdLAysxNBtO9w3J2g	0.645	10	156.364	-11.065	0.836	0.051	B. G. In Hi Fi
4	54	0.0363	0.336	Jazz Classics	Kenny Dorham	190400	0.0619	jazz	classic	https://api.spotify.com/v1/tracks/3GOZbK2epuHzCt5YvvVFHO	Alone Together - Rudy Van Gelder Remaster 2006		spotify:track:3GOZbK2epuHzCt5YvvVFHO	audio_features	Wed Jan 01 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	https://api.spotify.com/v1/audio-analysis/3GOZbK2epuHzCt5YvvVFHO	3GOZbK2epuHzCt5YvvVFHO	0.891	4B0pF1WLB3pCaZ4eTx5U8S	37i9dQZF1DXbITWG1ZJKYt	3GOZbK2epuHzCt5YvvVFHO	0.197	5	60.705	-20.494	0.985	0.11	Quiet Kenny
4	53	0.0407	0.742	Jazz Classics	Horace Silver	438280	0.671	jazz	classic	https://api.spotify.com/v1/tracks/1CDBaGlisZlOJzvx88lL8A	Song For My Father		spotify:track:1CDBaGlisZlOJzvx88lL8A	audio_features	Fri Jan 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	https://api.spotify.com/v1/audio-analysis/1CDBaGlisZlOJzvx88lL8A	1CDBaGlisZlOJzvx88lL8A	0.00441	4LEnATSqKeANOJ0mLUAuCE	37i9dQZF1DXbITWG1ZJKYt	1CDBaGlisZlOJzvx88lL8A	0.591	5	127.359	-8.142	0.794	0.122	Song For My Father


CREATE TABLE low_popularity_spotify_data (
  "time_signature" DOUBLE,
  "track_popularity" BIGINT,
  "speechiness" DOUBLE,
  "danceability" DOUBLE,
  "playlist_name" VARCHAR,
  "track_artist" VARCHAR,
  "duration_ms" DOUBLE,
  "energy" DOUBLE,
  "playlist_genre" VARCHAR,
  "playlist_subgenre" VARCHAR,
  "track_href" VARCHAR,
  "track_name" VARCHAR,
  "mode" DOUBLE,
  "uri" VARCHAR,
  "type" VARCHAR,
  "track_album_release_date" TIMESTAMP,
  "analysis_url" VARCHAR,
  "id" VARCHAR,
  "instrumentalness" DOUBLE,
  "track_album_id" VARCHAR,
  "playlist_id" VARCHAR,
  "track_id" VARCHAR,
  "valence" DOUBLE,
  "key" DOUBLE,
  "tempo" DOUBLE,
  "loudness" DOUBLE,
  "acousticness" DOUBLE,
  "liveness" DOUBLE,
  "track_album_name" VARCHAR
);