Spotify And Youtube

Statistics for the Top 10 songs of various spotify artists and their yt video.

@kaggle.salvatorerastelli_spotify_and_youtube

Table List

1 table(13.09 MB)

Spotify Youtube

@kaggle.salvatorerastelli_spotify_and_youtube.spotify_youtube

13.09 MB
20718 rows
28 columns

unnamed_0 Unnamed: 0	artist Artist	url_spotify Url Spotify	track Track	album Album	album_type Album Type	uri Uri	danceability Danceability	energy Energy	key Key	loudness Loudness	speechiness Speechiness	acousticness Acousticness	instrumentalness Instrumentalness	liveness Liveness	valence Valence	tempo Tempo	duration_ms Duration Ms	url_youtube Url Youtube	title Title	channel Channel	views Views	likes Likes	comments Comments	description Description	licensed Licensed	official_video Official Video	stream Stream
	Gorillaz	https://open.spotify.com/artist/3AA28KZvwAUcZuOKwyblJQ	Feel Good Inc.	Demon Days	album	spotify:track:0d28khcov6AiegSCpG5TuT	0.818	0.705	6	-6.679	0.177	0.00836	0.00233	0.613	0.772	138.559	222640	https://www.youtube.com/watch?v=HyHNuVaZJ-k	Gorillaz - Feel Good Inc. (Official Video)	Gorillaz	693555221	6220896	169907	Official HD Video for Gorillaz' fantastic track Feel Good Inc. Follow Gorillaz online: http://gorillaz.com http://facebook.com/Gorillaz http://twitter.com/GorillazBand http://instagram/Gorillaz For more information on Gorillaz don't forget to check out the official website at http://www.gorillaz.c…	True	True	1040234854
