This is a fields-rich motors database of 36,095 records from 1,854 cities of 110 counties over 6 regions in the United Kingdom. Each motor is comprised of title, description, location, price, posted, make, model, year, mileage, seller type, body type, fuel type, transmission, color, engine size, etc. These 6 regions are England, Guernsey, Isle Of Man, Northern Ireland, Scotland & Wales. It also comes with 2 motor images in the 277.10K media set of this database. The whole United Kingdom motors database consists of 8 tables.
| Name | n3zm_Used_Cars_gumtree_com |
|---|---|
| Data | 26.02M (+ 0B) |
| Tables | 8 (+ 0) |
| Columns | 49 (+ 0) |
| Table Rows | 86,755 (+ 0) |
| Media | 277.10K (+ 0B) |
| Files | 2 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 1,854 | title |
100%
|
| county_id |
100%
|
||
| county |
100%
|
||
| city_x_motors | 48,686 | city_id |
100%
|
| motors_id |
100%
|
||
| county | 110 | title |
100%
|
| region_id |
100%
|
||
| region |
100%
|
||
| motors | 36,095 | title |
100%
|
| description |
0%
|
||
| location |
100%
|
||
| price |
98.4%
|
||
| posted |
0%
|
||
| make |
0%
|
||
| model |
0%
|
||
| year |
0%
|
||
| mileage |
0%
|
||
| seller_type |
0%
|
||
| body_type |
0%
|
||
| fuel_type |
0%
|
||
| transmission |
0%
|
||
| colour |
0%
|
||
| engine_size |
0%
|
||
| ad_id |
0%
|
||
| motors_image | 2 | motors_id |
0%
|
| motors_x_motors_image | 2 | motors_id |
100%
|
| motors_image_id |
100%
|
||
| region | 6 | title |
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
MOTORS_IMAGE_DOWNLOAD
| Size (Bytes) | Files |
|---|---|
| 277.10K | 2 |
