Spotify Music Dataset
Popular and Not so popular songs
@kaggle.solomonameh_spotify_music_dataset
Popular and Not so popular songs
@kaggle.solomonameh_spotify_music_dataset
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
);
CREATE TABLE low_popularity_spotify_data (
"time_signature" DOUBLE,
"track_popularity" BIGINT,
"speechiness" DOUBLE,
"danceability" DOUBLE,
"playlist_name" VARCHAR,
"track_artist" VARCHAR,
"duration_ms" DOUBLE,
"energy" DOUBLE,
"playlist_genre" VARCHAR,
"playlist_subgenre" VARCHAR,
"track_href" VARCHAR,
"track_name" VARCHAR,
"mode" DOUBLE,
"uri" VARCHAR,
"type" VARCHAR,
"track_album_release_date" TIMESTAMP,
"analysis_url" VARCHAR,
"id" VARCHAR,
"instrumentalness" DOUBLE,
"track_album_id" VARCHAR,
"playlist_id" VARCHAR,
"track_id" VARCHAR,
"valence" DOUBLE,
"key" DOUBLE,
"tempo" DOUBLE,
"loudness" DOUBLE,
"acousticness" DOUBLE,
"liveness" DOUBLE,
"track_album_name" VARCHAR
);
Anyone who has the link will be able to view this.