Medicare Advantage, Part D, Medicaid

Special Needs Plans by plan and month, parse revision 3 (D-SNP integration status, small-cell bounds, Under-11 rows)

medicare_silver.snp_data_v2·live·silver

Rows

195,628

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS's monthly SNP Comprehensive Report at parse revision 3: every SNP plan since 2007-05 with SNP type, specialty diseases, enrollment and states (Plan ID at three digits), plus the D-SNP integration status (CO / HIDE / FIDE, from 2022-07), applicable integrated plan, partial-dual-only and D-SNP-only-contract flags (from 2025-01), the [0, 10] bound on a blank enrollment cell, and CMS's Under-11 aggregate rows flagged synthetic_under_11_row.
2The tools read medicare_semantic.vw_snp_data_v3, this table's current vintage (card medicare_snp_data_v3).

Grain

Key	Grain
N/A	1One row per (contract_id, plan_id, segment_id, snp_type, state_list_raw, report_month) among is_current real rows; 2195,628 current rows over 233 months 2007-05..2026-09 = the served 194,930 rows one for one plus CMS's 698 Under-11 rows (Athena a3e5cf73, 43cbe058).

Columns (31)

Column	Type	Meaning
`contract_id`	string
`plan_id`	string
`segment_id`	string
`report_month`	date
`contract_name_raw`	string
`organization_type`	string
`plan_name_raw`	string
`plan_type`	string
`plan_geographic_name`	string
`state_list_raw`	string
`plan_enrollment`	int
`snp_type`	string
`specialty_diseases`	string
`dsnp_integration_status`	string
`applicable_integrated_plan`	boolean
`partial_dual_only`	boolean
`dsnp_only_contract`	boolean
`plan_enrollment_lower_bound`	int
`plan_enrollment_upper_bound`	int
`enrollment_suppression_reason`	string
`synthetic_under_11_row`	boolean
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`is_current`	boolean

Query it

describe_data_source(source_fqn="medicare_silver.snp_data_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.snp_data_v2 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id,plan_id,segment_id`
Join	`how_to_join(source_fqn="medicare_silver.snp_data_v2")`
Raw door	Athena: medicare_silver.snp_data_v2 (WHERE is_current AND NOT synthetic_under_11_row for plans; pin report_month); prefer medicare_semantic.vw_snp_data_v3
Note	Wave-1A reload (Data Tracker, docs/data-tracker/RELOAD-PLAN-WAVE1A-MA-LOADERS-2026-10-01.md, defects SNPD-1/-3). Versioned, never overwritten; medicare_snp_data_v2 (vw_snp_data_v2) stays live as the rollback.

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