top of page

Technical Details

Dataset Description
Metrics from individual Marketplaces during the current reporting period. The report includes data for the states using State-based Marketplaces (SBMs) that use their own eligibility and enrollment platforms Source: State-based Marketplace (SBM) operational data submitted to CMS. Each monthly reporting period occurs during the first through last day of the reported month. SBMs report relevant Marketplace activity from April 2023 (when unwinding-related renewals were initiated in most SBMs) through the end of a state’s Medicaid unwinding renewal period and processing timeline, which will vary by SBM. Some SBMs did not receive unwinding-related applications during reporting period months in April or May 2023 due to renewal processing timelines. SBMs that are no longer reporting Marketplace activity due to the completion of a state’s Medicaid unwinding renewal period are marked as NA. Some SBMs may revise data from a prior month and thus this data may not align with that previously reported. For April, Idaho’s reporting period was from February 1, 2023 to April 30, 2023. Notes: This table represents consumers whose Medicaid/CHIP coverage was denied or terminated following renewal and 1) whose applications were processed by an SBM through an integrated Medicaid, CHIP, and Marketplace eligibility system or 2) whose applications/information was sent by a state Medicaid or CHIP agency to an SBM through an account transfer process. Consumers who submitted applications to an SBM that can be matched to a Medicaid/CHIP record are also included. See the "Data Sources and Metrics Definition Overview" at http://www.medicaid.gov for a full description of the differences between the SBM operating systems and resulting data metrics, measure definitions, and general data limitations. As of the September 2023 report, this table was updated to differentiate between SBMs with an integrated Medicaid, CHIP, and Marketplace eligibility system and those with an account transfer process to better represent the percentage of QHP selections in relation to applicable consumers received and processed by the relevant SBM. State-specific variations are: - Maine’s data and Nevada’s April and May 2023 data report all applications with Medicaid/CHIP denials or terminations, not only those part of the annual renewal process. - Connecticut, Massachusetts, and Washington also report applications with consumers determined ineligible for Medicaid/CHIP due to procedural reasons. - Minnesota and New York report on eligibility and enrollment for their Basic Health Programs (BHP). Effective April 1, 2024, New York transitioned its BHP to a program operated under a section 1332 waiver, which expands eligibility to individuals with incomes up to 250% of FPL. As of the March 2024 data, New York reports on consumers with expanded eligibility and enrollment under the section 1332 waiver program in the BHP data. - Idaho’s April data on consumers eligible for a QHP with financial assistance do not depict a direct correlation to consumers with a QHP selection. - Virginia transitioned from using the HealthCare.gov platform in Plan Year 2023 to an SBM using its own eligibility and enrollment platform in Plan Year 2024. Virginia's data are reported in the HealthCare.gov and HeathCare.gov Transitions Marketplace Medicaid Unwinding Reports through the end of 2024 and is available in SBM reports as of the April 2024 report. Virginia's SBM data report all applications with Medicaid/CHIP denials or terminations, not only those part of the annual renewal process, and as a result are not directly comparable to their data in the HealthCare.gov data reports. - Only SBMs with an automatic plan assignment process have and report automatic QHP selections. These SBMs make automatic plan assignments into a QHP for a subset of individuals and provide a notification of options regarding active selection of an alternative plan and/or, if applicable, making the first month’s premium payment. SBMs report on all applicable applications received and not on the Medicaid-defined cohorts of individuals whose renewal is due in a given month. The data in this table are not cumulative and count unique Marketplace activities during the reporting period month in which the relevant activity occurs. As such, activities by any one consumer may be included across reporting months. For example, a consumer who submits an application and receives a determination of QHP eligibility may be counted in one month but his/her plan selection could be counted in a later month. Thus, the percentages do not necessarily depict a direct correlation to the count of consumers on applications received during the current reporting month. Total counts represent activity across the reporting months and are not cumulative as of the latest reporting month. Updated applications in the reporting month are only counted once. Updated applications in a following month may be counted again in that applicable month only if the consumer obtains a new Medicaid/CHIP renewal. SBMs have different operational processes and eligibility systems for handling QHP, Medicaid and CHIP eligibility determinations. While CMS works with SBMs to align the metric definitions across the Marketplaces there can be limitations and anomalies among the SBM data due to different SBM system capabilities. Additionally, variances in the data may be attributable to differences in how states are conducting unwinding renewals including processing timelines and whether states are staging applications for population cohorts (e.g., over age 65). Percentages shown are of consumers on applications whose Medicaid/CHIP coverage was denied or terminated following renewal during the reporting period month. Percentages shown are of consumers on account transfers whose Medicaid/CHIP coverage was denied or terminated following renewal during the reporting period month. The percentages for SBMs with integrated eligibility systems and the SBM Total - Integrated and SBM Total data record groups are marked as not available (NA) because SBMs with integrated eligibility systems do not receive account transfers. Additionally, some SBMs with account transfer processes adjusted, with guidance from CMS, the count of "Consumers on Account Transfers Associated with a Medicaid/CHIP Coverage Denial or Termination Following Renewal" to include all consumers on applications who are associated with a Medicaid/CHIP coverage denial or termination following renewal for purposes of calculating the Percent - Account Transfer data record group. For example, Pennsylvania conducts automatic QHP eligibility determinations for Marketplace plans for some account transfers and as of the December 2023 report, revised its data to report those consumers in the account transfer and application metrics. As of the April 2024 report, New Jersey revised its data to report consumers on account transfers and direct applications in the account transfer and application metrics to reflect overall SBM activity in the Percent - Account Transfer data record group. APTC: Advance Premium Tax Credit; CHIP: Children's Health Insurance Program; QHP: Qualified Health Plan; BHP: Basic Health Program
MetaData
Landing Page
Keywords

