Curated datasets

County × payer landscape aggregate

vlada_curated.agg_county_payer_landscape·live·mart·Medicare Advantage & Part D Plan Landscape

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Per county and payer, the hospital MRF coverage (hospital_mrf_rows) + status.
2A coverage map of which payers have hospital pricing in each county.

Grain

Key	Grain
N/A	1One row per (county_fips, payer_id) — hospital MRF row count + status.

Columns (5)

Column	Type	Meaning
`county_fips`	string
`payer_id`	string
`hospital_mrf_rows`	bigint
`status`	string
`vintage`	date

Query it

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

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

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