VladaOmega
Sign inStart free
Medicare Advantage, Part D, Medicaid

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

medicare_silver.ma_network_contract_group_v1·partial·mart
Rows
N/A
Columns
8
History
N/A
Card
nocolumns only
Typed tools
1

What it is

  1. 1The 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).
  2. 22027: 4.22M contract x group rows (192K groups), 155.6K contract x system rows (643 systems).
  3. 3Typed door get_network_groups.

Grain

KeyGrain
N/A
  1. 1One 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.
  2. 2Partitioned by dataset_id, plan_year.

Columns (8)

ColumnTypeMeaning
contract_idstring
rollup_levelstring
entity_keystring
entity_namestring
entity_statestring
clinicians_listedbigint
entity_cliniciansbigint
share_listeddouble

Query it

describe_data_source(source_fqn="medicare_silver.ma_network_contract_group_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ma_network_contract_group_v1 WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itget_network_groups
Identity keycontract_id
Joinhow_to_join(source_fqn="medicare_silver.ma_network_contract_group_v1")
Raw doorAthena (read-only via query_substrate): medicare_silver.ma_network_contract_group_v1 (pin dataset_id and plan_year; filter rollup_level; read share_listed with entity_clinicians)

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