Medicare Physician & Other Practitioners - by Provider

The Medicare Physician & Other Practitioners by Provider dataset provides information on use, payments, submitted charges and beneficiary demographic and…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.MEDICARE_PHYSICIAN__OTHER_PRACTITIONERS__BY_PROVIDER on Snowflake and Databricks — 12 annual reporting periods (2013–2024) aligned to a single schema, refreshed automatically whenever CMS publishes a new file. Every row carries lineage back to the exact CMS source file that produced it.

Key facts

Snowflake	DWV.MEDICARE_PHYSICIAN__OTHER_PRACTITIONERS__BY_PROVIDER
Databricks	cms_dwv.medicare_physician__other_practitioners__by_provider
Coverage	Jan 2013 – Dec 2024 (12 of 12 annual reporting periods)
Rows	13,528,933 (total across all reporting periods)
Cadence	Annual
Update pattern	Time-partitioned — each file adds one reporting year
CMS published	2026-05-21
Loaded	2026-05-21
Columns	98 data + 6 lineage
Identifiers	NPI · FIPS codes · HCPCS codes
File versions	12
License	CMS public data — U.S. Government work
Platforms	Snowflake Marketplace · Databricks Delta Sharing

Included in the CMS Data Feeds Dataset — start a free trial on Snowflake Marketplace.

Current — CMS last published this feed on 2026-05-21. Coverage is complete through the 2024 reporting year. Next CMS release expected ~May 2027.

Time-partitioned feed — each file version covers one reporting year, so history is additive. Query the full table for all years; filter on the reporting period columns for a single period. Do not filter to the latest file only — that would return just the 2024 reporting year.

Sample queries

Snowflake

-- Each file version covers one reporting period — history is additive
SELECT *
FROM DWV.MEDICARE_PHYSICIAN__OTHER_PRACTITIONERS__BY_PROVIDER
LIMIT 100;

Databricks

About this feed

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

— Source: CMS feed metadata

Keywords: Medicare, Original Medicare, Physicians & Practitioners, Health Care Use & Payments, Health Equity Theme: Medicare

Coverage timeline

2013–2024 🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)

12 of 12 annual reporting periods present — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
2024-01-01 – 2024-12-31	2026-05-21	2026-05-21	✓
2023-01-01 – 2023-12-31	2025-04-24	2025-04-24
2022-01-01 – 2022-12-31	2024-06-04	2024-06-07
2021-01-01 – 2021-12-31	2023-05-10	2023-08-29
2020-01-01 – 2020-12-31	2023-05-10	2023-08-29
2019-01-01 – 2019-12-31	2023-05-10	2023-08-29
2018-01-01 – 2018-12-31	2023-05-10	2023-08-29
2017-01-01 – 2017-12-31	2023-05-10	2023-08-29
2016-01-01 – 2016-12-31	2023-05-10	2023-08-29
2015-01-01 – 2015-12-31	2023-05-10	2023-08-29

Show 2 earlier file versions

Reporting period	CMS published	Loaded	Latest file
2014-01-01 – 2014-12-31	2023-05-10	2023-08-29
2013-01-01 – 2013-12-31	2023-05-10	2023-08-29

Data dictionary

📋 98 data columns + 6 lineage columns

Data columns

