About this Dataset

Opt Out Affidavits

ATTENTION USERS

Some Providers' Opt-Out Status may end early due to COVID 19 waivers. Please contact your respective MAC for further information.

For more information on the opt-out process, see Manage Your Enrollment or view the FAQ section below.

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.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-07-29T18:00:01.080823
Tags: medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

Opt Out Affidavits : 2025-05-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2025_05_01

2.17 MB
51581 rows
13 columns


CREATE TABLE opt_out_affidavits_2025_05_01 (
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "npi" BIGINT,
  "specialty" VARCHAR,
  "optout_effective_date" TIMESTAMP,
  "optout_end_date" TIMESTAMP,
  "first_line_street_address" VARCHAR,
  "second_line_street_address" VARCHAR,
  "city_name" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" BIGINT,
  "eligible_to_order_and_refer" VARCHAR,
  "last_updated" TIMESTAMP
);

Opt Out Affidavits : 2025-06-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2025_06_01

2.19 MB
51908 rows
13 columns


CREATE TABLE opt_out_affidavits_2025_06_01 (
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "npi" BIGINT,
  "specialty" VARCHAR,
  "optout_effective_date" TIMESTAMP,
  "optout_end_date" TIMESTAMP,
  "first_line_street_address" VARCHAR,
  "second_line_street_address" VARCHAR,
  "city_name" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" BIGINT,
  "eligible_to_order_and_refer" VARCHAR,
  "last_updated" TIMESTAMP
);