Home

Dataset:

Name pre-2012-hospital-quarterly-financial-utilization-report-sum-of-four-quarters
Updated 2024-08-29
CA Dataset link
Current True
Tables
1995_quarter_4_sum_of_four_quarters     fac_no_ - varchar(9)
year - int
qtr - varchar(3)
fac_name - varchar(40)
city - varchar(20)
hsa - varchar(3)
hfpa - varchar(4)
peer - varchar(4)
toc - varchar(3)
bg_date - varchar(9)
ed_date - varchar(9)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcal - varchar(8)
dis_cnty - varchar(8)
dis_thrd - varchar(8)
dis91oth - varchar(8)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcal - varchar(8)
day_cnty - varchar(8)
day_thrd - varchar(8)
day91oth - varchar(8)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcal - varchar(8)
vis_cnty - varchar(8)
vis_thrd - varchar(8)
vis91oth - varchar(8)
vis_oth - varchar(7)
vis_tot - varchar(7)
tot_exp - varchar(10)
inp_exp - varchar(10)
out_exp - varchar(9)
phy_comp - varchar(8)
gri_mcar - varchar(9)
gri_mcal - varchar(9)
gri_cnty - varchar(9)
gri_thrd - varchar(9)
gri_oth - varchar(9)
gri_tot - varchar(10)
gro_mcar - varchar(8)
gro_mcal - varchar(9)
gro_cnty - varchar(9)
gro_thrd - varchar(9)
gro_oth - varchar(9)
gro_tot - varchar(9)
ded_mcar - varchar(9)
ded_mcal - varchar(9)
ded_disp - varchar(10)
ded_cnty - varchar(9)
ded_thrd - varchar(9)
ded_bd - varchar(8)
ded_hb - varchar(7)
ded_91ch - varchar(8)
ded_char - varchar(8)
ded_gift - varchar(8)
ded_rest - varchar(8)
ded_tch - varchar(7)
ded_clin - varchar(8)
ded91oth - varchar(8)
ded_oth - varchar(9)
ded_tot - varchar(10)
net_mcar - varchar(9)
net_mcal - varchar(9)
net_cnty - varchar(8)
net_thrd - varchar(9)
net91oth - varchar(8)
net_oth - varchar(9)
net_tot - varchar(9)
othoprev - varchar(8)
nonoprex - varchar(9)
capital - varchar(9)
assets - varchar(9)
disp_tfr - varchar(9)
puripdis - varchar(8)
puripday - varchar(8)
puripexp - varchar(8)
puriprev - varchar(8)
1996_quarter_4_sum_of_four_quarters     fac_no_ - varchar(9)
year - int
qtr - varchar(3)
fac_name - varchar(40)
city - varchar(20)
hsa - varchar(3)
hfpa - varchar(4)
toc - varchar(3)
bg_date - varchar(7)
ed_date - varchar(9)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcal - varchar(8)
dis_cnty - varchar(8)
dis_thrd - varchar(8)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcal - varchar(8)
day_cnty - varchar(8)
day_thrd - varchar(8)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcal - varchar(8)
vis_cnty - varchar(8)
vis_thrd - varchar(8)
vis_oth - varchar(7)
vis_tot - varchar(7)
tot_exp - varchar(11)
inp_exp - varchar(11)
out_exp - varchar(11)
phy_comp - varchar(8)
gri_mcar - varchar(11)
gri_mcal - varchar(11)
gri_cnty - varchar(11)
gri_thrd - varchar(11)
gri_oth - varchar(11)
gri_tot - varchar(11)
gro_mcar - varchar(8)
gro_mcal - varchar(8)
gro_cnty - varchar(11)
gro_thrd - varchar(11)
gro_oth - varchar(11)
gro_tot - varchar(11)
ded_mcar - varchar(11)
ded_mcal - varchar(11)
ded_disp - varchar(11)
ded_cnty - varchar(11)
ded_thrd - varchar(11)
ded_bd - varchar(11)
ded_hb - varchar(11)
ded_char - varchar(8)
ded_rest - varchar(8)
ded_tch - varchar(11)
ded_clin - varchar(11)
ded_oth - varchar(11)
ded_tot - varchar(11)
net_mcar - varchar(11)
net_mcal - varchar(11)
net_cnty - varchar(8)
net_thrd - varchar(11)
net_oth - varchar(11)
net_tot - varchar(11)
othoprev - varchar(8)
nonoprex - varchar(11)
capital - varchar(11)
assets - varchar(11)
disp_tfr - varchar(11)
puripdis - varchar(8)
puripday - varchar(8)
puripexp - varchar(8)
puriprev - varchar(8)
1997_quarter_4_sum_of_four_quarters     fac_no_ - varchar(9)
year - int
qtr - varchar(3)
fac_name - varchar(40)
city - varchar(20)
hsa - varchar(3)
hfpa - varchar(4)
toc - varchar(3)
bg_date - varchar(7)
ed_date - varchar(9)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcal - varchar(8)
dis_cnty - varchar(8)
dis_thrd - varchar(8)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcal - varchar(8)
day_cnty - varchar(8)
day_thrd - varchar(8)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcal - varchar(8)
vis_cnty - varchar(8)
vis_thrd - varchar(8)
vis_oth - varchar(7)
vis_tot - varchar(7)
tot_exp - varchar(11)
inp_exp - varchar(11)
out_exp - varchar(11)
phy_comp - varchar(8)
gri_mcar - varchar(11)
gri_mcal - varchar(11)
gri_cnty - varchar(11)
gri_thrd - varchar(11)
gri_oth - varchar(11)
gri_tot - varchar(11)
gro_mcar - varchar(8)
gro_mcal - varchar(8)
gro_cnty - varchar(11)
gro_thrd - varchar(11)
gro_oth - varchar(11)
gro_tot - varchar(11)
ded_mcar - varchar(11)
ded_mcal - varchar(11)
ded_disp - varchar(11)
ded_cnty - varchar(11)
ded_thrd - varchar(11)
ded_bd - varchar(11)
ded_hb - varchar(11)
ded_char - varchar(8)
ded_rest - varchar(8)
ded_tch - varchar(11)
ded_clin - varchar(11)
ded_cap - varchar(11)
ded_oth - varchar(11)
ded_tot - varchar(11)
net_mcar - varchar(11)
net_mcal - varchar(11)
net_cnty - varchar(8)
net_thrd - varchar(11)
net_oth - varchar(11)
net_tot - varchar(11)
othoprev - varchar(8)
nonoprex - varchar(11)
capital - varchar(11)
assets - varchar(11)
disp_tfr - varchar(11)
puripdis - varchar(8)
puripday - varchar(8)
puripexp - varchar(8)
puriprev - varchar(8)
1998_quarter_4_sum_of_four_quarters     fac_no_ - varchar(9)
year - int
qtr - varchar(3)
fac_name - varchar(40)
city - varchar(20)
hsa - varchar(3)
hfpa - varchar(4)
toc - varchar(3)
bg_date - varchar(8)
ed_date - varchar(11)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcal - varchar(8)
dis_cnty - varchar(8)
dis_thrd - varchar(8)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcal - varchar(8)
day_cnty - varchar(8)
day_thrd - varchar(8)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcal - varchar(8)
vis_cnty - varchar(8)
vis_thrd - varchar(8)
vis_oth - varchar(7)
vis_tot - varchar(7)
tot_exp - varchar(11)
inp_exp - varchar(11)
out_exp - varchar(11)
phy_comp - varchar(8)
gri_mcar - varchar(11)
gri_mcal - varchar(11)
gri_cnty - varchar(11)
gri_thrd - varchar(11)
gri_oth - varchar(11)
gri_tot - varchar(11)
gro_mcar - varchar(8)
gro_mcal - varchar(8)
gro_cnty - varchar(11)
gro_thrd - varchar(11)
gro_oth - varchar(11)
gro_tot - varchar(11)
ded_mcar - varchar(11)
ded_mcal - varchar(11)
ded_disp - varchar(11)
ded_cnty - varchar(11)
ded_thrd - varchar(11)
ded_bd - varchar(11)
ded_hb - varchar(11)
ded_char - varchar(8)
ded_rest - varchar(8)
ded_tch - varchar(11)
ded_clin - varchar(11)
ded_cap - varchar(11)
ded_oth - varchar(11)
ded_tot - varchar(11)
net_mcar - varchar(11)
net_mcal - varchar(11)
net_cnty - varchar(8)
net_thrd - varchar(11)
net_oth - varchar(11)
net_tot - varchar(11)
othoprev - varchar(11)
nonoprex - varchar(11)
capital - varchar(11)
assets - varchar(11)
disp_tfr - varchar(11)
puripdis - varchar(8)
puripday - varchar(8)
puripexp - varchar(8)
puriprev - varchar(8)
1999_quarter_4_sum_of_four_quarters     fac_no_ - varchar(9)
year - int
qtr - varchar(3)
fac_name - varchar(40)
city - varchar(20)
hsa - varchar(3)
hfpa - varchar(4)
toc - varchar(3)
bg_date - varchar(8)
ed_date - varchar(11)
lic_beds - varchar(8)
avl_beds - varchar(8)
stf_beds - varchar(8)
dis_mcar - varchar(8)
dis_mcal - varchar(8)
dis_cnty - varchar(8)
dis_thrd - varchar(8)
dis_oth - varchar(7)
dis_tot - varchar(7)
dis_ltc - varchar(7)
day_mcar - varchar(8)
day_mcal - varchar(8)
day_cnty - varchar(8)
day_thrd - varchar(8)
day_oth - varchar(7)
day_tot - varchar(7)
day_ltc - varchar(7)
vis_mcar - varchar(8)
vis_mcal - varchar(8)
vis_cnty - varchar(8)
vis_thrd - varchar(8)
vis_oth - varchar(7)
vis_tot - varchar(7)
tot_exp - varchar(11)
inp_exp - varchar(11)
out_exp - varchar(11)
phy_comp - varchar(8)
gri_mcar - varchar(11)
gri_mcal - varchar(11)
gri_cnty - varchar(11)
gri_thrd - varchar(11)
gri_oth - varchar(11)
gri_tot - varchar(11)
gro_mcar - varchar(8)
gro_mcal - varchar(8)
gro_cnty - varchar(11)
gro_thrd - varchar(11)
gro_oth - varchar(11)
gro_tot - varchar(11)
ded_mcar - varchar(11)
ded_mcal - varchar(11)
ded_disp - varchar(11)
ded_cnty - varchar(11)
ded_thrd - varchar(11)
ded_bd - varchar(11)
ded_hb - varchar(11)
ded_char - varchar(8)
ded_rest - varchar(11)
ded_tch - varchar(11)
ded_clin - varchar(11)
ded_cap - varchar(11)
ded_oth - varchar(11)
ded_tot - varchar(11)
net_mcar - varchar(11)
net_mcal - varchar(11)
net_cnty - varchar(8)
net_thrd - varchar(11)
net_oth - varchar(11)
net_tot - varchar(11)
othoprev - varchar(8)
nonoprex - varchar(11)
capital - varchar(11)
assets - varchar(11)
disp_tfr - varchar(11)
puripdis - varchar(8)
puripday - varchar(8)
puripexp - varchar(8)
puriprev - varchar(8)
Sources
1995-documentation-sum-of-4-quarters.pdf - None
1996-documentation-sum-of-four-quarters.pdf - None
2000-quarter-4-sum-of-four-quarters-revised-may-2007.xls - None
2001-quarter-4-sum-of-four-quarters-revised-may-2007.xls - None
2002-quarter-4-sum-of-four-quarters-revised-may-2007.xls - None
2003-quarter-4-sum-of-four-quarters-revised-may-2007.xls - None
2004-quarter-1-sum-of-four-quarters.xls - None
2004-quarter-2-sum-of-four-quarters.xls - None
2004-quarter-3-sum-of-four-quarters.xls - None
2004-quarter-4-sum-of-four-quarters-revised-may-2007.xls - None
2005-quarter-1-sum-of-four-quarters.xls - None
2005-quarter-2-sum-of-four-quarters.xls - None
2005-quarter-3-sum-of-four-quarters.xls - None
2005-quarter-4-sum-of-four-quarters-revised-april-2008.xls - None
2006-quarter-1-sum-of-four-quarters.xls - None
2006-quarter-2-sum-of-four-quarters.xls - None
2006-quarter-3-sum-of-four-quarters.xls - None
2006-quarter-4-sum-of-four-quarters-revised-may-2017.xls - None
2007-quarter-1-sum-of-four-quarters.xls - None
2007-quarter-2-sum-of-four-quarters.xls - None
2007-quarter-3-sum-of-four-quarters.xls - None
2007-quarter-4-sum-of-four-quarters-revised-may-2010.xls - None
2008-quarter-1-sum-of-four-quarters.xls - None
2008-quarter-2-sum-of-four-quarters.xls - None
2008-quarter-3-sum-of-four-quarters.xls - None
2008-quarter-4-sum-of-four-quarters-revised-april-2011.xls - None
2009-quarter-1-sum-of-four-quarters.xls - None
2009-quarter-2-sum-of-four-quarters.xls - None
2009-quarter-3-sum-of-four-quarters.xls - None
2009-quarter-4-sum-of-four-quarters-revised-april-2011.xls - None
2010-quarter-1-sum-of-four-quarters.xls - None
2010-quarter-2-sum-of-four-quarters.xls - None
2010-quarter-3-sum-of-four-quarters.xls - None
2010-quarter-4-sum-of-four-quarters-revised-october-2012.xls - None
2011-quarter-1-sum-of-four-quarters-this-is-really-one-the-other-is-q4.xls - None
2011-quarter-2-sum-of-four-quarters.xls - None
2011-quarter-3-sum-of-four-quarters.xls - None
2011-quarter-4-sum-of-four-quarters-revised-july-2015.xls - None
data-importing-instructions-for-excel.docx - None
post-2011-hospital-quarterly-financial-utilization-report-sum-of-four-quarters.html - None
datapackage.json - None
1995-quarter-4-sum-of-four-quarters.csv - 1995_quarter_4_sum_of_four_quarters
1996-quarter-4-sum-of-four-quarters.csv - 1996_quarter_4_sum_of_four_quarters
1997-quarter-4-sum-of-four-quarters.csv - 1997_quarter_4_sum_of_four_quarters
1998-quarter-4-sum-of-four-quarters.csv - 1998_quarter_4_sum_of_four_quarters
1999-quarter-4-sum-of-four-quarters.csv - 1999_quarter_4_sum_of_four_quarters
Updates
2025-07-11 17:52:13      None
2025-07-06 22:30:34      0
2025-06-06 12:05:25      0
2025-03-10 09:56:14      0
2025-02-03 22:30:32      0
2025-02-03 22:22:15      0
2025-02-03 18:51:33      0
2025-02-03 18:50:57      0
2025-02-03 18:49:33      0
2025-02-02 18:50:24      0
2024-12-27 18:58:51      0
2024-12-14 17:15:21      0
2024-12-04 16:49:17      None
2024-09-18 13:17:51      None