Home Data Automotive Car Parts & Accessories Used & New Auto Parts + Car Parts & Accessories + Automotive

US Car Parts & OE Numbers Database 1985-2021 by Make, Year, Model, Engine, Brand, Categories

Name	n3a5_carparts_com
Data	14.21G (+ 0B)
Tables	17 (+ 0)
Columns	115 (+ 0)
Table Rows	85,512,657 (+ 0)
Media	140.48G (+ 0B)
Files	526,166 (+ 0)
Last Commit	2023-06-19 19:26:56 (+ 169 d)

This is the latest (1985 to 2021) and most comprehensive United States auto parts database for your auto parts software, app, or website, with 521,648 parts by 37 years, 1,608 makes, 17,299 models, 41,064 submodels or trims, 63,076 engines, and 217 manufacturer brands. Parts are also categorized by 8 top categories, further by 158 secondary categories, and eventually by 5,698 tertiary categories, which all come with a large cover image each.

Other than general part fields, the part_attributes (99.4%) field carry further details of 642 unique part attributes: warranty (94.8%), location (62.0%), product fit (51.8%), series (49.5%), recommended use (45.9%), 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%), design (9.3%), components (8.7%), etc.. This data set also comes with 520,830 auto part images (139.85G) that are of high resolutions with no watermarks, averaging about 246KB per JPEG image, ready for your part store and inventory management. There are 17 tables in this database.

Data Samples

Parts List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table
Vehicles List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table

Data APIs

http://n3.datasn.io/data/api/v1/n3a5/auto_parts_united_states/ (By Table)

Media Files

category_1_image ^{Bytes: 220.58K / Files: 8}
category_2_image ^{Bytes: 36.74M / Files: 145}
category_3_image ^{Bytes: 603.09M / Files: 5,183}
part_image ^{Bytes: 139.85G / Files: 520,830}

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
brand	217	title	100%
		slug	100%
		count_parts	100%
category_1	8	title	100%
		slug	100%
		count_parts	100%
category_2	158	title	100%
		slug	100%
		category_1_id	100%
		count_parts	94.3%
category_3	5,698	title	100%
		slug	100%
		category_2_id	100%
		count_parts	18.46%
engine	63,076	cylinders	98.78%
		liter	98.78%
		year	100%
		make	100%
		model	100%
		submodel	99.54%
		submodel_id	100%
		count_parts	99.94%
make	1,608	title	100%
		slug	100%
		year	100%
		year_id	100%
		count_parts	100%
model	17,299	title	100%
		slug	100%
		year	100%
		make	100%
		make_id	100%
		count_parts	99.95%
part	521,648	part_number	100%
		manufacturer_number	100%
		description	99.97%
		part_name	100%
		brand	100%
		brand_id	100%
		category_1	100%
		category_2	100%
		category_3	100%
		category_1_id	100%
		category_2_id	100%
		category_3_id	100%
		is_universal	100%
		price_regular	100%
		price_list	92.94%
		price_shipping	87.77%
		price_handling	5.92%
		price_special	0.75%
		price_core	5.27%
		part_title	99.99%
		part_attributes	99.43%
		is_best_seller	100%
		is_made_to_order	100%
		fit_notes	100%
part_number	1,932	part_number	100%
submodel	41,064	title	99.3%
		slug	99.3%
		year	100%
		make	100%
		model	100%
		model_id	100%
		count_parts	99.94%
vehicle	63,076	year	100%
		make	100%
		model	100%
		submodel	99.54%
		cylinders	98.78%
		liter	98.78%
		year_id	100%
		make_id	100%
		model_id	100%
		submodel_id	100%
		engine_id	100%
		parts_total	99.94%
		count_parts	99.94%
vehicle_x_part	84,796,836	vehicle_id	100%
vehicle_x_part	84,796,836	part_id	100%
year	37	title	100%
year	37	slug	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

category_1_image

Size (Bytes)	Files
220.58K	8

category_2_image

Size (Bytes)	Files
36.74M	145

category_3_image

Size (Bytes)	Files
603.09M	5,183

part_image

Size (Bytes)	Files
139.85G	520,830

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	14.21G (+ 0B)	17 (+ 0)	115 (+ 0)	85,512,657 (+ 0)	140.48G (+ 0B)	526,166 (+ 0)
2023-01-01 (+ 95 d)	14.21G (- 0.16M)	17 (- 1)	115 (- 5)	85,512,657 (- 797)	140.48G (+ 0B)	526,166 (+ 0)
2022-09-27 (+ 271 d)	14.21G (+ 272K)	18 (+ 2)	120 (+ 7)	85,513,454 (+ 2,729)	140.48G (+ 0B)	526,166 (+ 0)
2021-12-30 (+ 115 d)	14.21G (+ 3.56G)	16 (+ 0)	113 (+ 0)	85,510,725 (+ 0)	140.48G (+ 0B)	526,166 (+ 0)
2021-09-05 (+ 150 d)	10.66G (+ 4.10G)	16 (+ 5)	113 (+ 36)	85,510,725 (+ 19,219,708)	140.48G (+ 140.48G)	526,166 (+ 526,166)
2021-04-08 (+ 68 d)	6.56G (+ 834.38M)	11 (+ 0)	77 (+ 0)	66,291,017 (+ 28,754,982)	0B (+ 0B)	0 (+ 0)
2021-01-29	5.74G	11	77	37,536,035	0B	0

Download Latest Commit

In the same time, you can also access this data set via API.

Access Now!

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.