Carrier Ledger U.S. DOT Motor Carrier Safety Records

USDOT FMCSA Census, Crash & Terminal Reconciliation Methodology

Carrier Ledger deterministically reconciles four U.S. Department of Transportation Socrata bulk datasets covering 169,161 motor carriers, 451,667 deduplicated commercial crashes, 22,311 involuntary authority revocations, and 88,652 outright insurance cancellations (publication 75ca41809bb209ca3214).

Publication ID: 75ca41809bb209ca3214 Retrieved: 2026-11-06 Verified VMT Bounds: 1,000 to 250,000 mi/PU

1. Authoritative U.S. DOT Socrata Sources

2. MCS-150 Mileage Quarantine & Privacy-Preserving Yard Hashing

Per-100M-VMT crash rates are computed strictly for the 75,648 carriers whose Form MCS-150 mileage year is 2021 or newer and whose annual miles per power unit fall within [1,000, 250,000]. The remaining 93,513 carriers (including 35 calendar-year-in-mileage anomalies) are quarantined in dq_vmt_review. Raw street addresses and telephone numbers are cryptographically hashed after stripping 26,952 suite/PMB tokens and excluding 1,045 commercial mail drops so public marts expose zero raw personal street or phone PII.

Pipeline Quality & Reconciliation Audit Checks (Publication 75ca41809bb209ca3214)
Reconciliation Metric Verified Count Integrity Guarantee
Verified VMT vs Quarantined VMT Carriers 75,648 / 93,513 Zero unverified denominators in per-100M-VMT rankings
Duplicate Crash Sequence Rows Collapsed 1,433 Prevents multi-unit state report sequences from double-counting crashes
Docket-Recovered Revocations & Insurance Rows 271 / 477 Recovers zero-filled USDOT enforcement filings via MC/FF/MX docket bridge
Commercial Mail Drops & Filing Agent Phones Excluded 1,045 / 12 Prevents UPS Store PMBs and permit agents from triggering contagion flags
Raw Street & Phone PII in Public Marts 0 Verified by automated CI check zero_raw_phone_or_street_in_public_marts

3. Reproducible Architecture & Companion Engineering Guides

Every Carrier Ledger release binds Socrata snapshot SHA-256 digests, DuckDB quarantine audits, and zero-PII public mart schemas into a deterministic publication artifact. For deeper engineering documentation on how Meru AI structures verifiable civic and logistics datasets, consult the technical guide on checksummed public-data reconciliation, the distribution operations case study, the supply-chain and environmental entity resolution guide, AI systems for law firms, AI automation consulting, the public-data platforms overview, or reach out via custom data and partnership inquiries.