This is a fields-rich and valuable vehicles database that includes 1,979 ATVs, 82,295 boats, 7,401 cars by year, 7,422 motorcycles, 25,224 new cars, 4,417 RVS camper and 15,243 used cars.
There are title, condition, type, state, detail type, price, year, make, model, mileage, color, engine cc, description, e-mail and seller type in each ATV. These ATVs are from 376 locations and 8 makers. Each boat record has title, condition, type, state, detail type etc. All the boats are from 3,337 locations and 71 makers. In each car by year record, there are title, img slug, used car slug, car category etc. In the vehicles database, each motorcycle has title, condition, type, state, detail type, price, year, make, model, mileage, description etc. All the motorcycles are from 517 locations and 11 makers. In the each new car record, there is title, model etc. and all the new cars are from 34 car makers. Each rvs camper has title, condition, price, color, class, stock, vin, phone, address, info and description. All the used cars are from 39 car makers. Each used car has title, model etc. The whole vehicles data set consists of 51 tables.
Name | n3_lyz_atvsoup.com |
---|---|
Data | 907.20M (+ 0B) |
Tables | 51 (+ 0) |
Columns | 303 (+ 0) |
Table Rows | 3,011,233 (+ 0) |
Media | 15.81G (+ 0B) |
Files | 307,772 (+ 0) |
Data Samples
- By Table / ATV (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Motorcycle (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Boat (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Car (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / New Car (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Used Car (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / RVs Camper (Desktop) / JSON / XML / Excel / CSV (Download)
Database APIs
- http://n3.datasn.io/data/api/v1/n3_lyz/cars_and_powersports_vehicle_and_motorcycle_and_boat_14/ (By Table)
Media Files
- atv_image Bytes: 104.30M / Files: 1,736
- boat_image Bytes: 1.21G / Files: 30,303
- car_by_year_image Bytes: 21.82M / Files: 7,400
- car_photo Bytes: 9.45G / Files: 152,063
- motorcycle_image Bytes: 314.31M / Files: 4,808
- new_car_image Bytes: 2.05G / Files: 49,472
- rvs_camper_image Bytes: 1.43G / Files: 35,129
- used_car_image Bytes: 1.24G / Files: 26,861
Tables & Columns
Tables | Rows | Columns | Non-empty |
---|---|---|---|
atv | 1,979 | title |
100%
|
condition |
100%
|
||
type |
100%
|
||
state |
100%
|
||
detail_type |
100%
|
||
price |
87.82%
|
||
year |
87.82%
|
||
make |
87.82%
|
||
model |
87.82%
|
||
mileage |
87.82%
|
||
color |
87.82%
|
||
engine_cc |
87.82%
|
||
description |
87.82%
|
||
e_mail |
87.82%
|
||
seller_type |
87.82%
|
||
atv_by_location | 376 | title |
100%
|
make_id |
100%
|
||
atv_by_location_x_atv | 1,979 | atv_id |
100%
|
atv_by_location_id |
100%
|
||
atv_by_make | 8 | title |
100%
|
atv_image_slug | 1,737 | image_slug |
100%
|
atv_id |
100%
|
||
boat | 82,295 | title |
100%
|
condition |
100%
|
||
type |
100%
|
||
state |
100%
|
||
detail_type |
100%
|
||
price |
65.82%
|
||
year |
65.82%
|
||
make |
65.82%
|
||
model |
65.82%
|
||
mileage |
65.82%
|
||
color |
65.82%
|
||
engine_cc |
65.82%
|
||
description |
65.82%
|
||
e_mail |
14.31%
|
||
seller_type |
56.72%
|
||
boat_by_location | 3,337 | title |
100%
|
make_id |
100%
|
||
boat_by_location_x_boat | 22,127 | boat_by_location_id |
100%
|
boat_id |
100%
|
||
boat_by_make | 71 | title |
100%
|
boat_image_slug | 52,492 | boat_id |
100%
|
car_by_year | 7,401 | title |
100%
|
car_category_2_id |
100%
|
||
car_category_1 | 15 | title |
100%
|
car_category_2 | 1,012 | title |
100%
|
price |
100%
|
||
mpg |
100%
|
||
car_category_1_id |
100%
|
||
car_color | 49,224 | color |
100%
|
color_value |
99.98%
|
||
car_color_slug_id |
100%
|
||
car_color_slug | 7,400 | car_overview_id |
100%
|
car_feature | 353,116 | title |
100%
|
car_overview_style_id |
100%
|
||
car_title |
100%
|
||
car_feature_detail | 934,486 | title |
100%
|
car_feature_id |
100%
|
||
title_name |
100%
|
||
car_green_score | 7,209 | title |
100%
|
car_overview_id |
100%
|
||
car_overview | 7,400 | title |
100%
|
style |
84.28%
|
||
price |
100%
|
||
mpg_city |
100%
|
||
mpg_highway |
100%
|
||
description |
41.59%
|
||
car_by_year_id |
100%
|
||
mpg_ciyt |
0%
|
||
car_overview_style | 49,067 | style |
100%
|
engine |
100%
|
||
mpg |
100%
|
||
price |
100%
|
||
car_by_year_id |
100%
|
||
car_photo_slug | 263,139 | car_overview_id |
100%
|
car_safety | 36,938 | title |
100%
|
value |
51.96%
|
||
car_overview_id |
100%
|
||
category_1 | 6 | title |
83.33%
|
motorcycle | 7,422 | title |
100%
|
condition |
100%
|
||
type |
100%
|
||
state |
100%
|
||
detail_type |
100%
|
||
price |
74.37%
|
||
year |
74.37%
|
||
make |
74.37%
|
||
model |
74.37%
|
||
mileage |
74.37%
|
||
color |
74.37%
|
||
engine_cc |
74.37%
|
||
description |
100%
|
||
e_mail |
74.37%
|
||
seller_type |
74.21%
|
||
motorcycle_by_location | 517 | title |
100%
|
make_id |
100%
|
||
motorcycle_by_location_x_motorcycle | 7,422 | motorcycle_by_location_id |
100%
|
motorcycle_id |
100%
|
||
motorcycle_by_make | 11 | title |
100%
|
motorcycle_image_slug | 5,496 | image_slug |
100%
|
motorcycle_id |
100%
|
||
new_car | 25,224 | title |
100%
|
model |
34.39%
|
||
price |
33.46%
|
||
color |
33.46%
|
||
body_style |
33.42%
|
||
fuel_type |
33.46%
|
||
engine |
28.83%
|
||
drive |
33.46%
|
||
transmission |
30.65%
|
||
stock |
30%
|
||
vin |
33.46%
|
||
miles |
17.17%
|
||
quick_search |
33.46%
|
||
mpg_city |
17.11%
|
||
mpg_hwy |
17.53%
|
||
feature_slug |
33.46%
|
||
new_car_connection | 8,136 | tel |
78.99%
|
address |
99.96%
|
||
city |
100%
|
||
new_car_id |
100%
|
||
new_car_feature | 601,315 | feature |
100%
|
new_car_id |
100%
|
||
new_car_image_slug | 64,934 | image_slug |
100%
|
new_car_id |
100%
|
||
new_car_make | 34 | make |
100%
|
new_car_make_x_new_car | 8,675 | new_car_make_id |
100%
|
new_car_id |
100%
|
||
rvs_camper | 4,417 | title |
100%
|
condition |
100%
|
||
price |
99.71%
|
||
color |
99.71%
|
||
class |
88.59%
|
||
stock |
97.03%
|
||
vin |
99.71%
|
||
phone |
99.71%
|
||
address |
99.71%
|
||
info |
93.96%
|
||
description |
83.34%
|
||
rvs_camper_by_condition | 2 | title |
100%
|
rvs_camper_image_slug | 35,130 | image_slug |
100%
|
rvs_camper_id |
100%
|
||
used_car | 15,243 | title |
100%
|
model |
46.07%
|
||
price |
34.79%
|
||
color |
34.79%
|
||
body_style |
34.63%
|
||
fuel_type |
34.78%
|
||
engine |
33.64%
|
||
drive |
34.79%
|
||
transmission |
34.33%
|
||
stock |
32.92%
|
||
vin |
34.79%
|
||
miles |
33.41%
|
||
quick_search |
34.79%
|
||
mpg_city |
27.26%
|
||
mpg_hwy |
27.57%
|
||
feature_slug |
34.79%
|
||
used_car_connection | 4,912 | used_car_id |
100%
|
tel |
68.08%
|
||
address |
99.96%
|
||
city |
99.96%
|
||
used_car_feature | 300,590 | feature |
100%
|
used_car_id |
100%
|
||
used_car_image_slug | 31,877 | image_slug |
100%
|
used_car_id |
100%
|
||
used_car_make | 39 | make |
100%
|
used_car_make_x_used_car | 7,023 | used_car_make_id |
100%
|
used_car_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
ATV_IMAGE
Size (Bytes) | Files |
---|---|
104.30M | 1,736 |
BOAT_IMAGE
Size (Bytes) | Files |
---|---|
1.21G | 30,303 |
CAR_BY_YEAR_IMAGE
Size (Bytes) | Files |
---|---|
21.82M | 7,400 |
CAR_PHOTO
Size (Bytes) | Files |
---|---|
9.45G | 152,063 |
MOTORCYCLE_IMAGE
Size (Bytes) | Files |
---|---|
314.31M | 4,808 |
NEW_CAR_IMAGE
Size (Bytes) | Files |
---|---|
2.05G | 49,472 |
RVS_CAMPER_IMAGE
Size (Bytes) | Files |
---|---|
1.43G | 35,129 |
USED_CAR_IMAGE
Size (Bytes) | Files |
---|---|
1.24G | 26,861 |