About this Dataset

Insurance Company Complaints, Resolutions, Status, And Recoveries

Listing of consumer complaints filed against Insurance companies licensed in Connecticut. This dataset includes the Company, Line of Business, nature of complaint, outcome or resolution, and recovery.
Organization: State of Connecticut
Last updated: 2020-11-12T14:57:46.412131
Tags: complaints, insurance, recovery

Tables

Table 1

@usgov.state_of_connecticut_insurance_company_complaints_reso_a93634f1.table_1

996.04 kB
72,934 rows
12 columns

CREATE TABLE table_1 (
  "company" VARCHAR,
  "file_no" BIGINT  -- File No.,
  "opened" TIMESTAMP,
  "closed" TIMESTAMP,
  "coverage" VARCHAR,
  "subcoverage" VARCHAR,
  "reason" VARCHAR,
  "subreason" VARCHAR,
  "disposition" VARCHAR,
  "conclusion" VARCHAR,
  "recovery" DOUBLE,
  "status" VARCHAR
);