Spotify Music Dataset

Popular and Not so popular songs

@kaggle.solomonameh_spotify_music_dataset

Table List

2 tables(1.14 MB)

High Popularity Spotify Data

@kaggle.solomonameh_spotify_music_dataset.high_popularity_spotify_data

383.84 KB
1686 rows
29 columns

energy Energy	tempo Tempo	danceability Danceability	playlist_genre Playlist Genre	loudness Loudness	liveness Liveness	valence Valence	track_artist Track Artist	time_signature Time Signature	speechiness Speechiness	track_popularity Track Popularity	track_href Track Href	uri Uri	track_album_name Track Album Name	playlist_name Playlist Name	analysis_url Analysis Url	track_id Track Id	track_name Track Name	track_album_release_date Track Album Release Date	instrumentalness Instrumentalness	track_album_id Track Album Id	mode Mode	key Key	duration_ms Duration Ms	acousticness Acousticness	id Id	playlist_subgenre Playlist Subgenre	type Type	playlist_id Playlist Id
0.592	157.969	0.521	pop	-7.777	0.122	0.535	Lady Gaga, Bruno Mars	3	0.0304	100	https://api.spotify.com/v1/tracks/2plbrEY59IikOBgBGLjaoe	spotify:track:2plbrEY59IikOBgBGLjaoe	Die With A Smile	Today's Top Hits	https://api.spotify.com/v1/audio-analysis/2plbrEY59IikOBgBGLjaoe	2plbrEY59IikOBgBGLjaoe	Die With A Smile	Fri Aug 16 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		10FLjwfpbxLmW8c25Xyc2N		6	251668	0.308	2plbrEY59IikOBgBGLjaoe	mainstream	audio_features	37i9dQZF1DXcBWIGoYBM5M
0.507	104.978	0.747	pop	-10.171	0.117	0.438	Billie Eilish	4	0.0358	97	https://api.spotify.com/v1/tracks/6dOtVTDdiauQNBQEDOtlAB	spotify:track:6dOtVTDdiauQNBQEDOtlAB	HIT ME HARD AND SOFT	Today's Top Hits	https://api.spotify.com/v1/audio-analysis/6dOtVTDdiauQNBQEDOtlAB	6dOtVTDdiauQNBQEDOtlAB	BIRDS OF A FEATHER	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.0608	7aJuG4TFXa2hmE4z1yxc3n	1	2	210373	0.2	6dOtVTDdiauQNBQEDOtlAB	mainstream	audio_features	37i9dQZF1DXcBWIGoYBM5M
0.808	108.548	0.554	pop	-4.169	0.159	0.372	Gracie Abrams	4	0.0368	93	https://api.spotify.com/v1/tracks/7ne4VBA60CxGM75vw0EYad	spotify:track:7ne4VBA60CxGM75vw0EYad	The Secret of Us (Deluxe)	Today's Top Hits	https://api.spotify.com/v1/audio-analysis/7ne4VBA60CxGM75vw0EYad	7ne4VBA60CxGM75vw0EYad	That’s So True	Fri Oct 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		0hBRqPYPXhr1RkTDG3n4Mk	1	1	166300	0.214	7ne4VBA60CxGM75vw0EYad	mainstream	audio_features	37i9dQZF1DXcBWIGoYBM5M
0.91	112.966	0.67	pop	-4.07	0.304	0.786	Sabrina Carpenter	4	0.0634	81	https://api.spotify.com/v1/tracks/1d7Ptw3qYcfpdLNL5REhtJ	spotify:track:1d7Ptw3qYcfpdLNL5REhtJ	Short n' Sweet	Today's Top Hits	https://api.spotify.com/v1/audio-analysis/1d7Ptw3qYcfpdLNL5REhtJ	1d7Ptw3qYcfpdLNL5REhtJ	Taste	Fri Aug 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		4B4Elma4nNDUyl6D5PvQkj			157280	0.0939	1d7Ptw3qYcfpdLNL5REhtJ	mainstream	audio_features	37i9dQZF1DXcBWIGoYBM5M
0.783	149.027	0.777	pop	-4.477	0.355	0.939	ROSÉ, Bruno Mars	4	0.26	98	https://api.spotify.com/v1/tracks/5vNRhkKd0yEAg8suGBpjeY	spotify:track:5vNRhkKd0yEAg8suGBpjeY	APT.	Today's Top Hits	https://api.spotify.com/v1/audio-analysis/5vNRhkKd0yEAg8suGBpjeY	5vNRhkKd0yEAg8suGBpjeY	APT.	Fri Oct 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		2IYQwwgxgOIn7t3iF6ufFD			169917	0.0283	5vNRhkKd0yEAg8suGBpjeY	mainstream	audio_features	37i9dQZF1DXcBWIGoYBM5M
0.582	116.712	0.7	pop	-5.96	0.0881	0.785	Chappell Roan	4	0.0356	94	https://api.spotify.com/v1/tracks/0WbMK4wrZ1wFSty9F7FCgu	spotify:track:0WbMK4wrZ1wFSty9F7FCgu	Good Luck, Babe!	Today's Top Hits	https://api.spotify.com/v1/audio-analysis/0WbMK4wrZ1wFSty9F7FCgu	0WbMK4wrZ1wFSty9F7FCgu	Good Luck, Babe!	Fri Apr 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		1WAjjRMfZjEXtB0lQrAw6Q		11	218424	0.0502	0WbMK4wrZ1wFSty9F7FCgu	mainstream	audio_features	37i9dQZF1DXcBWIGoYBM5M
0.561	150.069	0.669	pop	-6.538	0.0954	0.841	Addison Rae	4	0.0411	88	https://api.spotify.com/v1/tracks/6MzofobZt2dm0Kf1hTThFz	spotify:track:6MzofobZt2dm0Kf1hTThFz	Diet Pepsi	Today's Top Hits	https://api.spotify.com/v1/audio-analysis/6MzofobZt2dm0Kf1hTThFz	6MzofobZt2dm0Kf1hTThFz	Diet Pepsi	Fri Aug 09 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.00962	0XA403JTounqFh2owquBXu	1	10	169698	0.495	6MzofobZt2dm0Kf1hTThFz	mainstream	audio_features	37i9dQZF1DXcBWIGoYBM5M
0.247	148.101	0.467	pop	-12.002	0.17	0.126	Billie Eilish	4	0.0431	93	https://api.spotify.com/v1/tracks/3QaPy1KgI7nu9FJEQUgn6h	spotify:track:3QaPy1KgI7nu9FJEQUgn6h	HIT ME HARD AND SOFT	Today's Top Hits	https://api.spotify.com/v1/audio-analysis/3QaPy1KgI7nu9FJEQUgn6h	3QaPy1KgI7nu9FJEQUgn6h	WILDFLOWER	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.000271	7aJuG4TFXa2hmE4z1yxc3n		6	261467	0.612	3QaPy1KgI7nu9FJEQUgn6h	mainstream	audio_features	37i9dQZF1DXcBWIGoYBM5M
0.416	94.926	0.492	pop	-10.439	0.203	0.297	Gigi Perez	4	0.0254	71	https://api.spotify.com/v1/tracks/0UYnhUfnUj5adChuAXvLUB	spotify:track:0UYnhUfnUj5adChuAXvLUB	Sailor Song	Today's Top Hits	https://api.spotify.com/v1/audio-analysis/0UYnhUfnUj5adChuAXvLUB	0UYnhUfnUj5adChuAXvLUB	Sailor Song	Fri Jul 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.0000861	4DWrYvfGXRE8ko5ZxlIpit	1	11	211979	0.686	0UYnhUfnUj5adChuAXvLUB	mainstream	audio_features	37i9dQZF1DXcBWIGoYBM5M
0.722	119.973	0.769	pop	-5.485	0.111	0.57	The Weeknd, Playboi Carti	4	0.0507	92	https://api.spotify.com/v1/tracks/1Es7AUAhQvapIcoh3qMKDL	spotify:track:1Es7AUAhQvapIcoh3qMKDL	Timeless	Today's Top Hits	https://api.spotify.com/v1/audio-analysis/1Es7AUAhQvapIcoh3qMKDL	1Es7AUAhQvapIcoh3qMKDL	Timeless (with Playboi Carti)	Fri Sep 27 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.00000256	2IRxVVqbSbqHJo8Zx50LYn		11	256000	0.0584	1Es7AUAhQvapIcoh3qMKDL	mainstream	audio_features	37i9dQZF1DXcBWIGoYBM5M


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