HCAI

Home

Dataset:

Name

hospital-annual-financial-data-selected-data-pivot-tables

Updated

2025-04-23

CA Dataset

link

Current

True

Tables

2012_2013_fy_hospital_annual_selected_file_june_2014_extract

2012_2017_cy_hospital_annual_selected_file_machine_read_ee501c9c

fac_no - varchar(9)
fac_name - varchar(49)
beg_date - varchar(9)
end_date - varchar(9)
day_per - varchar(7)
data_ind - varchar(10)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(3)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(10)
teach_rurl - varchar(10)
phone - varchar(14)
address - varchar(28)
city - varchar(16)
zip_code - varchar(10)
ceo - varchar(23)
ceo_title - varchar(18)
web_site1 - varchar(32)
owner - varchar(45)
rpt_prep - varchar(23)
org_name1 - varchar(44)
er_desig - varchar(8)
mcar_pronum - varchar(9)
mcal_pronum - varchar(9)
reg_mcalnum - varchar(9)
bed_lic - varchar(7)
bed_avl - varchar(7)
bed_stf - varchar(7)
variable - varchar(15)
amount - varchar(12)
web_site2 - varchar(32)
org_name2 - varchar(40)

2012_cy_hospital_annual_selected_file_october_2014_extract

2013_2014_fy_hospital_annual_selected_file_sept_2015_extract

2013_cy_hospital_annual_selected_file_september_2014_extract

2013_pivot_table_hospital_annual_selected_file

2014_2015_fy_hospital_annual_selected_file_april_2017_extract

fac_no - varchar(9)
fac_name - varchar(58)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(10)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(10)
address - varchar(35)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(28)
ceo_title - varchar(25)
web_site - varchar(60)
owner - varchar(54)
rpt_prep - varchar(30)
org_name - varchar(72)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(10)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(5)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(4)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(4)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(3)
occ_lic - varchar(5)
occ_avl - varchar(4)
alos_all - varchar(6)
alos_exltc - varchar(6)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_thrd_tr - varchar(6)
vis_thrd_mc - varchar(6)
vis_oth_ind - varchar(5)
vis_oth - varchar(5)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(6)
vis_home - varchar(6)
vis_ref_op - varchar(6)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(10)
tot_cap_rev - varchar(9)
net_pt_rev - varchar(10)
oth_op_rev - varchar(9)
tot_op_exp - varchar(10)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(7)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(10)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(9)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(9)
gr_ip_cnty - varchar(8)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(8)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(10)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(9)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(9)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(10)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(9)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(9)
ded_oth - varchar(9)
cap_rev_mcar - varchar(9)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(7)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(8)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(8)
netrv_oth - varchar(9)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(8)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(9)
exp_anc - varchar(9)
exp_pip - varchar(8)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(9)
exp_unassg - varchar(9)
exp_sal - varchar(9)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(9)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(10)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(9)
inv_oth - varchar(10)
intan_asst - varchar(9)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(10)
liab_eq - varchar(11)
cash - varchar(9)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs_ - varchar(11)
equipment - varchar(9)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(9)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(8)
inter_rec - varchar(10)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(7)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(7)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(6)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(7)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(7)

2014_cy_hospital_annual_selected_file_april_2017_extract

fac_no - varchar(9)
fac_name - varchar(58)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(7)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(10)
address - varchar(35)
city - varchar(19)
zip_code - varchar(11)
ceo - varchar(25)
ceo_title - varchar(28)
web_site - varchar(60)
owner - varchar(54)
rpt_prep - varchar(28)
org_name - varchar(68)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(10)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(5)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(4)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(4)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(2)
occ_lic - varchar(5)
occ_avl - varchar(4)
alos_all - varchar(6)
alos_exltc - varchar(5)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(6)
vis_thrd_tr - varchar(6)
vis_thrd_mc - varchar(6)
vis_oth_ind - varchar(5)
vis_oth - varchar(6)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(6)
vis_home - varchar(6)
vis_ref_op - varchar(6)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(10)
tot_cap_rev - varchar(9)
net_pt_rev - varchar(10)
oth_op_rev - varchar(9)
tot_op_exp - varchar(10)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(9)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(10)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(9)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(9)
gr_ip_cnty - varchar(9)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(9)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(10)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(9)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(9)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(8)
gr_op_oth - varchar(9)
gr_op_tot - varchar(10)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(9)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(9)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(9)
ded_oth - varchar(9)
cap_rev_mcar - varchar(8)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(7)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(9)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(8)
netrv_oth - varchar(9)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(8)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(9)
exp_anc - varchar(9)
exp_pip - varchar(8)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(9)
exp_unassg - varchar(9)
exp_sal - varchar(9)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(9)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(10)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(10)
inv_oth - varchar(10)
intan_asst - varchar(9)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(10)
liab_eq - varchar(11)
cash - varchar(9)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs_ - varchar(11)
equipment - varchar(9)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(8)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(8)
inter_rec - varchar(10)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(7)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(7)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(7)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(7)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(7)

2014_pivot_table_hospital_annual_selected_file

2015_2016_fy_hospital_annual_selected_file_sept_2018_extract

