Carrier - All With History

Dataset Records for all carriers/brokers/freight forwarders with active, inactive, or pending authorities (common or contract). It includes the DOT number and MC/FF/MX number for the carrier/broker/freight forwarder, along with company census data (e.g., types of authority, address, types of insurance on file, and amounts of insurance on file). See dataset attachment "FMCSA Dataset Description and Data Definitions - Select Datasets" for more information.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"datahub-transportation-gov/carrier-all-with-history-6eyk-hxee\".\"carrier_all_with_history\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.