# Data dictionary - fmcsa-national-carriers-2026-10

Every column of every table. `source_status` says whether a value is reported by the source, normalized, derived or aggregated by Persistfolio; the lineage says which source field it comes from.

## carriers

| field | type | status | lineage | definition |
|---|---|---|---|---|
| usdot_number | text | normalized | Census dot_number | USDOT number, unpadded integer text; primary key |
| status_code | text | reported | Census status_code | A Active, I Inactive, P Pending (Census record status) |
| add_date | date | normalized | Census add_date | Date the record was added to the Census |
| legal_name | text | reported | Census legal_name | Legal name as registered |
| dba_name | text | reported | Census dba_name | Doing-business-as name; blank when none |
| entity_class | text | reported | Census business_org_desc | CORPORATION, INDIVIDUAL, PARTNERSHIP or blank (source did not classify; never inferred) |
| phy_street | text | reported | Census phy_street | Physical street address as registered; blank when entity_class is INDIVIDUAL (rule N1) |
| phy_city | text | reported | Census phy_city | Physical city |
| phy_state | text | reported | Census phy_state | Physical state or province code |
| phy_zip | text | reported | Census phy_zip | Physical ZIP or postal code; blank when entity_class is INDIVIDUAL (rule N1) |
| phy_country | text | reported | Census phy_country | Physical country code |
| phy_county_code | text | reported | Census phy_cnty | Physical county code |
| phy_address_undeliverable | text | reported | Census undeliv_phy | U = mail to the physical address was returned undeliverable; N otherwise; blank unknown |
| phone | text | reported | Census phone; Motus bus_telno only if Census blank | Business telephone as in the source; blank when entity_class is INDIVIDUAL (rule N1) |
| phone_source | text | derived | rule R-PH1 | census, motus_fallback or blank (blank when phone is blank or withheld) |
| identity_withheld | text | derived | rule N1 | N1_INDIVIDUAL when street, ZIP and phone are withheld; otherwise blank |
| identity_rule_version | text | constant | rule N1 | N1-1 on every row |
| carrier_operation | text | reported | Census carrier_operation | A interstate, B intrastate hazmat, C intrastate non-hazmat; blank when not reported |
| operation_classification | text | reported | Census classdef | Operation classification list separated by semicolons |
| hazmat_flag | bool | normalized | Census hm_ind | true if the carrier reports hazardous-materials operations |
| power_units | int | reported | Census power_units | Self-reported power units (MCS-150) |
| truck_units | int | reported | Census truck_units | Self-reported truck units |
| bus_units | int | reported | Census bus_units | Self-reported bus units |
| fleet_size | int | reported | Census fleetsize | Census fleet size code/count as reported |
| total_drivers | int | reported | Census total_drivers | Self-reported drivers |
| total_cdl_drivers | int | reported | Census total_cdl | Self-reported CDL drivers |
| total_intrastate_drivers | int | reported | Census total_intrastate_drivers | Self-reported intrastate drivers |
| drivers_interstate_total | int | reported | Census driver_inter_total | Self-reported interstate drivers |
| drivers_interstate_beyond_100mi | int | reported | Census interstate_beyond_100_miles | Interstate drivers operating beyond 100 miles |
| drivers_interstate_within_100mi | int | reported | Census interstate_within_100_miles | Interstate drivers operating within 100 miles |
| drivers_intrastate_beyond_100mi | int | reported | Census intrastate_beyond_100_miles | Intrastate drivers operating beyond 100 miles |
| drivers_intrastate_within_100mi | int | reported | Census intrastate_within_100_miles | Intrastate drivers operating within 100 miles |
| avg_drivers_leased_per_month | int | reported | Census avg_drivers_leased_per_month | Average leased drivers per month |
| mcs150_date | date | normalized | Census mcs150_date | Date of the last MCS-150 update |
| mcs150_mileage | int | reported | Census mcs150_mileage | Self-reported annual mileage |
| mcs150_mileage_year | int | reported | Census mcs150_mileage_year | Year of the reported mileage |
| mcs150_age_days | int | derived | census_as_of - mcs150_date | Days between census_as_of and mcs150_date; arithmetic only |
| equip_own_truck | int | reported | Census owntruck | Equipment count as reported (own truck) |
| equip_own_tractor | int | reported | Census owntract | Equipment count as reported (own tractor) |
| equip_own_trailer | int | reported | Census owntrail | Equipment count as reported (own trailer) |
| equip_own_coach | int | reported | Census owncoach | Equipment count as reported (own coach) |
| equip_own_school_1_8 | int | reported | Census ownschool_1_8 | Equipment count as reported (own school 1 8) |
| equip_own_school_9_15 | int | reported | Census ownschool_9_15 | Equipment count as reported (own school 9 15) |
| equip_own_school_16 | int | reported | Census ownschool_16 | Equipment count as reported (own school 16) |
| equip_own_bus_16 | int | reported | Census ownbus_16 | Equipment count as reported (own bus 16) |
| equip_own_van_1_8 | int | reported | Census ownvan_1_8 | Equipment count as reported (own van 1 8) |
| equip_own_van_9_15 | int | reported | Census ownvan_9_15 | Equipment count as reported (own van 9 15) |
| equip_own_limo_1_8 | int | reported | Census ownlimo_1_8 | Equipment count as reported (own limo 1 8) |
| equip_own_limo_9_15 | int | reported | Census ownlimo_9_15 | Equipment count as reported (own limo 9 15) |
| equip_own_limo_16 | int | reported | Census ownlimo_16 | Equipment count as reported (own limo 16) |
| equip_term_leased_truck | int | reported | Census trmtruck | Equipment count as reported (term leased truck) |
| equip_term_leased_tractor | int | reported | Census trmtract | Equipment count as reported (term leased tractor) |
| equip_term_leased_trailer | int | reported | Census trmtrail | Equipment count as reported (term leased trailer) |
| equip_term_leased_coach | int | reported | Census trmcoach | Equipment count as reported (term leased coach) |
| equip_term_leased_school_1_8 | int | reported | Census trmschool_1_8 | Equipment count as reported (term leased school 1 8) |
| equip_term_leased_school_9_15 | int | reported | Census trmschool_9_15 | Equipment count as reported (term leased school 9 15) |
| equip_term_leased_school_16 | int | reported | Census trmschool_16 | Equipment count as reported (term leased school 16) |
| equip_term_leased_bus_16 | int | reported | Census trmbus_16 | Equipment count as reported (term leased bus 16) |
| equip_term_leased_van_1_8 | int | reported | Census trmvan_1_8 | Equipment count as reported (term leased van 1 8) |
| equip_term_leased_van_9_15 | int | reported | Census trmvan_9_15 | Equipment count as reported (term leased van 9 15) |
| equip_term_leased_limo_1_8 | int | reported | Census trmlimo_1_8 | Equipment count as reported (term leased limo 1 8) |
| equip_term_leased_limo_9_15 | int | reported | Census trmlimo_9_15 | Equipment count as reported (term leased limo 9 15) |
| equip_term_leased_limo_16 | int | reported | Census trmlimo_16 | Equipment count as reported (term leased limo 16) |
| equip_trip_leased_truck | int | reported | Census trptruck | Equipment count as reported (trip leased truck) |
| equip_trip_leased_tractor | int | reported | Census trptract | Equipment count as reported (trip leased tractor) |
| equip_trip_leased_trailer | int | reported | Census trptrail | Equipment count as reported (trip leased trailer) |
| equip_trip_leased_coach | int | reported | Census trpcoach | Equipment count as reported (trip leased coach) |
| equip_trip_leased_school_1_8 | int | reported | Census trpschool_1_8 | Equipment count as reported (trip leased school 1 8) |
| equip_trip_leased_school_9_15 | int | reported | Census trpschool_9_15 | Equipment count as reported (trip leased school 9 15) |
| equip_trip_leased_school_16 | int | reported | Census trpschool_16 | Equipment count as reported (trip leased school 16) |
| equip_trip_leased_bus_16 | int | reported | Census trpbus_16 | Equipment count as reported (trip leased bus 16) |
| equip_trip_leased_van_1_8 | int | reported | Census trpvan_1_8 | Equipment count as reported (trip leased van 1 8) |
| equip_trip_leased_van_9_15 | int | reported | Census trpvan_9_15 | Equipment count as reported (trip leased van 9 15) |
| equip_trip_leased_limo_1_8 | int | reported | Census trplimo_1_8 | Equipment count as reported (trip leased limo 1 8) |
| equip_trip_leased_limo_9_15 | int | reported | Census trplimo_9_15 | Equipment count as reported (trip leased limo 9 15) |
| equip_trip_leased_limo_16 | int | reported | Census trplimo_16 | Equipment count as reported (trip leased limo 16) |
| cargo_types | text | derived | Census crgo_* flags | Cargo classes flagged X by the carrier, joined with / |
| cargo_other_desc | text | reported | Census crgo_cargoothr_desc | Free-text other cargo |
| safety_rating | text | reported | Census safety_rating | Official FMCSA rating code: S Satisfactory, C Conditional, U Unsatisfactory; blank = not rated |
| safety_rating_date | date | normalized | Census safety_rating_date | Date of the safety rating |
| review_type | text | reported | Census review_type | Type code of the latest compliance review as reported |
| review_date | date | normalized | Census review_date | Date of the latest compliance review |
| recordable_crash_rate | float | reported | Census recordable_crash_rate | Recordable crash rate as reported by the Census |
| prior_revoke_flag | bool | normalized | Census prior_revoke_flag | true if the Census flags a prior revocation |
| prior_revoke_dot_number | text | reported | Census prior_revoke_dot_number | USDOT number of the prior revoked entity, if any |
| census_docket_1 | text | normalized | Census docket1prefix+docket1 | Docket number 1 listed in the Census (prefix + number, no zero padding) |
| census_docket_1_status | text | reported | Census docket1_status_code | Census status code of docket 1: A, I or P |
| census_docket_2 | text | normalized | Census docket2prefix+docket2 | Docket number 2 listed in the Census (prefix + number, no zero padding) |
| census_docket_2_status | text | reported | Census docket2_status_code | Census status code of docket 2: A, I or P |
| census_docket_3 | text | normalized | Census docket3prefix+docket3 | Docket number 3 listed in the Census (prefix + number, no zero padding) |
| census_docket_3_status | text | reported | Census docket3_status_code | Census status code of docket 3: A, I or P |
| n_dockets | int | derived | authority_dockets | Distinct dockets for this USDOT across Census, Motus and legacy sources (0 if none) |
| authority_active_any | bool | derived | authority_dockets | true if any docket row has authority_status Active (per-docket merge rule) |
| authority_pending_any | bool | derived | authority_dockets | true if any docket row has authority_status Pending |
| authority_types_active | text | derived | authority_dockets | Authority types with Active status, joined with / |
| authority_source | text | derived | authority_dockets.source_table | motus, legacy_2026-05-14, mixed or none |
| authority_as_of | date | derived | source dates | Oldest source date among tables that supplied authority rows (legacy = 2026-05-14) |
| insurance_filing_present | bool | derived | insurance_filings | Reported insurance filing presence as of source date. Not verified current coverage |
| insurance_filings_n | int | derived | insurance_filings | Number of reported active/pending filings (0 if none) |
| bipd_max_coverage_usd | int | derived | insurance_filings | Largest reported BI&PD maximum coverage, USD |
| cargo_filing_present | bool | derived | insurance_filings | true if a cargo filing is reported |
| surety_or_trust_filing_present | bool | derived | insurance_filings | true if a surety bond or trust fund filing is reported |
| insurance_latest_effective_date | date | derived | insurance_filings | Latest effective date among reported filings |
| insurance_source | text | derived | insurance_filings.source_table | motus, legacy_2026-05-14, mixed or none |
| insurance_as_of | date | derived | source dates | Oldest source date among tables that supplied filings (legacy = 2026-05-14) |
| scheduled_cancellation | text | constant | rule | not detected in bulk; unknown. Scheduled cancellations are not visible in the bulk files |
| revocation_suspension_orders_n | int | derived | Motus RevokeSuspend + legacy Revocation | Orders on file for this USDOT across both sources (0 if none) |
| latest_revocation_suspension_date | date | derived | Motus RevokeSuspend + legacy Revocation | Latest effective date among those orders |
| insp_records_n | int | aggregated | Vehicle Inspection File | Inspection records for this USDOT in the file window (0 if none) |
| insp_first_date | date | aggregated | Vehicle Inspection File | Earliest inspection date in the file window |
| insp_last_date | date | aggregated | Vehicle Inspection File | Latest inspection date |
| insp_violations_sum | int | aggregated | Vehicle Inspection File viol_total | Sum of violations over the inspection records |
| insp_oos_sum | int | aggregated | Vehicle Inspection File oos_total | Sum of out-of-service violations |
| insp_driver_violations_sum | int | aggregated | driver_viol_total | Sum of driver violations |
| insp_driver_oos_sum | int | aggregated | driver_oos_total | Sum of driver out-of-service violations |
| insp_vehicle_violations_sum | int | aggregated | vehicle_viol_total | Sum of vehicle violations |
| insp_vehicle_oos_sum | int | aggregated | vehicle_oos_total | Sum of vehicle out-of-service violations |
| insp_hazmat_violations_sum | int | aggregated | hazmat_viol_total | Sum of hazmat violations |
| insp_hazmat_oos_sum | int | aggregated | hazmat_oos_total | Sum of hazmat out-of-service violations |
| crash_records_n | int | aggregated | Crash File | Crash records attributed to this USDOT via dot_number (one record per vehicle report; 0 if none) |
| crash_first_date | date | aggregated | Crash File report_date | Earliest crash report date |
| crash_last_date | date | aggregated | Crash File report_date | Latest crash report date |
| crash_fatalities_sum | int | aggregated | Crash File fatalities | Sum of the fatalities field over attributed records (not de-duplicated across vehicles of one crash) |
| crash_injuries_sum | int | aggregated | Crash File injuries | Sum of the injuries field over attributed records (same caveat) |
| crash_tow_away_records_n | int | aggregated | Crash File tow_away | Attributed records with tow_away = Y |
| crash_federal_recordable_records_n | int | aggregated | Crash File federal_recordable | Attributed records with federal_recordable = Y |
| census_as_of | date | constant | Socrata rowsUpdatedAt (Census, daily) | Date of the Census table pull |
| motus_as_of | date | constant | Socrata rowsUpdatedAt (Motus Carrier, daily) | Date of the Motus table pull |
| legacy_as_of | date | constant | FMCSA catalog text on legacy tables | Always 2026-05-14: the legacy tables were last refreshed then and are no longer updated |
| edition_id | text | constant | release | Release identifier |
| rule_version | text | constant | release | Pipeline rule-set version |
| verify_live | bool | derived | verify_live_reasons | true if at least one verify_live reason applies; the constant unknown-cancellation caveat applies to every row and is not a reason |
| verify_live_reasons | text | derived | rule | 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. |

