AuthHist - All With History
Dataset Records showing the history of each authority granted to a carrier/broker/freight forwarder, along with the dates of the original authority action (e.g., “granted”) and the final authority action (e.g., “revoked”). The dataset contains the DOT number and docket number of the entity that holds or held the authority. As there can be multiple authorities for a single entity, there may be multiple records for an 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/authhist-all-with-history-9mw4-x3tu\".\"authhist_all_with_history\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.