Complaint indexes and policy counts for insurance companies

The Texas Department of Insurance (TDI) regulates the state’s insurance industry and oversees the administration of the Texas workers’ compensation system. This data set includes counts for confirmed complaints and policies in force by company name and line of coverage. The complaint index is calculated by dividing the company's percentage of complaints for a specific line of insurance by the company's percentage of policies in force for the same line of insurance. The average index is 1.00. A number less than 1 indicates fewer complaints than average. A number greater than 1 indicates more complaints than average. Please visit <a href="https://data.texas.gov/dataset/Insurance-complaints-All-data/ubdr-4uff" target="_blank"><u>TDI Complaints: All Data </u></a>for details about processed complaints.

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 \"texas-gov/complaint-indexes-and-policy-counts-for-insurance-pa9u-9s9w\".\"complaint_indexes_and_policy_counts_for_insurance\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.