About this Dataset

Market Saturation & Utilization State-County

The Market Saturation and Utilization State-County dataset provides monitoring of market saturation as a means to help prevent potential fraud, waste, and abuse (FWA). 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.

The interactive dataset can be filtered and analyzed on the site or downloaded in Excel format.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-05-24T07:30:50.303421
Tags: counties, fraud-waste-abuse-prevention, health-care-use-payments, medicare, national, original-medicare, states-territories

Tables

Market Saturation & Utilization State-County : 2024-12-01

@usgov.hhs_gov_market_saturation_utilization_state_county_8c2ec.market_saturation_utilization_state_county_2024_12_01

38.79 MB
892,917 rows
48 columns

CREATE TABLE market_saturation_utilization_state_county_2024_12_01 (
  "reference_period" VARCHAR,
  "type_of_service" VARCHAR,
  "aggregation_level" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "state_fips" VARCHAR,
  "county_fips" VARCHAR,
  "number_of_fee_for_service_beneficiaries" BIGINT,
  "number_of_providers" BIGINT,
  "average_number_of_users_per_provider" VARCHAR,
  "percentage_of_users_out_of_ffs_beneficiaries" VARCHAR,
  "number_of_users" BIGINT,
  "average_number_of_providers_per_county" DOUBLE,
  "number_of_dual_eligible_users" VARCHAR,
  "percentage_of_dual_eligible_users_out_of_total_users" VARCHAR,
  "percentage_of_dual_eligible_users_out_of_dual_eligible_05aabf36" VARCHAR  -- Percentage Of Dual Eligible Users Out Of Dual Eligible Ffs Beneficiaries,
  "total_payment" VARCHAR,
  "moratorium" VARCHAR,
  "number_of_fee_for_service_beneficiaries_dual_color" VARCHAR,
  "number_of_fee_for_service_beneficiaries_description" VARCHAR,
  "number_of_providers_dual_color" VARCHAR,
  "number_of_providers_description" VARCHAR,
  "average_number_of_users_per_provider_dual_color" VARCHAR,
  "average_number_of_users_per_provider_description" VARCHAR,
  "percentage_of_users_out_of_ffs_beneficiaries_dual_color" VARCHAR,
  "percentage_of_users_out_of_ffs_beneficiaries_description" VARCHAR,
  "number_of_users_dual_color" VARCHAR,
  "n__number_of_users_description" VARCHAR  -- Number Of Users Description,
  "average_number_of_providers_per_county_dual_color" VARCHAR,
  "average_number_of_providers_per_county_description" VARCHAR,
  "number_of_dual_eligible_users_dual_color" VARCHAR,
  "number_of_dual_eligible_users_description" VARCHAR,
  "percentage_of_dual_eligible_users_out_of_total_users_dual_color" VARCHAR,
  "percentage_of_dual_eligible_users_out_of_total_users_d_a396b8b3" VARCHAR  -- Percentage Of Dual Eligible Users Out Of Total Users Description,
  "percentage_of_dual_eligible_users_out_of_dual_eligible_04fda5ea" VARCHAR  -- Percentage Of Dual Eligible Users Out Of Dual Eligible Ffs Beneficiaries Dual Color,
  "percentage_of_dual_eligible_users_out_of_dual_eligible_6ab65c07" VARCHAR  -- Percentage Of Dual Eligible Users Out Of Dual Eligible Ffs Beneficiaries Description,
  "total_payment_dual_color" VARCHAR,
  "total_payment_description" VARCHAR,
  "number_of_fee_for_service_beneficiaries_change" VARCHAR,
  "number_of_providers_change" VARCHAR,
  "average_number_of_users_per_provider_change" VARCHAR,
  "percentage_of_users_out_of_ffs_beneficiaries_change" VARCHAR,
  "number_of_users_change" VARCHAR,
  "average_number_of_providers_per_county_change" VARCHAR,
  "number_of_dual_eligible_users_change" VARCHAR,
  "percentage_of_dual_eligible_users_out_of_total_users_change" VARCHAR,
  "percentage_of_dual_eligible_users_out_of_dual_eligible_1bcf7916" VARCHAR  -- Percentage Of Dual Eligible Users Out Of Dual Eligible Ffs Beneficiaries Change,
  "total_payment_change" VARCHAR
);