30000 Spotify Songs

Almost 30,000 Spotify songs from the Spotify API

@kaggle.joebeachcapital_30000_spotify_songs

Table List

1 table(3.17 MB)

Spotify Songs

@kaggle.joebeachcapital_30000_spotify_songs.spotify_songs

3.17 MB
32833 rows
23 columns

track_id Track Id	track_name Track Name	track_artist Track Artist	track_popularity Track Popularity	track_album_id Track Album Id	track_album_name Track Album Name	track_album_release_date Track Album Release Date	playlist_name Playlist Name	playlist_id Playlist Id	playlist_genre Playlist Genre	playlist_subgenre Playlist Subgenre	danceability Danceability	energy Energy	key Key	loudness Loudness	mode Mode	speechiness Speechiness	acousticness Acousticness	instrumentalness Instrumentalness	liveness Liveness	valence Valence	tempo Tempo	duration_ms Duration Ms
6f807x0ima9a1j3VPbc7VN	I Don't Care (with Justin Bieber) - Loud Luxury Remix	Ed Sheeran	66	2oCs0DGTsRO98Gh5ZSl2Cx	I Don't Care (with Justin Bieber) [Loud Luxury Remix]	Fri Jun 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Pop Remix	37i9dQZF1DXcZDD7cfEKhW	pop	dance pop	0.748	0.916	6	-2.634	1	0.0583	0.102		0.0653	0.518	122.036	194754
0r7CVbZTWZgbTCYdfa2P31	Memories - Dillon Francis Remix	Maroon 5	67	63rPSO264uRjW1X5E6cWv6	Memories (Dillon Francis Remix)	Fri Dec 13 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Pop Remix	37i9dQZF1DXcZDD7cfEKhW	pop	dance pop	0.726	0.815	11	-4.969	1	0.0373	0.0724	0.00421	0.357	0.693	99.972	162600
1z1Hg7Vb0AhHDiEmnDE79l	All the Time - Don Diablo Remix	Zara Larsson	70	1HoSmj2eLcsrR0vE9gThr4	All the Time (Don Diablo Remix)	Fri Jul 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Pop Remix	37i9dQZF1DXcZDD7cfEKhW	pop	dance pop	0.675	0.931	1	-3.432		0.0742	0.0794	0.0000233	0.11	0.613	124.008	176616
75FpbthrwQmzHlBJLuGdC7	Call You Mine - Keanu Silva Remix	The Chainsmokers	60	1nqYsOef1yKKuGOVchbsk6	Call You Mine - The Remixes	Fri Jul 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Pop Remix	37i9dQZF1DXcZDD7cfEKhW	pop	dance pop	0.718	0.93	7	-3.778	1	0.102	0.0287	0.00000943	0.204	0.277	121.956	169093
1e8PAfcKUYoKkxPhrHqw4x	Someone You Loved - Future Humans Remix	Lewis Capaldi	69	7m7vv9wlQ4i0LFuJiE2zsQ	Someone You Loved (Future Humans Remix)	Tue Mar 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Pop Remix	37i9dQZF1DXcZDD7cfEKhW	pop	dance pop	0.65	0.833	1	-4.672	1	0.0359	0.0803		0.0833	0.725	123.976	189052
7fvUMiyapMsRRxr07cU8Ef	Beautiful People (feat. Khalid) - Jack Wins Remix	Ed Sheeran	67	2yiy9cd2QktrNvWC2EUi0k	Beautiful People (feat. Khalid) [Jack Wins Remix]	Thu Jul 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Pop Remix	37i9dQZF1DXcZDD7cfEKhW	pop	dance pop	0.675	0.919	8	-5.385	1	0.127	0.0799		0.143	0.585	124.982	163049
2OAylPUDDfwRGfe0lYqlCQ	Never Really Over - R3HAB Remix	Katy Perry	62	7INHYSeusaFlyrHSNxm8qH	Never Really Over (R3HAB Remix)	Fri Jul 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Pop Remix	37i9dQZF1DXcZDD7cfEKhW	pop	dance pop	0.449	0.856	5	-4.788		0.0623	0.187		0.176	0.152	112.648	187675
6b1RNvAcJjQH73eZO4BLAB	Post Malone (feat. RANI) - GATTÜSO Remix	Sam Feldt	69	6703SRPsLkS4bPtMFFJes1	Post Malone (feat. RANI) [GATTÜSO Remix]	Thu Aug 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Pop Remix	37i9dQZF1DXcZDD7cfEKhW	pop	dance pop	0.542	0.903	4	-2.419		0.0434	0.0335	0.00000483	0.111	0.367	127.936	207619
7bF6tCO3gFb8INrEDcjNT5	Tough Love - Tiësto Remix / Radio Edit	Avicii	68	7CvAfGvq4RlIwEbT9o8Iav	Tough Love (Tiësto Remix)	Fri Jun 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Pop Remix	37i9dQZF1DXcZDD7cfEKhW	pop	dance pop	0.594	0.935	8	-3.562	1	0.0565	0.0249	0.00000397	0.637	0.366	127.015	193187
1IXGILkPm0tOCNeq00kCPa	If I Can't Have You - Gryffin Remix	Shawn Mendes	67	4QxzbfSsVryEQwvPFEV5Iu	If I Can't Have You (Gryffin Remix)	Thu Jun 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Pop Remix	37i9dQZF1DXcZDD7cfEKhW	pop	dance pop	0.642	0.818	2	-4.552	1	0.032	0.0567		0.0919	0.59	124.957	253040


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