Iowa Property Casualty Insurance Premiums and Losses

Dataset contains information on premiums written, losses paid and taxes paid for property casualty insurance companies licensed to operate in the State of Iowa by year and line of insurance. The data listed in this table comes from amounts reflected in each company's annual statement. The taxes paid column may not represent amounts actually collected by the State of Iowa.

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 \"mydata-iowa-gov/iowa-property-casualty-insurance-premiums-and-inub-pueg\".\"iowa_property_casualty_insurance_premiums_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.