DOT Census Explorer
About
Back to search Back

About this site

This site shows public U.S. government records about trucking and bus companies: who they are, their safety scores, inspections, crashes, and insurance.

It updates itself automatically whenever the government publishes new data.

Data sources for the curious Every dataset, how often it changes, and when it was last updated here

Everything comes from public FMCSA releases on the DOT Public Data Portal. An automated updater checks each source hourly and re-imports it when FMCSA publishes a new file — daily, weekly, or monthly depending on the dataset. All times below are when this database last imported the file.

Registration

Dataset Cadence Rows Source file Last updated
Company Census File MCS-150 registration data for every DOT-registered entity. companies daily 4,523,399 Company_Census_File_20261027.csv.gz

Inspections

Dataset Cadence Rows Source file Last updated
Vehicle Inspection File Roadside inspections, 3-year window. One row per inspection. inspections weekly 8,284,557 Vehicle_Inspection_File_20261026.csv.gz
Inspections Per Unit Vehicle units examined per inspection (make, plate, VIN). inspection_units weekly 13,811,092 Inspections_Per_Unit_20261026.csv.gz
Vehicle Inspections and Violations Each violation cited during an inspection (49 CFR part, OOS flag). inspection_violations weekly 13,549,053 Vehicle_Inspections_And_Violations_20261025.csv.gz
Inspections and Citations Citations issued with inspections. inspection_citations weekly 28,423 Inspections_And_Citations_20261026.csv.gz
Violation Code Dictionary FMCSA descriptions, BASIC category and severity weight per 49 CFR violation code (distilled from SMS Input – Violation). violation_codes monthly 1,945 SMS_Input_-_Violation_20261013.csv.gz

Crashes

Dataset Cadence Rows Source file Last updated
Crash File Federal/state crash reports, full history. One row per vehicle involved. crash_records daily 5,018,645 Crash_File_20261028.csv.gz
SMS Input – Crash 24-month crash snapshot used in SMS calculations (severity weights). crashes monthly 311,487 SMS_Input_-_Crash_20261013.csv.gz

Licensing & Insurance

Dataset Cadence Rows Source file Last updated
Carrier (authority status) Operating-authority status and insurance requirements per docket. li_carriers daily 1,860,849 Carrier_20261028.csv.gz
ActPendInsur (active/pending insurance) Active and pending insurance policies with coverage amounts. li_active_insurance daily 467,983 ActPendInsur_20261027.csv.gz
Insur (policy detail) Per-policy insurance detail, keyed by docket. li_insurance daily 467,984 Insur_20261027.csv.gz
InsHist (insurance history) Cancelled / replaced insurance policy history. li_insurance_history weekly 7,427,947 InsHist_20261026.csv.gz
AuthHist (authority history) Grant / revoke history for each operating authority. li_auth_history weekly 4,941,431 AuthHist_20261026.csv.gz
Revocation Revoked authorities with order types and dates. li_revocations daily 1,529,083 Revocation_20261027.csv.gz
BOC-3 (process agents) Blanket process agent designations. li_boc3 weekly 1,861,044 BOC3_20261026.csv.gz
Rejected (insurance filings) Insurance filings rejected by FMCSA, with reasons. li_rejected daily 7,145 Rejected_20261027.csv.gz

Safety Measurement System (SMS)

Dataset Cadence Rows Source file Last updated
SMS AB Pass BASIC results — interstate / hazmat passenger carriers. sms_basics monthly 8,625 SMS_AB_Pass_20261013.csv.gz
SMS AB PassProperty BASIC results — interstate / hazmat property & passenger carriers. sms_basics monthly 676,951 SMS_AB_PassProperty_20261013.csv.gz
SMS C Pass BASIC results — intrastate non-hazmat passenger carriers. sms_basics monthly 19,855 SMS_C_Pass_20261013.csv.gz
SMS C PassProperty BASIC results — intrastate non-hazmat property & passenger carriers. sms_basics monthly 1,455,917 SMS_C_PassProperty_20261013.csv.gz

Derived (rebuilt after every import)

Dataset Cadence Rows Source file Last updated
Carrier safety roll-up Per-DOT summary of SMS alerts and crash counts (powers search chips). carrier_safety after each import 2,166,613 —
SMS measure percentile bands Non-zero measure breakpoints by SMS inspection-count cohort (ISS + BASIC cards). sms_measure_bands after each import 119 —
Crash Indicator measure bands Weighted-crash / power-unit percentiles by Combination vs Straight cohort. crash_measure_bands after each import 10 —
ISS inspection-rate quantiles Peer ranks of inspection-per-unit rates for the insufficient-data ISS algorithm. iss_insp_rate_quantiles after each import 1 —

Unofficial mirror for reference only — FMCSA publishes the authoritative data at ai.fmcsa.dot.gov and data.transportation.gov. Source data is U.S. Government work in the public domain.