fac_no - varchar(9)
fac_name - varchar(58)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(10)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(12)
address - varchar(35)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(25)
ceo_title - varchar(24)
web_site - varchar(60)
owner - varchar(54)
rpt_prep - varchar(30)
org_name - varchar(51)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(10)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(5)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(5)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(4)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(3)
occ_lic - varchar(4)
occ_avl - varchar(4)
alos_all - varchar(6)
alos_exltc - varchar(6)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(6)
vis_thrd_tr - varchar(6)
vis_thrd_mc - varchar(6)
vis_oth_ind - varchar(6)
vis_oth - varchar(5)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(7)
vis_home - varchar(6)
vis_ref_op - varchar(6)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(11)
tot_cap_rev - varchar(9)
net_pt_rev - varchar(10)
oth_op_rev - varchar(9)
tot_op_exp - varchar(10)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(8)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(11)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(9)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(10)
gr_ip_cnty - varchar(9)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(8)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(10)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(9)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(9)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(10)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(9)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(8)
ded_oth - varchar(9)
cap_rev_mcar - varchar(8)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(7)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(8)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(9)
netrv_oth - varchar(9)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(8)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(9)
exp_anc - varchar(10)
exp_pip - varchar(8)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(9)
exp_unassg - varchar(9)
exp_sal - varchar(10)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(9)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(10)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(9)
inv_oth - varchar(10)
intan_asst - varchar(9)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(11)
liab_eq - varchar(11)
cash - varchar(9)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs_ - varchar(11)
equipment - varchar(10)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(8)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(9)
inter_rec - varchar(10)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(6)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(7)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(7)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(7)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(7)

2015_cy_hospital_annual_selected_file_march_2018_extract

fac_no - varchar(9)
fac_name - varchar(58)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(10)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(13)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(12)
address - varchar(35)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(28)
ceo_title - varchar(24)
web_site - varchar(60)
owner - varchar(54)
rpt_prep - varchar(30)
org_name - varchar(74)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(10)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(5)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(5)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(4)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(3)
occ_lic - varchar(18)
occ_avl - varchar(18)
alos_all - varchar(6)
alos_exltc - varchar(6)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_thrd_tr - varchar(6)
vis_thrd_mc - varchar(6)
vis_oth_ind - varchar(5)
vis_oth - varchar(5)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(6)
vis_home - varchar(6)
vis_ref_op - varchar(6)
day_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(10)
tot_cap_rev - varchar(9)
net_pt_rev - varchar(10)
oth_op_rev - varchar(9)
tot_op_exp - varchar(10)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(8)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(10)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(9)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(9)
gr_ip_cnty - varchar(9)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(8)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(10)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(9)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(9)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(10)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(9)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(9)
ded_oth - varchar(9)
cap_rev_mcar - varchar(9)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(7)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(8)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(9)
netrv_oth - varchar(9)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(8)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(9)
exp_anc - varchar(9)
exp_pip - varchar(8)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(9)
exp_unassg - varchar(9)
exp_sal - varchar(9)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(9)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(10)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(9)
inv_oth - varchar(10)
intan_asst - varchar(9)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(11)
liab_eq - varchar(11)
cash - varchar(9)
acctc_rec - varchar(10)
allow_uncol - varchar(11)
bldgs - varchar(11)
equipment - varchar(10)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(9)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(9)
inter_rec - varchar(10)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(7)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(7)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(6)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(7)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(7)

2015_pivot_table_hospital_annual_selected_file

2016_cy_hospital_annual_selected_file_september_2018_extract

fac_no - varchar(9)
fac_name - varchar(58)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(10)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(12)
address - varchar(35)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(25)
ceo_title - varchar(24)
web_site - varchar(60)
owner - varchar(54)
rpt_prep - varchar(30)
org_name - varchar(51)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(10)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(5)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(4)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(3)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(4)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(3)
occ_lic - varchar(4)
occ_avl - varchar(4)
alos_all - varchar(6)
alos_exltc - varchar(6)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(6)
vis_thrd_tr - varchar(6)
vis_thrd_mc - varchar(6)
vis_oth_ind - varchar(6)
vis_oth - varchar(5)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(7)
vis_home - varchar(6)
vis_ref_op - varchar(6)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(11)
tot_cap_rev - varchar(9)
net_pt_rev - varchar(11)
oth_op_rev - varchar(9)
tot_op_exp - varchar(10)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(1)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(11)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(9)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(10)
gr_ip_cnty - varchar(8)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(8)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(10)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(9)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(9)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(10)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(9)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(8)
ded_oth - varchar(9)
cap_rev_mcar - varchar(8)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(7)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(8)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(8)
netrv_oth - varchar(9)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(8)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(9)
exp_anc - varchar(10)
exp_pip - varchar(9)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(9)
exp_unassg - varchar(9)
exp_sal - varchar(10)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(9)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(10)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(10)
inv_oth - varchar(10)
intan_asst - varchar(9)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(11)
liab_eq - varchar(11)
cash - varchar(9)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs_ - varchar(11)
equipment - varchar(9)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(8)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(9)
inter_rec - varchar(10)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(6)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(7)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(7)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(7)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(7)

2016_pivot_table_hospital_annual_selected_file_sept_2018_extract

2017_2018_fy_hospital_annual_selected_file_april_2020_extract

