# States W3 Networks + affiliations: state_affiliation_edge_v1

`vlada_curated.state_affiliation_edge_v1` · Hospital price transparency · status partial · 7,013,685 rows

State product W3 (Networks + affiliations) of the States lane: affiliation edges: which clinician, group or facility belongs to which system, dated, with evidence. One row per child -> parent edge (child_kind, parent_kind, edge_type) with first_seen / last_seen; filter state_code. last_seen is the last file the edge appeared in, not an end date. 5 state(s): CA FL NY PA TX.

**Grain.** Affiliation edges: which clinician, group or facility belongs to which system, dated, with evidence. 7,013,685 rows (Athena, 2026-10-29). Period 2016-08-30 to 2026-10-29 (as_of).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| county_fips | string |  |
| period | string |  |
| as_of | string |  |
| child_kind | varchar(12) |  |
| child_id | string |  |
| parent_kind | varchar(12) |  |
| parent_id | string |  |
| edge_type | string |  |
| first_seen | string |  |
| last_seen | string |  |
| effective_start | string |  |
| effective_end | string |  |
| evidence_type | varchar(33) |  |
| evidence_table | varchar(64) |  |
| source_sha256 | string |  |
| source_locator | string |  |
| source_url | string |  |
| source_row_key | string |  |
| review_status | varchar(34) |  |
| child_name | string |  |
| parent_name | string |  |
| canonical_parent_system | string |  |
| facility_type | string |  |
| w2_facility_id | string |  |
| w2_facility_class | string |  |

Query it: `query_substrate` with `SELECT ... FROM vlada_curated.state_affiliation_edge_v1 WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.state_affiliation_edge_v1")` first.