Overview

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.

Key Features

1.Company : The name of the insurance company involved in the complaint.

2.File No. : A unique identification number or code assigned to each complaint file.

3.Opened : The date and time when the complaint was opened or received.

4.Closed: The date and time when the complaint was resolved and officially closed.

5.Coverage : The type of insurance coverage related to the complaint (e.g., auto insurance, health insurance, etc.).

6.SubCoverage : Further details or subcategory of the insurance coverage.

7.Reason : The main reason or cause of the complaint.

8.SubReason : Further details or subcategory of the reason for the complaint.

9.Disposition : The outcome or resolution of the complaint (e.g., resolved, denied, pending, etc.).

10.Conclusion : Additional notes or information about the conclusion of the complaint.

11.Recovery : The amount of money recovered, if applicable, as a result of resolving the complaint.

12.Status : The current status of the complaint (e.g., open, closed, in progress, etc.).

If this was helpful, a vote is appreciated 😁

Tables

Insurance Company Complaints Resolutions Status And Recoveries

@kaggle.adelanseur_insurance_company_complaints.insurance_company_complaints_resolutions_status_and_recoveries

545.75 KB
38267 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
);