Active insurance company appointments for agents and adjusters

Active insurance company appointments for agents and adjustersAppointments are formal designations to represent regulated insurance companies. This data set includes a row for each active appointment between an agent or adjuster and an insurance company. To view a list of appointments for agencies and businesses, go to the <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 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>Visit the full page to view this data.

This view cannot be displayed

Embed this Dataset

      <div><iframe width="_width_px" title="Active insurance company appointments for agents and adjusters" height="_height_px" src="https://data.texas.gov/w/ft7p-v8a7/7v57-4sdh?cur=So4hL50RusY&from=70aega4m21f" frameborder="0"scrolling="no"><a href="https://data.texas.gov/dataset/Active-insurance-company-appointments-for-agents-a/ft7p-v8a7" title="Active insurance company appointments for agents and adjusters" target="_blank">Active insurance company appointments for agents and adjusters</a></iframe><p><a href="http://www.socrata.com/" target="_blank">Powered by Tyler Technologies</a></p></div>

Size

500x425
760x646
950x808

Custom Size

425x425 is the minimum size

Width

Height

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

NAIC ID: naic_id
Insurance company name: company
Appointment active date: active_date
Appointment type: appointment_type
Agent NPN: npn_ein
Agent name: licensee
City: city
State: state
Postal code: postal_cd

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

State of Texas Open Data Portal

API Endpoint:

Field Names:

OData V4 Endpoint:

OData V2 Endpoint:

Want to leave a comment?

You are leaving data.texas.gov.

Notice