About this Dataset

Opt Out Affidavits

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-10-23T10:04:46.669232
Tags: medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

Opt Out Affidavits : 2025-09-01

@usgov.hhs_gov_opt_out_affidavits_afeae.opt_out_affidavits_2025_09_01

2.32 MB
52,480 rows
13 columns

CREATE TABLE opt_out_affidavits_2025_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
);