Name: Insurance Company Complaints
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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

235.75 kB
14,509 rows
12 columns

CREATE TABLE insurance_company_complaints_resolutions_status_and_recoveries (
  "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
);