# CMS provider and clinician state quality distributions

`medicare_semantic.vw_state_quality_rollup` · Medicare Advantage, Part D, Medicaid · status live · 259,838 rows

Explicitly Vlada-derived unweighted state distributions across 12 certified CMS quality families covering hospitals, QPP/MIPS clinicians or groups, nursing homes, home health, hospice, dialysis facilities, and ESRD QIP.

**Grain.** One row per source, provider-location state, reporting-period type, reporting period, and measure.

| column | type | meaning |
|---|---|---|
| source_id | varchar(32) |  |
| source_table | varchar(45) |  |
| state_code | varchar(2) |  |
| state_name | varchar(24) |  |
| geography_basis | varchar(17) |  |
| entity_type | varchar(18) |  |
| reporting_period_type | varchar(20) |  |
| reporting_period | string |  |
| measure_id | string |  |
| measure_name | string |  |
| measure_unit | varchar(21) |  |
| aggregation_method | varchar(52) |  |
| mean_value | double |  |
| median_value | double |  |
| minimum_value | double |  |
| maximum_value | double |  |
| source_record_count | bigint |  |
| distinct_entity_count | bigint |  |
| observed_record_count | bigint |  |
| missing_record_count | bigint |  |
| measurement_period_start | string |  |
| measurement_period_end | string |  |
| source_asserted_at | date |  |
| is_publisher_native_state_measure | boolean |  |
| weighting_and_missingness_rule | varchar(113) |  |

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