Lifetime updates. Come back once in a while to stay updated of new versions of this database.
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:
Buy Now & Download: $489.95 (USD)
phpMyAdmin Screenshots:
Table Details (Data Structure / Schema):
-
brand
Records:765Brands of auto parts
Data fields
- id: int(10) unsigned
- title: varchar(255)
- slug: varchar(255)
- initial: char(1)
-
category
Records:8Top categories
Data fields
- id: int(11)
- title: varchar(255)
- slug: varchar(255)
-
category_sub
Records:158Secondary categories
Data fields
- id: int(11)
- title: varchar(255)
- slug: varchar(255)
- category_id: int(11)
-
category_sub_sub
Records:1,540Tertiary categories
Data fields
- id: int(11)
- title: varchar(255)
- slug: varchar(255)
- category_sub_id: int(11)
-
engine
Records:74,205Different engines of automobiles
Data fields
- id: int(11)
- title: varchar(255)
- submodel_id: int(11)
- make: varchar(255)
- year: char(4)
- model: varchar(255)
- submodel: varchar(255)
- num_parts: int(10) unsigned
-
engine2part
Records:117,229,740Association table of auto engines and auto parts
Data fields
- id: int(11)
- part_id: int(11)
- engine_id: int(11)
-
make
Records:68Automobile makes
Data fields
- id: int(10) unsigned
- title: varchar(255)
- num_parts: int(10) unsigned
-
make2year
Records:2,978Association table of auto makes and auto years
Data fields
- id: int(11)
- make: varchar(255)
- year: char(4)
-
model
Records:22,603Different models of automobile makes
Data fields
- id: int(11)
- title: varchar(255)
- make2year_id: int(11)
- make: varchar(255)
- year: char(4)
-
part
Records:1,708,530Primary table containing all the automobile parts
Data fields
- id: int(11)
- title: varchar(255)
- part_number: varchar(255)
- manufacturer_number: varchar(255)
- list_price: varchar(255)
- universal_part: tinyint(1)
- brand_title: varchar(255)
- brand_id: int(10) unsigned
- description: mediumtext
- fits: text
- specifications_json: text
- Quantity_Sold: varchar(255)
- Product_Fit: varchar(255)
- Warranty: varchar(255)
- Color_Finish: varchar(255)
- Material: varchar(255)
- Location: varchar(255)
- Series: varchar(255)
- Notes: text
- Seat_Type: varchar(255)
- Fit_Note: text
- Design: varchar(255)
- Position: varchar(255)
- Type: varchar(255)
- Row: varchar(255)
- Recommended_Use: varchar(255)
- Vehicle_Body_Type: varchar(255)
- Construction: varchar(255)
- Kit_Type: varchar(255)
-
submodel
Records:43,921Sub-models or trims of auto models
Data fields
- id: int(11)
- title: varchar(255)
- model_id: int(11)
- make: varchar(255)
- year: char(4)
- model: varchar(255)
-
year
Records:74Year of automobile production
Data fields
- id: int(11)
- title: char(4)
- num_parts: int(10) unsigned
Buy Now & Download: $489.95 (USD)
Download link will be sent to your PayPal email. Please check spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive it 10 minutes after payment. We will manually send you the download details in 24 hours. Our support staff work in the time zone of GMT+8.
Instant download upon payment success, just press return button on PayPal website after finishing payment.
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
- XML
- YAML
- WordPress Category / Post Database
- Single Table Format
As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the same URL we sent to you, you can download updated versions.