Opt Out Affidavits
The Opt Out Affidavits dataset provides information on providers who have decided not to participate in Medicare.
Part of the CMS Data Feeds Dataset › Medicare
Dataplex delivers this CMS feed as the analysis-ready table DWV.OPT_OUT_AFFIDAVITS 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.OPT_OUT_AFFIDAVITS
Databricks
cms_dwv.opt_out_affidavits
Coverage
Apr 2023 – Apr 2026
Rows
1,758,084 (total across all reporting periods)
Cadence
Monthly
Update pattern
Time-partitioned — each file adds one reporting period
CMS published
2026-05-26
Loaded
2026-05-26
Columns
13 data + 6 lineage
Identifiers
NPI · ZIP codes
File versions
39
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.
Last CMS publication 2026-05-26 — awaiting the next release. New files load automatically when CMS publishes.
Time-partitioned feed — each file version covers one reporting period, so history is additive. Query the full table for all periods; filter on the reporting period columns for a single period. Do not filter to the latest file only — that would return just the 2026 reporting period.
Sample queries
About this feed
The Opt Out Affidavits dataset provides information on providers who have decided not to participate in Medicare. It contains provider's NPI, specialty, address, and effective dates.
— Source: CMS feed metadata
Keywords: Medicare, Original Medicare, Medicare Advantage, Provider Enrollment Theme: Medicare
Coverage timeline
2023 🟩 · 2024 🟩 · 2025 🟩 · 2026 🟩
4 of 4 years covered — no gaps.
Release history
2026-04-01 – 2026-04-30
2026-05-26
2026-05-26
✓
2026-03-01 – 2026-03-31
2026-04-20
2026-04-20
2026-02-01 – 2026-02-28
2026-03-23
2026-03-23
2026-01-01 – 2026-01-31
2026-02-25
2026-02-28
2026-01-01 – 2026-01-31
2026-02-23
2026-02-23
2025-12-01 – 2025-12-31
2026-01-21
2026-01-21
2025-11-01 – 2025-11-30
2025-12-22
2025-12-22
2025-10-01 – 2025-10-31
2025-11-24
2025-11-24
2025-09-01 – 2025-09-30
2025-10-28
2025-10-28
2025-09-01 – 2025-09-30
2025-10-22
2025-10-22
Show 29 earlier file versions
2025-08-01 – 2025-08-31
2025-09-19
2025-09-19
2025-07-01 – 2025-07-31
2025-08-20
2025-08-20
2025-06-01 – 2025-06-30
2025-07-28
2025-07-28
2025-05-01 – 2025-05-31
2025-06-27
2025-06-27
2025-04-01 – 2025-04-30
2025-05-27
2025-05-27
2025-03-01 – 2025-03-31
2025-04-24
2025-04-24
2025-02-01 – 2025-02-28
2025-03-24
2025-03-24
2025-01-01 – 2025-01-31
2025-02-27
2025-02-27
2024-12-01 – 2024-12-31
2025-01-22
2025-01-22
2024-11-01 – 2024-11-30
2024-12-20
2024-12-20
2024-10-01 – 2024-10-31
2024-11-22
2024-11-22
2024-09-01 – 2024-09-30
2024-10-22
2024-10-22
2024-08-01 – 2024-08-31
2024-09-23
2024-09-23
2024-07-01 – 2024-07-31
2024-08-26
2024-08-26
2024-06-01 – 2024-06-30
2024-07-22
2024-07-22
2024-05-01 – 2024-05-31
2024-06-17
2024-06-17
2024-04-01 – 2024-04-30
2024-06-04
2024-06-07
2024-02-01 – 2024-02-29
2024-03-26
2024-03-26
2024-03-01 – 2024-03-31
2024-03-22
2024-03-22
2024-01-01 – 2024-01-31
2024-02-22
2024-02-22
2023-12-01 – 2023-12-31
2024-01-22
2024-01-22
2023-11-01 – 2023-11-30
2023-12-19
2023-12-19
2023-10-01 – 2023-10-31
2023-11-20
2023-11-20
2023-09-01 – 2023-09-30
2023-10-23
2023-10-23
2023-08-01 – 2023-08-31
2023-09-18
2023-09-18
2023-07-01 – 2023-07-31
2023-08-18
2023-08-29
2023-06-01 – 2023-06-30
2023-07-19
2023-08-29
2023-05-01 – 2023-05-31
2023-06-22
2023-08-29
2023-04-01 – 2023-04-30
2023-05-17
2023-08-29
Data dictionary
📋 13 data columns + 6 lineage columns
Column-level definitions are maintained by CMS in the official Opt Out Affidavits data dictionary.
Data columns
FIRST_NAME
TEXT
LAST_NAME
TEXT
NPI
NUMBER
SPECIALTY
TEXT
OPTOUT_EFFECTIVE_DATE
DATE
OPTOUT_END_DATE
DATE
FIRST_LINE_STREET_ADDRESS
TEXT
SECOND_LINE_STREET_ADDRESS
TEXT
CITY_NAME
TEXT
STATE_CODE
TEXT
ZIP_CODE
TEXT
ELIGIBLE_TO_ORDER_AND_REFER
BOOLEAN
LAST_UPDATED
DATE
Lineage columns (present on every feed table)
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:
Source & provenance
Published by the Centers for Medicare & Medicaid Services (bureau 009:38).
Frequently asked questions
How often is Opt Out Affidavits updated?
Monthly. CMS last published this feed on 2026-05-26, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them.
What years does Opt Out Affidavits cover?
2023 through 2026.
How many records are in Opt Out Affidavits?
1,758,084 rows across all 39 reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count — no deduplication needed.
How do I get Opt Out Affidavits 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.OPT_OUT_AFFIDAVITS directly — no pipeline setup required.
Related feeds
Medicare Provider and Supplier Taxonomy CrosswalkHospital Change of Ownership - Owner InformationSkilled Nursing Facility Change of Ownership - Owner InformationSkilled Nursing Facility All OwnersHome Infusion Therapy ProvidersGet 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