Surplus Lines Agent And Agency Status Detail
City of Austin
@usgov.city_of_austin_surplus_lines_agent_and_agency_status_detail
City of Austin
@usgov.city_of_austin_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
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
);
Anyone who has the link will be able to view this.