Medicare Advantage, Part D, Medicaid

Publisher-native state quality measures

medicare_semantic.vw_state_quality_publisher·live·semantic_view

Rows

596,762

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

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

Key	Grain
N/A	1One row per publisher, state, reporting year, program/population/methodology, and measure observation.

Columns (23)

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

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

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

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