Insurance agencies and businesses approved to manage insurance-related products

The Texas Department of Insurance (TDI) is responsible for licensing, registering, certifying, and regulating agencies and businesses that want to sell insurance or adjust property and casualty claims in Texas. This data set includes a row for each license held by an agency or business. An agency or business with more than one license will be listed in multiple rows. To view a list of people licensed by TDI, go to the <a href="https://data.texas.gov/dataset/Insurance-agents-adjusters-and-people-approved-to-/kxv3-diwf" target="_blank"><u>Insurance agent and adjusters data set</u></a>. To learn more about the type of licenses in this data set, go to <a href="https://tdi.texas.gov/agent/index.html" target="_blank"><u>TDI’s agent and adjuster licensing</u></a> webpage. For detailed search results on individual agencies, agents, and adjusters please click here: <a href="https://appscenter.tdi.texas.gov/reports/p/sirconReport" target="_blank"><u>Detailed reports</u></a>.

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/insurance-agencies-and-businesses-approved-to-3yqc-fcdt\".\"insurance_agencies_and_businesses_approved_to\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.