ISBN Database of 12.8 Million Books (Title, Author, ISBN, Cover Images and More)

Database Description:

Containing 12.8 million unique books (12.8 million unique ISBN-13 numbers, so there are ABSOLUTELY NO duplicate books in this database) that are categorized by over 10,000 subjects across thousands of disciplines and genres, this books ISBN database comes with 1.01 million unique book cover images (1.01 million JPEG files, 5.8 GB).

Each book record consists of book title, first author, author biography, all authors, ISBN-13 (13-digits ISBN), ISBN-10 (10-digits ISBN), physical format (hardcover, paperback, etc.), publisher, publishing date, edition, synopsis and TOC (table of contents). ONLY the first million books are associated with subjects. And NOT all books have the author biography, synopsis and TOC fields populated. More information about each book can be acquired by querying Amazon Product Advertising API by the ISBN numbers from this books database.

Among the first million records, this database contains about 80,000 unique textbooks which all have cover images. For a better textbooks collection, see this textbooks database.

Database Meta:

• Size: 6348.3 + 5915.0 MB
• Images / Multi-media: Over 1.01 million unique JPEG images, 5.8 GB. File name: covers/{book.isbn13}.jpg
• Last updated: June 22nd, 2011
• Formats Included: MySQL 5 SQL dump text file, CSV, MS Excel
• Tables: 5

Buy Now & Download: $289.95 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• book

  Records:12,772,250

  The books table containing all the books: title, author, ISBN-13, ISBN-10, publisher, release date, etc.

  Data fields

  1. id: int(11)
  2. title: text
  3. author: varchar(255)
  4. author_bio: text
  5. authors: varchar(255)
  6. title_slug: varchar(255)
  7. author_slug: varchar(255)
  8. isbn13: varchar(255)
  9. isbn10: varchar(255)
  10. physical: varchar(255)
  11. publisher: varchar(255)
  12. pubdate: varchar(255)
  13. edition: varchar(255)
  14. synopsis: text
  15. toc: text

• book2subjects

  Records:5,471,657

  Each book is associated with multiple subjects.

  Data fields

  1. id: int(11)
  2. book: int(11)
  3. sub_subject: int(11)
  4. sub_sub_subject: int(11)

• sub_sub_subject

  Records:9,770

  The 3rd tier of topic subjects, children of the 2nd tier subjects.

  Data fields

  1. id: mediumint(9)
  2. title: varchar(255)
  3. sub_subject: smallint(6)
  4. slug: varchar(255)
  5. count: int(11)

• sub_subject

  Records:850

  The 2nd tier of topic subjects, children of the 1st tier subjects.

  Data fields

  1. id: mediumint(9)
  2. title: varchar(255)
  3. subject: smallint(6)
  4. slug: varchar(255)
  5. count: int(11)

• subject

  Records:57

  The 1st tier of topic subjects.

  Data fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)

Buy Now & Download: $289.95 (USD)

Prospective Applications / Implementations:

• Books community site enhancement
• Books directory and information site
• Books search engine
• Books database integration for libraries
• ISBN search engine
• Book search by ISBN number
• ...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)