Baselight

Nigerian Spotify Music

Weekly data for popular nigerian music

@kaggle.kemdudebobo_nigerian_spotify_music

Loading...
Loading...

About this Dataset

Nigerian Spotify Music

This is a comprehensive, well documented dataset containing music heard all over Nigeria as well as details on each track. It's a semi-automated ETL pipeline and every week a new csv would be dumped.

Tables

N 2024week22may

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week22may
  • 232.94 KB
  • 391 rows
  • 22 columns
Loading...

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
);

N 2024week23jun

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week23jun
  • 227.32 KB
  • 399 rows
  • 22 columns
Loading...

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
);

N 2024week24jun

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week24jun
  • 219.07 KB
  • 395 rows
  • 22 columns
Loading...

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
);

N 2024week25jun

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week25jun
  • 233.93 KB
  • 409 rows
  • 22 columns
Loading...

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
);

N 2024week26jun

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week26jun
  • 248 KB
  • 402 rows
  • 22 columns
Loading...

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
);

N 2024week27jul

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week27jul
  • 225.79 KB
  • 404 rows
  • 22 columns
Loading...

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
);

N 2024week29jul

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week29jul
  • 245.65 KB
  • 412 rows
  • 22 columns
Loading...

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
);

N 2024week30jul

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week30jul
  • 240.68 KB
  • 413 rows
  • 22 columns
Loading...

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
);

N 2024week31aug

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week31aug
  • 234.63 KB
  • 407 rows
  • 22 columns
Loading...

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
);

N 2024week32aug

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week32aug
  • 219.46 KB
  • 409 rows
  • 22 columns
Loading...

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
);

N 2024week33aug

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week33aug
  • 233.15 KB
  • 413 rows
  • 22 columns
Loading...

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
);

N 2024week34aug

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week34aug
  • 220.95 KB
  • 405 rows
  • 22 columns
Loading...

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
);

N 2024week36sep

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week36sep
  • 226.16 KB
  • 407 rows
  • 22 columns
Loading...

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
);

N 2024week40oct

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week40oct
  • 83.2 KB
  • 403 rows
  • 22 columns
Loading...

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
);

N 2024week41oct

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week41oct
  • 82.02 KB
  • 398 rows
  • 22 columns
Loading...

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
);

N 2024week42oct

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week42oct
  • 83.77 KB
  • 414 rows
  • 22 columns
Loading...

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
);

N 2024week43oct

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week43oct
  • 83.5 KB
  • 413 rows
  • 22 columns
Loading...

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
);

N 2024week45nov

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week45nov
  • 85.43 KB
  • 416 rows
  • 22 columns
Loading...

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
);

N 2024week47nov

@kaggle.kemdudebobo_nigerian_spotify_music.n_2024week47nov
  • 82.56 KB
  • 403 rows
  • 22 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.