Total Medicaid Enrollees - VIII Group Break Out Report Reported on the CMS-64 The enrollment information is a state-reported count of unduplicated individuals enrolled in the state’s Medicaid program at any time during each month in the quarterly reporting period. The enrollment data identifies the total number of Medicaid enrollees and, for states that have expanded Medicaid, provides specific counts for the number of individuals enrolled in the new adult eligibility group, also referred to as the “VIII Group”. The VIII Group is only applicable for states that have expanded their Medicaid programs by adopting the VIII Group. This data includes state-by-state data for this population as well as a count of individuals whom the state has determined are newly eligible for Medicaid. All 50 states, the District of Columbia and the US territories are represented in these data. Notes: 1. “VIII GROUP” is also known as the “New Adult Group.” 2. The VIII Group is only applicable for states that have expanded their Medicaid programs by adopting the VIII Group. VIII Group enrollment information for the states that have not expanded their Medicaid program is noted as “N/A.”

Context

This public dataset was created by the Centers for Medicare & Medicaid Services. The data summarize counts of enrollees who are dually-eligible for both Medicare and Medicaid program, including those in Medicare Savings Programs. “Duals” represent 20 percent of all Medicare beneficiaries, yet they account for 34 percent of all spending by the program, according to the Commonwealth Fund . As a representation of this high-needs, high-cost population, these data offer a view of regions ripe for more intensive care coordination that can address complex social and clinical needs. In addition to the high cost savings opportunity to deliver upstream clinical interventions, this population represents the county-by-county volume of patients who are eligible for both state level (Medicaid) and federal level (Medicare) reimbursements and potential funding streams to address unmet social needs across various programs, waivers, and other projects. The dataset includes eligibility type and enrollment by quarter, at both the state and county level. These data represent monthly snapshots submitted by states to the CMS, which are inherently lower than ever-enrolled counts (which include persons enrolled at any time during a calendar year.) For more information on dually eligible beneficiaries

Querying BigQuery tables

You can use the BigQuery Python client library to query tables in this dataset in Kernels. Note that methods available in Kernels are limited to querying data. Tables are at bigquery-public-data.sdoh_cms_dual_eligible_enrollment.

Sample Query

In what counties in Michigan has the number of dual-eligible individuals increased the most from 2015 to 2018? Find the counties in Michigan which have experienced the largest increase of dual enrollment households

duals_Jan_2015 AS ( SELECT Public_Total AS duals_2015, County_Name, FIPS FROM bigquery-public-data.sdoh_cms_dual_eligible_enrollment.dual_eligible_enrollment_by_county_and_program WHERE State_Abbr = "MI" AND Date = '2015-12-01' ),

duals_increase AS ( SELECT d18.FIPS, d18.County_Name, d15.duals_2015, d18.duals_2018, (d18.duals_2018 - d15.duals_2015) AS total_duals_diff FROM duals_Jan_2018 d18 JOIN duals_Jan_2015 d15 ON d18.FIPS = d15.FIPS )

SELECT * FROM duals_increase WHERE total_duals_diff IS NOT NULL ORDER BY total_duals_diff DESC

