In this car parts database, it has 1,118 records for Japan and Europe.
Each part record is comprised of assemble, oem number, part name, color, interior type, required per car, note and price. There are 5 tables mostly related with these parts, they are 940 assemble records with system, model, complectation, vin, engine, year, transmission type in each; model with 43 records; 3,491 complectation records with type, vin, doors, engine, model, year and transmission type in each; 316 system records with complectation, vin, doors, engine, model, year and transmission type in each and 705 type records with year, transmission type and model in each. It also comes with 50 assemble images in the 928.22K media set.
There are 8 tables in the whole auto parts data set.
| Name | n3_lyz_honda_epc_eur |
|---|---|
| Data | 2.16M (+ 144K) |
| Tables | 8 (+ 0) |
| Columns | 61 (+ 0) |
| Table Rows | 6,663 (+ 0) |
| Media | 928.22K (+ 0B) |
| Files | 35 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assemble | 940 | assemble |
100%
|
| system_id |
100%
|
||
| model |
100%
|
||
| system |
100%
|
||
| complectation |
100%
|
||
| vin |
100%
|
||
| engine |
100%
|
||
| year |
100%
|
||
| transmission_type |
100%
|
||
| assemble_image_slug | 50 | assemble_id |
100%
|
| complectation | 3,491 | complectation |
100%
|
| type_id |
100%
|
||
| vin |
100%
|
||
| doors |
100%
|
||
| engine |
100%
|
||
| model |
100%
|
||
| year |
100%
|
||
| transmission_type |
100%
|
||
| model | 43 | model |
100%
|
| part | 1,118 | assemble_id |
100%
|
| oem_number |
4.11%
|
||
| part_name |
4.11%
|
||
| color |
0%
|
||
| interior_type |
0%
|
||
| required_per_car |
4.11%
|
||
| note |
0%
|
||
| price |
3.94%
|
||
| system | 316 | system |
100%
|
| complectation_id |
100%
|
||
| complectation |
100%
|
||
| vin |
100%
|
||
| doors |
100%
|
||
| engine |
100%
|
||
| model |
100%
|
||
| year |
100%
|
||
| transmission_type |
100%
|
||
| type | 705 | year |
100%
|
| transmission_type |
100%
|
||
| model_id |
100%
|
||
| model |
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
ASSEMBLE_IMAGE
| Size (Bytes) | Files |
|---|---|
| 928.22K | 35 |
