# Medicaid managed-care plan quality (HEDIS) by plan, 15 states, the newest three measurement years each publishes

`medicare_semantic.vw_medicaid_plan_quality_measure_v1` · State programs · status partial · 5,696 rows

Ten fixed HEDIS measures (W30, WCV, CIS10, PPC_PRE, PPC_POST, CBP, HBA1C_LT8, BCS, FUH7, FUM7) by Medicaid managed-care plan for 15 states (TX NY CA FL PA OH IL MI NC GA WA NJ AZ VA KY), as each state and its EQRO publish them: the fact (medicare_silver.medicaid_plan_quality_measure_v1) LEFT JOIN the plan crosswalk, so every row carries the canonical medicaid_plan_id, plan_product, plan_display_name, program_class and parent_name. Plan names stay as printed. rate is 0-1; a cell the publisher prints without a rate (NA, N/A, NR, a dash, See footnote, blank) is a row with NULL rate and the marker in rate_raw, never a zero.

**Grain.** One row per state x program x publisher plan name x measure x sub-measure x measurement year; (medicaid_plan_id, plan_product, indicator_code, measurement_year) is unique: 5,696 rows = 5,696 keys (Athena 0e9266f8, 3f142481).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| program_name_raw | string |  |
| plan_name_raw | string |  |
| measure_code | string |  |
| indicator_code | string |  |
| measure_label_raw | string |  |
| sub_measure_raw | string |  |
| measurement_year | int |  |
| rate | double |  |
| rate_raw | string |  |
| rate_flags | string |  |
| denominator | bigint |  |
| low_denominator | boolean |  |
| data_source_raw | string |  |
| audited_flag | boolean |  |
| medicaid_plan_id | string |  |
| plan_product | string |  |
| plan_display_name | string |  |
| program_class | string |  |
| parent_name | string |  |
| plan_id_match_method | string |  |
| document_url | string |  |
| sha256_content_hash | string |  |
| evidence_locator | string |  |
| parse_revision | string |  |
| semantic_row_sha256 | string |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_medicaid_plan_quality_measure_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_medicaid_plan_quality_measure_v1")` first.