This dataset includes total enrollment in separate CHIP (S-CHIP) programs by month and state from April 2023 forward. Sources: T-MSIS Analytic Files (TAF) and state-submitted enrollment totals. The data notes indicate when a state’s monthly total was a state-submitted value, rather than from T-MSIS. Methods: Enrollment includes individuals enrolled in S-CHIP at any point during the coverage month, excluding those enrolled in dental-only coverage. The S-CHIP enrollment in this report also excludes enrollees covered by Medicaid expansion CHIP, a program in which a state receives federal funding to expand Medicaid eligibility to optional targeted low-income children that meets the requirements of section 2103 of the Social Security Act. If an individual is enrolled in both Medicaid or Medicaid-expansion CHIP and S-CHIP in a given month, TAF picks the program in which they were last enrolled. Unless S-CHIP enrollment counts are replaced with a state-submitted value, each state's monthly S-CHIP enrollment is equal to the number of unique people in TAF with a CHIP_CODE = 3 (S-CHIP) and ELGBLTY_GRP_CD not equal to ‘66’ (Children Eligible for Dental Only Supplemental Coverage). More information about TAF is available at https://www.medicaid.gov/medicaid/data-systems/macbis/medicaid-chip-research-files/transformed-medicaid-statistical-information-system-t-msis-analytic-files-taf/index.html. Note: A historic dataset with S-CHIP enrollment by month and state from April 2023 to June 2024 is also available at: https://data.medicaid.gov/dataset/d30cfc7c-4b32-4df1-b2bf-e0a850befd77. This historic dataset was created to fulfill reporting requirements under section 1902(tt)(1) of the Social Security Act, which was added by section 5131(b) of subtitle D of title V of division FF of the Consolidated Appropriations Act, 2023 (P.L. 117-328) (CAA, 2023). Please note that the methods used to count S-CHIP enrollees differ slightly between the two datasets; as a result, data users should exercise caution if comparing S-CHIP enrollment across the two datasets. State notes: Alaska, District of Columbia, Hawaii, New Hampshire, New Mexico, North Carolina, North Dakota, Ohio, South Carolina, Vermont, and Wyoming do not have S-CHIP programs. Maryland has an S-CHIP program for the from conception to end of pregnancy group that began in July 2023; April 2023 - June 2023 data for Maryland represents retroactive coverage. Oregon moved all its S-CHIP enrollees, other than those in the from conception to the end of pregnancy group, to a Medicaid-expansion CHIP program effective January 1, 2024. CHIP: Children's Health Insurance Program

This historic dataset with total enrollment in separate CHIP programs by month and state was created to fulfill reporting requirements under section 1902(tt)(1) of the Social Security Act, which was added by section 5131(b) of subtitle D of title V of division FF of the Consolidated Appropriations Act, 2023 (P.L. 117-328) (CAA, 2023). For each month from April 1, 2023, through June 30, 2024, states were required to submit to CMS (on a timely basis), and CMS was required to make public, certain monthly data, including the total number of beneficiaries who were enrolled in a separate CHIP program. Accordingly, this historic dataset contains separate CHIP enrollment by month and state between April 2023 and June 2024. CMS will continue to publicly report separate CHIP enrollment by month and state (beyond the historic CAA/Unwinding period) in a new dataset, which is available at [link]. Please note that the methods used to count separate CHIP enrollees differ slightly between the two datasets; as a result, data users should exercise caution if comparing separate CHIP enrollment across the two datasets. Sources: T-MSIS Analytic Files (TAF) and state-submitted enrollment totals. The data notes indicate when a state’s monthly total was a state-submitted value, rather than from T-MSIS.TAF data were pulled as follows:April 2023 enrollment - TAF as of August 2023May 2023 enrollment - TAF as of August 2023June 2023 enrollment - TAF as of September 2023July 2023 enrollment - TAF as of October 2023August 2023 enrollment - TAF as of November 2023September 2023 enrollment - TAF as of December 2023October 2023 enrollment - TAF as of January 2024November 2023 enrollment - TAF as of February 2024December 2023 enrollment - TAF as of March 2024January 2024 enrollment - TAF as of April 2024February 2024 enrollment - TAF as of May 2024March 2024 enrollment - TAF as of June 2024April 2024 enrollment – TAF as of July 2024May 2024 enrollment – TAF as of August 2024June 2024 enrollment – TAF as of September 2024 TAF are produced one month after the T-MSIS submission month. For example, TAF as of August 2023 is based on July T-MSIS submissions. Notes: The separate CHIP enrollment in this report is not inclusive of enrollees covered by Medicaid expansion CHIP. Enrollment includes individuals enrolled in separate CHIP at any point during the month but excludes those enrolled in both Medicaid and separate CHIP during the month. See the Data Sources and Metrics Definitions Overview document for a full description of the data sources, metric definitions, and general data limitations.Alaska, District of Columbia, Hawaii, New Hampshire, New Mexico, North Carolina, North Dakota, Ohio, South Carolina, Vermont, and Wyoming do not have separate CHIP Programs. Maryland has a separate CHIP program that began in July 2023; April 2023 - June 2023 data for Maryland represents retroactive coverage. This document includes separate CHIP data submitted to CMS by states via T-MSIS or a separate collection form. These data include reporting metrics consistent with section 1902(tt)(1) of the Social Security Act.CHIP: Children's Health Insurance Program Data notes: (a) State-submitted value; data not from T-MSIS(b1) May 2023 enrollment pulled from TAF as of September 2023(b2) Data was restated using TAF as of October 2023(b3) Data was restated using TAF as of April 2024(b4) Data was restated using TAF as of July 2024(b5) Data was restated using TAF as of August 2024(c) Enrollment counts include postpartum women with coverage funded via a Health Services Initiative

