Medicare Advantage, Part D, Medicaid

Vlada benefit reading, each contract's closest contracts by footprint (edition v20261018b)

medicare_semantic.vw_benefit_contract_match·live·mart

Rows

15,180

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1For each contract, product type and plan type: the other contracts with the same product and plan type and shared counties, ranked by the member-weighted county Jaccard (SUM(min) / SUM(max)); floors: 1,000 shared-county members on side A and a Jaccard of 0.05. overlap_share_a / _b = each side's members in the shared counties.
2Pointer -> medicare_semantic.benefit_contract_match_v20261018b.
3Owner: the Benefits lane.

Grain

Key	Grain
N/A	1One row per base_year x bucket x plan_type x contract_id x match_contract_id (top 10).

Columns (18)

Column	Type	Meaning
`base_year`	int
`bucket`	string
`plan_type`	string
`contract_id`	string
`parent_a`	string
`match_contract_id`	string
`parent_b`	string
`members_a`	double
`members_b`	double
`counties_a`	bigint
`counties_b`	bigint
`shared_counties`	bigint
`shared_a`	double
`shared_b`	double
`overlap_share_a`	double
`overlap_share_b`	double
`jaccard`	double
`match_rank`	bigint

Query it

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

Item	Value
Typed tools that read it	get_benefit_change
Identity key	`base_year,bucket,plan_type,contract_id,match_contract_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_benefit_contract_match")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_benefit_contract_match

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