## authority_dockets

| field | type | status | lineage | definition |
|---|---|---|---|---|
| usdot_number | text | normalized | Motus usdot_number / legacy dot_number | USDOT number |
| docket_number | text | normalized | docket_number | Docket (MC/FF/MX...), prefix + number without zero padding; blank for Motus rows with no docket |
| authority_type | text | reported | Motus op_auth_type; legacy common/contract/broker | Operating authority type |
| authority_status | text | normalized | Motus op_auth_status; legacy *_stat and *_app_pend | Active, Pending, Inactive or Withdrawn |
| source_table | text | constant | merge rule | motus or legacy_2026-05-14 |
| source_as_of | date | constant | source date | Motus pull date, or 2026-05-14 for legacy rows |
| motus_docket_row_present | bool | derived | merge rule | true if the docket has a Motus Carrier row |
| last_status_change_date | date | aggregated | Motus AuthHist status_change_date; legacy AuthHist served dates | Latest authority change date recorded for the docket |
| last_status_change_reason | text | aggregated | Motus AuthHist reason; legacy AuthHist action | Reason or action text of that change |
| revocation_pending | bool | normalized | legacy *_rev_pend | true if a revocation was pending in the legacy record (as of 2026-05-14); false for Motus rows |
| bipd_required_usd | int | normalized | Motus/legacy min_cov_amount | Required BI&PD insurance, USD |
| bipd_on_file_usd | int | normalized | Motus/legacy bipd_file | BI&PD insurance on file, USD |
| cargo_required | bool | normalized | cargo_req | Cargo insurance required |
| cargo_on_file | bool | normalized | cargo_file | Cargo insurance on file |
| bond_required | bool | normalized | bond_req | Surety bond/trust fund required |
| bond_on_file | bool | normalized | bond_file | Surety bond/trust fund on file |
| census_docket_status | text | reported | Census docketN_status_code | Census status of this docket (A, I, P) when listed in the Census |
| latest_revocation_suspension_type | text | aggregated | Motus RevokeSuspend / legacy Revocation | Type of the latest order for the docket |
| latest_revocation_suspension_effective_date | date | aggregated | same | Effective date of the latest order for the docket |
| latest_revocation_suspension_source | text | aggregated | same | motus or legacy_2026-05-14 |

