Medicare Advantage, Part D, Medicaid

SNP HEDIS general file (plan x report year), 2019-2025

medicare_silver.snp_hedis_general·live·silver

Rows

4,936

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1One row per SNP plan (contract x PBP) per report year: organization and plan type, SNP type, plan and contract enrollment, region, patient population, Part D and EGWP flags.
22025: 1,054 plans (708 Dual-Eligible, 228 Chronic, 118 Institutional) with 6,215,762 members.

Grain

Key	Grain
N/A	1One row per (contract_id, plan_id, report_year).

Columns (31)

Column	Type	Meaning
`contract_id`	string
`contract_name_raw`	string
`organization_type`	string
`plan_type`	string
`contract_offers_snp`	string
`contract_offers_part_d`	string
`contract_enrollment`	int
`region`	string
`region_name`	string
`patient_population`	string
`plan_id`	string
`plan_name_raw`	string
`plan_is_snp`	string
`snp_type`	string
`plan_offers_part_d`	string
`plan_is_egwp`	string
`contract_non_snp_plan_count`	int
`contract_snp_plan_count`	int
`contract_plan_count`	int
`contract_all_plans_snp`	string
`plan_enrollment`	int
`report_year`	int
`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_silver.snp_hedis_general")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.snp_hedis_general WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id,plan_id,report_year`
Join	`how_to_join(source_fqn="medicare_silver.snp_hedis_general")`
Raw door	Athena (read-only via query_substrate): medicare_silver.snp_hedis_general
Note	Register source cms_snp_hedis_puf (w3, serve raw). RAW. Loaded 2026-09-29 (verify_tracker_loads PASS 2026-09-30 for all four tables: general 4,936, service area 124,273, measures 211,299, RAU 52,668 rows; 0 duplicate keys; Athena d363fb91, fcad559b, 4404b749, 0a8f9699). Cell reconciliation PASS on 2019, 2021, 2024 and 2025 including the documentation-code check (every General-00xx code read against that year's PUF documentation). Registered 2026-09-30.

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