NewBizBot
|Docs
Data APIDatasets

FMCSA Census

Full schema reference, querying examples, aggregate functions, and data quality notes for the FMCSA Motor Carrier Census dataset.

The fmcsa_census table contains ~1.96 million active motor carrier records from the FMCSA Company Census.

Source

PropertyValue
SourceFMCSA Company Census
Total records~1,960,000
Last FMCSA updateFebruary 2026
Refresh strategyPeriodic (quarterly re-ingestion)

Sample Record

A complete JSON object returned by the API (with select=*):

{
  "id": 123456,
  "dot_number": 53467,
  "dun_bradstreet_no": "001234567",
  "legal_name": "WERNER ENTERPRISES INC",
  "dba_name": null,
  "status_code": "A",
  "add_date": "1987-08-24",
  "mcs150_date": "2024-01-15T00:00:00+00:00",
  "phone": "4028952400",
  "cell_phone": null,
  "email_address": null,
  "company_officer_1": "DEREK J LEATHERS",
  "company_officer_2": null,
  "phy_street": "14507 FRONTIER RD",
  "phy_city": "OMAHA",
  "phy_state": "NE",
  "phy_zip": "68138",
  "phy_country": "US",
  "mailing_street": "PO BOX 45308",
  "mailing_city": "OMAHA",
  "mailing_state": "NE",
  "mailing_zip": "68145",
  "mailing_country": "US",
  "business_org_desc": "Corporation",
  "carrier_operation": "A",
  "classdef": null,
  "carship": null,
  "truck_units": 8200,
  "power_units": 8200,
  "bus_units": 0,
  "fleetsize": "6",
  "total_drivers": 12500,
  "total_cdl": 12500,
  "total_intrastate_drivers": 0,
  "driver_inter_total": 12500,
  "mcs150_mileage": 1200000000,
  "mcs150_mileage_year": 2023,
  "hm_ind": "Y",
  "interstate_beyond_100": 1,
  "interstate_within_100": 0,
  "intrastate_beyond_100": 0,
  "intrastate_within_100": 0,
  "safety_rating": "S",
  "safety_rating_date": "2019-06-15",
  "review_type": "C",
  "review_date": "2019-06-15",
  "docket_prefix": "MC",
  "docket_number": 177075,
  "cargo_types": ["General Freight", "Intermodal Cont.", "Refrigerated Food"],
  "cargo_other_desc": null,
  "data_snapshot_date": "2026-02-01"
}

Schema

Carrier Identification

ColumnTypeDescription
idbigintInternal primary key
dot_numberintegerUSDOT number (unique)
dun_bradstreet_notextDun & Bradstreet number
legal_nametextLegal business name
dba_nametextDoing-business-as name

Status & Dates

ColumnTypeDescription
status_codetextA = Active, I = Inactive
add_datedateDate added to census
mcs150_datetimestamptzLast MCS-150 filing date

Contact Information

ColumnTypeDescription
phonetextPrimary phone number
cell_phonetextCell phone number
email_addresstextEmail address
company_officer_1textPrimary company officer
company_officer_2textSecondary company officer

Physical Address

ColumnTypeDescription
phy_streettextStreet address
phy_citytextCity
phy_statetext2-letter state code
phy_ziptextZIP code (text for leading zeros)
phy_countrytextCountry code

Mailing Address

ColumnTypeDescription
mailing_streettextMailing street
mailing_citytextMailing city
mailing_statetextMailing state
mailing_ziptextMailing ZIP
mailing_countrytextMailing country

Business Classification

ColumnTypeDescription
business_org_desctextBusiness type (e.g., Corporation, LLC)
carrier_operationtextOperation type: A = Auth For Hire, B = Exempt For Hire, C = Private
classdeftextCarrier classification
carshiptextCarrier/shipper indicator

Fleet & Driver Counts

ColumnTypeDescription
truck_unitsintegerNumber of truck units
power_unitsintegerNumber of power units
bus_unitsintegerNumber of bus units
fleetsizetextFleet size category code
total_driversintegerTotal number of drivers
total_cdlintegerCDL holders
total_intrastate_driversintegerIntrastate-only drivers
driver_inter_totalintegerInterstate drivers

Operations & Mileage

ColumnTypeDescription
mcs150_mileagebigintAnnual mileage from MCS-150
mcs150_mileage_yearintegerYear of mileage report
hm_indtextHazmat indicator (Y/N)
interstate_beyond_100integerInterstate operations > 100 miles
interstate_within_100integerInterstate operations ≤ 100 miles
intrastate_beyond_100integerIntrastate operations > 100 miles
intrastate_within_100integerIntrastate operations ≤ 100 miles

Safety

ColumnTypeDescription
safety_ratingtextS = Satisfactory, C = Conditional, U = Unsatisfactory
safety_rating_datedateDate of safety rating
review_typetextType of review
review_datedateDate of last review

