> For the complete documentation index, see [llms.txt](https://docs.dataplex-consulting.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.dataplex-consulting.com/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-physician-other-practitioners-by-provider.md).

# Medicare Physician & Other Practitioners - by Provider

Part of the [CMS Data Feeds Dataset](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog.md) › 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](https://app.snowflake.com/marketplace/listing/GZT1Z125KDH/dataplex-consulting-data-products-cms-data-feeds-dataset).

{% hint style="success" %}
**Current** — CMS last published this feed on 2026-05-21. Coverage is complete through the 2024 reporting year. Next CMS release expected \~May 2027.
{% endhint %}

{% hint style="info" %}
**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.
{% endhint %}

## Sample queries

{% tabs %}
{% tab title="Snowflake" %}

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

{% endtab %}

{% tab title="Databricks" %}

```sql
-- Each file version covers one reporting period — history is additive
SELECT *
FROM cms_dwv.medicare_physician__other_practitioners__by_provider
LIMIT 100;
```

{% endtab %}
{% endtabs %}

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

<details>

<summary>Show 2 earlier file versions</summary>

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

</details>

## Data dictionary

<details>

<summary>📋 <strong>98 data columns + 6 lineage columns</strong></summary>

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

</details>

## 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:

```mermaid
erDiagram
    FEEDS ||--o{ FEEDS_FILES : "ID = FEED_ID"
    FEEDS ||--o{ MEDICARE_PHYSICIAN__OTHER_PRACTITIONERS__BY_PROVIDER : "ID = FILE_FEED_ID"
    FEEDS_FILES ||--o{ MEDICARE_PHYSICIAN__OTHER_PRACTITIONERS__BY_PROVIDER : "ID = FILE_ID"

    FEEDS {
        text ID PK
        text TITLE
        text VIEW_NAME
        text ACCURAL_PERIODICITY
    }
    FEEDS_FILES {
        text ID PK
        text FEED_ID FK
        date TEMPORAL_START
        date TEMPORAL_END
        date CMS_FEED_MODIFIED
        number IS_LATEST
    }
    MEDICARE_PHYSICIAN__OTHER_PRACTITIONERS__BY_PROVIDER {
        text ROW_ID PK
        text FILE_ID FK
        text FILE_FEED_ID FK
        number RNDRNG_NPI
        text RNDRNG_PRVDR_LAST_ORG_NAME
        text RNDRNG_PRVDR_FIRST_NAME
        text RNDRNG_PRVDR_MI
        number remaining_94_data_columns
    }
```

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

```sql
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](https://data.cms.gov/resources/medicare-physician-other-practitioners-by-provider-data-dictionary)
* [Medicare Physician Other Practitioners Methodology](https://data.cms.gov/resources/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](https://app.snowflake.com/marketplace/listing/GZT1Z125KDH/dataplex-consulting-data-products-cms-data-feeds-dataset) (free trial available) and via [Databricks Delta Sharing](https://checkout.dataplex-consulting.com/b/3cIdR2e1J59Sh2w7pWbQY00). Once mounted, query `DWV.MEDICARE_PHYSICIAN__OTHER_PRACTITIONERS__BY_PROVIDER` directly — no pipeline setup required.

## Related feeds

{% content-ref url="/pages/0yQWEWJZ1hsGQwv3mdq4" %}
[Medicare Physician & Other Practitioners - by Provider and Service](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-physician-other-practitioners-by-provider-and-service.md)
{% endcontent-ref %}

{% content-ref url="/pages/mLAzRSEXMTntOoMnqquk" %}
[Medicare Durable Medical Equipment, Devices & Supplies - by Geography and Service](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-durable-medical-equipment-devices-supplies-by-geography-and-service.md)
{% endcontent-ref %}

{% content-ref url="/pages/rbWJsiOOm1fFT4s84H9g" %}
[Medicare Physician & Other Practitioners - by Geography and Service](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-physician-other-practitioners-by-geography-and-service.md)
{% endcontent-ref %}

{% content-ref url="/pages/VIw3c5tLZxTAD8CFddod" %}
[Medicare Durable Medical Equipment, Devices & Supplies - by Supplier](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-durable-medical-equipment-devices-supplies-by-supplier.md)
{% endcontent-ref %}

{% content-ref url="/pages/ChHxmMUbXaxxDkjmq4Zy" %}
[Medicare Durable Medical Equipment, Devices & Supplies - by Referring Provider](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-durable-medical-equipment-devices-supplies-by-referring-provider.md)
{% endcontent-ref %}

## Get this feed

1. [Start a free trial on Snowflake Marketplace](https://app.snowflake.com/marketplace/listing/GZT1Z125KDH/dataplex-consulting-data-products-cms-data-feeds-dataset) or purchase via [Databricks](https://checkout.dataplex-consulting.com/b/3cIdR2e1J59Sh2w7pWbQY00)
2. Mount the share — the database and `DWV` schema appear in your account immediately
3. Run the [sample query](#sample-queries) above — no ETL, no pipeline maintenance

Questions about this feed? Contact us at <notifications@dataplex-consulting.com>.

***

Part of the [CMS Data Feeds Dataset](/data-catalog/cms-data-feeds-dataset.md) — 280+ feeds · 245B+ records · updated daily. [Back to the full catalog →](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog.md#medicare-physician-other-practitioners-by-provider)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.dataplex-consulting.com/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-physician-other-practitioners-by-provider.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
