Home

Dataset:

Name hospital-quarterly-financial-utilization-report-complete-data-set
Updated 2025-07-30
CA Dataset link
Current True
Tables
2011_2015_summary_trends    
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_1_complete_data_set_7_11_19    
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)
2024_quarter_3_complete_data_set_01_29_2025    
2024_quarter_4_complete_data_set_04_29_2025    
2025_quarter_1_complete_data_set_07_30_2025    
Sources
2019-quarter-1-complete-data-set-7-11-19.xls  -   
data-importing-instructions-for-excel.docx  -   
documentation-for-hospital-quarterly-financial-and-utilization-data-files.pdf  -   
documentation-for-hospital-quarterly-financial-and-utilization-data-files-2015-through-2023.pdf  -   
datapackage.json  -   
2011-2015-summary-trends.xlsx  -  Table: 2011_2015_summary_trends   Updated: 2025-10-11
2016-quarter-4-complete-data-set-4-14-17.csv  -  Table: 2016_quarter_4_complete_data_set_4_14_17   Updated: 2025-10-11
2017-quarter-1-complete-data-set-7-14-17.csv  -  Table: 2017_quarter_1_complete_data_set_7_14_17   Updated: 2025-10-11
2017-quarter-2-complete-data-set-11-02-17.csv  -  Table: 2017_quarter_2_complete_data_set_11_02_17   Updated: 2025-10-11
2017-quarter-3-complete-data-set-1-12-18.csv  -  Table: 2017_quarter_3_complete_data_set_1_12_18   Updated: 2025-10-11
2017-quarter-4-complete-data-set-4-13-18.csv  -  Table: 2017_quarter_4_complete_data_set_4_13_18   Updated: 2025-10-11
2018-quarter-1-complete-data-set-7-13-18.csv  -  Table: 2018_quarter_1_complete_data_set_7_13_18   Updated: 2025-10-11
2018-quarter-2-complete-data-set-10-10-18.csv  -  Table: 2018_quarter_2_complete_data_set_10_10_18   Updated: 2025-10-11
2018-quarter-3-complete-data-set-1-10-19.csv  -  Table: 2018_quarter_3_complete_data_set_1_10_19   Updated: 2025-10-11
2018-quarter-4-complete-data-set-4-11-2019.csv  -  Table: 2018_quarter_4_complete_data_set_4_11_2019   Updated: 2025-10-11
2019-quarter-1-complete-data-set-7-11-19.csv  -  Table: 2019_quarter_1_complete_data_set_7_11_19   Fails: 2
2019-quarter-2-complete-data-set-10-10-19.csv  -  Table: 2019_quarter_2_complete_data_set_10_10_19   Updated: 2025-10-11
2019-quarter-3-complete-data-set-1-10-20.csv  -  Table: 2019_quarter_3_complete_data_set_1_10_20   Updated: 2025-10-11
2019-quarter-4-complete-data-set-4-10-20.csv  -  Table: 2019_quarter_4_complete_data_set_4_10_20   Updated: 2025-10-11
2020-quarter-1-complete-data-set-9-4-20.xlsx  -  Table: 2020_quarter_1_complete_data_set_9_4_20   Updated: 2025-10-13
2020-quarter-2-complete-data-set-10-19-2020.xlsx  -  Table: 2020_quarter_2_complete_data_set_10_19_2020   Updated: 2025-10-13
2020-quarter-3-complete-data-set-01-15-2021.xlsx  -  Table: 2020_quarter_3_complete_data_set_01_15_2021   Updated: 2025-10-13
2020-quarter-4-complete-data-set-04-15-2021.xlsx  -  Table: 2020_quarter_4_complete_data_set_04_15_2021   Updated: 2025-10-13
2021-quarter-1-complete-data-set-07-14-2021.xlsx  -  Table: 2021_quarter_1_complete_data_set_07_14_2021   Updated: 2025-10-13
2021-quarter-2-complete-data-set-10-13-2021.xlsx  -  Table: 2021_quarter_2_complete_data_set_10_13_2021   Updated: 2025-10-13
2021-quarter-3-complete-data-set-01-13-2022.xlsx  -  Table: 2021_quarter_3_complete_data_set_01_13_2022   Updated: 2025-10-13
2021-quarter-4-complete-data-set-04-15-2022.xlsx  -  Table: 2021_quarter_4_complete_data_set_04_15_2022   Updated: 2025-10-13
2022-quarter-1-complete-data-set-07-14-2022.xlsx  -  Table: 2022_quarter_1_complete_data_set_07_14_2022   Updated: 2025-10-13
2022-quarter-2-complete-data-set-10-13-2022.xlsx  -  Table: 2022_quarter_2_complete_data_set_10_13_2022   Updated: 2025-10-13
2022-quarter-3-complete-data-set-01-13-2023.xlsx  -  Table: 2022_quarter_3_complete_data_set_01_13_2023   Updated: 2025-10-13
2022-quarter-4-complete-data-set-04-14-2023.xlsx  -  Table: 2022_quarter_4_complete_data_set_04_14_2023   Updated: 2025-10-13
2023-quarter-1-complete-data-set-07-14-2023.xlsx  -  Table: 2023_quarter_1_complete_data_set_07_14_2023   Updated: 2025-10-13
2023-quarter-2-complete-data-set-10-16-2023.xlsx  -  Table: 2023_quarter_2_complete_data_set_10_16_2023   Updated: 2025-10-13
2023-quarter-3-complete-data-set-01-16-2024.xlsx  -  Table: 2023_quarter_3_complete_data_set_01_16_2024   Updated: 2025-10-13
2023-quarter-4-complete-data-set-04-16-2024.xlsx  -  Table: 2023_quarter_4_complete_data_set_04_16_2024   Updated: 2025-10-13
2024-quarter-1-complete-data-set-07-30-2024.xlsx  -  Table: 2024_quarter_1_complete_data_set_07_30_2024   Updated: 2025-10-13
2024-quarter-2-complete-data-set-10-30-2024.xlsx  -  Table: 2024_quarter_2_complete_data_set_10_30_2024   Updated: 2025-10-13
2024-quarter-3-complete-data-set-01-29-2025.xlsx  -  Table: 2024_quarter_3_complete_data_set_01_29_2025   Updated: 2025-10-11
2024-quarter-4-complete-data-set-04-29-2025.xlsx  -  Table: 2024_quarter_4_complete_data_set_04_29_2025   Updated: 2025-10-11
2025-quarter-1-complete-data-set-07-30-2025.csv  -  Table: 2025_quarter_1_complete_data_set_07_30_2025   Fails: 2
Updated