Authority / Docket

ColumnTypeDescription
docket_prefixtextDocket prefix (MC, FF, etc.)
docket_numberintegerDocket number

Cargo

ColumnTypeDescription
cargo_typestext[]Array of cargo type labels carried
cargo_other_desctextDescription for "Other" cargo type
ColumnTypeDescription
legal_name_searchtsvectorFull-text search vector (auto-generated from legal_name + dba_name)

Fast-Lookup Columns

These columns are optimized for fast filtering and sorting:

  • dot_number (unique)
  • phy_state
  • phy_state + phy_city (composite)
  • phy_zip
  • carrier_operation
  • phy_state + carrier_operation (composite)
  • power_units
  • total_drivers
  • status_code
  • safety_rating
  • legal_name_search (full-text search, GIN index)
  • cargo_types (array containment, GIN index)

At least one of these columns must appear as a filter in table queries. phy_city requires phy_state as a co-filter (composite index). Guardrail violations return a 400 response.

Carrier Operation Codes

CodeNameDescription
AAuthorized For HireCarriers authorized to transport property or passengers for compensation
BExempt For HireCarriers exempt from certain FMCSA regulations
CPrivate (Property)Private carriers transporting their own goods

Querying Examples

For general query syntax (operators, pagination, sorting), see the Query Syntax Reference.

Find carriers by state

# All carriers in Texas
curl "https://newbizbot.ai/api/data/fmcsa_census?phy_state=eq.TX&limit=10" \
  -H "Authorization: Bearer YOUR_API_KEY"

Search by carrier name

# Full-text search for "Werner"
curl "https://newbizbot.ai/api/data/fmcsa_census?legal_name_search=fts.werner&limit=5" \
  -H "Authorization: Bearer YOUR_API_KEY"
[
  {
    "dot_number": 53467,
    "legal_name": "WERNER ENTERPRISES INC",
    "phy_city": "OMAHA",
    "phy_state": "NE",
    "power_units": 8200,
    "total_drivers": 12500,
    "carrier_operation": "A",
    "safety_rating": "S"
  }
]

Filter by carrier operation type

# Authorized for-hire carriers in California
curl "https://newbizbot.ai/api/data/fmcsa_census?phy_state=eq.CA&carrier_operation=eq.A&limit=10&order=power_units.desc" \
  -H "Authorization: Bearer YOUR_API_KEY"

# Private carriers in Texas
curl "https://newbizbot.ai/api/data/fmcsa_census?phy_state=eq.TX&carrier_operation=eq.C&limit=10&order=power_units.desc" \
  -H "Authorization: Bearer YOUR_API_KEY"

Filter by fleet size / power units

# Large carriers (100+ power units) in Florida
curl "https://newbizbot.ai/api/data/fmcsa_census?phy_state=eq.FL&power_units=gte.100&order=power_units.desc&limit=20&select=legal_name,phy_city,power_units,total_drivers,carrier_operation" \
  -H "Authorization: Bearer YOUR_API_KEY"

# Small carriers (1-5 power units) in New York
curl "https://newbizbot.ai/api/data/fmcsa_census?phy_state=eq.NY&power_units=gte.1&power_units=lte.5&order=total_drivers.desc&limit=20" \
  -H "Authorization: Bearer YOUR_API_KEY"

Filter by cargo type

The cargo_types column is a PostgreSQL array. Use the cs (contains) operator:

# Carriers hauling refrigerated food in Georgia
curl "https://newbizbot.ai/api/data/fmcsa_census?phy_state=eq.GA&cargo_types=cs.{\"Refrigerated Food\"}&limit=10&order=power_units.desc" \
  -H "Authorization: Bearer YOUR_API_KEY"

# Hazmat carriers in Illinois
curl "https://newbizbot.ai/api/data/fmcsa_census?phy_state=eq.IL&hm_ind=eq.Y&order=power_units.desc&limit=20&select=legal_name,phy_city,power_units,total_drivers,cargo_types" \
  -H "Authorization: Bearer YOUR_API_KEY"

Note: URL-encode the array value: {"Refrigerated Food"} becomes %7B%22Refrigerated%20Food%22%7D. Common cargo types include General Freight, Household Goods, Metal: sheets, coils, rolls, Motor Vehicles, Refrigerated Food, Beverages, Chemicals, Intermodal Cont., and others.

Filter by safety rating

# Carriers with unsatisfactory safety rating
curl "https://newbizbot.ai/api/data/fmcsa_census?safety_rating=eq.U&limit=20&order=power_units.desc&select=legal_name,phy_city,phy_state,power_units,safety_rating,safety_rating_date" \
  -H "Authorization: Bearer YOUR_API_KEY"

# Satisfactory-rated carriers in a specific city
curl "https://newbizbot.ai/api/data/fmcsa_census?phy_state=eq.TN&phy_city=eq.MEMPHIS&safety_rating=eq.S&order=power_units.desc&limit=20" \
  -H "Authorization: Bearer YOUR_API_KEY"

