Baselight
Sign In

Medicare Post-Acute Care Utilization - Skilled Nursing Facility

U.S. Department of Health & Human Services

@usgov.hhs_gov_medicare_post_acute_care_utilization_skilled_n_507e4e3c

Loading...
Loading...

About this Dataset

Medicare Post-Acute Care Utilization - Skilled Nursing Facility

The Medicare Post-Acute Care (PAC) Utilization - Skilled Nursing Facility (SNF) 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 SNF setting.
 
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:29:44.545521
Tags: health-care-use-payments, hospitals-facilities, medicare, national, original-medicare, skilled-nursing, states-territories

Tables

Medicare Post-Acute Care Utilization - Skilled Nursing Facility : 2017-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_skilled_n_507e4e3c.medicare_post_acute_care_utilization_skilled_nursing_f_54b6a6cf
  • 2.32 MB
  • 15,064 rows
  • 81 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_54b6a6cf (
  "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,
  "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,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "tot_asmt_cnt" VARCHAR,
  "asmt_10_mnts_rv_thrshld_pct" VARCHAR,
  "asmt_10_mnts_ru_thrshld_pct" VARCHAR
);

Medicare Post-Acute Care Utilization - Skilled Nursing Facility : 2015-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_skilled_n_507e4e3c.medicare_post_acute_care_utilization_skilled_nursing_f_9eff86d9
  • 2.02 MB
  • 15,112 rows
  • 81 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_9eff86d9 (
  "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,
  "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,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "tot_asmt_cnt" VARCHAR,
  "asmt_10_mnts_rv_thrshld_pct" VARCHAR,
  "asmt_10_mnts_ru_thrshld_pct" VARCHAR
);

Medicare Post-Acute Care Utilization - Skilled Nursing Facility : 2023-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_skilled_n_507e4e3c.medicare_post_acute_care_utilization_skilled_nursing_f_b32726d5
  • 1.48 MB
  • 14,214 rows
  • 69 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_b32726d5 (
  "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,
  "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 - Skilled Nursing Facility : 2022-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_skilled_n_507e4e3c.medicare_post_acute_care_utilization_skilled_nursing_f_c10ae2ea
  • 1.51 MB
  • 14,440 rows
  • 69 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_c10ae2ea (
  "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,
  "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 - Skilled Nursing Facility : 2014-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_skilled_n_507e4e3c.medicare_post_acute_care_utilization_skilled_nursing_f_c5ed039b
  • 1.99 MB
  • 15,081 rows
  • 81 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_c5ed039b (
  "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,
  "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,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "tot_asmt_cnt" VARCHAR,
  "asmt_10_mnts_rv_thrshld_pct" VARCHAR,
  "asmt_10_mnts_ru_thrshld_pct" VARCHAR
);

Medicare Post-Acute Care Utilization - Skilled Nursing Facility : 2016-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_skilled_n_507e4e3c.medicare_post_acute_care_utilization_skilled_nursing_f_d9cb9259
  • 2.03 MB
  • 15,066 rows
  • 81 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_d9cb9259 (
  "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,
  "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,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "tot_asmt_cnt" VARCHAR,
  "asmt_10_mnts_rv_thrshld_pct" VARCHAR,
  "asmt_10_mnts_ru_thrshld_pct" VARCHAR
);

Medicare Post-Acute Care Utilization - Skilled Nursing Facility : 2020-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_skilled_n_507e4e3c.medicare_post_acute_care_utilization_skilled_nursing_f_dbcfd93a
  • 1.53 MB
  • 14,671 rows
  • 69 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_dbcfd93a (
  "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,
  "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 - Skilled Nursing Facility : 2021-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_skilled_n_507e4e3c.medicare_post_acute_care_utilization_skilled_nursing_f_dd97127a
  • 1.52 MB
  • 14,612 rows
  • 69 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_dd97127a (
  "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,
  "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 - Skilled Nursing Facility : 2018-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_skilled_n_507e4e3c.medicare_post_acute_care_utilization_skilled_nursing_f_ea5e9d75
  • 2.31 MB
  • 14,989 rows
  • 81 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_ea5e9d75 (
  "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,
  "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,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "tot_asmt_cnt" VARCHAR,
  "asmt_10_mnts_rv_thrshld_pct" VARCHAR,
  "asmt_10_mnts_ru_thrshld_pct" VARCHAR
);

Medicare Post-Acute Care Utilization - Skilled Nursing Facility : 2019-01-01

@usgov.hhs_gov_medicare_post_acute_care_utilization_skilled_n_507e4e3c.medicare_post_acute_care_utilization_skilled_nursing_f_eae8ae55
  • 2.31 MB
  • 14,873 rows
  • 81 columns
Loading... 
CREATE TABLE medicare_post_acute_care_utilization_skilled_nursing_f_eae8ae55 (
  "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,
  "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,
  "tot_ot_mnts" VARCHAR,
  "indvdl_ot_mnts" VARCHAR,
  "cncrnt_grp_ot_mnts" VARCHAR,
  "tot_slp_mnts" VARCHAR,
  "indvdl_slp_mnts" VARCHAR,
  "cncrnt_grp_slp_mnts" VARCHAR,
  "tot_asmt_cnt" VARCHAR,
  "asmt_10_mnts_rv_thrshld_pct" VARCHAR,
  "asmt_10_mnts_ru_thrshld_pct" VARCHAR
);

Share link

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