This dataset includes the total number of individuals enrolled in Medi-Cal by eligibility group: Modified Adjusted Gross Income (MAGI), non-MAGI, and Children’s Health Insurance Program (CHIP). The groups are defined by the Centers for Medicare and Medicaid Services (CMS) Performance Indicators (CMSPI) reporting requirements. The Department of Health Care Services (DHCS) submits eligibility and enrollment data regarding Medicaid and CHIP monthly to CMS. The enrollment data represents enrollment totals as of 60 days after the eligibility month (indicated as “Reporting Period” in the dataset). CMS publishes the state total enrollments on the CMSPI website. The total enrollment comprises of individuals who are eligible for full scope Medi-Cal by MAGI – Child, MAGI – Adult, Non-MAGI Child, Non-MAGI Adult, and CHIP eligibility groups. DHCS does not report to CMS the total enrollment in limited scope Medi-Cal or state-only funded programs (indicated as the “Non-CMSPI” in the dataset).

State-reported data on Medicaid and CHIP eligibility renewals conducted during the reporting period and call center operations Sources: (1) March and April 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of June 13, 2023. Florida's March and April 2023 Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of June 05, 2023. May 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of July 12, 2023. Florida's May 2023 Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of July 03, 2023. June 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of August 16, 2023. Florida's June 2023 Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of July 31, 2023. July 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of September 12, 2023. August 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of October 23, 2023. September 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of November 07, 2023. Delaware’s September state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of November 28, 2023. October 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of December 05, 2023. November 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of January 05, 2024. December 2023 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of February 08, 2024. January 2024 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of March 05, 2024. February 2024 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of April 02, 2024. The total number of Medicaid and CHIP beneficiaries for whom a renewal was initiated in the reporting month (metric 4) for Idaho and Nebraska as of April 12, 2024. March 2024 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of May 07, 2024. April 2024 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of June 11, 2024. May 2024 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of July 02, 2024. June 2024 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of August 06, 2024. July 2024 state Medicaid and CHIP Renewal and Termination Data for the Unwinding Data Report as of September 09, 2024. (2) Call Center Data from the Medicaid and CHIP Eligibility and Enrollment Performance Indicator Data as of September 10, 2024. Notes: For all states, data may be affected by mitigation strategies in place, such as those related to ex parte functionality. Georgia reported data for individuals who continue to be eligible following a change in circumstances and were granted a new 12-month eligibility period during the April - July 2024 reporting periods, along with data on individuals due for renewal in these months. South Dakota did not initiate or complete renewals in the March - July 2024 reporting period due to a mitigation strategy for ex parte functionality. South Dakota did not initiate renewals in the February 2024 reporting period due to a mitigation strategy for ex parte functionality. Due to temporary renewal process changes, most renewals due in Iowa, including ex parte renewals, were not completed by the end of the reporting month for the December 2023 - February 2024 reporting periods. Hawaii and Vermont experienced a natural disaster, and the number of renewals initiated and completed in the reporting period were impacted due to the disaster response efforts in the month of August 2023. South Carolina does not have renewal outcomes to report

Context

