Commodity Insurance Plans by Year

This dataset provides an annual update based on the fiscal year (April 1- March 31) of all the insurance plans outlined by regulations under the Crop and Livestock Insurance Act for the number of growers participating in the plan, number of acres, herds, trees or animals insured, total coverage in dollars for each plan, as well as total indemnities which provides protection against future loss or financial burden.

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 \"novascotia-ca/commodity-insurance-plans-by-year-s37s-4gfp\".\"commodity_insurance_plans_by_year\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.