Database
Database of 251,940 Poems in 228 Topics
Specific contents of 251,940 poems that were written by 17,557 poets & into 228 topics
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, specific content and submitted date.
Database Statistics
- Size: 311.80 MB
- Tables: 4
- Records: 251,940
- Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)
Database Categories
Database Structure
| Table | Records | Fields |
|---|---|---|
| poem | 251,940 |
|
| poet | 17,557 |
|
| topic | 228 |
|
| topic_to_poem | 75,077 |
|
Content Scope
Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:
topic
- acrostic
- africa
- alone
- america
- angel
- anger
- animal
- anniversary
- april
- august
- autumn
- baby
- ballad
- beach
- beautiful
- beauty
- believe
- birth
- brother
- butterfly
- candy
- car
- cat
- change
- chicago
- child
- childhood
- children
- chocolate
- christmas
- cinderella
- city
- concrete
- couplet
- courage
- crazy
- culture
- dance
- dark
- daughter
- death
- depression
- despair
- destiny
- discrimination
- dog
- dream
- education
- elegy
- epic
- evil
- fairy
- faith
- family
- farewell
- fate
- father
- fear
- fire
- fish
- fishing
- flower
- fog
- food
- football
- freedom
- friend
- frog
- fun
- funeral
- funny
- future
- girl
- god
- golf
- graduate
- graduation
- greed
- green
- grief
- guitar
- haiku
- hair
- happiness
- happy
- hate
- heart
- heaven
- hero
- history
- holocaust
- home
- homework
- honesty
- hope
- horse
- house
- howl
- humor
- hunting
- husband
- identity
- innocence
- inspiration
- irony
- isolation
- january
- journey
- joy
- july
- june
- justice
- kiss
- laughter
- life
- light
- limerick
- london
- lonely
- loss
- lost
- love
- lust
- lyric
- magic
- marriage
- memory
- mentor
- metaphor
- mirror
- mom
- money
- moon
- mother
- murder
- music
- narrative
- nature
- night
- ocean
- october
- ode
- pain
- paris
- passion
- peace
- people
- pink
- poem
- poetry
- poverty
- power
- prejudice
- pride
- purple
- racism
- rain
- rainbow
- rape
- raven
- red
- remember
- respect
- retirement
- river
- romance
- romantic
- rose
- running
- sad
- school
- sea
- september
- shopping
- sick
- silence
- silver
- simile
- sister
- sky
- sleep
- smart
- smile
- snake
- snow
- soccer
- soldier
- solitude
- sometimes
- son
- song
- sonnet
- sorrow
- sorry
- spring
- star
- strength
- success
- suicide
- summer
- sun
- sunset
- sunshine
- swimming
- sympathy
- teacher
- television
- thanks
- tiger
- time
- today
- together
- travel
- tree
- trust
- truth
- valentine
- war
- warning
- water
- weather
- wedding
- wind
- winter
- woman
- women
- work
- world
Miscellaneous
Notes:
- There are 252,045 records that have a title in table poem.
- There are 250,400 records with a populated content field.
- There are 206,735 records that have a populated date field.
- In table poet, there are 17,556 records that have a title.
- There are 16,963 records that have a populated birth address field.
- There are 16,812 records that have a non-empty description field.
Lifetime Updates (fees may apply)
This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.
Other Formats upon Request
We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:
- Microsoft SQL Server
- Microsoft SQL Server Compact Edition
- Oracle
- PostgreSQL
- ODBC
- Interbase / Firebird
- WordPress
- Single Table (multiple tables are combined into one)
- Microsoft Word .DOC
Let us know and we'll see what we can do. Additional fees may apply.