About this Dataset

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 Active insurance company appointments for agents and adjusters 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:30:35.309701
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_2f4af17c.table_1

5.49 MB
593,182 rows
10 columns

CREATE TABLE table_1 (
  "naic_id" DOUBLE,
  "insurance_company_name" VARCHAR,
  "appointment_active_date" TIMESTAMP,
  "appointment_type" VARCHAR,
  "agency_npn" VARCHAR,
  "agency_ein" BIGINT,
  "agency_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postal_code" BIGINT
);