Benefits Data - Plan Service Area (Region)

Region-level service area for Regional MA and PDP contracts, keyed on the three-part plan key (contract_id, plan_id, segment_id).

Part of the CMS Data Research Dataset › Plan Benefits

Dataplex delivers this CMS research table as the analysis-ready table DWV.BENEFITS_DATA__PLAN_REGION_AREA on Snowflake and Databricks: coverage from 2006 to 2026 in a single aligned schema, refreshed automatically whenever CMS publishes a new file. Every row carries lineage back to the exact CMS source file that produced it.

Key facts

Snowflake	DWV.BENEFITS_DATA__PLAN_REGION_AREA
Databricks	cms_research_dwv.benefits_data__plan_region_area
Coverage	Jan 2006 – Jan 2026
Rows	310,630 (total across all reporting periods)
Update pattern	Time-partitioned; each file adds one reporting period
Latest report period	2026-01-01
Loaded	2026-08-12
Columns	16 data + 5 lineage
Identifiers	Contract ID (H-number) · Plan ID
File versions	32
License	CMS public data (U.S. Government work)
Platforms	Snowflake Marketplace · Databricks Delta Sharing

Included in the CMS Data Research Dataset, start a free trial on Snowflake Marketplace.

Current: data runs through the Jan 2026 report period. Next CMS release expected ~Oct 2026.

Partitioned by report period: each file version covers one report period and history is additive. The sample query below returns the latest report period; drop the WHERE clause to query the full history.

Sample queries

Snowflake

-- Latest report period only (drop the WHERE clause for the full history)
SELECT *
FROM DWV.BENEFITS_DATA__PLAN_REGION_AREA
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

Databricks

-- Latest report period only (drop the WHERE clause for the full history)
SELECT *
FROM cms_research_dwv.benefits_data__plan_region_area
WHERE file_id IN (
  SELECT id FROM cms_research_dwv.feeds_files WHERE is_latest = 1
)
LIMIT 100;

About this feed

Region-level service area for Regional MA and PDP contracts, keyed on the three-part plan key (contract_id, plan_id, segment_id). One row per plan per MA or PDP region, with region type, region code and region name, contract year, eghp_flag identifying employer group health plans, and pending/partial flags. Complements the Plan Service Area (County) feed, which does not carry R and S contracts

Source: CMS feed metadata

Theme: Plan Benefits

Coverage timeline

2006–2026 🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)

21 of 21 years covered, no gaps.

Release history

Report period	Files	Loaded	Latest	CMS source
2026-01-01	1	2026-08-12	✓	source ↗
2025-01-01	1	2026-08-12		source ↗
2024-10-01	1	2026-08-12		source ↗
2024-07-01	1	2026-08-12		source ↗
2024-01-01	1	2026-08-12		source ↗
2023-10-01	1	2026-08-12		source ↗
2023-07-01	1	2026-08-12		source ↗
2023-04-01	1	2026-08-12		source ↗
2023-01-01	1	2026-08-12		source ↗
2022-04-01	1	2026-08-12		source ↗

Show 22 earlier report periods

Report period	Files	Loaded	Latest	CMS source
2022-01-01	1	2026-08-12		source ↗
2021-10-01	1	2026-08-12		source ↗
2021-04-01	1	2026-08-12		source ↗
2021-02-01	1	2026-08-12		source ↗
2021-01-01	1	2026-08-12		source ↗
2020-10-01	1	2026-08-12		source ↗
2020-04-01	1	2026-08-12		source ↗
2020-01-01	1	2026-08-12		source ↗
2019-01-01	1	2026-08-12		source ↗
2018-01-01	1	2026-08-12		source ↗
2017-01-01	1	2026-08-12		source ↗
2016-01-01	1	2026-08-12		source ↗
2015-01-01	1	2026-08-12		source ↗
2014-01-01	1	2026-08-12		source ↗
2013-01-01	1	2026-08-12		source ↗
2012-01-01	1	2026-08-12		source ↗
2011-01-01	1	2026-08-12		source ↗
2010-01-01	1	2026-08-12		source ↗
2009-01-01	1	2026-08-12		source ↗
2008-01-01	1	2026-08-12		source ↗
2007-01-01	1	2026-08-12		source ↗
2006-01-01	1	2026-08-12		source ↗

