| Name |
hospital-quarterly-financial-utilization-report-sum-of-four-quarters |
|---|
| Updated |
2025-04-29 |
|---|
| Current |
True |
|---|
| 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 | |
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(6)
|
| 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 | |
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_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
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-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 |
|
|---|