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

These datasets contain aggregated responses from the HCAI Health Workforce License Renewal Survey for Physician and Surgeon and Osteopathic Physician and Surgeon licensees. The data are limited to physicians whose license was in an Active Status and who indicated they were actively working in a position that required their license as of April 3, 2025.

The license renewal survey utilizes a cell-based weighting methodology to estimate the total count of licensed individuals and accounts for individuals that decline to provide a response or who have not yet taken the survey. The presented estimated counts were calculated by multiplying county level weighted percentages for each metric by the total count of active licenses within each county. If no physicians within a given specialty and county provided a response to the activity hours question, the statewide mode for that specialty was used.

Note: Previous versions of this dataset utilized raw counts rather than a cell-based weighting approach and did not take into account whether physicians were actively working in their field.

In addition, the previous version of this dataset (as of April 3, 2024) contained errors regarding the total number of “Unsurveyed” individuals within each county. For more information regarding this issue, please contact the Workforce Data team using the email address below.

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 contains the Physician Quality Reporting System (PQRS), Performance Rates for Individual Eligible Professionals (EP) PQRS, Consumer Assessment of Healthcare Providers and Systems (CAHPS) and Group Practice.

The Physician and Other Supplier Public Use File (Physician and Other Supplier PUF) provides information on services and procedures provided to Medicare beneficiaries by physicians and other healthcare professionals. The Physician and Other Supplier PUF contains information on utilization, payment (allowed amount and Medicare payment), and submitted charges organized by National Provider Identifier (NPI), Healthcare Common Procedure Coding System (HCPCS) code, and place of service. This PUF is based on information from CMS administrative claims data for Medicare beneficiaries enrolled in the fee-for-service program. The data in the Physician and Other Supplier PUF covers calendar years 2012 through 2016 and contains 100 percent final-action physician-supplier Part B non-institutional line items for the Medicare fee-for-service population.

The Physician and Physician Practice Research Database (3P-RD) captures characteristics of physicians and physician practices in 13 states. The database describes the supply of physician services available across selected states for data year 2019-2020.

This data package contains health indicator information about the total Medicare costs for Medicare fee-for-service beneficiaries and Locality County Crosswalk for 2017 and 2018. It also shows the Physician Fee Schedule National Payment amount and relative value units.

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

The Physician/Supplier Procedure Summary (PSPS) data provides a summary of calendar year Medicare Part B carrier and durable medical equipment fee-for-service (FFS) claims. The file is organized by carrier, pricing locality, Healthcare Common Procedure Coding System (HCPCS) code, HCPCS modifier, provider specialty, type of service, and place of service. The summarized fields are total submitted services and charges, total allowed services and charges, total denied services and charges, and total payment amounts. This dataset is produced annually and is typically available in July (i.e., data for CY2015 is usually available in July 2016). 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 dataset contains aggregated responses to the Physician Survey incorporated into the license renewal process. The dataset is limited to physicians whose license was in “current” status on a specified date.

Physician Compare, which meets Affordable Care Act of 2010 requirements, helps you search for and select physicians and other healthcare professionals enrolled in the Medicare program.

"Facilitate marketing campaigns with the healthcare email list from Infotanks Media that includes doctors, healthcare professionals, NPI numbers, physician specialties, and more. Buy targeted email lists of healthcare professionals and connect with doctors, specialists, and other healthcare professionals to promote your products and services. Hyper personalize campaigns to increase engagement for better chances of conversion. Reach out to our data experts today! Access 1.2 million physician contact database with 150+ specialities including chiropractors, cardiologists, psychiatrists, and radiologists among others. Get ready to integrate healthcare email lists from Infotanks Media to start email marketing campaigns through any CRM and ESP. Contact us right now! Ensure guaranteed lead generation with segmented email marketing strategies for specialists, departments, and more. Make the best use of target marketing to progress and move closer to your business goals with email listing services for healthcare professionals. Infotanks Media provides 100% verified healthcare email lists with the highest email deliverability guarantee of 95%. Get a custom quote today as per your requirements. Enhance your marketing campaigns with healthcare email lists from 170+ countries to build your global outreach. Request your free sample today! Personalize your business communication and interactions to maximize conversion rates with high quality contact data. Grow your business network in your target markets from anywhere in the world with a guaranteed 95% contact accuracy of the healthcare email lists from Infotanks Media. Contact data experts at Infotanks Media from the healthcare industry to get a quick sample for free. Write to us or call today!