fac_no - varchar(9)
fac_name - varchar(59)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(10)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(12)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(27)
ceo_title - varchar(24)
web_site - varchar(60)
owner - varchar(54)
rpt_prep - varchar(30)
org_name - varchar(57)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(9)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(5)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(5)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(4)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(2)
occ_lic - varchar(5)
occ_avl - varchar(5)
alos_all - varchar(6)
alos_exltc - varchar(5)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(6)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(6)
vis_thrd_tr - varchar(6)
vis_thrd_mc - varchar(6)
vis_oth_ind - varchar(5)
vis_oth - varchar(6)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(7)
vis_home - varchar(6)
vis_ref_op - varchar(6)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(11)
tot_cap_rev - varchar(9)
net_pt_rev - varchar(10)
oth_op_rev - varchar(10)
tot_op_exp - varchar(10)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(1)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(11)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(9)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(10)
gr_ip_cnty - varchar(9)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(9)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(11)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(9)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(9)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(10)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(10)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(8)
ded_oth - varchar(9)
cap_rev_mcar - varchar(8)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(8)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(8)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(8)
netrv_oth - varchar(8)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(8)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(9)
exp_anc - varchar(10)
exp_pip - varchar(9)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(9)
exp_unassg - varchar(9)
exp_sal - varchar(10)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(10)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(11)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(10)
inv_oth - varchar(10)
intan_asst - varchar(9)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(11)
liab_eq - varchar(11)
cash - varchar(10)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs - varchar(11)
equipment - varchar(10)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(9)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(9)
inter_rec - varchar(10)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(7)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(8)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(6)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(8)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(6)

2017_cy_hospital_annual_selected_file_october_2019_extract

fac_no - varchar(9)
fac_name - varchar(58)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(10)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(12)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(27)
ceo_title - varchar(26)
web_site - varchar(60)
owner - varchar(54)
rpt_prep - varchar(32)
org_name - varchar(53)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(9)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(5)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(5)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(4)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(3)
occ_lic - varchar(5)
occ_avl - varchar(5)
alos_all - varchar(6)
alos_exltc - varchar(5)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(6)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_thrd_tr - varchar(6)
vis_thrd_mc - varchar(6)
vis_oth_ind - varchar(6)
vis_oth - varchar(6)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(7)
vis_home - varchar(6)
vis_ref_op - varchar(6)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(11)
tot_cap_rev - varchar(9)
net_pt_rev - varchar(10)
oth_op_rev - varchar(10)
tot_op_exp - varchar(10)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(1)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(11)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(9)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(10)
gr_ip_cnty - varchar(9)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(8)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(11)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(9)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(9)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(10)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(10)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(8)
ded_oth - varchar(9)
cap_rev_mcar - varchar(8)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(8)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(8)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(8)
netrv_oth - varchar(9)
disp_trnfr - varchar(9)
inter_tfr - varchar(11)
contribtns - varchar(8)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(9)
exp_anc - varchar(10)
exp_pip - varchar(9)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(9)
exp_unassg - varchar(9)
exp_sal - varchar(10)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(10)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(11)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(10)
inv_oth - varchar(10)
intan_asst - varchar(9)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(11)
liab_eq - varchar(11)
cash - varchar(10)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs - varchar(11)
equipment - varchar(10)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(9)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(9)
inter_rec - varchar(10)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(6)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(7)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(7)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(7)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(7)

2018_2019_fy_hospital_annual_selected_file_may_2021_extract

fac_no - varchar(9)
fac_name - varchar(70)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(10)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(12)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(24)
ceo_title - varchar(24)
web_site - varchar(60)
owner - varchar(55)
rpt_prep - varchar(33)
org_name - varchar(60)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(9)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(5)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(5)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(4)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(3)
occ_lic - varchar(5)
occ_avl - varchar(5)
alos_all - varchar(6)
alos_exltc - varchar(5)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(6)
vis_thrd_tr - varchar(6)
vis_thrd_mc - varchar(6)
vis_oth_ind - varchar(5)
vis_oth - varchar(6)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(7)
vis_home - varchar(6)
vis_ref_op - varchar(6)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(11)
tot_cap_rev - varchar(9)
net_pt_rev - varchar(11)
oth_op_rev - varchar(10)
tot_op_exp - varchar(10)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(1)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(11)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(9)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(10)
gr_ip_cnty - varchar(9)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(9)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(11)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(9)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(9)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(10)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(10)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(9)
ded_oth - varchar(11)
cap_rev_mcar - varchar(9)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(6)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(8)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(8)
netrv_oth - varchar(9)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(8)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(9)
exp_anc - varchar(10)
exp_pip - varchar(9)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(9)
exp_unassg - varchar(9)
exp_sal - varchar(10)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(10)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(11)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(10)
inv_oth - varchar(10)
intan_asst - varchar(10)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(11)
liab_eq - varchar(11)
cash - varchar(10)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs - varchar(11)
equipment - varchar(10)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(9)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(9)
inter_rec - varchar(11)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(7)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(7)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(7)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(7)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(7)

2018_cy_hospital_annual_selected_file_november_2020_extract

