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

Database Description:

This United States auto parts catalog data set (5th edition, 2021) is comprised of a 13.8 GB database (MySQL or CSV) with 521,648 vehicle car parts of 59 makes from year 1985 to 2021 by 5,698 part categories and 217 manufacturer brands, in 16 related data tables. Media assets are 520,830 high resolution part images (123.2 GB, about 247KB per JPEG image) and 5,336 part category image files.

You can search parts by:

1. Year (37) + Make (1,608) => Model (17,299) => Trim / Submodel (41,064) => Engine (63,076) => Part (521,648)
2. Brand (217) => Part (521,648) 3. Category 1 (8) => Category 2 (158) => Category 3 (5,698) => Part (521,648)

Each part has one or more part numbers (100%), manufacturer number (100%), text description (99.9%), part name (100%), brand (100%), categories 1 / 2 / 3 (100%), list prices (100%), part images (99.8%), part title (99.9%), fit notes (96.8%), and part attributes (99.4%) with 642 unique attributes, of which the most are: Warranty (94.8%), Location (62.0%), Product Fit (51.8%), Series (49.5%), Recommended Use (45.9%), Prop 65 Warning (42.8%), Notes (35.2%), Replaces OE Number (28.7%), Material (25.8%), Type (20.9%), Interchange Part Number (20.7%), Color Finish (19.5%), Returns Policy (19.4%), Condition (15.8%), Replaces Partslink Number (15.1%), Color/Finish (9.6%), Design (9.3%), Components (8.7%), Includes (6.8%).

Each part has a large no-watermark catalog photo picture referenced by part.id to part_image.part_id. Car parts data in the database are organized by car makes, years, models, sub-models / trims, engines and part brands.

Top categories: Auto Body Parts & Mirrors (50,206), Headlights & Lighting (21,442), Engine & Drivetrain (188,010), Brakes, Suspension & Steering (143,562), Interior Accessories (55,935), Exterior Accessories (60,595), Wheels (296), Tools & Garage (1,602).

Sub categories with over 10,000 distinct parts: Brake Discs, Pads & Calipers (51,685), Seats, Seat Covers & Accessories (27,089), Heating, Air Conditioning & Components (26,049), Radiators, Fans, Cooling Systems & Components (19,954), Shocks, Struts & Components (18,820), Bumpers & Components (18,381), Cams, Timing & Valvetrain (17,025), Control Arms, Thrust Arms & Components (16,194), Cranks, Pistons, Oil & Components (14,558), Air Filters & Intake Systems (13,660), Axles, Driveshaft & 4WD (12,316), Fuel Systems & Components (11,607), Exhaust, Headers, Manifolds Mufflers & Components (11,466), Tie Rods, Steering Racks, Gearboxes & Components (10,641)

The 4th and the 3rd edition of this database are also included in the order for you to download after payment.

Database Meta:

• Size: 13.8 GB + 123.2 GB
• Images / Multi-media: 520,830 JPEG image files, 123.2 GB. File path: {part_image.path} by {part_image.part_id} to {part.id}
• Last updated: Aug. 28th, 2021
• Formats Included: MySQL dump .sql text file, CSV for MS Excel
• Tables: 16

Buy Now & Download: $595.95 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• brand

  Records:217

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. title: varchar(255)
  4. slug: varchar(255)
  5. count_parts: int(10) unsigned

• category_1

  Records:8

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. title: varchar(255)
  4. slug: varchar(255)
  5. count_parts: int(10) unsigned

• category_1_image

  Records:8

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. source_content_type: varchar(255)
  4. hash_file_content: varchar(255)
  5. size: bigint(20) unsigned
  6. path: varchar(2047)
  7. title: varchar(255)
  8. category_1_id: bigint(20) unsigned

• category_2

  Records:158

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. title: varchar(255)
  4. slug: varchar(255)
  5. category_1_id: bigint(20) unsigned
  6. count_parts: int(10) unsigned

