Home Data Arts & Literature Music

982,511 Song Lyrics by 189,842 Artists Database

Name	n3zm_Lyric_songlyrics_com
Data	342.84M (+ 0B)
Tables	4 (+ 0)
Columns	22 (+ 0)
Table Rows	2,718,534 (+ 0)
Media	0B (+ 0B)
Files	0 (+ 0)
Last Commit	2019-09-21 10:40:57 (+ 197 d)

This is a song lyrics database of 982,511 records with title and content in each. All these songs are created by 189,842 artists. These artists are grouped into 27 categories by alphabetical order. This millions of song lyrics database consists of 4 tables.

Data Samples

Main (Desktop) / JSON / XML / Excel / CSV (Download)

Database APIs

http://n3.datasn.io/data/api/v1/n3zm/lyrics_of_song_by_song_artists_6/ (By Table)

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
artist	189,842	title	99.99%
		category_1_id	100%
		artist_info	100%
		category_1	100%
artist_x_song	1,546,154	artist_id	100%
artist_x_song	1,546,154	song_id	100%
category_1	27	title	100%
song	982,511	title	100%
song	982,511	content	46.65%

Notes:

Meta columns id and ts are not shown here, but included in columns total.
Some statistical or memo columns are not shown here, but included in columns total.
Non-empty percentage indicates the percent of values that are non-empty for that particular column.

Media Sets

No media sets.

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2019-09-21 (+ 197 d)	342.84M (+ 0B)	4 (+ 0)	22 (+ 0)	2,718,534 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-03-07 (+ 43 d)	342.84M (+ 0B)	4 (+ 0)	22 (+ 0)	2,718,534 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-01-23 (+ 44 d)	342.84M (+ 0B)	4 (+ 0)	22 (+ 0)	2,718,534 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	342.84M (- 1.72G)	4 (+ 0)	22 (- 2)	2,718,534 (- 547,754)	0B (+ 0B)	0 (+ 0)
2018-11-09 (+ 27 d)	2.05G (+ 1.56G)	4 (+ 0)	24 (+ 0)	3,266,288 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-10-13 (+ 30 d)	504.80M (+ 0B)	4 (+ 0)	24 (+ 0)	3,266,288 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	504.80M (+ 0B)	4 (+ 0)	24 (+ 0)	3,266,288 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	504.80M (+ 0B)	4 (+ 0)	24 (+ 0)	3,266,288 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	504.80M (+ 0B)	4 (+ 0)	24 (+ 0)	3,266,288 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-06-10	504.80M	4	24	3,266,288	0B	0

Download Latest Commit

In the same time, you can also access this data set via API.

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.