fac_no - varchar(9)
fac_name - varchar(70)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(7)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(12)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(27)
ceo_title - varchar(26)
web_site - varchar(60)
owner - varchar(55)
rpt_prep - varchar(30)
org_name - varchar(57)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(9)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(5)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(5)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(4)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(3)
occ_lic - varchar(4)
occ_avl - varchar(4)
alos_all - varchar(6)
alos_exltc - varchar(5)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(6)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(6)
vis_thrd_tr - varchar(6)
vis_thrd_mc - varchar(6)
vis_oth_ind - varchar(5)
vis_oth - varchar(6)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(7)
vis_home - varchar(6)
vis_ref_op - varchar(6)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(11)
tot_cap_rev - varchar(9)
net_pt_rev - varchar(11)
oth_op_rev - varchar(10)
tot_op_exp - varchar(10)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(1)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(11)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(9)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(10)
gr_ip_cnty - varchar(9)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(8)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(11)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(9)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(9)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(10)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(10)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(8)
ded_oth - varchar(11)
cap_rev_mcar - varchar(8)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(8)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(8)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(8)
netrv_oth - varchar(8)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(8)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(9)
exp_anc - varchar(10)
exp_pip - varchar(9)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(9)
exp_unassg - varchar(9)
exp_sal - varchar(10)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(10)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(11)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(10)
inv_oth - varchar(10)
intan_asst - varchar(9)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(11)
liab_eq - varchar(11)
cash - varchar(10)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs - varchar(11)
equipment - varchar(10)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(9)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(9)
inter_rec - varchar(11)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(7)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(8)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(6)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(8)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(6)

2019_2020_fy_hospital_annual_selected_file_april_2022_extract

fac_no - varchar(9)
fac_name - varchar(70)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(7)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(12)
address - varchar(33)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(26)
ceo_title - varchar(24)
web_site - varchar(75)
owner - varchar(55)
rpt_prep - varchar(33)
org_name - varchar(60)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(10)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(5)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(4)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(5)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(3)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(3)
occ_lic - varchar(4)
occ_avl - varchar(4)
alos_all - varchar(6)
alos_exltc - varchar(6)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(6)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_thrd_tr - varchar(5)
vis_thrd_mc - varchar(6)
vis_oth_ind - varchar(5)
vis_oth - varchar(6)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(7)
vis_home - varchar(6)
vis_ref_op - varchar(6)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(11)
tot_cap_rev - varchar(9)
net_pt_rev - varchar(11)
oth_op_rev - varchar(10)
tot_op_exp - varchar(11)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(1)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(11)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(10)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(10)
gr_ip_cnty - varchar(9)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(9)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(11)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(9)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(10)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(11)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(10)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(9)
ded_oth - varchar(9)
cap_rev_mcar - varchar(9)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(6)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(8)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(8)
netrv_oth - varchar(8)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(9)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(9)
exp_anc - varchar(10)
exp_pip - varchar(9)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(10)
exp_unassg - varchar(9)
exp_sal - varchar(10)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(10)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(11)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(10)
inv_oth - varchar(10)
intan_asst - varchar(10)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(11)
liab_eq - varchar(11)
cash - varchar(10)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs - varchar(11)
equipment - varchar(10)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(9)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(9)
inter_rec - varchar(11)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(7)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(7)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(7)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(7)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(7)

2019_cy_hospital_annual_selected_file_april_2022_extract

fac_no - varchar(9)
fac_name - varchar(70)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(7)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(12)
address - varchar(33)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(24)
ceo_title - varchar(24)
web_site - varchar(60)
owner - varchar(55)
rpt_prep - varchar(33)
org_name - varchar(60)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(9)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(5)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(5)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(4)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(3)
occ_lic - varchar(5)
occ_avl - varchar(5)
alos_all - varchar(6)
alos_exltc - varchar(5)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(5)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(6)
vis_thrd_tr - varchar(6)
vis_thrd_mc - varchar(6)
vis_oth_ind - varchar(5)
vis_oth - varchar(5)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(7)
vis_home - varchar(6)
vis_ref_op - varchar(6)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(11)
tot_cap_rev - varchar(9)
net_pt_rev - varchar(11)
oth_op_rev - varchar(10)
tot_op_exp - varchar(11)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(1)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(11)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(10)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(10)
gr_ip_cnty - varchar(9)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(9)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(11)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(9)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(10)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(11)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(10)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(9)
ded_oth - varchar(9)
cap_rev_mcar - varchar(9)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(6)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(8)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(8)
netrv_oth - varchar(9)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(8)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(9)
exp_anc - varchar(10)
exp_pip - varchar(9)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(9)
exp_unassg - varchar(9)
exp_sal - varchar(10)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(10)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(11)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(10)
inv_oth - varchar(10)
intan_asst - varchar(10)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(11)
liab_eq - varchar(11)
cash - varchar(10)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs - varchar(11)
equipment - varchar(10)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(9)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(9)
inter_rec - varchar(11)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(7)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(7)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(7)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(7)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(7)

2020_2021_fy_hospital_annual_selected_file_october_2022_extract

