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

`medicare_silver.nppes_deactivated_npi_v1` · Medicare Advantage, Part D, Medicaid · status partial

CMS'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). 2026-11-02: 360,014 NPIs. Read the newest report_date; each report replaces the last.

**Grain.** One row per NPI x report_date: deactivation_date, source_url, source_member, sha256_content_hash. Partitioned by report_date.

| column | type | meaning |
|---|---|---|
| npi | string |  |
| deactivation_date | date |  |
| source_url | string |  |
| source_member | string |  |
| sha256_content_hash | string |  |
| loaded_at | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.nppes_deactivated_npi_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.nppes_deactivated_npi_v1")` first.