PDP State/County Penetration
Provides PDP market penetration rates at the state/county level.
Part of the CMS Data Research Dataset › Part D
Dataplex delivers this CMS research table as the analysis-ready table DWV.PDP_STATE_COUNTY_PENETRATION on Snowflake — coverage from 2008 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.PDP_STATE_COUNTY_PENETRATION
Coverage
Jul 2008 – Jul 2026
Rows
696,546 (total across all reporting periods)
Cadence
Monthly
Update pattern
Time-partitioned — each file adds one reporting period
Latest report period
2026-07-01
Loaded
2026-07-16
Columns
13 data + 5 lineage
Identifiers
FIPS codes · SSA state/county codes
File versions
216
License
CMS public data — U.S. Government work
Platforms
Snowflake Marketplace
Included in the CMS Data Research Dataset — start a free trial on Snowflake Marketplace.
Current — data runs through the Jul 2026 report period. Next CMS release expected ~Aug 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
About this feed
Provides PDP market penetration rates at the state/county level.
— Source: CMS feed metadata
Theme: Part D
Coverage timeline
2008–2026 🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)
19 of 19 years covered — no gaps.
Release history
Data dictionary
📋 13 data columns + 5 lineage columns
Data columns
STATE_NAME
TEXT
COUNTY_NAME
TEXT
FIPSST
NUMBER
FIPSCNTY
NUMBER
FIPS
NUMBER
SSAST
NUMBER
SSACNTY
NUMBER
SSA
NUMBER
ELIGIBLES
TEXT
ENROLLED
TEXT
PENETRATION
TEXT
CHECK_PENETRATION
TEXT
DIFF_PENE
TEXT
Lineage columns (present on every feed table)
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 PDP State/County Penetration updated?
Monthly. CMS last published this feed on 2026-07-01, and Dataplex loaded it to the warehouse on 2026-07-16. New releases are added automatically when CMS publishes them.
What years does PDP State/County Penetration cover?
2008 through 2026.
How many records are in PDP State/County Penetration?
696,546 rows across all 216 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 PDP State/County Penetration data?
It's included in the CMS Data Research Dataset on the Snowflake Marketplace (free trial available). Once mounted, query DWV.PDP_STATE_COUNTY_PENETRATION directly — no pipeline setup required.
Related feeds
PDP Contract Service AreaPDP Enrollment by SCCPDP Enrollment by SCPGet this feed
Mount the share — the database and
DWVschema appear in your account immediatelyRun 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