Hospital price transparency

States W6 Quality: state_quality_v1

vlada_curated.state_quality_v1·partial·silver

Rows

538,616

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1State product W6 (Quality) of the States lane: quality by entity (plans, hospitals, facilities) with its parent, every measure and rating status.
2One row per entity x program x measure x period.
3Filter quality_program and is_latest; rating_status and not_rated_reason explain a missing value, which is never zero.
48 state(s): CA FL GA IL NY OH PA TX.

Grain

Key	Grain
N/A	1Quality by entity (plans, hospitals, facilities) with its parent, every measure and rating status. 2538,616 rows (Athena, 2026-10-29). 3Period 2015-01-01 to 2026-10-08 (as_of).

Columns (34)

Column	Type	Meaning
`state_code`	string
`county_fips`	string
`line`	string
`entity_type`	string
`entity_id`	string
`entity_id_type`	string
`canonical_entity_id`	string
`canonical_id_source`	string
`entity_name`	string
`parent_id`	string
`parent_name`	string
`parent_source`	string
`parent_as_of`	string
`parent_status`	string
`quality_program`	string
`measure_code`	string
`measure_label`	string
`record_level`	string
`period_label`	string
`period_start`	date
`period_end`	date
`as_of`	date
`value_num`	double
`value_raw`	string
`value_unit`	string
`rating_status`	string
`not_rated_reason`	string
`is_latest`	boolean
`source_table`	string
`source_sha256`	string
`source_url`	string
`source_locator`	string
`row_key`	string
`build_id`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="vlada_curated.state_quality_v1")`
Raw door	Athena (read-only via query_substrate): vlada_curated.state_quality_v1 (filter state_code)
Company names	`parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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