# States W2 Facilities, ownership + finances: state_facility_v1

`medicare_silver.state_facility_v1` · Hospital price transparency · status partial · 239,616 rows

State 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. One 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. 15 state(s): AZ CA FL GA IL MI NC NJ NY OH PA TN TX VA WA.

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

| 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: `query_substrate` with `SELECT ... FROM medicare_silver.state_facility_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.state_facility_v1")` first.