Menu

Building a Trucking Company List From FMCSA Open Data (SoQL Pitfalls Included)
📰

Building a Trucking Company List From FMCSA Open Data (SoQL Pitfalls Included)

DEV Community: api·Ben Barazandeh·9 days ago
#7pD0eGlN
#devtoapi#devto#dev#authority#company
Reading 0:00
15s threshold

Disclosure: I'm Ben, and I built the Apify Actor mentioned later in this post. I charge per result for it. The tutorial part uses only free public data.

Freight insurance agents, factoring companies, ELD and fuel-card sellers, and brokers looking for capacity all need the same thing: a list of trucking companies with a phone number and fleet size. People pay for those lists, but the source behind most of them is free. Every US interstate carrier files an MCS-150 with FMCSA, and US DOT publishes the result as open data, refreshed daily.

Here's how to query it yourself, and what tripped me up.

The datasets

All on data.transportation.gov (Socrata), no key needed for light use:

Company Census File ( az4n-8mr2 ): one row per USDOT number, with legal name, address, phone, email (if filed), power units, drivers, cargo, operation type and status.

L&I "Carrier – All With History" ( 6eyk-hxee ): MC dockets, authority and insurance.

L&I "AuthHist – All With History" ( 9mw4-x3tu ): authority grants, revocations…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.