Baselight
Sign In

Opt Out Affidavits

U.S. Department of Health & Human Services

@usgov.hhs_gov_opt_out_affidavits_81c05

Loading...
Loading...

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 : 2023-04-30

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_04_30
  • 1.36 MB
  • 30,468 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2023_04_30 (
  "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 : 2023-05-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_05_01
  • 1.37 MB
  • 30,612 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2023_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 : 2023-06-30

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_06_30
  • 1.38 MB
  • 30,882 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2023_06_30 (
  "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 : 2023-07-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_07_01
  • 1.39 MB
  • 31,062 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2023_07_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 : 2023-08-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_08_01
  • 1.4 MB
  • 31,352 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2023_08_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 : 2023-09-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_09_01
  • 1.41 MB
  • 31,603 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2023_09_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 : 2023-10-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_10_01
  • 1.4 MB
  • 31,365 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2023_10_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 : 2023-11-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_11_01
  • 1.43 MB
  • 32,122 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2023_11_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 : 2023-12-31

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_12_31
  • 1.45 MB
  • 32,386 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2023_12_31 (
  "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 : 2024-01-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_01_01
  • 1.53 MB
  • 34,216 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2024_01_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 : 2024-02-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_02_01
  • 1.7 MB
  • 38,278 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2024_02_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 : 2024-03-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_03_01
  • 1.79 MB
  • 40,526 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2024_03_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 : 2024-04-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_04_01
  • 1.87 MB
  • 42,388 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2024_04_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 : 2024-05-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_05_01
  • 1.92 MB
  • 43,479 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2024_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 : 2024-06-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_06_01
  • 1.96 MB
  • 44,308 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2024_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
);

Opt Out Affidavits : 2024-07-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_07_01
  • 2 MB
  • 45,112 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2024_07_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 : 2024-08-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_08_01
  • 2.02 MB
  • 45,735 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2024_08_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 : 2024-09-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_09_01
  • 2.05 MB
  • 46,406 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2024_09_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 : 2024-10-31

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_10_31
  • 2.09 MB
  • 47,350 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2024_10_31 (
  "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 : 2024-11-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_11_01
  • 2.12 MB
  • 47,984 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2024_11_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 : 2024-12-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_12_01
  • 2.15 MB
  • 48,702 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2024_12_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-01-31

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2025_01_31
  • 2.19 MB
  • 49,316 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2025_01_31 (
  "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-02-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2025_02_01
  • 2.21 MB
  • 49,923 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2025_02_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-03-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2025_03_01
  • 2.23 MB
  • 50,473 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2025_03_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-04-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2025_04_01
  • 2.26 MB
  • 51,174 rows
  • 13 columns
Loading... 
CREATE TABLE opt_out_affidavits_2025_04_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
);

Share link

Anyone who has the link will be able to view this.