marketplace, transitions in coverage

Publisher

data.medicaid.gov

Program Code

09:00

Bureau Code

09:00

State-based Marketplace (SBM) Medicaid Unwinding Report

Download State-based Marketplace (SBM) Medicaid Unwinding Report In Real Time

Getting CMS data into your dashboards shouldn’t require a team of engineers. We automate the end-to-end process, from pulling fresh datasets from data.cms.gov, to cleaning, structuring, and feeding them into your BI environment.

 

Whether you’re using Power BI, Tableau, Metabase, or need help picking the right tool, we make sure your data is accurate, up-to-date, and always ready for analysis.

Our Expertise With Health Care Data Integration

Anyone can wire up a CMS API. Red Corner has done far more than we’ve led data platform projects in providers, payers, and analytics firms, where CMS data wasn’t optional; it was mission-critical. We understand the downstream pressure: reports must run, queries must work, and decision-makers need answers quickly.

 

That’s why we build systems that aren’t just technically correct; they’re reliable under pressure, scalable, and deeply aligned with your business goals.

The Red Corner Approach

Most teams stop at pulling CMS data. We don’t. Red Corner understand that raw CMS datasets are messy, often duplicated, inconsistently structured, and a pain to work with.

 

That’s why we build more than just pipelines. We design and maintain robust processing systems that normalize, clean, and reshape CMS data into models that analysts and BI tools can work with immediately.

 

We don’t just deliver data; we deliver clarity, speed, and answers.

Foundational

We’ve already done the heavy lifting. Red Corner builds and manages robust systems that extract, clean, and structure CMS data reliably, so you don’t have to sink hundreds of thousands of dollars into solving the same problems.

 

From day one, your team gets access to a dependable, production-grade pipeline that’s been hardened across multiple clients and use cases. It’s plug-in ready, maintainable, and built for scale.

1

2

Evolution

Once your CMS data is flowing and structured, we don’t stop. Red Corner ensures historical consistency by storing and managing all past data in the same unified structure. That means the reports you build today won’t break tomorrow, even as CMS releases new versions or modifies schemas.

 

We will also guide you through understanding where this stability delivers cost savings, analytics acceleration, and long-term ROI across teams.

3

Growth

With a reliable CMS data pipeline in place, your organization can stop relying on analysts for every insight.

 

Red Corner structures your data to work natively with modern BI tools, enabling business leaders to explore trends, spot risks, and make informed decisions without bottlenecks.

 

We will help extend that reach across teams, empowering everyone to move faster with data they can trust.

Expert Guidance

