# States W6 Quality: state_quality_v1

`vlada_curated.state_quality_v1` · Hospital price transparency · status partial · 538,616 rows

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

**Grain.** Quality by entity (plans, hospitals, facilities) with its parent, every measure and rating status. 538,616 rows (Athena, 2026-10-29). Period 2015-01-01 to 2026-10-08 (as_of).

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