Usage & Publication License: database price dollar sign169.00

Database of 251,940 Poems in 228 Topics

Specific contents of 251,940 poems that were written by 17,557 poets & into 228 topics

database structure screenshot of Database of 251,940 Poems in 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.

Related DBs:

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
  1. id
  2. poet_id
  3. title
  4. content
  5. date
poet 17,557
  1. id
  2. title
  3. count
  4. birth_address
  5. description
topic 228
  1. id
  2. title
  3. count
  4. slug
topic_to_poem 75,077
  1. id
  2. topic_id
  3. poem_id

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 - 332
  • africa - 335
  • alone - 280
  • america - 282
  • angel - 276
  • anger - 297
  • animal - 362
  • anniversary - 351
  • april - 307
  • august - 325
  • autumn - 320
  • baby - 337
  • ballad - 369
  • beach - 336
  • beautiful - 330
  • beauty - 293
  • believe - 287
  • birth - 342
  • brother - 325
  • butterfly - 311
  • candy - 348
  • car - 351
  • cat - 310
  • change - 305
  • chicago - 333
  • child - 350
  • childhood - 323
  • children - 351
  • chocolate - 319
  • christmas - 269
  • cinderella - 349
  • city - 360
  • concrete - 370
  • couplet - 284
  • courage - 331
  • crazy - 323
  • culture - 348
  • dance - 340
  • dark - 345
  • daughter - 348
  • death - 297
  • depression - 290
  • despair - 355
  • destiny - 297
  • discrimination - 361
  • dog - 330
  • dream - 293
  • education - 348
  • elegy - 360
  • epic - 366
  • evil - 344
  • fairy - 355
  • faith - 299
  • family - 307
  • farewell - 350
  • fate - 327
  • father - 330
  • fear - 287
  • fire - 331
  • fish - 344
  • fishing - 348
  • flower - 359
  • fog - 328
  • food - 345
  • football - 360
  • freedom - 315
  • friend - 242
  • frog - 340
  • fun - 331
  • funeral - 361
  • funny - 347
  • future - 335
  • girl - 305
  • god - 338
  • golf - 351
  • graduate - 358
  • graduation - 341
  • greed - 344
  • green - 337
  • grief - 353
  • guitar - 364
  • haiku - 310
  • hair - 349
  • happiness - 302
  • happy - 331
  • hate - 272
  • heart - 325
  • heaven - 328
  • hero - 309
  • history - 337
  • holocaust - 363
  • home - 305
  • homework - 343
  • honesty - 345
  • hope - 280
  • horse - 360
  • house - 337
  • howl - 359
  • humor - 360
  • hunting - 367
  • husband - 365
  • identity - 351
  • innocence - 341
  • inspiration - 320
  • irony - 360
  • isolation - 353
  • january - 296
  • journey - 316
  • joy - 354
  • july - 346
  • june - 315
  • justice - 346
  • kiss - 273
  • laughter - 346
  • life - 273
  • light - 338
  • limerick - 354
  • london - 353
  • lonely - 322
  • loss - 363
  • lost - 276
  • love - 276
  • lust - 328
  • lyric - 367
  • magic - 339
  • marriage - 348
  • memory - 343
  • mentor - 365
  • metaphor - 365
  • mirror - 265
  • mom - 316
  • money - 325
  • moon - 360
  • mother - 318
  • murder - 348
  • music - 306
  • narrative - 324
  • nature - 341
  • night - 332
  • ocean - 336
  • october - 306
  • ode - 349
  • pain - 297
  • paris - 337
  • passion - 330
  • peace - 301
  • people - 340
  • pink - 353
  • poem - 346
  • poetry - 311
  • poverty - 365
  • power - 340
  • prejudice - 366
  • pride - 332
  • purple - 346
  • racism - 344
  • rain - 274
  • rainbow - 325
  • rape - 336
  • raven - 345
  • red - 323
  • remember - 263
  • respect - 335
  • retirement - 360
  • river - 356
  • romance - 349
  • romantic - 353
  • rose - 303
  • running - 313
  • sad - 325
  • school - 310
  • sea - 342
  • september - 328
  • shopping - 353
  • sick - 343
  • silence - 275
  • silver - 343
  • simile - 257
  • sister - 318
  • sky - 341
  • sleep - 311
  • smart - 348
  • smile - 282
  • snake - 345
  • snow - 332
  • soccer - 341
  • soldier - 328
  • solitude - 316
  • sometimes - 240
  • son - 352
  • song - 325
  • sonnet - 347
  • sorrow - 332
  • sorry - 188
  • spring - 323
  • star - 340
  • strength - 344
  • success - 354
  • suicide - 296
  • summer - 319
  • sun - 341
  • sunset - 344
  • sunshine - 316
  • swimming - 350
  • sympathy - 364
  • teacher - 334
  • television - 341
  • thanks - 320
  • tiger - 339
  • time - 291
  • today - 312
  • together - 348
  • travel - 345
  • tree - 339
  • trust - 288
  • truth - 310
  • valentine - 288
  • war - 319
  • warning - 354
  • water - 330
  • weather - 356
  • wedding - 355
  • wind - 329
  • winter - 335
  • woman - 337
  • women - 317
  • work - 363
  • world - 344
  • - 0

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.

One Payment, Lifetime Updates

This database is being constantly updated with regards to the volume and 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. You can download the updated version from the Download page by the same credentials we sent to you when you made the purchase, for a lifetime.

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
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries.

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. How many eyes do you have? Use 1, 2, 3, ... to answer.

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.