Home

Dataset:

Name pre-2012-hospital-annual-financial-data-selected-data-pivot-tables
Updated 2024-08-29
CA Dataset link
Current True
Tables
1995_cy_hospital_annual_selected_file    
1996_cy_hospital_annual_selected_file    
1997_cy_hospital_annual_selected_file    
1998_cy_hospital_annual_selected_file    
2009_2010_fy_hospital_annual_selected_file_september_2011_ext     fac_no - varchar(9)
fac_name - varchar(63)
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(11)
phone - varchar(14)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(28)
ceo_title - varchar(18)
web_site - varchar(62)
owner - varchar(57)
rpt_prep - varchar(28)
org_name - varchar(57)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(9)
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(5)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(5)
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)
2009_cy_hospital_annual_selected_file_september_2011_extract     fac_no - varchar(9)
fac_name - varchar(63)
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(11)
phone - varchar(14)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(28)
ceo_title - varchar(18)
web_site - varchar(41)
owner - varchar(57)
rpt_prep - varchar(28)
org_name - varchar(56)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(9)
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(5)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(5)
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)
2010_2011_fy_hospital_annual_selected_file_september_2012_ext     fac_no - varchar(9)
fac_name - varchar(63)
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(11)
phone - varchar(14)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(28)
ceo_title - varchar(20)
web_site - varchar(66)
owner - varchar(57)
rpt_prep - varchar(28)
org_name - varchar(59)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(9)
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(4)
dis_cnty - varchar(5)
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)
2011_2012_fy_hospital_annual_selected_file_october_2013_extract     fac_no - varchar(9)
fac_name - varchar(63)
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(14)
teach_rurl - varchar(8)
phone - varchar(14)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(27)
ceo_title - varchar(22)
web_site - varchar(38)
owner - varchar(59)
rpt_prep - varchar(27)
org_name - varchar(59)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(9)
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(5)
dis_mcal_tr - varchar(5)
dis_mcal_mc - varchar(4)
dis_cnty - varchar(5)
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)
2011_cy_hospital_annual_selected_file_october_2013_extract     fac_no - varchar(9)
fac_name - varchar(63)
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(14)
teach_rurl - varchar(8)
phone - varchar(14)
address - varchar(30)
city - varchar(19)
zip_code - varchar(10)
ceo - varchar(28)
ceo_title - varchar(22)
web_site - varchar(38)
owner - varchar(59)
rpt_prep - varchar(28)
org_name - varchar(59)
er_desig - varchar(1)
mcar_pronum - varchar(7)
mcal_pronum - varchar(9)
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(4)
dis_cnty - varchar(5)
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)
Sources
1995-1999-combined-cy-hospital-annual-selected-file.csv - None
1995-1999-documentation-hospital-annual-selected-file.pdf - None
1995-pivot-table-hospital-annual-selected-file.xls - None
1996-pivot-table-hospital-annual-selected-file.xls - None
1997-1999-documentation-hospital-annual-selected-file.pdf - None
1997-pivot-table-hospital-annual-selected-file.xls - None
1998-pivot-table-hospital-annual-selected-file.xls - None
1999-cy-hospital-annual-selected-file.csv - None
1999-pivot-table-hospital-annual-selected-file.xls - None
2000-and-after-cy-documentation.pdf - None
2000-cy-partial-6-30-00-12-31-00-hospital-annual-selected-file.csv - None
2000-cy-partial-7-1-99-6-29-00-hospital-annual-selected-file.csv - None
2000-pivot-table-hospital-annual-selected-file.xls - None
2001-2002-fy-hospital-annual-selected-file.xls - None
2001-cy-hospital-annual-selected-file-september-2004-extract.xls - None
2001-pivot-table-hospital-annual-selected-file.xls - None
2002-2003-fy-hospital-annual-selected-file-october-2004-extract.xls - None
2002-cy-hospital-annual-selected-file-october-2004-extract.xls - None
2002-pivot-table-hospital-annual-selected-file.xls - None
2003-cy-hospital-annual-selected-file-september-2005-extract.xls - None
2003-pivot-table-hospital-annual-selected-file.xls - None
2004-2005-fy-hospital-annual-selected-file-september-2006-extract.xls - None
2004-cy-hospital-annual-selected-file-september-2006-extract.xls - None
2004-pivot-table-hospital-annual-selected-file.xls - None
2005-2006-fy-hospital-annual-selected-file-september-2007-extract.xls - None
2005-cy-hospital-annual-selected-file-september-2007-extract.xls - None
2005-pivot-table-hospital-annual-selected-file.xls - None
2006-2007-fy-hospital-annual-selected-file-september-2008-extract.xls - None
2006-cy-hospital-annual-selected-file-september-2008-extract.xls - None
2006-pivot-table-hospital-annual-selected-file.xls - None
2007-2008-fy-hospital-annual-selected-file-september-2009-extract.xls - None
2007-cy-hospital-annual-selected-file-september-2009-extract.xls - None
2007-pivot-table-hospital-annual-selected-file.xls - None
2008-2009-fy-hospital-annual-selected-file-september-2010-extract.xls - None
2008-cy-hospital-annual-selected-file-september-2010-extract.xls - None
2008-pivot-table-hospital-annual-selected-file.xls - None
2009-pivot-table-hospital-annual-selected-file.xls - None
2010-cy-hospital-annual-selected-file-september-2012-extract.xls - None
2010-pivot-table-hospital-annual-selected-file.xls - None
2011-pivot-table-hospital-annual-selected-file.xls - None
data-importing-instructions-for-excel.docx - None
post-2011-hospital-annual-financial-data-selected-data-pivot-tables.html - None
2000-cy-partial-7-1-99-6-29-00-hospital-annual-selected-file.txt - None
2000-cy-partial-6-30-00-12-31-00-hospital-annual-selected-file.txt - None
1995-1999-combined-cy-hospital-annual-selected-file.txt - None
1999-cy-hospital-annual-selected-file.txt - None
1998-cy-hospital-annual-selected-file.txt - None
1997-cy-hospital-annual-selected-file.txt - None
1996-cy-hospital-annual-selected-file.txt - None
1995-cy-hospital-annual-selected-file.txt - None
datapackage.json - None
1995-cy-hospital-annual-selected-file.csv - 1995_cy_hospital_annual_selected_file
1996-cy-hospital-annual-selected-file.csv - 1996_cy_hospital_annual_selected_file
1997-cy-hospital-annual-selected-file.csv - 1997_cy_hospital_annual_selected_file
1998-cy-hospital-annual-selected-file.csv - 1998_cy_hospital_annual_selected_file
2009-2010-fy-hospital-annual-selected-file-september-2011-extract.xlsx - 2009_2010_fy_hospital_annual_selected_file_september_2011_ext
2009-cy-hospital-annual-selected-file-september-2011-extract.xlsx - 2009_cy_hospital_annual_selected_file_september_2011_extract
2010-2011-fy-hospital-annual-selected-file-september-2012-extract.xlsx - 2010_2011_fy_hospital_annual_selected_file_september_2012_ext
2011-2012-fy-hospital-annual-selected-file-october-2013-extract.xlsx - 2011_2012_fy_hospital_annual_selected_file_october_2013_extract
2011-cy-hospital-annual-selected-file-october-2013-extract.xlsx - 2011_cy_hospital_annual_selected_file_october_2013_extract
Updates
2025-08-01 12:46:55      0
2025-07-11 17:52:16      None
2025-06-06 11:38:32      0
2025-04-20 18:54:24      0
2025-02-03 22:32:06      0
2025-02-03 22:17:31      0
2025-02-03 19:59:51      0
2025-02-03 19:58:59      0
2025-02-03 19:57:30      0
2025-02-03 19:55:50      1
2025-02-03 19:52:33      1
2025-02-02 18:49:18      1
2025-01-30 11:33:54      1
2025-01-30 11:31:13      1
2025-01-30 11:29:56      1
2025-01-30 11:23:31      1
2025-01-30 11:18:10      0
2025-01-30 11:17:23      2
2025-01-30 11:15:40      0
2025-01-30 11:11:38      0
2025-01-30 10:49:11      1
2025-01-17 06:07:48      1
2025-01-17 06:07:39      1
2025-01-16 19:46:02      1
2025-01-16 19:45:54      1
2025-01-03 14:58:47      1
2025-01-01 15:35:49      1
2024-12-31 21:21:43      1
2024-12-31 15:43:25      1
2024-12-31 15:42:43      1
2024-12-20 23:47:55      1
2024-12-04 16:48:09      None
2024-09-18 13:15:45      None