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