Business relationships between agents, agencies, adjusters, and insurance companies

This data set includes a row for each type of non-appointment relationship between an insurance agent, agency, adjuster, and businesses and an insurance company or another person or business approved to manage insurance-related products or claims. To view a list of formal designations, or appointments, for agents to represent a regulated company, go to <a href=" https://data.texas.gov/dataset/Active-insurance-company-appointments-for-agents-a/ft7p-v8a7" target="_blank"><u>Active insurance company appointments for agents and adjusters</u></a>. To view a list of formal designations, or appointments, for agencies to represent a regulated company, go to <a href="https://data.texas.gov/dataset/Active-insurance-company-appointments-for-agencies/avjc-7u2m" target="_blank"><u>Active insurance company appointments for agencies and businesses</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/business-relationships-between-agents-agencies-kvqi-vsrr\".\"business_relationships_between_agents_agencies\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.