The CMS National Plan and Provider Enumeration System (NPPES) was developed as part of the Administrative Simplification provisions in the original HIPAA act. The primary purpose of NPPES was to develop a unique identifier for each physician that billed medicare and medicaid. This identifier is now known as the National Provider Identifier Standard (NPI) which is a required 10 digit number that is unique to an individual provider at the national level.

Once an NPI record is assigned to a healthcare provider, parts of the NPI record that have public relevance, including the provider’s name, speciality, and practice address are published in a searchable website as well as downloadable file of zipped data containing all of the FOIA disclosable health care provider data in NPPES and a separate PDF file of code values which documents and lists the descriptions for all of the codes found in the data file.

Content

The dataset contains the latest NPI downloadable file in an easy to query BigQuery table, npi_raw. In addition, there is a second table, npi_optimized which harnesses the power of Big Query’s next-generation columnar storage format to provide an analytical view of the NPI data containing description fields for the codes based on the mappings in Data Dissemination Public File - Code Values documentation as well as external lookups to the healthcare provider taxonomy codes . While this generates hundreds of columns, BigQuery makes it possible to process all this data effectively and have a convenient single lookup table for all provider information.

Fork this kernel to get started.

Acknowledgements

https://bigquery.cloud.google.com/dataset/bigquery-public-data:nppes?_ga=2.117120578.-577194880.1523455401

https://console.cloud.google.com/marketplace/details/hhs/nppes?filter=category:science-research

Dataset Source: Center for Medicare and Medicaid Services. This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - http://www.data.gov/privacy-policy#data_policy — and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

Banner Photo by @rawpixel from Unplash.

Inspiration

What are the top ten most common types of physicians in Mountain View?

What are the names and phone numbers of dentists in California who studied public health?

Evaluating Health Home Care Quality

CMS Core Set and Health Home SPA Measures

By Health Data New York [source]

About this dataset

This dataset provides comprehensive measures to evaluate the quality of medical services provided to Medicaid beneficiaries by Health Homes, including the Centers for Medicare & Medicaid Services (CMS) Core Set and Health Home State Plan Amendment (SPA). This allows us to gain insight into how well these health homes are performing in terms of delivering high-quality care. Our data sources include the Medicaid Data Mart, QARR Member Level Files, and New York State Delivery System Inform Incentive Program (DSRIP) Data Warehouse. With this data set you can explore essential indicators such as rates for indicators within scope of Core Set Measures, sub domains, domains and measure descriptions; age categories used; denominators of each measure; level of significance for each indicator; and more! By understanding more about Health Home Quality Measures from this resource you can help make informed decisions about evidence based health practices while also promoting better patient outcomes

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset contains measures that evaluate the quality of care delivered by Health Homes for the Centers for Medicare & Medicaid Services (CMS). With this dataset, you can get an overview of how a health home is performing in terms of quality. You can use this data to compare different health homes and their respective service offerings.

The data used to create this dataset was collected from Medicaid Data Mart, QARR Member Level Files, and New York State Delivery System Incentive Program (DSRIP) Data Warehouse sources.

In order to use this dataset effectively, you should start by looking at the columns provided. These include: Measurement Year; Health Home Name; Domain; Sub Domain; Measure Description; Age Category; Denominator; Rate; Level of Significance; Indicator. Each column provides valuable insight into how a particular health home is performing in various measurements of healthcare quality.

When examining this data, it is important to remember that many variables are included in any given measure and that changes may have occurred over time due to varying factors such as population or financial resources available for healthcare delivery. Furthermore, changes in policy may also affect performance over time so it is important to take these things into account when evaluating the performance of any given health home from one year to the next or when comparing different health homes on a specific measure or set of indicators over time

Research Ideas

• Using this dataset, state governments can evaluate the effectiveness of their health home programs by comparing the performance across different domains and subdomains.
• Healthcare providers and organizations can use this data to identify areas for improvement in quality of care provided by health homes and strategies to reduce disparities between individuals receiving care from health homes.
• Researchers can use this dataset to analyze how variations in cultural context, geography, demographics or other factors impact delivery of quality health home services across different locations

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

