Spotify Multi-Genre Playlists Data
Featuring Spotify's audio features for various songs from various playlists
@kaggle.siropo_spotify_multigenre_playlists_data
Featuring Spotify's audio features for various songs from various playlists
@kaggle.siropo_spotify_multigenre_playlists_data
CREATE TABLE alternative_music_data (
"artist_name" VARCHAR,
"track_name" VARCHAR,
"popularity" BIGINT,
"genres" VARCHAR,
"playlist" VARCHAR,
"danceability" DOUBLE,
"energy" DOUBLE,
"key" BIGINT,
"loudness" DOUBLE,
"mode" BIGINT,
"speechiness" DOUBLE,
"acousticness" DOUBLE,
"instrumentalness" DOUBLE,
"liveness" DOUBLE,
"valence" DOUBLE,
"tempo" DOUBLE,
"id" VARCHAR,
"uri" VARCHAR,
"track_href" VARCHAR,
"analysis_url" VARCHAR,
"duration_ms" BIGINT,
"time_signature" BIGINT
);
CREATE TABLE blues_music_data (
"artist_name" VARCHAR,
"track_name" VARCHAR,
"popularity" BIGINT,
"genres" VARCHAR,
"playlist" VARCHAR,
"danceability" DOUBLE,
"energy" DOUBLE,
"key" BIGINT,
"loudness" DOUBLE,
"mode" BIGINT,
"speechiness" DOUBLE,
"acousticness" DOUBLE,
"instrumentalness" DOUBLE,
"liveness" DOUBLE,
"valence" DOUBLE,
"tempo" DOUBLE,
"id" VARCHAR,
"uri" VARCHAR,
"track_href" VARCHAR,
"analysis_url" VARCHAR,
"duration_ms" BIGINT,
"time_signature" BIGINT
);
CREATE TABLE hiphop_music_data (
"artist_name" VARCHAR,
"track_name" VARCHAR,
"popularity" BIGINT,
"genres" VARCHAR,
"playlist" VARCHAR,
"danceability" DOUBLE,
"energy" DOUBLE,
"key" BIGINT,
"loudness" DOUBLE,
"mode" BIGINT,
"speechiness" DOUBLE,
"acousticness" DOUBLE,
"instrumentalness" DOUBLE,
"liveness" DOUBLE,
"valence" DOUBLE,
"tempo" DOUBLE,
"id" VARCHAR,
"uri" VARCHAR,
"track_href" VARCHAR,
"analysis_url" VARCHAR,
"duration_ms" BIGINT,
"time_signature" BIGINT
);
CREATE TABLE indie_alt_music_data (
"artist_name" VARCHAR,
"track_name" VARCHAR,
"popularity" BIGINT,
"genres" VARCHAR,
"playlist" VARCHAR,
"danceability" DOUBLE,
"energy" DOUBLE,
"key" BIGINT,
"loudness" DOUBLE,
"mode" BIGINT,
"speechiness" DOUBLE,
"acousticness" DOUBLE,
"instrumentalness" DOUBLE,
"liveness" DOUBLE,
"valence" DOUBLE,
"tempo" DOUBLE,
"id" VARCHAR,
"uri" VARCHAR,
"track_href" VARCHAR,
"analysis_url" VARCHAR,
"duration_ms" BIGINT,
"time_signature" BIGINT
);
CREATE TABLE metal_music_data (
"artist_name" VARCHAR,
"track_name" VARCHAR,
"popularity" BIGINT,
"genres" VARCHAR,
"playlist" VARCHAR,
"danceability" DOUBLE,
"energy" DOUBLE,
"key" BIGINT,
"loudness" DOUBLE,
"mode" BIGINT,
"speechiness" DOUBLE,
"acousticness" DOUBLE,
"instrumentalness" DOUBLE,
"liveness" DOUBLE,
"valence" DOUBLE,
"tempo" DOUBLE,
"id" VARCHAR,
"uri" VARCHAR,
"track_href" VARCHAR,
"analysis_url" VARCHAR,
"duration_ms" BIGINT,
"time_signature" BIGINT
);
CREATE TABLE pop_music_data (
"artist_name" VARCHAR,
"track_name" VARCHAR,
"popularity" BIGINT,
"genres" VARCHAR,
"playlist" VARCHAR,
"danceability" DOUBLE,
"energy" DOUBLE,
"key" BIGINT,
"loudness" DOUBLE,
"mode" BIGINT,
"speechiness" DOUBLE,
"acousticness" DOUBLE,
"instrumentalness" DOUBLE,
"liveness" DOUBLE,
"valence" DOUBLE,
"tempo" DOUBLE,
"id" VARCHAR,
"uri" VARCHAR,
"track_href" VARCHAR,
"analysis_url" VARCHAR,
"duration_ms" BIGINT,
"time_signature" BIGINT
);
CREATE TABLE rock_music_data (
"artist_name" VARCHAR,
"track_name" VARCHAR,
"popularity" BIGINT,
"genres" VARCHAR,
"playlist" VARCHAR,
"danceability" DOUBLE,
"energy" DOUBLE,
"key" BIGINT,
"loudness" DOUBLE,
"mode" BIGINT,
"speechiness" DOUBLE,
"acousticness" DOUBLE,
"instrumentalness" DOUBLE,
"liveness" DOUBLE,
"valence" DOUBLE,
"tempo" DOUBLE,
"id" VARCHAR,
"uri" VARCHAR,
"track_href" VARCHAR,
"analysis_url" VARCHAR,
"duration_ms" BIGINT,
"time_signature" BIGINT
);
Anyone who has the link will be able to view this.