Dataset: CMS Insurance Plan Enrollment By State

About this Dataset

CMS Insurance Plan Enrollment By State

Content

The Affordable Care Act created the new Pre-Existing Condition Insurance Plan (PCIP) program to make health insurance available to Americans denied coverage by private insurance companies because of a pre-existing condition. Coverage for people living with such conditions as diabetes, asthma, cancer, and HIV/AIDS has often been priced out of the reach of most Americans who buy their own insurance, and this has resulted in a lack of coverage for millions. The temporary program covers a broad range of health benefits and is designed as a bridge for people with pre-existing conditions who cannot obtain health insurance coverage in today’s private insurance market. To learn more, visit PCIP.gov or HealthCare.gov.

Note: * Massachusetts and Vermont are guarantee issue states that have already implemented many of the broader market reforms included in the Affordable Care Act that take effect in 2014. Existing commercial plans offering guaranteed coverage at premiums comparable to PCIP are already available in both states.

Context

This is a dataset hosted by the Centers for Medicare & Medicaid Services (CMS). The organization has an open data platform found here and they update their information according the amount of data that is brought in. Explore CMS's Data using Kaggle and all of the data sources available through the CMS organization page!

Update Frequency: This dataset is updated daily.

Acknowledgements

This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by Lily Banse on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

Tables

Monthly Pre Existing Condition Insurance Plan Enrollme Fb12bb4c

@kaggle.cms_cms_insurance_plan_enrollment_by_state.monthly_pre_existing_condition_insurance_plan_enrollme_fb12bb4c

42.57 KB
52 rows
38 columns


CREATE TABLE monthly_pre_existing_condition_insurance_plan_enrollme_fb12bb4c (
  "state" VARCHAR,
  "federally_state_administered" VARCHAR,
  "enrolled_through_january_31_2014" BIGINT,
  "enrolled_through_december_31_2013" BIGINT,
  "enrolled_through_november_30_2013" BIGINT,
  "enrolled_through_october_31_2013" BIGINT,
  "enrolled_through_september_30_2013" BIGINT,
  "enrolled_through_august_31_2013" BIGINT,
  "enrolled_through_july_31_2013" BIGINT,
  "enrolled_through_june_30_2013" BIGINT,
  "enrolled_through_may_31_2013" BIGINT,
  "enrolled_through_april_30_2013" BIGINT,
  "enrolled_through_mar_31_2013" BIGINT,
  "enrolled_through_feb_28_2013" BIGINT,
  "enrolled_through_jan_31_2013" BIGINT,
  "enrolled_through_dec_31_2012" BIGINT,
  "enrolled_through_nov_30_2012" BIGINT,
  "enrolled_through_october_31_2012" BIGINT,
  "enrolled_through_september_30_2012" BIGINT,
  "enrolled_through_august_31_2012" BIGINT,
  "enrolled_through_july_31_2012" BIGINT,
  "enrolled_through_june_30_2012" BIGINT,
  "enrolled_through_may_31_2012" BIGINT,
  "enrolled_through_april_30_2012" BIGINT,
  "enrolled_through_march_31_2012" BIGINT,
  "enrolled_through_february_29_2012" BIGINT,
  "enrolled_through_december_31_2011" BIGINT,
  "enrolled_through_november_30_2011" BIGINT,
  "enrolled_through_october_31_2011" BIGINT,
  "enrolled_through_september_30_2011" BIGINT,
  "enrolled_through_august_31_2011" BIGINT,
  "enrolled_through_july_31_2011" BIGINT,
  "enrolled_through_june_30_2011" BIGINT,
  "enrolled_through_may_31_2011" BIGINT,
  "enrolled_through_april_30_2011" BIGINT,
  "enrolled_through_march_31_2011" BIGINT,
  "enrolled_through_february_1_2011" BIGINT,
  "enrolled_through_november_1_2011" BIGINT
);