Medicare Post-Acute Care Utilization - Home Health Agency
U.S. Department of Health & Human Services
@usgov.hhs_gov_medicare_post_acute_care_utilization_home_heal_0225a617
U.S. Department of Health & Human Services
@usgov.hhs_gov_medicare_post_acute_care_utilization_home_heal_0225a617
The Medicare Post-Acute Care (PAC) Utilization - Home Health Agency (HHA) dataset contains data summarized at the provider, state, and national levels. Payment information includes provider charges, Medicare allowed amount (if applicable), Medicare payment, and the standardized payment for care provided in the HHA setting.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:20:49.083034
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_26cf1a64 (
"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,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"tot_chrg_amt" BIGINT,
"tot_alowd_amt" BIGINT,
"tot_mdcr_pymt_amt" BIGINT,
"tot_mdcr_stdzd_pymt_amt" BIGINT,
"tot_outlier_pymt_amt" BIGINT,
"bene_dual_pct" VARCHAR,
"bene_rrl_pct" VARCHAR,
"bene_avg_age" BIGINT,
"bene_male_pct" VARCHAR,
"bene_feml_pct" VARCHAR,
"bene_race_wht_pct" VARCHAR,
"bene_race_black_pct" VARCHAR,
"bene_race_api_pct" VARCHAR,
"bene_race_hspnc_pct" VARCHAR,
"bene_race_natind_pct" VARCHAR,
"bene_race_unk_pct" VARCHAR,
"bene_race_othr_pct" VARCHAR,
"bene_avg_risk_scre" DOUBLE,
"bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
"bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
"bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
"bene_cc_bh_anxiety_v1_pct" VARCHAR,
"bene_cc_bh_bipolar_v1_pct" VARCHAR,
"bene_cc_bh_depress_v1_pct" VARCHAR,
"bene_cc_bh_mood_v2_pct" VARCHAR,
"bene_cc_bh_pd_v1_pct" VARCHAR,
"bene_cc_bh_ptsd_v1_pct" VARCHAR,
"bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
"bene_cc_bh_tobacco_v1_pct" VARCHAR,
"bene_cc_ph_afib_v2_pct" VARCHAR,
"bene_cc_ph_arthritis_v2_pct" VARCHAR,
"bene_cc_ph_asthma_v2_pct" VARCHAR,
"bene_cc_ph_cancer6_v2_pct" VARCHAR,
"bene_cc_ph_ckd_v2_pct" VARCHAR,
"bene_cc_ph_copd_v2_pct" VARCHAR,
"bene_cc_ph_diabetes_v2_pct" VARCHAR,
"bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
"bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
"bene_cc_ph_hypertension_v2_pct" VARCHAR,
"bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
"bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
"bene_cc_ph_parkinson_v2_pct" VARCHAR,
"bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
"prmry_dx_infctn_pct" VARCHAR,
"prmry_dx_neobld_pct" VARCHAR,
"prmry_dx_endonutrmet_pct" VARCHAR,
"prmry_dx_mntbehneudis_pct" VARCHAR,
"prmry_dx_nervsystm_pct" VARCHAR,
"prmry_dx_entsys_pct" VARCHAR,
"prmry_dx_circsystm_pct" VARCHAR,
"prmry_dx_rspsystm_pct" VARCHAR,
"prmry_dx_digsystm_pct" VARCHAR,
"prmry_dx_sknmussystm_pct" VARCHAR,
"prmry_dx_gusystm_pct" VARCHAR,
"prmry_dx_prgpericong_pct" VARCHAR,
"prmry_dx_sxilldef_pct" VARCHAR,
"prmry_dx_injpois_pct" VARCHAR,
"prmry_dx_hlthsrv_pct" VARCHAR,
"nrsng_visits_cnt" VARCHAR,
"msw_visits_cnt" VARCHAR,
"aide_visits_cnt" VARCHAR,
"tot_nrsng_mnts" VARCHAR,
"tot_pt_mnts" VARCHAR,
"tot_ot_mnts" VARCHAR,
"tot_slp_mnts" VARCHAR,
"tot_hh_lupa_epsds_cnt" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_28da86d3 (
"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,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"tot_chrg_amt" BIGINT,
"tot_alowd_amt" BIGINT,
"tot_mdcr_pymt_amt" BIGINT,
"tot_mdcr_stdzd_pymt_amt" BIGINT,
"tot_outlier_pymt_amt" BIGINT,
"bene_dual_pct" VARCHAR,
"bene_rrl_pct" VARCHAR,
"bene_avg_age" BIGINT,
"bene_male_pct" VARCHAR,
"bene_feml_pct" VARCHAR,
"bene_race_wht_pct" VARCHAR,
"bene_race_black_pct" VARCHAR,
"bene_race_api_pct" VARCHAR,
"bene_race_hspnc_pct" VARCHAR,
"bene_race_natind_pct" VARCHAR,
"bene_race_unk_pct" VARCHAR,
"bene_race_othr_pct" VARCHAR,
"bene_avg_risk_scre" DOUBLE,
"bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
"bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
"bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
"bene_cc_bh_anxiety_v1_pct" VARCHAR,
"bene_cc_bh_bipolar_v1_pct" VARCHAR,
"bene_cc_bh_depress_v1_pct" VARCHAR,
"bene_cc_bh_mood_v2_pct" VARCHAR,
"bene_cc_bh_pd_v1_pct" VARCHAR,
"bene_cc_bh_ptsd_v1_pct" VARCHAR,
"bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
"bene_cc_bh_tobacco_v1_pct" VARCHAR,
"bene_cc_ph_afib_v2_pct" VARCHAR,
"bene_cc_ph_arthritis_v2_pct" VARCHAR,
"bene_cc_ph_asthma_v2_pct" VARCHAR,
"bene_cc_ph_cancer6_v2_pct" VARCHAR,
"bene_cc_ph_ckd_v2_pct" VARCHAR,
"bene_cc_ph_copd_v2_pct" VARCHAR,
"bene_cc_ph_diabetes_v2_pct" VARCHAR,
"bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
"bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
"bene_cc_ph_hypertension_v2_pct" VARCHAR,
"bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
"bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
"bene_cc_ph_parkinson_v2_pct" VARCHAR,
"bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
"prmry_dx_infctn_pct" VARCHAR,
"prmry_dx_neobld_pct" VARCHAR,
"prmry_dx_endonutrmet_pct" VARCHAR,
"prmry_dx_mntbehneudis_pct" VARCHAR,
"prmry_dx_nervsystm_pct" VARCHAR,
"prmry_dx_entsys_pct" VARCHAR,
"prmry_dx_circsystm_pct" VARCHAR,
"prmry_dx_rspsystm_pct" VARCHAR,
"prmry_dx_digsystm_pct" VARCHAR,
"prmry_dx_sknmussystm_pct" VARCHAR,
"prmry_dx_gusystm_pct" VARCHAR,
"prmry_dx_prgpericong_pct" VARCHAR,
"prmry_dx_sxilldef_pct" VARCHAR,
"prmry_dx_injpois_pct" VARCHAR,
"prmry_dx_hlthsrv_pct" VARCHAR,
"nrsng_visits_cnt" VARCHAR,
"msw_visits_cnt" VARCHAR,
"aide_visits_cnt" VARCHAR,
"tot_nrsng_mnts" VARCHAR,
"tot_pt_mnts" VARCHAR,
"tot_ot_mnts" VARCHAR,
"tot_slp_mnts" VARCHAR,
"tot_hh_lupa_epsds_cnt" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_314e1f16 (
"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,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"tot_chrg_amt" BIGINT,
"tot_alowd_amt" BIGINT,
"tot_mdcr_pymt_amt" BIGINT,
"tot_mdcr_stdzd_pymt_amt" BIGINT,
"tot_outlier_pymt_amt" BIGINT,
"bene_dual_pct" VARCHAR,
"bene_rrl_pct" VARCHAR,
"bene_avg_age" BIGINT,
"bene_male_pct" VARCHAR,
"bene_feml_pct" VARCHAR,
"bene_race_wht_pct" VARCHAR,
"bene_race_black_pct" VARCHAR,
"bene_race_api_pct" VARCHAR,
"bene_race_hspnc_pct" VARCHAR,
"bene_race_natind_pct" VARCHAR,
"bene_race_unk_pct" VARCHAR,
"bene_race_othr_pct" VARCHAR,
"bene_avg_risk_scre" DOUBLE,
"bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
"bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
"bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
"bene_cc_bh_anxiety_v1_pct" VARCHAR,
"bene_cc_bh_bipolar_v1_pct" VARCHAR,
"bene_cc_bh_depress_v1_pct" VARCHAR,
"bene_cc_bh_mood_v2_pct" VARCHAR,
"bene_cc_bh_pd_v1_pct" VARCHAR,
"bene_cc_bh_ptsd_v1_pct" VARCHAR,
"bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
"bene_cc_bh_tobacco_v1_pct" VARCHAR,
"bene_cc_ph_afib_v2_pct" VARCHAR,
"bene_cc_ph_arthritis_v2_pct" VARCHAR,
"bene_cc_ph_asthma_v2_pct" VARCHAR,
"bene_cc_ph_cancer6_v2_pct" VARCHAR,
"bene_cc_ph_ckd_v2_pct" VARCHAR,
"bene_cc_ph_copd_v2_pct" VARCHAR,
"bene_cc_ph_diabetes_v2_pct" VARCHAR,
"bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
"bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
"bene_cc_ph_hypertension_v2_pct" VARCHAR,
"bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
"bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
"bene_cc_ph_parkinson_v2_pct" VARCHAR,
"bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
"prmry_dx_infctn_pct" VARCHAR,
"prmry_dx_neobld_pct" VARCHAR,
"prmry_dx_endonutrmet_pct" VARCHAR,
"prmry_dx_mntbehneudis_pct" VARCHAR,
"prmry_dx_nervsystm_pct" VARCHAR,
"prmry_dx_entsys_pct" VARCHAR,
"prmry_dx_circsystm_pct" VARCHAR,
"prmry_dx_rspsystm_pct" VARCHAR,
"prmry_dx_digsystm_pct" VARCHAR,
"prmry_dx_sknmussystm_pct" VARCHAR,
"prmry_dx_gusystm_pct" VARCHAR,
"prmry_dx_prgpericong_pct" VARCHAR,
"prmry_dx_sxilldef_pct" VARCHAR,
"prmry_dx_injpois_pct" VARCHAR,
"prmry_dx_hlthsrv_pct" VARCHAR,
"nrsng_visits_cnt" VARCHAR,
"msw_visits_cnt" VARCHAR,
"aide_visits_cnt" VARCHAR,
"tot_nrsng_mnts" VARCHAR,
"tot_pt_mnts" VARCHAR,
"tot_ot_mnts" VARCHAR,
"tot_slp_mnts" VARCHAR,
"tot_hh_lupa_epsds_cnt" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_378c0e39 (
"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,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"tot_chrg_amt" BIGINT,
"tot_alowd_amt" BIGINT,
"tot_mdcr_pymt_amt" BIGINT,
"tot_mdcr_stdzd_pymt_amt" BIGINT,
"tot_outlier_pymt_amt" BIGINT,
"bene_dual_pct" VARCHAR,
"bene_rrl_pct" VARCHAR,
"bene_avg_age" BIGINT,
"bene_male_pct" VARCHAR,
"bene_feml_pct" VARCHAR,
"bene_race_wht_pct" VARCHAR,
"bene_race_black_pct" VARCHAR,
"bene_race_api_pct" VARCHAR,
"bene_race_hspnc_pct" VARCHAR,
"bene_race_natind_pct" VARCHAR,
"bene_race_unk_pct" VARCHAR,
"bene_race_othr_pct" VARCHAR,
"bene_avg_risk_scre" DOUBLE,
"bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
"bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
"bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
"bene_cc_bh_anxiety_v1_pct" VARCHAR,
"bene_cc_bh_bipolar_v1_pct" VARCHAR,
"bene_cc_bh_depress_v1_pct" VARCHAR,
"bene_cc_bh_mood_v2_pct" VARCHAR,
"bene_cc_bh_pd_v1_pct" VARCHAR,
"bene_cc_bh_ptsd_v1_pct" VARCHAR,
"bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
"bene_cc_bh_tobacco_v1_pct" VARCHAR,
"bene_cc_ph_afib_v2_pct" VARCHAR,
"bene_cc_ph_arthritis_v2_pct" VARCHAR,
"bene_cc_ph_asthma_v2_pct" VARCHAR,
"bene_cc_ph_cancer6_v2_pct" VARCHAR,
"bene_cc_ph_ckd_v2_pct" VARCHAR,
"bene_cc_ph_copd_v2_pct" VARCHAR,
"bene_cc_ph_diabetes_v2_pct" VARCHAR,
"bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
"bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
"bene_cc_ph_hypertension_v2_pct" VARCHAR,
"bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
"bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
"bene_cc_ph_parkinson_v2_pct" VARCHAR,
"bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
"prmry_dx_infctn_pct" VARCHAR,
"prmry_dx_neobld_pct" VARCHAR,
"prmry_dx_endonutrmet_pct" VARCHAR,
"prmry_dx_mntbehneudis_pct" VARCHAR,
"prmry_dx_nervsystm_pct" VARCHAR,
"prmry_dx_entsys_pct" VARCHAR,
"prmry_dx_circsystm_pct" VARCHAR,
"prmry_dx_rspsystm_pct" VARCHAR,
"prmry_dx_digsystm_pct" VARCHAR,
"prmry_dx_sknmussystm_pct" VARCHAR,
"prmry_dx_gusystm_pct" VARCHAR,
"prmry_dx_prgpericong_pct" VARCHAR,
"prmry_dx_sxilldef_pct" VARCHAR,
"prmry_dx_injpois_pct" VARCHAR,
"prmry_dx_hlthsrv_pct" VARCHAR,
"nrsng_visits_cnt" VARCHAR,
"msw_visits_cnt" VARCHAR,
"aide_visits_cnt" VARCHAR,
"tot_nrsng_mnts" VARCHAR,
"tot_pt_mnts" VARCHAR,
"tot_ot_mnts" VARCHAR,
"tot_slp_mnts" VARCHAR,
"tot_hh_lupa_epsds_cnt" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_42cde386 (
"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,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"tot_chrg_amt" BIGINT,
"tot_alowd_amt" BIGINT,
"tot_mdcr_pymt_amt" BIGINT,
"tot_mdcr_stdzd_pymt_amt" BIGINT,
"tot_outlier_pymt_amt" BIGINT,
"bene_dual_pct" VARCHAR,
"bene_rrl_pct" VARCHAR,
"bene_avg_age" BIGINT,
"bene_male_pct" VARCHAR,
"bene_feml_pct" VARCHAR,
"bene_race_wht_pct" VARCHAR,
"bene_race_black_pct" VARCHAR,
"bene_race_api_pct" VARCHAR,
"bene_race_hspnc_pct" VARCHAR,
"bene_race_natind_pct" VARCHAR,
"bene_race_unk_pct" VARCHAR,
"bene_race_othr_pct" VARCHAR,
"bene_avg_risk_scre" DOUBLE,
"bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
"bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
"bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
"bene_cc_bh_anxiety_v1_pct" VARCHAR,
"bene_cc_bh_bipolar_v1_pct" VARCHAR,
"bene_cc_bh_depress_v1_pct" VARCHAR,
"bene_cc_bh_mood_v2_pct" VARCHAR,
"bene_cc_bh_pd_v1_pct" VARCHAR,
"bene_cc_bh_ptsd_v1_pct" VARCHAR,
"bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
"bene_cc_bh_tobacco_v1_pct" VARCHAR,
"bene_cc_ph_afib_v2_pct" VARCHAR,
"bene_cc_ph_arthritis_v2_pct" VARCHAR,
"bene_cc_ph_asthma_v2_pct" VARCHAR,
"bene_cc_ph_cancer6_v2_pct" VARCHAR,
"bene_cc_ph_ckd_v2_pct" VARCHAR,
"bene_cc_ph_copd_v2_pct" VARCHAR,
"bene_cc_ph_diabetes_v2_pct" VARCHAR,
"bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
"bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
"bene_cc_ph_hypertension_v2_pct" VARCHAR,
"bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
"bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
"bene_cc_ph_parkinson_v2_pct" VARCHAR,
"bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
"prmry_dx_infctn_pct" VARCHAR,
"prmry_dx_neobld_pct" VARCHAR,
"prmry_dx_endonutrmet_pct" VARCHAR,
"prmry_dx_mntbehneudis_pct" VARCHAR,
"prmry_dx_nervsystm_pct" VARCHAR,
"prmry_dx_entsys_pct" VARCHAR,
"prmry_dx_circsystm_pct" VARCHAR,
"prmry_dx_rspsystm_pct" VARCHAR,
"prmry_dx_digsystm_pct" VARCHAR,
"prmry_dx_sknmussystm_pct" VARCHAR,
"prmry_dx_gusystm_pct" VARCHAR,
"prmry_dx_prgpericong_pct" VARCHAR,
"prmry_dx_sxilldef_pct" VARCHAR,
"prmry_dx_injpois_pct" VARCHAR,
"prmry_dx_hlthsrv_pct" VARCHAR,
"nrsng_visits_cnt" VARCHAR,
"msw_visits_cnt" VARCHAR,
"aide_visits_cnt" VARCHAR,
"tot_nrsng_mnts" VARCHAR,
"tot_pt_mnts" VARCHAR,
"tot_ot_mnts" VARCHAR,
"tot_slp_mnts" VARCHAR,
"tot_hh_lupa_epsds_cnt" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_72854e8c (
"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,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"tot_chrg_amt" BIGINT,
"tot_alowd_amt" BIGINT,
"tot_mdcr_pymt_amt" BIGINT,
"tot_mdcr_stdzd_pymt_amt" BIGINT,
"tot_outlier_pymt_amt" BIGINT,
"bene_dual_pct" VARCHAR,
"bene_rrl_pct" VARCHAR,
"bene_avg_age" BIGINT,
"bene_male_pct" VARCHAR,
"bene_feml_pct" VARCHAR,
"bene_race_wht_pct" VARCHAR,
"bene_race_black_pct" VARCHAR,
"bene_race_api_pct" VARCHAR,
"bene_race_hspnc_pct" VARCHAR,
"bene_race_natind_pct" VARCHAR,
"bene_race_unk_pct" VARCHAR,
"bene_race_othr_pct" VARCHAR,
"bene_avg_risk_scre" DOUBLE,
"bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
"bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
"bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
"bene_cc_bh_anxiety_v1_pct" VARCHAR,
"bene_cc_bh_bipolar_v1_pct" VARCHAR,
"bene_cc_bh_depress_v1_pct" VARCHAR,
"bene_cc_bh_mood_v2_pct" VARCHAR,
"bene_cc_bh_pd_v1_pct" VARCHAR,
"bene_cc_bh_ptsd_v1_pct" VARCHAR,
"bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
"bene_cc_bh_tobacco_v1_pct" VARCHAR,
"bene_cc_ph_afib_v2_pct" VARCHAR,
"bene_cc_ph_arthritis_v2_pct" VARCHAR,
"bene_cc_ph_asthma_v2_pct" VARCHAR,
"bene_cc_ph_cancer6_v2_pct" VARCHAR,
"bene_cc_ph_ckd_v2_pct" VARCHAR,
"bene_cc_ph_copd_v2_pct" VARCHAR,
"bene_cc_ph_diabetes_v2_pct" VARCHAR,
"bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
"bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
"bene_cc_ph_hypertension_v2_pct" VARCHAR,
"bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
"bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
"bene_cc_ph_parkinson_v2_pct" VARCHAR,
"bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
"prmry_dx_infctn_pct" VARCHAR,
"prmry_dx_neobld_pct" VARCHAR,
"prmry_dx_endonutrmet_pct" VARCHAR,
"prmry_dx_mntbehneudis_pct" VARCHAR,
"prmry_dx_nervsystm_pct" VARCHAR,
"prmry_dx_entsys_pct" VARCHAR,
"prmry_dx_circsystm_pct" VARCHAR,
"prmry_dx_rspsystm_pct" VARCHAR,
"prmry_dx_digsystm_pct" VARCHAR,
"prmry_dx_sknmussystm_pct" VARCHAR,
"prmry_dx_gusystm_pct" VARCHAR,
"prmry_dx_prgpericong_pct" VARCHAR,
"prmry_dx_sxilldef_pct" VARCHAR,
"prmry_dx_injpois_pct" VARCHAR,
"prmry_dx_hlthsrv_pct" VARCHAR,
"nrsng_visits_cnt" VARCHAR,
"msw_visits_cnt" VARCHAR,
"aide_visits_cnt" VARCHAR,
"tot_nrsng_mnts" VARCHAR,
"tot_pt_mnts" VARCHAR,
"tot_ot_mnts" VARCHAR,
"tot_slp_mnts" VARCHAR,
"tot_hh_lupa_epsds_cnt" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_8011ff5a (
"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,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"tot_chrg_amt" BIGINT,
"tot_alowd_amt" BIGINT,
"tot_mdcr_pymt_amt" BIGINT,
"tot_mdcr_stdzd_pymt_amt" BIGINT,
"tot_outlier_pymt_amt" BIGINT,
"bene_dual_pct" VARCHAR,
"bene_rrl_pct" VARCHAR,
"bene_avg_age" BIGINT,
"bene_male_pct" VARCHAR,
"bene_feml_pct" VARCHAR,
"bene_race_wht_pct" VARCHAR,
"bene_race_black_pct" VARCHAR,
"bene_race_api_pct" VARCHAR,
"bene_race_hspnc_pct" VARCHAR,
"bene_race_natind_pct" VARCHAR,
"bene_race_unk_pct" VARCHAR,
"bene_race_othr_pct" VARCHAR,
"bene_avg_risk_scre" DOUBLE,
"bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
"bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
"bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
"bene_cc_bh_anxiety_v1_pct" VARCHAR,
"bene_cc_bh_bipolar_v1_pct" VARCHAR,
"bene_cc_bh_depress_v1_pct" VARCHAR,
"bene_cc_bh_mood_v2_pct" VARCHAR,
"bene_cc_bh_pd_v1_pct" VARCHAR,
"bene_cc_bh_ptsd_v1_pct" VARCHAR,
"bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
"bene_cc_bh_tobacco_v1_pct" VARCHAR,
"bene_cc_ph_afib_v2_pct" VARCHAR,
"bene_cc_ph_arthritis_v2_pct" VARCHAR,
"bene_cc_ph_asthma_v2_pct" VARCHAR,
"bene_cc_ph_cancer6_v2_pct" VARCHAR,
"bene_cc_ph_ckd_v2_pct" VARCHAR,
"bene_cc_ph_copd_v2_pct" VARCHAR,
"bene_cc_ph_diabetes_v2_pct" VARCHAR,
"bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
"bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
"bene_cc_ph_hypertension_v2_pct" VARCHAR,
"bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
"bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
"bene_cc_ph_parkinson_v2_pct" VARCHAR,
"bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
"prmry_dx_infctn_pct" VARCHAR,
"prmry_dx_neobld_pct" VARCHAR,
"prmry_dx_endonutrmet_pct" VARCHAR,
"prmry_dx_mntbehneudis_pct" VARCHAR,
"prmry_dx_nervsystm_pct" VARCHAR,
"prmry_dx_entsys_pct" BIGINT,
"prmry_dx_circsystm_pct" VARCHAR,
"prmry_dx_rspsystm_pct" VARCHAR,
"prmry_dx_digsystm_pct" VARCHAR,
"prmry_dx_sknmussystm_pct" VARCHAR,
"prmry_dx_gusystm_pct" VARCHAR,
"prmry_dx_prgpericong_pct" VARCHAR,
"prmry_dx_sxilldef_pct" VARCHAR,
"prmry_dx_injpois_pct" VARCHAR,
"prmry_dx_hlthsrv_pct" VARCHAR,
"nrsng_visits_cnt" VARCHAR,
"msw_visits_cnt" VARCHAR,
"aide_visits_cnt" VARCHAR,
"tot_nrsng_mnts" VARCHAR,
"tot_pt_mnts" VARCHAR,
"tot_ot_mnts" VARCHAR,
"tot_slp_mnts" VARCHAR,
"tot_hh_lupa_epsds_cnt" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_9a7be084 (
"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,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"tot_chrg_amt" BIGINT,
"tot_alowd_amt" BIGINT,
"tot_mdcr_pymt_amt" BIGINT,
"tot_mdcr_stdzd_pymt_amt" BIGINT,
"tot_outlier_pymt_amt" BIGINT,
"bene_dual_pct" VARCHAR,
"bene_rrl_pct" VARCHAR,
"bene_avg_age" BIGINT,
"bene_male_pct" VARCHAR,
"bene_feml_pct" VARCHAR,
"bene_race_wht_pct" VARCHAR,
"bene_race_black_pct" VARCHAR,
"bene_race_api_pct" VARCHAR,
"bene_race_hspnc_pct" VARCHAR,
"bene_race_natind_pct" VARCHAR,
"bene_race_unk_pct" VARCHAR,
"bene_race_othr_pct" VARCHAR,
"bene_avg_risk_scre" DOUBLE,
"bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
"bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
"bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
"bene_cc_bh_anxiety_v1_pct" VARCHAR,
"bene_cc_bh_bipolar_v1_pct" VARCHAR,
"bene_cc_bh_depress_v1_pct" VARCHAR,
"bene_cc_bh_mood_v2_pct" VARCHAR,
"bene_cc_bh_pd_v1_pct" VARCHAR,
"bene_cc_bh_ptsd_v1_pct" VARCHAR,
"bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
"bene_cc_bh_tobacco_v1_pct" VARCHAR,
"bene_cc_ph_afib_v2_pct" VARCHAR,
"bene_cc_ph_arthritis_v2_pct" VARCHAR,
"bene_cc_ph_asthma_v2_pct" VARCHAR,
"bene_cc_ph_cancer6_v2_pct" VARCHAR,
"bene_cc_ph_ckd_v2_pct" VARCHAR,
"bene_cc_ph_copd_v2_pct" VARCHAR,
"bene_cc_ph_diabetes_v2_pct" VARCHAR,
"bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
"bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
"bene_cc_ph_hypertension_v2_pct" VARCHAR,
"bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
"bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
"bene_cc_ph_parkinson_v2_pct" VARCHAR,
"bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
"prmry_dx_infctn_pct" VARCHAR,
"prmry_dx_neobld_pct" VARCHAR,
"prmry_dx_endonutrmet_pct" VARCHAR,
"prmry_dx_mntbehneudis_pct" VARCHAR,
"prmry_dx_nervsystm_pct" VARCHAR,
"prmry_dx_entsys_pct" VARCHAR,
"prmry_dx_circsystm_pct" VARCHAR,
"prmry_dx_rspsystm_pct" VARCHAR,
"prmry_dx_digsystm_pct" VARCHAR,
"prmry_dx_sknmussystm_pct" VARCHAR,
"prmry_dx_gusystm_pct" VARCHAR,
"prmry_dx_prgpericong_pct" VARCHAR,
"prmry_dx_sxilldef_pct" VARCHAR,
"prmry_dx_injpois_pct" VARCHAR,
"prmry_dx_hlthsrv_pct" VARCHAR,
"nrsng_visits_cnt" VARCHAR,
"msw_visits_cnt" VARCHAR,
"aide_visits_cnt" VARCHAR,
"tot_nrsng_mnts" VARCHAR,
"tot_pt_mnts" VARCHAR,
"tot_ot_mnts" VARCHAR,
"tot_slp_mnts" VARCHAR,
"tot_hh_lupa_epsds_cnt" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_c2adea92 (
"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,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"tot_chrg_amt" BIGINT,
"tot_alowd_amt" BIGINT,
"tot_mdcr_pymt_amt" BIGINT,
"tot_mdcr_stdzd_pymt_amt" BIGINT,
"tot_outlier_pymt_amt" BIGINT,
"bene_dual_pct" VARCHAR,
"bene_rrl_pct" VARCHAR,
"bene_avg_age" BIGINT,
"bene_male_pct" VARCHAR,
"bene_feml_pct" VARCHAR,
"bene_race_wht_pct" VARCHAR,
"bene_race_black_pct" VARCHAR,
"bene_race_api_pct" VARCHAR,
"bene_race_hspnc_pct" VARCHAR,
"bene_race_natind_pct" VARCHAR,
"bene_race_unk_pct" VARCHAR,
"bene_race_othr_pct" VARCHAR,
"bene_avg_risk_scre" DOUBLE,
"bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
"bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
"bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
"bene_cc_bh_anxiety_v1_pct" VARCHAR,
"bene_cc_bh_bipolar_v1_pct" VARCHAR,
"bene_cc_bh_depress_v1_pct" VARCHAR,
"bene_cc_bh_mood_v2_pct" VARCHAR,
"bene_cc_bh_pd_v1_pct" VARCHAR,
"bene_cc_bh_ptsd_v1_pct" VARCHAR,
"bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
"bene_cc_bh_tobacco_v1_pct" VARCHAR,
"bene_cc_ph_afib_v2_pct" VARCHAR,
"bene_cc_ph_arthritis_v2_pct" VARCHAR,
"bene_cc_ph_asthma_v2_pct" VARCHAR,
"bene_cc_ph_cancer6_v2_pct" VARCHAR,
"bene_cc_ph_ckd_v2_pct" VARCHAR,
"bene_cc_ph_copd_v2_pct" VARCHAR,
"bene_cc_ph_diabetes_v2_pct" VARCHAR,
"bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
"bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
"bene_cc_ph_hypertension_v2_pct" VARCHAR,
"bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
"bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
"bene_cc_ph_parkinson_v2_pct" VARCHAR,
"bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
"prmry_dx_infctn_pct" VARCHAR,
"prmry_dx_neobld_pct" VARCHAR,
"prmry_dx_endonutrmet_pct" VARCHAR,
"prmry_dx_mntbehneudis_pct" VARCHAR,
"prmry_dx_nervsystm_pct" VARCHAR,
"prmry_dx_entsys_pct" VARCHAR,
"prmry_dx_circsystm_pct" VARCHAR,
"prmry_dx_rspsystm_pct" VARCHAR,
"prmry_dx_digsystm_pct" VARCHAR,
"prmry_dx_sknmussystm_pct" VARCHAR,
"prmry_dx_gusystm_pct" VARCHAR,
"prmry_dx_prgpericong_pct" VARCHAR,
"prmry_dx_sxilldef_pct" VARCHAR,
"prmry_dx_injpois_pct" VARCHAR,
"prmry_dx_hlthsrv_pct" VARCHAR,
"nrsng_visits_cnt" VARCHAR,
"msw_visits_cnt" VARCHAR,
"aide_visits_cnt" VARCHAR,
"tot_nrsng_mnts" VARCHAR,
"tot_pt_mnts" VARCHAR,
"tot_ot_mnts" VARCHAR,
"tot_slp_mnts" VARCHAR,
"tot_hh_lupa_epsds_cnt" VARCHAR
);CREATE TABLE medicare_post_acute_care_utilization_home_health_agenc_d1d22938 (
"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,
"bene_dstnct_cnt" BIGINT,
"tot_epsd_stay_cnt" BIGINT,
"tot_srvc_days" BIGINT,
"tot_chrg_amt" BIGINT,
"tot_alowd_amt" BIGINT,
"tot_mdcr_pymt_amt" BIGINT,
"tot_mdcr_stdzd_pymt_amt" BIGINT,
"tot_outlier_pymt_amt" BIGINT,
"bene_dual_pct" VARCHAR,
"bene_rrl_pct" VARCHAR,
"bene_avg_age" BIGINT,
"bene_male_pct" VARCHAR,
"bene_feml_pct" VARCHAR,
"bene_race_wht_pct" VARCHAR,
"bene_race_black_pct" VARCHAR,
"bene_race_api_pct" VARCHAR,
"bene_race_hspnc_pct" VARCHAR,
"bene_race_natind_pct" VARCHAR,
"bene_race_unk_pct" VARCHAR,
"bene_race_othr_pct" VARCHAR,
"bene_avg_risk_scre" DOUBLE,
"bene_cc_bh_adhd_othcd_v1_pct" VARCHAR,
"bene_cc_bh_alcohol_drug_v1_pct" VARCHAR,
"bene_cc_bh_alz_nonalzdem_v2_pct" VARCHAR,
"bene_cc_bh_anxiety_v1_pct" VARCHAR,
"bene_cc_bh_bipolar_v1_pct" VARCHAR,
"bene_cc_bh_depress_v1_pct" VARCHAR,
"bene_cc_bh_mood_v2_pct" VARCHAR,
"bene_cc_bh_pd_v1_pct" VARCHAR,
"bene_cc_bh_ptsd_v1_pct" VARCHAR,
"bene_cc_bh_schizo_othpsy_v1_pct" VARCHAR,
"bene_cc_bh_tobacco_v1_pct" VARCHAR,
"bene_cc_ph_afib_v2_pct" VARCHAR,
"bene_cc_ph_arthritis_v2_pct" VARCHAR,
"bene_cc_ph_asthma_v2_pct" VARCHAR,
"bene_cc_ph_cancer6_v2_pct" VARCHAR,
"bene_cc_ph_ckd_v2_pct" VARCHAR,
"bene_cc_ph_copd_v2_pct" VARCHAR,
"bene_cc_ph_diabetes_v2_pct" VARCHAR,
"bene_cc_ph_hf_nonihd_v2_pct" VARCHAR,
"bene_cc_ph_hyperlipidemia_v2_pct" VARCHAR,
"bene_cc_ph_hypertension_v2_pct" VARCHAR,
"bene_cc_ph_ischemicheart_v2_pct" VARCHAR,
"bene_cc_ph_osteoporosis_v2_pct" VARCHAR,
"bene_cc_ph_parkinson_v2_pct" VARCHAR,
"bene_cc_ph_stroke_tia_v2_pct" VARCHAR,
"prmry_dx_infctn_pct" VARCHAR,
"prmry_dx_neobld_pct" VARCHAR,
"prmry_dx_endonutrmet_pct" VARCHAR,
"prmry_dx_mntbehneudis_pct" VARCHAR,
"prmry_dx_nervsystm_pct" VARCHAR,
"prmry_dx_entsys_pct" VARCHAR,
"prmry_dx_circsystm_pct" VARCHAR,
"prmry_dx_rspsystm_pct" VARCHAR,
"prmry_dx_digsystm_pct" VARCHAR,
"prmry_dx_sknmussystm_pct" VARCHAR,
"prmry_dx_gusystm_pct" VARCHAR,
"prmry_dx_prgpericong_pct" VARCHAR,
"prmry_dx_sxilldef_pct" VARCHAR,
"prmry_dx_injpois_pct" VARCHAR,
"prmry_dx_hlthsrv_pct" VARCHAR,
"nrsng_visits_cnt" VARCHAR,
"msw_visits_cnt" VARCHAR,
"aide_visits_cnt" VARCHAR,
"tot_nrsng_mnts" VARCHAR,
"tot_pt_mnts" VARCHAR,
"tot_ot_mnts" VARCHAR,
"tot_slp_mnts" VARCHAR,
"tot_hh_lupa_epsds_cnt" VARCHAR
);Anyone who has the link will be able to view this.