Market Saturation & Utilization State-County

The Market Saturation and Utilization State-County dataset provides monitoring of market saturation.

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.MARKET_SATURATION__UTILIZATION_STATECOUNTY on Snowflake and Databricks: eight annual reporting periods (2022–2025) 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.MARKET_SATURATION__UTILIZATION_STATECOUNTY
Databricks	cms_dwv.market_saturation__utilization_statecounty
Coverage	Oct 2022 – Dec 2025 (4 of 4 annual reporting periods)
Rows	7,582,553 (total across all reporting periods)
Cadence	Annual
Update pattern	Time-partitioned; each file adds one reporting year
CMS published	2026-06-10
Loaded	2026-06-11
Columns	48 data + 6 lineage
Identifiers	FIPS codes
File versions	8
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-06-10. Coverage is complete through the 2025 reporting year. Next CMS release expected ~Jun 2027.

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

Sample queries

Snowflake

-- Each file version covers one reporting period (2022, 2023, 2024, 2025); history is additive
SELECT *
FROM DWV.MARKET_SATURATION__UTILIZATION_STATECOUNTY
LIMIT 100;

Databricks

-- Each file version covers one reporting period (2022, 2023, 2024, 2025); history is additive
SELECT *
FROM cms_dwv.market_saturation__utilization_statecounty
LIMIT 100;

About this feed

The Market Saturation and Utilization State-County dataset provides monitoring of market saturation. Market saturation, in the present context, refers to the density of providers of a particular service within a defined geographic area relative to the number of beneficiaries receiving that service in the area. The data can be used to reveal the degree to which use of a service is related to the number of providers servicing a geographic region. There are also a number of secondary research uses for these data, but one objective of making these data public is to assist health care providers in making informed decisions about their service locations and the beneficiary population they serve.

Source: CMS feed metadata

Keywords: National, States & Territories, Counties, Medicare, Original Medicare, Health Care Use & Payments, Fraud, Waste, & Abuse Prevention Theme: Medicare

Coverage timeline

2022 🟩 · 2023 🟩 · 2024 🟩 · 2025 🟩

4 of 4 annual reporting periods present, no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
2025-01-01 – 2025-12-31	2026-06-10	2026-06-11	✓
2024-01-01 – 2024-12-31	2026-02-19	2026-02-19
2024-01-01 – 2024-12-31	2025-09-15	2025-10-18
2024-01-01 – 2024-12-31	2025-05-21	2025-05-21
2023-01-01 – 2023-12-31	2024-10-31	2024-11-01
2023-10-01 – 2023-12-31	2024-04-02	2024-04-02
2023-04-01 – 2023-06-30	2023-11-08	2023-11-08
2022-10-01 – 2022-12-31	2023-04-27	2023-08-29

Data dictionary

📋 48 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Market Saturation & Utilization State-County data dictionary.

Data columns

