Medicare Quarterly Part B Spending by Drug

The Medicare Quarterly Part B Spending by Drug dataset presents information on spending for drugs administered in doctors’ offices and other outpatient…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.MEDICARE_QUARTERLY_PART_B_SPENDING_BY_DRUG on Snowflake and Databricks — coverage from 2025 to 2025 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.MEDICARE_QUARTERLY_PART_B_SPENDING_BY_DRUG
Databricks	cms_dwv.medicare_quarterly_part_b_spending_by_drug
Coverage	Jan 2025 – Sep 2025
Rows	5,140 (total across all reporting periods)
Cadence	Quarterly
Update pattern	Time-partitioned — each file adds one reporting period
CMS published	2026-04-30
Loaded	2026-04-30
Columns	10 data + 6 lineage
Identifiers	HCPCS codes
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-04-30. Coverage runs through 2025-09-30. Next CMS release expected ~Jul 2026.

Time-partitioned feed — each file version covers one reporting period, so history is additive. Query the full table for all periods; filter on YEAR for a single period. Do not filter to the latest file only — that would return just the 2025 reporting period.

Sample queries

Snowflake

-- Each file version covers one reporting period (2025) — history is additive
SELECT *
FROM DWV.MEDICARE_QUARTERLY_PART_B_SPENDING_BY_DRUG
LIMIT 100;

Databricks

About this feed

The Medicare Quarterly Part B Spending by Drug dataset presents information on spending for drugs administered in doctors’ offices and other outpatient settings by physicians and other healthcare providers to Medicare Part B enrollees. It also includes consumer-friendly descriptions of the drug uses, clinical indications, and manufacturer(s).

Drug spending metrics for Part B drugs represent the full value of the product, including the Medicare payment and beneficiary liability. All Part B drug spending metrics are calculated at the HCPCS level.

This dataset reports preliminary data that goes beyond the latest date available in the annual Medicare Part B Spending by Drug dataset. The data are updated each quarter and may change with each new release due to claims lag. Once an entire year of data is available with a sufficient run-out period, that data will move out of the preliminary quarterly dataset and into the annual Medicare Part B Spending by Drug dataset. Due to the preliminary nature of the quarterly dataset, we advise using caution when comparing between the annual and quarterly datasets.

— Source: CMS feed metadata

Keywords: Medicare, Original Medicare, Drugs Theme: Medicare

Coverage timeline

2025 🟩

1 of 1 years covered — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
2025-07-01 – 2025-09-30	2026-04-30	2026-04-30	✓
2025-04-01 – 2025-06-30	2026-01-29	2026-01-29
2025-01-01 – 2025-03-31	2025-12-11	2025-12-11

Data dictionary

📋 10 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Medicare Quarterly Part B Spending by Drug data dictionary.

Data columns

Column	Type
BRND_NAME	TEXT
GNRC_NAME	TEXT
HCPCS_CD	TEXT
HCPCS_DESC	TEXT
YEAR	TEXT
TOT_BENES	NUMBER
TOT_CLMS	NUMBER
TOT_SPNDNG	NUMBER
AVG_SPND_PER_BENE	NUMBER
AVG_SPND_PER_CLM	NUMBER

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.BRND_NAME, d.GNRC_NAME, d.HCPCS_CD,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.MEDICARE_QUARTERLY_PART_B_SPENDING_BY_DRUG d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Source & provenance

Published by the Centers for Medicare & Medicaid Services (bureau 009:38).

• Official CMS data dictionary

• Medicare Quarterly Part B Spending by Drug Methodology

Frequently asked questions

How often is Medicare Quarterly Part B Spending by Drug updated?

Quarterly. CMS last published this feed on 2026-04-30, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them.

What years does Medicare Quarterly Part B Spending by Drug cover?

2025 through 2025.

How many records are in Medicare Quarterly Part B Spending by Drug?

5,140 rows across all three reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count — no deduplication needed.

How do I get Medicare Quarterly Part B Spending by Drug 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.MEDICARE_QUARTERLY_PART_B_SPENDING_BY_DRUG directly — no pipeline setup required.

Related feeds

Medicare Part B Discarded Drug UnitsMedicare Part B Spending by DrugOpioid Treatment Program ProvidersIncome and Asset OwnershipACO Realizing Equity, Access and Community Health Providers

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 →