This is an auto parts catalog data set with a total of 1,256,058 auto parts for the North America markets, including parts for models, engines, and trims of United States, Canada, and Mexico. Parts have oem numbers, price, description, images, and are classified by 257 makes, 5,965 years, 33,449 models, 61,125 engines or trims, and 612 manufacturers, etc., and also by 28 top categories and further by 5,505 secondary categories.
There are 18 tables in this database. The part images table has 3,148,915 files.
We have also another edition of US Auto Parts Database from another website source (one of the top auto parts website as well): https://www.thedataplanet.com/databases/autoparts-database.html
| Name | n3a5_rockauto |
|---|---|
| Data | 40.35G (+ 15M) |
| Tables | 18 (+ 0) |
| Columns | 89 (+ 0) |
| Table Rows | 98,334,758 (+ 11,243,475) |
| Media | 12.97G (+ 0B) |
| Files | 456,242 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 28 | title |
100%
|
| params |
0%
|
||
| slug |
100%
|
||
| category_2 | 5,505 | title |
100%
|
| slug |
100%
|
||
| parttype |
100%
|
||
| description |
32.24%
|
||
| category_1_id |
100%
|
||
| engine | 61,125 | title |
100%
|
| model_id |
100%
|
||
| slug |
100%
|
||
| carcode |
99.99%
|
||
| make |
100%
|
||
| year |
100%
|
||
| model |
100%
|
||
| engine_x_category_1 | 1,124,730 | engine_id |
100%
|
| category_1_id |
100%
|
||
| engine_x_category_1_x_category_2 | 19,828,178 | engine_x_category_1_id |
100%
|
| category_2_id |
100%
|
||
| engine_x_category_1_x_category_2_x_part | 67,777,892 | engine_x_category_1_x_category_2_id |
100%
|
| part_id |
100%
|
||
| make | 257 | title |
100%
|
| slug |
100%
|
||
| manufacturer | 612 | title |
100%
|
| manufacturer_x_part | 1,291,517 | manufacturer_id |
100%
|
| part_id |
100%
|
||
| market | 3 | title |
100%
|
| abbr |
100%
|
||
| market_x_part | 534,173 | market_id |
100%
|
| part_id |
100%
|
||
| model | 33,449 | title |
100%
|
| year_id |
100%
|
||
| slug |
100%
|
||
| make |
100%
|
||
| year |
100%
|
||
| oem_number | 1,101,140 | title |
100%
|
| oem_number_x_part | 2,165,211 | oem_number_id |
100%
|
| part_id |
100%
|
||
| part | 1,256,058 | manufacturer |
100%
|
| part_number |
100%
|
||
| alternate_oem_numbers |
45.1%
|
||
| tagline |
60.63%
|
||
| list_price |
85.8%
|
||
| description |
82.64%
|
||
| info_essential |
100%
|
||
| info_supplemental |
100%
|
||
| category_1 |
100%
|
||
| category_2 |
100%
|
||
| partkey |
100%
|
||
| part_image | 3,148,915 | part_id |
100%
|
| year | 5,965 | title |
100%
|
| make_id |
100%
|
||
| make |
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
PART_IMAGE_FILE
| Size (Bytes) | Files |
|---|---|
| 12.97G | 456,242 |
