Official UK Market Standards
Vehicle records reflect UK market specifics including VRM registration plates, outward postcode areas (e.g. SW1, B4, M1), and official V5C engine displacement in litres.
United Kingdom / Structured Dataset Collection
Explore our exhaustive AutoTrader UK dataset capturing 480,000+ active UK vehicle listings with verified GBP asking prices, official DVLA-aligned specifications, imperial and metric mileages, and dealer postal codes.
Complete database schema
Every export cut contains standardized field names, explicit SQL types, and consistent formatting. Missing values in optional columns remain explicit NULLs.
| Column Name | Data Type | Description | Sample Value |
|---|---|---|---|
advert_id | VARCHAR(32) | AutoTrader UK primary advert identifier | at_uk_202610149021948 |
vrm | VARCHAR(10) | UK Vehicle Registration Mark / Plate | LO21XKZ |
make | VARCHAR(64) | Vehicle manufacturer brand | BMW |
model | VARCHAR(64) | Vehicle model line | 3 Series |
trim | VARCHAR(128) | Derivative and equipment trim | 320i M Sport |
year | SMALLINT | UK Registration year | 2021 |
price_gbp | NUMERIC(10,2) | Original GBP advertised asking price | 24500.00 |
price_eur | NUMERIC(10,2) | Calculated EUR equivalent at capture date | 28650.00 |
mileage_miles | INTEGER | Odometer reading in imperial miles | 29800 |
mileage_km | INTEGER | Calculated metric kilometre equivalent | 47958 |
fuel_type | VARCHAR(32) | Fuel type (Petrol, Diesel, Hybrid, Electric) | Petrol |
transmission | VARCHAR(32) | Gearbox (Automatic, Manual) | Automatic |
body_type | VARCHAR(48) | Saloon, Estate, Hatchback, SUV, Coupe | Saloon |
engine_size_l | NUMERIC(3,1) | Engine displacement in litres | 2.0 |
power_bhp | INTEGER | Engine brake horsepower (BHP) | 184 |
co2_g_km | INTEGER | Official manufacturer CO2 emissions (g/km) | 147 |
doors | SMALLINT | Number of doors | 4 |
seats | SMALLINT | Passenger seating capacity | 5 |
seller_name | VARCHAR(128) | Dealership or private seller trading name | Lookers BMW Birmingham |
seller_type | VARCHAR(32) | Franchised Dealer, Independent Dealer, Private | Franchised Dealer |
town | VARCHAR(64) | Dealer town or city | Birmingham |
postcode_area | VARCHAR(8) | UK outward postcode area code | B4 |
image_count | INTEGER | Number of gallery photos | 28 |
first_seen_at | TIMESTAMP | First observed date (UTC) | 2026-09-28 11:04:18 |
last_checked_at | TIMESTAMP | Last checked active date (UTC) | 2026-10-17 19:30:12 |
status | VARCHAR(16) | Active or removed status | active |
Sample record payload
Inspect the exact structure of a representative listing from the AutoTrader UK collection.
{
"advert_id": "at_uk_202610149021948",
"vrm": "LO21XKZ",
"make": "BMW",
"model": "3 Series",
"trim": "320i M Sport",
"year": 2021,
"asking_price_gbp": 24500,
"odometer_miles": 29800,
"odometer_km": 47958,
"fuel_type": "Petrol",
"transmission": "Automatic",
"body_type": "Saloon",
"engine_size_l": 2.0,
"power_bhp": 184,
"co2_emissions_g_km": 147,
"doors": 4,
"seats": 5,
"seller": {
"name": "Lookers BMW Birmingham",
"type": "Franchised Dealer",
"town": "Birmingham",
"postcode_area": "B4"
},
"image_count": 28,
"first_observed_at": "2026-09-28T11:04:18Z",
"last_checked_at": "2026-10-17T19:30:12Z",
"status": "active"
}Source methodology & context
Vehicle records reflect UK market specifics including VRM registration plates, outward postcode areas (e.g. SW1, B4, M1), and official V5C engine displacement in litres.
Prices are captured in native British Pounds (GBP). Converted EUR estimates are provided for pan-European comparative research while preserving the native currency.
Records include official Brake Horsepower (BHP) and certified grams of CO2 per kilometre, essential for ULEZ, Clean Air Zone, and company car tax modeling.
Available delivery formats
Columnar storage compressed with Zstandard / Snappy. Optimal for DuckDB, Polars, PySpark, Snowflake, and BigQuery data warehousing.
Self-contained, serverless relational database with pre-built indexes on listing IDs, VINs, makes, models, and timestamps.
UTF-8 formatted flat comma-separated files with standard header rows, compatible with any spreadsheet tool or custom ETL loader.
Frequently asked questions
Yes. Where published by the seller, the vehicle registration mark is captured, enabling cross-referencing with DVLA MOT history databases.
Yes. Listings cover dealers and private sellers across England, Scotland, Wales, and Northern Ireland with outward postcode geocoding.
We collect passenger cars and light commercial vehicles (vans). You can specify passenger-car-only exports if required.
Yes. Our continuous availability checkers verify advert URLs daily, identifying when listings are marked sold or removed.
Before you order
Include in your request: desired vehicle make/model scope, geographic filter (states/regions), active or historical scope, preferred file format (Parquet, SQLite, CSV), and delivery method.
We will provide a representative validation sample and exact row count before payment. All deliveries include checksum validation files.