1. Authoritative U.S. DOT Socrata Sources
- FMCSA Company Census File (
az4n-8mr2): 169,161 registered motor carriers covering 100% of California-domiciled fleets with 2 or more power units (105,549) and 100% of U.S. national fleets with 25 or more power units (69,273), retaining active and inactive registrations. - MCMIS Commercial Crash File (
aayw-vxb3): 1,080,209 raw police-reported commercial crash rows from 2021-01-01 onward, deduplicated across multi-sequence crash keys into 451,667 cohort crashes (1,433 duplicate sequence rows collapsed). - Operating Authority Revocations (
sa6p-acbp): 521,650 federal revocation orders (2020+) linked via canonical USDOT and stripped MC/FF/MX docket keys into 22,311 cohort involuntary revocations. - Licensing & Insurance History (
6sqe-dvqs): 1,553,175 BIPD, cargo, and bond filings (2023+) classified into 88,652 outright cancellations vs routine policy replacements.
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.
| 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.