The CMS Program Statistics - Medicare Total Enrollment tables provide data on characteristics of the Medicare-covered populations. For additional information on enrollment, providers, and Medicare use and payment, visit the CMS Program Statistics page. These data do not exist in a machine-readable format, so the view data and API options are not available. Please use the download function to access the data. Below is the list of tables: MDCR ENROLL AB 1. Total Medicare Enrollment: Total, Original Medicare, and Medicare Advantage and Other Health Plan Enrollment, Yearly Trend MDCR ENROLL AB 2. Total Medicare Enrollment: Total, Original Medicare, Medicare Advantage and Other Health Plan Enrollment, and Resident Population, by Area of Residence MDCR ENROLL AB 3. Total Medicare Enrollment: Part A and/or Part B Total, Aged, and Disabled Enrollees, Yearly Trend MDCR ENROLL AB 4. Total Medicare Enrollment: Part A and/or Part B Enrollees, by Age Group, Yearly Trend MDCR ENROLL AB 5. Total Medicare Enrollment: Part A and/or Part B Enrollees, by Demographic Characteristics MDCR ENROLL AB 6. Total Medicare Enrollment: Part A and/or Part B Enrollees, by Type of Entitlement and Demographic Characteristics MDCR ENROLL AB 7. Total Medicare Enrollment: Part A and/or Part B Total, Aged, and Disabled Enrollees, by Area of Residence MDCR ENROLL AB 8. Total Medicare Enrollment: Part A and/or Part B Enrollees, by Type of Entitlement and Area of Residence

