Insurance Company Complaints, Resolutions, Status, And Recoveries

State of Connecticut

@usgov.state_of_connecticut_insurance_company_complaints_reso_a93634f1

Table List

1 table(972.69 KB)

Table 1

@usgov.state_of_connecticut_insurance_company_complaints_reso_a93634f1.table_1

972.69 KB
72934 rows
12 columns

company Company	file_no File No.	opened Opened	closed Closed	coverage Coverage	subcoverage SubCoverage	reason Reason	subreason SubReason	disposition Disposition	conclusion Conclusion	recovery Recovery	status Status
Anthem Health Plans, Inc	7045593	Tue May 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Group	Health Only	Claim Handling	Medically Necessary	Company Position Substantiated	Company Position Upheld		Closed
Anthem Health Plans, Inc	7043381	Mon Feb 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Group	Health Only	Claim Handling	Provider Contract Issue	Claim Settled	Satisfied	6467.3	Closed
Aetna Health and Life Insurance Company	7047493	Thu Aug 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Group	A & H	Claim Handling	Claim Handling Other		Company Position Upheld		Closed
Anthem Health Plans, Inc	7052007	Thu Feb 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	A & H	A & H	Marketing & Sales	Duplicate Coverage	Compromised Settlement/Resolution	Premium Refund	2179.32	Closed
Anthem Health Plans, Inc	7044860	Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	A & H	Health Only	Claim Handling	Denial	Claim Settled	Claim Paid	147.58	Closed
Anthem Health Plans, Inc	7057449	Wed Sep 13 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 18 2023 00:00:00 GMT+0000 (Coordinated Universal Time)			Claim Handling	External Review				Closed
Anthem Health Plans, Inc	7043381	Mon Feb 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Group	A & H	Claim Handling	Provider Contract Issue	Claim Settled	Satisfied	6467.3	Closed
Anthem Health Plans, Inc	7057828	Thu Sep 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Dec 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	A & H	Health Only	Claim Handling	Unsatisfactory Settlement	Question of Fact/Contract/Provision/Legal Issue	Provider Issue	1855.2	Closed
Anthem Health Plans, Inc	7057828	Thu Sep 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Dec 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	A & H	Health Only	Claim Handling	Provider Contract Issue	Question of Fact/Contract/Provision/Legal Issue	Provider Issue	1855.2	Closed
Anthem Health Plans, Inc	7054758	Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Group	A & H	Claim Handling	Provider Contract Issue		Provider Issue		Closed


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