Dataset: Insurance Company Complaints

About this Dataset

Insurance Company Complaints

Content

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.

Acknowledgements

Data Provided by
Department of Insurance

Tables

Insurance Company Complaints Resolutions Status And Recoveries

@kaggle.shashwatwork_insurance_company_complaints.insurance_company_complaints_resolutions_status_and_recoveries

230.22 KB
14509 rows
12 columns


CREATE TABLE insurance_company_complaints_resolutions_status_and_recoveries (
  "company" VARCHAR,
  "file_no" BIGINT,
  "opened" TIMESTAMP,
  "closed" TIMESTAMP,
  "coverage" VARCHAR,
  "subcoverage" VARCHAR,
  "reason" VARCHAR,
  "subreason" VARCHAR,
  "disposition" VARCHAR,
  "conclusion" VARCHAR,
  "recovery" DOUBLE,
  "status" VARCHAR
);