About this Dataset

Rate Review Detail, Trend

This data is from the California Department of Managed Health Care (DMHC). It contains all information on health plan proposed premium rates filed with the DMHC since January 1, 2011. The DMHC is committed to providing the public with information in order to expand consumer understanding about premium rate increases. The DMHC does not have the authority to approve or deny rate increases; however, the DMHC's review of proposed premium rates improves accountability in health plan rate setting and often results in a reduction in the proposed rate.
Organization: State of California
Last updated: 2021-07-23T12:38:24.134851
Tags: california-department-of-managed-health-care, dmhc, filing, premium, rate-increase, rate-review, rates

Tables

Rate Review Detail, Trend

@usgov.ca_gov_rate_review_detail_trend.rate_review_detail_trend

48.69 KB
1303 rows
11 columns


CREATE TABLE rate_review_detail_trend (
  "referenceid" VARCHAR,
  "legalname" VARCHAR,
  "reportingyear" BIGINT,
  "filingtype" VARCHAR,
  "filingstatus" VARCHAR,
  "markettype" VARCHAR,
  "productname" VARCHAR,
  "proposedrateincrease" VARCHAR,
  "finalrateincrease" VARCHAR,
  "memberaffected" VARCHAR,
  "dateeffective" VARCHAR
);

Table 1

@usgov.ca_gov_rate_review_detail_trend.table_1

51.58 KB
1444 rows
11 columns


CREATE TABLE table_1 (
  "referenceid" VARCHAR,
  "legalname" VARCHAR,
  "reportingyear" BIGINT,
  "filingtype" VARCHAR,
  "filingstatus" VARCHAR,
  "markettype" VARCHAR,
  "productname" VARCHAR,
  "proposedrateincrease" VARCHAR,
  "finalrateincrease" VARCHAR,
  "memberaffected" VARCHAR,
  "dateeffective" VARCHAR
);