Nigerian Spotify Music
Weekly data for popular nigerian music
@kaggle.kemdudebobo_nigerian_spotify_music
Weekly data for popular nigerian music
@kaggle.kemdudebobo_nigerian_spotify_music
CREATE TABLE n_2024week22may (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"added_at" TIMESTAMP,
"lyrics" VARCHAR
);
CREATE TABLE n_2024week23jun (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"added_at" TIMESTAMP,
"lyrics" VARCHAR
);
CREATE TABLE n_2024week24jun (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"added_at" TIMESTAMP,
"lyrics" VARCHAR
);
CREATE TABLE n_2024week25jun (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"added_at" TIMESTAMP,
"lyrics" VARCHAR
);
CREATE TABLE n_2024week26jun (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"added_at" TIMESTAMP,
"lyrics" VARCHAR
);
CREATE TABLE n_2024week27jul (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"added_at" TIMESTAMP,
"lyrics" VARCHAR
);
CREATE TABLE n_2024week29jul (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"added_at" TIMESTAMP,
"lyrics" VARCHAR
);
CREATE TABLE n_2024week30jul (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"added_at" TIMESTAMP,
"lyrics" VARCHAR
);
CREATE TABLE n_2024week31aug (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"added_at" TIMESTAMP,
"lyrics" VARCHAR
);
CREATE TABLE n_2024week32aug (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"added_at" TIMESTAMP,
"lyrics" VARCHAR
);
CREATE TABLE n_2024week33aug (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"added_at" TIMESTAMP,
"lyrics" VARCHAR
);
CREATE TABLE n_2024week34aug (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"added_at" TIMESTAMP,
"lyrics" VARCHAR
);
CREATE TABLE n_2024week36sep (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"added_at" TIMESTAMP,
"lyrics" VARCHAR
);
CREATE TABLE n_2024week40oct (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"lyrics" VARCHAR,
"added_at" TIMESTAMP
);
CREATE TABLE n_2024week41oct (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"lyrics" VARCHAR,
"added_at" TIMESTAMP
);
CREATE TABLE n_2024week42oct (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"lyrics" VARCHAR,
"added_at" TIMESTAMP
);
CREATE TABLE n_2024week43oct (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"lyrics" VARCHAR,
"added_at" TIMESTAMP
);
CREATE TABLE n_2024week45nov (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"lyrics" VARCHAR,
"added_at" TIMESTAMP
);
CREATE TABLE n_2024week47nov (
"tid" VARCHAR,
"track" VARCHAR,
"track_url" VARCHAR,
"release_date" TIMESTAMP,
"duration_ms" BIGINT,
"explicit" BOOLEAN,
"track_popularity" BIGINT,
"markets" BIGINT,
"albid" VARCHAR,
"album" VARCHAR,
"album_type" VARCHAR,
"artid" VARCHAR,
"artist" VARCHAR,
"genres" VARCHAR,
"artist_popularity" BIGINT,
"danceability" DOUBLE,
"instrumentalness" DOUBLE,
"speechiness" DOUBLE,
"valence" DOUBLE,
"loudness" DOUBLE,
"lyrics" VARCHAR,
"added_at" TIMESTAMP
);
Anyone who has the link will be able to view this.