VladaOmega
Sign inStart free
Medicare Advantage, Part D, Medicaid

CMS NPPES Deactivated NPI Report: every deactivated NPI with its date, one partition per monthly report

medicare_silver.nppes_deactivated_npi_v1·partial·reference
Rows
N/A
Columns
6
History
N/A
Card
nocolumns only
Typed tools
0

What it is

  1. 1CMS's monthly list of NPIs deactivated in NPPES and not reactivated, loaded by tools/data_tracker/load_nppes_deactivated.py (raw ZIP archived under its sha256).
  2. 22026-11-02: 360,014 NPIs.
  3. 3Read the newest report_date; each report replaces the last.

Grain

KeyGrain
N/A
  1. 1One row per NPI x report_date: deactivation_date, source_url, source_member, sha256_content_hash.
  2. 2Partitioned by report_date.

Columns (6)

ColumnTypeMeaning
npistring
deactivation_datedate
source_urlstring
source_memberstring
sha256_content_hashstring
loaded_atstring

Query it

describe_data_source(source_fqn="medicare_silver.nppes_deactivated_npi_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.nppes_deactivated_npi_v1 WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itnone; raw SQL
Identity keynpi
Joinhow_to_join(source_fqn="medicare_silver.nppes_deactivated_npi_v1")
Raw doorAthena (read-only via query_substrate): medicare_silver.nppes_deactivated_npi_v1 (filter report_date to the newest; join on npi)

This page as markdown: /docs-md/data/medicare_silver_nppes_deactivated_npi_v1.md · every page in one file: /llms-full.txt