The All CMS Data Feeds dataset is an expansive resource offering access to 118 unique report feeds, providing in-depth insights into various aspects of the U.S. healthcare system. With over 25.8 billion rows of data meticulously collected since 2007, this dataset is invaluable for healthcare professionals, analysts, researchers, and businesses seeking to understand and analyze healthcare trends, performance metrics, and demographic shifts over time. The dataset is updated monthly, ensuring that users always have access to the most current and relevant data available.

Dataset Overview:

118 Report Feeds: - The dataset includes a wide array of report feeds, each providing unique insights into different dimensions of healthcare. These topics range from Medicare and Medicaid service metrics, patient demographics, provider information, financial data, and much more. The breadth of information ensures that users can find relevant data for nearly any healthcare-related analysis. - As CMS releases new report feeds, they are automatically added to this dataset, keeping it current and expanding its utility for users.

25.8 Billion Rows of Data:

• With over 25.8 billion rows of data, this dataset provides a comprehensive view of the U.S. healthcare system. This extensive volume of data allows for granular analysis, enabling users to uncover insights that might be missed in smaller datasets. The data is also meticulously cleaned and aligned, ensuring accuracy and ease of use.

Historical Data Since 2007: - The dataset spans from 2007 to the present, offering a rich historical perspective that is essential for tracking long-term trends and changes in healthcare delivery, policy impacts, and patient outcomes. This historical data is particularly valuable for conducting longitudinal studies and evaluating the effects of various healthcare interventions over time.

Monthly Updates:

• To ensure that users have access to the most current information, the dataset is updated monthly. These updates include new reports as well as revisions to existing data, making the dataset a continuously evolving resource that stays relevant and accurate.

Data Sourced from CMS:

• The data in this dataset is sourced directly from the Centers for Medicare & Medicaid Services (CMS). After collection, the data is meticulously cleaned and its attributes are aligned, ensuring consistency, accuracy, and ease of use for any application. Furthermore, any new updates or releases from CMS are automatically integrated into the dataset, keeping it comprehensive and current.

Use Cases:

Market Analysis:

• The dataset is ideal for market analysts who need to understand the dynamics of the healthcare industry. The extensive historical data allows for detailed segmentation and analysis, helping users identify trends, market shifts, and growth opportunities. The comprehensive nature of the data enables users to perform in-depth analyses of specific market segments, making it a valuable tool for strategic decision-making.

Healthcare Research:

• Researchers will find the All CMS Data Feeds dataset to be a robust foundation for academic and commercial research. The historical data, combined with the breadth of coverage across various healthcare metrics, supports rigorous, in-depth analysis. Researchers can explore the effects of healthcare policies, study patient outcomes, analyze provider performance, and more, all within a single, comprehensive dataset.

Performance Tracking:

• Healthcare providers and organizations can use the dataset to track performance metrics over time. By comparing data across different periods, organizations can identify areas for improvement, monitor the effectiveness of initiatives, and ensure compliance with regulatory standards. The dataset provides the detailed, reliable data needed to track and analyze key performance indicators.

Compliance and Regulatory Reporting:

• The dataset is also an essential tool for compliance officers and those involved in regulatory reporting. With detailed data on provider performance, patient outcomes, and healthcare utilization, the dataset helps organizations meet regulatory requirements, prepare for audits, and ensure adherence to best practices. The accuracy and comprehensiveness of the data make it a trusted resource for regulatory compliance.

Data Quality and Reliability:

The All CMS Data Feeds dataset is designed with a strong emphasis on data quality and reliability. Each row of data is meticulously cleaned and aligned, ensuring that it is both accurate and consistent. This attention to detail makes the dataset a trusted resource for high-stakes applications, where data quality is critical.

Integration and Usability:

Ease of Integration:

• The dataset is provided in a CSV format, which is widely compatible with most data analysis tools and platforms. This ensures that users can easily integrate the data into their existing wo...

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

Revalidation disclaimer: The next anticipated revalidation date is an estimated date that may be subject to change based on factors such as a timing lag, updates made to an enrollment file prior to revalidation, and the State’s ability to extend the date for certain providers. Therefore, providers should make sure the correspondence address on their enrollment file is current, and providers should not submit a revalidation package until they receive a notice in the mail to do so. The notice will contain the deadline for submitting the revalidation.

