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.

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

This dataset tracks the updates made on the dataset "Provider of Services File - Internet Quality Improvement and Evaluation System - Home Health Agency, Ambulatory Surgical Center, and Hospice Providers" as a repository for previous versions of the data and metadata.

This dataset tracks the updates made on the dataset "Provider of Services File - Hospital & Non-Hospital Facilities" as a repository for previous versions of the data and metadata.

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.

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

See the Splitgraph documentation for more information.

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

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 dataset tracks the updates made on the dataset "Provider of Services File - CLIA - March 2013" as a repository for previous versions of the data and metadata.

This dataset tracks the updates made on the dataset "Provider of Services File - OTHER - March 2015" as a repository for previous versions of the data and metadata.

This dataset tracks the updates made on the dataset "Provider of Services File - CLIA - June 2020" as a repository for previous versions of the data and metadata.

The dataset provides basic information of the FFS providers enrolled in the Medi-Cal program as of September 1, 2025. 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.

The Medicare Provider Analysis and Review (MEDPAR) File contains data from claims for services provided to beneficiaries admitted to Medicare certified inpatient hospitals and skilled nursing facilities (SNF). The accumulation of claims from a beneficiarys date of admission to an inpatient hospital, where the beneficiary has been discharged, or to a skilled nursing facility, where the beneficiary may still be a patient, represents one stay. A stay record may represent one claim or multiple claims.

The Hospice Utilization and Payment Public Use File provides information on services provided to Medicare beneficiaries by hospice providers. The Hospice PUF contains information on utilization, payment (Medicare payment and standard payment), submitted charges, primary diagnoses, sites of service, and hospice beneficiary demographics organized by CMS Certification Number 6-digit provider identification number, and state. This PUF is based on information from CMSs Chronic Conditions Data Warehouse (CCW) data files. The data in the Hospice PUF covers calendar year 2014 and contains 100 percent final-action i.e., all claim adjustments have been resolved, hospice claims for the Medicare population including beneficiaries enrolled in a Medicare Advantage plan.
Although the Hospice PUF has a wealth of payment and utilization information about hospice services, the data set also has a number of limitations. The information presented in this file does not indicate the quality of care provided by individual hospice providers. The file only contains cost and utilization information. Additionally, the data are not risk adjusted and thus do not account for differences in patient populations. For additional limitations, please review the methodology document available below.

The Centers for Medicare and Medicaid Services (CMS) has condensed all 56 Physician Fee Schedule (PFS) carrier specific pricing files into one zip file. It is labeled as All States in the State field, and 2009 in the Calendar Year field. Because the list is ordered by State name, All States appears after the Alaska files. If you sort by most recent Calendar Year, the file will appear at the top of the list.

CMS has released a series of publicly available data files that summarize the utilization and payments for procedures, services, and prescription drugs provided to Medicare beneficiaries by specific inpatient and outpatient hospitals, physicians, and other suppliers. These Medicare Provider Utilization and Payment Data files include information for 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 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).