For the complete documentation index, see llms.txt. This page is also available as Markdown.

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.

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

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

2025-01-01

1

2026-08-12

2024-10-01

1

2026-08-12

2024-07-01

1

2026-08-12

2024-01-01

1

2026-08-12

2023-10-01

1

2026-08-12

2023-07-01

1

2026-08-12

2023-04-01

1

2026-08-12

2023-01-01

1

2026-08-12

2022-04-01

1

2026-08-12

Show 22 earlier report periods
Report period
Files
Loaded
Latest
CMS source

2022-01-01

1

2026-08-12

2021-10-01

1

2026-08-12

2021-04-01

1

2026-08-12

2021-02-01

1

2026-08-12

2021-01-01

1

2026-08-12

2020-10-01

1

2026-08-12

2020-04-01

1

2026-08-12

2020-01-01

1

2026-08-12

2019-01-01

1

2026-08-12

2018-01-01

1

2026-08-12

2017-01-01

1

2026-08-12

2016-01-01

1

2026-08-12

2015-01-01

1

2026-08-12

2014-01-01

1

2026-08-12

2013-01-01

1

2026-08-12

2012-01-01

1

2026-08-12

2011-01-01

1

2026-08-12

2010-01-01

1

2026-08-12

2009-01-01

1

2026-08-12

2008-01-01

1

2026-08-12

2007-01-01

1

2026-08-12

2006-01-01

1

2026-08-12

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:

Source & provenance

Published by the Centers for Medicare & Medicaid Services.

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.

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. Mount the share; the database and DWV schema appear in your account immediately

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

Questions about this feed? Contact us at notifications@dataplex-consulting.com.


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 →

Last updated