Poems by Topics

Poems by poets and topics

Data Structure

poem [251,940]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ poet_id (100%)
varchar(255)
+ title (100%)
text
+ content (100%)
varchar(255)
+ date (82.1%)
poet [17,557]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ birth_address (96.6%)
text
+ description (95.8%)
topic [228]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)
topic_to_poem [75,077]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ topic_id (100%)
bigint(20) unsigned
+ poem_id (100%)

Description

From this database, there are 251,940 poems categorized into 228 topics that were written by 17,557 famous poets. Each poem record is comprised of title and content.

Data Profile

Size 455.02M
Tables 4
Last Commit 2016-09-02 03:26:05

Updates / Commits

Time Size Tables Columns Rows
2016-09-02 03:26:05 455.02M 4 21 344802

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
poem 251,940 .001 251.94
poet 17,557 .001 17.557
topic 228 .001 0.228
topic_to_poem 75,077 .001 75.077
Total Credits 344.802 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.