Baselight
Sign In

Medicare Post-Acute Care Utilization - Hospice

U.S. Department of Health & Human Services

@usgov.hhs_gov_medicare_post_acute_care_utilization_hospice_01799

Loading...
Loading...

About this Dataset

Medicare Post-Acute Care Utilization - Hospice

The Medicare Post-Acute Care (PAC) Utilization - Hospice dataset contains information on demographic and clinical characteristics of beneficiaries served, professional and paraprofessional service utilization, and payment information at the provider, state, and national levels at the hospice setting.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:28:38.135144
Tags: health-care-use-payments, home-health, hospitals-facilities, inpatient, medicare, national, original-medicare, states-territories

Tables

Medicare Post-Acute Care Utilization - Hospice : 2014-07-17

@usgov.hhs_gov_medicare_post_acute_care_utilization_hospice_01799.medicare_post_acute_care_utilization_hospice_2014_07_17
  • 457.11 kB
  • 3,961 rows
  • 49 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_hospice_2014_07_17 (
  "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,
  "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,
  "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" BIGINT,
  "nrsng_visits_cnt" VARCHAR,
  "msw_visits_cnt" VARCHAR,
  "aide_visits_cnt" VARCHAR,
  "tot_nrsng_mnts" VARCHAR,
  "hospc_rhc_days_pct" BIGINT
);

Medicare Post-Acute Care Utilization - Hospice : 2015-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_hospice_01799.medicare_post_acute_care_utilization_hospice_2015_01_01
  • 464.39 kB
  • 4,035 rows
  • 49 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_hospice_2015_01_01 (
  "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,
  "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,
  "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" BIGINT,
  "nrsng_visits_cnt" VARCHAR,
  "msw_visits_cnt" VARCHAR,
  "aide_visits_cnt" VARCHAR,
  "tot_nrsng_mnts" VARCHAR,
  "hospc_rhc_days_pct" BIGINT
);

Medicare Post-Acute Care Utilization - Hospice : 2016-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_hospice_01799.medicare_post_acute_care_utilization_hospice_2016_01_01
  • 477.94 kB
  • 4,165 rows
  • 49 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_hospice_2016_01_01 (
  "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,
  "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,
  "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" BIGINT,
  "nrsng_visits_cnt" VARCHAR,
  "msw_visits_cnt" VARCHAR,
  "aide_visits_cnt" VARCHAR,
  "tot_nrsng_mnts" VARCHAR,
  "hospc_rhc_days_pct" BIGINT
);

Medicare Post-Acute Care Utilization - Hospice : 2017-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_hospice_01799.medicare_post_acute_care_utilization_hospice_2017_01_01
  • 489.08 kB
  • 4,278 rows
  • 49 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_hospice_2017_01_01 (
  "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,
  "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,
  "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" BIGINT,
  "nrsng_visits_cnt" VARCHAR,
  "msw_visits_cnt" VARCHAR,
  "aide_visits_cnt" VARCHAR,
  "tot_nrsng_mnts" VARCHAR,
  "hospc_rhc_days_pct" BIGINT
);

Medicare Post-Acute Care Utilization - Hospice : 2018-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_hospice_01799.medicare_post_acute_care_utilization_hospice_2018_01_01
  • 504.86 kB
  • 4,425 rows
  • 49 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_hospice_2018_01_01 (
  "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,
  "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,
  "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" BIGINT,
  "nrsng_visits_cnt" VARCHAR,
  "msw_visits_cnt" VARCHAR,
  "aide_visits_cnt" VARCHAR,
  "tot_nrsng_mnts" VARCHAR,
  "hospc_rhc_days_pct" BIGINT
);

Medicare Post-Acute Care Utilization - Hospice : 2019-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_hospice_01799.medicare_post_acute_care_utilization_hospice_2019_01_01
  • 519.28 kB
  • 4,600 rows
  • 49 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_hospice_2019_01_01 (
  "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,
  "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,
  "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" BIGINT,
  "nrsng_visits_cnt" VARCHAR,
  "msw_visits_cnt" VARCHAR,
  "aide_visits_cnt" VARCHAR,
  "tot_nrsng_mnts" VARCHAR,
  "hospc_rhc_days_pct" BIGINT
);

Medicare Post-Acute Care Utilization - Hospice : 2020-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_hospice_01799.medicare_post_acute_care_utilization_hospice_2020_01_01
  • 536.39 kB
  • 4,770 rows
  • 49 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_hospice_2020_01_01 (
  "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,
  "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,
  "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,
  "hospc_rhc_days_pct" BIGINT
);

Medicare Post-Acute Care Utilization - Hospice : 2021-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_hospice_01799.medicare_post_acute_care_utilization_hospice_2021_01_01
  • 560.09 kB
  • 5,048 rows
  • 49 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_hospice_2021_01_01 (
  "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,
  "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,
  "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,
  "hospc_rhc_days_pct" BIGINT
);

Medicare Post-Acute Care Utilization - Hospice : 2022-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_hospice_01799.medicare_post_acute_care_utilization_hospice_2022_01_01
  • 589.62 kB
  • 5,366 rows
  • 49 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_hospice_2022_01_01 (
  "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,
  "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,
  "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,
  "hospc_rhc_days_pct" BIGINT
);

Medicare Post-Acute Care Utilization - Hospice : 2023-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_hospice_01799.medicare_post_acute_care_utilization_hospice_2023_01_01
  • 627.22 kB
  • 5,824 rows
  • 49 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_hospice_2023_01_01 (
  "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,
  "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,
  "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,
  "hospc_rhc_days_pct" BIGINT
);

Share link

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