Baselight
Sign In

Medicare Post-Acute Care Utilization - Long-Term Care Hospital

U.S. Department of Health & Human Services

@usgov.hhs_gov_medicare_post_acute_care_utilization_long_term_b57be9c4

Loading...
Loading...

About this Dataset

Medicare Post-Acute Care Utilization - Long-Term Care Hospital

The Medicare Post-Acute Care (PAC) Utilization - Long-Term Care Hospital (LTCH) 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 LTCH setting.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:20:19.520232
Tags: health-care-use-payments, hospitals-facilities, inpatient, long-term-care, medicare, national, original-medicare, states-territories

Tables

Medicare Post-Acute Care Utilization - Long-Term Care Hospital : 2017-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_long_term_b57be9c4.medicare_post_acute_care_utilization_long_term_care_ho_1483c923
  • 110.12 kB
  • 461 rows
  • 70 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_long_term_care_ho_1483c923 (
  "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
);

Medicare Post-Acute Care Utilization - Long-Term Care Hospital : 2019-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_long_term_b57be9c4.medicare_post_acute_care_utilization_long_term_care_ho_262019c7
  • 104.75 kB
  • 411 rows
  • 70 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_long_term_care_ho_262019c7 (
  "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
);

Medicare Post-Acute Care Utilization - Long-Term Care Hospital : 2020-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_long_term_b57be9c4.medicare_post_acute_care_utilization_long_term_care_ho_56896076
  • 103 kB
  • 398 rows
  • 70 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_long_term_care_ho_56896076 (
  "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
);

Medicare Post-Acute Care Utilization - Long-Term Care Hospital : 2021-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_long_term_b57be9c4.medicare_post_acute_care_utilization_long_term_care_ho_6313fb86
  • 100.6 kB
  • 383 rows
  • 70 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_long_term_care_ho_6313fb86 (
  "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" BIGINT,
  "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
);

Medicare Post-Acute Care Utilization - Long-Term Care Hospital : 2022-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_long_term_b57be9c4.medicare_post_acute_care_utilization_long_term_care_ho_89ea27d5
  • 100.18 kB
  • 382 rows
  • 70 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_long_term_care_ho_89ea27d5 (
  "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
);

Medicare Post-Acute Care Utilization - Long-Term Care Hospital : 2016-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_long_term_b57be9c4.medicare_post_acute_care_utilization_long_term_care_ho_950bd0c1
  • 98.26 kB
  • 468 rows
  • 70 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_long_term_care_ho_950bd0c1 (
  "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
);

Medicare Post-Acute Care Utilization - Long-Term Care Hospital : 2018-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_long_term_b57be9c4.medicare_post_acute_care_utilization_long_term_care_ho_b9d7dd47
  • 107.11 kB
  • 432 rows
  • 70 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_long_term_care_ho_b9d7dd47 (
  "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" BIGINT,
  "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
);

Medicare Post-Acute Care Utilization - Long-Term Care Hospital : 2014-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_long_term_b57be9c4.medicare_post_acute_care_utilization_long_term_care_ho_d50ba798
  • 98.77 kB
  • 471 rows
  • 70 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_long_term_care_ho_d50ba798 (
  "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
);

Medicare Post-Acute Care Utilization - Long-Term Care Hospital : 2023-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_long_term_b57be9c4.medicare_post_acute_care_utilization_long_term_care_ho_eb444280
  • 99.25 kB
  • 373 rows
  • 70 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_long_term_care_ho_eb444280 (
  "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
);

Medicare Post-Acute Care Utilization - Long-Term Care Hospital : 2015-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_long_term_b57be9c4.medicare_post_acute_care_utilization_long_term_care_ho_f9777238
  • 98.68 kB
  • 471 rows
  • 70 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_long_term_care_ho_f9777238 (
  "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
);

Share link

Anyone who has the link will be able to view this.