Column	Type	Description
RNDRNG_NPI	NUMBER	National Provider Identifier (NPI) for the rendering provider on the claim. The provider NPI is the numeric identifier registered in NPPES.
RNDRNG_PRVDR_LAST_ORG_NAME	TEXT	When the provider is registered in NPPES as an individual (entity type code='I'), this is the provider's last name. When the provider is registered as an organization (entity type code = 'O'), this is the organization name.
RNDRNG_PRVDR_FIRST_NAME	TEXT	When the provider is registered in NPPES as an individual (entity type code='I'), this is the provider's first name. When the provider is registered as an organization (entity type code = 'O'), this will be blank.
RNDRNG_PRVDR_MI	TEXT	When the provider is registered in NPPES as an individual (entity type code='I'), this is the provider's middle initial. When the provider is registered as an organization (entity type code = 'O'), this will be blank.
RNDRNG_PRVDR_CRDNTLS	TEXT	When the provider is registered in NPPES as an individual (entity type code='I'), these are the provider's credentials. When the provider is registered as an organization (entity type code = 'O'), this will be blank.
RNDRNG_PRVDR_ENT_CD	TEXT	Type of entity reported in NPPES. An entity code of 'I' identifies providers registered as individuals and an entity type code of 'O' identifies providers registered as organizations.
RNDRNG_PRVDR_ST1	TEXT	The first line of the provider's street address, as reported in NPPES.
RNDRNG_PRVDR_ST2	TEXT	The second line of the provider's street address, as reported in NPPES.
RNDRNG_PRVDR_CITY	TEXT	The city where the provider is located, as reported in NPPES.
RNDRNG_PRVDR_STATE_ABRVTN	TEXT	The state where the provider is located, as reported in NPPES. The fifty U.S. states and the District of Columbia are reported by the state postal abbreviation.
RNDRNG_PRVDR_STATE_FIPS	TEXT	FIPS code for rendering provider's state.
RNDRNG_PRVDR_ZIP5	TEXT	The provider's zip code, as reported in NPPES.
RNDRNG_PRVDR_RUCA	NUMBER	Rural-Urban Commuting Area Codes (RUCAs), are a Census tract-based classification scheme that utilizes the standard Bureau of Census Urbanized Area and Urban Cluster definitions in combination with work commuting information to characterize all of the nation's Census tracts regarding their rural and urban status and relationships.
RNDRNG_PRVDR_RUCA_DESC	TEXT	Description of Rural-Urban Commuting Area (RUCA) Code.
RNDRNG_PRVDR_CNTRY	TEXT	The country where the provider is located, as reported in NPPES.
RNDRNG_PRVDR_TYPE	TEXT	Derived from the provider specialty code reported on the claim.
RNDRNG_PRVDR_MDCR_PRTCPTG_IND	BOOLEAN	Identifies whether the provider participates in Medicare and/or accepts assignment of Medicare allowed amounts.
TOT_HCPCS_CDS	NUMBER	Total number of unique HCPCS codes.
TOT_BENES	NUMBER	Total Medicare beneficiaries receiving services from the provider.
TOT_SRVCS	NUMBER	Total provider services.
TOT_SBMTD_CHRG	NUMBER	The total charges that the provider submitted for all services.
TOT_MDCR_ALOWD_AMT	NUMBER	The Medicare allowed amount for all provider services.
TOT_MDCR_PYMT_AMT	NUMBER	Total amount that Medicare paid after deductible and coinsurance amounts have been deducted for all the provider's line item services.
TOT_MDCR_STDZD_AMT	NUMBER	Total amount that Medicare paid after the standardization of the Medicare payment has been applied.
DRUG_SPRSN_IND	TEXT	Identifies whether the utilization, cost and payment information associated with HCPCS codes for drug services has been suppressed.
DRUG_TOT_HCPCS_CDS	NUMBER	Total number of HCPCS codes for drug services.
DRUG_TOT_BENES	NUMBER	Total Medicare beneficiaries receiving drug services.
DRUG_TOT_SRVCS	NUMBER	Total drug services.
DRUG_SBMTD_CHRG	NUMBER	The total charges that the provider submitted for drug services.
DRUG_MDCR_ALOWD_AMT	NUMBER	The Medicare allowed amount for drug services.
DRUG_MDCR_PYMT_AMT	NUMBER	Total amount that Medicare paid post deductions for all drug services.
DRUG_MDCR_STDZD_AMT	NUMBER	Total amount that Medicare paid after standardization for drug services.
MED_SPRSN_IND	TEXT	Identifies whether medical utilization, cost and payment information has been suppressed.
MED_TOT_HCPCS_CDS	NUMBER	Total number of HCPCS codes associated with medical services.
MED_TOT_BENES	NUMBER	Total Medicare beneficiaries receiving medical services.
MED_TOT_SRVCS	NUMBER	Total medical services.
MED_SBMTD_CHRG	NUMBER	The total charges for medical services.
MED_MDCR_ALOWD_AMT	NUMBER	The Medicare allowed amount for medical services.
MED_MDCR_PYMT_AMT	NUMBER	Total amount that Medicare paid for medical services.
MED_MDCR_STDZD_AMT	NUMBER	Total amount that Medicare paid for medical services after standardization.
BENE_AVG_AGE	NUMBER	Average age of beneficiaries.
BENE_AGE_LT_65_CNT	NUMBER	Number of beneficiaries under the age of 65.
BENE_AGE_65_74_CNT	NUMBER	Number of beneficiaries between the ages of 65 and 74.
BENE_AGE_75_84_CNT	NUMBER	Number of beneficiaries between the ages of 75 and 84.
BENE_AGE_GT_84_CNT	NUMBER	Number of beneficiaries over the age of 84.
BENE_FEML_CNT	NUMBER	Number of female beneficiaries.
BENE_MALE_CNT	NUMBER	Number of male beneficiaries.
BENE_RACE_WHT_CNT	NUMBER	Number of non-Hispanic white beneficiaries.
BENE_RACE_BLACK_CNT	NUMBER	Number of non-Hispanic black or African American beneficiaries.
BENE_RACE_API_CNT	NUMBER	Number of Asian Pacific Islander beneficiaries.
BENE_RACE_HSPNC_CNT	NUMBER	Number of Hispanic beneficiaries.
BENE_RACE_NATIND_CNT	NUMBER	Number of American Indian or Alaska Native beneficiaries.
BENE_RACE_OTHR_CNT	NUMBER	Number of beneficiaries with race not elsewhere classified.
BENE_DUAL_CNT	NUMBER	Number of beneficiaries qualified for both Medicare and Medicaid.
BENE_NDUAL_CNT	NUMBER	Number of beneficiaries qualified to receive Medicare only benefits.
BENE_CC_BH_ADHD_OTHCD_V1_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for ADHD.
BENE_CC_BH_ALCOHOL_DRUG_V1_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithms for alcohol and drug use disorders.
BENE_CC_BH_TOBACCO_V1_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for tobacco use disorders.
BENE_CC_BH_ALZ_NONALZDEM_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for Alzheimer's disease.
BENE_CC_BH_ANXIETY_V1_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for anxiety disorders.
BENE_CC_BH_BIPOLAR_V1_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for bipolar disorders.
BENE_CC_BH_MOOD_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for mood disorders.
BENE_CC_BH_DEPRESS_V1_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for major depressive disorders.
BENE_CC_BH_PD_V1_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for personality disorders.
BENE_CC_BH_PTSD_V1_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for post-traumatic stress disorders.
BENE_CC_BH_SCHIZO_OTHPSY_V1_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for schizophrenia.
BENE_CC_PH_ASTHMA_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for asthma.
BENE_CC_PH_AFIB_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for atrial fibrillation/flutter.
BENE_CC_PH_CANCER6_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithms for six cancer types.
BENE_CC_PH_CKD_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithms for chronic kidney disease.
BENE_CC_PH_COPD_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for COPD.
BENE_CC_PH_DIABETES_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for diabetes.
BENE_CC_PH_HF_NONIHD_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for heart failure/non-ischemic heart disease.
BENE_CC_PH_HYPERLIPIDEMIA_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for hyperlipidemia.
BENE_CC_PH_HYPERTENSION_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for hypertension.
BENE_CC_PH_ISCHEMICHEART_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for ischemic heart disease.
BENE_CC_PH_OSTEOPOROSIS_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for osteoporosis.
BENE_CC_PH_PARKINSON_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for Parkinson's disease.
BENE_CC_PH_ARTHRITIS_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for rheumatoid arthritis.
BENE_CC_PH_STROKE_TIA_V2_PCT	NUMBER	Percent of beneficiaries meeting the CCW chronic condition algorithm for stroke.
BENE_AVG_RISK_SCRE	NUMBER	Average Hierarchical Condition Category (HCC) risk score of beneficiaries.
RNDRNG_PRVDR_GNDR	TEXT
BENE_CC_AF_PCT	NUMBER
BENE_CC_ALZHMR_PCT	NUMBER
BENE_CC_ASTHMA_PCT	NUMBER
BENE_CC_CNCR_PCT	NUMBER
BENE_CC_CHF_PCT	NUMBER
BENE_CC_CKD_PCT	NUMBER
BENE_CC_COPD_PCT	NUMBER
BENE_CC_DPRSSN_PCT	NUMBER
BENE_CC_DBTS_PCT	NUMBER
BENE_CC_HYPLPDMA_PCT	NUMBER
BENE_CC_HYPRTNSN_PCT	NUMBER
BENE_CC_IHD_PCT	NUMBER
BENE_CC_OPO_PCT	NUMBER
BENE_CC_RAOA_PCT	NUMBER
BENE_CC_SZ_PCT	NUMBER
BENE_CC_STROK_PCT	NUMBER

