Taylor Swift - All Songs & Albums
Lyrics & audio features from the Spotify API for all Taylor's studio album songs
@kaggle.joebeachcapital_taylor_swift_all_songs_and_albums
Lyrics & audio features from the Spotify API for all Taylor's studio album songs
@kaggle.joebeachcapital_taylor_swift_all_songs_and_albums
There are three main datasets:
Information on the audio features in the dataset from Spotify are included in their API documentation.
taylor_album_songs.csv
variable | class | description |
---|---|---|
album_name | character | Album name |
ep | logical | Is it an EP |
album_release | double | Album release date |
track_number | integer | Track number |
track_name | character | Track name |
artist | character | Artists |
featuring | character | Artists featured |
bonus_track | logical | Is it a bonus track |
promotional_release | double | Date of promotional release |
single_release | double | Date of single release |
track_release | double | Date of track release |
danceability | double | Spotify danceability score. A value of 0.0 is least danceable and 1.0 is most danceable. |
energy | double | Spotify energy score. Energy is a measure from 0.0 to 1.0 and represents a perceptual measure of intensity and activity. |
key | integer | The key the track is in. |
loudness | double | Spotify loudness score. The overall loudness of a track in decibels (dB). Loudness values are averaged across the entire track. |
mode | integer | Mode indicates the modality (major or minor) of a track, the type of scale from which its melodic content is derived. Major is represented by 1 and minor is 0. |
speechiness | double | Spotify speechiness score. Speechiness detects the presence of spoken words in a track. The more exclusively speech-like the recording (e.g. talk show, audio book, poetry), the closer to 1.0 the attribute value. |
acousticness | double | Spotify acousticness score. A confidence measure from 0.0 to 1.0 of whether the track is acoustic. 1.0 represents high confidence the track is acoustic. |
instrumentalness | double | Spotify instrumentalness score. Predicts whether a track contains no vocals. The closer the instrumentalness value is to 1.0, the greater likelihood the track contains no vocal content. Values above 0.5 are intended to represent instrumental tracks, but confidence is higher as the value approaches 1.0. |
liveness | double | Spotify liveness score. Detects the presence of an audience in the recording. Higher liveness values represent an increased probability that the track was performed live. A value above 0.8 provides strong likelihood that the track is live. |
valence | double | Spotify valence score. A measure from 0.0 to 1.0 describing the musical positiveness conveyed by a track. Tracks with high valence sound more positive (e.g. happy, cheerful, euphoric), while tracks with low valence sound more negative (e.g. sad, depressed, angry). |
tempo | double | The overall estimated tempo of a track in beats per minute (BPM). In musical terminology, tempo is the speed or pace of a given piece and derives directly from the average beat duration. |
time_signature | integer | An estimated time signature. The time signature (meter) is a notational convention to specify how many beats are in each bar (or measure). The time signature ranges from 3 to 7 indicating time signatures of "3/4", to "7/4". |
duration_ms | integer | The duration of the track in milliseconds. |
explicit | logical | Does the track have explicit lyrics. |
key_name | character | The key the track is in. Integers map to pitches using standard Pitch Class notation. E.g. 0 = C, 1 = C♯/Dâ™, 2 = D, and so on. If no key was detected, the value is -1. |
mode_name | character | Modality of the track. |
key_mode | character | The key of the track. |
lyrics | list | Track lyrics. |
taylor_all_songs.csv
variable | class | description |
---|---|---|
album_name | character | Album name |
ep | logical | Is it an EP |
album_release | double | Album release date |
track_number | integer | Track number |
track_name | character | Track name |
artist | character | Artists |
featuring | character | Artists featured |
bonus_track | logical | Is it a bonus track |
promotional_release | double | Date of promotional release |
single_release | double | Date of single release |
track_release | double | Date of track release |
danceability | double | Spotify danceability score. A value of 0.0 is least danceable and 1.0 is most danceable. |
energy | double | Spotify energy score. Energy is a measure from 0.0 to 1.0 and represents a perceptual measure of intensity and activity. |
key | integer | The key the track is in. |
loudness | double | Spotify loudness score. The overall loudness of a track in decibels (dB). Loudness values are averaged across the entire track. |
mode | integer | Mode indicates the modality (major or minor) of a track, the type of scale from which its melodic content is derived. Major is represented by 1 and minor is 0. |
speechiness | double | Spotify speechiness score. Speechiness detects the presence of spoken words in a track. The more exclusively speech-like the recording (e.g. talk show, audio book, poetry), the closer to 1.0 the attribute value. |
acousticness | double | Spotify acousticness score. A confidence measure from 0.0 to 1.0 of whether the track is acoustic. 1.0 represents high confidence the track is acoustic. |
instrumentalness | double | Spotify instrumentalness score. Predicts whether a track contains no vocals. The closer the instrumentalness value is to 1.0, the greater likelihood the track contains no vocal content. Values above 0.5 are intended to represent instrumental tracks, but confidence is higher as the value approaches 1.0. |
liveness | double | Spotify liveness score. Detects the presence of an audience in the recording. Higher liveness values represent an increased probability that the track was performed live. A value above 0.8 provides strong likelihood that the track is live. |
valence | double | Spotify valence score. A measure from 0.0 to 1.0 describing the musical positiveness conveyed by a track. Tracks with high valence sound more positive (e.g. happy, cheerful, euphoric), while tracks with low valence sound more negative (e.g. sad, depressed, angry). |
tempo | double | The overall estimated tempo of a track in beats per minute (BPM). In musical terminology, tempo is the speed or pace of a given piece and derives directly from the average beat duration. |
time_signature | integer | An estimated time signature. The time signature (meter) is a notational convention to specify how many beats are in each bar (or measure). The time signature ranges from 3 to 7 indicating time signatures of "3/4", to "7/4". |
duration_ms | integer | The duration of the track in milliseconds. |
explicit | logical | Does the track have explicit lyrics. |
key_name | character | The key the track is in. Integers map to pitches using standard Pitch Class notation. E.g. 0 = C, 1 = C♯/Dâ™, 2 = D, and so on. If no key was detected, the value is -1. |
mode_name | character | Modality of the track. |
key_mode | character | The key of the track. |
lyrics | list | Track lyrics. |
taylor_albums.csv
variable | class | description |
---|---|---|
album_name | character | Album name |
ep | logical | Is it an EP |
album_release | double | Album release date |
metacritic_score | integer | Metacritic score |
user_score | double | User score |
CREATE TABLE taylor_albums (
"album_name" VARCHAR,
"ep" BOOLEAN,
"album_release" TIMESTAMP,
"metacritic_score" DOUBLE,
"user_score" DOUBLE
);
CREATE TABLE taylor_album_songs (
"album_name" VARCHAR,
"ep" BOOLEAN,
"album_release" TIMESTAMP,
"track_number" BIGINT,
"track_name" VARCHAR,
"artist" VARCHAR,
"featuring" VARCHAR,
"bonus_track" BOOLEAN,
"promotional_release" TIMESTAMP,
"single_release" TIMESTAMP,
"track_release" TIMESTAMP,
"danceability" DOUBLE,
"energy" DOUBLE,
"key" DOUBLE,
"loudness" DOUBLE,
"mode" DOUBLE,
"speechiness" DOUBLE,
"acousticness" DOUBLE,
"instrumentalness" DOUBLE,
"liveness" DOUBLE,
"valence" DOUBLE,
"tempo" DOUBLE,
"time_signature" DOUBLE,
"duration_ms" DOUBLE,
"explicit" VARCHAR,
"key_name" VARCHAR,
"mode_name" VARCHAR,
"key_mode" VARCHAR,
"lyrics" VARCHAR
);
CREATE TABLE taylor_all_songs (
"album_name" VARCHAR,
"ep" VARCHAR,
"album_release" TIMESTAMP,
"track_number" DOUBLE,
"track_name" VARCHAR,
"artist" VARCHAR,
"featuring" VARCHAR,
"bonus_track" VARCHAR,
"promotional_release" TIMESTAMP,
"single_release" TIMESTAMP,
"track_release" TIMESTAMP,
"danceability" DOUBLE,
"energy" DOUBLE,
"key" DOUBLE,
"loudness" DOUBLE,
"mode" DOUBLE,
"speechiness" DOUBLE,
"acousticness" DOUBLE,
"instrumentalness" DOUBLE,
"liveness" DOUBLE,
"valence" DOUBLE,
"tempo" DOUBLE,
"time_signature" DOUBLE,
"duration_ms" DOUBLE,
"explicit" VARCHAR,
"key_name" VARCHAR,
"mode_name" VARCHAR,
"key_mode" VARCHAR,
"lyrics" VARCHAR
);
Anyone who has the link will be able to view this.