This is a pre-owned vehicles database of 336,150 used cars from 3,480 years by 609 models of 58 makes (such as Acura, BMW, Ferrari, Honda, Land Rover, Mercedes-Benz, Rolls-Royce, etc.). Each used car is identified by title, price, mileage, location, exterior, interior, vehicle identification number, description, stock number and image url. There are 120,989 overview of these vehicles. The whole used vehicles data set consists of 8 tables.
| Name | n3_chennan_car_truecar_com_1 |
|---|---|
| Data | 868.86M (+ 0B) |
| Tables | 8 (+ 0) |
| Columns | 43 (+ 0) |
| Table Rows | 2,786,905 (+ 0) |
| Media | 26.90M (+ 0B) |
| Files | 300 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| make | 58 | title |
100%
|
| model | 609 | title |
100%
|
| make_id |
100%
|
||
| make |
100%
|
||
| used_car | 336,150 | title |
100%
|
| price |
100%
|
||
| mileage |
100%
|
||
| location |
100%
|
||
| interior |
76.85%
|
||
| exterior |
97.01%
|
||
| vin |
100%
|
||
| description |
73.18%
|
||
| stock_number |
77.5%
|
||
| image_url |
77.53%
|
||
| used_car_x_vehicle_overview | 1,989,468 | used_car_id |
100%
|
| vehicle_overview_id |
100%
|
||
| vehicle_overview | 120,989 | key |
100%
|
| value |
100%
|
||
| year | 3,480 | title |
100%
|
| model |
100%
|
||
| model_id |
100%
|
||
| year_x_used_car | 336,151 | year_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
USED_CAR_IMAGE
| Size (Bytes) | Files |
|---|---|
| 26.90M | 300 |
