Part D Prescription Drug Coverage - Landscape - All Plan Types

Comprehensive landscape source data for all Medicare Part D plan types including MA, PDP, SNP, MMP, compliance reports, and premium data

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.PART_D_PRESCRIPTION_DRUG_COVERAGE__LANDSCAPE__ALL_PLAN_TYPES on Snowflake and Databricks — three snapshot releases spanning 2025–2026, aligned to a single 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.PART_D_PRESCRIPTION_DRUG_COVERAGE__LANDSCAPE__ALL_PLAN_TYPES
Databricks	cms_dwv.part_d_prescription_drug_coverage__landscape__all_plan_types
Update pattern	Full-refresh — each file replaces the prior snapshot
CMS published	2026-01-01
Loaded	2026-03-10
Columns	54 data + 6 lineage
File versions	3
License	CMS public data — U.S. Government work
Platforms	Snowflake Marketplace · Databricks Delta Sharing

Included in the CMS Data Feeds Dataset — start a free trial on Snowflake Marketplace.

Current — CMS last published this feed on 2026-01-01. Coverage runs through 2026-01-01. Next CMS release expected ~Dec 2026.

Full-refresh feed — each file version is a complete snapshot and newer files supersede older ones. Filter to the latest file (see the sample query) to avoid double-counting across versions.

Sample queries

Snowflake

-- Latest snapshot only (avoids double-counting across file versions)
SELECT *
FROM DWV.PART_D_PRESCRIPTION_DRUG_COVERAGE__LANDSCAPE__ALL_PLAN_TYPES
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

Databricks

About this feed

Comprehensive landscape source data for all Medicare Part D plan types including MA, PDP, SNP, MMP, compliance reports, and premium data

— Source: CMS feed metadata

Keywords: Medicare, Part D Prescription Drug Coverage - Landscape - All Plan Types Theme: Medicare

Coverage timeline

2025 🟩 · 2026 🟩

2 of 2 years with snapshot releases — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2026-01-01	2026-01-01	2026-03-10	✓
Snapshot as of 2026-01-01	2026-01-01	2026-03-02
Snapshot as of 2025-01-01	2025-01-01	2025-08-27

Data dictionary

📋 54 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Part D Prescription Drug Coverage - Landscape - All Plan Types data dictionary.

Data columns

Column	Type
__CONTRACT_YEAR	NUMBER
CONTRACT_CATEGORY_TYPE	TEXT
US_TERRITORY	BOOLEAN
STATE_TERRITORY_ABBREVIATION	TEXT
STATE_TERRITORY_NAME	TEXT
COUNTY_NAME	TEXT
CONTRACT_ID	TEXT
PLAN_ID	NUMBER
SEGMENT_ID	NUMBER
CONTRACTPLANID	TEXT
CONTRACTPLANSEGMENTID	TEXT
SANCTIONED_PLAN	BOOLEAN
PARENT_ORGANIZATION_NAME	TEXT
CONTRACT_NAME	TEXT
ORGANIZATION_MARKETING_NAME	TEXT
ORGANIZATION_TYPE	TEXT
PLAN_NAME	TEXT
PLAN_TYPE	TEXT
SPECIAL_NEEDS_PLAN_SNP_INDICATOR	BOOLEAN
SNP_TYPE	TEXT
SNP_INSTITUTIONAL_TYPE	TEXT
SNP_INSTITUTIONAL_CATEGORY	TEXT
DUAL_ELIGIBLE_SNP_D_SNP_INTEGRATION_STATUS	TEXT
D_SNP_APPLICABLE_INTEGRATED_PLAN_AIP_IDENTIFIER	TEXT
CHRONIC_OR_DISABLING_CONDITION_SNP_C_SNP_CONDITION_TYPE	TEXT
MEDICARE_ZERO_DOLLAR_COST_SHARING_D_SNP_PLAN	TEXT
PART_D_COVERAGE_INDICATOR	BOOLEAN
NATIONAL_PDP	TEXT
DRUG_BENEFIT_CATEGORY	TEXT
DRUG_BENEFIT_TYPE	TEXT
VOLUNTARY_DE_MINIMIS_PROGRAM_PARTICIPANT	BOOLEAN
PART_D_BASIC_PREMIUM_AT_OR_BELOW_REGIONAL_BENCHMARK	TEXT
LOW_INCOME_SUBSIDY_LIS_AUTO_ENROLLMENT	TEXT
OFFERS_DRUG_TIER_WITH_NO_PART_D_DEDUCTIBLE	TEXT
ANNUAL_PART_D_DEDUCTIBLE_AMOUNT	TEXT
PART_D_BASIC_PREMIUM	TEXT
PART_D_SUPPLEMENTAL_PREMIUM	TEXT
PART_D_TOTAL_PREMIUM	TEXT
LOW_INCOME_PREMIUM_SUBSIDY_LIPS_AMOUNT	TEXT
PART_D_LIPS_CMS_PAYS_	TEXT
PART_D_LOW_INCOME_BENEFICIARY_PREMIUM_AMOUNT	TEXT
PART_D_OUT_OF_POCKET_OOP_THRESHOLD	TEXT
PART_C_PREMIUM	TEXT
MONTHLY_CONSOLIDATED_PREMIUM_PART_C__D_	TEXT
IN_NETWORK_MAXIMUM_OUT_OF_POCKET_MOOP_AMOUNT	TEXT
PART_C_SUMMARY_STAR_RATING	TEXT
PART_D_SUMMARY_STAR_RATING	TEXT
OVERALL_STAR_RATING	TEXT
MA_REGION_CODE	TEXT
MA_REGION	TEXT
PDP_REGION_CODE	TEXT
PDP_REGION	TEXT
STATE_ABBREVIATION	TEXT
STATE_NAME	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
CREATED_AT	TIMESTAMP_NTZ	Timestamp when the record was loaded

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:

SELECT d.__CONTRACT_YEAR, d.CONTRACT_CATEGORY_TYPE, d.US_TERRITORY,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.PART_D_PRESCRIPTION_DRUG_COVERAGE__LANDSCAPE__ALL_PLAN_TYPES d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Source & provenance

Published by the Centers for Medicare & Medicaid Services.

• Official CMS documentation

Frequently asked questions

How often is Part D Prescription Drug Coverage - Landscape - All Plan Types updated?

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

What years does Part D Prescription Drug Coverage - Landscape - All Plan Types cover?

2025 through 2026.

How many records are in Part D Prescription Drug Coverage - Landscape - All Plan Types?

Count the current snapshot yourself once the share is mounted:

SELECT COUNT(*)
FROM DWV.PART_D_PRESCRIPTION_DRUG_COVERAGE__LANDSCAPE__ALL_PLAN_TYPES d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID
WHERE ff.IS_LATEST = 1;

How do I get Part D Prescription Drug Coverage - Landscape - All Plan Types data?

It's included in the CMS Data Feeds Dataset on the Snowflake Marketplace (free trial available) and via Databricks Delta Sharing. Once mounted, query DWV.PART_D_PRESCRIPTION_DRUG_COVERAGE__LANDSCAPE__ALL_PLAN_TYPES directly — no pipeline setup required.

Related feeds

Rural Health Clinic All OwnersHospice EnrollmentsCMS Medicare PSI-90 and component measures - six-digit estimate datasetMedicare Post-Acute Care Utilization - Hospice by Geography and ProviderREACH ACOs

Get this feed

1. Start a free trial on Snowflake Marketplace or purchase via Databricks

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 Feeds Dataset — 280+ feeds · 245B+ records · updated daily. Back to the full catalog →