See the dataset description for more information.

Columns

File: health-home-quality-measures-beginning-2013-1.csv | Column name | Description | |:--------------------------|:----------------------------------------------------| | Measurement Year | The year in which the data was collected. (Integer) | | Health Home Name | The name of the health home. (String) | | Domain | The domain of the measure. (String) | | Sub Domain | The sub domain of the measure. (String) | | Measure Description | A description of the measure. (String) | | Age Category | The age category of the patient. (String) | | Denominator | The denominator of the measure. (Integer) | | Rate | The rate of the measure. (Float) | | Level of Significance | The level of significance of the measure. (String) | | Indicator | The indicator of the measure. (String) |

Acknowledgements

...

This dataset includes the number of people enrolled in DSS services by town and by program from CY 2015-2024. To view the full dataset and filter the data, click the "View Data" button at the top right of the screen. More data on people served by DSS can be found here. About this data For privacy considerations, a count of zero is used for counts less than five. A recipient is counted in all towns where that recipient resided in that year. Due to eligibility policies and operational processes, enrollment can vary slightly after publication. Please be aware of the point-in-time nature of the published data when comparing to other data published or shared by the Department of Social Services, as this data may vary slightly. Notes by year 2021 In March 2020, Connecticut opted to add a new Medicaid coverage group: the COVID-19 Testing Coverage for the Uninsured. Enrollment data on this limited-benefit Medicaid coverage group is being incorporated into Medicaid data effective January 1, 2021. Enrollment data for this coverage group prior to January 1, 2021, was listed under State Funded Medical. An historical accounting of enrollment of the specific coverage group starting in calendar year 2020 will also be published separately. 2018 On April 22, 2019 the methodology for determining HUSKY A Newborn recipients changed, which caused an increase of recipients for that benefit starting in October 2016. We now count recipients recorded in the ImpaCT system as well as in the HIX system for that assistance type, instead using HIX exclusively. Also, the methodology for determining the address of the recipients changed: 1. The address of a recipient in the ImpaCT system is now correctly determined specific to that month instead of using the address of the most recent month. This resulted in some shuffling of the recipients among townships starting in October 2016. If, in a given month, a recipient has benefit records in both the HIX system and in the ImpaCT system, the address of the recipient is now calculated as follows to resolve conflicts: Use the residential address in ImpaCT if it exists, else use the mailing address in ImpaCT if it exists, else use the address in HIX. This resulted in a reduction in counts for most townships starting in March 2017 because a single address is now used instead of two when the systems do not agree. On February 14, 2019 the enrollment counts for 2012-2015 across all programs were updated to account for an error in the data integration process. As a result, the count of the number of people served increased by 13% for 2012, 10% for 2013, 8% for 2014 and 4% for 2015. Counts for 2016, 2017 and 2018 remain unchanged. On January 16, 2019 these counts were revised to count a recipient in all locations that recipient resided in that year. On January 1, 2019 the counts were revised to count a recipient in only one town per year even when the recipient moved within the year. The most recent address is used.

The Medicaid Managed Care Enrollment Report profiles enrollment statistics on Medicaid managed care programs on a plan-specific level. The managed care enrollment statistics include enrollees receiving comprehensive benefits and limited benefits and are point-in-time counts. Because Medicaid beneficiaries may be enrolled concurrently in more than one type of managed care program (e.g., a Comprehensive MCO and a BHO), users should not sum enrollment across all program types, since the total would count individuals more than once and, in some states, exceed the actual number of Medicaid enrollees. Comprehensive MCOs cover acute, primary, and specialty medical care services; they may also cover behavioral health, long-term services and supports, and other benefits in some states. Limited benefit managed care programs, including PCCM, MLTSS only, BHO, Dental, Transportation, and Other cover a narrower set of services. The “Total Medicaid Enrollees” column represents an unduplicated count of all beneficiaries in FFS and any type of managed care, including Medicaid-only and dually eligible individuals receiving full Medicaid benefits or Medicaid cost sharing. "--" indicates states that do not operate programs of a given type. 0 signifies that a state operated a program of this type in 2014, but it ended before July 1, 2014, or began after that date.

