This is a fields-rich vehicles database with 177,666 records from thousands of dealers worldwide. Each vehicle is comprised of title, description, mileage, engine, transmission, fuel, fuel economy, dealer, telephone number, address etc. All these cars are classified by 250 primary categories by brands and further categorized into 1,824 sub categories. In the whole vehicles database, there are other 2 important tables related with these used cars, they are option with 90,093 records and price list with 12,981 records. It also comes with 1,874,295 vehicles images in the 27.88G media sets of this database. The whole used cars data set consists of 11 tables.
| Name | n3a2_carsforsale_com |
|---|---|
| Data | 1.46G (+ 0B) |
| Tables | 11 (+ 0) |
| Columns | 55 (+ 0) |
| Table Rows | 7,182,708 (+ 0) |
| Media | 27.88G (+ 0B) |
| Files | 464,572 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 250 | title |
100%
|
| category_2 | 1,824 | title |
100%
|
| category_1_id |
100%
|
||
| category_1 |
100%
|
||
| category_3 | 15,121 | title |
100%
|
| category_2_id |
100%
|
||
| category_2 |
100%
|
||
| category_3_x_vehicle | 283,066 | category_3_id |
100%
|
| vehicle_id |
100%
|
||
| image | 1,874,295 | vehicle_id |
100%
|
| option | 90,093 | title |
100%
|
| price | 12,981 | title |
100%
|
| vehicle | 177,666 | title |
100%
|
| description |
49.44%
|
||
| mileage |
50.22%
|
||
| engine |
46.78%
|
||
| transmission |
47.16%
|
||
| fuel |
44.83%
|
||
| fuel_economy |
50.22%
|
||
| drive_train |
42.09%
|
||
| interior_exterior_colors |
40.42%
|
||
| dealer |
50.22%
|
||
| address |
50.22%
|
||
| telephone |
50.15%
|
||
| vehicle_x_option | 4,637,463 | vehicle_id |
100%
|
| option_id |
100%
|
||
| vehicle_x_price | 89,949 | vehicle_id |
100%
|
| price_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
VEHICLE_IMAGE
| Size (Bytes) | Files |
|---|---|
| 27.88G | 464,572 |
