# CMS Market Saturation & Utilization (provider competition by county × service)

`medicare_silver.fact_market_saturation` · Medicare Advantage, Part D, Medicaid · status live · 2,455,330 rows

The CMS Market Saturation & Utilization file — per rolling reference period, service type, and county: number of FFS beneficiaries, number of providers, number of users, average users-per-provider, average providers-per-county, dual-eligible user counts/percentages, and total payment. The provider COMPETITION / market-concentration signal (high providers-per-county = saturated; used to flag over/under-supply). Curated subset of the dashboard file (drops *_dual_color / *_description / *_change rendering columns).

**Grain.** One row per (reference_period, type_of_service, aggregation_level, state_fips, county_fips) — providers/users/payment.

| column | type | meaning |
|---|---|---|
| reference_period | string |  |
| type_of_service | string |  |
| aggregation_level | string |  |
| state | string |  |
| county | string |  |
| state_fips | string |  |
| county_fips | string |  |
| moratorium | string |  |
| n_ffs_beneficiaries | double |  |
| n_providers | double |  |
| avg_users_per_provider | double |  |
| pct_users_of_ffs | double |  |
| n_users | double |  |
| avg_providers_per_county | double |  |
| n_dual_eligible_users | double |  |
| pct_dual_of_total_users | double |  |
| pct_dual_of_dual_ffs | double |  |
| total_payment | double |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.fact_market_saturation WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_market_saturation")` first.