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-05-28T18:17:35.870145
Tags: medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

Opt Out Affidavits : 2025-04-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2025_04_01
  • 2.16 MB
  • 51174 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
);

Opt Out Affidavits : 2025-03-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2025_03_01
  • 2.13 MB
  • 50473 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-02-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2025_02_01
  • 2.11 MB
  • 49923 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-01-31

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2025_01_31
  • 2.08 MB
  • 49316 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 : 2024-12-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_12_01
  • 2.05 MB
  • 48702 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 : 2024-11-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_11_01
  • 2.02 MB
  • 47984 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-10-31

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_10_31
  • 2 MB
  • 47350 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-09-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_09_01
  • 1.95 MB
  • 46406 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-08-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_08_01
  • 1.93 MB
  • 45735 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-07-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_07_01
  • 1.9 MB
  • 45112 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-06-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_06_01
  • 1.87 MB
  • 44308 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-05-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_05_01
  • 1.83 MB
  • 43479 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-04-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_04_01
  • 1.78 MB
  • 42388 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-03-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_03_01
  • 1.71 MB
  • 40526 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-02-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_02_01
  • 1.62 MB
  • 38278 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-01-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2024_01_01
  • 1.46 MB
  • 34216 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 : 2023-12-31

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_12_31
  • 1.38 MB
  • 32386 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 : 2023-11-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_11_01
  • 1.37 MB
  • 32122 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-10-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_10_01
  • 1.34 MB
  • 31365 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-09-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_09_01
  • 1.35 MB
  • 31603 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-08-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_08_01
  • 1.34 MB
  • 31352 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-07-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_07_01
  • 1.32 MB
  • 31062 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-06-30

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_06_30
  • 1.32 MB
  • 30882 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-05-01

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_05_01
  • 1.31 MB
  • 30612 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-04-30

@usgov.hhs_gov_opt_out_affidavits_81c05.opt_out_affidavits_2023_04_30
  • 1.3 MB
  • 30468 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
);

Share link

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