fac_no - varchar(9)
fac_name - varchar(70)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(10)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(12)
address - varchar(31)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(26)
ceo_title - varchar(18)
web_site - varchar(63)
owner - varchar(62)
rpt_prep - varchar(30)
org_name - varchar(74)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(9)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(6)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(4)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(4)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(3)
occ_lic - varchar(5)
occ_avl - varchar(5)
alos_all - varchar(6)
alos_exltc - varchar(6)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(6)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_thrd_tr - varchar(5)
vis_thrd_mc - varchar(6)
vis_oth_ind - varchar(5)
vis_oth - varchar(6)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(7)
vis_home - varchar(6)
vis_ref_op - varchar(6)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(11)
tot_cap_rev - varchar(10)
net_pt_rev - varchar(11)
oth_op_rev - varchar(10)
tot_op_exp - varchar(11)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(1)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(11)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(10)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(10)
gr_ip_cnty - varchar(9)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(9)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(11)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(9)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(10)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(11)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(11)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(9)
ded_oth - varchar(9)
cap_rev_mcar - varchar(10)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(1)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(9)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(9)
netrv_oth - varchar(10)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(9)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(9)
exp_anc - varchar(10)
exp_pip - varchar(9)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(9)
exp_unassg - varchar(9)
exp_sal - varchar(10)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(10)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(11)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(10)
inv_oth - varchar(10)
intan_asst - varchar(10)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(11)
liab_eq - varchar(11)
cash - varchar(10)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs - varchar(11)
equipment - varchar(10)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(9)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(9)
inter_rec - varchar(11)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(6)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(7)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(7)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(7)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(7)

2020_cy_hospital_annual_selected_file_october_2022_extract

fac_no - varchar(9)
fac_name - varchar(70)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(7)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(12)
address - varchar(31)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(26)
ceo_title - varchar(21)
web_site - varchar(75)
owner - varchar(62)
rpt_prep - varchar(30)
org_name - varchar(74)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(10)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(5)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(4)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(3)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(3)
occ_lic - varchar(4)
occ_avl - varchar(4)
alos_all - varchar(6)
alos_exltc - varchar(6)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(6)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_thrd_tr - varchar(5)
vis_thrd_mc - varchar(6)
vis_oth_ind - varchar(5)
vis_oth - varchar(6)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(7)
vis_home - varchar(6)
vis_ref_op - varchar(6)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(11)
tot_cap_rev - varchar(10)
net_pt_rev - varchar(11)
oth_op_rev - varchar(10)
tot_op_exp - varchar(11)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(1)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(11)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(10)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(10)
gr_ip_cnty - varchar(9)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(9)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(11)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(9)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(10)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(11)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(11)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(9)
ded_oth - varchar(9)
cap_rev_mcar - varchar(10)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(6)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(8)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(9)
netrv_oth - varchar(10)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(9)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(9)
exp_anc - varchar(10)
exp_pip - varchar(9)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(10)
exp_unassg - varchar(9)
exp_sal - varchar(10)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(10)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(11)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(10)
inv_oth - varchar(10)
intan_asst - varchar(10)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(11)
liab_eq - varchar(11)
cash - varchar(10)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs - varchar(11)
equipment - varchar(10)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(9)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(9)
inter_rec - varchar(11)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(7)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(7)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(7)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(7)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(7)

2021_cy_hospital_annual_selected_file_october_2023_extract

fac_no - varchar(9)
fac_name - varchar(70)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(7)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(12)
address - varchar(31)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(28)
ceo_title - varchar(20)
web_site - varchar(63)
owner - varchar(61)
rpt_prep - varchar(30)
org_name - varchar(74)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(10)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(6)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(4)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(4)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(3)
occ_lic - varchar(5)
occ_avl - varchar(5)
alos_all - varchar(6)
alos_exltc - varchar(6)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(6)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(5)
vis_thrd_tr - varchar(6)
vis_thrd_mc - varchar(7)
vis_oth_ind - varchar(5)
vis_oth - varchar(6)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(7)
vis_home - varchar(6)
vis_ref_op - varchar(7)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(11)
tot_cap_rev - varchar(9)
net_pt_rev - varchar(11)
oth_op_rev - varchar(10)
tot_op_exp - varchar(11)
net_frm_op - varchar(10)
nonop_rev - varchar(9)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(1)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(11)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(10)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(10)
gr_ip_cnty - varchar(9)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(9)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(11)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(10)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(10)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(11)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(10)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(10)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(9)
ded_oth - varchar(9)
cap_rev_mcar - varchar(9)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(1)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(9)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(8)
netrv_oth - varchar(9)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(9)
inc_invest - varchar(9)
dist_rev - varchar(8)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(10)
exp_anc - varchar(10)
exp_pip - varchar(9)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(9)
exp_unassg - varchar(11)
exp_sal - varchar(10)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(10)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(11)
cur_asst - varchar(11)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(10)
inv_oth - varchar(10)
intan_asst - varchar(10)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(11)
liab_eq - varchar(11)
cash - varchar(10)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs - varchar(11)
equipment - varchar(10)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(9)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(9)
inter_rec - varchar(11)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(6)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(7)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(7)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(7)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(7)

2022_cy_hospital_annual_selected_file_october_2024_extract