This is a list of active Medicaid fee-for-service (FFS), Managed Care Only and Ordering, Prescribing, Referring, Attending (OPRA) providers. Data elements include the provider’s Medicaid Provider ID, NPI, provider or facility name, Medicaid type, profession or service, provider specialty, service address, city, state, zip code, county, telephone number, latitude, longitude, enrollment begin date, next anticipated revalidation date, date the file was extracted from the data warehouse and a Medically Fragile Children and Adults Directory Indicator.

The CMS Program Statistics - Medicare Providers summary tables provide data on institutional (i.e., hospitals, skilled nursing facilities, home health agencies, hospices, etc.) and non-institutional (i.e., physicians, nonphysicians, specialists, and suppliers) providers. For additional information on enrollment, providers, and Medicare use and payment, visit the CMS Program Statistics page. Below is the list of tables: MDCR PROVIDERS 1. Medicare Providers: Number of Medicare Certified Institutional Providers, Yearly Trend MDCR PROVIDERS 2. Medicare Providers: Number of Medicare Certified Inpatient Hospital and Skilled Nursing Facility Beds and Beds Per 1,000 Enrollees, Yearly Trend MDCR PROVIDERS 3. Medicare Providers: Number of Medicare Certified Facilities, by Type of Control, Yearly Trend MDCR PROVIDERS 4. Medicare Providers: Number of Skilled Nursing Facilities and Medicare Certified Hospitals, and Number of Beds, by State, Territories, Possessions and Other Areas MDCR PROVIDERS 5. Medicare Providers: Number of Medicare Certified Providers, by Type of Provider, by State, Territories, Possessions, and Other Areas MDCR PROVIDERS 6. Medicare Providers: Number of Medicare Non-Institutional Providers by Specialty, Yearly Trend MDCR PROVIDERS 7. Medicare Providers: Number of Medicare Non-Institutional Providers, by State, Territories, Possessions, and Other Areas, Yearly Trend

The Medicare Physician & Other Practitioners by Provider dataset provides information on use, payments, submitted charges and beneficiary demographic and health characteristics organized by National Provider Identifier (NPI).

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?

The Medicare Physician & Other Practitioners by Provider and Service dataset provides information on use, payments, and submitted charges organized by National Provider Identifier (NPI), Healthcare Common Procedure Coding System (HCPCS) code, and place of service.

The Patient-Centered Medical Home (PCMH) is a care delivery model that puts patients as the primary focus of care. It builds better relationships between patients and their primary care teams, which are responsible for managing the full spectrum of healthcare needs. The PCMH program recognizes primary care practices (a provider or a group of providers), that meet standards in the patient-centered care criteria. The table provides a distribution of Medicaid managed care (MMC) members based on the PCMH status of their plan-assigned providers. Member numbers are stratified by MMC plan types and demographics of members.

The Individual Provider Network Data displays information on individuals participating in health plan networks from January through March 2021. Plan network data is collected from Medicaid, Commercial, and Exchange plans on a quarterly basis by the Department of Health, including managed care plans, as well as PPO/EPO plans. For more information, please visit https://pndslookup.health.ny.gov.

This is a random sampling of the 2022 public data set hosted by the Center for Medicare & Medicaid Services at:

https://data.cms.gov/provider-summary-by-type-of-service/medicare-physician-other-practitioners/medicare-physician-other-practitioners-by-provider-and-service

The complete data set for 2022 can be found there. This random sampling has 292,663 rows and 29 columns. The full set hosted at the link above is about 3GB in size with 9,755,427 rows and 29 columns. The 29 columns are:

