Rejected - All With History
Dataset Information on insurance forms that were rejected by FMCSA. The dataset contains information on the insurance policy associated with the form, along with the date that the form was rejected and the reason for rejection (e.g., “Policy is already cancelled”). The dataset contains the DOT number and docket number of the carrier/broker/freight forwarder associated with the policy. 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/rejected-all-with-history-96tg-4mhf\".\"rejected_all_with_history\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.