Distinct from AutoTrader UK
Autotrader US is a completely independent classifieds platform with USD pricing, US miles, NHTSA VIN requirements, and US dealership networks.
United States / Structured Dataset Collection
Explore our nationwide US Autotrader database collection covering 630,000+ active dealer listings across franchise and independent inventories with VINs, powertrain specifications, and geocoded locations.
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 |
|---|---|---|---|
listing_id | VARCHAR(32) | Autotrader US unique listing identifier | at_us_718290145 |
vin | VARCHAR(17) | 17-character standard Vehicle Identification Number | 5YJSA1E21HF289104 |
make | VARCHAR(64) | Vehicle manufacturer brand | Tesla |
model | VARCHAR(64) | Vehicle model name | Model S |
year | SMALLINT | Model year of production | 2022 |
trim | VARCHAR(128) | Trim description and drivetrain designation | Long Range AWD |
body_style | VARCHAR(48) | Vehicle body configuration | Sedan |
price | NUMERIC(10,2) | Advertised dealer asking price in USD | 54900.00 |
mileage | INTEGER | Odometer reading in miles | 24100 |
fuel_type | VARCHAR(32) | Fuel type (Electric, Gasoline, Hybrid) | Electric |
transmission | VARCHAR(64) | Transmission type and gearing | 1-Speed Automatic |
drivetrain | VARCHAR(16) | Drive wheel configuration (AWD, RWD, FWD) | AWD |
engine | VARCHAR(128) | Powertrain motor or displacement specification | Dual Electric Motors 670hp |
exterior_color | VARCHAR(64) | Exterior paint finish | Pearl White Multi-Coat |
interior_color | VARCHAR(64) | Interior cabin upholstery | All Black Premium |
dealer_name | VARCHAR(128) | Selling dealership name | CarMax Austin |
city | VARCHAR(64) | Dealership city location | Austin |
state | CHAR(2) | US State 2-letter postal code | TX |
zip | VARCHAR(10) | Dealership 5-digit postal code | 78749 |
image_urls | TEXT[] | Array of photo gallery URLs | ["https://images.autotrader.com/.../img1.jpg"] |
first_seen_at | TIMESTAMP | First observed date (UTC) | 2026-10-02 08:15:22 |
last_seen_at | TIMESTAMP | Last observed active date (UTC) | 2026-10-17 21:10:44 |
status | VARCHAR(16) | Active or removed status | active |
Sample record payload
Inspect the exact structure of a representative listing from the Autotrader US collection.
{
"listing_id": "at_us_718290145",
"vin": "5YJSA1E21HF289104",
"make": "Tesla",
"model": "Model S",
"year": 2022,
"trim": "Long Range AWD",
"body_style": "Sedan",
"asking_price_usd": 54900,
"odometer_miles": 24100,
"fuel_type": "Electric",
"transmission": "1-Speed Automatic",
"drivetrain": "AWD",
"engine": "Dual Electric Motors 670hp",
"doors": 4,
"exterior_color": "Pearl White Multi-Coat",
"interior_color": "All Black Premium",
"seller": {
"dealer_name": "CarMax Austin",
"city": "Austin",
"state": "TX",
"zip": "78749",
"seller_type": "Dealer"
},
"first_observed_at": "2026-10-02T08:15:22Z",
"last_observed_at": "2026-10-17T21:10:44Z",
"status": "active"
}Source methodology & context
Autotrader US is a completely independent classifieds platform with USD pricing, US miles, NHTSA VIN requirements, and US dealership networks.
Coverage focuses on dealer inventory with verified dealer IDs, street addresses, and manufacturer certification flags.
Listings include granular horsepower, engine displacement, transmission speed counts, and multi-motor electric vehicle configurations.
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
They are two completely distinct platforms operating in different countries with different currencies (USD vs GBP), odometer units (miles vs km/miles), and vehicle specification taxonomies.
Our US collector focuses on franchise and independent dealer inventory where VINs, complete option codes, and physical dealer addresses are transparently published.
Our parallel partitioned collectors crawl nationwide US inventory daily, cycling through make, model, and regional subdivisions.
Yes. Contact our team with your desired make, model year range, or state, and we will provide a representative Parquet or CSV sample file.
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.