HCAI

Home

Dataset:

Name

hospital-quarterly-financial-utilization-report-sum-of-four-quarters

Updated

2025-07-30

CA Dataset

link

Current

False

Tables

2013_quarter_1_sum_of_four_quarters_rev_7_15

fac_no - varchar(9)
fac_name - varchar(53)
year_qtr - varchar(8)
beg_date - varchar(8)
end_date - varchar(9)
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(13)
address - varchar(36)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(25)
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(14)
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(14)
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(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(12)
cadj_mcal - varchar(14)
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(10)
char_oth - varchar(12)
sub_indgnt - varchar(12)
tch_allow - varchar(9)
tch_supp - varchar(12)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(10)
cap_mcal - varchar(10)
cap_cnty - varchar(10)
cap_thrd - varchar(11)
cap_tot - varchar(12)
net_mcar - varchar(11)
net_mcar_mc - varchar(12)
net_mcal - varchar(13)
net_mcal_mc - varchar(11)
net_cnty - varchar(12)
net_cnty_mc - varchar(12)
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(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(13)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(11)
exp_pops - varchar(10)
cap_exp - varchar(12)
ending_fix_assets - varchar(17)
disp_trnfr - varchar(12)

2013_quarter_2_sum_of_four_quarters_rev_7_15

fac_no - varchar(9)
fac_name - varchar(53)
year_qtr - varchar(8)
beg_date - varchar(8)
end_date - varchar(9)
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(13)
address - varchar(36)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(22)
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(14)
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(14)
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(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(12)
cadj_mcal - varchar(14)
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(10)
char_oth - varchar(12)
sub_indgnt - varchar(12)
tch_allow - varchar(9)
tch_supp - varchar(12)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(10)
cap_mcal - varchar(10)
cap_cnty - varchar(10)
cap_thrd - varchar(11)
cap_tot - varchar(12)
net_mcar - varchar(11)
net_mcar_mc - varchar(12)
net_mcal - varchar(13)
net_mcal_mc - varchar(12)
net_cnty - varchar(12)
net_cnty_mc - varchar(12)
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(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(14)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(11)
exp_pops - varchar(10)
cap_exp - varchar(12)
ending_fix_assets - varchar(17)
disp_trnfr - varchar(12)

2013_quarter_3_sum_of_four_quarters_rev_7_15

fac_no - varchar(9)
fac_name - varchar(53)
year_qtr - varchar(8)
beg_date - varchar(8)
end_date - varchar(9)
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(36)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(22)
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(14)
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(14)
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(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(12)
cadj_mcal - varchar(14)
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(10)
char_oth - varchar(12)
sub_indgnt - varchar(12)
tch_allow - varchar(9)
tch_supp - varchar(12)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(10)
cap_mcal - varchar(10)
cap_cnty - varchar(10)
cap_thrd - varchar(11)
cap_tot - varchar(12)
net_mcar - varchar(11)
net_mcar_mc - varchar(12)
net_mcal - varchar(13)
net_mcal_mc - varchar(12)
net_cnty - varchar(12)
net_cnty_mc - varchar(12)
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(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(14)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(11)
exp_pops - varchar(10)
cap_exp - varchar(12)
ending_fix_assets - varchar(17)
disp_trnfr - varchar(12)

2013_quarter_4_sum_of_four_quarters_rev_7_15

fac_no - varchar(9)
fac_name - varchar(58)
year_qtr - varchar(8)
beg_date - varchar(8)
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(10)
ceo - varchar(25)
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(14)
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(14)
grop_mcar_mc - varchar(12)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(12)
grop_cnty - varchar(12)
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(12)
cadj_mcal - varchar(14)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(13)
cadj_cnty - varchar(12)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(11)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(12)
sub_indgnt - varchar(12)
tch_allow - varchar(9)
tch_supp - varchar(12)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(10)
cap_mcal - varchar(10)
cap_cnty - varchar(10)
cap_thrd - varchar(11)
cap_tot - varchar(12)
net_mcar - varchar(11)
net_mcar_mc - varchar(12)
net_mcal - varchar(14)
net_mcal_mc - varchar(12)
net_cnty - varchar(12)
net_cnty_mc - varchar(12)
net_thrd - varchar(13)
net_thrd_mc - varchar(14)
net_indgnt - varchar(12)
net_oth - varchar(13)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(14)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(11)
exp_pops - varchar(10)
cap_exp - varchar(12)
ending_fix_assets - varchar(17)
disp_trnfr - varchar(12)

2014_quarter_1_sum_of_four_quarters_rev_7_15

fac_no - varchar(9)
fac_name - varchar(52)
year_qtr - varchar(8)
beg_date - varchar(8)
end_date - varchar(9)
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(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(25)
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(14)
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(14)
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(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(12)
cadj_mcal - varchar(14)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(13)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(14)
cadj_thrd_mc - varchar(14)
char_hb - varchar(10)
char_oth - varchar(12)
sub_indgnt - varchar(12)
tch_allow - varchar(9)
tch_supp - varchar(12)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(10)
cap_mcal - varchar(10)
cap_cnty - varchar(10)
cap_thrd - varchar(11)
cap_tot - varchar(12)
net_mcar - varchar(11)
net_mcar_mc - varchar(12)
net_mcal - varchar(14)
net_mcal_mc - varchar(12)
net_cnty - varchar(12)
net_cnty_mc - varchar(12)
net_thrd - varchar(13)
net_thrd_mc - varchar(14)
net_indgnt - varchar(12)
net_oth - varchar(13)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(14)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(12)
ending_fix_assets - varchar(17)
disp_trnfr - varchar(12)

2014_quarter_2_sum_of_four_quarters_rev_7_15

fac_no - varchar(9)
fac_name - varchar(52)
year_qtr - varchar(8)
beg_date - varchar(8)
end_date - varchar(9)
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(32)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(25)
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(14)
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(14)
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(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(12)
cadj_mcal - varchar(14)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(13)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(14)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(11)
sub_indgnt - varchar(12)
tch_allow - varchar(9)
tch_supp - varchar(12)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(12)
cap_cnty - varchar(10)
cap_thrd - varchar(12)
cap_tot - varchar(11)
net_mcar - varchar(11)
net_mcar_mc - varchar(12)
net_mcal - varchar(14)
net_mcal_mc - varchar(12)
net_cnty - varchar(12)
net_cnty_mc - varchar(12)
net_thrd - varchar(13)
net_thrd_mc - varchar(14)
net_indgnt - varchar(12)
net_oth - varchar(13)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(14)
dis_pips - varchar(10)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(11)
ending_fix_assets - varchar(17)
disp_trnfr - varchar(12)

2014_quarter_3_sum_of_four_quarters_rev_7_15

fac_no - varchar(9)
fac_name - varchar(54)
year_qtr - varchar(8)
beg_date - varchar(9)
end_date - varchar(9)
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(10)
ceo - varchar(25)
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(14)
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(14)
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(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(12)
cadj_mcal - varchar(14)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(13)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(14)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(11)
sub_indgnt - varchar(12)
tch_allow - varchar(9)
tch_supp - varchar(12)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(12)
cap_cnty - varchar(10)
cap_thrd - varchar(12)
cap_tot - varchar(11)
net_mcar - varchar(12)
net_mcar_mc - varchar(12)
net_mcal - varchar(14)
net_mcal_mc - varchar(12)
net_cnty - varchar(12)
net_cnty_mc - varchar(11)
net_thrd - varchar(13)
net_thrd_mc - varchar(14)
net_indgnt - varchar(12)
net_oth - varchar(13)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(14)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(11)
ending_fix_assets - varchar(17)
disp_trnfr - varchar(12)

2014_quarter_4_sum_of_four_quarters_rev_7_15

fac_no - varchar(9)
fac_name - varchar(58)
year_qtr - varchar(8)
beg_date - varchar(8)
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(10)
ceo - varchar(24)
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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(12)
grip_mcal - varchar(14)
grip_mcal_mc - varchar(12)
grip_cnty - varchar(12)
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(14)
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(14)
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(14)
cadj_mcal_mc - varchar(14)
disp_855 - varchar(13)
cadj_cnty - varchar(12)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(14)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(11)
sub_indgnt - varchar(12)
tch_allow - varchar(9)
tch_supp - varchar(12)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(12)
cap_cnty - varchar(10)
cap_thrd - varchar(12)
cap_tot - varchar(11)
net_mcar - varchar(12)
net_mcar_mc - varchar(12)
net_mcal - varchar(14)
net_mcal_mc - varchar(11)
net_cnty - varchar(12)
net_cnty_mc - varchar(11)
net_thrd - varchar(13)
net_thrd_mc - varchar(14)
net_indgnt - varchar(12)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(14)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(11)
ending_fix_assets - varchar(17)
disp_trnfr - varchar(12)

2015_quarter_1_sum_of_four_quarters_rev_4_16

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(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(10)
ceo - varchar(24)
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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(12)
grip_mcal - varchar(14)
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(14)
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(14)
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(14)
cadj_mcal_mc - varchar(14)
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(10)
char_oth - varchar(11)
sub_indgnt - varchar(12)
tch_allow - varchar(9)
tch_supp - varchar(12)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(12)
cap_cnty - varchar(10)
cap_thrd - varchar(12)
cap_tot - varchar(11)
net_mcar - varchar(12)
net_mcar_mc - varchar(12)
net_mcal - varchar(14)
net_mcal_mc - varchar(13)
net_cnty - varchar(12)
net_cnty_mc - varchar(11)
net_thrd - varchar(13)
net_thrd_mc - varchar(14)
net_indgnt - varchar(12)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(14)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(11)
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)

2015_quarter_2_sum_of_four_quarters_rev_4_16

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(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(10)
ceo - varchar(24)
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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(12)
grip_mcal - varchar(14)
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(12)
grip_tot - varchar(14)
grop_mcar - varchar(14)
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(14)
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(14)
cadj_mcal_mc - varchar(14)
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(10)
char_oth - varchar(11)
sub_indgnt - varchar(11)
tch_allow - varchar(11)
tch_supp - varchar(12)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(11)
cap_cnty - varchar(10)
cap_thrd - varchar(12)
cap_tot - varchar(11)
net_mcar - varchar(12)
net_mcar_mc - varchar(12)
net_mcal - varchar(12)
net_mcal_mc - varchar(14)
net_cnty - varchar(12)
net_cnty_mc - varchar(11)
net_thrd - varchar(13)
net_thrd_mc - varchar(14)
net_indgnt - varchar(12)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(14)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(11)
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)

2015_quarter_3_sum_of_four_quarters_rev_4_16

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(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(10)
ceo - varchar(24)
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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(12)
grip_mcal - varchar(14)
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(14)
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(14)
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(14)
cadj_mcal_mc - varchar(14)
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(10)
char_oth - varchar(11)
sub_indgnt - varchar(12)
tch_allow - varchar(11)
tch_supp - varchar(12)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(11)
cap_cnty - varchar(10)
cap_thrd - varchar(12)
cap_tot - varchar(11)
net_mcar - varchar(11)
net_mcar_mc - varchar(12)
net_mcal - varchar(12)
net_mcal_mc - varchar(14)
net_cnty - varchar(12)
net_cnty_mc - varchar(11)
net_thrd - varchar(13)
net_thrd_mc - varchar(14)
net_indgnt - varchar(11)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(14)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(11)
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)

2015_quarter_4_sum_of_four_quarters_rev_4_16

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(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(10)
ceo - varchar(24)
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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(12)
grip_mcal - varchar(14)
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(12)
grip_tot - varchar(14)
grop_mcar - varchar(14)
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(14)
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(14)
cadj_mcal_mc - varchar(14)
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(10)
char_oth - varchar(11)
sub_indgnt - varchar(12)
tch_allow - varchar(11)
tch_supp - varchar(12)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(11)
cap_cnty - varchar(10)
cap_thrd - varchar(11)
cap_tot - varchar(12)
net_mcar - varchar(11)
net_mcar_mc - varchar(12)
net_mcal - varchar(13)
net_mcal_mc - varchar(14)
net_cnty - varchar(12)
net_cnty_mc - varchar(11)
net_thrd - varchar(13)
net_thrd_mc - varchar(14)
net_indgnt - varchar(11)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(14)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(11)
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)

2016_quarter_1_sum_of_four_quarters

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(10)
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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(12)
grip_mcal - varchar(14)
grip_mcal_mc - varchar(14)
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(14)
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(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(12)
cadj_mcal - varchar(14)
cadj_mcal_mc - varchar(14)
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(11)
tch_supp - varchar(12)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(11)
cap_cnty - varchar(10)
cap_thrd - varchar(11)
cap_tot - varchar(12)
net_mcar - varchar(11)
net_mcar_mc - varchar(12)
net_mcal - varchar(13)
net_mcal_mc - varchar(14)
net_cnty - varchar(12)
net_cnty_mc - varchar(11)
net_thrd - varchar(13)
net_thrd_mc - varchar(14)
net_indgnt - varchar(11)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(13)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(11)
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)

2016_quarter_2_sum_of_four_quarters

fac_no - varchar(9)
fac_name - varchar(72)
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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(12)
grip_mcal - varchar(14)
grip_mcal_mc - varchar(14)
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(14)
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(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(12)
cadj_mcal - varchar(14)
cadj_mcal_mc - varchar(14)
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(12)
tch_allow - varchar(11)
tch_supp - varchar(12)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(11)
cap_cnty - varchar(10)
cap_thrd - varchar(11)
cap_tot - varchar(12)
net_mcar - varchar(11)
net_mcar_mc - varchar(12)
net_mcal - varchar(13)
net_mcal_mc - varchar(14)
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(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(13)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(11)
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(12)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)

2016_quarter_3_sum_of_four_quarters

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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(12)
grip_mcal - varchar(14)
grip_mcal_mc - varchar(14)
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(14)
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(14)
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(14)
cadj_mcal_mc - varchar(14)
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(12)
sub_indgnt - varchar(12)
tch_allow - varchar(11)
tch_supp - varchar(12)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(11)
cap_cnty - varchar(11)
cap_thrd - varchar(11)
cap_tot - varchar(11)
net_mcar - varchar(11)
net_mcar_mc - varchar(12)
net_mcal - varchar(13)
net_mcal_mc - varchar(14)
net_cnty - varchar(12)
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(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(13)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(11)
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(12)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)

2016_quarter_4_sum_of_four_quarters

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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(12)
grip_mcal - varchar(14)
grip_mcal_mc - varchar(14)
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(14)
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(14)
grop_indgnt - varchar(11)
grop_oth - varchar(12)
grop_tot - varchar(14)
bad_debt - varchar(11)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(12)
cadj_mcal - varchar(14)
cadj_mcal_mc - varchar(14)
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(12)
tch_allow - varchar(11)
tch_supp - varchar(12)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(12)
cap_cnty - varchar(11)
cap_thrd - varchar(11)
cap_tot - varchar(12)
net_mcar - varchar(12)
net_mcar_mc - varchar(12)
net_mcal - varchar(13)
net_mcal_mc - varchar(14)
net_cnty - varchar(12)
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(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(13)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(11)
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(12)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)

2017_quarter_1_sum_of_four_quarters

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(15)
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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(14)
grip_mcal_mc - varchar(14)
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(14)
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(12)
grop_tot - varchar(14)
bad_debt - varchar(11)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(14)
cadj_mcal_mc - varchar(14)
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(12)
sub_indgnt - varchar(12)
tch_allow - varchar(11)
tch_supp - varchar(12)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(12)
cap_cnty - varchar(10)
cap_thrd - varchar(11)
cap_tot - varchar(12)
net_mcar - varchar(12)
net_mcar_mc - varchar(12)
net_mcal - varchar(13)
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(12)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(12)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(11)
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(12)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)

2017_quarter_2_sum_of_four_quarters

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(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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(14)
grip_mcal_mc - varchar(14)
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(14)
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(12)
grop_tot - varchar(14)
bad_debt - varchar(12)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(14)
cadj_mcal_mc - varchar(14)
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(11)
tch_supp - varchar(12)
ded_oth - varchar(12)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(12)
cap_cnty - varchar(10)
cap_thrd - varchar(11)
cap_tot - varchar(12)
net_mcar - varchar(12)
net_mcar_mc - varchar(12)
net_mcal - varchar(13)
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(12)
net_oth - varchar(12)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(12)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(10)
exp_pops - varchar(10)
cap_exp - varchar(11)
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)

2017_quarter_3_sum_of_four_quarters

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(15)
address - varchar(33)
city - varchar(19)
zip_code - varchar(10)
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(10)
grip_mcar_mc - varchar(12)
grip_mcal - varchar(10)
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(9)
grip_tot - varchar(11)
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(9)
grop_tot - varchar(10)
bad_debt - varchar(9)
cadj_mcar - varchar(10)
cadj_mcar_mc - varchar(12)
cadj_mcal - varchar(10)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(10)
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(9)
sub_indgnt - varchar(10)
tch_allow - varchar(9)
tch_supp - varchar(9)
ded_oth - varchar(9)
ded_tot - varchar(11)
cap_mcar - varchar(8)
cap_mcal - varchar(9)
cap_cnty - varchar(8)
cap_thrd - varchar(9)
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(9)
net_cnty_mc - varchar(11)
net_thrd - varchar(9)
net_thrd_mc - varchar(11)
net_indgnt - varchar(10)
net_oth - varchar(10)
net_tot - varchar(10)
oth_op_rev - varchar(10)
tot_op_exp - varchar(10)
phy_comp - varchar(9)
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(8)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)

2017_quarter_4_sum_of_four_quarters

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(3)
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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(14)
grip_mcal_mc - varchar(14)
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(14)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(14)
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(12)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(14)
cadj_mcal_mc - varchar(14)
disp_855 - varchar(13)
cadj_cnty - varchar(12)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(11)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(12)
sub_indgnt - varchar(12)
tch_allow - varchar(11)
tch_supp - varchar(12)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(11)
cap_cnty - varchar(10)
cap_thrd - varchar(11)
cap_tot - varchar(11)
net_mcar - varchar(11)
net_mcar_mc - varchar(14)
net_mcal - varchar(12)
net_mcal_mc - varchar(11)
net_cnty - varchar(12)
net_cnty_mc - varchar(11)
net_thrd - varchar(11)
net_thrd_mc - varchar(14)
net_indgnt - varchar(12)
net_oth - varchar(13)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
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(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_1_sum_of_four_quarters

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(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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(14)
grip_mcal_mc - varchar(14)
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(12)
grip_tot - varchar(14)
grop_mcar - varchar(14)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(14)
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(12)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(14)
cadj_mcal_mc - varchar(14)
disp_855 - varchar(13)
cadj_cnty - varchar(12)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(11)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(12)
sub_indgnt - varchar(12)
tch_allow - varchar(11)
tch_supp - varchar(12)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(11)
cap_cnty - varchar(10)
cap_thrd - varchar(12)
cap_tot - varchar(11)
net_mcar - varchar(11)
net_mcar_mc - varchar(14)
net_mcal - varchar(12)
net_mcal_mc - varchar(11)
net_cnty - varchar(12)
net_cnty_mc - varchar(11)
net_thrd - varchar(11)
net_thrd_mc - varchar(14)
net_indgnt - varchar(12)
net_oth - varchar(13)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
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(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(12)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)

2018_quarter_2_sum_of_four_quarters

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(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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(14)
grip_mcal_mc - varchar(14)
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(14)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(14)
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(12)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(14)
cadj_mcal_mc - varchar(14)
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(12)
sub_indgnt - varchar(12)
tch_allow - varchar(11)
tch_supp - varchar(12)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(11)
cap_cnty - varchar(10)
cap_thrd - varchar(12)
cap_tot - varchar(11)
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(11)
net_thrd_mc - varchar(14)
net_indgnt - varchar(12)
net_oth - varchar(13)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(12)
nonop_rev - varchar(12)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(11)
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(12)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)

2018_quarter_3_sum_of_four_quarters

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(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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(14)
grip_mcal_mc - varchar(14)
grip_cnty - varchar(11)
grip_cnty_mc - varchar(12)
grip_thrd - varchar(12)
grip_thrd_mc - varchar(14)
grip_indgnt - varchar(11)
grip_oth - varchar(12)
grip_tot - varchar(14)
grop_mcar - varchar(14)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(14)
grop_cnty - varchar(11)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(12)
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(14)
cadj_mcal_mc - varchar(14)
disp_855 - varchar(13)
cadj_cnty - varchar(12)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(14)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(11)
sub_indgnt - varchar(12)
tch_allow - varchar(11)
tch_supp - varchar(12)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(12)
cap_mcal - varchar(11)
cap_cnty - varchar(11)
cap_thrd - varchar(12)
cap_tot - varchar(11)
net_mcar - varchar(12)
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(12)
net_oth - varchar(13)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(11)
nonop_rev - varchar(12)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(11)
exp_pops - varchar(10)
cap_exp - varchar(11)
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_sum_of_four_quarters

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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(14)
grip_mcal_mc - varchar(14)
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(14)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(14)
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(14)
cadj_mcal_mc - varchar(14)
disp_855 - varchar(13)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(14)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(12)
sub_indgnt - varchar(12)
tch_allow - varchar(11)
tch_supp - varchar(12)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(11)
cap_mcal - varchar(11)
cap_cnty - varchar(11)
cap_thrd - varchar(12)
cap_tot - varchar(11)
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(11)
net_thrd_mc - varchar(14)
net_indgnt - varchar(12)
net_oth - varchar(13)
net_tot - varchar(14)
oth_op_rev - varchar(14)
tot_op_exp - varchar(14)
phy_comp - varchar(11)
nonop_rev - varchar(12)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(11)
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)

2019_quarter_2_sum_of_four_quarters

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(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(10)
grip_mcar - varchar(14)
grip_mcar_mc - varchar(14)
grip_mcal - varchar(14)
grip_mcal_mc - varchar(14)
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(14)
grop_mcar_mc - varchar(14)
grop_mcal - varchar(11)
grop_mcal_mc - varchar(14)
grop_cnty - varchar(11)
grop_cnty_mc - varchar(12)
grop_thrd - varchar(14)
grop_thrd_mc - varchar(14)
grop_indgnt - varchar(11)
grop_oth - varchar(11)
grop_tot - varchar(14)
bad_debt - varchar(12)
cadj_mcar - varchar(14)
cadj_mcar_mc - varchar(14)
cadj_mcal - varchar(14)
cadj_mcal_mc - varchar(14)
disp_855 - varchar(13)
cadj_cnty - varchar(11)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(14)
cadj_thrd_mc - varchar(14)
char_hb - varchar(7)
char_oth - varchar(12)
sub_indgnt - varchar(11)
tch_allow - varchar(11)
tch_supp - varchar(12)
ded_oth - varchar(11)
ded_tot - varchar(14)
cap_mcar - varchar(12)
cap_mcal - varchar(12)
cap_cnty - varchar(11)
cap_thrd - varchar(12)
cap_tot - varchar(12)
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(12)
net_oth - varchar(13)
net_tot - varchar(14)
oth_op_rev - varchar(14)
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(11)
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)

2019_quarter_3_sum_of_four_quarters

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(10)
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(9)
grip_tot - varchar(11)
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(10)
grop_thrd_mc - varchar(12)
grop_indgnt - varchar(11)
grop_oth - varchar(9)
grop_tot - varchar(11)
bad_debt - varchar(9)
cadj_mcar - varchar(10)
cadj_mcar_mc - varchar(12)
cadj_mcal - varchar(10)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(10)
cadj_cnty - varchar(9)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(10)
cadj_thrd_mc - varchar(12)
char_hb - varchar(7)
char_oth - varchar(9)
sub_indgnt - varchar(10)
tch_allow - varchar(9)
tch_supp - varchar(9)
ded_oth - varchar(9)
ded_tot - varchar(11)
cap_mcar - varchar(9)
cap_mcal - varchar(9)
cap_cnty - varchar(8)
cap_thrd - varchar(9)
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(9)
net_thrd_mc - varchar(11)
net_indgnt - varchar(10)
net_oth - varchar(10)
net_tot - varchar(11)
oth_op_rev - varchar(10)
tot_op_exp - varchar(11)
phy_comp - varchar(9)
nonop_rev - varchar(9)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(8)
exp_pops - varchar(9)
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(8)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)

2019_quarter_4_sum_of_four_quarters

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(10)
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(9)
grip_tot - varchar(11)
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(9)
grop_tot - varchar(11)
bad_debt - varchar(9)
cadj_mcar - varchar(10)
cadj_mcar_mc - varchar(12)
cadj_mcal - varchar(10)
cadj_mcal_mc - varchar(12)
disp_855 - varchar(10)
cadj_cnty - varchar(9)
cadj_cnty_mc - varchar(12)
cadj_thrd - varchar(10)
cadj_thrd_mc - varchar(12)
char_hb - varchar(7)
char_oth - varchar(9)
sub_indgnt - varchar(10)
tch_allow - varchar(9)
tch_supp - varchar(9)
ded_oth - varchar(9)
ded_tot - varchar(11)
cap_mcar - varchar(10)
cap_mcal - varchar(9)
cap_cnty - varchar(8)
cap_thrd - varchar(9)
cap_tot - varchar(10)
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(9)
net_thrd_mc - varchar(11)
net_indgnt - varchar(10)
net_oth - varchar(10)
net_tot - varchar(11)
oth_op_rev - varchar(10)
tot_op_exp - varchar(11)
phy_comp - varchar(9)
nonop_rev - varchar(9)
dis_pips - varchar(8)
day_pips - varchar(8)
exp_pips - varchar(8)
exp_pops - varchar(9)
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(8)
qa_suppl_pay - varchar(12)
mngd_care_qa_pay - varchar(16)

hqfur_2020_quarter_1_sum_of_four_quarters

fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - date
end_date - date
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(5)
dis_mcar_mc - varchar(5)
dis_mcal - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(6)
dis_ltc - varchar(4)
day_mcar - varchar(6)
day_mcar_mc - varchar(6)
day_mcal - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(4)
day_thrd - varchar(5)
day_thrd_mc - varchar(6)
day_indgnt - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
day_ltc - varchar(6)
vis_mcar - varchar(9)
vis_mcar_mc - varchar(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2020_quarter_2_sum_of_four_quarters_10_19_2020

hqfur_2020_quarter_3_sum_of_four_quarters_01_15_2021

fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - date
end_date - date
op_status - varchar(21)
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(5)
dis_mcar_mc - varchar(5)
dis_mcal - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
dis_ltc - varchar(4)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(4)
day_thrd - varchar(5)
day_thrd_mc - varchar(5)
day_indgnt - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
day_ltc - varchar(6)
vis_mcar - varchar(9)
vis_mcar_mc - varchar(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2020_quarter_4_sum_of_four_quarters_04_15_2021

fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - date
end_date - date
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(5)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
dis_ltc - varchar(4)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(4)
day_thrd - varchar(5)
day_thrd_mc - varchar(5)
day_indgnt - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
day_ltc - varchar(6)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2021_quarter_1_sum_of_four_quarters_07_14_2021

fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - date
end_date - date
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(5)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
dis_ltc - varchar(4)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(4)
day_thrd - varchar(5)
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(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2021_quarter_2_sum_of_four_quarters_10_13_2021

fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - date
end_date - date
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(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(5)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
dis_ltc - varchar(4)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(4)
day_thrd - varchar(6)
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(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2021_quarter_3_sum_of_four_quarters_01_13_2022

fac_no - varchar(9)
fac_name - varchar(70)
year_qtr - varchar(5)
beg_date - date
end_date - date
op_status - varchar(8)
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(5)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
dis_ltc - varchar(4)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(4)
day_thrd - varchar(6)
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(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2021_quarter_4_sum_of_four_quarters_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(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(5)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
dis_ltc - varchar(4)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(4)
day_thrd - varchar(6)
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(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2022_quarter_1_sum_of_four_quarters_07_14_2022

hqfur_2022_quarter_2_sum_of_four_quarters_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(5)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(4)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(4)
day_thrd - varchar(6)
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(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2022_quarter_3_sum_of_four_quarters_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(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(5)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(4)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(4)
day_thrd - varchar(6)
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(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2022_quarter_4_sum_of_four_quarters_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(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(5)
dis_mcar_mc - varchar(4)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(4)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(4)
day_thrd - varchar(6)
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(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2023_quarter_1_sum_of_four_quarters_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(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(5)
dis_mcar_mc - varchar(5)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(3)
dis_oth - varchar(3)
dis_tot - varchar(5)
dis_ltc - varchar(4)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(4)
day_thrd - varchar(6)
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(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2023_quarter_2_sum_of_four_quarters_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(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(5)
dis_mcar_mc - varchar(5)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(3)
dis_oth - varchar(4)
dis_tot - varchar(5)
dis_ltc - varchar(4)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_cnty_mc - varchar(4)
day_thrd - varchar(6)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(6)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2023_quarter_3_sum_of_four_quarters_01_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(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(5)
dis_mcar_mc - varchar(5)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(3)
dis_oth - varchar(4)
dis_tot - varchar(5)
dis_ltc - varchar(4)
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(4)
day_thrd - varchar(6)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(6)
day_tot - varchar(6)
day_ltc - varchar(5)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2023_quarter_4_sum_of_four_quarters_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(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(5)
dis_mcar_mc - varchar(5)
dis_mcal - varchar(4)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_cnty_mc - varchar(3)
dis_thrd - varchar(4)
dis_thrd_mc - varchar(5)
dis_indgnt - varchar(3)
dis_oth - varchar(4)
dis_tot - varchar(5)
dis_ltc - varchar(4)
day_mcar - varchar(6)
day_mcar_mc - varchar(5)
day_mcal - varchar(5)
day_mcal_mc - varchar(6)
day_cnty - varchar(5)
day_cnty_mc - varchar(4)
day_thrd - varchar(5)
day_thrd_mc - varchar(5)
day_indgnt - varchar(4)
day_oth - varchar(6)
day_tot - varchar(6)
day_ltc - varchar(6)
vis_mcar - varchar(6)
vis_mcar_mc - varchar(6)
vis_mcal - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_cnty_mc - varchar(5)
vis_thrd - varchar(6)
vis_thrd_mc - varchar(7)

hqfur_2023_quarter_4_sum_of_four_quarters_04_29_2024

Sources

2012-quarter-1-sum-of-four-quarters.xls	-	None
2012-quarter-2-sum-of-four-quarters.xls	-	None
2012-quarter-3-sum-of-four-quarters.xls	-	None
2012-quarter-4-sum-of-four-quarters.xls	-	None
2019-quarter-1-sum-of-four-quarters.csv	-	None
data-importing-instructions-for-excel.docx	-	None
documentation-for-hospital-quarterly-financial-and-utilization-data-files0.pdf	-	None
documentation-for-hospital-quarterly-financial-and-utilization-data-files.pdf	-	None
documentation-for-hospital-quarterly-financial-utilization-data-2000-2014.pdf	-	None
pre-2012-hospital-quarterly-financial-utilization-report-sum-of-four-quarters.html	-	None
datapackage.json	-	None
2013-quarter-1-sum-of-four-quarters-rev-7-15.csv	-	2013_quarter_1_sum_of_four_quarters_rev_7_15
2013-quarter-1-sum-of-four-quarters-rev-7-15.csv	-	2013_quarter_1_sum_of_four_quarters_rev_7_15
2013-quarter-2-sum-of-four-quarters-rev-7-15.csv	-	2013_quarter_2_sum_of_four_quarters_rev_7_15
2013-quarter-2-sum-of-four-quarters-rev-7-15.csv	-	2013_quarter_2_sum_of_four_quarters_rev_7_15
2013-quarter-3-sum-of-four-quarters-rev-7-15.csv	-	2013_quarter_3_sum_of_four_quarters_rev_7_15
2013-quarter-3-sum-of-four-quarters-rev-7-15.csv	-	2013_quarter_3_sum_of_four_quarters_rev_7_15
2013-quarter-4-sum-of-four-quarters-rev-7-15.csv	-	2013_quarter_4_sum_of_four_quarters_rev_7_15
2014-quarter-1-sum-of-four-quarters-rev-7-15.csv	-	2014_quarter_1_sum_of_four_quarters_rev_7_15
2014-quarter-2-sum-of-four-quarters-rev-7-15.csv	-	2014_quarter_2_sum_of_four_quarters_rev_7_15
2014-quarter-3-sum-of-four-quarters-rev-7-15.csv	-	2014_quarter_3_sum_of_four_quarters_rev_7_15
2014-quarter-4-sum-of-four-quarters-rev-7-15.csv	-	2014_quarter_4_sum_of_four_quarters_rev_7_15
2015-quarter-1-sum-of-four-quarters-rev-4-16.csv	-	2015_quarter_1_sum_of_four_quarters_rev_4_16
2015-quarter-2-sum-of-four-quarters-rev-4-16.csv	-	2015_quarter_2_sum_of_four_quarters_rev_4_16
2015-quarter-3-sum-of-four-quarters-rev-4-16.csv	-	2015_quarter_3_sum_of_four_quarters_rev_4_16
2015-quarter-4-sum-of-four-quarters-rev-4-16.csv	-	2015_quarter_4_sum_of_four_quarters_rev_4_16
2016-quarter-1-sum-of-four-quarters.csv	-	2016_quarter_1_sum_of_four_quarters
2016-quarter-2-sum-of-four-quarters.csv	-	2016_quarter_2_sum_of_four_quarters
2016-quarter-3-sum-of-four-quarters.csv	-	2016_quarter_3_sum_of_four_quarters
2016-quarter-4-sum-of-four-quarters.csv	-	2016_quarter_4_sum_of_four_quarters
2017-quarter-1-sum-of-four-quarters.csv	-	2017_quarter_1_sum_of_four_quarters
2017-quarter-2-sum-of-four-quarters.csv	-	2017_quarter_2_sum_of_four_quarters
2017-quarter-3-sum-of-four-quarters.csv	-	2017_quarter_3_sum_of_four_quarters
2017-quarter-4-sum-of-four-quarters.csv	-	2017_quarter_4_sum_of_four_quarters
2018-quarter-1-sum-of-four-quarters.csv	-	2018_quarter_1_sum_of_four_quarters
2018-quarter-2-sum-of-four-quarters.csv	-	2018_quarter_2_sum_of_four_quarters
2018-quarter-3-sum-of-four-quarters.csv	-	2018_quarter_3_sum_of_four_quarters
2018-quarter-4-sum-of-four-quarters.csv	-	2018_quarter_4_sum_of_four_quarters
2019-quarter-2-sum-of-four-quarters.csv	-	2019_quarter_2_sum_of_four_quarters
2019-quarter-3-sum-of-four-quarters.csv	-	2019_quarter_3_sum_of_four_quarters
2019-quarter-4-sum-of-four-quarters.csv	-	2019_quarter_4_sum_of_four_quarters
2020-quarter-1-sum-of-four-quarters.xlsx	-	hqfur_2020_quarter_1_sum_of_four_quarters
2020-quarter-2-sum-of-four-quarters-10-19-2020.xlsx	-	hqfur_2020_quarter_2_sum_of_four_quarters_10_19_2020
2020-quarter-3-sum-of-four-quarters-01-15-2021.xlsx	-	hqfur_2020_quarter_3_sum_of_four_quarters_01_15_2021
2020-quarter-4-sum-of-four-quarters-04-15-2021.xlsx	-	hqfur_2020_quarter_4_sum_of_four_quarters_04_15_2021
2021-quarter-1-sum-of-four-quarters-07-14-2021.xlsx	-	hqfur_2021_quarter_1_sum_of_four_quarters_07_14_2021
2021-quarter-2-sum-of-four-quarters-10-13-2021.xlsx	-	hqfur_2021_quarter_2_sum_of_four_quarters_10_13_2021
2021-quarter-3-sum-of-four-quarters-01-13-2022.xlsx	-	hqfur_2021_quarter_3_sum_of_four_quarters_01_13_2022
2021-quarter-4-sum-of-four-quarters-04-15-2022.xlsx	-	hqfur_2021_quarter_4_sum_of_four_quarters_04_15_2022
2022-quarter-1-sum-of-four-quarters-07-14-2022.xlsx	-	hqfur_2022_quarter_1_sum_of_four_quarters_07_14_2022
2022-quarter-2-sum-of-four-quarters-10-13-2022.xlsx	-	hqfur_2022_quarter_2_sum_of_four_quarters_10_13_2022
2022-quarter-3-sum-of-four-quarters-01-13-2023.xlsx	-	hqfur_2022_quarter_3_sum_of_four_quarters_01_13_2023
2022-quarter-4-sum-of-four-quarters-04-14-2023.xlsx	-	hqfur_2022_quarter_4_sum_of_four_quarters_04_14_2023
2023-quarter-1-sum-of-four-quarters-07-14-2023.xlsx	-	hqfur_2023_quarter_1_sum_of_four_quarters_07_14_2023
2023-quarter-2-sum-of-four-quarters-10-16-2023.xlsx	-	hqfur_2023_quarter_2_sum_of_four_quarters_10_16_2023
2023-quarter-3-sum-of-four-quarters-01-16-2024.xlsx	-	hqfur_2023_quarter_3_sum_of_four_quarters_01_16_2024
2023-quarter-4-sum-of-four-quarters-04-16-2024.xlsx	-	hqfur_2023_quarter_4_sum_of_four_quarters_04_16_2024
2024-quarter-4-sum-of-four-quarters-04-29-2024.xlsx	-	hqfur_2023_quarter_4_sum_of_four_quarters_04_29_2024

Updates

2025-07-11 17:46:46		None
2025-06-28 16:52:13		1
2025-06-28 15:17:13		1
2025-06-14 17:08:17		1
2025-06-14 17:05:55		1
2025-06-14 16:30:28		0
2025-06-14 16:28:48		1
2025-06-14 16:17:01		1
2025-06-06 12:08:07		1
2025-02-06 21:39:11		1
2025-02-06 21:33:37		1
2025-02-02 18:12:19		1
2025-01-16 23:53:56		0
2025-01-16 23:53:31		0
2025-01-16 19:17:13		0
2025-01-16 19:16:35		0
2024-12-20 10:19:56		0
2024-12-20 10:18:48		1
2024-12-14 15:47:46		1
2024-12-04 16:28:24		None
2024-09-18 13:06:56		None