This data set accompanies the Profile of the California Medicare Population chartbook, published by the Office of Medicare Innovation and Integration in February 2022, and available at (https://www.dhcs.ca.gov/services/Documents/OMII-Medicare-Databook-February-18-2022.pdf). The three data files in this data set were analyzed from federal administrative data (the Medicare Master Beneficiary Summary File) for beneficiary characteristics as of March 2021. These datasets include: Medicare enrollment, Medicare Advantage enrollment (and its converse fee-for-service Medicare enrollment), dual Medi-Cal eligibility and enrollment (and its converse Medicare-only enrollment), by county. Medicare Savings Program enrollees were considered Medicare-only and not dually enrolled in Medi-Cal. All Medicare Part C beneficiaries, including PACE, Cal MediConnect and Special Needs Plans, were considered to have Medicare Advantage.

DHCS partnered with The SCAN Foundation and ATI Advisory in 2021 and 2022 to develop a series of chartbooks that provide information about Medicare beneficiaries in California. This work is supported by a grant from The SCAN Foundation to advance a coordinated and easily navigated system of high-quality services for older adults that preserve dignity and independence. For more information, visit www.TheSCANFoundation.org.

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

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.

NCHS has linked data from various surveys with 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.

Content

This crosswalk links the types of providers and suppliers who are eligible to apply for enrollment in the Medicare program with the appropriate Healthcare Provider Taxonomy Codes. This crosswalk includes the Medicare Specialty Codes for those provider/supplier types who have Medicare Specialty Codes. The Healthcare Provider Taxonomy Code Set is available from the Washington Publishing Company (www.wpc-edi.com) and is maintained by the National Uniform Claim Committee (www.nucc.org). The code set is updated twice a year, with the updates being effective April 1 and October 1 of each year. This document reflects Healthcare Provider Taxonomy Codes effective for use on April 2, 2018.

When changes are made to Medicare provider enrollment requirements, the Medicare Specialty Codes, or the Healthcare Provider Taxonomy Code Set, this document may need to be revised.

NOTE: This document does not alter existing Medicare claims preparation, processing, or payment instructions, nor does it alter existing Medicare provider enrollment requirements or policies.

Context

This is a dataset hosted by the Centers for Medicare & Medicaid Services (CMS). The organization has an open data platform found here and they update their information according the amount of data that is brought in. Explore CMS's Data using Kaggle and all of the data sources available through the CMS organization page!

• Update Frequency: This dataset is updated daily.

Acknowledgements

This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by Markus Spiske on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

This dataset is distributed under NA

The datasets include the monthly count of individuals who are enrolled in Medicare Savings Programs (MSP), by aid code and county. The counts reflect the total number of eligible individuals enrolled during the month. MSP help individuals with limited income and resources pay for some of the out-of-pocket costs for Medicare, including Medicare Part A and Part B premiums, deductibles, copayments, and coinsurance. There are four Medicare Savings Programs: Qualified Medicare Beneficiary (QMB), Specified Low Income Medicare Beneficiary (SLMB), Qualifying Individual (QI), and Qualified Working Disabled Individual (QWDI). Individuals who are eligible for QMB, SLMB, and QI also automatically qualify for the Low Income Subsidy (or “Extra Help”) program, which helps lower the cost of prescription drugs. Counties and aid codes with zero individuals enrolled during a reporting period are not included in the dataset.

Verify the accuracy of SSNs of all individual Medicare providers, owners, managing/directing employees, authorized representatives, ambulance service medical directors, ambulance crew members, technicians, chain organization administrators, Independent Diagnostic Test Facility (IDTF), supervising/directing physicians, and IDTF interpretation service providers. Also included in this Agreement are individual health care providers who apply for a National Provider Identification Number (NPI).

This series of files links two large population-based sources providing detailed data about Medicare beneficiaries with cancer. The SEER (Surveillance, Epidemiology, and End Results) program consists of clinical, demographic, and cause of death information collected from tumor registries beginning in January 1, 1973. The Medicare contribution includes all claims for covered health care services from beneficiaries’ time of eligibility until death. Linkage is processed biennially by SEER and Centers for Medicare and Medicaid Services (CMS) staff. 95% of individuals age 65 and older are included in the SEER files. Due to privacy concerns, access to this database requires an application, SEER-Medicare Data Use Agreement (DUA), and documentation of institutional review board approval. Additionally, the National Cancer Institute’s information technology contractor assesses a processing fee the amount of which is dependent upon the type and number of files requested.

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?

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

2014-2019. This dataset is a de-identified summary table of vision and eye health data indicators from Medicare claims, stratified by all available combinations of age group, race/ethnicity, sex, and state. Medicare claims for VEHSS includes beneficiaries who were fully enrolled in Medicare Part B Fee-for-Service (FFS) for the duration of the year. Medicare claims provide a convenience sample that includes approximately 30 million individuals annually, which represents nearly 89% of the US population aged 65 and older and 3.3% of the US population younger than 65, including persons disabled due to blindness. Medicare data for VEHSS include Service Utilization and Medical Diagnoses indicators. Data were suppressed for de-identification to ensure protection of patient privacy. Data will be updated as it becomes available. Detailed information on VEHSS Medicare analyses can be found on the VEHSS Medicare webpage (cdc.gov/visionhealth/vehss/data/claims/medicare.html). Information on available Medicare claims data can be found on the ResDac website (www.resdac.org). The VEHSS Medicare dataset was last updated May 2023.

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.”

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 tracks the updates made on the dataset "Eligible Individuals Enrolled in Medicare Savings Programs (MSP)" as a repository for previous versions of the data and metadata.

Content

The hospital readmission rate PUF presents nation-wide information about inpatient hospital stays that occurred within 30 days of a previous inpatient hospital stay (readmissions) for Medicare fee-for-service beneficiaries. The readmission rate equals the number of inpatient hospital stays classified as readmissions divided by the number of index stays for a given month. Index stays include all inpatient hospital stays except those where the primary diagnosis was cancer treatment or rehabilitation. Readmissions include stays where a beneficiary was admitted as an inpatient within 30 days of the discharge date following a previous index stay, except cases where a stay is considered always planned or potentially planned. Planned readmissions include admissions for organ transplant surgery, maintenance chemotherapy/immunotherapy, and rehabilitation.

This dataset has several limitations. Readmissions rates are unadjusted for age, health status or other factors. In addition, this dataset reports data for some months where claims are not yet final. Data published for the most recent six months is preliminary and subject to change. Final data will be published as they become available, although the difference between preliminary and final readmission rates for a given month is likely to be less than 0.1 percentage point.

Data Source: The primary data source for these data is the CMS Chronic Condition Data Warehouse (CCW), a database with 100% of Medicare enrollment and fee-for-service claims data. For complete information regarding data in the CCW, visit http://ccwdata.org/index.php. Study Population: Medicare fee-for-service beneficiaries with inpatient hospital stays.

Context

This is a dataset hosted by the Centers for Medicare & Medicaid Services (CMS). The organization has an open data platform found here and they update their information according the amount of data that is brought in. Explore CMS's Data using Kaggle and all of the data sources available through the CMS organization page!

• Update Frequency: This dataset is updated daily.

Acknowledgements

This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by Justyn Warner on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

This dataset is distributed under NA

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

The MBSF mortality denominator can be used to study mortality rates of the elder population in the US. Access to CMS data is restricted. Processed datasets cannot be shared. Contact the authors if you've purchased CMS data through RESDAC and would like to use our data processing pipelines to clean CMS raw data and generate the MBSF mortality denominator. Medicare Overview In the United States, when individuals reach the age of 65, they become eligible for the Medicare federal health insurance program. Medicare also covers individuals under 65 if they have certain disabilities or End-Stage Renal Disease (ESRD) or Amyotrophic Lateral Sclerosis (ALS). About CMS The Center for Medicare & Medicaid Services (CMS) is the federal agency responsible for managing the Medicare and Medicaid data. CMS makes predefined datasets available for purchase to researchers after they enter a Data usage agreement through Research Data Assistance Center (ResDAC). Master Beneficiary Summary File (MBSF) A beneficiary-level data from CMS/ResDAC is known as the Master Beneficiary Summary File (MBSF). The raw MBSF data contains basic demographic information of individuals, an indicator of death, and some details on their medicare enrollment. Mortality Denominator We refer to the mortality denominator as the clean subset of MBSF health data that is representative of the older population. The subset consists of the US elder population; notably, individuals under 64 who qualified because of a disability are excluded.

The Medicare Telehealth Trends dataset provides information about people with Medicare who used telehealth services between January 1, 2020 and June 30, 2024. The data were used to generate the Medicare Telehealth Trends Report.

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. 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. 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. 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), or PACE program. It excludes beneficiaries who are enrolled in a Financial Alignment Demonstration Medicare-Medicaid Plan as their only form of managed care. The “Medicaid Enrollment in Comprehensive MCOs Under ACA Section VIII Expansion” column is a subset of the total reported in column C and includes individuals who are enrolled in comprehensive MCOs and are low-income adults, with or without dependent children, eligible for Medicaid under ACA Section VIII. n/a" indicates that a state or territory was either not able to report data or does not operate a managed care program.