This dataset contains counts for Medicaid recipients served by month in Iowa, starting with month ending 1/31/2011.

Eligibility groups are a category of people who meet certain common eligibility requirements. Some Medicaid eligibility groups cover additional services, such as nursing facility care and care received in the home. Others have higher income and resource limits, charge a premium, only pay the Medicare premium or cover only expenses also paid by Medicare, or require the recipient to pay a specific dollar amount of their medical expenses. Eligible Medicaid recipients may be considered medically needy if their medical costs are so high that they use up most of their income. Those considered medically needy are responsible for paying some of their medical expenses. This is called meeting a spend down. Then Medicaid would start to pay for the rest. Think of the spend down like a deductible that people pay as part of a private insurance plan.

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

In order to facilitate public review and access, enrollment data published on the Open Data Portal is provided as promptly as possible after the end of each month or year, as applicable to the data set. Due to eligibility policies and operational processes, enrollment can vary slightly after publication. Please be aware of the point-in-time nature of the published data when comparing to other data published or shared by the Department of Social Services, as this data may vary slightly.

As a general practice, for monthly data sets published on the Open Data Portal, DSS will continue to refresh the monthly enrollment data for three months, after which time it will remain static. For example, when March data is published the data in January and February will be refreshed. When April data is published, February and March data will be refreshed, but January will not change. This allows the Department to account for the most common enrollment variations in published data while also ensuring that data remains as stable as possible over time. In the event of a significant change in enrollment data, the Department may republish reports and will notate such republication dates and reasons accordingly. In March 2020, Connecticut opted to add a new Medicaid coverage group: the COVID-19 Testing Coverage for the Uninsured. Enrollment data on this limited-benefit Medicaid coverage group is being incorporated into Medicaid data effective January 1, 2021. Enrollment data for this coverage group prior to January 1, 2021, was listed under State Funded Medical. Effective January 1, 2021, this coverage group have been separated: (1) the COVID-19 Testing Coverage for the Uninsured is now G06-I and is now listed as a limited benefit plan that rolls up into “Program Name” of Medicaid and “Medical Benefit Plan” of HUSKY Limited Benefit; (2) the emergency medical coverage has been separated into G06-II as a limited benefit plan that rolls up into “Program Name” of Emergency Medical and “Medical Benefit Plan” of Other Medical. An historical accounting of enrollment of the specific coverage group starting in calendar year 2020 will also be published separately. This data represents number of active recipients who received benefits under a program in that calendar year and month. A recipient may have received benefits from multiple programs in the same month; if so that recipient will be included in multiple categories in this dataset (counted more than once.) 2021 is a partial year. For privacy considerations, a count of zero is used for counts less than five. NOTE: On April 22, 2019 the methodology for determining HUSKY A Newborn recipients changed, which caused an increase of recipients for that benefit starting in October 2016. We now count recipients recorded in the ImpaCT system as well as in the HIX system for that assistance type, instead using HIX exclusively. Also, corrections in the ImpaCT system for January and February 2019 caused the addition of around 2000 and 3000 recipients respectively, and the counts for many types of assistance (e.g. SNAP) were adjusted upward for those 2 months. Also, the methodology for determining the address of the recipients changed: 1. The address of a recipient in the ImpaCT system is now correctly determined specific to that month instead of using the address of the most recent month. This resulted in some shuffling of the recipients among townships starting in October 2016. 2. If, in a given month, a recipient has benefit records in both the HIX system and in the ImpaCT system, the address of the recipient is now calculated as follows to resolve conflicts: Use the residential address in ImpaCT if it exists, else use the mailing address in ImpaCT if it exists, else use the address in HIX. This resulted in a reduction in counts for most townships starting in March 2017 because a single address is now used instead of two when the systems do not agree. NOTE: On February 14 2019, the enrollment counts for 2012-2015 across all programs were updated to account for an error in the data integration process. As a result, the count of the number of people served increased by 13% for 2012, 10% for 2013, 8% for 2014 and 4% for 2015. Counts for 2016, 2017 and 2018 remain unchanged. NOTE: On 11/30/2018 the counts were revised because of a change in the way active recipients were counted in one source system.

