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

`medicare_silver.ma_network_plan_county_v1` · Medicare Advantage, Part D, Medicaid · status partial

How 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. Typed door get_network_breadth.

**Grain.** One 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. Partitioned by dataset_id, plan_year.

| 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 |  |

Tools that read it: get_network_breadth

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.ma_network_plan_county_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.ma_network_plan_county_v1")` first.