Baselight
Sign In

Spotify Song Attributes

"Harmonizing the Hits: Analyzing the Spotify Song Attributes Dataset"

@kaggle.byomokeshsenapati_spotify_song_attributes

Spotify Song Attributes
@kaggle.byomokeshsenapati_spotify_song_attributes.spotify_song_attributes

  • 949.14 KB
  • 10080 rows
  • 22 columns
trackname

TrackName

artistname

ArtistName

msplayed

MsPlayed

genre

Genre

danceability

Danceability

energy

Energy

key

Key

loudness

Loudness

mode

Mode

speechiness

Speechiness

acousticness

Acousticness

instrumentalness

Instrumentalness

liveness

Liveness

valence

Valence

tempo

Tempo

type

Type

id

Id

uri

Uri

track_href

Track Href

analysis_url

Analysis Url

duration_ms

Duration Ms

time_signature

Time Signature

"Honest"Nico Collins191772nan0.4760.7994-4.9390.2120.01620.2570.577162.139audio_features7dTxqsaFGHOXwtzHINjfHvspotify:track:7dTxqsaFGHOXwtzHINjfHvhttps://api.spotify.com/v1/tracks/7dTxqsaFGHOXwtzHINjfHvhttps://api.spotify.com/v1/audio-analysis/7dTxqsaFGHOXwtzHINjfHv1919484
"In The Hall Of The Mountain King" from Peer Gynt Suite N°1, Op. 46London Symphony Orchestra1806234british orchestra0.4750.137-17.71910.0510.9160.9560.1010.122112.241audio_features14Qcrx6Dfjvcj0H8oV8oUWspotify:track:14Qcrx6Dfjvcj0H8oV8oUWhttps://api.spotify.com/v1/tracks/14Qcrx6Dfjvcj0H8oV8oUWhttps://api.spotify.com/v1/audio-analysis/14Qcrx6Dfjvcj0H8oV8oUW1508274
#BrooklynBloodPop!SyKo145610glitchcore0.6910.8141-3.7880.1170.01640.3660.509132.012audio_features7K9Z3yFNNLv5kwTjQYGjnuspotify:track:7K9Z3yFNNLv5kwTjQYGjnuhttps://api.spotify.com/v1/tracks/7K9Z3yFNNLv5kwTjQYGjnuhttps://api.spotify.com/v1/audio-analysis/7K9Z3yFNNLv5kwTjQYGjnu1456114
$10Good Morning25058experimental pop0.6240.5964-9.80410.03140.4750.2030.1190.896120.969audio_features3koAwrM1RO0TGMeQJ3qt9Jspotify:track:3koAwrM1RO0TGMeQJ3qt9Jhttps://api.spotify.com/v1/tracks/3koAwrM1RO0TGMeQJ3qt9Jhttps://api.spotify.com/v1/audio-analysis/3koAwrM1RO0TGMeQJ3qt9J895094
(I Just) Died In Your ArmsCutting Crew5504949album rock0.6250.72611-11.4020.04440.01580.0001690.06250.507124.945audio_features4ByEFOBuLXpCqvO1kw8Wdmspotify:track:4ByEFOBuLXpCqvO1kw8Wdmhttps://api.spotify.com/v1/tracks/4ByEFOBuLXpCqvO1kw8Wdmhttps://api.spotify.com/v1/audio-analysis/4ByEFOBuLXpCqvO1kw8Wdm2804004
(L)only Childsalem ilese2237969alt z0.6450.6118-5.9250.1370.290.00002050.2370.645157.475audio_features22lJaG2yxlSjIwdUIddcFkspotify:track:22lJaG2yxlSjIwdUIddcFkhttps://api.spotify.com/v1/tracks/22lJaG2yxlSjIwdUIddcFkhttps://api.spotify.com/v1/audio-analysis/22lJaG2yxlSjIwdUIddcFk1444683
(lol)Eren Cannata441335guitar case0.6630.9047-4.7110.08570.0007080.2890.3410.675118.024audio_features4DS2UXeR2V5W7R9aype6t1spotify:track:4DS2UXeR2V5W7R9aype6t1https://api.spotify.com/v1/tracks/4DS2UXeR2V5W7R9aype6t1https://api.spotify.com/v1/audio-analysis/4DS2UXeR2V5W7R9aype6t12176274
-Interlude-NF70589nannannannannannan
...And to Those I Love, Thanks for Sticking Around$uicideboy$120005cloud rap0.7920.5112-6.87610.04090.1240.00009040.140.111113.983audio_features30QR0ndUdiiMQMA9g1PGCmspotify:track:30QR0ndUdiiMQMA9g1PGCmhttps://api.spotify.com/v1/tracks/30QR0ndUdiiMQMA9g1PGCmhttps://api.spotify.com/v1/audio-analysis/30QR0ndUdiiMQMA9g1PGCm1684904
...Baby One More TimeBritney Spears107407dance pop0.7590.699-5.7450.03070.2020.0001310.4430.90792.96audio_features3MjUtNVVq3C8Fn0MP3zhXaspotify:track:3MjUtNVVq3C8Fn0MP3zhXahttps://api.spotify.com/v1/tracks/3MjUtNVVq3C8Fn0MP3zhXahttps://api.spotify.com/v1/audio-analysis/3MjUtNVVq3C8Fn0MP3zhXa2110674

CREATE TABLE spotify_song_attributes (
  "trackname" VARCHAR,
  "artistname" VARCHAR,
  "msplayed" BIGINT,
  "genre" VARCHAR,
  "danceability" DOUBLE,
  "energy" DOUBLE,
  "key" DOUBLE,
  "loudness" DOUBLE,
  "mode" DOUBLE,
  "speechiness" DOUBLE,
  "acousticness" DOUBLE,
  "instrumentalness" DOUBLE,
  "liveness" DOUBLE,
  "valence" DOUBLE,
  "tempo" DOUBLE,
  "type" VARCHAR,
  "id" VARCHAR,
  "uri" VARCHAR,
  "track_href" VARCHAR,
  "analysis_url" VARCHAR,
  "duration_ms" DOUBLE,
  "time_signature" DOUBLE
);