Data on Medicaid coverage among people under age 65, in the United States, by selected population characteristics. Data from Health, United States. SOURCE: National Center for Health Statistics, National Health Interview Survey. Search, visualize, and download these and other estimates from over 120 health topics with the NCHS Data Query System (DQS), available from: https://www.cdc.gov/nchs/dataquery/index.htm.

Analysis of ‘Managed Care Enrollment Summary’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/730ae026-2760-41fb-b423-6a55a1eb54c3 on 26 January 2022.

--- Dataset description provided by original source is as follows ---

The Medicaid Managed Care Enrollment Report profiles enrollment statistics on Medicaid managed care programs on a plan-specific level. The managed care enrollment statistics include enrollees receiving comprehensive benefits and limited benefits and are point-in-time counts.

1. Total Medicaid Enrollees represents an unduplicated count of all beneficiaries in FFS and any type of managed care, including Medicaid-only and Medicare-Medicaid ("dual") enrollees.
2. Total Medicaid enrollment in Any Type of Managed Care represents an unduplicated count of beneficiaries enrolled in any Medicaid managed care program, including comprehensive MCOs, limited benefit MCOs, and PCCMs.
3. Medicaid Enrollment in Comprehensive Managed Care represents an unduplicated count of Medicaid beneficiaries enrolled in a managed care plan that provides comprehensive benefits (acute, primary care, specialty, and any other), as well as PACE programs. It excludes beneficiaries who are enrolled in a Financial Alignment Initiative Medicare-Medicaid Plan as their only form of managed care.
4. Medicaid Newly Eligible Adults Enrolled in Comprehensive MCOs represents individuals who are enrolled in comprehensive MCOs and are low-income adults, with or without dependent children, newly eligible for Medicaid under ACA Section VIII, and not covered under a waiver or other authority prior to 2014.

--- Original source retains full ownership of the source dataset ---

NCHS has linked data from various surveys with 1999-2013 Medicare program enrollment and health care utilization and expenditure data from the Centers for Medicare & Medicaid Services (CMS). Linkage of the NCHS survey participants with the CMS Medicare data provides the opportunity to study changes in health status, health care utilization and costs, and prescription drug use among Medicare enrollees. Medicare is the federal health insurance program for people who are 65 or older, certain younger people with disabilities, and people with End-Stage Renal Disease.

This dataset includes the number of people enrolled in DSS services by town and by type of assistance (TOA) from CY 2015-2024. To view the full dataset and filter the data, click the "View Data" button at the top right of the screen. More data on people served by DSS can be found here. About this data For privacy considerations, a count of zero is used for counts less than five. A recipient is counted in all towns where that recipient resided in that year. Due to eligibility policies and operational processes, enrollment can vary slightly after publication. Please be aware of the point-in-time nature of the published data when comparing to other data published or shared by the Department of Social Services, as this data may vary slightly. Notes by year 2021 In March 2020, Connecticut opted to add a new Medicaid coverage group: the COVID-19 Testing Coverage for the Uninsured. Enrollment data on this limited-benefit Medicaid coverage group is being incorporated into Medicaid data effective January 1, 2021. Enrollment data for this coverage group prior to January 1, 2021, was listed under State Funded Medical. An historical accounting of enrollment of the specific coverage group starting in calendar year 2020 will also be published separately. 2018 On April 22, 2019 the methodology for determining HUSKY A Newborn recipients changed, which caused an increase of recipients for that benefit starting in October 2016. We now count recipients recorded in the ImpaCT system as well as in the HIX system for that assistance type, instead using HIX exclusively. Also, the methodology for determining the address of the recipients changed: 1. The address of a recipient in the ImpaCT system is now correctly determined specific to that month instead of using the address of the most recent month. This resulted in some shuffling of the recipients among townships starting in October 2016. If, in a given month, a recipient has benefit records in both the HIX system and in the ImpaCT system, the address of the recipient is now calculated as follows to resolve conflicts: Use the residential address in ImpaCT if it exists, else use the mailing address in ImpaCT if it exists, else use the address in HIX. This resulted in a reduction in counts for most townships starting in March 2017 because a single address is now used instead of two when the systems do not agree. On February 14, 2019 the enrollment counts for 2012-2015 across all programs were updated to account for an error in the data integration process. As a result, the count of the number of people served increased by 13% for 2012, 10% for 2013, 8% for 2014 and 4% for 2015. Counts for 2016, 2017 and 2018 remain unchanged. On January 16, 2019 these counts were revised to count a recipient in all locations that recipient resided in that year. On January 1, 2019 the counts were revised to count a recipient in only one town per year even when the recipient moved within the year. The most recent address is used.