Data dictionary

📋 16 data columns + 5 lineage columns

Data columns

Column	Type
PBP_A_HNUMBER	TEXT
PBP_A_PLAN_IDENTIFIER	NUMBER
SEGMENT_ID	NUMBER
PBP_A_BEN_COV	NUMBER
PBP_A_PLAN_TYPE	NUMBER
ORGTYPE	NUMBER
BID_ID	TEXT
CONTRACT_ID	TEXT
PLAN_ID	NUMBER
PENDING_FLAG	NUMBER
PARTIAL_FLAG	TEXT
CONTRACT_YEAR	NUMBER
EGHP_FLAG	NUMBER
REGION_TYPE	TEXT
MA_OR_PDP_REGION_CODE	TEXT
REGION	TEXT

Lineage columns (present on every feed table)

Column	Type	Description
ROW_ID	TEXT	Unique row ID for this table (PK)
FILE_ID	TEXT	Source file; joins to FEEDS_FILES.ID (FK)
FILE_FEED_ID	TEXT	Parent feed; joins to FEEDS.ID (FK)
FILE_NAME	TEXT	Source file name as published by CMS
ROWNUM	NUMBER	Row number within the source file

Row-level lineage

Every row in this table traces to the exact CMS source file that produced it. The FILE_ID column joins to the FEEDS_FILES catalog table, and FILE_FEED_ID joins to the FEEDS master table:

Trace any row back to its source file and reporting period:

Snowflake

SELECT d.PBP_A_HNUMBER, d.PBP_A_PLAN_IDENTIFIER, d.SEGMENT_ID,
       ff.FILE_REPORT_PERIOD AS TEMPORAL_START, ff.FILE_REPORT_PERIOD AS TEMPORAL_END
FROM DWV.BENEFITS_DATA__PLAN_REGION_AREA d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Databricks

SELECT d.pbp_a_hnumber, d.pbp_a_plan_identifier, d.segment_id,
       ff.file_report_period AS temporal_start, ff.file_report_period AS temporal_end
FROM cms_research_dwv.benefits_data__plan_region_area d
JOIN cms_research_dwv.feeds_files ff ON d.file_id = ff.id;

Source & provenance

Published by the Centers for Medicare & Medicaid Services.

• Official CMS documentation (MA/Part D contract and enrollment data)

• Latest source file from CMS (zip)

Frequently asked questions

How often is Benefits Data - Plan Service Area (Region) updated?

CMS last published this feed on 2026-01-01. New releases are added automatically when CMS publishes them.

What years does Benefits Data - Plan Service Area (Region) cover?

2006 through 2026.

How many records are in Benefits Data - Plan Service Area (Region)?

310,630 rows across all 32 report periods. Because this feed is partitioned by report period, the full table total is the meaningful count; no deduplication needed.

How do I get Benefits Data - Plan Service Area (Region) data?

It's included in the CMS Data Research Dataset on the Snowflake Marketplace (free trial available). Once mounted, query DWV.BENEFITS_DATA__PLAN_REGION_AREA directly; no pipeline setup required.

Related feeds

Benefits Data - Plan Service Area (County)Benefits Data - Premiums & DeductiblesBenefits Data - Part D Drug CoverageBenefits Data - Inpatient Hospital (Acute)Benefits Data - Covered Services

Get this feed

1. Start a free trial on Snowflake Marketplace

2. Mount the share; the database and DWV schema appear in your account immediately

3. Run the sample query above; no ETL, no pipeline maintenance

Questions about this feed? Contact us at [e-mail].

---

Part of the CMS Data Research Dataset; 22 research tables · 20 years of Medicare Advantage & Part D history · updated daily. Back to the full catalog →