Books by ISBN-13 (World)

A database of books published across world

Data Structure

author [3,272]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
mediumtext
+ biography (100%)
book [18,392,601]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
text
+ title (99.7%)
varchar(255)
+ author (96.4%)
bigint(20) unsigned
+ author_id (0.2%)
mediumtext
+ author_bio (3.8%)
varchar(255)
+ authors (96.4%)
varchar(255)
+ title_slug (99.7%)
varchar(255)
+ author_slug (96.4%)
varchar(255)
+ isbn13 (100%)
varchar(255)
+ isbn10 (100%)
varchar(255)
+ price (42%)
varchar(255)
+ format (88.1%)
varchar(255)
+ publisher (47.1%)
varchar(255)
+ pubdate (90.1%)
varchar(255)
+ edition (3.7%)
varchar(255)
+ subjects (81%)
varchar(255)
+ lexile (0.2%)
varchar(255)
+ pages (8.7%)
varchar(255)
+ dimensions (6.5%)
mediumtext
+ overview (6.2%)
mediumtext
+ excerpt (0.6%)
text
+ synopsis (4.3%)
mediumtext
+ toc (4%)
mediumtext
+ editorial_reviews (2.3%)
book2subjects [5,471,657]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ book_id (100%)
bigint(20) unsigned
+ sub_subject_id (1%)
bigint(20) unsigned
+ sub_sub_subject_id (99%)
sub_sub_subject [9,770]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ sub_subject_id (100%)
varchar(255)
+ slug (100%)
int(10) unsigned
+ count (99.4%)
sub_subject [850]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ subject_id (100%)
varchar(255)
+ slug (100%)
int(10) unsigned
+ count (12.9%)
subject [57]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)

Description

With each book record uniquely identified by the 13-digits ISBN number, this books database tries to be as comprehensive as it can get, including any books possible. It's mostly comprised of English books but also come with books in other languages as well, e.g. Spanish, French, Italian, German.

Cover images are also available for query and download for about 50% of the books.

Data Profile

Size 21.73G
Tables 6
Last Commit 2017-04-24 00:52:07

Updates / Commits

Time Size Tables Columns Rows
2017-04-24 00:52:07 21.73G 6 51 23878207
2016-08-07 23:27:53 21.73G 6 51 23878207

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
author 3,272 .001 3.272
book 18,392,601 .001 18392.601
book2subjects 5,471,657 .001 5471.657
sub_sub_subject 9,770 .001 9.77
sub_subject 850 .001 0.85
subject 57 .001 0.057
Total Credits 23878.207 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.