Name: Health Insurance Coverage
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Health Insurance Coverage

Context

The Affordable Care Act (ACA) is the name for the comprehensive health care reform law and its amendments which addresses health insurance coverage, health care costs, and preventive care. The law was enacted in two parts: The Patient Protection and Affordable Care Act was signed into law on March 23, 2010 by President Barack Obama and was amended by the Health Care and Education Reconciliation Act on March 30, 2010.

Content

This dataset provides health insurance coverage data for each state and the nation as a whole, including variables such as the uninsured rates before and after Obamacare, estimates of individuals covered by employer and marketplace healthcare plans, and enrollment in Medicare and Medicaid programs.

Acknowledgements

The health insurance coverage data was compiled from the US Department of Health and Human Services and US Census Bureau.

Inspiration

How has the Affordable Care Act changed the rate of citizens with health insurance coverage? Which states observed the greatest decline in their uninsured rate? Did those states expand Medicaid program coverage and/or implement a health insurance marketplace? What do you predict will happen to the nationwide uninsured rate in the next five years?

Tables

States

@kaggle.hhs_health_insurance.states

16.48 kB
52 rows
14 columns

CREATE TABLE states (
  "state" VARCHAR,
  "uninsured_rate_2010" VARCHAR  -- Uninsured Rate (2010),
  "uninsured_rate_2015" VARCHAR  -- Uninsured Rate (2015),
  "uninsured_rate_change_2010_2015" VARCHAR  -- Uninsured Rate Change (2010-2015),
  "health_insurance_coverage_change_2010_2015" BIGINT  -- Health Insurance Coverage Change (2010-2015),
  "employer_health_insurance_coverage_2015" BIGINT  -- Employer Health Insurance Coverage (2015),
  "marketplace_health_insurance_coverage_2016" BIGINT  -- Marketplace Health Insurance Coverage (2016),
  "marketplace_tax_credits_2016" BIGINT  -- Marketplace Tax Credits (2016),
  "average_monthly_tax_credit_2016" VARCHAR  -- Average Monthly Tax Credit (2016),
  "state_medicaid_expansion_2016" VARCHAR  -- State Medicaid Expansion (2016),
  "medicaid_enrollment_2013" DOUBLE  -- Medicaid Enrollment (2013),
  "medicaid_enrollment_2016" BIGINT  -- Medicaid Enrollment (2016),
  "medicaid_enrollment_change_2013_2016" DOUBLE  -- Medicaid Enrollment Change (2013-2016),
  "medicare_enrollment_2016" BIGINT  -- Medicare Enrollment (2016)
);