This map shows where people have Medicaid or means-tested healthcare coverage in the US (ages under 65). This is shown by State, County, and Census Tract, and uses the most current ACS 5-year estimates.

The Share of Medicaid Enrollees in any Managed Care and in Comprehensive Managed CaAre profiles state-level enrollment statistics (numbers and percentages) of total Medicaid enrollees in any type of managed care as well as those enrolled specifically in comprehensive managed care programs. The report provides managed care enrollment by state with all 50 states, the District of Columbia and the US territories are represented in these data. Note: "n/a" indicates that a state or territory was not able to report data or does not have a managed care program. The “Total Medicaid Enrollees” column represents an unduplicated count of all beneficiaries in FFS and any type of managed care, including Medicaid-only and dually eligible individuals receiving full Medicaid benefits or Medicaid cost sharing. The “Total Medicaid Enrollment in Any Type of Managed Care” column represents an unduplicated count of beneficiaries enrolled in any Medicaid managed care program, including comprehensive MCOs, limited benefit MCOs, PCCMs, and PCCM entities. The “Medicaid Enrollment in Comprehensive Managed Care” column represents an unduplicated count of Medicaid beneficiaries enrolled in a managed care plan that provides comprehensive benefits (acute, primary care, specialty, and any other), as well as PACE programs. It excludes beneficiaries who are enrolled in a Financial Alignment Initiative Medicare-Medicaid Plan as their only form of managed care.

Centers for Medicare & Medicaid Services - Nursing HomesThis feature layer, utilizing data from the Centers for Medicare & Medicaid Services (CMS), displays the locations of nursing homes in the U.S. Nursing homes provide a type of residential care. They are a place of residence for people who require constant nursing care and have significant deficiencies with activities of daily living. Per CMS, "Nursing homes, which include Skilled Nursing Facilities (SNFs) and Nursing Facilities (NFs), are required to be in compliance with Federal requirements to receive payment under the Medicare or Medicaid programs. The Secretary of the United States Department of Health & Human Services has delegated to the CMS and the State Medicaid Agency the authority to impose enforcement remedies against a nursing home that does not meet Federal requirements." This layer includes currently active nursing homes, including number of certified beds, address, and other information.Bridgepoint Sub-Acute and Rehab Capitol HillData downloaded: August 1, 2024Data source: Provider InformationData modification: This dataset includes only those facilities with addresses that were appropriately geocoded.For more information: Nursing homes including rehab servicesFor feedback, please contact: ArcGIScomNationalMaps@esri.comCenters for Medicare & Medicaid ServicesPer USA.gov, "The Centers for Medicare and Medicaid Services (CMS) provides health coverage to more than 100 million people through Medicare, Medicaid, the Children’s Health Insurance Program, and the Health Insurance Marketplace. The CMS seeks to strengthen and modernize the Nation’s health care system, to provide access to high quality care and improved health at lower costs."