Medicare Post-Acute Care Utilization - Skilled Nursing Facility By Geography/Provider And Case-Mix Grouping
U.S. Department of Health & Human Services
@usgov.hhs_gov_medicare_post_acute_care_utilization_skilled_n_8204300a
U.S. Department of Health & Human Services
@usgov.hhs_gov_medicare_post_acute_care_utilization_skilled_n_8204300a
The Medicare Post-Acute Care (PAC) Utilization - Skilled Nursing Facility (SNF) by Geography/Provider and Case-Mix Grouping (CMG) supplemental dataset provides detailed information on payments and utilization for SNFs. For Fiscal Years (FY)s 2014–2019, data is organized by provider and Resource Utilization Group (RUG) type. Starting in FY 2020, following the shift to the Patient-Driven Payment Model (PDPM), the dataset no longer includes RUG-level data. Instead, it features therapy minutes by discipline, stays by clinical category, and the percentage of stays involving depression or swallowing disorders.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:26:52.362811
Tags: health-care-use-payments, hospitals-facilities, medicare, national, original-medicare, skilled-nursing, states-territories
CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_3925c7d4 (
"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_stay" BIGINT,
"avg_alowd_amt_per_stay" BIGINT,
"avg_pymt_amt_per_stay" BIGINT,
"avg_stdzd_pymt_amt_per_stay" BIGINT,
"avg_chrg_per_day" VARCHAR,
"avg_alowd_amt_per_day" VARCHAR,
"avg_pymt_amt_per_day" VARCHAR,
"avg_stdzd_pymt_amt_per_day" VARCHAR,
"casemix" VARCHAR,
"casemix_day_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_3ba38231 (
"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_stay" BIGINT,
"avg_alowd_amt_per_stay" BIGINT,
"avg_pymt_amt_per_stay" BIGINT,
"avg_stdzd_pymt_amt_per_stay" BIGINT,
"avg_chrg_per_day" VARCHAR,
"avg_alowd_amt_per_day" VARCHAR,
"avg_pymt_amt_per_day" VARCHAR,
"avg_stdzd_pymt_amt_per_day" VARCHAR,
"casemix" VARCHAR,
"casemix_day_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_55f2ccbd (
"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,
"tot_pt_mnts_stay" VARCHAR,
"indvdl_pt_mnts_stay" VARCHAR,
"cncrnt_grp_pt_mnts_stay" VARCHAR,
"tot_ot_mnts_stay" VARCHAR,
"indvdl_ot_mnts_stay" VARCHAR,
"cncrnt_grp_ot_mnts_stay" VARCHAR,
"tot_slp_mnts_stay" VARCHAR,
"indvdl_slp_mnts_stay" VARCHAR,
"cncrnt_grp_slp_mnts_stay" VARCHAR,
"stay_clncl_ctgry_acu_inf_pct" VARCHAR,
"stay_clncl_ctgry_acu_neu_pct" VARCHAR,
"stay_clncl_ctgry_cncr_pct" VARCHAR,
"stay_clncl_ctgry_crd_coag_pct" VARCHAR,
"stay_clncl_ctgry_mjr_spn_pct" VARCHAR,
"stay_clncl_ctgry_med_mng_pct" VARCHAR,
"stay_clncl_ctgry_noorth_srgy_pct" VARCHAR,
"stay_clncl_ctgry_orth_nosrgy_pct" VARCHAR,
"stay_clncl_ctgry_orth_srgy_pct" VARCHAR,
"stay_clncl_ctgry_plmnry_pct" VARCHAR,
"stay_dprsn_mood_scre_pct" VARCHAR,
"stay_swlwg_dsrdr_pct" VARCHAR,
"stay_mlntrn_pct" VARCHAR,
"pdpm_pt_ot_tc_days_pct" VARCHAR,
"pdpm_pt_ot_td_days_pct" VARCHAR,
"pdpm_slp_sk_days_pct" VARCHAR,
"pdpm_slp_sl_days_pct" VARCHAR,
"pdpm_nrsng_es3_days_pct" VARCHAR,
"pdpm_nrsng_es2_days_pct" VARCHAR,
"pdpm_nta_na_days_pct" VARCHAR,
"pdpm_nta_nb_days_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_5eed5040 (
"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,
"tot_pt_mnts_stay" VARCHAR,
"indvdl_pt_mnts_stay" VARCHAR,
"cncrnt_grp_pt_mnts_stay" VARCHAR,
"tot_ot_mnts_stay" VARCHAR,
"indvdl_ot_mnts_stay" VARCHAR,
"cncrnt_grp_ot_mnts_stay" VARCHAR,
"tot_slp_mnts_stay" VARCHAR,
"indvdl_slp_mnts_stay" VARCHAR,
"cncrnt_grp_slp_mnts_stay" VARCHAR,
"stay_clncl_ctgry_acu_inf_pct" VARCHAR,
"stay_clncl_ctgry_acu_neu_pct" VARCHAR,
"stay_clncl_ctgry_cncr_pct" VARCHAR,
"stay_clncl_ctgry_crd_coag_pct" VARCHAR,
"stay_clncl_ctgry_mjr_spn_pct" VARCHAR,
"stay_clncl_ctgry_med_mng_pct" VARCHAR,
"stay_clncl_ctgry_noorth_srgy_pct" VARCHAR,
"stay_clncl_ctgry_orth_nosrgy_pct" VARCHAR,
"stay_clncl_ctgry_orth_srgy_pct" VARCHAR,
"stay_clncl_ctgry_plmnry_pct" VARCHAR,
"stay_dprsn_mood_scre_pct" VARCHAR,
"stay_swlwg_dsrdr_pct" VARCHAR,
"stay_mlntrn_pct" VARCHAR,
"pdpm_pt_ot_tc_days_pct" VARCHAR,
"pdpm_pt_ot_td_days_pct" VARCHAR,
"pdpm_slp_sk_days_pct" VARCHAR,
"pdpm_slp_sl_days_pct" VARCHAR,
"pdpm_nrsng_es3_days_pct" VARCHAR,
"pdpm_nrsng_es2_days_pct" VARCHAR,
"pdpm_nta_na_days_pct" VARCHAR,
"pdpm_nta_nb_days_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_74478055 (
"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_stay" BIGINT,
"avg_alowd_amt_per_stay" BIGINT,
"avg_pymt_amt_per_stay" BIGINT,
"avg_stdzd_pymt_amt_per_stay" BIGINT,
"avg_chrg_per_day" VARCHAR,
"avg_alowd_amt_per_day" VARCHAR,
"avg_pymt_amt_per_day" VARCHAR,
"avg_stdzd_pymt_amt_per_day" VARCHAR,
"casemix" VARCHAR,
"casemix_day_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_e22b187d (
"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,
"tot_pt_mnts_stay" VARCHAR,
"indvdl_pt_mnts_stay" VARCHAR,
"cncrnt_grp_pt_mnts_stay" VARCHAR,
"tot_ot_mnts_stay" VARCHAR,
"indvdl_ot_mnts_stay" VARCHAR,
"cncrnt_grp_ot_mnts_stay" VARCHAR,
"tot_slp_mnts_stay" VARCHAR,
"indvdl_slp_mnts_stay" VARCHAR,
"cncrnt_grp_slp_mnts_stay" VARCHAR,
"stay_clncl_ctgry_acu_inf_pct" VARCHAR,
"stay_clncl_ctgry_acu_neu_pct" VARCHAR,
"stay_clncl_ctgry_cncr_pct" VARCHAR,
"stay_clncl_ctgry_crd_coag_pct" VARCHAR,
"stay_clncl_ctgry_mjr_spn_pct" VARCHAR,
"stay_clncl_ctgry_med_mng_pct" VARCHAR,
"stay_clncl_ctgry_noorth_srgy_pct" VARCHAR,
"stay_clncl_ctgry_orth_nosrgy_pct" VARCHAR,
"stay_clncl_ctgry_orth_srgy_pct" VARCHAR,
"stay_clncl_ctgry_plmnry_pct" VARCHAR,
"stay_dprsn_mood_scre_pct" VARCHAR,
"stay_swlwg_dsrdr_pct" VARCHAR,
"stay_mlntrn_pct" VARCHAR,
"pdpm_pt_ot_tc_days_pct" VARCHAR,
"pdpm_pt_ot_td_days_pct" VARCHAR,
"pdpm_slp_sk_days_pct" VARCHAR,
"pdpm_slp_sl_days_pct" VARCHAR,
"pdpm_nrsng_es3_days_pct" VARCHAR,
"pdpm_nrsng_es2_days_pct" VARCHAR,
"pdpm_nta_na_days_pct" VARCHAR,
"pdpm_nta_nb_days_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_e5a358d6 (
"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_stay" BIGINT,
"avg_alowd_amt_per_stay" BIGINT,
"avg_pymt_amt_per_stay" BIGINT,
"avg_stdzd_pymt_amt_per_stay" BIGINT,
"avg_chrg_per_day" VARCHAR,
"avg_alowd_amt_per_day" VARCHAR,
"avg_pymt_amt_per_day" VARCHAR,
"avg_stdzd_pymt_amt_per_day" VARCHAR,
"casemix" VARCHAR,
"casemix_day_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_ed97a00b (
"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_stay" BIGINT,
"avg_alowd_amt_per_stay" BIGINT,
"avg_pymt_amt_per_stay" BIGINT,
"avg_stdzd_pymt_amt_per_stay" BIGINT,
"avg_chrg_per_day" VARCHAR,
"avg_alowd_amt_per_day" VARCHAR,
"avg_pymt_amt_per_day" VARCHAR,
"avg_stdzd_pymt_amt_per_day" VARCHAR,
"casemix" VARCHAR,
"casemix_day_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_edbc150e (
"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,
"tot_pt_mnts_stay" VARCHAR,
"indvdl_pt_mnts_stay" VARCHAR,
"cncrnt_grp_pt_mnts_stay" VARCHAR,
"tot_ot_mnts_stay" VARCHAR,
"indvdl_ot_mnts_stay" VARCHAR,
"cncrnt_grp_ot_mnts_stay" VARCHAR,
"tot_slp_mnts_stay" VARCHAR,
"indvdl_slp_mnts_stay" VARCHAR,
"cncrnt_grp_slp_mnts_stay" VARCHAR,
"stay_clncl_ctgry_acu_inf_pct" VARCHAR,
"stay_clncl_ctgry_acu_neu_pct" VARCHAR,
"stay_clncl_ctgry_cncr_pct" VARCHAR,
"stay_clncl_ctgry_crd_coag_pct" VARCHAR,
"stay_clncl_ctgry_mjr_spn_pct" VARCHAR,
"stay_clncl_ctgry_med_mng_pct" VARCHAR,
"stay_clncl_ctgry_noorth_srgy_pct" VARCHAR,
"stay_clncl_ctgry_orth_nosrgy_pct" VARCHAR,
"stay_clncl_ctgry_orth_srgy_pct" VARCHAR,
"stay_clncl_ctgry_plmnry_pct" VARCHAR,
"stay_dprsn_mood_scre_pct" VARCHAR,
"stay_swlwg_dsrdr_pct" VARCHAR,
"stay_mlntrn_pct" VARCHAR,
"pdpm_pt_ot_tc_days_pct" VARCHAR,
"pdpm_pt_ot_td_days_pct" VARCHAR,
"pdpm_slp_sk_days_pct" VARCHAR,
"pdpm_slp_sl_days_pct" VARCHAR,
"pdpm_nrsng_es3_days_pct" VARCHAR,
"pdpm_nrsng_es2_days_pct" VARCHAR,
"pdpm_nta_na_days_pct" VARCHAR,
"pdpm_nta_nb_days_pct" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_efcb0d99 (
"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_stay" BIGINT,
"avg_alowd_amt_per_stay" BIGINT,
"avg_pymt_amt_per_stay" BIGINT,
"avg_stdzd_pymt_amt_per_stay" BIGINT,
"avg_chrg_per_day" VARCHAR,
"avg_alowd_amt_per_day" VARCHAR,
"avg_pymt_amt_per_day" VARCHAR,
"avg_stdzd_pymt_amt_per_day" VARCHAR,
"casemix" VARCHAR,
"casemix_day_pct" VARCHAR
);Anyone who has the link will be able to view this.