Curated datasets

Care-site × payer coverage aggregate

vlada_curated.agg_care_site_payer_coverage·live·mart

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

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

Grain

Key	Grain
N/A	1One row per (NPI, care_site_class, county, payer) — coverage + rate/contract shape.

Columns (10)

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

Query it

describe_data_source(source_fqn="vlada_curated.agg_care_site_payer_coverage")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.agg_care_site_payer_coverage WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	state_expert
Identity key	`npi`
Join	`how_to_join(source_fqn="vlada_curated.agg_care_site_payer_coverage")`
Raw door	Athena (read-only via query_substrate): vlada_curated.agg_care_site_payer_coverage

This page as markdown: /docs-md/data/vlada_curated_agg_care_site_payer_coverage.md · every page in one file: /llms-full.txt