Medicare Advantage, Part D, Medicaid

MA network intelligence: network breadth per plan x county x specialty vs the county's rivals

medicare_silver.ma_network_plan_county_v1·partial·mart

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1How broad each MA plan's published network is in every county of its CMS service area against the other plans sold there: the providers it lists in the county over every provider any MA plan lists there (the listed universe), ranked among the county's individual plans.
2Typed door get_network_breadth.

Grain

Key	Grain
N/A	1One row per plan_year x plan_key x county_fips x specialty ('*' = every provider): plan_npis, county_npis (the county's listed universe), breadth, rank_in_county, plans_ranked, plans_offered, rival_median_breadth, rival_max_breadth, matched_share, carried_share, contract_level_share, employer_plan. 2Partitioned by dataset_id, plan_year.

Columns (21)

Column	Type	Meaning
`plan_key`	string
`contract_id`	string
`employer_plan`	boolean
`county_fips`	string
`state`	string
`county_name`	string
`specialty`	string
`adequacy_type`	boolean
`plan_npis`	bigint
`county_npis`	bigint
`breadth`	double
`rank_in_county`	bigint
`plans_ranked`	bigint
`plans_offered`	bigint
`rival_median_breadth`	double
`rival_max_breadth`	double
`matched_share`	double
`carried_share`	double
`contract_level_share`	double
`billing_type_npis`	bigint
`verified_share`	double

Query it

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

Item	Value
Typed tools that read it	get_network_breadth
Identity key	`plan_key`
Join	`how_to_join(source_fqn="medicare_silver.ma_network_plan_county_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ma_network_plan_county_v1 (pin dataset_id and plan_year; filter specialty ('*' for all) and county_fips or contract_id)

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