This motorcycle OEM(original equipment manufacture) parts database contains 1,473,219 motor parts by 9 well-known makes (Can-Am / Honda / KTM / Kawasaki / Victory / Suzuki / Sea-Doo / Polaris / Yamaha OEM parts). In table part, each record is comprised of part, part idt, price, quantity and assembly id. The whole motor parts data set has 13 tables.
| Name | n3_lyz_motorcyclemall_parts.com |
|---|---|
| Data | 3.55G (+ 1.91G) |
| Tables | 13 (+ 0) |
| Columns | 56 (+ 0) |
| Table Rows | 16,948,098 (+ 0) |
| Media | 4.11G (+ 0B) |
| Files | 831,120 (+ 0) |
Data Samples
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
Database APIs
- http://n3.datasn.io/data/api/v1/n3_lyz/parts_of_powersports_vehicle_and_motorcycle_and_trailers_and_generator_set_and_watercraft_3/ (By Table)
Media Files
- assembly_image Bytes: 3.81G / Files: 771,797
- assembly_image_to_make Bytes: 307.23M / Files: 59,323
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| assembly | 842,907 | assembly |
100%
|
| category_model_id |
100%
|
||
| assembly_to_make | 59,804 | assembly |
100%
|
| category_model_to_make_id |
100%
|
||
| assembly_to_make_x_part | 1,443,260 | assembly_to_make_id |
100%
|
| part_id |
100%
|
||
| assembly_x_part | 13,109,753 | assembly_id |
100%
|
| part_id |
100%
|
||
| category_make | 9 | title |
100%
|
| category_model | 16,831 | model |
100%
|
| category_year_id |
100%
|
||
| category_model_to_make | 1,408 | model |
100%
|
| category_year_to_make_id |
100%
|
||
| category_type | 36 | type |
100%
|
| category_make_id |
100%
|
||
| category_year | 827 | year |
99.64%
|
| category_type_id |
100%
|
||
| category_year_to_make | 44 | year |
100%
|
| category_make_id |
100%
|
||
| part | 1,473,219 | part |
100%
|
| part_idt |
99.99%
|
||
| count |
75.16%
|
||
| sequence_number |
99.08%
|
||
| price |
75.16%
|
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 |
|---|---|
| 3.81G | 771,797 |
ASSEMBLY_IMAGE_TO_MAKE
| Size (Bytes) | Files |
|---|---|
| 307.23M | 59,323 |
