1,330,275 Library Books Database with Amazon ISBN in 4,364 Categories and 77,128 Subjects

Database Description:

1.3 million books is enough for any decent library, especially online ones. This database contains fully accountable information of 1.3 million books with book title, book author, book publisher and press, publish year, ISBN, DDC, LCC and Edition. There are in total more than 4,000 book categories in 5 tiers and a further 77,000 subjects to categorize and classify all the books. Each book is then assigned to one or more of the book subjects.

Here's a much bigger ISBN database and a textbooks database. It contains all the books from this database, except for the subjects.

Database Meta:

• Size: 608.9 MB
• Last updated: Aug. 2nd, 2010
• 3 Formats Included: MySQL 5 SQL dump text file, CSV, MS Excel
• Tables: 3

Buy Now & Download: $49.95 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• book

  Records:1,330,275

  Books table with 1.3 million book records. The content field includes book author, publish date, ISBN, DDC, LCC and so forth, delimited by br tag. The information regarding the publisher is in the publisher field.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. content: text
  5. subject: mediumint(9)
  6. isbn: varchar(255)
  7. publisher: text

• category

  Records:4,364

  Table of book categories. Parent field indicates the parent category in the same table (this one).

  Data fields

  1. id: mediumint(6)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. parent: mediumint(9)

• subject

  Records:77,128

  Table of book subjects of which each one falls into one of the categories in category table.

  Data fields

  1. id: mediumint(9)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. category: mediumint(9)

Buy Now & Download: $49.95 (USD)

Prospective Applications / Implementations:

• Online library site
• All-around book community / information site
• Books search engine or directory
• Book ecommerce / market site
• Book store
• Amazon affiliate book store
• ...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)