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

The POS file contains data on characteristics of hospitals and other types of healthcare facilities, including the name and address of the facility and the type of Medicare services the facility provides, among other information. The data are collected through the Centers for Medicare and Medicaid Services (CMS) Regional Offices. The file contains an individual record for each Medicare-approved provider and is updated quarterly. The data is an invaluable resource to a variety of stakeholders, including researchers and application developers.

The dataset contains the data on characteristics of hospitals and other types of healthcare facilities, including the name and address of the facility and the type of Medicare services the facility provides, among other information. The dataset includes provider number, name, and address and characterizes the participating institutional providers.

Please be advised that as of Q4 2023 there is a new Provider of Service file (POS) that contains the provider and certification details for Home Health Agencies (HHAs), Hospices, and Ambulatory Surgical Centers (ASCs). Data contained in this file are extracted from the Internet Quality Improvement and Evaluation System (iQIES) environment and will be updated quarterly along with the other two POS files.

The Provider of Services File - Hospital & Non-Hospital Facilities data provide critical resources for other federal regulator requirements as well as supports the ongoing quality & research efforts sponsored by CMS. In this file you will find provider certification, termination, accreditation, ownership, name, location and other characteristics organized by CMS Certification Number.

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 dataset provides information on use, payments, submitted charges and beneficiary demographic and health characteristics organized by National Provider Identifier (NPI).

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.

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 Provider of Services (POS) Clinical Laboratories (CLIA) data provides information on CLIA demographics and types of testing services the facility provides. In this file you will find provider number, name, address and characteristics of the participating institution providers.

The Provider of Services File (POS) - Internet Quality Improvement and Evaluation System (iQIES) - Home Health Agency (HHA), Ambulatory Surgical Center (ASC), and Hospice Providers data provides information on provider demographic and associated certification information. In this file you will find provider number (CMS Certification Number), name, address, and other characteristics of the participating institution providers.

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

Moratoria Provider Services and Utilization dataset provides information on the number of Medicare providers servicing a geographic region and the number of Medicare beneficiaries who use a health service area. The dataset can also be used to reveal the degree to which use of a service is related to the number of providers servicing a geographic region as well as to determine which geographic and health service areas might be considered for a moratorium on new providers.

The dataset contains information on ‘Provider Utilization and Payment Data Physician and Other Supplier Public Use File (PUF)’ prepared by the Centers for Medicare & Medicaid Services (CMS) and organized by National Provider Identifier (NPI), Healthcare Common Procedure Coding System code, and place of service. This PUF is based on information from CMS’s National Claims History (NCH) Standard Analytic Files (SAFs).

This public dataset was created by the Centers for Medicare & Medicaid Services. The data summarizes the utilization and payments for procedures, services, and prescription drugs provided to Medicare beneficiaries by specific inpatient and outpatient hospitals. The dataset includes the following data - common inpatient and outpatient services from 2012 to 2015.

Providers determine what they will charge for items, services, and procedures provided to patients and these charges are the amount that providers bill for an item, service, or procedure.

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.

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.

This data package shows information on Medicare enrollment level data for providers organized at the individual level, Phase III target list which revalidates all remaining providers, a list of due dates by which the provider/supplier's revalidation application must reach their MAC (Medicare Administrative Contractor) and the number of Medicare beneficiaries who use a health service area and a list of all providers and suppliers who have been mailed a revalidation notice.

This dataset shows the list of Essential Community Providers (ECPs) that provide dental services enrolled in the Centers for Medicare and Medicaid Services (CMS).

Abstract

This is a Medicare dataset released by the Center for Medicare and Medicaid Services (CMS) and accessed via BigQuery. All data is from 2014.

Documentation

For more information regarding the CMS data, click here.

From BigQuery:

This public dataset was created by the Centers for Medicare & Medicaid Services. The data summarizes the utilization and payments for procedures, services, and prescription drugs provided to Medicare beneficiaries by specific inpatient and outpatient hospitals, physicians, and other suppliers. The dataset includes the following data - common inpatient and outpatient services, all physician and other supplier procedures and services, and all Part D prescriptions.

Providers determine what they will charge for items, services, and procedures provided to patients and these charges are the amount that providers bill for an item, service, or procedure.

The Home Health Agency PUF contains information on utilization, payment (Medicare payment and standard payment), and submitted charges organized by CMS Certification Number (6-digit provider identification number), Home Health Resource Group (HHRG), and state of service. This PUF is based on information from CMSs Chronic Conditions Data Warehouse (CCW) data files. The data in the Home Health Agency PUF covers calendar year 2013 and contains 100 percent final-action (i.e., all claim adjustments have been resolved) home health agency institutional claims for the Medicare fee-for-service (FFS) population.

This statistic shows the ranking of the global top 10 health care equipment and services companies based on revenue, as of March 21, 2025. U.S. health care equipment and service company Centene was ranked fourth, with a total revenue of some 150 billion U.S. dollars.