US Vehicle Inspection data - 5 Million rows

US Vehicle Inspection Data

5,000,000 rows | 500,000 unique vehicles | 10 years of inspection history per vehicle

A structured dataset of US state vehicle safety inspection records, covering every inspection event for each vehicle over a 10-year period — ideal for VIN history checks, insurance risk modelling, used-car due diligence, fleet analytics, or training data for automotive ML applications.

Each row represents a single inspection event, so a vehicle with multiple inspections over the decade appears as multiple linked rows (via VIN/Plate), giving you a full odometer and pass/fail timeline per vehicle rather than a single snapshot.

Column Descriptions

• InspectionId — Unique identifier for the inspection record
• Plate — Vehicle license plate number at time of inspection
• Vin — Vehicle Identification Number (17-character) — primary key for tracking a vehicle across multiple inspections
• Year — Model year of the vehicle
• Make — Vehicle manufacturer (e.g. TOYOTA, FORD, SUBARU)
• Model — Vehicle model (e.g. TACOMA, F-150)
• GVWR — Gross Vehicle Weight Rating (lbs)
• StickerNumber — Inspection sticker/certificate number issued
• VehicleType — Category — CAR/TRUCK, HEAVY TRUCK, TRAILER, MOTORCYCLE
• StickerMonth — Month the inspection sticker is valid from
• Odometer — Recorded mileage at time of inspection
• FuelType — GASOLINE, DIESEL, HYBRID, PLUGIN ELECTRIC, FLEXIBLE FUEL/E85
• OverallTestResult — Final inspection outcome — PASS / FAIL / ABORTED
• SafetyInspectionResult — Result of the safety-specific portion of the inspection
• StationNumber — ID of the inspection station
• StationName — Name of the inspection station/garage
• StationAddress — Street address of the inspection station
• PrimaryTechNumber — ID of the certified inspecting technician
• TechName — Name of the inspecting technician
• TestDate — Date the inspection was performed
• TestTime — Time the inspection was performed
• HasOpenRecalls — Flag (0/1) indicating open manufacturer recalls at time of inspection
• InspectionItemsJson — Itemised pass/fail breakdown by system — e.g. Brakes, Steering & Suspension, Lighting & Electrical, Exhaust, Fuel System, Body, Glazing, Tires (JSON object)
• HasCoreData — Flag indicating whether core inspection data was successfully captured
• Success — Flag indicating the record fetch/parse was successful
• ErrorMessage — Error detail if the record fetch failed (blank on success)
• FetchedAtUtc — Timestamp the record was collected/fetched
• HttpStatus — HTTP response status from the data source at collection time
• FetchError — Additional error detail from the fetch process (blank on success)