In this motors database, there are 1,178 motors and 2,480 sale motors of powersport vehicles, motorcycles, ATVs, generators, etc. by 19 makes of Yamaha, Kawasaki, Honda, Suzuki, Kymco etc. Each motor record is comprised of model, price, year, description, category, etc. In table sale motor, it has style in each record.
3 tables related with motors, they are 8,353 motor infomation records, motor speci with 1,178 records and motor speci detail with 22,666 records and 5 tables of sale motors related, they are 2,479 sale motor detail with new used, usage, price, availability, vin, condition, stock, year, model, clean, color, etc. sale motor info with 14,117 records, sale motor info detail with 83,097 records, sale motor specification with 13,759 records and sale motor specification detail with 53,273 records. For images, it has motor image and sale motor images in 4 media sets, they are 1,178 cover image slug & 3,058 image slug of motors in the 39.51M & 210.63M media sets and 7,162 sale motor images in the 43.54M & 1.87G media sets of this database.
The whole powersport vehicles data set consists of 21 tables.
| Name | n3_lyz_petescycle.com |
|---|---|
| Data | 66.61M (+ 1.19M) |
| Tables | 21 (+ 0) |
| Columns | 94 (+ 0) |
| Table Rows | 220,542 (+ 0) |
| Media | 2.15G (+ 0B) |
| Files | 11,846 (+ 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/powersports_vehicle_and_motorcycle_and_generator_29/ (By Table)
Media Files
- motor_cover_image Bytes: 39.51M / Files: 1,178
- motor_image Bytes: 210.63M / Files: 3,013
- sale_motor_cover Bytes: 43.54M / Files: 567
- sale_motor_image Bytes: 1.87G / Files: 7,088
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_by_make | 15 | make |
100%
|
| category_by_type | 127 | class |
98.43%
|
| type |
98.43%
|
||
| category_by_make_id |
100%
|
||
| cover_image_slug | 1,178 | motor_id |
100%
|
| image_slug | 3,058 | motor_id |
100%
|
| make | 19 | make |
100%
|
| motor | 1,178 | year |
100%
|
| model |
100%
|
||
| price |
100%
|
||
| category_by_type_id |
100%
|
||
| description |
68.17%
|
||
| note |
71.82%
|
||
| availability |
95.93%
|
||
| motor_info | 8,353 | key |
100%
|
| motor_id |
100%
|
||
| value |
81.89%
|
||
| motor_speci | 5,102 | key |
100%
|
| motor_id |
100%
|
||
| motor_speci_detail | 22,666 | key |
100%
|
| value |
100%
|
||
| motor_speci_id |
100%
|
||
| sale_motor | 2,480 | title |
100%
|
| style |
99.6%
|
||
| sale_motor_detail | 2,479 | new_used |
24.73%
|
| usage |
13.43%
|
||
| price |
89.67%
|
||
| availability |
100%
|
||
| vin |
23.92%
|
||
| condition |
25.78%
|
||
| stock |
23.96%
|
||
| year |
100%
|
||
| model |
100%
|
||
| clean |
25.78%
|
||
| color |
25.57%
|
||
| description |
76.89%
|
||
| note |
76.36%
|
||
| sale_motor_id |
100%
|
||
| sale_motor_detail_x_make | 2,479 | sale_motor_detail_id |
100%
|
| make_id |
100%
|
||
| sale_motor_image_slug | 7,162 | sale_motor_id |
100%
|
| sale_motor_info | 14,117 | key |
100%
|
| sale_motor_id |
100%
|
||
| sale_motor_info_detail | 83,097 | value |
100%
|
| sale_motor_info_id |
100%
|
||
| sale_motor_speci | 13,759 | key |
100%
|
| sale_motor_id |
100%
|
||
| sale_motor_speci_detail | 53,273 | key |
100%
|
| value |
100%
|
||
| sale_motor_speci_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
MOTOR_COVER_IMAGE
| Size (Bytes) | Files |
|---|---|
| 39.51M | 1,178 |
MOTOR_IMAGE
| Size (Bytes) | Files |
|---|---|
| 210.63M | 3,013 |
SALE_MOTOR_COVER
| Size (Bytes) | Files |
|---|---|
| 43.54M | 567 |
SALE_MOTOR_IMAGE
| Size (Bytes) | Files |
|---|---|
| 1.87G | 7,088 |
