Medicare Advantage, Part D, Medicaid

CMS provider and clinician state quality distributions

medicare_semantic.vw_state_quality_rollup·live·semantic_view

Rows

259,838

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Explicitly 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

Key	Grain
N/A	1One row per source, provider-location state, reporting-period type, reporting period, and measure.

Columns (25)

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

describe_data_source(source_fqn="medicare_semantic.vw_state_quality_rollup")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_state_quality_rollup WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`source_id,state_code,reporting_period_type,reporting_period,measure_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_state_quality_rollup")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_state_quality_rollup

This page as markdown: /docs-md/data/medicare_semantic_vw_state_quality_rollup.md · every page in one file: /llms-full.txt