Hospital price transparency

States W5 Pricing coverage: state_pricing_coverage_v1

vlada_curated.state_pricing_coverage_v1·partial·silver

Rows

256,223

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1State product W5 (Pricing coverage) of the States lane: pricing coverage: for each site x payer, whether we hold a negotiated price, why not, and the members a gap affects.
2One row per site x payer x price_kind; has_price false rows carry missing_reason and members_affected.
3This is coverage of our price holdings, never a price.
49 state(s): CA FL GA IL NC NY OH PA TX.

Grain

Key	Grain
N/A	1Pricing coverage: for each site x payer, whether we hold a negotiated price, why not, and the members a gap affects. 2256,223 rows (Athena, 2026-10-29). 3Period 2026-10-28 to 2026-10-29 (as_of).

Columns (31)

Column	Type	Meaning
`row_key`	string
`state_code`	string
`county_fips`	string
`county_name`	string
`period`	string
`as_of`	date
`canonical_site_id`	string
`npi`	string
`ccn`	string
`legal_name`	string
`care_site_class`	string
`site_parent_system`	string
`site_parent_as_of`	string
`payer_id`	string
`payer_name`	string
`payer_parent_as_of`	string
`price_kind`	string
`has_price`	boolean
`missing_reason`	string
`lines_of_business`	string
`n_rates`	bigint
`detail`	string
`source_table`	string
`source_version`	string
`source_sha256`	string
`source_locator`	string
`members_affected`	bigint
`gap_rank`	int
`members_basis`	string
`members_source_sha256`	string
`members_locator`	string

Query it

describe_data_source(source_fqn="vlada_curated.state_pricing_coverage_v1")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.state_pricing_coverage_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_pricing_coverage_v1")`
Raw door	Athena (read-only via query_substrate): vlada_curated.state_pricing_coverage_v1 (filter state_code)
Company names	`payer_name` `payer_parent_as_of` 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_pricing_coverage_v1.md · every page in one file: /llms-full.txt