Medicare Advantage, Part D, Medicaid

Special Needs Plans by plan and month, current CMS vintage, with D-SNP integration status, small-cell bounds and Under-11 rows

medicare_semantic.vw_snp_data_v3·live·semantic_view

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, the current CMS vintage of each month: every SNP plan since 2007-05 with SNP type, specialty diseases, enrollment and states (Plan ID at three digits), 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. get_snp_plan_details and get_enrollment read this view from 2026-10-05.

Grain

Key	Grain
N/A	1One row per (contract_id, plan_id, segment_id, snp_type, state_list_raw, report_month) for real rows and one per (snp_type, report_month) for Under-11 rows; 2195,628 rows over 233 months 2007-05..2026-09, 698 Under-11 rows, equal to medicare_silver.snp_data_v2 WHERE is_current row for row (Athena 0d8b8098, a97849fd).

Columns (30)

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

Query it

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

Item	Value
Typed tools that read it	get_stars_rollup
Identity key	`contract_id,plan_id,segment_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_snp_data_v3")`
Raw door	Tools: get_snp_plan_details, get_enrollment (SNP type); Athena: medicare_semantic.vw_snp_data_v3 (WHERE NOT synthetic_under_11_row for plans; pin report_month)
Note	Versioned view (Data Tracker wave 1A, defects SNPD-1/-3). Never overwritten; vw_snp_data_v2 stays live as the rollback.

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