# MA HEDIS measures (restated v2)

`medicare_silver.hedis_measures_v2` · Medicare Advantage, Part D, Medicaid · status live · 2,058,568 rows

A 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.** One row per (report_year, contract_id, measure_code, indicator_key); 0 duplicate keys per year. Rows = the v1 rows: 597,168 / 488,368 / 522,368 / 173,956 / 143,058 / 133,650 for 2019, 2021-2025.

| 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: `query_substrate` with `SELECT ... FROM medicare_silver.hedis_measures_v2 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.hedis_measures_v2")` first.