# States W5 Pricing coverage: state_pricing_coverage_v1

`vlada_curated.state_pricing_coverage_v1` · Hospital price transparency · status partial · 256,223 rows

State 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. One row per site x payer x price_kind; has_price false rows carry missing_reason and members_affected. This is coverage of our price holdings, never a price. 9 state(s): CA FL GA IL NC NY OH PA TX.

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

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