1942-2015 Car Auto Parts Catalog Data by Make, Year, Model, Trim/Engine & Brand w/ Images

Database Description:

This auto parts catalog data set (4th edition) is comprised of a 15.8 GB database (MySQL or CSV) of over 1.7 million vehicle car parts of 68 makes from year 1942 to 2015, in 12 highly structural data tables, and a package of 1,702,044 JPEG part image files of a total download size of 30.4 GB. You can search or browse parts by:

1. Make (68) + Year (74) => Model (22,603) => Trim / Submodel (43,921) => Engine (74,205) => Part (1,708,530)
2. Brand (765) => Part (1,708,530)

Each part has a part number (100%), manufacturer number (100%), list price (100%), text description (100%), fits (97.5%), JSON specifications (100%) with more than 700 different properties / attributes, such as Product Fit (90.5%), Warranty (82.9%), Notes (47.4%), Fit Note (43.9%), Color / Finish, Material, Series, Design, Position, and Recommended Use.

Each part has a thumbnail picture in the part images package with a total of over 1.7 million part image photos referenced by part.id. Car parts data records in the database are organized by car makes, years, models, sub-models / trims, engines and part brands.

Parts included: Accessory, Air Intake, Body Electrical, Body Mechanical & Trim, Brake, Car Care, Climate Control, Clutch, Cooling System, Driveshaft & Axle, Engine Electrical & Mechanical, Exhaust, Fuel Delivery, Interior Styling, Steering, Suspension, Tires & Wheels, and Transmission.

Category tables, namely `category`, `category_sub`, and `category_sub_sub` are NOT associated with the other tables for now.

For latest auto parts data, please go to our data warehouse automotive category https://datasn.io/p/155 which has all the car makes, models and referenced parts for the North America market, available as JSON APIs but no downloads.

Database Meta:

• Size: 15.8 GB + 30.4 GB
• Images / Multi-media: 1,702,044 JPEG image files, 30.4 GB. File name: ab/cd/{part.id}.jpg (abcd = last 4 digits of file name, e.g. 888abcd.jpg)
• Last updated: Jan. 3rd, 2015
• Formats Included: MySQL 5 SQL dump text file, CSV, MS Excel
• Tables: 12

Buy Now & Download: $489.95 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• brand

  Records:765

  Brands of auto parts

  Data fields

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

• category

  Records:8

  Top categories

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• category_sub

  Records:158

  Secondary categories

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. category_id: int(11)

• category_sub_sub

  Records:1,540

  Tertiary categories

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. category_sub_id: int(11)

• engine

  Records:74,205

  Different engines of automobiles

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. submodel_id: int(11)
  4. make: varchar(255)
  5. year: char(4)
  6. model: varchar(255)
  7. submodel: varchar(255)
  8. num_parts: int(10) unsigned

• engine2part

  Records:117,229,740

  Association table of auto engines and auto parts

  Data fields

  1. id: int(11)
  2. part_id: int(11)
  3. engine_id: int(11)

• make

  Records:68

  Automobile makes

  Data fields

  1. id: int(10) unsigned
  2. title: varchar(255)
  3. num_parts: int(10) unsigned

• make2year

  Records:2,978

  Association table of auto makes and auto years

  Data fields

  1. id: int(11)
  2. make: varchar(255)
  3. year: char(4)

• model

  Records:22,603

  Different models of automobile makes

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. make2year_id: int(11)
  4. make: varchar(255)
  5. year: char(4)

• part

  Records:1,708,530

  Primary table containing all the automobile parts

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. part_number: varchar(255)
  4. manufacturer_number: varchar(255)
  5. list_price: varchar(255)
  6. universal_part: tinyint(1)
  7. brand_title: varchar(255)
  8. brand_id: int(10) unsigned
  9. description: mediumtext
  10. fits: text
  11. specifications_json: text
  12. Quantity_Sold: varchar(255)
  13. Product_Fit: varchar(255)
  14. Warranty: varchar(255)
  15. Color_Finish: varchar(255)
  16. Material: varchar(255)
  17. Location: varchar(255)
  18. Series: varchar(255)
  19. Notes: text
  20. Seat_Type: varchar(255)
  21. Fit_Note: text
  22. Design: varchar(255)
  23. Position: varchar(255)
  24. Type: varchar(255)
  25. Row: varchar(255)
  26. Recommended_Use: varchar(255)
  27. Vehicle_Body_Type: varchar(255)
  28. Construction: varchar(255)
  29. Kit_Type: varchar(255)

• submodel

  Records:43,921

  Sub-models or trims of auto models

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. model_id: int(11)
  4. make: varchar(255)
  5. year: char(4)
  6. model: varchar(255)

• year

  Records:74

  Year of automobile production

  Data fields

  1. id: int(11)
  2. title: char(4)
  3. num_parts: int(10) unsigned

Buy Now & Download: $489.95 (USD)

Potential Applications / Usage:

• New & used auto parts online shopping store / affiliate site
• Aftermarket automobile / automotive related website / wholesale manufacturer
• Automobile repair service site
• Automobile information site / community enhancement
• Auto body parts directory lookup and reference

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