Dataset: Insurance Complaints: All Data

About this Dataset

Insurance Complaints: All Data

► The Texas Department of Insurance (TDI) handles complaints against people and organizations licensed by TDI, such as companies, agents, and adjusters. To learn more, go to the TDI webpage, How to get help with an insurance issue or file a complaint. ► This dataset includes a row for each person and organization named in a complaint. This means some complaint numbers are listed multiple times. To view a dataset that lists each complaint number once due to removing the “Complaint filed against” column, use TDI Complaints: One Record / Complaint.
Organization: City of Austin
Last updated: 2023-08-25T23:35:26.352674
Tags: accident, agent, auto, carrier, casualty, company, complaint, department, doi, health, homeowner, insurance, life, property, tdi

Tables

Table 1

@usgov.city_of_austin_insurance_complaints_all_data.table_1

6.19 MB
268465 rows
17 columns


CREATE TABLE table_1 (
  "complaint_number" BIGINT,
  "complaint_filed_against" VARCHAR,
  "complaint_filed_by" VARCHAR,
  "reason_complaint_filed" VARCHAR,
  "confirmed_complaint" VARCHAR,
  "how_resolved" VARCHAR,
  "received_date" TIMESTAMP,
  "closed_date" TIMESTAMP,
  "complaint_type" VARCHAR,
  "coverage_type" VARCHAR,
  "coverage_level" VARCHAR,
  "others_involved" VARCHAR,
  "respondent_id" BIGINT,
  "respondent_role" VARCHAR,
  "respondent_type" VARCHAR,
  "complainant_type" VARCHAR,
  "keywords" VARCHAR
);