BOC3 - All With History

Dataset Records for each BOC3 agent hired by a carrier/broker/freight forwarder. Each entity must hire a BOC3 agent to represent them in legal matters to obtain operating authority. In some cases, entities may act as their own BOC3 agent. The records in the dataset contain the BOC3 agent’s name and address. The dataset also contains the DOT number and docket number of the represented entity. 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/boc3-all-with-history-2emp-mxtb\".\"boc3_all_with_history\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.