Baselight
Sign In

Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility

U.S. Department of Health & Human Services

@usgov.hhs_gov_medicare_post_acute_care_utilization_inpatient_88a912a5

Loading...
Loading...

About this Dataset

Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility

The Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility (IRF) 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 IRF setting.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:22:39.743936
Tags: health-care-use-payments, hospitals-facilities, inpatient, medicare, national, original-medicare, rehabilitation, states-territories

Tables

Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility : 2017-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_inpatient_88a912a5.medicare_post_acute_care_utilization_inpatient_rehabil_0833cbec
  • 271.03 kB
  • 1,172 rows
  • 83 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_inpatient_rehabil_0833cbec (
  "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,
  "tot_pt_mnts" BIGINT,
  "indvdl_pt_mnts" BIGINT,
  "cncrnt_grp_pt_mnts" BIGINT,
  "cotrt_pt_mnts" BIGINT,
  "tot_ot_mnts" BIGINT,
  "indvdl_ot_mnts" BIGINT,
  "cncrnt_grp_ot_mnts" BIGINT,
  "cotrt_ot_mnts" BIGINT,
  "tot_slp_mnts" BIGINT,
  "indvdl_slp_mnts" BIGINT,
  "cncrnt_grp_slp_mnts" BIGINT,
  "cotrt_slp_mnts" BIGINT,
  "tot_asmt_cnt" BIGINT
);

Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility : 2015-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_inpatient_88a912a5.medicare_post_acute_care_utilization_inpatient_rehabil_08759a96
  • 172.86 kB
  • 1,178 rows
  • 83 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_inpatient_rehabil_08759a96 (
  "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,
  "tot_pt_mnts" VARCHAR,
  "indvdl_pt_mnts" VARCHAR,
  "cncrnt_grp_pt_mnts" VARCHAR,
  "cotrt_pt_mnts" VARCHAR,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "cotrt_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "cotrt_slp_mnts" VARCHAR,
  "tot_asmt_cnt" BIGINT
);

Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility : 2014-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_inpatient_88a912a5.medicare_post_acute_care_utilization_inpatient_rehabil_18628c34
  • 172.68 kB
  • 1,183 rows
  • 83 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_inpatient_rehabil_18628c34 (
  "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,
  "tot_pt_mnts" VARCHAR,
  "indvdl_pt_mnts" VARCHAR,
  "cncrnt_grp_pt_mnts" VARCHAR,
  "cotrt_pt_mnts" VARCHAR,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "cotrt_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "cotrt_slp_mnts" VARCHAR,
  "tot_asmt_cnt" VARCHAR
);

Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility : 2016-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_inpatient_88a912a5.medicare_post_acute_care_utilization_inpatient_rehabil_3836e600
  • 260.85 kB
  • 1,186 rows
  • 83 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_inpatient_rehabil_3836e600 (
  "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,
  "tot_pt_mnts" VARCHAR,
  "indvdl_pt_mnts" VARCHAR,
  "cncrnt_grp_pt_mnts" VARCHAR,
  "cotrt_pt_mnts" VARCHAR,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "cotrt_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "cotrt_slp_mnts" VARCHAR,
  "tot_asmt_cnt" VARCHAR
);

Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility : 2020-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_inpatient_88a912a5.medicare_post_acute_care_utilization_inpatient_rehabil_40577fdc
  • 275.06 kB
  • 1,158 rows
  • 82 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_inpatient_rehabil_40577fdc (
  "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,
  "tot_pt_mnts" VARCHAR,
  "indvdl_pt_mnts" VARCHAR,
  "cncrnt_grp_pt_mnts" VARCHAR,
  "cotrt_pt_mnts" VARCHAR,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "cotrt_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "cotrt_slp_mnts" VARCHAR
);

Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility : 2023-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_inpatient_88a912a5.medicare_post_acute_care_utilization_inpatient_rehabil_461fc742
  • 282.69 kB
  • 1,205 rows
  • 82 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_inpatient_rehabil_461fc742 (
  "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,
  "tot_pt_mnts" VARCHAR,
  "indvdl_pt_mnts" VARCHAR,
  "cncrnt_grp_pt_mnts" VARCHAR,
  "cotrt_pt_mnts" VARCHAR,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "cotrt_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "cotrt_slp_mnts" VARCHAR
);

Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility : 2021-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_inpatient_88a912a5.medicare_post_acute_care_utilization_inpatient_rehabil_58fe17e2
  • 275.26 kB
  • 1,163 rows
  • 82 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_inpatient_rehabil_58fe17e2 (
  "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,
  "tot_pt_mnts" VARCHAR,
  "indvdl_pt_mnts" VARCHAR,
  "cncrnt_grp_pt_mnts" VARCHAR,
  "cotrt_pt_mnts" VARCHAR,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "cotrt_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "cotrt_slp_mnts" VARCHAR
);

Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility : 2019-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_inpatient_88a912a5.medicare_post_acute_care_utilization_inpatient_rehabil_5f8023f7
  • 268.79 kB
  • 1,159 rows
  • 83 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_inpatient_rehabil_5f8023f7 (
  "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,
  "tot_pt_mnts" BIGINT,
  "indvdl_pt_mnts" BIGINT,
  "cncrnt_grp_pt_mnts" BIGINT,
  "cotrt_pt_mnts" BIGINT,
  "tot_ot_mnts" BIGINT,
  "indvdl_ot_mnts" BIGINT,
  "cncrnt_grp_ot_mnts" BIGINT,
  "cotrt_ot_mnts" BIGINT,
  "tot_slp_mnts" BIGINT,
  "indvdl_slp_mnts" BIGINT,
  "cncrnt_grp_slp_mnts" BIGINT,
  "cotrt_slp_mnts" BIGINT,
  "tot_asmt_cnt" BIGINT
);

Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility : 2022-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_inpatient_88a912a5.medicare_post_acute_care_utilization_inpatient_rehabil_75fe35c3
  • 277.26 kB
  • 1,174 rows
  • 82 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_inpatient_rehabil_75fe35c3 (
  "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,
  "tot_pt_mnts" VARCHAR,
  "indvdl_pt_mnts" VARCHAR,
  "cncrnt_grp_pt_mnts" VARCHAR,
  "cotrt_pt_mnts" VARCHAR,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "cotrt_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "cotrt_slp_mnts" VARCHAR
);

Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility : 2018-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_inpatient_88a912a5.medicare_post_acute_care_utilization_inpatient_rehabil_cde43caa
  • 284 kB
  • 1,169 rows
  • 83 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_inpatient_rehabil_cde43caa (
  "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,
  "tot_pt_mnts" VARCHAR,
  "indvdl_pt_mnts" VARCHAR,
  "cncrnt_grp_pt_mnts" VARCHAR,
  "cotrt_pt_mnts" VARCHAR,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "cotrt_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "cotrt_slp_mnts" VARCHAR,
  "tot_asmt_cnt" VARCHAR
);

Share link

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