Curated datasets

State × payer roster aggregate

vlada_curated.agg_state_payer_roster·live·mart

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Per state and payer, coverage counts (ct_hospitals, mrf_rows), in_rds/built flags, and a recommended action.
2The operator-facing roster of payer coverage + what to build next per state.

Grain

Key	Grain
N/A	1One row per (state, payer_id) — coverage + build/action status.

Columns (8)

Column	Type	Meaning
`state`	string
`payer_id`	string
`ct_hospitals`	int
`mrf_rows`	bigint
`in_rds`	boolean
`built`	boolean
`action`	string
`vintage`	date

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`state`
Join	`how_to_join(source_fqn="vlada_curated.agg_state_payer_roster")`
Raw door	Athena (read-only via query_substrate): vlada_curated.agg_state_payer_roster

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