What CMS datasets can you integrate?

We support a wide range of datasets published on 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.

How often is the data updated?

We update CMS data weekly. Our system automatically detects and processes updates, syncing them to your preferred BI tools or data platforms.

Do you clean and structure the CMS data?

Yes. We remove duplicates, standardize formats, and transform CMS data into analysis-ready structures, eliminating the need for manual cleaning.

Can you integrate with our existing BI tools?

Absolutely. We integrate with Power BI, Tableau, Metabase, and others. If you don’t have a BI tool, we provide a built-in self-service platform.

How do you handle schema changes from CMS?

We monitor for changes and version control schema adjustments to keep your reports stable and your data model intact.

Is this secure and compliant with healthcare standards?

Yes. We follow strict data protection protocols and can deploy in secure, HIPAA-aligned environments if needed.

Do I need a technical team to manage this?

No. We fully manage the integration, updates, and delivery. Your team gets clean data, ready to use, with zero engineering effort.

What if I need historical data?

We preserve historical CMS datasets in consistent schemas, enabling reliable trend analysis and long-term reporting.

Can you help with analytics and reporting?

Yes. Our team includes analysts familiar with CMS data who can help design dashboards, generate insights, or support strategic reporting.

What’s the onboarding time?

We can typically integrate your CMS data and have it live in under a week, thanks to our prebuilt, customizable infrastructure.

Automated CMS Healthcare Data Integration for HealthCare.gov Marketplace Medicaid Unwinding Report datasets

Technical Details

Dataset Description

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: This table includes Marketplace consumers who: 1) submitted a HealthCare.gov application on or after the start of each state’s first reporting month; and 2) who can be linked to an enrollment record in TAF that shows Medicaid or CHIP enrollment between March 2023 and the latest reporting month. Cumulative counts show the number of unique consumers from the included population who had a Marketplace application submitted or a HealthCare.gov Marketplace policy on or after the start of each state’s first reporting month through the latest reporting month. Net counts show the difference between the cumulative counts through a given reporting month and previous reporting months. The data used to produce the metrics are organized by week. Reporting months start on the first Monday of the month and end on the first Sunday of the next month when the last day of the reporting month is not a Sunday. For example, the April 2023 reporting period extends from Monday, April 3 through Sunday, April 30. Data are preliminary and will be restated over time to reflect consumers most recent HealthCare.gov status. Data may change as states resubmit T-MSIS data or data quality issues are identified. Data do not represent Marketplace consumers who had a confirmed Medicaid/CHIP loss. Future reporting will look at coverage transitions for people who lost Medicaid/CHIP. See the data and methodology documentation for a full description of the data sources, measure definitions, and general data limitations. Data notes: Virginia operated a Federally Facilitated Exchange (FFE) on the HealthCare.gov platform during 2023. In 2024, the state started operating a State Based Marketplace (SBM) platform. This table only includes data on 2023 applications and policies obtained through the HealthCare.gov Marketplace. Due to limited Marketplace activity on the HealthCare.gov platform in December 2023, data from December 2023 onward are excluded. The cumulative count and percentage for Virginia and the HealthCare.gov total reflect Virginia data from April 2023 through November 2023. The report may include negative 'net counts,' which reflect that there were cumulatively fewer counts from one month to the next. Wyoming has negative ‘net counts’ for most of its metrics in March 2024, including 'Marketplace Consumers with Previous Medicaid or CHIP Enrollment.' Negative counts reflect that there were cumulatively fewer individual counts from one month to the next. The net percentages have been replaced with an asterisk for March 2024 due to the uninterpretable values. Percentages shown are of total Marketplace consumers with previous Medicaid or CHIP enrollment. Some cells have a value of "NR" or not reported. State data starts being reported in the month when the state's first unwinding renewal cohort is due. APTC: Advance Premium Tax Credit; CHIP: Children's Health Insurance Program; NR: Not reported; QHP: Qualified Health Plan

MetaData

Landing Page

https://data.medicaid.gov/dataset/9a83ba5e-05f5-47f5-82de-f3a59233a912#overview

Keywords

marketplace, transitions in coverage

Publisher

data.medicaid.gov

Program Code

09:00

Bureau Code

09:00

Don't want to deal with it? Automate it instead

HealthCare.gov Marketplace Medicaid Unwinding Report

Automate Your CMS Data Ingestion

Download HealthCare.gov Marketplace 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.

Discovery Call - CMS Data Automation
30 min
Book A Call

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

Get CMS Data Integration Help

Discovery Call - CMS Data Automation
30 min
Let's Talk

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.

FAQ

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.
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.
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.
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.
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.
Is this secure and compliant with healthcare standards?

Yes. However, due to the public nature of the data, HIPAA does not apply.
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.
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.
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.
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.