About this Dataset

Surplus Lines Agent And Agency Status Detail

This data set includes a row for each person or organization with an active or inactive Surplus Lines license issued by TDI. For detailed search results on individual agencies, agents, and adjusters please click here: Detailed reports.
Organization: City of Austin
Last updated: 2023-08-25T22:15:33.583924
Tags: agencies, agency, agents, casualty, doi, license, licenses, licensing, lines, property, surplus, tdi

Tables

Table 1

@usgov.city_of_austin_surplus_lines_agent_and_agency_status_detail.table_1

582.85 KB
17248 rows
9 columns


CREATE TABLE table_1 (
  "license_number" BIGINT,
  "license_status" VARCHAR,
  "licensee_name" VARCHAR,
  "entity_type" VARCHAR,
  "resident_state" VARCHAR,
  "license_original_issue_date" TIMESTAMP,
  "license_effective_date" TIMESTAMP,
  "license_expiration_date" TIMESTAMP,
  "license_inactivation_reason" VARCHAR
);