In this bikes database, there are 31,111 records with description, votes, overall rating, overall rating for naked, engine performance, engine performance for naked, reliability problem free, reliability problem free for naked, fun factor, value for money, repair maintenance costs, repair maintenance costs for naked, design and look, offroad capability, racing track capability, touring capability, low accident risk and etc. in each. These bikes are from 478 brands and 126 years. In table bike feature, it contains 186,588 records for these bikes. The bikes data also comes with 96,325 images in the 10.52G media set of this data. The whole bikes database totally has 9 tables.
| Name | n3_lyz_bikez.com_years |
|---|---|
| Data | 350.52M (+ 178.16M) |
| Tables | 9 (+ 0) |
| Columns | 57 (+ 0) |
| Table Rows | 1,461,642 (+ 0) |
| Media | 10.52G (+ 0B) |
| Files | 95,443 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| bike | 31,111 | title |
100%
|
| description |
49.65%
|
||
| votes |
58.91%
|
||
| overall_rating |
58.91%
|
||
| overall_rating_for_naked |
58.91%
|
||
| engine_performance |
58.91%
|
||
| engine_performance_for_naked |
58.91%
|
||
| reliability_problem_free |
58.91%
|
||
| reliability_problem_free_for_naked |
58.91%
|
||
| fun_factor |
58.91%
|
||
| fun_factor_for_naked |
58.91%
|
||
| value_for_money |
58.91%
|
||
| value_for_money_for_naked |
58.91%
|
||
| repair_maintenance_costs |
58.91%
|
||
| repair_maintenance_costs_for_naked |
58.91%
|
||
| design_and_look |
58.91%
|
||
| design_and_look_for_naked |
58.91%
|
||
| offroad_capability |
58.91%
|
||
| offroad_capability_for_naked |
58.91%
|
||
| racing_track_capability |
58.91%
|
||
| racing_track_capability_for_naked |
58.91%
|
||
| touring_capability |
58.91%
|
||
| touring_capability_for_naked |
58.91%
|
||
| low_accident_risk |
58.91%
|
||
| low_accident_risk_for_naked |
58.91%
|
||
| bike_feature | 186,588 | title |
100%
|
| bike_id |
100%
|
||
| bike_feature_detail | 1,084,792 | title |
100%
|
| value |
100%
|
||
| bike_feature_id |
100%
|
||
| bike_x_brand | 31,111 | bike_id |
100%
|
| brand_id |
100%
|
||
| brand | 478 | title |
100%
|
| image_slug | 96,325 | bike_id |
100%
|
| year | 126 | year |
100%
|
| year_x_bike | 31,111 | year_id |
100%
|
| bike_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 |
|---|---|
| 10.52G | 95,443 |
