The FMCSA carrier universe in one documented, load-ready dataset.
4,516,324 carriers (2,240,593 active), 1,529,584 authority dockets, 486,339 insurance filings and 7,247,040 past filings from FMCSA open data. CSV and Parquet, with an active-only extract.
FMCSA National Motor Carrier Dataset, 2026-10 Edition
US$149 one time
US$399 one time
The free sample is 1,000 active Wyoming carriers that have authority and a reported insurance filing, with their child rows in the production schema. It contains: sample/carriers_sample.csv, sample/authority_dockets_sample.csv, sample/insurance_filings_sample.csv, sample/insurance_history_sample.csv, sample/SAMPLE_README.txt, docs/README.md, docs/DATA_DICTIONARY.csv, docs/LIMITATIONS.md.
You want to sell something to trucking companies. But where do you find them?
Imagine you've developed a product or service for trucking companies. Maybe it's fleet management software, insurance services, equipment, or something else. You know there are thousands of potential customers across the United States, but how do you find the ones most likely to need what you're selling?
You could spend weeks searching Google, collecting company names, and building spreadsheets. But you still wouldn't know much about these businesses. How many trucks do they operate? Where are they located? Are they registered as active? Which companies are large enough to be worth approaching? And how big is your potential market in the first place?
The good news is that the U.S. government already collects much of this information. The bad news is that it's scattered across different databases, with inconsistent formats and records that aren't always up to date. Putting everything together can become a project of its own.
That's where Persistfolio's FMCSA National Motor Carrier Dataset comes in. We've brought together approximately 4.5 million motor carrier records, along with operating authority and insurance filing information, into one organized dataset. You can explore carriers by location, fleet size, and other characteristics without having to assemble all those government files yourself.
Maybe you'll use it to identify potential customers, decide which states to expand into, research the trucking industry, or develop a service of your own. It's not a ready-made list of qualified leads, and some information needs to be checked against current FMCSA records before you rely on it. But it gives you something valuable: a much clearer picture of the market you're trying to reach.
Because before you can sell to trucking companies, you need to know who they are and where to find them.
Need something more specific?
Don't need the entire dataset? Request an extract for selected years, entities, or records, or a research table or report based on this dataset. We review the scope and quote a price before work begins.
Request a Custom Extract or Report →Who is this dataset for?
- Freight brokers, shippers and carrier-onboarding teams who screen carriers by authority, status, fleet size and insurance filings
- Sales and market-intelligence teams building lists of motor carriers by state, fleet size, cargo and operation type
- Analysts and researchers who need the full FMCSA carrier universe in one joined, documented snapshot
What can you do with it?
Screen carriers before onboarding
Filter authority_dockets by status and carriers by status_code, power_units and mcs150_age_days; read verify_live_reasons for carriers whose data is old or where official sources disagree, and verify those on the FMCSA portal.
Build a carrier list by state, fleet and cargo
Select active carriers in carriers_active, filter by physical_state, power_units and cargo columns, and keep the source and as-of columns so every row can be checked.
Study the carrier population
Join carriers to authority_dockets, insurance_filings and insurance_history on usdot_number to analyse authority, filings and fleet by state or operation type.
How to use the files
- Download the free sample and read README, LIMITATIONS and the data dictionary to learn the tables, source dates and flags.
- Read the limitations before relying on any record: insurance filings are not verified coverage and some authority data is frozen at 2026-05-14.
- Load the Parquet or CSV files into DuckDB, pandas or your database; start from carriers_active or carriers_all and join the child tables on usdot_number.
In carriers_active filter physical_state = TX and power_units >= 10, then join authority_dockets on usdot_number and keep rows where verify_live_reasons is empty; verify any flagged carrier on the FMCSA portal.
Try real records before buying
The table below uses actual rows from this release’s free sample, not simulated data. Blank cells are left blank as supplied. The preview is shortened for readability; download the sample for all columns and complete cell values.
| usdot_number | legal_name | status_code | authority_active_any | power_units | mcs150_date |
|---|---|---|---|---|---|
| 171801 | KENYON TRUCKING INC | A | true | 2 | 2026-01-08 |
| 174559 | U-KNOW SERVICE LLC | A | true | 15 | 2025-05-28 |
| 175899 | HOMAX OIL SALES INC | A | true | 97 | 2025-07-21 |
| 177589 | FULLMER TRUCKING LLC | A | true | 3 | 2026-02-05 |
| 177751 | PINE BLUFFS FEED AND GRAIN TRUCKING INC | A | true | 1 | 2026-05-14 |
| 186272 | S & T TRUCKING INCORPORATED | A | true | 5 | 2025-02-14 |
| 191059 | BONANZA EARTH RELOCATORS LLC | A | true | 6 | 2025-09-26 |
| 191414 | PC TRANSPORT INC | A | true | 30 | 2026-06-26 |
Download sample CSV — no account or email required → · Full sample package (ZIP) →
Which edition and license should you buy?
One fixed edition, built from FMCSA Census data of 2026-10-12, Motus data of 2026-10-12 and legacy tables frozen at 2026-05-14. Both tiers receive the identical complete dataset (all carriers and an active-only extract, CSV and Parquet). The Individual / Academic tier is for one named person’s own academic, research, journalistic or professional-analysis work; the Business / Commercial tier is for internal use within one legal entity, including vetting and prospecting. No updates are promised.
Why buy this instead of using free source data?
The FMCSA data is free but split across many datasets with different layouts, legacy and current systems and inconsistent amounts. This edition joins them once, documents every merge rule and source date, flags records that need live verification, and ships ready-to-load files with checksums.
What happens after payment?
After secure checkout you receive a private download link for one ZIP (35 files, about 1.37 GB) with CSV and Parquet tables, documentation, QA reports, a sample and checksums. You must accept the license at checkout.
What You Get
- Carriers (all 4,516,324 and an active-only extract), authority dockets, insurance filings and insurance history, each as gzip CSV and Parquet
- Data dictionary, methodology, limitations, quality report, adjudication record, date-anomaly list, checksums and manifest
- A free sample of 1,000 active carriers with their child rows
- Read the limitations first: insurance filings are not verified coverage; part of the authority data is frozen at 2026-05-14
What This Does Not Contain
- No dedicated e-mail address column (authority status-reason text can contain e-mail-shaped strings), fax, cell, officers, mailing addresses, BOC-3 agents, DUNS, policy numbers, safety-measurement percentiles, per-inspection or per-incident detail, or individual driver records (aggregate driver counts are included).
What the file does that the raw FMCSA tables do not
- Joins Census, Motus and frozen legacy tables on USDOT number and docket under documented rules, with source and as-of columns on every table
- Flags records that need live verification (old registration, frozen legacy data, implausible dates, official sources that disagree)
- Separates insurance filing evidence from verified coverage and says plainly what bulk data cannot show
- Ships an active-only extract, Parquet and CSV, a data dictionary and checksums
Coverage & Product Facts
- Coverage
- FMCSA registry as of 2026-10-12 – 2026-10-12
- Source
- FMCSA open data on data.transportation.gov: Company Census File, Motus carrier, authority, insurance and history tables, and legacy tables frozen 2026-05-14
- Observation Frequency
- One dated snapshot (Census and Motus 2026-10-12; legacy tables frozen 2026-05-14)
- Release
- fmcsa-national-carriers-2026-10 (2026-10-12)
- Formats
- CSV (gzip) + Parquet
- Update Policy
- Fixed, dated edition; one-time purchase. No updates, subscription or live feed are included or promised.
Methodology & QA
Census, Motus and frozen legacy tables are pulled from data.transportation.gov, joined on USDOT number and docket under documented rules (Motus preferred over legacy; Census as the primary phone source), normalised and flagged. Two independent builds are byte-identical and an independent fidelity check compared 25,996 cells with no mismatch.
Certification status: QA-complete. NOT certified: no blind independent audit has passed. An external review of 39 records found no confirmed material error but was not blind and did not verify every field. No legal opinion has been obtained. — read the full certification report →
Data Dictionary
| File | Field | Description |
|---|---|---|
| carriers | usdot_number | USDOT number, unpadded integer text; primary key [normalized; text] |
| carriers | status_code | A Active, I Inactive, P Pending (Census record status) [reported; text] |
| carriers | add_date | Date the record was added to the Census [normalized; date] |
| carriers | legal_name | Legal name as registered [reported; text] |
| carriers | dba_name | Doing-business-as name; blank when none [reported; text] |
| carriers | entity_class | CORPORATION, INDIVIDUAL, PARTNERSHIP or blank (source did not classify; never inferred) [reported; text] |
| carriers | phy_street | Physical street address as registered; blank when entity_class is INDIVIDUAL (rule N1) [reported; text] |
| carriers | phy_city | Physical city [reported; text] |
| carriers | phy_state | Physical state or province code [reported; text] |
| carriers | phy_zip | Physical ZIP or postal code; blank when entity_class is INDIVIDUAL (rule N1) [reported; text] |
| carriers | phy_country | Physical country code [reported; text] |
| carriers | phy_county_code | Physical county code [reported; text] |
| carriers | phy_address_undeliverable | U = mail to the physical address was returned undeliverable; N otherwise; blank unknown [reported; text] |
| carriers | phone | Business telephone as in the source; blank when entity_class is INDIVIDUAL (rule N1) [reported; text] |
| carriers | phone_source | census, motus_fallback or blank (blank when phone is blank or withheld) [derived; text] |
| carriers | identity_withheld | N1_INDIVIDUAL when street, ZIP and phone are withheld; otherwise blank [derived; text] |
| carriers | identity_rule_version | N1-1 on every row [constant; text] |
| carriers | carrier_operation | A interstate, B intrastate hazmat, C intrastate non-hazmat; blank when not reported [reported; text] |
| carriers | operation_classification | Operation classification list separated by semicolons [reported; text] |
| carriers | hazmat_flag | true if the carrier reports hazardous-materials operations [normalized; bool] |
| carriers | power_units | Self-reported power units (MCS-150) [reported; int] |
| carriers | truck_units | Self-reported truck units [reported; int] |
| carriers | bus_units | Self-reported bus units [reported; int] |
| carriers | fleet_size | Census fleet size code/count as reported [reported; int] |
| carriers | total_drivers | Self-reported drivers [reported; int] |
| carriers | total_cdl_drivers | Self-reported CDL drivers [reported; int] |
| carriers | total_intrastate_drivers | Self-reported intrastate drivers [reported; int] |
| carriers | drivers_interstate_total | Self-reported interstate drivers [reported; int] |
| carriers | drivers_interstate_beyond_100mi | Interstate drivers operating beyond 100 miles [reported; int] |
| carriers | drivers_interstate_within_100mi | Interstate drivers operating within 100 miles [reported; int] |
| carriers | drivers_intrastate_beyond_100mi | Intrastate drivers operating beyond 100 miles [reported; int] |
| carriers | drivers_intrastate_within_100mi | Intrastate drivers operating within 100 miles [reported; int] |
| carriers | avg_drivers_leased_per_month | Average leased drivers per month [reported; int] |
| carriers | mcs150_date | Date of the last MCS-150 update [normalized; date] |
| carriers | mcs150_mileage | Self-reported annual mileage [reported; int] |
| carriers | mcs150_mileage_year | Year of the reported mileage [reported; int] |
| carriers | mcs150_age_days | Days between census_as_of and mcs150_date; arithmetic only [derived; int] |
| carriers | equip_own_truck | Equipment count as reported (own truck) [reported; int] |
| carriers | equip_own_tractor | Equipment count as reported (own tractor) [reported; int] |
| carriers | equip_own_trailer | Equipment count as reported (own trailer) [reported; int] |
| carriers | equip_own_coach | Equipment count as reported (own coach) [reported; int] |
| carriers | equip_own_school_1_8 | Equipment count as reported (own school 1 8) [reported; int] |
| carriers | equip_own_school_9_15 | Equipment count as reported (own school 9 15) [reported; int] |
| carriers | equip_own_school_16 | Equipment count as reported (own school 16) [reported; int] |
| carriers | equip_own_bus_16 | Equipment count as reported (own bus 16) [reported; int] |
| carriers | equip_own_van_1_8 | Equipment count as reported (own van 1 8) [reported; int] |
| carriers | equip_own_van_9_15 | Equipment count as reported (own van 9 15) [reported; int] |
| carriers | equip_own_limo_1_8 | Equipment count as reported (own limo 1 8) [reported; int] |
| carriers | equip_own_limo_9_15 | Equipment count as reported (own limo 9 15) [reported; int] |
| carriers | equip_own_limo_16 | Equipment count as reported (own limo 16) [reported; int] |
| carriers | equip_term_leased_truck | Equipment count as reported (term leased truck) [reported; int] |
| carriers | equip_term_leased_tractor | Equipment count as reported (term leased tractor) [reported; int] |
| carriers | equip_term_leased_trailer | Equipment count as reported (term leased trailer) [reported; int] |
| carriers | equip_term_leased_coach | Equipment count as reported (term leased coach) [reported; int] |
| carriers | equip_term_leased_school_1_8 | Equipment count as reported (term leased school 1 8) [reported; int] |
| carriers | equip_term_leased_school_9_15 | Equipment count as reported (term leased school 9 15) [reported; int] |
| carriers | equip_term_leased_school_16 | Equipment count as reported (term leased school 16) [reported; int] |
| carriers | equip_term_leased_bus_16 | Equipment count as reported (term leased bus 16) [reported; int] |
| carriers | equip_term_leased_van_1_8 | Equipment count as reported (term leased van 1 8) [reported; int] |
| carriers | equip_term_leased_van_9_15 | Equipment count as reported (term leased van 9 15) [reported; int] |
| carriers | equip_term_leased_limo_1_8 | Equipment count as reported (term leased limo 1 8) [reported; int] |
| carriers | equip_term_leased_limo_9_15 | Equipment count as reported (term leased limo 9 15) [reported; int] |
| carriers | equip_term_leased_limo_16 | Equipment count as reported (term leased limo 16) [reported; int] |
| carriers | equip_trip_leased_truck | Equipment count as reported (trip leased truck) [reported; int] |
| carriers | equip_trip_leased_tractor | Equipment count as reported (trip leased tractor) [reported; int] |
| carriers | equip_trip_leased_trailer | Equipment count as reported (trip leased trailer) [reported; int] |
| carriers | equip_trip_leased_coach | Equipment count as reported (trip leased coach) [reported; int] |
| carriers | equip_trip_leased_school_1_8 | Equipment count as reported (trip leased school 1 8) [reported; int] |
| carriers | equip_trip_leased_school_9_15 | Equipment count as reported (trip leased school 9 15) [reported; int] |
| carriers | equip_trip_leased_school_16 | Equipment count as reported (trip leased school 16) [reported; int] |
| carriers | equip_trip_leased_bus_16 | Equipment count as reported (trip leased bus 16) [reported; int] |
| carriers | equip_trip_leased_van_1_8 | Equipment count as reported (trip leased van 1 8) [reported; int] |
| carriers | equip_trip_leased_van_9_15 | Equipment count as reported (trip leased van 9 15) [reported; int] |
| carriers | equip_trip_leased_limo_1_8 | Equipment count as reported (trip leased limo 1 8) [reported; int] |
| carriers | equip_trip_leased_limo_9_15 | Equipment count as reported (trip leased limo 9 15) [reported; int] |
| carriers | equip_trip_leased_limo_16 | Equipment count as reported (trip leased limo 16) [reported; int] |
| carriers | cargo_types | Cargo classes flagged X by the carrier, joined with | [derived; text] |
| carriers | cargo_other_desc | Free-text other cargo [reported; text] |
| carriers | safety_rating | Official FMCSA rating code: S Satisfactory, C Conditional, U Unsatisfactory; blank = not rated [reported; text] |
| carriers | safety_rating_date | Date of the safety rating [normalized; date] |
| carriers | review_type | Type code of the latest compliance review as reported [reported; text] |
| carriers | review_date | Date of the latest compliance review [normalized; date] |
| carriers | recordable_crash_rate | Recordable crash rate as reported by the Census [reported; float] |
| carriers | prior_revoke_flag | true if the Census flags a prior revocation [normalized; bool] |
| carriers | prior_revoke_dot_number | USDOT number of the prior revoked entity, if any [reported; text] |
| carriers | census_docket_1 | Docket number 1 listed in the Census (prefix + number, no zero padding) [normalized; text] |
| carriers | census_docket_1_status | Census status code of docket 1: A, I or P [reported; text] |
| carriers | census_docket_2 | Docket number 2 listed in the Census (prefix + number, no zero padding) [normalized; text] |
| carriers | census_docket_2_status | Census status code of docket 2: A, I or P [reported; text] |
| carriers | census_docket_3 | Docket number 3 listed in the Census (prefix + number, no zero padding) [normalized; text] |
| carriers | census_docket_3_status | Census status code of docket 3: A, I or P [reported; text] |
| carriers | n_dockets | Distinct dockets for this USDOT across Census, Motus and legacy sources (0 if none) [derived; int] |
| carriers | authority_active_any | true if any docket row has authority_status Active (per-docket merge rule) [derived; bool] |
| carriers | authority_pending_any | true if any docket row has authority_status Pending [derived; bool] |
| carriers | authority_types_active | Authority types with Active status, joined with | [derived; text] |
| carriers | authority_source | motus, legacy_2026-05-14, mixed or none [derived; text] |
| carriers | authority_as_of | Oldest source date among tables that supplied authority rows (legacy = 2026-05-14) [derived; date] |
| carriers | insurance_filing_present | Reported insurance filing presence as of source date. Not verified current coverage [derived; bool] |
| carriers | insurance_filings_n | Number of reported active/pending filings (0 if none) [derived; int] |
| carriers | bipd_max_coverage_usd | Largest reported BI&PD maximum coverage, USD [derived; int] |
| carriers | cargo_filing_present | true if a cargo filing is reported [derived; bool] |
| carriers | surety_or_trust_filing_present | true if a surety bond or trust fund filing is reported [derived; bool] |
| carriers | insurance_latest_effective_date | Latest effective date among reported filings [derived; date] |
| carriers | insurance_source | motus, legacy_2026-05-14, mixed or none [derived; text] |
| carriers | insurance_as_of | Oldest source date among tables that supplied filings (legacy = 2026-05-14) [derived; date] |
| carriers | scheduled_cancellation | not detected in bulk; unknown. Scheduled cancellations are not visible in the bulk files [constant; text] |
| carriers | revocation_suspension_orders_n | Orders on file for this USDOT across both sources (0 if none) [derived; int] |
| carriers | latest_revocation_suspension_date | Latest effective date among those orders [derived; date] |
| carriers | insp_records_n | Inspection records for this USDOT in the file window (0 if none) [aggregated; int] |
| carriers | insp_first_date | Earliest inspection date in the file window [aggregated; date] |
| carriers | insp_last_date | Latest inspection date [aggregated; date] |
| carriers | insp_violations_sum | Sum of violations over the inspection records [aggregated; int] |
| carriers | insp_oos_sum | Sum of out-of-service violations [aggregated; int] |
| carriers | insp_driver_violations_sum | Sum of driver violations [aggregated; int] |
| carriers | insp_driver_oos_sum | Sum of driver out-of-service violations [aggregated; int] |
| carriers | insp_vehicle_violations_sum | Sum of vehicle violations [aggregated; int] |
| carriers | insp_vehicle_oos_sum | Sum of vehicle out-of-service violations [aggregated; int] |
| carriers | insp_hazmat_violations_sum | Sum of hazmat violations [aggregated; int] |
| carriers | insp_hazmat_oos_sum | Sum of hazmat out-of-service violations [aggregated; int] |
| carriers | crash_records_n | Crash records attributed to this USDOT via dot_number (one record per vehicle report; 0 if none) [aggregated; int] |
| carriers | crash_first_date | Earliest crash report date [aggregated; date] |
| carriers | crash_last_date | Latest crash report date [aggregated; date] |
| carriers | crash_fatalities_sum | Sum of the fatalities field over attributed records (not de-duplicated across vehicles of one crash) [aggregated; int] |
| carriers | crash_injuries_sum | Sum of the injuries field over attributed records (same caveat) [aggregated; int] |
| carriers | crash_tow_away_records_n | Attributed records with tow_away = Y [aggregated; int] |
| carriers | crash_federal_recordable_records_n | Attributed records with federal_recordable = Y [aggregated; int] |
| carriers | census_as_of | Date of the Census table pull [constant; date] |
| carriers | motus_as_of | Date of the Motus table pull [constant; date] |
| carriers | legacy_as_of | Always 2026-05-14: the legacy tables were last refreshed then and are no longer updated [constant; date] |
| carriers | edition_id | Release identifier [constant; text] |
| carriers | rule_version | Pipeline rule-set version [constant; text] |
| carriers | verify_live | true if at least one verify_live reason applies; the constant unknown-cancellation caveat applies to every row and is not a reason [derived; bool] |
| carriers | verify_live_reasons | Reason codes joined with ; (see SCHEMA.md). MOTUS_STATUS_DISAGREES_WITH_LATEST_HISTORY = the Motus Carrier-table status differs from the latest Motus authority-history row for at least one authority of this carrier; MOTUS_HISTORY_LATEST_DATE_TIE = the latest history date is a tie between conflicting statuses that include the published one. Both mean two official sources disagree: verify live, not proof the published status is wrong. IMPLAUSIBLE_RECORDED_INSURANCE_DATE = insurance_latest_effective_date is a recorded date before 1900 or later than the pull date + 5 years, published as filed. [derived; text] |
| authority_dockets | usdot_number | USDOT number [normalized; text] |
| authority_dockets | docket_number | Docket (MC/FF/MX...), prefix + number without zero padding; blank for Motus rows with no docket [normalized; text] |
| authority_dockets | authority_type | Operating authority type [reported; text] |
| authority_dockets | authority_status | Active, Pending, Inactive or Withdrawn [normalized; text] |
| authority_dockets | source_table | motus or legacy_2026-05-14 [constant; text] |
| authority_dockets | source_as_of | Motus pull date, or 2026-05-14 for legacy rows [constant; date] |
| authority_dockets | motus_docket_row_present | true if the docket has a Motus Carrier row [derived; bool] |
| authority_dockets | last_status_change_date | Latest authority change date recorded for the docket [aggregated; date] |
| authority_dockets | last_status_change_reason | Reason or action text of that change [aggregated; text] |
| authority_dockets | revocation_pending | true if a revocation was pending in the legacy record (as of 2026-05-14); false for Motus rows [normalized; bool] |
| authority_dockets | bipd_required_usd | Required BI&PD insurance, USD [normalized; int] |
| authority_dockets | bipd_on_file_usd | BI&PD insurance on file, USD [normalized; int] |
| authority_dockets | cargo_required | Cargo insurance required [normalized; bool] |
| authority_dockets | cargo_on_file | Cargo insurance on file [normalized; bool] |
| authority_dockets | bond_required | Surety bond/trust fund required [normalized; bool] |
| authority_dockets | bond_on_file | Surety bond/trust fund on file [normalized; bool] |
| authority_dockets | census_docket_status | Census status of this docket (A, I, P) when listed in the Census [reported; text] |
| authority_dockets | latest_revocation_suspension_type | Type of the latest order for the docket [aggregated; text] |
| authority_dockets | latest_revocation_suspension_effective_date | Effective date of the latest order for the docket [aggregated; date] |
| authority_dockets | latest_revocation_suspension_source | motus or legacy_2026-05-14 [aggregated; text] |
| insurance_filings | usdot_number | USDOT number [normalized; text] |
| insurance_filings | docket_number | Docket [normalized; text] |
| insurance_filings | filing_seq | Ordinal of the filing within (usdot_number, docket_number) in the output; with those two columns it is the primary key [derived; int] |
| insurance_filings | source_table | motus or legacy_2026-05-14 [constant; text] |
| insurance_filings | source_as_of | Motus pull date or 2026-05-14 [constant; date] |
| insurance_filings | form_code | BMC form code such as BMC-91X; legacy codes are prefixed BMC- [normalized; text] |
| insurance_filings | insurance_type | BIPD, CARGO, SURETY BOND or TRUST FUND [normalized; text] |
| insurance_filings | class_code | P primary, E excess, 1 or 2 full security limits; blank otherwise [reported; text] |
| insurance_filings | insurer_name | Insurer name as filed (the policy may be administered by a branch with a different name) [reported; text] |
| insurance_filings | max_coverage_usd | Maximum coverage, USD; blank when amount_note is set [normalized; int] |
| insurance_filings | underlying_limit_usd | Underlying limit for excess BI&PD, USD (0 when none) [normalized; int] |
| insurance_filings | effective_date | Policy effective date [normalized; date] |
| insurance_filings | fmcsa_received_date | Date FMCSA received the filing [normalized; date] |
| insurance_filings | cancellation_effective_date_reported | Cancellation effective date as filed by 2026-05-14 (legacy rows only; blank for Motus because that table has no such column). Not a detected cancellation [normalized; date] |
| insurance_filings | scheduled_cancellation | not detected in bulk; unknown [constant; text] |
| insurance_filings | amount_note | LEGACY_ZERO_NOT_REPORTED when the legacy table stores 0 (amount not stored); otherwise blank [derived; text] |
| insurance_history | history_row_id | Row identifier unique within this release (primary key); not stable across releases [derived; text] |
| insurance_history | usdot_number | USDOT number [normalized; text] |
| insurance_history | docket_number | Docket [normalized; text] |
| insurance_history | source_table | motus or legacy_2026-05-14 [constant; text] |
| insurance_history | source_as_of | Motus pull date or 2026-05-14 [constant; date] |
| insurance_history | form_code | BMC form code [normalized; text] |
| insurance_history | insurance_type | BIPD, CARGO, SURETY BOND, TRUST FUND or blank when the source gives no unambiguous type [normalized; text] |
| insurance_history | class_code | P, E, 1, 2 or blank [reported; text] |
| insurance_history | insurer_name | Insurer name as filed [reported; text] |
| insurance_history | min_coverage_usd | Minimum coverage required, USD [normalized; int] |
| insurance_history | max_coverage_usd | Maximum coverage, USD (Motus history only; the legacy history table has no such column) [normalized; int] |
| insurance_history | underlying_limit_usd | Underlying limit, USD (Motus history only) [normalized; int] |
| insurance_history | effective_date | Policy effective date [normalized; date] |
| insurance_history | cancellation_effective_date | Date the policy was effectively cancelled, replaced, transferred or renamed [normalized; date] |
| insurance_history | termination_reason | Reason code as in the source (CANCEL, TERM/REPL, NAMECHG, TRANSFER ...) [reported; text] |
| insurance_history | cancellation_form | Cancellation form code (legacy rows only) [reported; text] |
Full data dictionary (JSON) → · Complete dictionary with enumerated values and date semantics (Markdown) →
Pricing & License
Individual / Academic: US$149 one time
Commercial / Business: US$399 one time
Persistfolio Data License v1.0 (Individual / Academic or Business / Commercial)
Limitations: read before relying on any record →
Known Limitations
- Insurance filings are reported filing evidence as of the source date, not verified coverage; scheduled cancellations are not detectable in bulk and a missing cancellation date means unknown.
- Legacy authority and insurance tables were last refreshed by FMCSA on 2026-05-14; for dockets without a Motus record this edition can be five months out of date.
- Two official Motus tables disagree about the authority status of 5,401 of 160,566 checked authority rows; such carriers are flagged for live verification. A flag does not show which source is right.
- Census self-reported fields (fleet, drivers, mileage, phones, addresses) are as registered by the carrier and can be stale; check mcs150_date.
- Differences between this edition and FMCSA SAFER snapshots taken on other dates were observed in review and could not all be explained; verify on the FMCSA portal before relying on a record.
- E-mail-shaped text remains unmasked in authority_dockets.last_status_change_reason (3,956 values, 3,578 carriers), because it is source-provided status-reason text; three e-mail strings in other free-text fields are masked.
- No blind independent audit has passed; no legal opinion has been obtained.
FAQ
Is this verified or certified?
No. It is QA-complete: automated checks pass, two builds are identical and an independent fidelity check found no mismatch. No blind independent audit has passed and no legal opinion has been obtained. An external review of 39 records found no confirmed material error but was not blind and did not verify every field.
Does it show current insurance coverage?
No. Insurance records are filings reported to FMCSA as of the source date. Verify coverage on the FMCSA portal before onboarding, underwriting or tendering.
How current is it?
Census and Motus data are as of 2026-10-12. Legacy authority and insurance tables were frozen by FMCSA on 2026-05-14, so for dockets without a Motus record the data can be about five months old.
What is the difference between the two licenses?
Both receive the identical complete dataset. Individual / Academic (US$149) is for one named person’s own academic, research, journalistic or professional-analysis work. Business / Commercial (US$399) is for internal use within one legal entity, including carrier vetting and sales prospecting. Neither allows redistribution.
Can I contact the carriers?
The phone numbers and addresses are public registry fields, but you are responsible for lawful outreach (telemarketing, do-not-call, anti-spam and privacy laws). Carriers that are individuals have street, ZIP and phone withheld.
Do I get updates?
No. This is a fixed, dated edition. A later edition would be a separate product.
Persistfolio is independent and is not affiliated with or endorsed by the Federal Motor Carrier Safety Administration or the U.S. Department of Transportation. Derived from public FMCSA open data. Not legal, insurance or safety advice.