1. National Provider Identifier (Rndrng_NPI)
2. Last Name/Organization Name of the Provider (Rndrng_Prvdr_Last_Org_Name)
3. First Name of the Provider (Rndrng_Prvdr_First_Name)
4. Middle Initial of the Provider (Rndrng_Prvdr_MI)
5. Credentials of the Provider (Rndrng_Prvdr_Crdntls)
6. Gender of the Provider (Rndrng_Prvdr_Gndr)
7. Entity Type of the Provider (Rndrng_Prvdr_Ent_Cd)
8. Street Address 1 of the Provider (Rndrng_Prvdr_St1)
9. Street Address 2 of the Provider (Rndrng_Prvdr_St2)
10. City of the Provider (Rndrng_Prvdr_City)
11. State Abbreviation of the Provider (Rndrng_Prvdr_State_Abrvtn)
12. State FIPS Code of the Provider (Rndrng_Prvdr_State_FIPS)
13. Zip Code of the Provide (Rndrng_Prvdr_Zip5)
14. RUCA Code of the Provider (Rndrng_Prvdr_RUCA)
15. RUCA Description (Rndrng_Prvdr_RUCA_Desc)
16. Country Code of the Provider (Rndrng_Prvdr_Cntry)
17. Provider Type of the Provider (Rndrng_Prvdr_Type)
18. Medicare Participation Indicator (Rndrng_Prvdr_Mdcr_Prtcptg_Ind)
19. HCPCS Code (HCPCS_Cd)
20. HCPCS Description (HCPCS_Desc)
21. HCPCS Drug Indicator (HCPCS_Drug_Ind)
22. Place of Service (Place_Of_Srvc)
23. Number of Medicare Beneficiaries (Tot_Benes)
24. Number of Services (Tot_Srvcs)
25. Number of Distinct Medicare Beneficiary/Per Day Services (Tot_Bene_Day_Srvcs)
26. Average Submitted Charge Amount (Avg_Sbmtd_Chrg)
27. Average Medicare Allowed Amount (Avg_Mdcr_Alowd_Amt)
28. Average Medicare Payment Amount (Avg_Mdcr_Pymt_Amt)
29. Average Medicare Standardized Payment Amount (Avg_Mdcr_Stdzd_Amt)

A brief description of each these columns can be found here:

https://data.cms.gov/resources/medicare-physician-other-practitioners-by-provider-and-service-data-dictionary

A full description of the data is in the 27-page document, "Medicare Fee-For-Service Provider Utilization & Payment Data Physician and Other Supplier Public Use File: A Methodological Overview" which can be found here:

www.cms.gov/research-statistics-data-and-systems/statistics-trends-and-reports/medicare-provider-charge-data/downloads/medicare-physician-and-other-supplier-puf-methodology.pdf

This data set is similar to the one posted by Tamil Selvan here https://www.kaggle.com/datasets/tamilsel/healthcare-providers-data. That data's origin is unclear, however it is very likely from same source. It has different header text and may be from one of the earlier years.

A list of hospice providers with data on the quality of patient care measures.

Corrected and updated version. Contains full records/datasets available through the CMS Open Data API, including: CMS Innovation Center Programs COVID-19 Resources Medicare Current Beneficiary Survey (MCBS) Medicare Shared Saving Program Medicare Value-Based Payment Modifier Program Provider Characteristics Provider Compliance Provider Summary By Type of Service Quality of Care Summary Statistics on Beneficiary Enrollment Summary Statistics on Provider Enrollment Summary Statistics on Use and Payments About: This site gives you direct access to public data released by the Centers for Medicare & Medicaid Services (CMS). Our goal is to make our data readily available in open, accessible, and machine-readable formats. For most available data, you can: Download data in a variety of formats. View and analyze data using interactive tools. Access data through an Application Programming Interface, or API. An API lets developers connect other applications to data in real time. The Centers

Our objective is to ensure that providers who bill Federal health care programs do not submit claims for services furnished, ordered or prescribed by an excluded individual or entity. The LEIE is updated monthly with all individuals and entities who have been excluded from participation in Federal health care programs. Providers who bill Medicare, Medicaid, or other Federal health care programs must ensure that they know what individuals or entities are excluded and not bill for their services (e.g., a pharmacy should not bill Medicaid for a drug prescribed by an excluded physician nor for drugs dispensed by an excluded pharmacist).

The dataset provides basic information of the FFS providers enrolled in the Medi-Cal program as of February 2, 2026. The data was retrieved from the Provider Master File (PMF), which has been used in the claims payment process and maintained by the Provider Enrollment Division (PED). The Variables in the dataset include provider number, name, type, specialty, geographic information, etc. This dataset does not include the Managed Care providers.

