HealthCare.gov Marketplace Medicaid Unwinding Report
U.S. Department of Health & Human Services
@usgov.hhs_gov_healthcare_gov_marketplace_medicaid_unwinding__0f047f70
U.S. Department of Health & Human Services
@usgov.hhs_gov_healthcare_gov_marketplace_medicaid_unwinding__0f047f70
Metrics from individual Marketplaces during the current reporting period. The report includes data for the states using HealthCare.gov. As of August 2024, CMS is no longer releasing the “HealthCare.gov” metrics. Historical data between July 2023-July 2024 will remain available. The “HealthCare.gov Transitions” metrics, which are the CAA, 2023 required metrics, will continue to be released.
Sources: HealthCare.gov application and policy data through May 5, 2024, and T-MSIS Analytic Files (TAF) through March 2024 (TAF version 7.1 with T-MSIS enrollment through the end of March 2024). Data include consumers in HealthCare.gov states where the first unwinding renewal cohort is due on or after the end of reporting month (state identification based on HealthCare.gov policy and application data). State data start being reported in the month when the state's first unwinding renewal cohort is due. April data include Arizona, Arkansas, Florida, Indiana, Iowa, Kansas, Nebraska, New Hampshire, Ohio, Oklahoma, South Dakota, Utah, West Virginia, and Wyoming. May data include the previous states and the following new states: Alaska, Delaware, Georgia, Hawaii, Montana, North Dakota, South Carolina, Texas, and Virginia. June data include the previous states and the following new states: Alabama, Illinois, Louisiana, Michigan, Missouri, Mississippi, North Carolina, Tennessee, and Wisconsin. July data include the previous states and Oregon. All HealthCare.gov states are included in this version of the report.
Notes:
Data notes:
CREATE TABLE table_1 (
"state" VARCHAR,
"metric" VARCHAR,
"april_2023_net_count" VARCHAR -- April 2023: Net Count,
"april_2023_net_percentage" VARCHAR -- April 2023: Net Percentage,
"may_2023_net_count" VARCHAR -- May 2023: Net Count,
"may_2023_net_percentage" VARCHAR -- May 2023: Net Percentage,
"june_2023_net_count" VARCHAR -- June 2023: Net Count,
"june_2023_net_percentage" VARCHAR -- June 2023: Net Percentage,
"july_2023_net_count" BIGINT -- July 2023: Net Count,
"july_2023_net_percentage" VARCHAR -- July 2023: Net Percentage,
"august_2023_net_count" BIGINT -- August 2023: Net Count,
"august_2023_net_percentage" VARCHAR -- August 2023: Net Percentage,
"september_2023_net_count" BIGINT -- September 2023: Net Count,
"september_2023_net_percentage" VARCHAR -- September 2023: Net Percentage,
"october_2023_net_count" BIGINT -- October 2023: Net Count,
"october_2023_net_percentage" VARCHAR -- October 2023: Net Percentage,
"november_2023_net_count" BIGINT -- November 2023: Net Count,
"november_2023_net_percentage" VARCHAR -- November 2023: Net Percentage,
"december_2023_net_count" VARCHAR -- December 2023: Net Count,
"december_2023_net_percentage" VARCHAR -- December 2023: Net Percentage,
"january_2024_net_count" VARCHAR -- January 2024: Net Count,
"january_2024_net_percentage" VARCHAR -- January 2024: Net Percentage,
"february_2024_net_count" VARCHAR -- February 2024: Net Count,
"february_2024_net_percentage" VARCHAR -- February 2024: Net Percentage,
"march_2024_net_count" VARCHAR -- March 2024: Net Count,
"march_2024_net_percentage" VARCHAR -- March 2024: Net Percentage,
"april_2024_net_count" VARCHAR -- April 2024: Net Count,
"april_2024_net_percentage" VARCHAR -- April 2024: Net Percentage,
"april_2024_cumulative_count" BIGINT -- April 2024: Cumulative Count,
"april_cumulative_2024_percentage" VARCHAR -- April Cumulative 2024: Percentage
);Anyone who has the link will be able to view this.