Medicare Advantage, Part D, Medicaid

MA HEDIS measures (restated v2)

medicare_silver.hedis_measures_v2·live·silver·Medicare Advantage HEDIS Quality

Rows

2,058,568

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1A contract's reported HEDIS rate per measure and indicator, with LCL/UCL, denominator, numerator, eligible population (2025) and member count (2024+), from the CMS MA HEDIS PUF hedis_measures sheet. numerator/denominator are double: in 2019 the risk-adjusted utilization rows carry fractional observed/expected counts there. rate_raw is the publisher's Rate cell verbatim (NB, NR, NA, BR status codes where rate is NULL).

Grain

Key	Grain
N/A	1One row per (report_year, contract_id, measure_code, indicator_key); 20 duplicate keys per year. 3Rows = the v1 rows: 597,168 / 488,368 / 522,368 / 173,956 / 143,058 / 133,650 for 2019, 2021-2025.

Columns (21)

Column	Type	Meaning
`contract_id`	string
`measure_code`	string
`indicator_key`	string
`rate`	double
`rate_raw`	string
`lcl`	double
`ucl`	double
`denominator`	double
`numerator`	double
`eligible_population`	int
`member_count`	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.hedis_measures_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.hedis_measures_v2 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id`
Join	`how_to_join(source_fqn="medicare_silver.hedis_measures_v2")`
Raw door	Athena (read-only via query_substrate): medicare_silver.hedis_measures_v2
Note	Restated v2 (HEDIS-fix lane 2026-09-29); supersedes medicare_silver.hedis_measures. Never overwritten; a changed schema is a new version.

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