# MA network intelligence: active grade per listed provider (Medicare billing and enrollment)

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

The network lockdown's active check (docs/data-tracker/network-intel/LOCKDOWN-LEDGER.md N1): whether Medicare's own files confirm a listed provider is active. 2027: 1,570,066 billing-type providers, A 52.9%, B 39.8%, C 7.4%.

**Grain.** One row per plan_year x listed NPI: provider_class, specialty, enrolled_medicare (PECOS), billed_medicare_year (CMS billing file), contracts_listing, medicare_billing_type, active_grade (A billed Medicare in the newest year, B enrolled only, C neither, n/a a type that does not bill Medicare). Partitioned by dataset_id, plan_year.

| column | type | meaning |
|---|---|---|
| npi | string |  |
| provider_class | string |  |
| specialty | string |  |
| enrolled_medicare | boolean |  |
| billed_medicare_year | int |  |
| contracts_listing | bigint |  |
| medicare_billing_type | boolean |  |
| active_grade | string |  |

Tools that read it: get_plan_network

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