Lineage columns (present on every feed table)

Column	Type	Description
ROW_ID	TEXT	Unique row ID for this table (PK)
FILE_ID	TEXT	Source file — joins to FEEDS_FILES.ID (FK)
FILE_FEED_ID	TEXT	Parent feed — joins to FEEDS.ID (FK)
FILE_NAME	TEXT	Source file name as published by CMS
ROWNUM	NUMBER	Row number within the source file
CREATED_AT	TIMESTAMP_NTZ	Timestamp when the record was loaded

Row-level lineage

Every row in this table traces to the exact CMS source file that produced it. The FILE_ID column joins to the FEEDS_FILES catalog table, and FILE_FEED_ID joins to the FEEDS master table:

Trace any row back to its source file and reporting period:

SELECT d.RNDRNG_NPI, d.RNDRNG_PRVDR_LAST_ORG_NAME, d.RNDRNG_PRVDR_FIRST_NAME,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.MEDICARE_PHYSICIAN__OTHER_PRACTITIONERS__BY_PROVIDER d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Source & provenance

Published by the Centers for Medicare & Medicaid Services (bureau 009:38).

• Official CMS data dictionary

• Medicare Physician Other Practitioners Methodology

Frequently asked questions

How often is Medicare Physician & Other Practitioners - by Provider updated?

