CMS National Health Expenditure Accounts - National by Type of Service & Source of Funds

Aggregate U.S.

Part of the CMS Data Feeds Dataset › Health

Dataplex delivers this CMS feed as the analysis-ready table DWV.NHE_NATIONAL 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.NHE_NATIONAL
Databricks	cms_dwv.nhe_national
Cadence	Annual
Update pattern	Full-refresh; each file replaces the prior snapshot
CMS published	2026-12-01
Loaded	2026-06-29
Columns	7 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-12-01. Coverage runs through 2026-12-01. Next CMS release expected ~Dec 2027.

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.NHE_NATIONAL
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

Databricks

-- Latest snapshot only (avoids double-counting across file versions)
SELECT *
FROM cms_dwv.nhe_national
WHERE file_id IN (
  SELECT id FROM cms_dwv.feeds_files WHERE is_latest = 1
)
LIMIT 100;

About this feed

Aggregate U.S. national health spending (millions of dollars) by type of service and source of funds, 1960-2033, historical estimates plus CMS Office of the Actuary projections. One row per (type_of_service, source_of_funds, year) with a Historical/Projected marker.

Source: CMS feed metadata

Keywords: national health expenditures, NHEA, health spending, type of service, source of funds, GDP, projections, actuary Theme: Health

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-12-01	2026-12-01	2026-06-29	✓
Snapshot as of 2025-12-01	2025-12-01	2026-06-01
Snapshot as of 2025-12-01	2025-12-01	2026-05-31

Data dictionary

📋 7 data columns + 6 lineage columns

Data columns

Column	Type	Description
DATA_PERIOD	TEXT	Release vintage (YYYY-12), filter by this to select a specific annual release; the spending year is in the YEAR column.
TYPE_OF_SERVICE	TEXT	Spending category (e.g. National Health Expenditures, Hospital Care, Physician and Clinical Services, Prescription Drugs).
SOURCE_OF_FUNDS	TEXT	Funding source within the type of service (e.g. Total Expenditures, Out of pocket, Private Health Insurance, Medicare, Medicaid).
INDENT_LEVEL	NUMBER	Leading-space indentation depth of source_of_funds in the source file, encodes the funding-source hierarchy (0 = top level).
YEAR	NUMBER	Calendar year of the spending figure (1960-2033).
PROJECTION_TYPE	TEXT	'Historical' for estimated actuals, 'Projected' for CMS Office of the Actuary forecast years.
EXPENDITURE_MILLIONS	NUMBER	Health expenditure amount in millions of U.S. dollars.

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:

Snowflake

SELECT d.DATA_PERIOD, d.TYPE_OF_SERVICE, d.SOURCE_OF_FUNDS,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.NHE_NATIONAL d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Databricks

SELECT d.data_period, d.type_of_service, d.source_of_funds,
       ff.temporal_start, ff.temporal_end, ff.cms_feed_modified
FROM cms_dwv.nhe_national d
JOIN cms_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 documentation

• Historical

• Projected

Frequently asked questions

How often is CMS National Health Expenditure Accounts - National by Type of Service & Source of Funds updated?

Annually. CMS last published this feed on 2026-12-01, and Dataplex loaded it to the warehouse on 2026-06-29. New releases are added automatically when CMS publishes them.

What years does CMS National Health Expenditure Accounts - National by Type of Service & Source of Funds cover?

2025 through 2026.

How many records are in CMS National Health Expenditure Accounts - National by Type of Service & Source of Funds?

Count the current snapshot yourself once the share is mounted:

Snowflake

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

Databricks

SELECT COUNT(*)
FROM cms_dwv.nhe_national d
JOIN cms_dwv.feeds_files ff ON d.file_id = ff.id
WHERE ff.is_latest = 1;

How do I get CMS National Health Expenditure Accounts - National by Type of Service & Source of Funds 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.NHE_NATIONAL directly; no pipeline setup required.

Related feeds

CMS National Health Expenditure Accounts - Health Spending by Age and SexCMS National Health Expenditure Accounts - Health Spending by State of ResidenceCMS National Health Expenditure Accounts - Health Spending by State of ProviderCMS Program Statistics - Medicare SNF Utilization by Covered Days of CareNursing Homes Including Rehab Services - Penalties

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 →