This tremendous books database is filled with 5,049,667 records by 59 categories, such as Folklore & Mythology, General Fiction, Historical Fiction, Literature, etc.
Each book has title, ISBN, contributor, description, table of contents, review quote, pages, dimensions, publication date, publisher, publication city country, language, illustrations note, format, sale price, list price, etc. These books are written by 55,494 authors. There are 2,528,378 files of these book images in the 45.92G media set.
The whole books ISBNs data set consists of 11 tables.
| Name | n3a2_bookdepository_com |
|---|---|
| Data | 5.26G (+ 259M) |
| Tables | 11 (+ 0) |
| Columns | 85 (+ 0) |
| Table Rows | 13,514,061 (+ 0) |
| Media | 45.92G (+ 0B) |
| Files | 2,528,378 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| author | 55,494 | title |
100%
|
| content |
0%
|
||
| book | 5,049,667 | title |
100%
|
| isbn_13 |
99.85%
|
||
| contributor |
92.82%
|
||
| description |
3.19%
|
||
| table_of_contents |
0.35%
|
||
| review_quote |
0.36%
|
||
| pages |
3.33%
|
||
| dimensions |
3.06%
|
||
| publication_date |
3.62%
|
||
| publisher |
3.62%
|
||
| publication_city_country |
1.69%
|
||
| language |
1.56%
|
||
| edition_statement |
0.47%
|
||
| illustrations_note |
1.04%
|
||
| isbn_10 |
1.82%
|
||
| bestsellers_rank |
1.9%
|
||
| rating_value |
0.91%
|
||
| sale_price |
2.77%
|
||
| list_price |
0.44%
|
||
| about_author |
1.89%
|
||
| format |
3.71%
|
||
| imprint |
0.49%
|
||
| bnid |
0.14%
|
||
| format_2 |
0.16%
|
||
| file_size |
0.16%
|
||
| book_x_author | 96,075 | book_id |
100%
|
| author_id |
100%
|
||
| book_x_subcategory | 136,943 | book_id |
100%
|
| subcategory_id |
100%
|
||
| category | 59 | category |
100%
|
| category_1 | 35 | title |
100%
|
| content |
0%
|
||
| category_2 | 317 | title |
100%
|
| category_1_id |
100%
|
||
| category_1 |
100%
|
||
| content |
0%
|
||
| category_3 | 1,364 | title |
100%
|
| category_2_id |
100%
|
||
| category_2 |
100%
|
||
| category_1 |
100%
|
||
| category_3_x_book | 8,173,253 | category_3_id |
100%
|
| book_id |
100%
|
||
| subcategory | 854 | subcategory |
100%
|
| category |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
BOOK_IMAGE
| Size (Bytes) | Files |
|---|---|
| 45.92G | 2,528,378 |
