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
  • 238.53 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
  • 232.78 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
  • 224.33 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
  • 239.55 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
  • 253.96 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
  • 231.21 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
  • 251.54 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
  • 246.46 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
  • 240.26 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
  • 224.73 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
  • 238.74 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
  • 226.25 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
  • 231.59 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
  • 85.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
  • 83.99 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
  • 85.78 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
  • 85.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
  • 87.48 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
  • 84.54 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.