🎶 Song Dataset: 10,000 Apple Music Tracks

Dive into the Diversity: Genres, Artists & Hits

@kaggle.kanchana1990_apple_music_dataset_10000_tracks_uncovered

Table List

1 table(1.31 MB)

Apple Music Dataset

@kaggle.kanchana1990_apple_music_dataset_10000_tracks_uncovered.apple_music_dataset

1.31 MB
10000 rows
24 columns

artistid ArtistId	artistname ArtistName	collectioncensoredname CollectionCensoredName	collectionid CollectionId	collectionname CollectionName	collectionprice CollectionPrice	contentadvisoryrating ContentAdvisoryRating	country Country	currency Currency	disccount DiscCount	discnumber DiscNumber	isstreamable IsStreamable	kind Kind	previewurl PreviewUrl	primarygenrename PrimaryGenreName	releasedate ReleaseDate	trackcensoredname TrackCensoredName	trackcount TrackCount	trackexplicitness TrackExplicitness	trackid TrackId	trackname TrackName	tracknumber TrackNumber	trackprice TrackPrice	tracktimemillis TrackTimeMillis
46087	Erick Sermon	Music	298321651	Music	9.99	Explicit	USA	USD	1	1	True	song	https://audio-ssl.itunes.apple.com/itunes-assets/AudioPreview125/v4/64/61/b5/6461b58b-c65e-a48b-30fe-1c732242772d/mzaf_8096933756363508880.plus.aac.p.m4a	Hip-Hop/Rap	Mon Aug 27 2001 12:00:00 GMT+0000 (Coordinated Universal Time)	Music (feat. Marvin Gaye)	16	explicit	298321904	Music	4	1.29	223133
20044	Madonna	Music	80815197	Music	9.99	nan	USA	USD	1	1	True	song	https://audio-ssl.itunes.apple.com/itunes-assets/AudioPreview115/v4/f7/3a/72/f73a728e-5e89-8c8d-69f2-578e6e2d1819/mzaf_6039980339395716833.plus.aac.p.m4a	Pop	Mon Aug 21 2000 07:00:00 GMT+0000 (Coordinated Universal Time)	Music	10	notExplicit	80815173	Music	1	1.29	225973
486597	Journey	Greatest Hits (2024 Remaster)	169003304	Greatest Hits (2024 Remaster)	10.99	nan	USA	USD	1	1	True	song	https://audio-ssl.itunes.apple.com/itunes-assets/AudioPreview126/v4/5c/72/97/5c72974f-6022-f760-ad82-35964fb636b5/mzaf_12752096049347330756.plus.aac.p.m4a	Rock	Wed Jun 03 1981 07:00:00 GMT+0000 (Coordinated Universal Time)	Don't Stop Believin' (2024 Remaster)	16	notExplicit	169003415	Don't Stop Believin' (2024 Remaster)	2	1.29	250835
156987	Jason Mraz	We Sing. We Dance. We Steal Things	277635758	We Sing. We Dance. We Steal Things	11.99	nan	USA	USD	1	1	True	song	https://audio-ssl.itunes.apple.com/itunes-assets/AudioPreview116/v4/31/eb/0d/31eb0dab-85d5-84db-009c-14b17db984de/mzaf_2277093686109849165.plus.aac.p.m4a	Pop	Tue Feb 12 2008 08:00:00 GMT+0000 (Coordinated Universal Time)	I'm Yours	12	notExplicit	277635828	I'm Yours	2	1.29	242947
46087	Erick Sermon	Music	298429528	Music	9.99	Clean	USA	USD	1	1	True	song	https://audio-ssl.itunes.apple.com/itunes-assets/AudioPreview115/v4/b7/b1/b3/b7b1b383-221a-e4e1-1b4a-14a6d1f919a5/mzaf_12396333354455774624.plus.aac.p.m4a	Hip-Hop/Rap	Tue May 29 2001 07:00:00 GMT+0000 (Coordinated Universal Time)	Music (feat. Marvin Gaye)	16	cleaned	298429596	Music	4	1.29	223133
20044	Madonna	Celebration (Deluxe Video Edition)	329064696	Celebration (Deluxe Video Edition)	34.99	nan	USA	USD	1	1	nan	music-video	https://video-ssl.itunes.apple.com/itunes-assets/Video126/v4/a9/9b/a6/a99ba6fe-b6ff-7d40-3cd1-a94a4a074448/mzvf_13528336415660615384.640x480.h264lc.U.p.m4v	Pop	Tue Sep 29 2009 07:00:00 GMT+0000 (Coordinated Universal Time)	Music	68	notExplicit	329064769	Music	59	1.99	286687
889327	Shakira	Oral Fixation, Vol. 2 (Expanded Edition)	155658405	Oral Fixation, Vol. 2 (Expanded Edition)	9.99	nan	USA	USD	1	1	True	song	https://audio-ssl.itunes.apple.com/itunes-assets/AudioPreview116/v4/56/0e/48/560e48c8-6200-fe59-4cdb-dff99af51e82/mzaf_14836774711422153362.plus.aac.p.m4a	Pop	Tue Feb 28 2006 08:00:00 GMT+0000 (Coordinated Universal Time)	Hips Don't Lie (feat. Wyclef Jean)	13	notExplicit	155658510	Hips Don't Lie (feat. Wyclef Jean)	3	1.29	218093
4488522	P!nk	The Truth About Love	545398133	The Truth About Love	10.99	nan	USA	USD	1	1	True	song	https://audio-ssl.itunes.apple.com/itunes-assets/AudioPreview125/v4/57/38/52/573852b0-6b53-4b2e-f8d1-857ec7f60632/mzaf_6157346851900450639.plus.aac.p.m4a	Pop	Fri Sep 14 2012 07:00:00 GMT+0000 (Coordinated Universal Time)	Just Give Me a Reason (feat. Nate Ruess)	15	notExplicit	545398139	Just Give Me a Reason (feat. Nate Ruess)	4	1.29	242721
138226712	Fun.	Some Nights	486040153	Some Nights	9.99	Explicit	USA	USD	1	1	True	song	https://audio-ssl.itunes.apple.com/itunes-assets/AudioPreview112/v4/d0/94/0d/d0940d6e-7b4d-ffca-b62c-ae00af05f61c/mzaf_4309929167912355763.plus.aac.p.m4a	Alternative	Tue Feb 21 2012 08:00:00 GMT+0000 (Coordinated Universal Time)	Some Nights	11	explicit	486040194	Some Nights	2	1.29	277040
20044	Madonna	Celebration (Deluxe Version)	329043011	Celebration (Deluxe Version) [Bonus Track]	19.99	nan	USA	USD	1	1	True	song	https://audio-ssl.itunes.apple.com/itunes-assets/AudioPreview116/v4/0f/3c/e4/0f3ce4ed-7b48-7a9c-5252-e19401ba7993/mzaf_12314112352993709534.plus.aac.p.m4a	Pop	Mon Aug 21 2000 07:00:00 GMT+0000 (Coordinated Universal Time)	Music	37	notExplicit	329043268	Music	2	1.29	225813


CREATE TABLE apple_music_dataset (
  "artistid" BIGINT,
  "artistname" VARCHAR,
  "collectioncensoredname" VARCHAR,
  "collectionid" BIGINT,
  "collectionname" VARCHAR,
  "collectionprice" DOUBLE,
  "contentadvisoryrating" VARCHAR,
  "country" VARCHAR,
  "currency" VARCHAR,
  "disccount" BIGINT,
  "discnumber" BIGINT,
  "isstreamable" VARCHAR,
  "kind" VARCHAR,
  "previewurl" VARCHAR,
  "primarygenrename" VARCHAR,
  "releasedate" TIMESTAMP,
  "trackcensoredname" VARCHAR,
  "trackcount" BIGINT,
  "trackexplicitness" VARCHAR,
  "trackid" BIGINT,
  "trackname" VARCHAR,
  "tracknumber" BIGINT,
  "trackprice" DOUBLE,
  "tracktimemillis" BIGINT
);