CSV documentation

Know every column.

State and nationwide packs share a contact-focused schema. CSV files are compressed as .csv.gz; extract them before importing.

Identifiers and company

dot_number is the carrier’s stable registration identifier. mc_number and active_dockets describe operating-authority dockets. legal_name, dba_name and company_officer fields describe the business as filed.

Contacts and quality

email, phone, cell_phone and fax are self-reported. email_flag identifies unique, shared-same-company or likely service/agent addresses. email_shared_count reports how many carrier records share an address. Empty means not supplied.

Physical and mailing addresses

phy_ columns describe the physical address used for state packs. mail_ columns hold mailing details where available. Preserve postal codes as text when importing.

Fleet and cargo

power_units, total_drivers, fleet_bucket, owner_operator and cargo_segments support territory and fleet targeting. authority_class and op_scope separate authority and operation scope. Cargo categories can overlap.

Feed additions

first_seen is the UTC date this pipeline first published the carrier in its discovery feed. feed_events explains registration, snapshot, reactivation or authority signals. Event and registration dates can precede publication.

Identity7

The company and its registration

  • dot_number
  • mc_number
  • active_dockets
  • legal_name
  • dba_name
  • company_officer_1
  • company_officer_2

Contact7

Self-reported contact details

  • email
  • email_flag
  • email_shared_count
  • email_is_freemail
  • phone
  • cell_phone
  • fax

Location11

Physical and mailing addresses

  • phy_street
  • phy_city
  • phy_state
  • phy_zip
  • phy_country
  • phy_county_code
  • mail_street
  • mail_city
  • mail_state
  • mail_zip
  • mail_country

Operations13

Authority, fleet and cargo

  • authority_class
  • op_scope
  • classdef
  • business_org
  • power_units
  • truck_units
  • total_drivers
  • total_cdl
  • fleet_bucket
  • owner_operator
  • cargo_segments
  • hazmat
  • passenger_carrier

Dates6

Registration and filing freshness

  • add_date
  • mcs150_date
  • mcs150_age_days
  • safety_rating
  • new_30d
  • new_90d

Contact support