Medicare Post-Acute Care Utilization - Home Health Agency By Geography/Provider And Case-Mix Grouping
U.S. Department of Health & Human Services
@usgov.hhs_gov_medicare_post_acute_care_utilization_home_heal_1f8bbae1
U.S. Department of Health & Human Services
@usgov.hhs_gov_medicare_post_acute_care_utilization_home_heal_1f8bbae1
The Medicare Post-Acute Care Utilization - Home Health Agency (HHA) by Geography/Provider and Case-Mix Grouping (CMG) supplemental dataset offers payment and utilization data for HHAs, organized by provider and Home Health Resource Group (HHRG) CMGs. It reflects the 153-group HHRG model for Calendar Years (CYs) 2014 - 2019 and the expanded 432-group model for CYs 2020 - 2023 under the Home Health Prospective Payment System (HH PPS). Low Utilization Payment Adjustment (LUPA) claims are excluded from all years, as they are not assigned an HHRG and are reimbursed per visit rather than through standardized payments.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:29:28.811110
Tags: health-care-use-payments, home-health, hospitals-facilities, medicare, national, original-medicare, states-territories
CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_1e3f7cf8 (
"year" BIGINT,
"year_type" VARCHAR,
"smry_ctgry" VARCHAR,
"srvc_ctgry" VARCHAR,
"prvdr_id" VARCHAR,
"prvdr_name" VARCHAR,
"prvdr_city" VARCHAR,
"state" VARCHAR,
"prvdr_zip" VARCHAR,
"grpng" VARCHAR,
"grpng_desc" VARCHAR,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"avg_chrg_per_bene" BIGINT,
"avg_alowd_amt_per_bene" BIGINT,
"avg_pymt_amt_per_bene" BIGINT,
"avg_stdzd_pymt_amt_per_bene" BIGINT,
"avg_chrg_per_epsd" BIGINT,
"avg_alowd_amt_per_epsd" BIGINT,
"avg_pymt_amt_per_epsd" BIGINT,
"avg_stdzd_pymt_amt_per_epsd" BIGINT,
"avg_chrg_per_day" BIGINT,
"avg_alowd_amt_per_day" BIGINT,
"avg_pymt_amt_per_day" BIGINT,
"avg_stdzd_pymt_amt_per_day" BIGINT,
"pt_visits_cnt" VARCHAR,
"ot_visits_cnt" VARCHAR,
"slp_visits_cnt" VARCHAR,
"casemix_src_tmng" VARCHAR,
"casemix_src_tmng_epsd_pct" VARCHAR,
"casemix_cmrbdty" VARCHAR,
"casemix_cmrbdty_epsd_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_2f893bc8 (
"year" BIGINT,
"year_type" VARCHAR,
"smry_ctgry" VARCHAR,
"srvc_ctgry" VARCHAR,
"prvdr_id" VARCHAR,
"prvdr_name" VARCHAR,
"prvdr_city" VARCHAR,
"state" VARCHAR,
"prvdr_zip" VARCHAR,
"grpng" VARCHAR,
"grpng_desc" VARCHAR,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"avg_chrg_per_bene" BIGINT,
"avg_alowd_amt_per_bene" BIGINT,
"avg_pymt_amt_per_bene" BIGINT,
"avg_stdzd_pymt_amt_per_bene" BIGINT,
"avg_chrg_per_epsd" BIGINT,
"avg_alowd_amt_per_epsd" BIGINT,
"avg_pymt_amt_per_epsd" BIGINT,
"avg_stdzd_pymt_amt_per_epsd" BIGINT,
"avg_chrg_per_day" BIGINT,
"avg_alowd_amt_per_day" BIGINT,
"avg_pymt_amt_per_day" BIGINT,
"avg_stdzd_pymt_amt_per_day" BIGINT,
"pt_visits_cnt" VARCHAR,
"ot_visits_cnt" VARCHAR,
"slp_visits_cnt" VARCHAR,
"casemix" VARCHAR,
"casemix_day_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_5406dacc (
"year" BIGINT,
"year_type" VARCHAR,
"smry_ctgry" VARCHAR,
"srvc_ctgry" VARCHAR,
"prvdr_id" VARCHAR,
"prvdr_name" VARCHAR,
"prvdr_city" VARCHAR,
"state" VARCHAR,
"prvdr_zip" VARCHAR,
"grpng" VARCHAR,
"grpng_desc" VARCHAR,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"avg_chrg_per_bene" BIGINT,
"avg_alowd_amt_per_bene" BIGINT,
"avg_pymt_amt_per_bene" BIGINT,
"avg_stdzd_pymt_amt_per_bene" BIGINT,
"avg_chrg_per_epsd" BIGINT,
"avg_alowd_amt_per_epsd" BIGINT,
"avg_pymt_amt_per_epsd" BIGINT,
"avg_stdzd_pymt_amt_per_epsd" BIGINT,
"avg_chrg_per_day" BIGINT,
"avg_alowd_amt_per_day" BIGINT,
"avg_pymt_amt_per_day" BIGINT,
"avg_stdzd_pymt_amt_per_day" BIGINT,
"pt_visits_cnt" VARCHAR,
"ot_visits_cnt" VARCHAR,
"slp_visits_cnt" VARCHAR,
"casemix" VARCHAR,
"casemix_day_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_5aa43c56 (
"year" BIGINT,
"year_type" VARCHAR,
"smry_ctgry" VARCHAR,
"srvc_ctgry" VARCHAR,
"prvdr_id" VARCHAR,
"prvdr_name" VARCHAR,
"prvdr_city" VARCHAR,
"state" VARCHAR,
"prvdr_zip" VARCHAR,
"grpng" VARCHAR,
"grpng_desc" VARCHAR,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"avg_chrg_per_bene" BIGINT,
"avg_alowd_amt_per_bene" BIGINT,
"avg_pymt_amt_per_bene" BIGINT,
"avg_stdzd_pymt_amt_per_bene" BIGINT,
"avg_chrg_per_epsd" BIGINT,
"avg_alowd_amt_per_epsd" BIGINT,
"avg_pymt_amt_per_epsd" BIGINT,
"avg_stdzd_pymt_amt_per_epsd" BIGINT,
"avg_chrg_per_day" BIGINT,
"avg_alowd_amt_per_day" BIGINT,
"avg_pymt_amt_per_day" BIGINT,
"avg_stdzd_pymt_amt_per_day" BIGINT,
"pt_visits_cnt" VARCHAR,
"ot_visits_cnt" VARCHAR,
"slp_visits_cnt" VARCHAR,
"casemix" VARCHAR,
"casemix_day_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_6c59eb67 (
"year" BIGINT,
"year_type" VARCHAR,
"smry_ctgry" VARCHAR,
"srvc_ctgry" VARCHAR,
"prvdr_id" VARCHAR,
"prvdr_name" VARCHAR,
"prvdr_city" VARCHAR,
"state" VARCHAR,
"prvdr_zip" VARCHAR,
"grpng" VARCHAR,
"grpng_desc" VARCHAR,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"avg_chrg_per_bene" BIGINT,
"avg_alowd_amt_per_bene" BIGINT,
"avg_pymt_amt_per_bene" BIGINT,
"avg_stdzd_pymt_amt_per_bene" BIGINT,
"avg_chrg_per_epsd" BIGINT,
"avg_alowd_amt_per_epsd" BIGINT,
"avg_pymt_amt_per_epsd" BIGINT,
"avg_stdzd_pymt_amt_per_epsd" BIGINT,
"avg_chrg_per_day" BIGINT,
"avg_alowd_amt_per_day" BIGINT,
"avg_pymt_amt_per_day" BIGINT,
"avg_stdzd_pymt_amt_per_day" BIGINT,
"pt_visits_cnt" VARCHAR,
"ot_visits_cnt" VARCHAR,
"slp_visits_cnt" VARCHAR,
"casemix" VARCHAR,
"casemix_day_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_94116f76 (
"year" BIGINT,
"year_type" VARCHAR,
"smry_ctgry" VARCHAR,
"srvc_ctgry" VARCHAR,
"prvdr_id" VARCHAR,
"prvdr_name" VARCHAR,
"prvdr_city" VARCHAR,
"state" VARCHAR,
"prvdr_zip" VARCHAR,
"grpng" VARCHAR,
"grpng_desc" VARCHAR,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"avg_chrg_per_bene" BIGINT,
"avg_alowd_amt_per_bene" BIGINT,
"avg_pymt_amt_per_bene" BIGINT,
"avg_stdzd_pymt_amt_per_bene" BIGINT,
"avg_chrg_per_epsd" BIGINT,
"avg_alowd_amt_per_epsd" BIGINT,
"avg_pymt_amt_per_epsd" BIGINT,
"avg_stdzd_pymt_amt_per_epsd" BIGINT,
"avg_chrg_per_day" BIGINT,
"avg_alowd_amt_per_day" BIGINT,
"avg_pymt_amt_per_day" BIGINT,
"avg_stdzd_pymt_amt_per_day" BIGINT,
"pt_visits_cnt" VARCHAR,
"ot_visits_cnt" VARCHAR,
"slp_visits_cnt" VARCHAR,
"casemix_src_tmng" VARCHAR,
"casemix_src_tmng_epsd_pct" VARCHAR,
"casemix_cmrbdty" VARCHAR,
"casemix_cmrbdty_epsd_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_946fe4e6 (
"year" BIGINT,
"year_type" VARCHAR,
"smry_ctgry" VARCHAR,
"srvc_ctgry" VARCHAR,
"prvdr_id" VARCHAR,
"prvdr_name" VARCHAR,
"prvdr_city" VARCHAR,
"state" VARCHAR,
"prvdr_zip" VARCHAR,
"grpng" VARCHAR,
"grpng_desc" VARCHAR,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"avg_chrg_per_bene" BIGINT,
"avg_alowd_amt_per_bene" BIGINT,
"avg_pymt_amt_per_bene" BIGINT,
"avg_stdzd_pymt_amt_per_bene" BIGINT,
"avg_chrg_per_epsd" BIGINT,
"avg_alowd_amt_per_epsd" BIGINT,
"avg_pymt_amt_per_epsd" BIGINT,
"avg_stdzd_pymt_amt_per_epsd" BIGINT,
"avg_chrg_per_day" BIGINT,
"avg_alowd_amt_per_day" BIGINT,
"avg_pymt_amt_per_day" BIGINT,
"avg_stdzd_pymt_amt_per_day" BIGINT,
"pt_visits_cnt" VARCHAR,
"ot_visits_cnt" VARCHAR,
"slp_visits_cnt" VARCHAR,
"casemix" VARCHAR,
"casemix_day_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_b691dd8a (
"year" BIGINT,
"year_type" VARCHAR,
"smry_ctgry" VARCHAR,
"srvc_ctgry" VARCHAR,
"prvdr_id" VARCHAR,
"prvdr_name" VARCHAR,
"prvdr_city" VARCHAR,
"state" VARCHAR,
"prvdr_zip" VARCHAR,
"grpng" VARCHAR,
"grpng_desc" VARCHAR,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"avg_chrg_per_bene" BIGINT,
"avg_alowd_amt_per_bene" BIGINT,
"avg_pymt_amt_per_bene" BIGINT,
"avg_stdzd_pymt_amt_per_bene" BIGINT,
"avg_chrg_per_epsd" BIGINT,
"avg_alowd_amt_per_epsd" BIGINT,
"avg_pymt_amt_per_epsd" BIGINT,
"avg_stdzd_pymt_amt_per_epsd" BIGINT,
"avg_chrg_per_day" BIGINT,
"avg_alowd_amt_per_day" BIGINT,
"avg_pymt_amt_per_day" BIGINT,
"avg_stdzd_pymt_amt_per_day" BIGINT,
"pt_visits_cnt" VARCHAR,
"ot_visits_cnt" VARCHAR,
"slp_visits_cnt" VARCHAR,
"casemix" VARCHAR,
"casemix_day_pct" VARCHAR
);Anyone who has the link will be able to view this.