We have worked deep in the healthcare trenches, where CMS data is not just a compliance tool but a driver of strategic decisions. We’ve seen the pitfalls: broken queries, outdated datasets, overworked analysts, and built systems that avoid them.

 

With Red Corner, you’re not just getting someone to wire up a feed. You’re getting a seasoned partner who knows how CMS data powers quality improvement, benchmarking, and real-world business outcomes.

Continuous Support

The moment you sign up with us, your CMS data stays fresh. Red Corner ensures automated, ongoing updates from data.cms.gov starting on day zero. No stale reports, no surprise schema changes.

 

We monitor, manage, and maintain the entire flow so your teams always have access to the latest available data, ready for analysis when you need it.

Tailored Solutions

Whether you need your CMS data in your existing Power BI, Tableau, or Metabase setup or you’re starting from scratch, we’ve got you covered.

 

Red Corner offers a ready-to-use, self-service BI interface that lets your team chat with the data directly, no SQL or tech support required. Prefer your own environment? We’ll integrate clean, query-ready data right into your existing tools. 

Innovative Approach

Innovation, for us, means cutting through the usual complexity. With Red Corner, your CMS data arrives report-ready from day one, clean, structured, and instantly usable in any BI tool. No manual wrangling, no delayed timelines, no guesswork.

 

We’ve built a system that turns a messy public dataset into a plug-and-play source of truth, so your team can skip straight to insights.

Live, Updated CMS Data — Delivered as a Service by Red Corner

Let's Get To Work

TELEPHONE. 514-777-3883

Founded with Love in Montreal, Canada, but operates around the world :-)

Book a call to learn more about how Red Corner's CTO as a Service can grow and support your engineering organization today.

Thanks for submitting. We'll get back to you shortly!

Contact Us

FAQ

  1. What CMS datasets can you integrate?

    We support a wide range of datasets published on data.cms.gov, including Medicare Provider Utilization, Hospital Quality, Medicare Advantage plan ratings, and more. If it’s available from CMS, we can pull it, process it, and deliver it into your analytics workflow fully structured and analysis-ready.
     

  2. How often is the data updated?

    We update CMS data weekly, as new files are published. Our system automatically detects updates, processes the latest versions, and syncs them to your destination, whether that’s a BI tool, a data warehouse, or our self-service interface. You don’t have to lift a finger.
     

  3. Do you clean and structure the CMS data?

    Yes. CMS datasets are often unstructured, inconsistent, and full of duplicate entries. We clean every record, normalize date formats, and ensure column consistency so that your analysts spend time analyzing, not fixing broken rows and cells.
     

  4. Can you integrate with our existing BI tools?

    Absolutely. Whether you use Power BI, Tableau, Metabase, Looker, or another tool, we adapt to your environment. If you don’t yet have a BI tool, we’ll provide a powerful self-service interface where your team can explore and visualize the data from day one.
     

  5. How do you handle schema changes from CMS?

    CMS can change field names, column formats, or file layouts without notice. Our pipelines track version changes, test against historical schemas, and preserve your existing data model. That means your reports don’t break, even when CMS makes changes upstream.
     

  6. Is this secure and compliant with healthcare standards?

    Yes. However, due to the public nature of the data, HIPAA does not apply.
     

  7. Do I need a technical team to manage this?

    No. Red Corner manages the full stack from ingestion to transformation to delivery. Your team gets clean, up-to-date data in the tools they already use, without needing internal engineers to maintain scripts or fix broken pipelines.
     

  8. What if I need historical data?

    We don’t just keep current data; we preserve all historical files in the same structured schema. This makes it easy to build reports over time, compare year-over-year trends, and answer complex analytical questions without having to jump through hoops.
     

  9. Can you help with analytics and reporting?

    Yes. We provide not only the data but also expert analysts who understand the healthcare context behind it. Whether you need ad hoc reports, dashboard design, or help interpreting trends, we’re here to support your goals, not just deliver files.
     

  10. What’s the onboarding time?

    In most cases, we can have your CMS data live and integrated in under a few weeks. Our systems are built and battle-tested, which means we don’t start from scratch; we start with what works and tailor it to your needs.

bottom of page