Icon for Socrata external plugin
Open repository in Console
Updated 14 hours ago
Indexed 2 hours ago

Active insurance company appointments for agencies and businesses

Appointments are formal designations to represent regulated insurance companies. This data set includes a row for each active appointment between an insurance agency and an insurance company. To view a list of appointments for agents and adjusters, go to the <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 data set</u></a>. To view a list of non-appointment relationships between agents, agencies, adjusters, and insurance companies, go to the <a href="https://data.texas.gov/dataset/Business-relationships-between-agents-agencies-adj/kvqi-vsrr" target="_blank"><u>Business relationships between agents, agencies, adjusters, and insurance companies data set.</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" \
{"sql": "
    SELECT *
    FROM \"texas-gov/active-insurance-company-appointments-for-agencies-avjc-7u2m\".\"active_insurance_company_appointments_for_agencies\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • active_insurance_company_appointments_for_agencies
Upstream Metadata