## insurance_filings

| field | type | status | lineage | definition |
|---|---|---|---|---|
| usdot_number | text | normalized | usdot_number / dot_number | USDOT number |
| docket_number | text | normalized | docket_number | Docket |
| filing_seq | int | derived | order within docket | Ordinal of the filing within (usdot_number, docket_number) in the output; with those two columns it is the primary key |
| source_table | text | constant | merge rule | motus or legacy_2026-05-14 |
| source_as_of | date | constant | source date | Motus pull date or 2026-05-14 |
| form_code | text | normalized | ins_form_code | BMC form code such as BMC-91X; legacy codes are prefixed BMC- |
| insurance_type | text | normalized | ins_type_code / mod_col_1 | BIPD, CARGO, SURETY BOND or TRUST FUND |
| class_code | text | reported | ins_class_code / mod_col_1 | P primary, E excess, 1 or 2 full security limits; blank otherwise |
| insurer_name | text | reported | insurance_company_name / name_company | Insurer name as filed (the policy may be administered by a branch with a different name) |
| max_coverage_usd | int | normalized | max_cov_amount | Maximum coverage, USD; blank when amount_note is set |
| underlying_limit_usd | int | normalized | underl_lim_amount | Underlying limit for excess BI&PD, USD (0 when none) |
| effective_date | date | normalized | effective_date | Policy effective date |
| fmcsa_received_date | date | normalized | trans_date | Date FMCSA received the filing |
| cancellation_effective_date_reported | date | normalized | legacy cancl_effective_date | 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 |
| scheduled_cancellation | text | constant | rule | not detected in bulk; unknown |
| amount_note | text | derived | rule | LEGACY_ZERO_NOT_REPORTED when the legacy table stores 0 (amount not stored); otherwise blank |

