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 16 tables in this database.
| Name | n3a5_carparts_com |
|---|---|
| Data | 10.66G (+ 4.10G) |
| Tables | 16 (+ 5) |
| Columns | 113 (+ 36) |
| Table Rows | 85,510,725 (+ 19,219,708) |
| Media | 140.48G (+ 140.48G) |
| Files | 526,166 (+ 526,166) |
Data Samples
- By Table / Parts (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Vehicles (Desktop) / JSON / XML / Excel / CSV (Download)
Database APIs
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
| 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%
|
||
| 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%
|
| part_id |
100%
|
||
| year | 37 | title |
100%
|
| 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 |
