- ID: Unique identifier for each car listing.
- Heading: Title or headline of the car listing.
- Vdp URL: URL link to the vehicle detail page.
- Price: Listed price of the car.
- Currency Indicator: Currency in which the price is listed.
- Miles: Mileage of the car.
- Miles Indicator: Indicator for mileage (e.g., miles, kilometres).
- Year: Manufacturing year of the car.
- Make: Manufacturer of the car.
- Model: Model of the car.
- Variant: Specific variant or trim level of the car model.
- Body Type: Body style of the car (e.g., sedan, hatchback).
- Drivetrain: Type of drivetrain (e.g., FWD, RWD, AWD).
- Fuel Type: Type of fuel the car uses (e.g., petrol, diesel).
- Transmission: Type of transmission (e.g., manual, automatic).
- Doors: Number of doors the car has.
- Insurance Group: Insurance group rating.
- Vehicle Registration Mark: Registration mark of the vehicle.
- Vehicle Registration Date: Date of vehicle registration.
- Num Owners: Number of previous owners.
- Interior Colour: Interior colour of the car.
- Exterior Colour: Exterior colour of the car.
- Source: Source of the listing.
- Dealer ID: Unique identifier for the dealer.
- Seller Name: Name of the seller or dealer.
- Street: Street address of the seller.
- City: City where the seller is located.
- County: County where the seller is located.
- Postal Code: Postal code of the seller’s location.
- Latitude: Latitude coordinate of the seller’s location.
- Longitude: Longitude coordinate of the seller’s location.
- Country: Country where the seller is located.
- Seller Phone: Contact phone number of the seller.
- Inventory Type: Type of inventory (e.g., new, used).
- Scraped At: Date and time when the data was scraped.
- Status Date: Date when the listing status was last updated.
- First Scraped At: Date and time when the listing was first scraped.
- Photo URL: URL of the main photo.
- Photo Links: Links to all photos.
- Options: List of optional features or packages.
- Features: List of standard features.
- Seller Comments: Additional comments from the seller.
- Images Count: Number of images in the listing.
- Engine Size: Engine size in litres.
- Performance Torque Ftlb: Performance torque in foot-pounds.
- Performance Maxspeed Mph: Maximum speed in miles per hour.
- Performance Torque Rpm: RPM at which maximum torque is delivered.
- Performance Power Bhp: Power output in brake horsepower.
- Performance Power Rpm: RPM at which maximum power is delivered.
- Performance Torque Nm: Performance torque in Newton-meters.
- Performance Power Kw: Power output in kilowatts.
- Performance Acceleration Zero To 60 Mph: Acceleration time from 0 to 60 mph.
- Performance Acceleration Mph: Acceleration performance.
- Performance Co2: CO2 emissions.
- Efficiency Extraurban Mpg: Fuel e_iciency in extra-urban conditions (miles per gallon).
- Efficiency Urbancold Mpg: Fuel e_iciency in urban conditions (miles per gallon).
- Efficiency Combined Mpg: Combined fuel e_iciency (miles per gallon).
- Dom Active: Days on market – active.
- Dom 180: Days on market in the last 180 days.
- Dom: Total days on market.
- Write Off Category: Write-o_ category if applicable.
- Car Seller Name: Name of the car seller.
- Car Street: Street address of the car seller.
- Car City: City of the car seller.
- Car County: County of the car seller.
- Car Postal Code: Postal code of the car seller.
- FCA Status: Financial Conduct Authority status.
- FCA Reference No: Financial Conduct Authority reference number.
- Seller Email: Email address of the seller.
- Seating Capacity: Number of seats in the car.
- Euro Status: Euro emission standard status.
- Imported: Whether the car is imported or not.
- Scrapped: Whether the car is scrapped or not.
- Is Van: Indicator if the vehicle is a van.
- EV Battery Type: Type of electric vehicle battery.
- EV Battery Capacity: Capacity of the electric vehicle battery.
- EV Vehicle Range: Range of the electric vehicle on a full charge.
- Is Price Included Vat: Indicator if the price includes VAT.
- Dealership Group ID: Unique identifier for the dealership group.
- Dealership Group Name: Name of the dealership group.
- Sub Dealership Group ID: Unique identifier for the sub dealership group.
- Sub Dealership Group Name: Name of the sub dealership group.
- Is ULEZ Compliant: Indicator if the vehicle is ULEZ (Ultra Low Emission Zone) compliant.
- Model Normalised: Normalised model name.
- DOS Active: Days on website – active.
- Base Exterior Colour: Colour normalised.
- Fuel Type Normalised: Normalising fuel into 5 categories; diesel, petrol, hybrid, electric and other.
- Car Longitude: Longitude coordinate of the car seller’s location.
- Car Latitude: Latitude coordinate of the car seller’s location.
- Wheelbase: The distance between the front and rear axles of the car, affecting handling and stability.
- Wheelbase Category: Classification of the car’s wheelbase length (e.g., short, medium, long).