Column	Type
REFERENCE_PERIOD	TEXT
TYPE_OF_SERVICE	TEXT
AGGREGATION_LEVEL	TEXT
STATE	TEXT
COUNTY	TEXT
STATE_FIPS	TEXT
COUNTY_FIPS	TEXT
NUMBER_OF_FEE_FOR_SERVICE_BENEFICIARIES	TEXT
NUMBER_OF_PROVIDERS	TEXT
AVERAGE_NUMBER_OF_USERS_PER_PROVIDER	TEXT
PERCENTAGE_OF_USERS_OUT_OF_FFS_BENEFICIARIES	TEXT
NUMBER_OF_USERS	TEXT
AVERAGE_NUMBER_OF_PROVIDERS_PER_COUNTY	TEXT
NUMBER_OF_DUAL_ELIGIBLE_USERS	TEXT
PERCENTAGE_OF_DUAL_ELIGIBLE_USERS_OUT_OF_TOTAL_USERS	TEXT
PERCENTAGE_OF_DUAL_ELIGIBLE_USERS_OUT_OF_DUAL_ELIGIBLE_FFS_BENEFICIARIES	TEXT
TOTAL_PAYMENT	TEXT
MORATORIUM	TEXT
NUMBER_OF_FEE_FOR_SERVICE_BENEFICIARIES_DUAL_COLOR	TEXT
NUMBER_OF_FEE_FOR_SERVICE_BENEFICIARIES_DESCRIPTION	TEXT
NUMBER_OF_PROVIDERS_DUAL_COLOR	TEXT
NUMBER_OF_PROVIDERS_DESCRIPTION	TEXT
AVERAGE_NUMBER_OF_USERS_PER_PROVIDER_DUAL_COLOR	TEXT
AVERAGE_NUMBER_OF_USERS_PER_PROVIDER_DESCRIPTION	TEXT
PERCENTAGE_OF_USERS_OUT_OF_FFS_BENEFICIARIES_DUAL_COLOR	TEXT
PERCENTAGE_OF_USERS_OUT_OF_FFS_BENEFICIARIES_DESCRIPTION	TEXT
NUMBER_OF_USERS_DUAL_COLOR	TEXT
TNUMBER_OF_USERS_DESCRIPTION	TEXT
AVERAGE_NUMBER_OF_PROVIDERS_PER_COUNTY_DUAL_COLOR	TEXT
AVERAGE_NUMBER_OF_PROVIDERS_PER_COUNTY_DESCRIPTION	TEXT
NUMBER_OF_DUAL_ELIGIBLE_USERS_DUAL_COLOR	TEXT
NUMBER_OF_DUAL_ELIGIBLE_USERS_DESCRIPTION	TEXT
PERCENTAGE_OF_DUAL_ELIGIBLE_USERS_OUT_OF_TOTAL_USERS_DUAL_COLOR	TEXT
PERCENTAGE_OF_DUAL_ELIGIBLE_USERS_OUT_OF_TOTAL_USERS_DESCRIPTION	TEXT
PERCENTAGE_OF_DUAL_ELIGIBLE_USERS_OUT_OF_DUAL_ELIGIBLE_FFS_BENEFICIARIES_DUAL_COLOR	TEXT
PERCENTAGE_OF_DUAL_ELIGIBLE_USERS_OUT_OF_DUAL_ELIGIBLE_FFS_BENEFICIARIES_DESCRIPTION	TEXT
TOTAL_PAYMENT_DUAL_COLOR	TEXT
TOTAL_PAYMENT_DESCRIPTION	TEXT
NUMBER_OF_FEE_FOR_SERVICE_BENEFICIARIES_CHANGE	TEXT
NUMBER_OF_PROVIDERS_CHANGE	TEXT
AVERAGE_NUMBER_OF_USERS_PER_PROVIDER_CHANGE	TEXT
PERCENTAGE_OF_USERS_OUT_OF_FFS_BENEFICIARIES_CHANGE	TEXT
NUMBER_OF_USERS_CHANGE	TEXT
AVERAGE_NUMBER_OF_PROVIDERS_PER_COUNTY_CHANGE	TEXT
NUMBER_OF_DUAL_ELIGIBLE_USERS_CHANGE	TEXT
PERCENTAGE_OF_DUAL_ELIGIBLE_USERS_OUT_OF_TOTAL_USERS_CHANGE	TEXT
PERCENTAGE_OF_DUAL_ELIGIBLE_USERS_OUT_OF_DUAL_ELIGIBLE_FFS_BENEFICIARIES_CHANGE	TEXT
TOTAL_PAYMENT_CHANGE	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:

Snowflake

SELECT d.REFERENCE_PERIOD, d.TYPE_OF_SERVICE, d.AGGREGATION_LEVEL,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.MARKET_SATURATION__UTILIZATION_STATECOUNTY d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Databricks

SELECT d.reference_period, d.type_of_service, d.aggregation_level,
       ff.temporal_start, ff.temporal_end, ff.cms_feed_modified
FROM cms_dwv.market_saturation__utilization_statecounty 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 data dictionary

• Market Saturation Utilization State County Methodology

Frequently asked questions

How often is Market Saturation & Utilization State-County updated?

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

What years does Market Saturation & Utilization State-County cover?

2022 through 2025: four annual reporting periods with no gaps. Each reporting year arrives as its own file version, and all years remain queryable side by side.

How many records are in Market Saturation & Utilization State-County?

7,582,553 rows across all eight reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count; no deduplication needed.

How do I get Market Saturation & Utilization State-County 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.MARKET_SATURATION__UTILIZATION_STATECOUNTY directly; no pipeline setup required.

Related feeds

Medicare Geographic Variation - by National, State & CountySpecific Chronic ConditionsMultiple Chronic ConditionsMedicare Post-Acute Care Utilization - Home Health AgencyMedicare Post-Acute Care & Hospice - by Geography and Provider

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 →