fac_no - varchar(9)
fac_name - varchar(70)
beg_date - varchar(19)
end_date - varchar(19)
day_per - varchar(3)
data_ind - varchar(7)
audit_ind - varchar(21)
county - varchar(15)
hsa - varchar(2)
hfpa - varchar(4)
type_cntrl - varchar(11)
type_care - varchar(11)
type_hosp - varchar(20)
teach_rurl - varchar(8)
phone - varchar(12)
address - varchar(31)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(28)
ceo_title - varchar(20)
web_site - varchar(72)
owner - varchar(61)
rpt_prep - varchar(30)
org_name - varchar(65)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(10)
reg_mcalnum - varchar(10)
bed_lic - varchar(4)
bed_avl - varchar(4)
bed_stf - varchar(4)
day_mcar_tr - varchar(6)
day_mcar_mc - varchar(5)
day_mcal_tr - varchar(6)
day_mcal_mc - varchar(5)
day_cnty - varchar(5)
day_thrd_tr - varchar(6)
day_thrd_mc - varchar(5)
day_oth_ind - varchar(5)
day_oth - varchar(6)
day_tot - varchar(6)
dis_mcar_tr - varchar(5)
dis_mcar_mc - varchar(5)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(5)
dis_cnty - varchar(4)
dis_thrd_tr - varchar(4)
dis_thrd_mc - varchar(5)
dis_oth_ind - varchar(4)
dis_oth - varchar(4)
dis_tot - varchar(5)
bed_acute - varchar(3)
bed_psych - varchar(4)
bed_chem - varchar(3)
bed_rehab - varchar(3)
bed_ltc - varchar(4)
bed_resdnt - varchar(3)
day_acute - varchar(6)
day_psych - varchar(6)
day_chem - varchar(5)
day_rehab - varchar(5)
day_ltc - varchar(6)
day_resdnt - varchar(5)
dis_acute - varchar(5)
dis_psych - varchar(4)
dis_chem - varchar(4)
dis_rehab - varchar(4)
dis_ltc - varchar(4)
dis_resdnt - varchar(3)
occ_lic - varchar(5)
occ_avl - varchar(5)
alos_all - varchar(6)
alos_exltc - varchar(6)
bas_nursry - varchar(2)
day_nursry - varchar(5)
dis_nursry - varchar(4)
vis_mcar_tr - varchar(6)
vis_mcar_mc - varchar(6)
vis_mcal_tr - varchar(6)
vis_mcal_mc - varchar(6)
vis_cnty - varchar(6)
vis_thrd_tr - varchar(6)
vis_thrd_mc - varchar(7)
vis_oth_ind - varchar(5)
vis_oth - varchar(5)
vis_tot - varchar(7)
vis_er - varchar(6)
vis_clin - varchar(7)
vis_home - varchar(6)
vis_ref_op - varchar(7)
days_pips - varchar(5)
op_room - varchar(2)
op_min_ip - varchar(7)
op_min_op - varchar(7)
surg_ip - varchar(5)
surg_op - varchar(5)
nat_births - varchar(4)
c_sections - varchar(4)
gr_pt_rev - varchar(11)
ded_fr_rev - varchar(11)
tot_cap_rev - varchar(9)
net_pt_rev - varchar(11)
oth_op_rev - varchar(10)
tot_op_exp - varchar(11)
net_frm_op - varchar(10)
nonop_rev - varchar(10)
nonop_exp - varchar(9)
inc_tax - varchar(8)
ext_item - varchar(1)
net_income - varchar(10)
gr_rev_dly - varchar(10)
gr_rev_amb - varchar(10)
gr_rev_anc - varchar(11)
gr_ip_mcar_tr - varchar(10)
gr_ip_mcar_mc - varchar(10)
gr_ip_mcal_tr - varchar(10)
gr_ip_mcal_mc - varchar(10)
gr_ip_cnty - varchar(9)
gr_ip_thrd_tr - varchar(9)
gr_ip_thrd_mc - varchar(10)
gr_ip_oth_ind - varchar(9)
gr_ip_oth - varchar(9)
gr_ip_tot - varchar(11)
gr_op_mcar_tr - varchar(10)
gr_op_mcar_mc - varchar(10)
gr_op_mcal_tr - varchar(9)
gr_op_mcal_mc - varchar(10)
gr_op_cnty - varchar(9)
gr_op_thrd_tr - varchar(9)
gr_op_thrd_mc - varchar(10)
gr_op_oth_ind - varchar(9)
gr_op_oth - varchar(9)
gr_op_tot - varchar(11)
c_adj_mcar_tr - varchar(10)
c_adj_mcar_mc - varchar(11)
c_adj_mcal_tr - varchar(10)
c_adj_mcal_mc - varchar(10)
disp_855 - varchar(10)
c_adj_cnty - varchar(9)
c_adj_thrd_tr - varchar(9)
c_adj_thrd_mc - varchar(11)
bad_debt - varchar(9)
char_hb - varchar(1)
char_oth - varchar(9)
sub_indgnt - varchar(9)
ded_oth - varchar(10)
cap_rev_mcar - varchar(9)
cap_rev_mcal - varchar(9)
cap_rev_cnty - varchar(1)
cap_rev_thrd - varchar(9)
netrv_mcar_tr - varchar(9)
netrv_mcar_mc - varchar(9)
netrv_mcal_tr - varchar(9)
netrv_mcal_mc - varchar(9)
netrv_cnty - varchar(9)
netrv_thrd_tr - varchar(9)
netrv_thrd_mc - varchar(10)
netrv_oth_ind - varchar(8)
netrv_oth - varchar(8)
disp_trnfr - varchar(9)
inter_tfr - varchar(10)
contribtns - varchar(8)
inc_invest - varchar(10)
dist_rev - varchar(9)
cnty_appro - varchar(9)
exp_dly - varchar(9)
exp_amb - varchar(10)
exp_anc - varchar(10)
exp_pip - varchar(9)
exp_pop - varchar(8)
exp_res - varchar(9)
exp_ed - varchar(9)
exp_gen - varchar(9)
exp_fisc - varchar(9)
exp_adm - varchar(9)
exp_unassg - varchar(9)
exp_sal - varchar(10)
exp_ben - varchar(9)
exp_phys - varchar(9)
exp_othpro - varchar(9)
exp_supp - varchar(9)
exp_purch - varchar(10)
exp_depre - varchar(9)
exp_leases - varchar(8)
exp_insur - varchar(8)
exp_intrst - varchar(8)
exp_oth - varchar(9)
cur_asst - varchar(11)
asst_limtd - varchar(10)
net_ppe - varchar(10)
const_prog - varchar(10)
inv_oth - varchar(10)
intan_asst - varchar(10)
tot_asst - varchar(11)
cur_liab - varchar(10)
def_cred - varchar(10)
net_ltdebt - varchar(10)
equity - varchar(11)
liab_eq - varchar(11)
cash - varchar(10)
accts_rec - varchar(10)
allow_uncoll - varchar(11)
bldgs - varchar(11)
equipment - varchar(10)
tot_ppe - varchar(11)
acc_depre - varchar(10)
mort_pay - varchar(9)
cap_lease - varchar(9)
bond_pay - varchar(10)
tot_ltdebt - varchar(10)
cur_mat - varchar(9)
inter_rec - varchar(11)
inter_pay - varchar(10)
hosp_fte - varchar(5)
nurs_fte - varchar(4)
prod_hrs - varchar(8)
non_prd_hr - varchar(7)
paid_hrs - varchar(8)
med_staff - varchar(5)
stdnt_fte - varchar(3)
prd_hr_mgt - varchar(7)
prd_hr_tch - varchar(7)
prd_hr_rn - varchar(7)
prd_hr_lvn - varchar(6)
prd_hr_aid - varchar(7)
prd_hr_clr - varchar(7)
prd_hr_env - varchar(7)
prd_hr_oth - varchar(7)
cnt_hr_rn - varchar(6)
cnt_hr_oth - varchar(7)
prd_hr_dly - varchar(7)
prd_hr_amb - varchar(7)
prd_hr_anc - varchar(7)
prd_hr_ed - varchar(7)
prd_hr_gen - varchar(7)
prd_hr_fis - varchar(7)
prd_hr_adm - varchar(7)
prd_hr_non - varchar(7)
pd_hr_dly - varchar(7)
pd_hr_amb - varchar(7)
pd_hr_anc - varchar(7)
pd_hr_ed - varchar(7)
pd_hr_gen - varchar(7)
pd_hr_fis - varchar(7)
pd_hr_adm - varchar(7)
pd_hr_non - varchar(7)

