Home Data Arts & Literature Poems

7,003 Poems: Author, Content, Year by 148 Themes Database

Data	33.41M (+ 0B)
Tables	3 (+ 0)
Columns	18 (+ 0)
Table Rows	22,009 (+ 0)
Media	0B (+ 0B)
Files	0 (+ 0)
Last Commit	2019-01-23 10:53:39 (+ 44 d)

This is a collection of poems with 7,003 records. All these poems are sorted by 148 themes, such as afterlife, aging, anxiety,body, creation, drugs, flight, family, hope, love, etc. Each poem has title, year, about this poem, poem content and author. The whole poems database has 3 tables.

Data Samples

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

Database APIs

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

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
poem	7,003	title	100%
		year	99.59%
		about_this_poem	99.97%
		poem_content	99.84%
		author	99.99%
theme	148	title	100%
theme_x_poem	14,858	theme_id	100%
theme_x_poem	14,858	poem_id	100%

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-01-23 (+ 44 d)	33.41M (+ 0B)	3 (+ 0)	18 (+ 0)	22,009 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	33.41M (+ 0B)	3 (+ 0)	18 (+ 0)	22,009 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-11-09 (+ 27 d)	33.41M (+ 13.64M)	3 (+ 0)	18 (+ 0)	22,009 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-10-13 (+ 30 d)	19.77M (+ 0B)	3 (+ 0)	18 (+ 0)	22,009 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	19.77M (+ 0B)	3 (+ 0)	18 (+ 0)	22,009 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	19.77M (+ 0B)	3 (+ 0)	18 (+ 0)	22,009 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	19.77M (+ 0B)	3 (+ 0)	18 (+ 0)	22,009 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-06-10 (+ 31 d)	19.77M (+ 0B)	3 (+ 0)	18 (+ 0)	22,009 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-05-10 (+ 28 d)	19.77M (+ 0B)	3 (+ 0)	18 (+ 0)	22,009 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-04-11 (+ 38 d)	19.77M (+ 0B)	3 (+ 0)	18 (+ 0)	22,009 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-03-03	19.77M	3	18	22,009	0B	0

Download Latest Commit

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

Request Access

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to generate 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. Make 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.