ONC uses the SK&A Office-based Provider Database to calculate the counts of medical doctors, doctors of osteopathy, nurse practitioners, and physician assistants at the state and count level from 2011 through 2013. These counts are grouped as a total, as well as segmented by each provider type and separately as counts of primary care providers.

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.

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

Variability in mean payment per physician, number of physicians, and aggregated payments for transactions in the Open Payments database, 2014–2018, for each top-category specialty available for allopathic and osteopathic physicians.

affordable

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.

Open Payments (otherwise known as the Sunshine Act) - Open Payments is a Congressionally-mandated transparency program that increases awareness of financial relationships between the health care industry and physicians by collecting and reporting any payments or transfers of value medical manufacturers make to physicians or teaching hospitals.

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 table provides a statistics on Distribution of Physician Payments by Program and Specialty under the Alberta Health Care Insurance Plan (AHCIP). This table is an Excel version of a table in the “Alberta Health Care Insurance Plan Statistical Supplement” report published annually by Alberta 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

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.

Comprehensive database of physician contact information across all medical specialties in the United States

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

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

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.

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.

The Nuclear Medicine National HQ System database is a series of MS Excel spreadsheets and Access Database Tables by fiscal year. They consist of information from all Veterans Affairs Medical Centers (VAMCs) performing or contracting nuclear medicine services in Veterans Affairs medical facilities. The medical centers are required to complete questionnaires annually (RCS 10-0010-Nuclear Medicine Service Annual Report). The information is then manually entered into the Access Tables, which includes: * Distribution and cost of in-house VA - Contract Physician Services, whether contracted services are made via sharing agreement (with another VA medical facility or other government medical providers) or with private providers. * Workload data for the performance and/or purchase of PET/CT studies. * Organizational structure of services. * Updated changes in key imaging service personnel (chiefs, chief technicians, radiation safety officers). * Workload data on the number and type of studies (scans) performed, including Medicare Relative Value Units (RVUs), also referred to as Weighted Work Units (WWUs). WWUs are a workload measure calculated as the product of a study's Current Procedural Terminology (CPT) code, which consists of total work costs (the cost of physician medical expertise and time), and total practice costs (the costs of running a practice, such as equipment, supplies, salaries, utilities etc). Medicare combines WWUs together with one other parameter to derive RVUs, a workload measure widely used in the health care industry. WWUs allow Nuclear Medicine to account for the complexity of each study in assessing workload, that some studies are more time consuming and require higher levels of expertise. This gives a more accurate picture of workload; productivity etc than using just 'total studies' would yield. * A detailed Full-Time Equivalent Employee (FTEE) grid, and staffing distributions of FTEEs across nuclear medicine services. * Information on Radiation Safety Committees and Radiation Safety Officers (RSOs). Beginning in 2011 this will include data collection on part-time and non VA (contract) RSOs; other affiliations they may have and if so to whom they report (supervision) at their VA medical center.Collection of data on nuclear medicine services' progress in meeting the special needs of our female veterans. Revolving documentation of all major VA-owned gamma cameras (by type) and computer systems, their specifications and ages. * Revolving data collection for PET/CT cameras owned or leased by VA; and the numbers and types of PET/CT studies performed on VA patients whether produced on-site, via mobile PET/CT contract or from non-VA providers in the community.* Types of educational training/certification programs available at VA sites * Ongoing funded research projects by Nuclear Medicine (NM) staff, identified by source of funding and research purpose. * Data on physician-specific quality indicators at each nuclear medicine service.* Academic achievements by NM staff, including published books/chapters, journals and abstracts. * Information from polling field sites re: relevant issues and programs Headquarters needs to address. * Results of a Congressionally mandated contracted quality assessment exercise, also known as a Proficiency study. Study results are analyzed for comparison within VA facilities (for example by mission or size), and against participating private sector health care groups. * Information collected on current issues in nuclear medicine as they arise. Radiation Safety Committee structures and membership, Radiation Safety Officer information and information on how nuclear medicine services provided for female Veterans are examples of current issues.The database is now stored completely within MS Access Database Tables with output still presented in the form of Excel graphs and tables.

This dataset contains the industry payments and financial relationships with U.S. physicians from 432 for-profit companies that publically reported data. These data were derived from Kyruus, is a software-based solutions company that uses big data to optimize patient access and provider network operations for large health systems across the country. These data contain individual-level information on physicians’ financial relationships with industry in 2011, including companies from whom they received money, the monetary value of these interactions, and the reason for the financial tie (consulting, research funding, meals and travel, etc.). Additionally, these data include demographic information such as age, gender, medical specialty and primary location. We merged these individual-level data with institution-level data from the American Hospitals Association (AHA) 2011 Annual Survey (which has to be obtained independently due to liscense restrictions) and the National Institutes of Health (NIH) 2011 publically searchable database. Kyruus provided permission for data sharing.