This parts and assemblies data set contains the powersports vehicle, motorcycle, trailers, watercraft, generator set assemblies and parts data of 3 brands: Arctic Cat, Kawasaki and Yamaha. The data is range from year 1995 to 2018 and comprises 7 types: ATV, generator, motorcycle, scooter, snowmobile, utility vehicle and watercraft. Database has total 4,358 models, 197,966 assemblies and 315,721 parts. Each record of part includes part name, price, quantity and sequence of diagram. It also comes with 13.69G assembly images in the media set. The whole motorcycles parts database totally has 12 tables.
| Name | n3_lyz_nepapowersports_parts.net |
|---|---|
| Data | 940.86M (+ 667.30M) |
| Tables | 12 (+ 0) |
| Columns | 45 (+ 0) |
| Table Rows | 4,941,896 (+ 0) |
| Media | 13.69G (+ 0B) |
| Files | 146,277 (+ 0) |
Data Samples
Database APIs
- http://n3.datasn.io/data/api/v1/n3_lyz/parts_of_powersports_vehicle_and_motorcycle_and_trailers_and_generator_set_and_watercraft_1/ (By Table)
Media Files
- assembly_image Bytes: 13.69G / Files: 146,277
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assembly | 197,966 | title |
100%
|
| type_x_make_x_year_x_model_id |
100%
|
||
| assembly_x_part | 4,221,299 | assembly_id |
100%
|
| part_id |
100%
|
||
| image_slug | 197,933 | assembly_id |
100%
|
| make | 3 | title |
100%
|
| model | 4,358 | title |
100%
|
| part | 315,721 | part |
83.13%
|
| price |
99.91%
|
||
| quantity |
98.26%
|
||
| squence |
89.08%
|
||
| type | 7 | title |
100%
|
| type_x_make | 13 | type_id |
100%
|
| make_id |
100%
|
||
| type_x_make_x_year | 198 | type_x_make_id |
100%
|
| year_id |
100%
|
||
| type_x_make_x_year_x_model | 4,358 | model_id |
100%
|
| type_x_make_x_year_id |
100%
|
||
| year | 40 | year |
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
ASSEMBLY_IMAGE
| Size (Bytes) | Files |
|---|---|
| 13.69G | 146,277 |
