# MA contract service area (revision 2)

`medicare_silver.ma_contract_service_area_v2` · Medicare Advantage, Part D, Medicaid · status live · 89,865,222 rows

Which counties each MA contract serves each month, from CMS's monthly contract service area file, with organization_name, plan_type, the EGHP (employer-only) flag and the partial-county flag as CMS prints them, and national_service_area for nationwide contracts (National PACE and similar).

**Grain.** One row per (contract_id, county, flag variant) per month: 89,865,222 rows in 239 months. A contract-county CMS splits across flag values appears on more than one row (3,788 split rows); national service-area rows have no county or state.

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| county_fips | string |  |
| county_ssa | string |  |
| state_code | string |  |
| report_month | date |  |
| organization_name_raw | string |  |
| organization_type | string |  |
| plan_type | string |  |
| partial_county | boolean |  |
| eghp | boolean |  |
| county_name_raw | string |  |
| notes_raw | string |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| national_service_area | boolean |  |

Tools that read it: get_contract_service_area

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