In this car parts database, there are 126,677 records by 18 categories and further into 3,946 sub-categories.
Each record is comprised of title, location, list price dollar, final price dollar, number, image url, description, slug and logo. There are 5 tables mostly related with these parts, they are 110,098 engines with slug and submodel in each; 3,877 make records with slug and year in each; 35,097 model records with slug and make in each; 1,128,756 part feature records with key, value and part in each and year with 119 records from 1918-2017 years.
The whole auto parts data set totaly has 13 tables.
| Name | n3_superhan_carparts_com |
|---|---|
| Data | 11.07G (+ 0B) |
| Tables | 13 (+ 0) |
| Columns | 67 (+ 0) |
| Table Rows | 62,400,710 (+ 0) |
| Media | 14.34M (+ 0B) |
| Files | 1,043 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category | 18 | title |
100%
|
| slug |
100%
|
||
| engine | 110,098 | title |
100%
|
| slug |
100%
|
||
| submodel_id |
100%
|
||
| engine_x_category | 1,379,695 | engine_id |
100%
|
| category_id |
100%
|
||
| engine_x_sub_category | 25,290,541 | url |
100%
|
| pn |
0%
|
||
| vn |
0%
|
||
| engine_id |
100%
|
||
| sub_category_id |
100%
|
||
| engine_x_sub_category_x_parts | 34,255,423 | engine_x_sub_category_id |
100%
|
| parts_id |
100%
|
||
| make | 3,877 | title |
100%
|
| slug |
100%
|
||
| year_id |
100%
|
||
| model | 35,097 | title |
100%
|
| slug |
100%
|
||
| make_id |
100%
|
||
| part_feature | 1,128,756 | key |
100%
|
| value |
99.97%
|
||
| parts_id |
100%
|
||
| parts | 126,677 | title |
100%
|
| location |
46.86%
|
||
| list_price_dollar |
98.41%
|
||
| final_price_dollar |
100%
|
||
| number |
100%
|
||
| image_url |
100%
|
||
| description |
98.37%
|
||
| slug |
100%
|
||
| logo |
100%
|
||
| sub_category | 3,946 | title |
100%
|
| slug |
100%
|
||
| category_id |
100%
|
||
| submodel | 66,463 | title |
100%
|
| slug |
100%
|
||
| model_id |
100%
|
||
| year | 119 | 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
PART_IMAGE
| Size (Bytes) | Files |
|---|---|
| 14.34M | 1,043 |
