# MA network intelligence: each contract's network by billing group and health system (share of each listed)

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

The network lockdown's N3: a contract's listed clinicians rolled up to the billing groups they reassign Medicare payment to (CMS PECOS reassignment) and the health systems of their hospitals (CMS Doctors and Clinicians affiliation x the hospital system map). 2027: 4.22M contract x group rows (192K groups), 155.6K contract x system rows (643 systems). Typed door get_network_groups.

**Grain.** One row per plan_year x contract_id x rollup_level (group | system) x entity_key: entity_name, entity_state, clinicians_listed, entity_clinicians, share_listed. Partitioned by dataset_id, plan_year.

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| rollup_level | string |  |
| entity_key | string |  |
| entity_name | string |  |
| entity_state | string |  |
| clinicians_listed | bigint |  |
| entity_clinicians | bigint |  |
| share_listed | double |  |

Tools that read it: get_network_groups

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