# Care-site × payer coverage aggregate

`vlada_curated.agg_care_site_payer_coverage` · Curated datasets · status live

Aggregate of which payers have rates for each care site: NPI × class × county × payer with resolved flag, provider_group_count, rate_count, contract_shape. Backs county payer-coverage answers + the pricing flywheel.

**Grain.** One row per (NPI, care_site_class, county, payer) — coverage + rate/contract shape.

| column | type | meaning |
|---|---|---|
| npi | string |  |
| care_site_class | string |  |
| county_fips | string |  |
| payer_id | string |  |
| resolved | boolean |  |
| provider_group_count | int |  |
| rate_count | int |  |
| contract_shape | string |  |
| vintage | date |  |
| source | string |  |

Tools that read it: state_expert

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