In this auto parts database, there are 1,216,959 records with engine in each and 6,122,333 car parts with part number, list price, current price, manufacturer, part and etc. in each. There are four tables mostly related with these auto parts, they are 10,308 doors with type in each, 38,531 engines with door in each, 1,136 types with year in each and 35 years. This car parts and auto parts data also comes with 5,073,102 images of these auto parts. The whole auto parts and car parts data set totally has 11 tables.
A more comprehensive auto parts dataset: https://datasn.io/p/245
| Name | n3_chennan_part_xportautoparts_com |
|---|---|
| Data | 5.82G (+ 0B) |
| Tables | 11 (+ 0) |
| Columns | 54 (+ 0) |
| Table Rows | 18,588,302 (+ 0) |
| Media | 437.87M (+ 0B) |
| Files | 10,000 (+ 0) |
Data Samples
Database APIs
Media Files
- carpart_image Bytes: 0P / Files: 0
- carpart_image_1 Bytes: 437.87M / Files: 10,000
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| auto_part | 1,216,959 | title |
100%
|
| engine_id |
100%
|
||
| engine |
100%
|
||
| auto_part_x_carpart | 6,125,898 | auto_part_id |
100%
|
| carpart_id |
100%
|
||
| carpart | 6,122,333 | no |
100%
|
| part_no |
100%
|
||
| title |
68.2%
|
||
| list_price |
67.94%
|
||
| current_price |
67.96%
|
||
| manufacturer |
36.72%
|
||
| part_number |
68.18%
|
||
| part |
68.2%
|
||
| door | 10,308 | title |
100%
|
| type_id |
100%
|
||
| type |
100%
|
||
| engine | 38,531 | title |
100%
|
| door_id |
100%
|
||
| door |
100%
|
||
| image | 0 | image_url |
0%
|
| carpart_id |
0%
|
||
| image_1 | 5,073,102 | image_url |
100%
|
| carpart_id |
100%
|
||
| type | 1,136 | title |
100%
|
| total_id |
0%
|
||
| year |
100%
|
||
| year_id |
100%
|
||
| year | 35 | title |
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
CARPART_IMAGE
| Size (Bytes) | Files |
|---|---|
| 0P | 0 |
CARPART_IMAGE_1
| Size (Bytes) | Files |
|---|---|
| 437.87M | 10,000 |