Sources

2012-2016-hospital-trends-charts.pdf	-	None
2012-2016-hospital-trends-pivot.xls	-	None
2012-pivot-table-hospital-annual-selected-file.xls	-	None
2013-2017-hospital-trends-charts-october-2019-extract.pdf	-	None
2013-2017-hospital-trends-pivot-october-2019-extract.xls	-	None
2014-2018-hospital-trends-charts-may-2021-extract.pdf	-	None
2014-2018-hospital-trends-pivot-may-2021-extract.xls	-	None
2015-2019-hospital-trends-charts-april-2022-extract.pdf	-	None
2015-2019-hospital-trends-pivot-april-2022-extract.xls	-	None
2016-2017-fy-hospital-annual-selected-file-april-2019-extract.xls	-	None
2017-pivot-table-hospital-annual-selected-file-october-2019-extract.xls	-	None
2018-pivot-table-hospital-annual-selected-file-november-2020-extract.xls	-	None
2019-pivot-table-hospital-annual-selected-file-april-2022-extract.xls	-	None
2020-pivot-table-hospital-annual-selected-file-october-2022-extract.xls	-	None
2021-pivot-table-hospital-annual-selected-file-april-2023-extract.xls	-	None
2021-pivot-table-hospital-annual-selected-file-october-2023-extract.xls	-	None
2022-pivot-table-hospital-annual-selected-file-april-2024-extract.xls	-	None
data-importing-instructions-for-excel.doc	-	None
hospital-annual-selected-file-documentation.pdf	-	None
hospital-trends-glossary.pdf	-	None
pre-2012-hospital-annual-financial-data-selected-data-pivot-tables.html	-	None
datapackage.json	-	None
2012-2013-fy-hospital-annual-selected-file-june-2014-extract.xlsx	-	2012_2013_fy_hospital_annual_selected_file_june_2014_extract
2012-2017-cy-hospital-annual-selected-file-machine-readable-format.csv	-	2012_2017_cy_hospital_annual_selected_file_machine_read_ee501c9c
2012-cy-hospital-annual-selected-file-october-2014-extract.xlsx	-	2012_cy_hospital_annual_selected_file_october_2014_extract
2013-2014-fy-hospital-annual-selected-file-september-2015-extract.xlsx	-	2013_2014_fy_hospital_annual_selected_file_sept_2015_extract
2013-cy-hospital-annual-selected-file-september-2014-extract.xlsx	-	2013_cy_hospital_annual_selected_file_september_2014_extract
2013-pivot-table-hospital-annual-selected-file.xlsx	-	2013_pivot_table_hospital_annual_selected_file
2014-2015-fy-hospital-annual-selected-file-april-2017-extract.xlsx	-	2014_2015_fy_hospital_annual_selected_file_april_2017_extract
2014-cy-hospital-annual-selected-file-april-2017-extract.xlsx	-	2014_cy_hospital_annual_selected_file_april_2017_extract
2014-pivot-table-hospital-annual-selected-file.xlsx	-	2014_pivot_table_hospital_annual_selected_file
2015-2016-fy-hospital-annual-selected-file-september-2018-extract.xlsx	-	2015_2016_fy_hospital_annual_selected_file_sept_2018_extract
2015-cy-hospital-annual-selected-file-march-2018-extract.xlsx	-	2015_cy_hospital_annual_selected_file_march_2018_extract
2015-pivot-table-hospital-annual-selected-file.xlsx	-	2015_pivot_table_hospital_annual_selected_file
2016-cy-hospital-annual-selected-file-september-2018-extract.xlsx	-	2016_cy_hospital_annual_selected_file_september_2018_extract
2016-pivot-table-hospital-annual-selected-file-september-2018-extract.xlsx	-	2016_pivot_table_hospital_annual_selected_file_sept_2018_extract
2017-2018-fy-hospital-annual-selected-file-april-2020-extract.xlsx	-	2017_2018_fy_hospital_annual_selected_file_april_2020_extract
2017-cy-hospital-annual-selected-file-october-2019-extract.xlsx	-	2017_cy_hospital_annual_selected_file_october_2019_extract
2018-2019-fy-hospital-annual-selected-file-may-2021-extract.xlsx	-	2018_2019_fy_hospital_annual_selected_file_may_2021_extract
2018-cy-hospital-annual-selected-file-november-2020-extract.xlsx	-	2018_cy_hospital_annual_selected_file_november_2020_extract
2019-2020-fy-hospital-annual-selected-file-april-2022-extract.xlsx	-	2019_2020_fy_hospital_annual_selected_file_april_2022_extract
2019-cy-hospital-annual-selected-file-april-2022-extract.xlsx	-	2019_cy_hospital_annual_selected_file_april_2022_extract
2020-2021-fy-hospital-annual-selected-file-october-2022-extract.xlsx	-	2020_2021_fy_hospital_annual_selected_file_october_2022_extract
2020-cy-hospital-annual-selected-file-october-2022-extract.xlsx	-	2020_cy_hospital_annual_selected_file_october_2022_extract
2021-cy-hospital-annual-selected-file-october-2023-extract.xlsx	-	2021_cy_hospital_annual_selected_file_october_2023_extract
2022-cy-hospital-annual-selected-file-october-2024-extract.xlsx	-	2022_cy_hospital_annual_selected_file_october_2024_extract

