Home

Dataset:

Name hospital-quarterly-financial-utilization-report-complete-data-set
Updated 2025-07-30
CA Dataset link
Current False
Tables
2016_quarter_4_complete_data_set_4_14_17     fac_no - varchar(9)
fac_name - varchar(79)
year_qtr - varchar(8)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(9)
county_name - varchar(15)
hsa - varchar(3)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(10)
phone - varchar(14)
address - varchar(36)
city - varchar(19)
zip_code - varchar(8)
ceo - varchar(26)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcar_mc - varchar(11)
dis_mcal - varchar(8)
dis_mcal_mc - varchar(11)
dis_cnty - varchar(8)
dis_cnty_mc - varchar(11)
dis_thrd - varchar(8)
dis_thrd_mc - varchar(11)
dis_indgnt - varchar(10)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcar_mc - varchar(11)
day_mcal - varchar(8)
day_mcal_mc - varchar(11)
day_cnty - varchar(8)
day_cnty_mc - varchar(11)
day_thrd - varchar(8)
day_thrd_mc - varchar(11)
day_indgnt - varchar(10)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcar_mc - varchar(11)
vis_mcal - varchar(8)
vis_mcal_mc - varchar(11)
vis_cnty - varchar(8)
vis_cnty_mc - varchar(11)
vis_thrd - varchar(8)
vis_thrd_mc - varchar(11)
vis_indgnt - varchar(10)
vis_oth - varchar(7)
vis_tot - varchar(7)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(12)
grip_mcal - varchar(11)
grip_mcal_mc - varchar(12)
grip_cnty - varchar(11)
grip_cnty_mc - varchar(12)
grip_thrd - varchar(11)
grip_thrd_mc - varchar(12)
grip_indgnt - varchar(11)
grip_oth - varchar(10)
grip_tot - varchar(14)
grop_mcar - varchar(11)
grop_mcar_mc - varchar(12)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(12)
grop_cnty - varchar(11)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(11)
grop_thrd_mc - varchar(12)
grop_indgnt - varchar(11)
grop_oth - varchar(11)
grop_tot - varchar(14)
bad_debt - varchar(12)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(12)
cadj_mcal - varchar(12)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(13)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(12)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(11)
sub_indgnt - varchar(11)
tch_allow - varchar(9)
tch_supp - varchar(11)
ded_oth - varchar(10)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(10)
cap_cnty - varchar(10)
cap_thrd - varchar(10)
cap_tot - varchar(10)
net_mcar - varchar(12)
net_mcar_mc - varchar(11)
net_mcal - varchar(12)
net_mcal_mc - varchar(12)
net_cnty - varchar(10)
net_cnty_mc - varchar(11)
net_thrd - varchar(12)
net_thrd_mc - varchar(12)
net_indgnt - varchar(12)
net_oth - varchar(11)
net_tot - varchar(12)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(10)
nonop_rev - varchar(12)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(11)
cap_exp - varchar(12)
fix_assets - varchar(14)
disp_trnfr - varchar(10)
dis_tot_cc - varchar(10)
pat_day_tot_cc - varchar(14)
tot_out_vis_cc - varchar(14)
gros_inpat_rev_cc - varchar(17)
gros_outpat_rev_cc - varchar(18)
contr_adj_cc - varchar(12)
othr_deduct_cc - varchar(14)
cap_prem_rev_cc - varchar(15)
net_pat_rev_cc - varchar(14)
qa_fees - varchar(11)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)
2017_quarter_1_complete_data_set_7_14_17     fac_no - varchar(9)
fac_name - varchar(79)
year_qtr - varchar(8)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(9)
county_name - varchar(15)
hsa - varchar(3)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(10)
phone - varchar(14)
address - varchar(36)
city - varchar(19)
zip_code - varchar(8)
ceo - varchar(26)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcar_mc - varchar(11)
dis_mcal - varchar(8)
dis_mcal_mc - varchar(11)
dis_cnty - varchar(8)
dis_cnty_mc - varchar(11)
dis_thrd - varchar(8)
dis_thrd_mc - varchar(11)
dis_indgnt - varchar(10)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcar_mc - varchar(11)
day_mcal - varchar(8)
day_mcal_mc - varchar(11)
day_cnty - varchar(8)
day_cnty_mc - varchar(11)
day_thrd - varchar(8)
day_thrd_mc - varchar(11)
day_indgnt - varchar(10)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcar_mc - varchar(11)
vis_mcal - varchar(8)
vis_mcal_mc - varchar(11)
vis_cnty - varchar(8)
vis_cnty_mc - varchar(11)
vis_thrd - varchar(8)
vis_thrd_mc - varchar(11)
vis_indgnt - varchar(10)
vis_oth - varchar(7)
vis_tot - varchar(7)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(11)
grip_mcal_mc - varchar(12)
grip_cnty - varchar(11)
grip_cnty_mc - varchar(12)
grip_thrd - varchar(11)
grip_thrd_mc - varchar(14)
grip_indgnt - varchar(11)
grip_oth - varchar(10)
grip_tot - varchar(14)
grop_mcar - varchar(11)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(12)
grop_cnty - varchar(11)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(11)
grop_thrd_mc - varchar(14)
grop_indgnt - varchar(11)
grop_oth - varchar(11)
grop_tot - varchar(14)
bad_debt - varchar(11)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(12)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(13)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(11)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(10)
sub_indgnt - varchar(11)
tch_allow - varchar(9)
tch_supp - varchar(11)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(10)
cap_cnty - varchar(11)
cap_thrd - varchar(10)
cap_tot - varchar(10)
net_mcar - varchar(12)
net_mcar_mc - varchar(11)
net_mcal - varchar(12)
net_mcal_mc - varchar(11)
net_cnty - varchar(11)
net_cnty_mc - varchar(11)
net_thrd - varchar(12)
net_thrd_mc - varchar(14)
net_indgnt - varchar(11)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(12)
tot_op_exp - varchar(14)
phy_comp - varchar(10)
nonop_rev - varchar(11)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(11)
cap_exp - varchar(12)
fix_assets - varchar(14)
disp_trnfr - varchar(10)
dis_tot_cc - varchar(10)
pat_day_tot_cc - varchar(14)
tot_out_vis_cc - varchar(14)
gros_inpat_rev_cc - varchar(17)
gros_outpat_rev_cc - varchar(18)
contr_adj_cc - varchar(12)
othr_deduct_cc - varchar(14)
cap_prem_rev_cc - varchar(15)
net_pat_rev_cc - varchar(14)
qa_fees - varchar(10)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)
2017_quarter_2_complete_data_set_11_02_17     fac_no - varchar(9)
fac_name - varchar(61)
year_qtr - varchar(8)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(9)
county_name - varchar(15)
hsa - varchar(3)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(10)
phone - varchar(14)
address - varchar(37)
city - varchar(19)
zip_code - varchar(8)
ceo - varchar(26)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcar_mc - varchar(11)
dis_mcal - varchar(8)
dis_mcal_mc - varchar(11)
dis_cnty - varchar(8)
dis_cnty_mc - varchar(11)
dis_thrd - varchar(8)
dis_thrd_mc - varchar(11)
dis_indgnt - varchar(10)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcar_mc - varchar(11)
day_mcal - varchar(8)
day_mcal_mc - varchar(11)
day_cnty - varchar(8)
day_cnty_mc - varchar(11)
day_thrd - varchar(8)
day_thrd_mc - varchar(11)
day_indgnt - varchar(10)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcar_mc - varchar(11)
vis_mcal - varchar(8)
vis_mcal_mc - varchar(11)
vis_cnty - varchar(8)
vis_cnty_mc - varchar(11)
vis_thrd - varchar(8)
vis_thrd_mc - varchar(11)
vis_indgnt - varchar(10)
vis_oth - varchar(7)
vis_tot - varchar(7)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(11)
grip_mcal_mc - varchar(12)
grip_cnty - varchar(11)
grip_cnty_mc - varchar(12)
grip_thrd - varchar(11)
grip_thrd_mc - varchar(14)
grip_indgnt - varchar(11)
grip_oth - varchar(10)
grip_tot - varchar(14)
grop_mcar - varchar(11)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(12)
grop_cnty - varchar(11)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(11)
grop_thrd_mc - varchar(14)
grop_indgnt - varchar(11)
grop_oth - varchar(10)
grop_tot - varchar(14)
bad_debt - varchar(11)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(11)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(13)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(11)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(10)
sub_indgnt - varchar(12)
tch_allow - varchar(9)
tch_supp - varchar(11)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(10)
cap_cnty - varchar(11)
cap_thrd - varchar(10)
cap_tot - varchar(11)
net_mcar - varchar(12)
net_mcar_mc - varchar(11)
net_mcal - varchar(11)
net_mcal_mc - varchar(11)
net_cnty - varchar(12)
net_cnty_mc - varchar(11)
net_thrd - varchar(12)
net_thrd_mc - varchar(14)
net_indgnt - varchar(11)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(12)
tot_op_exp - varchar(14)
phy_comp - varchar(10)
nonop_rev - varchar(13)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(11)
cap_exp - varchar(12)
fix_assets - varchar(14)
disp_trnfr - varchar(10)
dis_tot_cc - varchar(10)
pat_day_tot_cc - varchar(14)
tot_out_vis_cc - varchar(14)
gros_inpat_rev_cc - varchar(17)
gros_outpat_rev_cc - varchar(18)
contr_adj_cc - varchar(12)
othr_deduct_cc - varchar(14)
cap_prem_rev_cc - varchar(15)
net_pat_rev_cc - varchar(14)
qa_fees - varchar(10)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)
2017_quarter_3_complete_data_set_1_12_18     fac_no - varchar(9)
fac_name - varchar(61)
year_qtr - varchar(8)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(9)
county_name - varchar(15)
hsa - varchar(3)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(10)
phone - varchar(14)
address - varchar(36)
city - varchar(19)
zip_code - varchar(8)
ceo - varchar(26)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcar_mc - varchar(11)
dis_mcal - varchar(8)
dis_mcal_mc - varchar(11)
dis_cnty - varchar(8)
dis_cnty_mc - varchar(11)
dis_thrd - varchar(8)
dis_thrd_mc - varchar(11)
dis_indgnt - varchar(10)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcar_mc - varchar(11)
day_mcal - varchar(8)
day_mcal_mc - varchar(11)
day_cnty - varchar(8)
day_cnty_mc - varchar(11)
day_thrd - varchar(8)
day_thrd_mc - varchar(11)
day_indgnt - varchar(10)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcar_mc - varchar(11)
vis_mcal - varchar(8)
vis_mcal_mc - varchar(11)
vis_cnty - varchar(8)
vis_cnty_mc - varchar(11)
vis_thrd - varchar(8)
vis_thrd_mc - varchar(11)
vis_indgnt - varchar(10)
vis_oth - varchar(7)
vis_tot - varchar(7)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(11)
grip_mcal_mc - varchar(12)
grip_cnty - varchar(11)
grip_cnty_mc - varchar(12)
grip_thrd - varchar(11)
grip_thrd_mc - varchar(14)
grip_indgnt - varchar(11)
grip_oth - varchar(11)
grip_tot - varchar(14)
grop_mcar - varchar(11)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(12)
grop_cnty - varchar(11)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(11)
grop_thrd_mc - varchar(14)
grop_indgnt - varchar(11)
grop_oth - varchar(11)
grop_tot - varchar(14)
bad_debt - varchar(10)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(11)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(12)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(11)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(11)
sub_indgnt - varchar(10)
tch_allow - varchar(9)
tch_supp - varchar(11)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(10)
cap_cnty - varchar(10)
cap_thrd - varchar(10)
cap_tot - varchar(10)
net_mcar - varchar(11)
net_mcar_mc - varchar(11)
net_mcal - varchar(12)
net_mcal_mc - varchar(11)
net_cnty - varchar(10)
net_cnty_mc - varchar(11)
net_thrd - varchar(12)
net_thrd_mc - varchar(14)
net_indgnt - varchar(11)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(12)
tot_op_exp - varchar(14)
phy_comp - varchar(10)
nonop_rev - varchar(12)
dis_pips - varchar(8)
day_pips - varchar(11)
exp_pips - varchar(10)
exp_pops - varchar(11)
cap_exp - varchar(12)
fix_assets - varchar(14)
disp_trnfr - varchar(10)
dis_tot_cc - varchar(10)
pat_day_tot_cc - varchar(14)
tot_out_vis_cc - varchar(14)
gros_inpat_rev_cc - varchar(17)
gros_outpat_rev_cc - varchar(18)
contr_adj_cc - varchar(12)
othr_deduct_cc - varchar(14)
cap_prem_rev_cc - varchar(15)
net_pat_rev_cc - varchar(14)
qa_fees - varchar(10)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)
2017_quarter_4_complete_data_set_4_13_18     fac_no - varchar(9)
fac_name - varchar(61)
year_qtr - varchar(8)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(9)
county_name - varchar(15)
hsa - varchar(3)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(10)
phone - varchar(12)
address - varchar(34)
city - varchar(19)
zip_code - varchar(8)
ceo - varchar(26)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcar_mc - varchar(11)
dis_mcal - varchar(8)
dis_mcal_mc - varchar(11)
dis_cnty - varchar(8)
dis_cnty_mc - varchar(11)
dis_thrd - varchar(8)
dis_thrd_mc - varchar(11)
dis_indgnt - varchar(10)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcar_mc - varchar(11)
day_mcal - varchar(8)
day_mcal_mc - varchar(11)
day_cnty - varchar(8)
day_cnty_mc - varchar(11)
day_thrd - varchar(8)
day_thrd_mc - varchar(11)
day_indgnt - varchar(10)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcar_mc - varchar(11)
vis_mcal - varchar(8)
vis_mcal_mc - varchar(11)
vis_cnty - varchar(8)
vis_cnty_mc - varchar(11)
vis_thrd - varchar(8)
vis_thrd_mc - varchar(11)
vis_indgnt - varchar(10)
vis_oth - varchar(7)
vis_tot - varchar(7)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(11)
grip_mcal_mc - varchar(12)
grip_cnty - varchar(11)
grip_cnty_mc - varchar(12)
grip_thrd - varchar(11)
grip_thrd_mc - varchar(14)
grip_indgnt - varchar(11)
grip_oth - varchar(10)
grip_tot - varchar(14)
grop_mcar - varchar(11)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(12)
grop_cnty - varchar(11)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(11)
grop_thrd_mc - varchar(14)
grop_indgnt - varchar(11)
grop_oth - varchar(10)
grop_tot - varchar(14)
bad_debt - varchar(12)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(12)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(13)
cadj_cnty - varchar(12)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(12)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(11)
sub_indgnt - varchar(11)
tch_allow - varchar(9)
tch_supp - varchar(11)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(10)
cap_cnty - varchar(10)
cap_thrd - varchar(10)
cap_tot - varchar(10)
net_mcar - varchar(11)
net_mcar_mc - varchar(12)
net_mcal - varchar(12)
net_mcal_mc - varchar(12)
net_cnty - varchar(12)
net_cnty_mc - varchar(11)
net_thrd - varchar(11)
net_thrd_mc - varchar(14)
net_indgnt - varchar(11)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(11)
tot_op_exp - varchar(14)
phy_comp - varchar(10)
nonop_rev - varchar(11)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(12)
fix_assets - varchar(14)
disp_trnfr - varchar(10)
dis_tot_cc - varchar(10)
pat_day_tot_cc - varchar(14)
tot_out_vis_cc - varchar(14)
gros_inpat_rev_cc - varchar(17)
gros_outpat_rev_cc - varchar(18)
contr_adj_cc - varchar(12)
othr_deduct_cc - varchar(14)
cap_prem_rev_cc - varchar(15)
net_pat_rev_cc - varchar(14)
qa_fees - varchar(10)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)
2018_quarter_1_complete_data_set_7_13_18     fac_no - varchar(9)
fac_name - varchar(61)
year_qtr - varchar(8)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(9)
county_name - varchar(15)
hsa - varchar(3)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(10)
phone - varchar(20)
address - varchar(32)
city - varchar(19)
zip_code - varchar(8)
ceo - varchar(28)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcar_mc - varchar(11)
dis_mcal - varchar(8)
dis_mcal_mc - varchar(11)
dis_cnty - varchar(8)
dis_cnty_mc - varchar(11)
dis_thrd - varchar(8)
dis_thrd_mc - varchar(11)
dis_indgnt - varchar(10)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcar_mc - varchar(11)
day_mcal - varchar(8)
day_mcal_mc - varchar(11)
day_cnty - varchar(8)
day_cnty_mc - varchar(11)
day_thrd - varchar(8)
day_thrd_mc - varchar(11)
day_indgnt - varchar(10)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcar_mc - varchar(11)
vis_mcal - varchar(8)
vis_mcal_mc - varchar(11)
vis_cnty - varchar(8)
vis_cnty_mc - varchar(11)
vis_thrd - varchar(8)
vis_thrd_mc - varchar(11)
vis_indgnt - varchar(10)
vis_oth - varchar(7)
vis_tot - varchar(7)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(11)
grip_mcal_mc - varchar(12)
grip_cnty - varchar(11)
grip_cnty_mc - varchar(12)
grip_thrd - varchar(11)
grip_thrd_mc - varchar(14)
grip_indgnt - varchar(11)
grip_oth - varchar(10)
grip_tot - varchar(14)
grop_mcar - varchar(11)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(12)
grop_cnty - varchar(11)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(11)
grop_thrd_mc - varchar(14)
grop_indgnt - varchar(11)
grop_oth - varchar(10)
grop_tot - varchar(14)
bad_debt - varchar(11)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(12)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(13)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(11)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(11)
sub_indgnt - varchar(10)
tch_allow - varchar(9)
tch_supp - varchar(11)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(10)
cap_cnty - varchar(10)
cap_thrd - varchar(10)
cap_tot - varchar(10)
net_mcar - varchar(11)
net_mcar_mc - varchar(14)
net_mcal - varchar(12)
net_mcal_mc - varchar(12)
net_cnty - varchar(11)
net_cnty_mc - varchar(11)
net_thrd - varchar(12)
net_thrd_mc - varchar(14)
net_indgnt - varchar(11)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(12)
tot_op_exp - varchar(14)
phy_comp - varchar(10)
nonop_rev - varchar(11)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(12)
fix_assets - varchar(14)
disp_trnfr - varchar(10)
dis_tot_cc - varchar(10)
pat_day_tot_cc - varchar(14)
tot_out_vis_cc - varchar(14)
gros_inpat_rev_cc - varchar(17)
gros_outpat_rev_cc - varchar(18)
contr_adj_cc - varchar(12)
othr_deduct_cc - varchar(14)
cap_prem_rev_cc - varchar(15)
net_pat_rev_cc - varchar(14)
qa_fees - varchar(12)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)
2018_quarter_2_complete_data_set_10_10_18     fac_no - varchar(9)
fac_name - varchar(60)
year_qtr - varchar(8)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(9)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(10)
phone - varchar(12)
address - varchar(36)
city - varchar(19)
zip_code - varchar(8)
ceo - varchar(26)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcar_mc - varchar(11)
dis_mcal - varchar(8)
dis_mcal_mc - varchar(11)
dis_cnty - varchar(8)
dis_cnty_mc - varchar(11)
dis_thrd - varchar(8)
dis_thrd_mc - varchar(11)
dis_indgnt - varchar(10)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcar_mc - varchar(11)
day_mcal - varchar(8)
day_mcal_mc - varchar(11)
day_cnty - varchar(8)
day_cnty_mc - varchar(11)
day_thrd - varchar(8)
day_thrd_mc - varchar(11)
day_indgnt - varchar(10)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcar_mc - varchar(11)
vis_mcal - varchar(8)
vis_mcal_mc - varchar(11)
vis_cnty - varchar(8)
vis_cnty_mc - varchar(11)
vis_thrd - varchar(8)
vis_thrd_mc - varchar(11)
vis_indgnt - varchar(10)
vis_oth - varchar(7)
vis_tot - varchar(7)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(11)
grip_mcal_mc - varchar(12)
grip_cnty - varchar(11)
grip_cnty_mc - varchar(12)
grip_thrd - varchar(11)
grip_thrd_mc - varchar(14)
grip_indgnt - varchar(11)
grip_oth - varchar(10)
grip_tot - varchar(14)
grop_mcar - varchar(11)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(12)
grop_cnty - varchar(11)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(11)
grop_thrd_mc - varchar(14)
grop_indgnt - varchar(11)
grop_oth - varchar(10)
grop_tot - varchar(14)
bad_debt - varchar(12)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(12)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(13)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(11)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(11)
sub_indgnt - varchar(12)
tch_allow - varchar(9)
tch_supp - varchar(11)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(10)
cap_cnty - varchar(10)
cap_thrd - varchar(10)
cap_tot - varchar(10)
net_mcar - varchar(11)
net_mcar_mc - varchar(11)
net_mcal - varchar(12)
net_mcal_mc - varchar(11)
net_cnty - varchar(11)
net_cnty_mc - varchar(11)
net_thrd - varchar(12)
net_thrd_mc - varchar(14)
net_indgnt - varchar(12)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(12)
tot_op_exp - varchar(14)
phy_comp - varchar(10)
nonop_rev - varchar(12)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(12)
fix_assets - varchar(14)
disp_trnfr - varchar(10)
dis_tot_cc - varchar(10)
pat_day_tot_cc - varchar(14)
tot_out_vis_cc - varchar(14)
gros_inpat_rev_cc - varchar(17)
gros_outpat_rev_cc - varchar(18)
contr_adj_cc - varchar(12)
othr_deduct_cc - varchar(14)
cap_prem_rev_cc - varchar(15)
net_pat_rev_cc - varchar(14)
qa_fees - varchar(11)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)
2018_quarter_3_complete_data_set_1_10_19     fac_no - varchar(9)
fac_name - varchar(61)
year_qtr - varchar(8)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(9)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(10)
phone - varchar(12)
address - varchar(37)
city - varchar(19)
zip_code - varchar(8)
ceo - varchar(26)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcar_mc - varchar(11)
dis_mcal - varchar(8)
dis_mcal_mc - varchar(11)
dis_cnty - varchar(8)
dis_cnty_mc - varchar(11)
dis_thrd - varchar(8)
dis_thrd_mc - varchar(11)
dis_indgnt - varchar(10)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcar_mc - varchar(11)
day_mcal - varchar(8)
day_mcal_mc - varchar(11)
day_cnty - varchar(8)
day_cnty_mc - varchar(11)
day_thrd - varchar(8)
day_thrd_mc - varchar(11)
day_indgnt - varchar(10)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcar_mc - varchar(11)
vis_mcal - varchar(8)
vis_mcal_mc - varchar(11)
vis_cnty - varchar(8)
vis_cnty_mc - varchar(11)
vis_thrd - varchar(8)
vis_thrd_mc - varchar(11)
vis_indgnt - varchar(10)
vis_oth - varchar(7)
vis_tot - varchar(7)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(11)
grip_mcal_mc - varchar(12)
grip_cnty - varchar(11)
grip_cnty_mc - varchar(12)
grip_thrd - varchar(11)
grip_thrd_mc - varchar(14)
grip_indgnt - varchar(11)
grip_oth - varchar(10)
grip_tot - varchar(14)
grop_mcar - varchar(11)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(12)
grop_cnty - varchar(11)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(11)
grop_thrd_mc - varchar(14)
grop_indgnt - varchar(11)
grop_oth - varchar(10)
grop_tot - varchar(14)
bad_debt - varchar(11)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(12)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(13)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(11)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(10)
sub_indgnt - varchar(10)
tch_allow - varchar(9)
tch_supp - varchar(11)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(11)
cap_cnty - varchar(10)
cap_thrd - varchar(10)
cap_tot - varchar(11)
net_mcar - varchar(11)
net_mcar_mc - varchar(11)
net_mcal - varchar(11)
net_mcal_mc - varchar(12)
net_cnty - varchar(11)
net_cnty_mc - varchar(11)
net_thrd - varchar(11)
net_thrd_mc - varchar(14)
net_indgnt - varchar(11)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(12)
tot_op_exp - varchar(14)
phy_comp - varchar(11)
nonop_rev - varchar(11)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(12)
fix_assets - varchar(14)
disp_trnfr - varchar(12)
dis_tot_cc - varchar(10)
pat_day_tot_cc - varchar(14)
tot_out_vis_cc - varchar(14)
gros_inpat_rev_cc - varchar(17)
gros_outpat_rev_cc - varchar(18)
contr_adj_cc - varchar(12)
othr_deduct_cc - varchar(14)
cap_prem_rev_cc - varchar(15)
net_pat_rev_cc - varchar(14)
qa_fees - varchar(11)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)
2018_quarter_4_complete_data_set_4_11_2019     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(8)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(9)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(10)
phone - varchar(12)
address - varchar(36)
city - varchar(19)
zip_code - varchar(8)
ceo - varchar(26)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcar_mc - varchar(11)
dis_mcal - varchar(8)
dis_mcal_mc - varchar(11)
dis_cnty - varchar(8)
dis_cnty_mc - varchar(11)
dis_thrd - varchar(8)
dis_thrd_mc - varchar(11)
dis_indgnt - varchar(10)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcar_mc - varchar(11)
day_mcal - varchar(8)
day_mcal_mc - varchar(11)
day_cnty - varchar(8)
day_cnty_mc - varchar(11)
day_thrd - varchar(8)
day_thrd_mc - varchar(11)
day_indgnt - varchar(10)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcar_mc - varchar(11)
vis_mcal - varchar(8)
vis_mcal_mc - varchar(11)
vis_cnty - varchar(8)
vis_cnty_mc - varchar(11)
vis_thrd - varchar(8)
vis_thrd_mc - varchar(11)
vis_indgnt - varchar(10)
vis_oth - varchar(7)
vis_tot - varchar(7)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(11)
grip_mcal_mc - varchar(12)
grip_cnty - varchar(11)
grip_cnty_mc - varchar(12)
grip_thrd - varchar(11)
grip_thrd_mc - varchar(14)
grip_indgnt - varchar(11)
grip_oth - varchar(10)
grip_tot - varchar(14)
grop_mcar - varchar(11)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(12)
grop_cnty - varchar(11)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(11)
grop_thrd_mc - varchar(14)
grop_indgnt - varchar(11)
grop_oth - varchar(10)
grop_tot - varchar(14)
bad_debt - varchar(11)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(12)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(13)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(11)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(10)
sub_indgnt - varchar(11)
tch_allow - varchar(9)
tch_supp - varchar(11)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(11)
cap_cnty - varchar(10)
cap_thrd - varchar(10)
cap_tot - varchar(11)
net_mcar - varchar(11)
net_mcar_mc - varchar(11)
net_mcal - varchar(12)
net_mcal_mc - varchar(12)
net_cnty - varchar(10)
net_cnty_mc - varchar(11)
net_thrd - varchar(12)
net_thrd_mc - varchar(14)
net_indgnt - varchar(11)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(12)
tot_op_exp - varchar(14)
phy_comp - varchar(11)
nonop_rev - varchar(13)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(12)
fix_assets - varchar(14)
disp_trnfr - varchar(12)
dis_tot_cc - varchar(10)
pat_day_tot_cc - varchar(14)
tot_out_vis_cc - varchar(14)
gros_inpat_rev_cc - varchar(17)
gros_outpat_rev_cc - varchar(18)
contr_adj_cc - varchar(12)
othr_deduct_cc - varchar(14)
cap_prem_rev_cc - varchar(15)
net_pat_rev_cc - varchar(14)
qa_fees - varchar(10)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)
2019_quarter_2_complete_data_set_10_10_19     fac_no - varchar(9)
fac_name - varchar(73)
year_qtr - varchar(8)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(9)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(10)
phone - varchar(12)
address - varchar(36)
city - varchar(19)
zip_code - varchar(8)
ceo - varchar(26)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcar_mc - varchar(11)
dis_mcal - varchar(8)
dis_mcal_mc - varchar(11)
dis_cnty - varchar(8)
dis_cnty_mc - varchar(11)
dis_thrd - varchar(8)
dis_thrd_mc - varchar(11)
dis_indgnt - varchar(10)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcar_mc - varchar(11)
day_mcal - varchar(8)
day_mcal_mc - varchar(11)
day_cnty - varchar(8)
day_cnty_mc - varchar(11)
day_thrd - varchar(8)
day_thrd_mc - varchar(11)
day_indgnt - varchar(10)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcar_mc - varchar(11)
vis_mcal - varchar(8)
vis_mcal_mc - varchar(11)
vis_cnty - varchar(8)
vis_cnty_mc - varchar(11)
vis_thrd - varchar(8)
vis_thrd_mc - varchar(11)
vis_indgnt - varchar(10)
vis_oth - varchar(7)
vis_tot - varchar(7)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(11)
grip_mcal_mc - varchar(12)
grip_cnty - varchar(11)
grip_cnty_mc - varchar(12)
grip_thrd - varchar(11)
grip_thrd_mc - varchar(14)
grip_indgnt - varchar(11)
grip_oth - varchar(10)
grip_tot - varchar(14)
grop_mcar - varchar(11)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(12)
grop_cnty - varchar(11)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(11)
grop_thrd_mc - varchar(14)
grop_indgnt - varchar(11)
grop_oth - varchar(10)
grop_tot - varchar(14)
bad_debt - varchar(11)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(12)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(12)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(11)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(10)
sub_indgnt - varchar(11)
tch_allow - varchar(9)
tch_supp - varchar(11)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(11)
cap_cnty - varchar(11)
cap_thrd - varchar(10)
cap_tot - varchar(11)
net_mcar - varchar(11)
net_mcar_mc - varchar(11)
net_mcal - varchar(12)
net_mcal_mc - varchar(11)
net_cnty - varchar(10)
net_cnty_mc - varchar(11)
net_thrd - varchar(12)
net_thrd_mc - varchar(14)
net_indgnt - varchar(11)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(12)
tot_op_exp - varchar(14)
phy_comp - varchar(11)
nonop_rev - varchar(12)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(12)
cap_exp - varchar(12)
fix_assets - varchar(14)
disp_trnfr - varchar(10)
dis_tot_cc - varchar(10)
pat_day_tot_cc - varchar(14)
tot_out_vis_cc - varchar(14)
gros_inpat_rev_cc - varchar(17)
gros_outpat_rev_cc - varchar(18)
contr_adj_cc - varchar(12)
othr_deduct_cc - varchar(14)
cap_prem_rev_cc - varchar(15)
net_pat_rev_cc - varchar(14)
qa_fees - varchar(10)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)
2019_quarter_3_complete_data_set_1_10_20     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(8)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(9)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(10)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(38)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcar_mc - varchar(11)
dis_mcal - varchar(8)
dis_mcal_mc - varchar(11)
dis_cnty - varchar(8)
dis_cnty_mc - varchar(11)
dis_thrd - varchar(8)
dis_thrd_mc - varchar(11)
dis_indgnt - varchar(10)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcar_mc - varchar(11)
day_mcal - varchar(8)
day_mcal_mc - varchar(11)
day_cnty - varchar(8)
day_cnty_mc - varchar(11)
day_thrd - varchar(8)
day_thrd_mc - varchar(11)
day_indgnt - varchar(10)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcar_mc - varchar(11)
vis_mcal - varchar(8)
vis_mcal_mc - varchar(11)
vis_cnty - varchar(8)
vis_cnty_mc - varchar(11)
vis_thrd - varchar(8)
vis_thrd_mc - varchar(11)
vis_indgnt - varchar(10)
vis_oth - varchar(7)
vis_tot - varchar(7)
grip_mcar - varchar(10)
grip_mcar_mc - varchar(12)
grip_mcal - varchar(9)
grip_mcal_mc - varchar(12)
grip_cnty - varchar(9)
grip_cnty_mc - varchar(12)
grip_thrd - varchar(9)
grip_thrd_mc - varchar(12)
grip_indgnt - varchar(11)
grip_oth - varchar(8)
grip_tot - varchar(10)
grop_mcar - varchar(10)
grop_mcar_mc - varchar(12)
grop_mcal - varchar(9)
grop_mcal_mc - varchar(12)
grop_cnty - varchar(9)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(9)
grop_thrd_mc - varchar(12)
grop_indgnt - varchar(11)
grop_oth - varchar(8)
grop_tot - varchar(10)
bad_debt - varchar(8)
cadj_mcar - varchar(10)
cadj_mcar_mc - varchar(12)
cadj_mcal - varchar(9)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(9)
cadj_cnty - varchar(9)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(9)
cadj_thrd_mc - varchar(12)
char_hb - varchar(7)
char_oth - varchar(8)
sub_indgnt - varchar(10)
tch_allow - varchar(9)
tch_supp - varchar(8)
ded_oth - varchar(9)
ded_tot - varchar(10)
cap_mcar - varchar(9)
cap_mcal - varchar(8)
cap_cnty - varchar(8)
cap_thrd - varchar(8)
cap_tot - varchar(9)
net_mcar - varchar(9)
net_mcar_mc - varchar(11)
net_mcal - varchar(9)
net_mcal_mc - varchar(11)
net_cnty - varchar(8)
net_cnty_mc - varchar(11)
net_thrd - varchar(8)
net_thrd_mc - varchar(11)
net_indgnt - varchar(10)
net_oth - varchar(9)
net_tot - varchar(10)
oth_op_rev - varchar(10)
tot_op_exp - varchar(10)
phy_comp - varchar(8)
nonop_rev - varchar(9)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(8)
exp_pops - varchar(8)
cap_exp - varchar(9)
fix_assets - varchar(10)
disp_trnfr - varchar(10)
dis_tot_cc - varchar(10)
pat_day_tot_cc - varchar(14)
tot_out_vis_cc - varchar(14)
gros_inpat_rev_cc - varchar(17)
gros_outpat_rev_cc - varchar(18)
contr_adj_cc - varchar(12)
othr_deduct_cc - varchar(14)
cap_prem_rev_cc - varchar(15)
net_pat_rev_cc - varchar(14)
qa_fees - varchar(7)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)
2019_quarter_4_complete_data_set_4_10_20     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(8)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(9)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(10)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(38)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcar_mc - varchar(11)
dis_mcal - varchar(8)
dis_mcal_mc - varchar(11)
dis_cnty - varchar(8)
dis_cnty_mc - varchar(11)
dis_thrd - varchar(8)
dis_thrd_mc - varchar(11)
dis_indgnt - varchar(10)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcar_mc - varchar(11)
day_mcal - varchar(8)
day_mcal_mc - varchar(11)
day_cnty - varchar(8)
day_cnty_mc - varchar(11)
day_thrd - varchar(8)
day_thrd_mc - varchar(11)
day_indgnt - varchar(10)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcar_mc - varchar(11)
vis_mcal - varchar(8)
vis_mcal_mc - varchar(11)
vis_cnty - varchar(8)
vis_cnty_mc - varchar(11)
vis_thrd - varchar(8)
vis_thrd_mc - varchar(11)
vis_indgnt - varchar(10)
vis_oth - varchar(7)
vis_tot - varchar(7)
grip_mcar - varchar(10)
grip_mcar_mc - varchar(12)
grip_mcal - varchar(9)
grip_mcal_mc - varchar(12)
grip_cnty - varchar(9)
grip_cnty_mc - varchar(12)
grip_thrd - varchar(9)
grip_thrd_mc - varchar(12)
grip_indgnt - varchar(11)
grip_oth - varchar(8)
grip_tot - varchar(10)
grop_mcar - varchar(10)
grop_mcar_mc - varchar(12)
grop_mcal - varchar(9)
grop_mcal_mc - varchar(12)
grop_cnty - varchar(9)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(9)
grop_thrd_mc - varchar(12)
grop_indgnt - varchar(11)
grop_oth - varchar(8)
grop_tot - varchar(10)
bad_debt - varchar(8)
cadj_mcar - varchar(10)
cadj_mcar_mc - varchar(12)
cadj_mcal - varchar(9)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(9)
cadj_cnty - varchar(9)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(9)
cadj_thrd_mc - varchar(12)
char_hb - varchar(7)
char_oth - varchar(8)
sub_indgnt - varchar(10)
tch_allow - varchar(9)
tch_supp - varchar(8)
ded_oth - varchar(9)
ded_tot - varchar(10)
cap_mcar - varchar(9)
cap_mcal - varchar(8)
cap_cnty - varchar(8)
cap_thrd - varchar(8)
cap_tot - varchar(9)
net_mcar - varchar(9)
net_mcar_mc - varchar(11)
net_mcal - varchar(9)
net_mcal_mc - varchar(11)
net_cnty - varchar(8)
net_cnty_mc - varchar(11)
net_thrd - varchar(8)
net_thrd_mc - varchar(11)
net_indgnt - varchar(10)
net_oth - varchar(9)
net_tot - varchar(10)
oth_op_rev - varchar(10)
tot_op_exp - varchar(10)
phy_comp - varchar(8)
nonop_rev - varchar(9)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(8)
exp_pops - varchar(8)
cap_exp - varchar(9)
fix_assets - varchar(10)
disp_trnfr - varchar(10)
dis_tot_cc - varchar(10)
pat_day_tot_cc - varchar(14)
tot_out_vis_cc - varchar(14)
gros_inpat_rev_cc - varchar(17)
gros_outpat_rev_cc - varchar(18)
contr_adj_cc - varchar(12)
othr_deduct_cc - varchar(14)
cap_prem_rev_cc - varchar(15)
net_pat_rev_cc - varchar(14)
qa_fees - varchar(7)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)
2020_quarter_1_complete_data_set_9_4_20     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(12)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(3)
day_thrd - varchar(4)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(5)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2020_quarter_2_complete_data_set_10_19_2020     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(4)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(3)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(4)
dis_ltc - varchar(3)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(3)
day_thrd - varchar(4)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(5)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2020_quarter_3_complete_data_set_01_15_2021     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(4)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(4)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(5)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2020_quarter_4_complete_data_set_04_15_2021     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(19)
end_date - varchar(10)
op_status - varchar(6)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(2)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(4)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(5)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2021_quarter_1_complete_data_set_07_14_2021     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(4)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(2)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(5)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(4)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(5)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2021_quarter_2_complete_data_set_10_13_2021     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(4)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(2)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(5)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(6)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2021_quarter_3_complete_data_set_01_13_2022     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(6)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(5)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(4)
day_thrd - varchar(6)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2021_quarter_4_complete_data_set_04_15_2022     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(4)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(2)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(5)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(5)
day_thrd_mc - varchar(5)
day_indgnt - varchar(5)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2022_quarter_1_complete_data_set_07_14_2022     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(4)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(2)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(5)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(5)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2022_quarter_2_complete_data_set_10_13_2022     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(6)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(2)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(5)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(5)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2022_quarter_3_complete_data_set_01_13_2023     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(4)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(2)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(4)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2022_quarter_4_complete_data_set_04_14_2023     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(4)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(2)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(5)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(6)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2023_quarter_1_complete_data_set_07_14_2023     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(4)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(5)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(5)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2023_quarter_2_complete_data_set_10_16_2023     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(4)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(2)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(4)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2023_quarter_3_complete_data_set_01_16_2024     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(19)
end_date - varchar(10)
op_status - varchar(6)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(32)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(2)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(4)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2023_quarter_4_complete_data_set_04_16_2024     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(4)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(32)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(2)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(4)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2024_quarter_1_complete_data_set_07_30_2024     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(4)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(32)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(2)
dis_thrd - varchar(3)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(4)
day_thrd_mc - varchar(5)
day_indgnt - varchar(3)
day_oth - varchar(5)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(4)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
2024_quarter_2_complete_data_set_10_30_2024     fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - varchar(10)
end_date - varchar(10)
op_status - varchar(4)
county_name - varchar(15)
hsa - varchar(26)
hfpa - varchar(4)
type_cntrl - varchar(17)
type_hosp - varchar(29)
teach_rurl - varchar(8)
phone - varchar(20)
address - varchar(32)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(30)
lic_beds - varchar(4)
avl_beds - varchar(4)
stf_beds - varchar(4)
dis_mcar - varchar(4)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(3)
dis_cnty_mc - varchar(2)
dis_thrd - varchar(3)
dis_thrd_mc - varchar(4)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(3)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(5)
day_cnty - varchar(4)
day_cnty_mc - varchar(3)
day_thrd - varchar(4)
day_thrd_mc - varchar(5)
day_indgnt - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal - varchar(5)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(4)
vis_thrd - varchar(5)
vis_thrd_mc - varchar(6)
Sources
2011-2015-summary-trends.xlsx - None
2019-quarter-1-complete-data-set-7-11-19.csv - None
2019-quarter-1-complete-data-set-7-11-19.xls - None
data-importing-instructions-for-excel.docx - None
documentation-for-hospital-quarterly-financial-and-utilization-data-files.pdf - None
2024-quarter-4-complete-data-set-04-29-2025.xlsx - None
2024-quarter-3-complete-data-set-01-29-2025.xlsx - None
documentation-for-hospital-quarterly-financial-and-utilization-data-files-2015-through-2023.pdf - None
datapackage.json - None
2016-quarter-4-complete-data-set-4-14-17.csv - 2016_quarter_4_complete_data_set_4_14_17
2017-quarter-1-complete-data-set-7-14-17.csv - 2017_quarter_1_complete_data_set_7_14_17
2017-quarter-2-complete-data-set-11-02-17.csv - 2017_quarter_2_complete_data_set_11_02_17
2017-quarter-3-complete-data-set-1-12-18.csv - 2017_quarter_3_complete_data_set_1_12_18
2017-quarter-4-complete-data-set-4-13-18.csv - 2017_quarter_4_complete_data_set_4_13_18
2018-quarter-1-complete-data-set-7-13-18.csv - 2018_quarter_1_complete_data_set_7_13_18
2018-quarter-2-complete-data-set-10-10-18.csv - 2018_quarter_2_complete_data_set_10_10_18
2018-quarter-3-complete-data-set-1-10-19.csv - 2018_quarter_3_complete_data_set_1_10_19
2018-quarter-4-complete-data-set-4-11-2019.csv - 2018_quarter_4_complete_data_set_4_11_2019
2019-quarter-2-complete-data-set-10-10-19.csv - 2019_quarter_2_complete_data_set_10_10_19
2019-quarter-3-complete-data-set-1-10-20.csv - 2019_quarter_3_complete_data_set_1_10_20
2019-quarter-4-complete-data-set-4-10-20.csv - 2019_quarter_4_complete_data_set_4_10_20
2020-quarter-1-complete-data-set-9-4-20.xlsx - 2020_quarter_1_complete_data_set_9_4_20
2020-quarter-2-complete-data-set-10-19-2020.xlsx - 2020_quarter_2_complete_data_set_10_19_2020
2020-quarter-3-complete-data-set-01-15-2021.xlsx - 2020_quarter_3_complete_data_set_01_15_2021
2020-quarter-4-complete-data-set-04-15-2021.xlsx - 2020_quarter_4_complete_data_set_04_15_2021
2021-quarter-1-complete-data-set-07-14-2021.xlsx - 2021_quarter_1_complete_data_set_07_14_2021
2021-quarter-2-complete-data-set-10-13-2021.xlsx - 2021_quarter_2_complete_data_set_10_13_2021
2021-quarter-3-complete-data-set-01-13-2022.xlsx - 2021_quarter_3_complete_data_set_01_13_2022
2021-quarter-4-complete-data-set-04-15-2022.xlsx - 2021_quarter_4_complete_data_set_04_15_2022
2022-quarter-1-complete-data-set-07-14-2022.xlsx - 2022_quarter_1_complete_data_set_07_14_2022
2022-quarter-2-complete-data-set-10-13-2022.xlsx - 2022_quarter_2_complete_data_set_10_13_2022
2022-quarter-3-complete-data-set-01-13-2023.xlsx - 2022_quarter_3_complete_data_set_01_13_2023
2022-quarter-4-complete-data-set-04-14-2023.xlsx - 2022_quarter_4_complete_data_set_04_14_2023
2023-quarter-1-complete-data-set-07-14-2023.xlsx - 2023_quarter_1_complete_data_set_07_14_2023
2023-quarter-2-complete-data-set-10-16-2023.xlsx - 2023_quarter_2_complete_data_set_10_16_2023
2023-quarter-3-complete-data-set-01-16-2024.xlsx - 2023_quarter_3_complete_data_set_01_16_2024
2023-quarter-4-complete-data-set-04-16-2024.xlsx - 2023_quarter_4_complete_data_set_04_16_2024
2024-quarter-1-complete-data-set-07-30-2024.xlsx - 2024_quarter_1_complete_data_set_07_30_2024
2024-quarter-2-complete-data-set-10-30-2024.xlsx - 2024_quarter_2_complete_data_set_10_30_2024
Updates
2025-07-11 17:46:48      None
2025-06-06 12:06:27      0
2025-03-10 09:56:15      0
2025-03-10 09:56:09      0
2025-02-03 22:30:35      0
2025-02-03 22:30:21      0
2025-02-03 22:22:17      0
2025-02-03 22:22:07      0
2025-02-03 18:51:35      0
2025-02-03 18:51:26      0
2025-02-03 18:50:51      0
2025-02-03 18:38:57      0
2025-02-02 18:08:28      0
2025-01-31 09:56:34      0
2025-01-16 23:53:13      0
2025-01-16 23:52:45      0
2025-01-16 19:16:14      0
2025-01-16 19:15:31      0
2024-12-20 10:17:33      0
2024-12-20 09:23:13      1
2024-12-14 15:47:11      1
2024-12-04 16:28:18      None
2024-09-18 13:06:51      None