Combine multiple filters

# Large authorized for-hire carriers hauling general freight in the Southeast
curl "https://newbizbot.ai/api/data/fmcsa_census?phy_state=in.(GA,FL,NC,SC,AL,TN)&carrier_operation=eq.A&power_units=gte.50&cargo_types=cs.{\"General Freight\"}&order=power_units.desc&limit=20&select=legal_name,phy_city,phy_state,power_units,total_drivers,cargo_types" \
  -H "Authorization: Bearer YOUR_API_KEY"

Count carriers

# Count all carriers in Ohio
curl -I "https://newbizbot.ai/api/data/fmcsa_census?phy_state=eq.OH&limit=0" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Prefer: count=exact"
# Read the Content-Range response header for the count

Aggregate Functions (RPCs)

The API provides pre-built RPC endpoints for aggregate queries on the FMCSA census data.

fmcsa_stats_by_state

Returns aggregate statistics grouped by state.

Endpoint: GET /data/rpc/fmcsa_stats_by_state

Parameters

ParameterTypeRequiredDescription
p_statetextNoFilter to a specific state (2-letter code). Omit for all states.

Examples

# Single state
curl "https://newbizbot.ai/api/data/rpc/fmcsa_stats_by_state?p_state=TX" \
  -H "Authorization: Bearer YOUR_API_KEY"
[
  {
    "state": "TX",
    "total_carriers": 142567,
    "total_power_units": 987654,
    "total_drivers": 1123456,
    "avg_power_units": 6.93,
    "avg_drivers": 7.88
  }
]
# All states
curl "https://newbizbot.ai/api/data/rpc/fmcsa_stats_by_state" \
  -H "Authorization: Bearer YOUR_API_KEY"

fmcsa_stats_by_carrier_operation

Returns aggregate statistics grouped by carrier operation type, optionally filtered by state.

Endpoint: GET /data/rpc/fmcsa_stats_by_carrier_operation

Parameters

ParameterTypeRequiredDescription
p_statetextNoFilter to a specific state (2-letter code). Omit for nationwide.

Examples

# Carrier operation breakdown in California
curl "https://newbizbot.ai/api/data/rpc/fmcsa_stats_by_carrier_operation?p_state=CA" \
  -H "Authorization: Bearer YOUR_API_KEY"
[
  {
    "carrier_operation": "A",
    "operation_name": "Authorized For Hire",
    "total_carriers": 45678,
    "total_power_units": 234567,
    "total_drivers": 289012,
    "avg_power_units": 5.13,
    "avg_drivers": 6.33
  },
  {
    "carrier_operation": "B",
    "operation_name": "Exempt For Hire",
    "total_carriers": 12345,
    "total_power_units": 56789,
    "total_drivers": 67890,
    "avg_power_units": 4.60,
    "avg_drivers": 5.50
  },
  {
    "carrier_operation": "C",
    "operation_name": "Private (Property)",
    "total_carriers": 34567,
    "total_power_units": 123456,
    "total_drivers": 145678,
    "avg_power_units": 3.57,
    "avg_drivers": 4.21
  }
]
# Nationwide breakdown
curl "https://newbizbot.ai/api/data/rpc/fmcsa_stats_by_carrier_operation" \
  -H "Authorization: Bearer YOUR_API_KEY"

Data Quality Notes

This is FMCSA census data loaded as-is. Known characteristics:

IssueScopeDetails
Self-reported dataAll recordsFleet size and driver counts are from MCS-150 filings, not independently verified
Stale MCS-150 filings~30% of recordsSome carriers haven't updated their MCS-150 in 2+ years
Missing safety ratingsMajorityOnly carriers that have been reviewed receive a safety rating
Inactive carriersFiltered outOnly status_code = 'A' records are included in aggregates and search
City name casingAll recordsCity names are stored in ALL CAPS (e.g., HOUSTON)
NULL fleet countsRareSome carriers report 0 or NULL for power_units/total_drivers

PPP Loans

Full schema reference, querying examples, aggregate functions, and data quality notes for the PPP loan dataset.

On this page

SourceSample RecordSchemaCarrier IdentificationStatus & DatesContact InformationPhysical AddressMailing AddressBusiness ClassificationFleet & Driver CountsOperations & MileageSafetyAuthority / DocketCargoSearchFast-Lookup ColumnsCarrier Operation CodesQuerying ExamplesFind carriers by stateSearch by carrier nameFilter by carrier operation typeFilter by fleet size / power unitsFilter by cargo typeFilter by safety ratingCombine multiple filtersCount carriersAggregate Functions (RPCs)fmcsa_stats_by_stateParametersExamplesfmcsa_stats_by_carrier_operationParametersExamplesData Quality Notes
FMCSA Census | NewBizBot Documentation | NewBizBot Documentation