Database
ISBN Database of 18.4 Million Library Books (Title, Author, ISBN, Cover Images)
Download Library Books Database with ISBN, Title, Author, Price, Format, Publisher, Edition, and 8.9 Million Covers
Description: This ISBN database has 18.4 million unique book titles and 8.9 million cover images in JPEG files. It is the ultimate library books / ISBN database on the entire Internet, growing by thousands every day (updates are released every 6 or 12 months). From the first version with a humble 4 million titles in 2009, after 5 major upgrades, it currently holds 18.4 million book titles with over 20 data fields for each of them, no inferior to the in-house databases of Google's or Amazon's.
There are also over 8.9 million book cover images (230 GB in download size) and 3,274 author icon images included in the attachment, named after the 13-digits ISBN of the book such as 9780123456789.jpg. Check out some samples.
There are 3,272 authors identified in the author table with a name and a biography for each of them. The 1st million books from the book table are associated with subjects (sub_subject, sub_sub_subject), while the rest of the books have their own subjects field containing the subjects of the book.
You will immediately be able to download the database files after purchase, but NOT the images package. Due to its massive size (that's growing!), we will prepare the images package for download within 8 hours to 2 days and send it your way. Should you be in a hurry, contact us.
Database Statistics
- Size: 13.10 GB
- Tables: 6
- Records: 18,392,601
- Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)
Database Categories
Images Statistics
- Images: 224.27G
- Dimensions: 300 x 450 on average
- Image formats: JPEG
- Images count: 8,880,949
- Reference field: isbn13
Database Structure
| Table | Records | Fields |
|---|---|---|
| author | 3,272 |
|
| book | 18,392,601 |
|
| book2subjects | 5,471,657 |
|
| subject | 57 |
|
| sub_subject | 850 |
|
| sub_sub_subject | 9,770 |
|
Database Attachments
Images: This database is attached with 8,880,949 images. See them under the Attachments tab.
Content Scope
Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:
subject
- Fiction Books & Literature
- Graphic Novels
- Horror
- Mystery & Crime
- Poetry
- Romance Books
- Science Fiction & Fantasy
- Thrillers
- Westerns
- Ages 0-2
- Ages 3-5
- Ages 6-8
- Ages 9-12
- Teens
- Children's Books
- African Americans
- Antiques & Collectibles
- Art, Architecture & Photography
- Bibles & Bible Studies
- Biography
- Business Books
- Christianity
- Computer Books & Technology Books
- Cookbooks, Food & Wine
- Crafts & Hobbies Books
- Education & Teaching
- Engineering
- Entertainment
- Foreign Languages
- Game Books
- Gay & Lesbian
- Health Books, Diet & Fitness Books
- History
- Home & Garden
- Humor Books
- Judaism & Judaica
- Law
- Medical Books
- New Age & Spirituality
- Nonfiction
- Parenting & Family
- Pets
- Philosophy
- Political Books & Current Events Books
- Psychology & Psychotherapy
- Reference
- Religion Books
- Science & Nature
- Self Improvement
- Sex & Relationships
- Social Sciences
- Sports & Adventure
- Study Guides & Test Prep
- Travel
- True Crime
- Weddings
- Women's Studies
Miscellaneous
Notes:
- 100% of the books have ISBN-13.
- 100% of the books have ISBN-10.
- There are 17,771,949 records (96.6%) with a non-empty author field or a non-empty authors field.
- There are 7,729,844 records with a non-empty price field.
- There are 16,209,875 records with a non-empty format field.
- There are 8,669,295 records with a non-empty publisher field.
- There are 16,576,965 records with a non-empty pubdate field.
- There are 14,899,214 records with a non-empty subjects field.
- There are 33,942 records with a non-empty lexile field.
- There are 1,600,151 records with a non-empty pages field.
- There are 1,193,154 records with a non-empty dimensions field.
- There are 1,147,614 records with a non-empty overview field.
- There are 114,463 records with a non-empty excerpt field.
- There are 797,122 records with a non-empty synopsis field.
- There are 728,839 records with a non-empty toc field.
- There are 416,508 records with a non-empty editorial_reviews field.
Defects:
- Not all but about 8.88 million distinct book cover images are available as of this version. We are working to get more.
- Only 3,272 authors are identified in the author table as of this version. However, there are 17,771,949 book records (96.6%) with a non-empty author field or a non-empty authors field in the book table.
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.