Annually. CMS last published this feed on 2026-05-21, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them.

What years does Medicare Physician & Other Practitioners - by Provider cover?

2013 through 2024 — 12 annual reporting periods with no gaps. Each reporting year arrives as its own file version, and all years remain queryable side by side.

How many records are in Medicare Physician & Other Practitioners - by Provider?

13,528,933 rows across all 12 reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count — no deduplication needed.

How do I get Medicare Physician & Other Practitioners - by Provider data?

It's included in the CMS Data Feeds Dataset on the Snowflake Marketplace (free trial available) and via Databricks Delta Sharing. Once mounted, query DWV.MEDICARE_PHYSICIAN__OTHER_PRACTITIONERS__BY_PROVIDER directly — no pipeline setup required.

Related feeds

Medicare Physician & Other Practitioners - by Provider and ServiceMedicare Durable Medical Equipment, Devices & Supplies - by Geography and ServiceMedicare Physician & Other Practitioners - by Geography and ServiceMedicare Durable Medical Equipment, Devices & Supplies - by SupplierMedicare Durable Medical Equipment, Devices & Supplies - by Referring Provider

Get this feed

1. Start a free trial on Snowflake Marketplace or purchase via Databricks

2. Mount the share — the database and DWV schema appear in your account immediately

3. Run the sample query above — no ETL, no pipeline maintenance

Questions about this feed? Contact us at [e-mail].

---

Part of the CMS Data Feeds Dataset — 280+ feeds · 245B+ records · updated daily. Back to the full catalog →