# Publisher-native state quality measures

`medicare_semantic.vw_state_quality_publisher` · Medicare Advantage, Part D, Medicaid · status live · 596,762 rows

Governed standard view over AHRQ NHQDR estimates, CMS Medicaid/CHIP Child and Adult Core Set state rates, Medicaid Health Home program quality cells, and CDC NHSN state HAI progress ratios, preserving raw values, sentinels, methodology, setting, ratio type, physical publisher-observation identity, and exact atomic lineage.

**Grain.** One row per publisher, state, reporting year, program/population/methodology, and measure observation.

| column | type | meaning |
|---|---|---|
| source_id | varchar(32) |  |
| source_table | varchar(49) |  |
| state_code | string |  |
| state_name_raw | string |  |
| reporting_year | int |  |
| program | string |  |
| measure_id | string |  |
| measure_name | string |  |
| population | string |  |
| methodology | string |  |
| rate_definition | string |  |
| measure_value | double |  |
| measure_value_raw | string |  |
| measure_value_status | string |  |
| facility_setting | string |  |
| ratio_type | string |  |
| benchmark_used | boolean |  |
| observed_period | date |  |
| asserted_at | date |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_observation_key | string |  |
| is_publisher_native_state_measure | boolean |  |

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