• category_2_image

  Records:145

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. source_content_type: varchar(255)
  4. hash_file_content: varchar(255)
  5. size: bigint(20) unsigned
  6. path: varchar(2047)
  7. title: varchar(255)
  8. category_2_id: bigint(20) unsigned

• category_3

  Records:5,698

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. title: varchar(255)
  4. slug: varchar(255)
  5. category_2_id: bigint(20) unsigned
  6. count_parts: int(10) unsigned

• category_3_image

  Records:5,183

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. source_content_type: varchar(255)
  4. hash_file_content: varchar(255)
  5. size: bigint(20) unsigned
  6. path: varchar(2047)
  7. title: varchar(255)
  8. category_3_id: bigint(20) unsigned

• engine

  Records:63,076

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. cylinders: varchar(255)
  4. liter: varchar(255)
  5. year: varchar(255)
  6. make: varchar(255)
  7. model: varchar(255)
  8. submodel: varchar(255)
  9. submodel_id: bigint(20) unsigned
  10. count_parts: int(10) unsigned

• make

  Records:1,608

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. title: varchar(255)
  4. slug: varchar(255)
  5. year: varchar(255)
  6. year_id: bigint(20) unsigned
  7. count_parts: int(10) unsigned

• model

  Records:17,299

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. title: varchar(255)
  4. slug: varchar(255)
  5. year: varchar(255)
  6. make: varchar(255)
  7. make_id: bigint(20) unsigned
  8. count_parts: int(10) unsigned

• part

  Records:521,648

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. part_number: varchar(255)
  4. manufacturer_number: varchar(255)
  5. description: mediumtext
  6. part_name: varchar(255)
  7. brand: varchar(255)
  8. brand_id: bigint(20) unsigned
  9. category_1: varchar(255)
  10. category_2: varchar(255)
  11. category_3: varchar(255)
  12. category_1_id: bigint(20) unsigned
  13. category_2_id: bigint(20) unsigned
  14. category_3_id: bigint(20) unsigned
  15. is_universal: varchar(255)
  16. price_regular: decimal(10,2) unsigned
  17. price_list: decimal(10,2) unsigned
  18. price_shipping: decimal(10,2) unsigned
  19. price_handling: decimal(10,2) unsigned
  20. price_special: decimal(10,2) unsigned
  21. price_core: decimal(10,2) unsigned
  22. part_title: varchar(255)
  23. part_attributes: mediumtext
  24. is_best_seller: varchar(255)
  25. is_made_to_order: varchar(255)
  26. fit_notes: mediumtext

• part_image

  Records:520,830

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. source_content_type: varchar(255)
  4. hash_file_content: varchar(255)
  5. size: bigint(20) unsigned
  6. path: varchar(2047)
  7. title: varchar(255)
  8. part_id: bigint(20) unsigned

• submodel

  Records:41,064

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. title: varchar(255)
  4. slug: varchar(255)
  5. year: varchar(255)
  6. make: varchar(255)
  7. model: varchar(255)
  8. model_id: bigint(20) unsigned
  9. count_parts: int(10) unsigned

• vehicle

  Records:63,076

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. year: varchar(255)
  4. make: varchar(255)
  5. model: varchar(255)
  6. submodel: varchar(255)
  7. cylinders: varchar(255)
  8. liter: varchar(255)
  9. year_id: bigint(20) unsigned
  10. make_id: bigint(20) unsigned
  11. model_id: bigint(20) unsigned
  12. submodel_id: bigint(20) unsigned
  13. engine_id: bigint(20) unsigned
  14. _url: varchar(255)
  15. count_parts: int(10) unsigned

• vehicle_x_part

  Records:84,796,836

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. vehicle_id: bigint(20) unsigned
  4. part_id: bigint(20) unsigned

• year

  Records:37

  Data fields

  1. id: bigint(20) unsigned
  2. ts: timestamp
  3. title: varchar(255)
  4. slug: varchar(255)

Buy Now & Download: $595.95 (USD)

Potential Applications / Usage:

• Auto parts inventory management software
• 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