Hospital price transparency

States W2 Facilities, ownership + finances: state_facility_v1

medicare_silver.state_facility_v1·partial·silver

Rows

239,616

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1State product W2 (Facilities, ownership + finances) of the States lane: every licensed facility in the state with its owner, chain, 340B status and latest cost report finances.
2One row per facility. facility_class separates hospitals, SNFs, labs and the rest; owner_status and cost_report_status say when the owner or finances are missing, never read a null margin as zero.
315 state(s): AZ CA FL GA IL MI NC NJ NY OH PA TN TX VA WA.

Grain

Key	Grain
N/A	1Every licensed facility in the state with its owner, chain, 340B status and latest cost report finances. 2239,616 rows (Athena, 2026-10-29). 3Period 2026-06-25 to 2026-10-18 (as_of).

Columns (48)

Column	Type	Meaning
`row_key`	string
`state_code`	string
`county_fips`	string
`county_basis`	string
`as_of`	date
`facility_id`	string
`facility_class`	string
`ccn`	string
`clia_number`	string
`enrollment_id`	string
`npi`	string
`facility_name`	string
`city`	string
`zip_code`	string
`lab_cert_type_cd`	string
`parent_ccn`	string
`fleet_canonical_site_id`	string
`fleet_status`	string
`roster_table`	string
`roster_sha256`	string
`roster_locator`	string
`owner_status`	string
`owner_basis`	string
`owner_org_name`	string
`chain_name`	string
`owner_count`	int
`is_private_equity`	boolean
`is_reit`	boolean
`ownership_since`	date
`ownership_last_change`	date
`ownership_as_of`	date
`ownership_sha256`	string
`ownership_locator`	string
`is_340b`	boolean
`id_340b`	string
`hrsa_sha256`	string
`hrsa_locator`	string
`cost_report_status`	string
`cost_report_fy`	int
`cost_report_rpt_rec_num`	string
`overall_ccr`	double
`ccr_fy`	int
`net_patient_revenue`	double
`operating_margin`	double
`total_margin`	double
`margin_status`	string
`cost_report_sha256`	string
`cost_report_locator`	string

Query it

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