Hyper target within and outside your desired markets with GDPR and CAN-SPAM compliant healthcare email lists that get integrated into your CRM and ESPs. Balance out the sales and marketing efforts by aligning goals using email lists from the healthcare industry. Build strong business relationships with potential clients through personalized campaigns. Call Infotanks Media for a free consultation. Explore new geographies and target markets with a focused approach using healthcare email lists. Align your sales teams and marketing teams through personalized email marketing campaigns to ensure they accomplish business goals together. Add value and grow revenue to take your business to the next level of success. Double up your business and revenue growth with email lists of healthcare professionals. Send segmented campaigns to monitor behaviors and understand the purchasing habits of your potential clients. Send follow up nurturing email marketing campaigns to attract your potential clients to become converted customers. Close deals sooner with detailed information of your prospects using the healthcare email list from Infotanks Media. Reach healthcare professionals on their preferred platform of communication with the email list of healthcare professionals. Identify, capture, explore, and grow in your target markets anywhere in the world with a fully verified, validated, and compliant email database of healthcare professionals. Move beyond the traditional approach and automate sales cycles with buying triggers sent through email marketing campaigns. Use the healthcare email list from Infotanks Media to engage with your targeted potential clients and get them to respond. Increase email marketing campaign response rate to convert better! Reach out to Infotanks Media to customize your healthcare email lists. Call today!"

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

Sometimes, doctors and hospitals have financial relationships with health care manufacturing companies. These relationships can include money for research activities, gifts, speaking fees, meals, or travel. The Social Security Act requires CMS to collect information from applicable manufacturers and group purchasing organizations (GPOs) in order to report information about their financial relationships with physicians and hospitals. Open Payments is the federally run program that collects the information about these financial relationships and makes it available to you from the Opendata.utah.gov portal.

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

Want to reach physician preference items (PPIs) list but meeting with continuous spam, return mail or email bounces?

Worry not.

Span Global Services’ 100% permission-based global physician email lists, guarantee a sure zoom in your email open rates and click-through rates. We empower global marketing strategies with our geo-targeted US, UK, Canada, Europe, Australia, and other countries physician-targeting comprehensive email database.

Why our Physicians Email Lists? • We not only provide you the physician’s name and email address but in-depth insightful data filters like specialty, years of experience, license information, country, state; SIC code, mailing address, phone number, hospital affiliation, etc. Hence, you can customize your hyper-targeted physician campaign as per your business requirements. • Span Global Services’ physician data counts are 100% permission-based and have whopping deliverability rates that guarantee your every email campaign, responsive success. • Our A-Z Specialty-wise physician data banks are ethically-sourced from legitimate sources like yellow pages, business card, healthcare websites, magazines and journals, government listings, etc. and are super-affordable. • Span Global Services’ physician’s email list is CAN-SPAM Act compliant and also adheres to 15+ global regulations.

Have a healthcare offer or deal, that a physician may find too good to pass?

Launch your worldwide marketing campaigns with our new data zest, keep the email marketing, direct marketing and telemarketing pouring for a continuous global sales pipeline, that only super-converts.

We are a stickler for data cleanliness. Span Global Services’ ‘Email Appending’ Services seeks to continuously update and upgrade your existent contact data from duplicate, incorrect, outdated and redundant physician contacts to highly-responsive ones. This retention of data quality helps your product message reach top physician decision-makers, boost sales and maximize ROIs, a 100% every time.

With such a lucrative data offer at hand, we strongly recommend you race ahead with our physician email lists or opt-for an existent physician data health check-up. How about a get set go?

This dataset tracks the updates made on the dataset "Physician Survey – Licensee Responses by Address of Record ZIP Code" as a repository for previous versions of the data and metadata.

Physicians (per 1,000 people) in Mexico was reported at 2.559 in 2021, according to the World Bank collection of development indicators, compiled from officially recognized sources. Mexico - Physicians - actual values, historical data, forecasts and projections were sourced from the World Bank on August of 2025.

The Unique Physician Identification Number (UPIN) Directory contains selected information on physicians, doctors of Osteopathy, limited licensed practitioners and some non-physician practitioners who are enrolled in the Medicare Program.

The data elements in the file (UPIN, full name, specialty, Physician License State Code, zip code, Medicare provider billing number and State) are extracted from the UPIN Database and are approved for public release in the Centers for Medicare and Medicaid Services (CMS) System of Records.