# Medicaid managed-care plan quality (HEDIS) by plan, the parsed fact without the plan crosswalk

`medicare_silver.medicaid_plan_quality_measure_v1` · State programs · status partial · 5,696 rows

The parsed rates exactly as each state's report prints them (plan_name_raw, program_name_raw, measure_label_raw, sub_measure_raw, rate, rate_raw, rate_flags, denominator, data_source_raw, audited_flag) with lineage on every row. It carries no canonical plan id: read medicare_semantic.vw_medicaid_plan_quality_measure_v1, which joins the crosswalk.

**Grain.** One row per state x program x publisher plan name x measure x sub-measure x measurement year (5,696 rows, Athena a749fcd4).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| plan_name_raw | string |  |
| program_name_raw | string |  |
| measure_code | string |  |
| measure_label_raw | string |  |
| sub_measure_raw | string |  |
| indicator_code | string |  |
| measurement_year | int |  |
| rate | double |  |
| rate_raw | string |  |
| rate_flags | string |  |
| denominator | bigint |  |
| low_denominator | boolean |  |
| data_source_raw | string |  |
| audited_flag | boolean |  |
| 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_silver.medicaid_plan_quality_measure_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.medicaid_plan_quality_measure_v1")` first.