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
Active insurance policies: BIPD, cargo, bond/trust filings with insurer names and coverage amounts.
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;Updated 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.