17-Character Standard VINs
Every record in the enriched Cars.com dataset contains a validated 17-character VIN compliant with ISO 3779 / NHTSA standards, enabling seamless CARFAX, AutoCheck, and internal fleet cross-matching.
United States / Structured Dataset Collection
Enquire about the collected Cars.com database spanning 1,600,000+ US vehicle listings with verified 17-character VINs, franchise and independent dealer locations, and enriched specifications across all 50 states.
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) | Cars.com primary unique listing identifier | cars_98241029 |
vin | VARCHAR(17) | Standard 17-character NHTSA Vehicle Identification Number | 1FA6P8CF8H5192834 |
make | VARCHAR(64) | Manufacturer brand name | Ford |
model | VARCHAR(64) | Vehicle model line | Mustang |
year | SMALLINT | Model year of manufacture | 2021 |
trim | VARCHAR(128) | Equipment trim and sub-model package | GT Premium Fastback |
body_style | VARCHAR(48) | Standard vehicle body classification | Coupe |
price | NUMERIC(10,2) | Advertised dealer asking price in USD | 38990.00 |
msrp | NUMERIC(10,2) | Manufacturer Suggested Retail Price if published | 44120.00 |
mileage | INTEGER | Odometer reading recorded in imperial miles | 18450 |
fuel_type | VARCHAR(32) | Primary fuel (Gasoline, Hybrid, Electric, Diesel) | Gasoline |
transmission | VARCHAR(64) | Gearbox specification and speed count | 6-Speed Manual |
drivetrain | VARCHAR(16) | Wheel drive configuration (RWD, FWD, AWD, 4WD) | RWD |
engine | VARCHAR(128) | Engine configuration, displacement and power output | 5.0L V8 Ti-VCT 460hp |
doors | SMALLINT | Number of passenger doors | 2 |
exterior_color | VARCHAR(64) | Manufacturer exterior finish paint name | Shadow Black |
interior_color | VARCHAR(64) | Interior upholstery material and color | Ebony Leather |
dealer_name | VARCHAR(128) | Selling dealership franchise or business name | AutoNation Ford |
city | VARCHAR(64) | Dealership physical location city | Dallas |
state | CHAR(2) | US State 2-letter postal code (50 US states) | TX |
zip | VARCHAR(10) | 5-digit US postal ZIP code | 75201 |
seller_type | VARCHAR(32) | Seller class (Franchise Dealer, Independent Dealer) | Franchise Dealer |
stock_type | VARCHAR(16) | Vehicle inventory status (Used, New, Certified) | Used |
features | TEXT[] | Extracted factory equipment, options and amenities | ["Leather Seats", "Apple CarPlay", "Brembo Brakes"] |
photo_urls | TEXT[] | Array of high-resolution hosted photo links | ["https://images.cars.com/cldstatic/wp-content/.../photo1.jpg"] |
listing_url | TEXT | Original canonical listing URL on Cars.com | https://www.cars.com/vehicledetail/98241029/ |
first_seen_at | TIMESTAMP | Timestamp when first crawled by discovery daemon (UTC) | 2026-09-12 14:22:10 |
last_seen_at | TIMESTAMP | Timestamp when last verified active (UTC) | 2026-10-17 18:45:00 |
status | VARCHAR(16) | Current status (active or observed removed) | active |
Sample record payload
Inspect the exact structure of a representative listing from the Cars.com collection.
{
"listing_id": "cars_98241029",
"vin": "1FA6P8CF8H5192834",
"make": "Ford",
"model": "Mustang",
"year": 2021,
"trim": "GT Premium Fastback",
"body_style": "Coupe",
"asking_price_usd": 38990,
"msrp_usd": 44120,
"odometer_miles": 18450,
"fuel_type": "Gasoline",
"transmission": "6-Speed Manual",
"drivetrain": "RWD",
"engine": "5.0L V8 Ti-VCT 460hp",
"doors": 2,
"exterior_color": "Shadow Black",
"interior_color": "Ebony Leather",
"dealer": {
"name": "AutoNation Ford",
"city": "Dallas",
"state": "TX",
"zip": "75201",
"seller_type": "Franchise Dealer"
},
"features": [
"Leather Seats",
"Navigation System",
"Apple CarPlay",
"Backup Camera",
"Blind Spot Monitor",
"Heated Seats"
],
"photo_count": 32,
"listing_url": "https://www.cars.com/vehicledetail/98241029/",
"first_observed_at": "2026-09-12T14:22:10Z",
"last_observed_at": "2026-10-17T18:45:00Z",
"status": "active"
}Source methodology & context
Every record in the enriched Cars.com dataset contains a validated 17-character VIN compliant with ISO 3779 / NHTSA standards, enabling seamless CARFAX, AutoCheck, and internal fleet cross-matching.
Prices recorded represent the published dealer asking prices in USD. They do not include dealer doc fees, sales tax, registration, or post-negotiation auction sale settlements.
Discovery crawls continuously map nationwide inventory volumes; our deep-enrichment daemons harvest complete vehicle options, trim packages, and high-resolution photo arrays.
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
VINs are extracted directly from dealer listings and verified against the standard 17-character alphanumeric NHTSA checksum formula (excluding I, O, and Q). Records with invalid or masked VINs are flagged explicitly.
Yes. Custom exports can be filtered by US state (e.g. California, Texas, Florida), vehicle make/model, minimum model year, price range, or body style to fit your pipeline.
We deliver datasets in Apache Parquet (compressed with Zstandard), SQLite 3 with pre-built indexes on VIN and listing ID, or RFC 4180-compliant CSV files.
Our verification workers re-check active URLs. When a listing is removed by the dealer or the portal returns a 404/inactive state, the record receives a delisted timestamp to measure observed Days on Market (DOM).
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.