Famous Quotes, Sayings & Quotations Database, 176,463 Quotes by 15,753 Famous People

Database Description:

Premium quality famous quotes, sayings and quotations database with over 15,753 authors / sayers and 176,463 quotes from worldwide hall of fame across the entire human history. All the quotes are categorized by author, author nationality (137 nationalities in total) and author profession / type (74 types in total). Nearly 6,000 of the quotes are classified under a topic (68 topics in total). Every quote is identified by 5 - 10 keywords.

Every author record consists of full name, first name, last name, name initials, birthday, birth year, death date, death year, type / profession and nationality.

Database Meta:

• Size: 43.9 MB
• Last updated: Feb. 6th, 2011
• 3 Formats Included: MySQL 5 SQL dump text file, CSV, MS Excel
• Tables: 7

Buy Now & Download: $289.95 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• author

  Records:15,753

  Author table contains all the authors of the quotes with information about each of the quote authors.

  Data fields

  1. id: int(11)
  2. first_initial: char(1)
  3. last_initial: char(1)
  4. name: varchar(255)
  5. first_name: varchar(255)
  6. last_name: varchar(255)
  7. name_slug: varchar(255)
  8. type: varchar(255)
  9. birth_day: varchar(255)
  10. birth_year: varchar(255)
  11. death_day: varchar(255)
  12. death_year: varchar(255)
  13. nationality: varchar(255)

• first_initial

  Records:26

  Initial letter of the first name of the authors.

  Data fields

  1. id: int(11)
  2. first_initial: char(1)
  3. count: int(11)

• last_initial

  Records:26

  Initial letter of the last name of the authors.

  Data fields

  1. id: int(11)
  2. last_initial: char(1)
  3. count: int(11)

• nationality

  Records:137

  All the different nationalities of the quote authors.

  Data fields

  1. id: int(11)
  2. nationality: varchar(255)
  3. count: int(11)

• quote

  Records:176,463

  The quotes table contains all the quotes and sayings. Each quote has several keywords and potentially a topic identified.

  Data fields

  1. id: int(11)
  2. content: text
  3. author: int(11)
  4. topic: varchar(255)
  5. keywords: varchar(255)

• topic

  Records:68

  All the different topics of the quotes and sayings.

  Data fields

  1. id: int(11)
  2. topic: varchar(255)
  3. count: int(11)

• type

  Records:74

  All the different types or professions of the quotation authors.

  Data fields

  1. id: int(11)
  2. type: varchar(255)
  3. count: int(11)

Buy Now & Download: $289.95 (USD)

Prospective Applications / Implementations:

• Famous quotes and sayings site
• Famous people directory / biography site
• Wisdom community enhancement
• Celebrity community enhancement
• Daily quote newsletter
• Merchandise
• ...Order a custom build

Other Available Formats:

After purchase, please contact us for any of the specific data formats listed below and we will send it right away.

• Plain CSV
• CSV for Microsoft Excel
• Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
• Microsoft Word .DOC file (2008, 2007, 2003, 2000)
• LaTeX
• Open Document Spreadsheet
• Open Document Text
• PDF
• XML
• YAML
• WordPress Category / Post Database (Extra $175)
• Single Table Format (Extra $100)