{"id":"us-motor-carriers","meta":{"id":"us-motor-carriers","name":"US and cross-border trucking companies (FMCSA motor carrier census)","category":"records","country":"US","region":"United States, Canada and Mexico","licence":"US federal public record (FMCSA open data)","attribution":"Source: Federal Motor Carrier Safety Administration, Motor Carrier Census, via the US DOT open-data portal (data.transportation.gov). Public record; not endorsed by or affiliated with the FMCSA or US DOT. Registration details change; check the FMCSA record before relying on them.","row_count":2242833,"refreshed_at":"2026-10-24T21:21:25.091Z"},"columns":[{"key":"dotNumber","label":"USDOT number","class":"organisational"},{"key":"legalName","label":"Legal name","class":"organisational"},{"key":"dbaName","label":"DBA name","class":"organisational"},{"key":"status","label":"Status","class":"organisational"},{"key":"operation","label":"Operation","class":"organisational"},{"key":"businessType","label":"Business type","class":"organisational"},{"key":"classification","label":"Classification","class":"organisational"},{"key":"hazmat","label":"Hazmat","class":"organisational"},{"key":"cargo","label":"Cargo carried","class":"organisational"},{"key":"address","label":"Physical address","class":"organisational"},{"key":"city","label":"City","class":"organisational"},{"key":"state","label":"State","class":"organisational"},{"key":"zip","label":"ZIP","class":"organisational"},{"key":"county","label":"County","class":"organisational"},{"key":"country","label":"Country","class":"organisational"},{"key":"cityState","label":"City, State","class":"organisational"},{"key":"powerUnits","label":"Power units","class":"organisational"},{"key":"truckUnits","label":"Truck units","class":"organisational"},{"key":"busUnits","label":"Bus units","class":"organisational"},{"key":"fleetBand","label":"Fleet size band","class":"organisational"},{"key":"totalDrivers","label":"Drivers","class":"organisational"},{"key":"cdlDrivers","label":"CDL drivers","class":"organisational"},{"key":"mileage","label":"Annual mileage (MCS-150)","class":"organisational"},{"key":"mileageYear","label":"Mileage year","class":"organisational"},{"key":"mcs150Date","label":"MCS-150 last updated","class":"organisational"},{"key":"registeredDate","label":"Registered with FMCSA","class":"organisational"},{"key":"mcNumber","label":"MC / docket number","class":"organisational"},{"key":"safetyRating","label":"Safety rating","class":"organisational"},{"key":"safetyRatingDate","label":"Safety rating date","class":"organisational"},{"key":"ownedTrucks","label":"Owned trucks","class":"organisational"},{"key":"ownedTractors","label":"Owned tractors","class":"organisational"},{"key":"ownedTrailers","label":"Owned trailers","class":"organisational"}],"filters":[{"key":"state","label":"State / province code","type":"enum","options":["AL","AK","AZ","AR","CA","CO","CT","DE","DC","FL","GA","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","OH","OK","OR","PA","RI","SC","SD","TN","TX","UT","VT","VA","WA","WV","WI","WY","PR","AB","BC","MB","NB","NL","NS","NT","ON","PE","QC","SK","YT","AG","BN","BS","CH","CI","CL","CP","CS","DF","DG","GE","GJ","HD","JA","MC","MR","MX","NA","OA","PU","QE","QI","SI","SL","SO","TA","TB","TL","VC","YU","ZA"],"op":"eq","example":"TX","description":"Physical address code as published by FMCSA. Some codes are shared between countries."},{"key":"city","label":"City","type":"text","op":"eq","example":"Houston","description":"Physical location city, exact (case-insensitive)"},{"key":"zipPrefix","label":"ZIP starts with","type":"text","op":"prefix","column":"zip","example":"770"},{"key":"operation","label":"Operation","type":"enum","options":["Interstate","Intrastate hazmat","Intrastate non-hazmat"],"op":"eq","example":"Interstate"},{"key":"fleetBand","label":"Fleet size band","type":"enum","options":["1 unit","2-5 units","6-20 units","21-100 units","100+ units"],"op":"eq","example":"21-100 units"},{"key":"minPowerUnits","label":"Minimum power units","type":"number","op":"gte","column":"powerUnits","example":"10"},{"key":"maxPowerUnits","label":"Maximum power units","type":"number","op":"lte","column":"powerUnits","example":"50"},{"key":"minDrivers","label":"Minimum drivers","type":"number","op":"gte","column":"totalDrivers","example":"5"},{"key":"classification","label":"Classification contains","type":"text","op":"contains","example":"Authorized For Hire","description":"Authorized For Hire, Exempt For Hire, Private (Property), Private (Passenger, Business), U.S. Mail, Federal/State/Local Government, Indian Tribe"},{"key":"businessType","label":"Business type","type":"enum","options":["Corporation","LLC","Sole Proprietor","Partnership","Other"],"op":"eq","example":"Corporation","description":"Populated for about 7% of carriers in the census (mostly older registrations)"},{"key":"cargo","label":"Cargo contains","type":"text","op":"contains","example":"Refrigerated Food","description":"e.g. General Freight, Household Goods, Building Materials, Fresh Produce, Liquids/Gases, Intermodal Containers, Passengers, Oilfield Equipment, Livestock, Grain, Coal, Meat, Garbage, Chemicals, Dry Bulk, Refrigerated Food, Beverages, Paper Products, Utilities, Farm Supplies, Construction, Water Well, Motor Vehicles, Drive/Tow away, Logs/Poles, Mobile Homes, Machinery, Metal sheets"},{"key":"hazmat","label":"Hazmat carriers only","type":"boolean","op":"bool","example":"true"},{"key":"safetyRating","label":"Safety rating","type":"enum","options":["Satisfactory","Conditional","Unsatisfactory"],"valueAliases":{"Satisfactory":["S"],"Conditional":["C"],"Unsatisfactory":["U"]},"op":"eq","example":"Conditional","description":"Published FMCSA rating: Satisfactory (S), Conditional (C) or Unsatisfactory (U). Unrated carriers have a blank value."},{"key":"registeredSince","label":"Registered since (YYYY-MM-DD)","type":"text","op":"gte","column":"registeredDate","example":"2026-01-01","description":"New carriers are the classic lead list"},{"key":"status","label":"Status","type":"enum","options":["Active","Inactive","Pending"],"op":"eq","example":"Active","description":"The default ingest keeps active carriers only"},{"key":"nameContains","label":"Name contains","type":"text","op":"contains","column":"legalName","example":"Logistics"},{"key":"cityState","label":"City, State / Province","type":"text","op":"eq","example":"Houston, TX","description":"Exact city and state or province code as shown on the list pages"}]}