About this Dataset

Insurance Agencies And Businesses Approved To Manage Insurance-related Products

The Texas Department of Insurance (TDI) is responsible for licensing, registering, certifying, and regulating agencies and businesses that want to sell insurance or adjust property and casualty claims in Texas. This data set includes a row for each license held by an agency or business. An agency or business with more than one license will be listed in multiple rows. To view a list of people licensed by TDI, go to the Insurance agent and adjusters data set. To learn more about the type of licenses in this data set, go to TDI’s agent and adjuster licensing webpage. For detailed search results on individual agencies, agents, and adjusters please click here: Detailed reports.
Organization: City of Austin
Last updated: 2023-08-25T22:01:17.585143
Tags: adjuster, agencies, agency, agent, agents, doi, escrow, insurance, license, licenses, producer, tdi, title

Tables

Table 1

@usgov.city_of_austin_insurance_agencies_and_businesses_appro_3a6a538b.table_1

2.07 MB
52,558 rows
12 columns

CREATE TABLE table_1 (
  "npn" DOUBLE,
  "license_number" BIGINT,
  "name" VARCHAR,
  "org_type" VARCHAR,
  "license_type" VARCHAR,
  "qualification" VARCHAR,
  "issue_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "city" VARCHAR,
  "state" VARCHAR,
  "postal_code" VARCHAR,
  "county_if_title_agency" VARCHAR  -- County (if Title Agency)
);