213,589 College Textbooks Database by Course, Department, University

Database Description:

This is the 4th edition of our college textbooks database that comes with 213,589 latest textbooks (213,589 unique isbn13) for colleges, universities and institutions across United States and Canada. All the books are finely indexed by course (548,042), department (47,799), university (700), and state / province (56) in North America. Each textbook record has title, author, isbn13 (213,589 unique isbn13), isbn10, publisher, format cover, price, and description.

This database also comes with 176,312 JPG cover images for the textbooks, a total of about 6.3 GB in size.

Database Meta:

• Size: 385.80 + 6300 MB
• Images / Multi-media: 176,312 JPEG image files, 6300 MB. File name: {textbook.id}.jpg
• Last updated: Dec. 20th, 2012
• Formats Included: MySQL dump .sql text file, CSV, MS Excel
• Tables: 7

Buy Now & Download: $239.00 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• course

  Records:548,042

  The courses table.

  Data fields

  1. id: int(10) unsigned
  2. title: varchar(120)
  3. count: int(11)
  4. slug: varchar(120)

• course_to_textbook

  Records:968,231

  Relationships table between courses and textbooks.

  Data fields

  1. id: int(10) unsigned
  2. course_id: int(11)
  3. textbook_id: int(11)

• department

  Records:47,799

  All the departments in all the universities.

  Data fields

  1. id: int(10) unsigned
  2. university_id: int(11)
  3. title: varchar(120)
  4. count: int(11)
  5. slug: varchar(120)

• department_to_course

  Records:530,870

  Relationships table between departments and courses.

  Data fields

  1. id: int(10) unsigned
  2. department_id: int(11)
  3. course_id: int(11)

• state_province

  Records:56

  States in US and provinces in Canada.

  Data fields

  1. id: int(10) unsigned
  2. title: varchar(255)
  3. count: int(11)
  4. slug: varchar(255)

• textbook

  Records:213,589

  The textbooks table.

  Data fields

  1. id: int(10) unsigned
  2. course_id: int(11)
  3. title: varchar(255)
  4. author: varchar(255)
  5. isbn13: varchar(255)
  6. isbn10: varchar(255)
  7. publisher: varchar(255)
  8. type: varchar(255)
  9. price: varchar(255)
  10. description: text

• university

  Records:700

  All the universities and colleges in US and Canada.

  Data fields

  1. id: int(10) unsigned
  2. state_province_id: int(11)
  3. title: varchar(120)
  4. count: int(11)
  5. slug: varchar(120)

Buy Now & Download: $239.00 (USD)

Potential Applications / Usage:

• New & used textbooks marketplace
• College textbooks information site / book store
• Textbooks (ISBN) search engine
• College study clubs
• Amazon book affiliate / associate program site

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

• 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
• Single Table Format