Home

Dataset:

Name	pre-2012-hospital-annual-financial-data-selected-data-pivot-tables
Updated	2024-08-29
CA Dataset	link
Current	True
Tables	1995_1999_combined_cy_hospital_annual_selected_file     1995_cy_hospital_annual_selected_file     1996_cy_hospital_annual_selected_file     1997_cy_hospital_annual_selected_file     1998_cy_hospital_annual_selected_file     1999_cy_hospital_annual_selected_file     2000_cy_partial_6_30_00_12_31_00_hospital_annual_selected_file     2000_cy_partial_7_1_99_6_29_00_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-documentation-hospital-annual-selected-file.pdf  -    1995-pivot-table-hospital-annual-selected-file.xls  -    1996-pivot-table-hospital-annual-selected-file.xls  -    1997-1999-documentation-hospital-annual-selected-file.pdf  -    1997-pivot-table-hospital-annual-selected-file.xls  -    1998-pivot-table-hospital-annual-selected-file.xls  -    1999-pivot-table-hospital-annual-selected-file.xls  -    2000-and-after-cy-documentation.pdf  -    2000-pivot-table-hospital-annual-selected-file.xls  -    2001-2002-fy-hospital-annual-selected-file.xls  -    2001-cy-hospital-annual-selected-file-september-2004-extract.xls  -    2001-pivot-table-hospital-annual-selected-file.xls  -    2002-2003-fy-hospital-annual-selected-file-october-2004-extract.xls  -    2002-cy-hospital-annual-selected-file-october-2004-extract.xls  -    2002-pivot-table-hospital-annual-selected-file.xls  -    2003-cy-hospital-annual-selected-file-september-2005-extract.xls  -    2003-pivot-table-hospital-annual-selected-file.xls  -    2004-2005-fy-hospital-annual-selected-file-september-2006-extract.xls  -    2004-cy-hospital-annual-selected-file-september-2006-extract.xls  -    2004-pivot-table-hospital-annual-selected-file.xls  -    2005-2006-fy-hospital-annual-selected-file-september-2007-extract.xls  -    2005-cy-hospital-annual-selected-file-september-2007-extract.xls  -    2005-pivot-table-hospital-annual-selected-file.xls  -    2006-2007-fy-hospital-annual-selected-file-september-2008-extract.xls  -    2006-cy-hospital-annual-selected-file-september-2008-extract.xls  -    2006-pivot-table-hospital-annual-selected-file.xls  -    2007-2008-fy-hospital-annual-selected-file-september-2009-extract.xls  -    2007-cy-hospital-annual-selected-file-september-2009-extract.xls  -    2007-pivot-table-hospital-annual-selected-file.xls  -    2008-2009-fy-hospital-annual-selected-file-september-2010-extract.xls  -    2008-cy-hospital-annual-selected-file-september-2010-extract.xls  -    2008-pivot-table-hospital-annual-selected-file.xls  -    2009-pivot-table-hospital-annual-selected-file.xls  -    2010-cy-hospital-annual-selected-file-september-2012-extract.xls  -    2010-pivot-table-hospital-annual-selected-file.xls  -    2011-pivot-table-hospital-annual-selected-file.xls  -    data-importing-instructions-for-excel.docx  -    post-2011-hospital-annual-financial-data-selected-data-pivot-tables.html  -    2000-cy-partial-7-1-99-6-29-00-hospital-annual-selected-file.txt  -    2000-cy-partial-6-30-00-12-31-00-hospital-annual-selected-file.txt  -    1995-1999-combined-cy-hospital-annual-selected-file.txt  -    1999-cy-hospital-annual-selected-file.txt  -    1998-cy-hospital-annual-selected-file.txt  -    1997-cy-hospital-annual-selected-file.txt  -    1996-cy-hospital-annual-selected-file.txt  -    1995-cy-hospital-annual-selected-file.txt  -    datapackage.json  -    1995-1999-combined-cy-hospital-annual-selected-file.csv  -  Table: 1995_1999_combined_cy_hospital_annual_selected_file   Fails: 2 1995-cy-hospital-annual-selected-file.csv  -  Table: 1995_cy_hospital_annual_selected_file   Fails: 13 1996-cy-hospital-annual-selected-file.csv  -  Table: 1996_cy_hospital_annual_selected_file   Fails: 13 1997-cy-hospital-annual-selected-file.csv  -  Table: 1997_cy_hospital_annual_selected_file   Fails: 13 1998-cy-hospital-annual-selected-file.csv  -  Table: 1998_cy_hospital_annual_selected_file   Fails: 13 1999-cy-hospital-annual-selected-file.csv  -  Table: 1999_cy_hospital_annual_selected_file   Fails: 2 2000-cy-partial-6-30-00-12-31-00-hospital-annual-selected-file.csv  -  Table: 2000_cy_partial_6_30_00_12_31_00_hospital_annual_selected_file   Fails: 2 2000-cy-partial-7-1-99-6-29-00-hospital-annual-selected-file.csv  -  Table: 2000_cy_partial_7_1_99_6_29_00_hospital_annual_selected_file   Fails: 2 2009-2010-fy-hospital-annual-selected-file-september-2011-extract.xlsx  -  Table: 2009_2010_fy_hospital_annual_selected_file_september_2011_ext   Updated: 2025-10-13 2009-cy-hospital-annual-selected-file-september-2011-extract.xlsx  -  Table: 2009_cy_hospital_annual_selected_file_september_2011_extract   Updated: 2025-10-13 2010-2011-fy-hospital-annual-selected-file-september-2012-extract.xlsx  -  Table: 2010_2011_fy_hospital_annual_selected_file_september_2012_ext   Updated: 2025-10-13 2011-2012-fy-hospital-annual-selected-file-october-2013-extract.xlsx  -  Table: 2011_2012_fy_hospital_annual_selected_file_october_2013_extract   Updated: 2025-10-13 2011-cy-hospital-annual-selected-file-october-2013-extract.xlsx  -  Table: 2011_cy_hospital_annual_selected_file_october_2013_extract   Updated: 2025-10-13
Updated