1	Gorillaz	https://open.spotify.com/artist/3AA28KZvwAUcZuOKwyblJQ	Rhinestone Eyes	Plastic Beach	album	spotify:track:1foMv2HQwfQ2vntFf9HFeG	0.676	0.703	8	-5.815	0.0302	0.0869	0.000687	0.0463	0.852	92.761	200173	https://www.youtube.com/watch?v=yYDmaexVHic	Gorillaz - Rhinestone Eyes [Storyboard Film] (Official Music Video)	Gorillaz	72011645	1079128	31003	The official video for Gorillaz - Rhinestone Eyes Rhinestone Eyes is taken from the 2010 album Plastic Beach including the singles Rhinestone Eyes, Stylo, Superfast Jellyfish and On Melancholy Hill. Follow Gorillaz online: https://instagram.com/gorillaz https://tiktok.com/@gorillaz https://twit…	True	True	310083733
2	Gorillaz	https://open.spotify.com/artist/3AA28KZvwAUcZuOKwyblJQ	New Gold (feat. Tame Impala and Bootie Brown)	New Gold (feat. Tame Impala and Bootie Brown)	single	spotify:track:64dLd6rVqDLtkXFYrEUHIU	0.695	0.923	1	-3.93	0.0522	0.0425	0.0469	0.116	0.551	108.014	215150	https://www.youtube.com/watch?v=qJa-VFwPpYA	Gorillaz - New Gold ft. Tame Impala & Bootie Brown (Official Visualiser)	Gorillaz	8435055	282142	7399	Gorillaz - New Gold ft. Tame Impala & Bootie Brown (Official Visualiser) Pre-order Cracker Island album: https://gorillaz.com Listen to New Gold: https://gorill.az/newgold Join The Last Cult: https://thelastcult.org Listen to Gorillaz: https://gorill.az/listen Shop Gorillaz: https://store.gorillaz…	True	True	63063467
3	Gorillaz	https://open.spotify.com/artist/3AA28KZvwAUcZuOKwyblJQ	On Melancholy Hill	Plastic Beach	album	spotify:track:0q6LuUqGLUiCPP1cbdwFs3	0.689	0.739	2	-5.81	0.026	0.0000151	0.509	0.064	0.578	120.423	233867	https://www.youtube.com/watch?v=04mfKJWDSzI	Gorillaz - On Melancholy Hill (Official Video)	Gorillaz	211754952	1788577	55229	Follow Gorillaz online: http://gorillaz.com http://facebook.com/Gorillaz http://twitter.com/GorillazBand https://instagram.com/gorillaz Music video by Gorillaz performing On Melancholy Hill. (P) 2010 The copyright in this audiovisual recording is owned by Parlophone Records	True	True	434663559
4	Gorillaz	https://open.spotify.com/artist/3AA28KZvwAUcZuOKwyblJQ	Clint Eastwood	Gorillaz	album	spotify:track:7yMiX7n9SBvadzox8T5jzT	0.663	0.694	10	-8.627	0.171	0.0253		0.0698	0.525	167.953	340920	https://www.youtube.com/watch?v=1V_xRb0x9aw	Gorillaz - Clint Eastwood (Official Video)	Gorillaz	618480958	6197318	155930	The official music video for Gorillaz - Clint Eastwood Taken from Gorillaz debut Studio Album 'Gorillaz’ released in 2001, which features the singles Clint Eastwood, 19-2000, Rock The House & Tomorrow Comes Today. Pre-order Cracker Island album: https://gorillaz.com Subscribe to the Gorillaz cha…	True	True	617259738
5	Gorillaz	https://open.spotify.com/artist/3AA28KZvwAUcZuOKwyblJQ	DARE	Demon Days	album	spotify:track:4Hff1IjRbLGeLgFgxvHflk	0.76	0.891	11	-5.852	0.0372	0.0229	0.0869	0.298	0.966	120.264	245000	https://www.youtube.com/watch?v=uAOR6ib95kQ	Gorillaz - DARE (Official Video)	Gorillaz	259021161	1844658	72008	Follow Gorillaz online: http://gorillaz.com http://facebook.com/Gorillaz http://twitter.com/GorillazBand https://instagram.com/gorillaz Stream Gorillaz on Spotify: http://bit.ly/1kvIyPR Music video by Gorillaz performing DARE. (P) 2005 The copyright in this sound recording is owned by Parlophone …	True	True	323850327
6	Gorillaz	https://open.spotify.com/artist/3AA28KZvwAUcZuOKwyblJQ	New Gold (feat. Tame Impala and Bootie Brown) - Dom Dolla Remix	New Gold (feat. Tame Impala and Bootie Brown) [Dom Dolla Remix]	single	spotify:track:2c3KCGq6UojB2c8UAFrRON	0.716	0.897	4	-7.185	0.0629	0.012	0.262	0.325	0.358	127.03	274142	https://www.youtube.com/watch?v=BONNm0F7Tto	Gorillaz - New Gold ft. Tame Impala, Bootie Brown (Dom Dolla Remix) (Official Live Video)	Dom Dolla	451996	11686	241	Gorillaz 'New Gold' ft. Tame Impala, Bootie Brown (Dom Dolla Remix) Live @ Shrine Expo Hall, Los Angeles, Oct 7th 2022 Stream/Download New Gold (Dom Dolla Remix): https://DomDolla.lnk.to/NewGoldRemix Follow and listen to more Dom: https://DomDolla.lnk.to/FollowYo Facebook: https://www.facebook.c…	False	True	10666154
7	Gorillaz	https://open.spotify.com/artist/3AA28KZvwAUcZuOKwyblJQ	She's My Collar (feat. Kali Uchis)	Humanz (Deluxe)	album	spotify:track:3lIxtCaROdRDuTnNBDm3n2	0.726	0.815	11	-5.886	0.0313	0.00799	0.081	0.112	0.462	140.158	209560	https://www.youtube.com/watch?v=f8NwLXYIHS4	Gorillaz - She's My Collar [HQ]	SalvaMuñox	1010982	17675	260	𝐁̲𝐎̲𝐍̲𝐔̲𝐒̲:̲ Hu̳ma̳n̳z [̲̠̲𝐃̲̠̲𝐄̲̠̲𝐅̲̠̲𝐈̲̠̲𝐍̲̠̲𝐈̲̠̲𝐓̲̠̲𝐈̲̠̲𝐕̲̠̲𝐄̲̠̲ ̲̠𝐄̲̠̲𝐃̲̠𝐈̲̠̲𝐓̲̠̲𝐈̲̠𝐎̲̠̲𝐍̲̠]̲̠̲ https://drive.google.com/file/d/1MsTWitzhoLzEG01q7dANDTZ_ltu-6Y5w/	False	False	159605929
8	Gorillaz	https://open.spotify.com/artist/3AA28KZvwAUcZuOKwyblJQ	Cracker Island (feat. Thundercat)	Cracker Island (feat. Thundercat)	single	spotify:track:2W3ZpQg9i6lE6kmHbcdu9N	0.741	0.913	2	-3.34	0.0465	0.00343	0.103	0.325	0.643	120.012	213750	https://www.youtube.com/watch?v=S03T47hapAc	Gorillaz - Cracker Island ft. Thundercat (Official Video)	Gorillaz	24459820	739527	20296	Listen to Cracker Island: https://gorillaz.lnk.to/CrackerIsland Join The Last Cult: https://thelastcult.org Listen to Gorillaz: https://gorill.az/listen Shop Gorillaz: https://store.gorillaz.com/ Follow Gorillaz: https://instagram.com/gorillaz https://tiktok.com/@gorillaz https://twitter.com/gor…	True	True	42671901
9	Gorillaz	https://open.spotify.com/artist/3AA28KZvwAUcZuOKwyblJQ	Dirty Harry	Demon Days	album	spotify:track:2bfGNzdiRa1jXZRdfssSzR	0.625	0.877	10	-7.176	0.162	0.0315	0.0811	0.672	0.865	192.296	230426	https://www.youtube.com/watch?v=cLnkQAeMbIM	Gorillaz - Dirty Harry (Official Video)	Gorillaz	154761056	1386920	39240	Follow Gorillaz online: http://gorillaz.com http://facebook.com/Gorillaz http://twitter.com/GorillazBand https://instagram.com/gorillaz Stream Gorillaz on Spotify: http://bit.ly/1kvIyPR Music video by Gorillaz performing Dirty Harry. (P) 2005 The copyright in this audiovisual recording is owned …	True	True	191074713


CREATE TABLE spotify_youtube (
  "unnamed_0" BIGINT,
  "artist" VARCHAR,
  "url_spotify" VARCHAR,
  "track" VARCHAR,
  "album" VARCHAR,
  "album_type" VARCHAR,
  "uri" VARCHAR,
  "danceability" DOUBLE,
  "energy" DOUBLE,
  "key" DOUBLE,
  "loudness" DOUBLE,
  "speechiness" DOUBLE,
  "acousticness" DOUBLE,
  "instrumentalness" DOUBLE,
  "liveness" DOUBLE,
  "valence" DOUBLE,
  "tempo" DOUBLE,
  "duration_ms" DOUBLE,
  "url_youtube" VARCHAR,
  "title" VARCHAR,
  "channel" VARCHAR,
  "views" DOUBLE,
  "likes" DOUBLE,
  "comments" DOUBLE,
  "description" VARCHAR,
  "licensed" VARCHAR,
  "official_video" VARCHAR,
  "stream" DOUBLE
);