## insurance_history

| field | type | status | lineage | definition |
|---|---|---|---|---|
| history_row_id | text | derived | output order | Row identifier unique within this release (primary key); not stable across releases |
| usdot_number | text | normalized | usdot_number / dot_number | USDOT number |
| docket_number | text | normalized | docket_number | Docket |
| source_table | text | constant | source | motus or legacy_2026-05-14 |
| source_as_of | date | constant | source date | Motus pull date or 2026-05-14 |
| form_code | text | normalized | ins_form_code | BMC form code |
| insurance_type | text | normalized | ins_type_code / form code | BIPD, CARGO, SURETY BOND, TRUST FUND or blank when the source gives no unambiguous type |
| class_code | text | reported | ins_class_code | P, E, 1, 2 or blank |
| insurer_name | text | reported | insurance_company_name / name_company | Insurer name as filed |
| min_coverage_usd | int | normalized | min_cov_amount | Minimum coverage required, USD |
| max_coverage_usd | int | normalized | max_cov_amount | Maximum coverage, USD (Motus history only; the legacy history table has no such column) |
| underlying_limit_usd | int | normalized | underl_lim_amount | Underlying limit, USD (Motus history only) |
| effective_date | date | normalized | effective_date | Policy effective date |
| cancellation_effective_date | date | normalized | cancl_effective_date | Date the policy was effectively cancelled, replaced, transferred or renamed |
| termination_reason | text | reported | Motus filing_status_reason / legacy cancl_method | Reason code as in the source (CANCEL, TERM/REPL, NAMECHG, TRANSFER ...) |
| cancellation_form | text | reported | legacy ins_cancl_form | Cancellation form code (legacy rows only) |