Order and Referring
The Order and Referring dataset provides information on all physicians and non-physician practitioners, by their National Provider Identifier (NPI), who are…
Part of the CMS Data Feeds Dataset › Medicare
Dataplex delivers this CMS feed as the analysis-ready table DWV.ORDER_AND_REFERRING on Snowflake and Databricks: coverage from 2023 to 2026 in a single aligned 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.ORDER_AND_REFERRING
Databricks
cms_dwv.order_and_referring
Coverage
May 2023 – Oct 2026
Rows
512,256,639 (total across all reporting periods)
Update pattern
Time-partitioned; each file adds one reporting period
CMS published
2026-10-06
Loaded
2026-10-06
Columns
8 data + 6 lineage
Identifiers
NPI
File versions
267
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-10-06. Coverage runs through 2026-10-03. Next CMS release expected ~Oct 2026.
Sample queries
About this feed
The Order and Referring dataset provides information on all physicians and non-physician practitioners, by their National Provider Identifier (NPI), who are of a type/specialty that is legally eligible to order and refer in the Medicare program and who have current enrollment records in Medicare. This dataset identifies Medicare fee-for-service ordering and referring eligibility, supporting transparency and regulatory compliance efforts. The information can be used to verify ordering and referring capabilities as required by Medicare program standards.
Source: CMS feed metadata
Keywords: Medicare, Original Medicare, Provider Enrollment Theme: Medicare
Coverage timeline
2023 🟩 · 2024 🟩 · 2025 🟩 · 2026 🟩
4 of 4 years covered, no gaps.
Release history
2026-09-27 – 2026-10-03
2026-10-06
2026-10-06
✓
2026-09-20 – 2026-09-26
2026-10-02
2026-10-02
2026-09-20 – 2026-09-26
2026-09-29
2026-09-30
2026-09-13 – 2026-09-19
2026-09-25
2026-09-25
2026-09-13 – 2026-09-19
2026-09-21
2026-09-21
2026-09-06 – 2026-09-12
2026-09-18
2026-09-18
2026-09-06 – 2026-09-12
2026-09-15
2026-09-15
2026-08-30 – 2026-09-05
2026-09-11
2026-09-11
2026-08-30 – 2026-09-05
2026-09-08
2026-09-08
2026-08-23 – 2026-08-29
2026-09-04
2026-09-04
Data dictionary
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:
Source & provenance
Published by the Centers for Medicare & Medicaid Services (bureau 009:38).
Frequently asked questions
How often is Order and Referring updated?
CMS last published this feed on 2026-10-06. New releases are added automatically when CMS publishes them.
What years does Order and Referring cover?
2023 through 2026.
How many records are in Order and Referring?
512,256,639 rows across all 267 reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count; no deduplication needed.
How do I get Order and Referring 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.ORDER_AND_REFERRING directly; no pipeline setup required.
Related feeds
Skilled Nursing Facility EnrollmentsHome Health Agency EnrollmentsMedicare Fee-For-Service Public Provider EnrollmentRevoked Medicare Providers and SuppliersRevalidation Reassignment ListGet this feed
Start a free trial on Snowflake Marketplace or purchase via Databricks
Mount the share; the database and
DWVschema appear in your account immediatelyRun the sample query above; no ETL, no pipeline maintenance
Questions about this feed? Contact us at notifications@dataplex-consulting.com.
Part of the CMS Data Feeds Dataset; 280+ feeds · 245B+ records · updated daily. Back to the full catalog →
Last updated