About this Dataset

Active Insurance Company Appointments For Agents And Adjusters

Appointments 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 Active insurance company appointments for agencies and businesses data set. To view a list of non-appointment relationships between agents, agencies, adjusters, and insurance companies, go to the Business relationships between agents, agencies, adjusters, and insurance companies data set.
Organization: City of Austin
Last updated: 2023-08-25T22:49:09.580975
Tags: adjuster, agencies, agency, agent, agents, appointment, doi, escrow, insurance, license, licenses, producer, tdi, title

Tables

Table 1

@usgov.city_of_austin_active_insurance_company_appointments_f_862e67d4.table_1

39.84 MB
4,124,332 rows
9 columns

CREATE TABLE table_1 (
  "naic_id" DOUBLE,
  "insurance_company_name" VARCHAR,
  "appointment_active_date" TIMESTAMP,
  "appointment_type" VARCHAR,
  "agent_npn" DOUBLE,
  "agent_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postal_code" VARCHAR
);