Insur - All With History

Dataset Records for carrier/broker/freight forwarder active or pending individual insurance policies. The records are linked to the entities by docket numbers included in the dataset. The dataset contains information on the insurance policy, including insurance company name, policy number and type of insurance. Entities can hold multiple insurance policies, so there may be multiple records associated with a particular 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/insur-all-with-history-ypjt-5ydn\".\"insur_all_with_history\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.