Datasets show Medicaid claims segmented by various demographic, geographic, provider, and diagnostic factors.

The CMS Program Statistics - Medicare Physician, Non-Physician Practitioner and Supplier tables provide use and payment data for physicians, other practitioners, limited-licensed practitioners, and durable medical equipment, prosthetic, and orthotic (DMEPOS) suppliers. For additional information on enrollment, providers, and Medicare use and payment, visit the CMS Program Statistics page. Below is the list of tables: MDCR PHYSSUPP 1. Medicare Physicians, Non-Physician Practitioners, and Suppliers: Utilization, Program Payments, Cost Sharing, and Balance Billing for Original Medicare Beneficiaries, by Type of Entitlement, Yearly Trend MDCR PHYSSUPP 2. Medicare Physicians, Non-Physician Practitioners, and Suppliers: Utilization, Program Payments, Cost Sharing, and Balance Billing for Original Medicare Beneficiaries, by Demographic Characteristics and Medicare-Medicaid Enrollment Status MDCR PHYSSUPP 3. Medicare Physicians, Non-Physician Practitioners, and Suppliers: Utilization, Program Payments, Cost Sharing, and Balance Billing for Original Medicare Beneficiaries, by Area of Residence MDCR PHYSSUPP 4. Medicare Physicians, Non-Physician Practitioners, and Suppliers: Utilization, Program Payments, and Balance Billing for Original Medicare Beneficiaries, by Type of Service MDCR PHYSSUPP 5. Medicare Physicians, Non-Physician Practitioners, and Suppliers: Utilization, Program Payments, and Balance Billing for Original Medicare Beneficiaries, by Place of Service MDCR PHYSSUPP 6. Medicare Physicians, Non-Physician Practitioners, and Suppliers: Utilization, Program Payments, and Balance Billing for Original Medicare Beneficiaries, by Physician Specialty MDCR PHYSSUPP 7. Medicare Physicians, Non-Physician Practitioners, and Suppliers: Utilization and Program Payments for Original Medicare Beneficiaries, by Berenson-Eggers Type of Service (BETOS) Classification

The CMS EHR Incentive Programs provide incentives to eligible office-based providers and hospitals to adopt electronic health records. Both the Medicare and Medicaid programs have separate criteria and eligible participants. These measures track the percentage of physicians, nurse practitioners, physician assistants, short-term general, Critical Access, and Children's hospitals that have demonstrated meaningul use of certified electronic health record technology and/or adopted, implemented, or ugraded any electronic health record. These measures track the rate of adoption and use of EHR technology certified by HHS in addition to adoption of other non-certified EHR technology. These measures are cumulative, representing the most recent data.

The Medicare Fee-For-Service Public Provider Enrollment dataset includes information on providers who are actively approved to bill Medicare or have completed the 855O at the time the data was pulled from the Provider Enrollment, Chain, and Ownership System (PECOS). The release of this provider enrollment data is not related to other provider information releases such as Physician Compare or Data Transparency. Note: This full dataset contains more records than most spreadsheet programs can handle, which will result in an incomplete load of data. Use of a database or statistical software is required.Resources for Using and Understanding the DataThese files are populated from PECOS and contain basic enrollment and provider information, reassignment of benefits information and practice location city, state and zip. These files are not intended to be used as real time reporting as the data changes from day to day and the files are updated only on a quarterly basis. If any information on these files needs to be updated, the provider needs to contact their respective Medicare Administrative Contractor (MAC) to have that information updated. This data does not include information on opt-out providers. Information is redacted where necessary to protect Medicare provider privacy.

The Institutional Provider Network Data displays information on health facilities and ancillary service providers (for example: hospitals, labs, home care agencies) participating in health plan networks from January through March 2021. Plan network data is collected from Medicaid, Commercial, and Exchange plans on a quarterly basis by NYSoH, including managed care plans, as well as PPO/EPO plans. For more information, please visit: https://pndslookup.health.ny.gov.

Content

This file is a point in time snapshot of enrollment level data for providers actively enrolled in Medicare.

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 Annie Spratt on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

This dataset is distributed under NA