Updates

2025-07-11 17:47:01		None
2025-06-06 12:04:09		0
2025-02-06 21:20:24		0
2025-02-06 21:17:42		0
2025-02-06 21:08:26		0
2025-01-17 17:29:31		1
2025-01-17 17:29:30		0
2025-01-17 17:27:27		1
2025-01-17 17:27:26		0
2025-01-17 17:25:55		1
2025-01-17 17:25:51		0
2025-01-17 17:23:53		1
2025-01-17 17:23:47		0
2025-01-17 17:09:31		1
2025-01-17 17:09:23		0
2025-01-17 17:06:41		1
2025-01-17 17:06:30		0
2025-01-17 17:05:19		1
2025-01-17 17:05:07		0
2025-01-17 17:03:15		1
2025-01-17 17:03:00		0
2025-01-17 17:00:34		1
2025-01-17 17:00:17		0
2025-01-17 16:59:02		1
2025-01-17 16:58:43		0
2025-01-17 16:57:15		1
2025-01-17 16:56:53		0
2025-01-17 16:55:47		1
2025-01-17 16:55:23		0
2025-01-17 16:54:14		1
2025-01-17 16:53:47		0
2025-01-17 16:52:36		1
2025-01-17 16:52:07		0
2025-01-17 16:51:09		1
2025-01-17 16:50:34		1
2025-01-17 16:50:03		0
2025-01-17 16:49:10		1
2025-01-17 16:49:09		1
2025-01-17 16:48:34		1
2025-01-17 16:48:01		0
2025-01-17 16:47:05		1
2025-01-17 16:47:04		1
2025-01-17 16:21:10		1
2025-01-17 16:20:48		0
2025-01-17 15:20:02		1
2025-01-17 15:19:42		0
2025-01-17 14:52:13		1
2025-01-17 14:51:53		0
2025-01-16 17:49:02		1
2025-01-16 17:48:30		0
2025-01-16 17:35:59		1
2025-01-16 17:35:26		0
2024-12-28 18:30:11		0
2024-12-28 18:14:16		1
2024-12-28 18:09:23		0
2024-12-28 18:07:19		1
2024-12-28 17:56:10		1
2024-12-28 17:52:20		1
2024-12-28 17:51:08		1
2024-12-28 17:49:36		1
2024-12-28 17:49:06		1
2024-12-28 17:39:24		0
2024-12-28 16:48:19		0
2024-12-28 16:42:05		143
2024-12-04 16:25:50		None
2024-09-18 13:02:34		None