This is a parts and assemblies data set having 302,389 assemblies and 455,850 parts for CAN-AM, HONDA, and SEA-DOO. There are assemble, type, model, year and brand in each assemble record, and price, description, require quantity, part number, and ref in each part record.
Ranging from the year 2003 to 2023, these parts and assembles comprise 8 types: ATVs(CAN-AM); Utility Vehicles(CAN-AM); ATVs(HONDA); Motorcycles(HONDA); Scooters (HONDA); Utility Vehicles (HONDA); Watercraft (SEA-DOO); Snowmobiles (SKI-DOO). Apart from this, it has 5,702 model records with type, brand, year, and model in each and also comes with 297,048 files of photo images in the 14.57G media set.
The whole parts and assemblies database totally has 9 tables.
| Name | n3_lyz_nepapowersports_parts.net |
|---|---|
| Data | 1.23G (+ 317.39M) |
| Tables | 9 (- 3) |
| Columns | 45 (+ 0) |
| Table Rows | 8,768,367 (+ 3,826,471) |
| Media | 14.57G (+ 903.70M) |
| Files | 297,048 (+ 150,771) |
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
- photo_image Bytes: 14.57G / Files: 297,048
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| model | 5,702 | type |
100%
|
| brand |
100%
|
||
| year |
100%
|
||
| model |
100%
|
||
| part | 455,850 | price |
100%
|
| description |
89.21%
|
||
| require_quantity |
96.99%
|
||
| part_number |
100%
|
||
| ref |
99.04%
|
||
| make | 3 | title |
100%
|
| image_slug | 300,828 | assemble_id |
100%
|
| type | 8 | brand |
100%
|
| type |
100%
|
||
| year | 147 | brand |
100%
|
| type |
100%
|
||
| year |
100%
|
||
| assemble | 302,389 | assemble |
100%
|
| type |
100%
|
||
| model |
100%
|
||
| make |
0%
|
||
| brand |
100%
|
||
| assemble_x_part | 7,703,440 | assemble_id |
100%
|
| part_id |
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
PHOTO_IMAGE
| Size (Bytes) | Files |
|---|---|
| 14.57G | 297,048 |
