top of page

Technical Details

Dataset Description
State-reported data on Medicaid and CHIP eligibility renewals that reflect the outcomes of previously pending renewals three months after the renewal was due and also any corrections to the original renewal data submitted to CMS. See here for original renewal data. CMS renewal data specifications require states to update and submit to CMS their monthly renewal outcome metrics - metric 5 data and its submetrics (monthly metrics 5a, 5a(1), 5a(2), 5b, 5c, and 5d) - after the original monthly report submission. The “updated” renewal data reflect the outcomes of renewals previously reported as pending (monthly metric 5d of the original monthly report) as of three months after the renewal was due. For more information about this data set and considerations for users when reviewing, please see the Medicaid and CHIP Unwinding: Data Sources and Metrics Definitions Overview found here. Sources: (1) March 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on March 05, 2024, representing the updated disposition of renewals due in March 2023 as of June 2023. April 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on March 05, 2024, representing the updated disposition of renewals due in April 2023 as of July 2023. May 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on March 05, 2024, representing the updated disposition of renewals due in May 2023 as of August 2023. June 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on March 05, 2024, representing the updated disposition of renewals due in June 2023 as of September 2023. July 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on March 05, 2024, representing the updated disposition of renewals due in July 2023 as of October 2023. August 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on March 05, 2024, representing the updated disposition of renewals due in August 2023 as of November 2023. September 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on April 02, 2024, representing the updated disposition of renewals due in September 2023 as of December 2023. October 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on April 02, 2024, representing the updated disposition of renewals due in October 2023 as of January 2024. November 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on May 07, 2024, representing the updated disposition of renewals due in November 2023 as of February 2024. December 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on June 11, 2024, representing the updated disposition of renewals due in December 2023 as of March 2024. New Hampshire’s December 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on April 09, 2024, representing the updated disposition of renewals due in December 2023 as of March 2024. New York’s December 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on April 22, 2024, representing the updated disposition of renewals due in December 2023 as of March 2024. January 2024 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on July 02, 2024, representing the updated disposition of renewals due in January 2024 as of April 2024. February 2024 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on August 06, 2024, representing the updated disposition of renewals due in February 2024 as of May 2024. March 2024 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report pulled on September 09, 2024, representing the updated disposition of renewals due in March 2024 as of June 2024. Notes: States report updated renewal outcomes for a cohort as of three months after the month renewals are scheduled for completion, unless otherwise noted. In the March 2023 – October 2023 reporting periods, Oklahoma included outcomes for some individuals who returned their renewal form during the reconsideration period. See the Data Sources and Definitions Overview document for a full description of the metric definitions and how they relate to each other. April 2023: Ohio reported updated renewal outcomes for the cohort as of 10/31/2023. Arkansas and Pennsylvania reported the eligibility status of the cohort, and data may include outcomes of eligibility actions that occurred after the renewal. May 2023: The following states reported updated renewal outcomes for the cohort as of a different date: Ohio (outcomes as of 10/31/2023), Rhode Island (outcomes as of 11/1/2023), South Carolina (outcomes as of 12/20/2023), and Texas (outcomes as of 9/8/2023). Pennsylvania, Rhode Island, and South Carolina updated the eligibility status of the cohort, and data may include eligibility actions that occurred after the renewal. June 2023: The following states reported updated renewal outcomes for the cohort as of a different date: Kansas (outcomes as of 8/31/23), Minnesota (outcomes as of 12/2023), Ohio (outcomes as of 10/31/2023), North Carolina (outcomes as of 12/1/2023), Rhode Island (outcomes as of 11/1/2023), and South Carolina (outcomes as of 12/20/2023). Pennsylvania, Rhode Island, and South Carolina updated the eligibility status of the cohort, and data may include eligibility actions that occurred after the renewal. July 2023: The following states reported updated renewal outcomes for the cohort as of a different date: Minnesota (outcomes as of 12/2023), North Carolina (outcomes as of 12/1/2023), Rhode Island (outcomes as of 11/1/2023), and Texas (outcomes as of 11/9/2023). California, Pennsylvania, and Rhode Island updated the eligibility status of the cohort, and data may include eligibility actions that occurred after the renewal. August 2023: The following states reported updated renewal outcomes for the cohort as of a different date: Minnesota (outcomes as of 12/2023), North Carolina (outcomes as of 12/1/2023), Rhode Island (outcomes as of 12/4/2023), and South Carolina (outcomes as of 12/20/2023). California, Pennsylvania, Rhode Island, and South Carolina updated the eligibility status of the cohort, and data may include eligibility actions that occurred after the renewal. September 2023: The following states reported updated renewal outcomes for the cohort as of a different date: Minnesota (outcomes as of 1/8/2024), North Carolina (1/2/2024), Rhode Island (1/1/2024), and South Carolina (outcomes as of 1/8/2024). California, Pennsylvania, Rhode Island, and South Carolina updated the eligibility status of the cohort, and data may include eligibility actions that occurred after the renewal. Vermont excluded renewal outcomes for some individuals who requested voluntary terminations or who were deceased. October 2023: The following states reported updated renewal outcomes for the cohort as of a different date: Minnesota (outcomes as of 2/12/2024), North Carolina (outcomes as of 2/1/2024), Rhode Island (outcomes as of 2/15/2024), and South Carolina (outcomes as 2/1/2024). California, Pennsylvania, and South Carolina updated the eligibility status of the cohort, and data may include eligibility actions that occurred after the renewal. Rhode Island’s updated data includes some individuals reported as pending whose renewal was completed. November 2023: The following states reported updated renewal outcomes for the cohort as of a different date: Minnesota (outcomes as of 3/4/2024), New York (outcomes as of 3/31/2024), North Carolina (outcomes as of 3/1/2024), Rhode Island (outcomes as of 4/1/2024), and South Carolina (outcomes as of 3/1/2024). Pennsylvania and South Carolina updated the eligibility status of the cohort, and data may include eligibility actions that occurred after the renewal. Rhode Island’s updated data includes some individuals reported as pending whose renewal was completed. California included outcomes for some individuals whose eligibility was redetermined based on a change in circumstances after the renewal was processed. December 2023: The following states reported updated renewal outcomes for the cohort as of a different date: North Carolina (outcomes as of 4/1/2024) and Minnesota (outcomes as of 4/2/2024). Pennsylvania updated the eligibility status of the cohort, and data may include eligibility actions that occurred after the renewal. California included outcomes for some individuals whose eligibility was redetermined based on a change in circumstances after the renewal was processed. January 2024: The following states reported updated renewal outcomes for the cohort as of a different date: North Carolina (outcomes as of 5/1/2024) and Minnesota (outcomes as of 5/6/2024). Pennsylvania updated the eligibility status of the cohort, and data may include eligibility actions that occurred after the renewal. February 2024: The following states reported updated renewal outcomes for the cohort as of a different date: North Carolina (outcomes as of 6/3/2024) and Minnesota (outcomes as of 6/5/2024). Pennsylvania and Wyoming updated the eligibility status of the cohort, and data may include eligibility actions that occurred after the renewal. March 2024: The following states reported updated renewal outcomes for the cohort as of a different date: North Carolina (outcomes as of 7/1/2024) and Texas (outcomes as of 7/1/2024). Pennsylvania and Wyoming updated the eligibility status of the cohort, and data may include eligibility actions that occurred after the renewal. Metric summation note: Total number of beneficiaries due for renewal in the reporting month (Metric 5) = Total number of beneficiaries due for renewal in the reporting month whose coverage was renewed (Metric 5a) + Total beneficiaries determined ineligible for Medicaid and CHIP based on the return of a renewal form (Metric 5b) + Total beneficiaries whose coverage was terminated for a procedural or administrative reason (Metric 5c) + Total number of beneficiaries due for renewal in the reporting month whose renewal was pending at the end of the month (Metric 5d); Total number of beneficiaries due for renewal in the reporting month whose coverage was renewed (Metric 5a) = Total beneficiaries renewed on an ex parte basis (i.e., based on available information) (Metric 5a1) + Total beneficiaries renewed based on the return of a renewal form (Metric 5a2). This document includes state updates to their monthly Medicaid and CHIP renewal outcome data submitted to CMS from the Unwinding Data Report. These data include updates to reporting metrics required under section 1902(tt)(1) of the Social Security Act and additional state-submitted renewal metrics.
MetaData
Landing Page

https://data.medicaid.gov/dataset/e6205a51-e6d7-4849-9882-4483b8a28c41#overview

Keywords

program enrollment, child enrollment, eligibility determinations, applications, chip, enrollment, medicaid

Publisher

data.medicaid.gov

Program Code

09:00

Bureau Code

09:00

Medicaid and CHIP Updated Renewal Outcomes

Download Medicaid and CHIP Updated Renewal Outcomes 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