Carriers
Core carrier records: DOT number, legal name, address, fleet size, cargo types, operation classification, and MCS-150 data.
Bulk Downloads
Free FMCSA data.
Ready to use.
Cleaned, joined, and exported daily from the FMCSA SAFER dataset. Download as CSV, Parquet, or a single SQLite database.
Safety
Crash and inspection statistics, OOS rates, and BASIC scores for each carrier.
Insurance
Insurance filings: BIPD, cargo, surety and trust-fund policies with insurer names, form codes and effective dates. One row per filing, so a carrier can appear more than once. FMCSA publishes a coverage amount only for BIPD — cargo, surety and trust-fund filings always report 0, which means "not published", not "no coverage".
Insurance Summary
One row per carrier: the highest currently-active BIPD coverage on file. Recomputed daily against the current date, so it reflects today rather than any fixed snapshot. The max_cargo column is always 0 because FMCSA does not publish cargo amounts — use the full Insurance dataset to see whether a cargo filing exists.
SQLite Database
All tables in a single SQLite file. Open with any SQLite client, DBeaver, or Datasette.
Query remotely with DuckDB
No download needed — query the Parquet files directly over HTTPS with DuckDB.
SELECT dot_number, legal_name, phy_state, total_power_units
FROM read_parquet('https://data.dotlookup.dev/carriers.parquet')
WHERE phy_state = 'TX' AND total_power_units > 100
ORDER BY total_power_units DESC
LIMIT 20;Know which snapshot you have
Every export publishes a manifest.json naming the snapshot date, the ETL run that produced it, and the expected size and row count of each file. It is uploaded last, after every data file has landed.
The files are republished in place, so a download that straddles an update can mix one day's file
with another's. If that matters to you, read the manifest first and check each file's
Content-Length against it — a mismatch means you caught an update in progress, so wait
and retry.
curl -s https://data.dotlookup.dev/manifest.jsonUpdated Daily
Automated ETL pipeline refreshes all datasets from the latest FMCSA SAFER snapshot every day. See current status.
Public Domain
Source data is published by the US government. No license restrictions — use it for anything.
Cleaned & Joined
Raw FMCSA tables are cleaned, deduplicated, and joined by DOT number into analysis-ready datasets.