Medicare Advantage, Part D, Medicaid

SNP HEDIS risk-adjusted utilization (plan x indicator), 2021-2025

medicare_silver.snp_hedis_rau_measures·live·silver

Rows

52,668

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Risk-adjusted utilization measures per SNP plan (e.g. plan all-cause readmissions): denominator, member and outlier counts, observed and expected counts and the variance, 2021 onward.
22025: 12,636 rows.

Grain

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

Columns (20)

Column	Type	Meaning
`contract_id`	string
`plan_id`	string
`measure_code`	string
`indicator_key`	string
`denominator`	double
`member_count`	double
`outlier_member_count`	double
`observed_count`	double
`expected_count`	double
`count_variance`	double
`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_rau_measures")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.snp_hedis_rau_measures WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id,plan_id,measure_code,indicator_key,report_year`
Join	`how_to_join(source_fqn="medicare_silver.snp_hedis_rau_measures")`
Raw door	Athena (read-only via query_substrate): medicare_silver.snp_hedis_rau_measures
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_rau_measures.md · every page in one file: /llms-full.txt