About the data

Everything on this site 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,449,425	Company_Census_File_20260610.csv.gz	2026-06-10T03:20:12.219708+00:00

Inspections

Dataset	Cadence	Rows	Source file	Last updated
Vehicle Inspection File Roadside inspections, 3-year window. One row per inspection. `inspections`	weekly	8,167,203	Vehicle_Inspection_File_20260609.csv.gz	2026-06-09T22:35:03.182116+00:00
Inspections Per Unit Vehicle units examined per inspection (make, plate, VIN). `inspection_units`	weekly	13,251,616	Inspections_Per_Unit_20260609.csv.gz	2026-06-09T22:52:38.294108+00:00
Vehicle Inspections and Violations Each violation cited during an inspection (49 CFR part, OOS flag). `inspection_violations`	weekly	13,019,841	Vehicle_Inspections_And_Violations_20260609.csv.gz	2026-06-09T23:03:12.855654+00:00
Inspections and Citations Citations issued with inspections. `inspection_citations`	weekly	27,333	Inspections_And_Citations_20260609.csv.gz	2026-06-09T22:02:58.823961+00:00
Violation Code Dictionary FMCSA descriptions, BASIC category and severity weight per 49 CFR violation code (distilled from SMS Input – Violation). `violation_codes`	monthly	1,959	SMS_Input_-_Violation_20260610.csv.gz	2026-06-10T14:55:43.771697+00:00

Crashes

Dataset	Cadence	Rows	Source file	Last updated
Crash File Federal/state crash reports, full history. One row per vehicle involved. `crash_records`	daily	4,949,346	Crash_File_20260609.csv.gz	2026-06-09T22:01:18.054696+00:00
SMS Input – Crash 24-month crash snapshot used in SMS calculations (severity weights). `crashes`	monthly	258,057	SMS_Input_-_Crash_20260610.csv.gz	2026-06-10T03:30:09.611624+00:00

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,604	Carrier_20260609.csv.gz	2026-06-09T21:43:15.080854+00:00
ActPendInsur (active/pending insurance) Active and pending insurance policies with coverage amounts. `li_active_insurance`	daily	467,983	ActPendInsur_20260609.csv.gz	2026-06-09T21:37:16.346925+00:00
Insur (policy detail) Per-policy insurance detail, keyed by docket. `li_insurance`	daily	467,984	Insur_20260609.csv.gz	2026-06-09T21:38:18.024799+00:00
InsHist (insurance history) Cancelled / replaced insurance policy history. `li_insurance_history`	weekly	7,427,776	InsHist_20260609.csv.gz	2026-06-09T21:51:34.126089+00:00
AuthHist (authority history) Grant / revoke history for each operating authority. `li_auth_history`	weekly	4,941,925	AuthHist_20260609.csv.gz	2026-06-09T21:55:03.658209+00:00
Revocation Revoked authorities with order types and dates. `li_revocations`	daily	1,529,083	Revocation_20260609.csv.gz	2026-06-09T21:44:49.519492+00:00
BOC-3 (process agents) Blanket process agent designations. `li_boc3`	weekly	1,860,604	BOC3_20260609.csv.gz	2026-06-09T21:56:12.658184+00:00
Rejected (insurance filings) Insurance filings rejected by FMCSA, with reasons. `li_rejected`	daily	13,202	Rejected_20260609.csv.gz	2026-06-09T21:33:27.325768+00:00

Safety Measurement System (SMS)

Dataset	Cadence	Rows	Source file	Last updated
SMS AB Pass BASIC results — interstate / hazmat passenger carriers. `sms_basics`	monthly	8,842	SMS_AB_Pass_20260610.csv.gz	2026-06-10T03:26:20.950971+00:00
SMS AB PassProperty BASIC results — interstate / hazmat property & passenger carriers. `sms_basics`	monthly	699,955	SMS_AB_PassProperty_20260610.csv.gz	2026-06-10T03:27:03.331947+00:00
SMS C Pass BASIC results — intrastate non-hazmat passenger carriers. `sms_basics`	monthly	27,704	SMS_C_Pass_20260610.csv.gz	2026-06-10T03:27:21.121512+00:00
SMS C PassProperty BASIC results — intrastate non-hazmat property & passenger carriers. `sms_basics`	monthly	1,377,353	SMS_C_PassProperty_20260610.csv.gz	2026-06-10T03:29:30.133679+00:00

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,077,308	—	2026-06-10T14:56:28.006915+00:00
SMS measure percentile bands Population percentile breakpoints used to rate PassProperty BASICs. `sms_measure_bands`	after each import	20	—	2026-06-10T14:56:28.006915+00:00

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.