Medicare Advantage, Part D, Medicaid

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

medicare_silver.fact_market_saturation·live·silver·CMS Medicare Market Saturation & Utilization

Rows

2,455,330

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The 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.
2The provider COMPETITION / market-concentration signal (high providers-per-county = saturated; used to flag over/under-supply).
3Curated subset of the dashboard file (drops *_dual_color / *_description / *_change rendering columns).

Grain

Key	Grain
N/A	1One row per (reference_period, type_of_service, aggregation_level, state_fips, county_fips) — providers/users/payment.

Columns (33)

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

describe_data_source(source_fqn="medicare_silver.fact_market_saturation")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_market_saturation WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`county_fips`
Join	`how_to_join(source_fqn="medicare_silver.fact_market_saturation")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_market_saturation
Note	Iceberg medicare_silver.fact_market_saturation, partition by reference_period, replace (idempotent by SHA-256).

This page as markdown: /docs-md/data/medicare_silver_fact_market_saturation.md · every page in one file: /llms-full.txt