Description
On an annual basis (individual hospital fiscal year), individual hospitals and hospital systems report detailed facility-level data on services capacity, inpatient/outpatient utilization, patients, revenues and expenses by type and payer, balance sheet and income statement.
Due to the large size of the complete dataset, a selected set of data representing a wide range of commonly used data items, has been created that can be easily managed and downloaded. The selected data file includes general hospital information, utilization data by payer, revenue data by payer, expense data by natural expense category, financial ratios, and labor information.
There are two groups of data contained in this dataset:
1) Selected Data - Calendar Year: To make it easier to compare hospitals by year, hospital reports with report periods ending within a given calendar year are grouped together. The Pivot Tables for a specific calendar year are also found here.
2) Selected Data - Fiscal Year: Hospital reports with report periods ending within a given fiscal year (July-June) are grouped together.
Resources
| Name | Format | Description | Link |
|---|---|---|---|
| 1995 CY Hospital Annual Selected File | Text | cy-selected-file-hafd1995.txt | Open resource |
| 2008 CY Hospital Annual Selected File (September 2010 Extract) | XLS | cy-selected-file-hafd123108revised9-10.xls | Open resource |
| 2004 Pivot Table Hospital Annual Selected File | XLS | hafd2004pivot.xls | Open resource |
| 2006 CY Hospital Annual Selected File (September 2008 Extract) | XLS | cy-selected-file-hafd-12-31-06revised-9-08.xls | Open resource |
| 2001 CY Hospital Annual Selected File (September 2004 Extract) | XLS | cy-selected-file-hafd2001revised-904.xls | Open resource |
| 2011 Pivot Table Hospital Annual Selected File | XLS | hafd2011pivot.xls | Open resource |
| 2002 CY Hospital Annual Selected File (October 2004 Extract) | XLS | cy-selected-file-hafd123102rev1004.xls | Open resource |
| 2006 Pivot Table Hospital Annual Selected File | XLS | hafd2006pivot.xls | Open resource |
| 2009 CY Hospital Annual Selected File (September 2011 Extract) | XLS | cy-selected-file-hafd09-revised911.xlsx | Open resource |
| 1997 CY Hospital Annual Selected File | Text | cy-selected-file-hafd1997.txt | Open resource |
| 2000 Pivot Table Hospital Annual Selected File | XLS | hafd2000pivot.xls | Open resource |
| 2008 - 2009 FY Hospital Annual Selected File (September 2010 Extract) | XLS | fy-selected-file-hafd0809-revised-910.xls | Open resource |
| Data Importing Instructions for Excel | Doc | data-importing-instructions-for-excel.docx | Open resource |
| 2007 CY Hospital Annual Selected File (September 2009 Extract) | XLS | cy-selected-file-hafd123107revised909.xls | Open resource |
| 2007 - 2008 FY Hospital Annual Selected File (September 2009 Extract) | XLS | fy-selected-file-hafd0708-revised-909.xls | Open resource |
| 2000 CY Partial (6/30/00 - 12/31/00) Hospital Annual Selected File | Text | cy-selected-file-hafd-630-12312000-partial-year.txt | Open resource |
| 2004 CY Hospital Annual Selected File (September 2006 Extract) | XLS | cy-selected-file-hafd2004revised906.xls | Open resource |
| 2000 CY Partial (7/1/99 - 6/29/00) Hospital Annual Selected File | Text | cy-selected-file-hafd-7199-062900-partial-year.txt | Open resource |
| 1995 - 1999 Documentation Hospital Annual Selected File | cy-selected-file-hafd9599doc-use-this-one.pdf | Open resource | |
| 1997 - 1999 Documentation Hospital Annual Selected File | cy-selected-file-hafd1299.pdf | Open resource | |
| 1999 Pivot Table Hospital Annual Selected File | XLS | hafd1999pivot.xls | Open resource |
| 2005 - 2006 FY Hospital Annual Selected File (September 2007 Extract) | XLS | fy-selected-file-hafd0506-revised-907.xls | Open resource |
| 2005 CY Hospital Annual Selected File (September 2007 Extract) | XLS | cy-selected-file-hafd12-31-05revised9-07.xls | Open resource |
| 1997 Pivot Table Hospital Annual Selected File | XLS | hafd1997pivot.xls | Open resource |
| 1999 CY Hospital Annual Selected File | Text | cy-selected-file-hafd1299.txt | Open resource |
| 2007 Pivot Table Hospital Annual Selected File | XLS | hafd2007pivot.xls | Open resource |
| 2002 - 2003 FY Hospital Annual Selected File (October 2004 Extract) | XLS | fy-selected-file-hafd0203-revised-1004.xls | Open resource |
| 2003 Pivot Table Hospital Annual Selected File | XLS | hafd2003pivot.xls | Open resource |
| 2006 - 2007 FY Hospital Annual Selected File (September 2008 Extract) | XLS | fy-selected-file-hafd0607-revised-908.xls | Open resource |
| 2011 - 2012 FY Hospital Annual Selected File (October 2013 Extract) | XLS | fy-selected-file-hafd1112-revised-1013.xlsx | Open resource |
| 2002 Pivot Table Hospital Annual Selected File | XLS | hafd2002pivot.xls | Open resource |
| 2001 Pivot Table Hospital Annual Selected File | XLS | hafd2001pivot.xls | Open resource |
| 2005 Pivot Table Hospital Annual Selected File | XLS | hafd2005pivot.xls | Open resource |
| 2009 - 2010 FY Hospital Annual Selected File (September 2011 Extract) | XLS | fy-selected-file-hafd0910-revised-911.xlsx | Open resource |
| 2010 CY Hospital Annual Selected File (September 2012 Extract) | XLS | cy-selected-file-hafd10revised912.xls | Open resource |
| 2010 - 2011 FY Hospital Annual Selected File (September 2012 Extract) | XLS | fy-selected-file-hafd1011-revised-912.xlsx | Open resource |
| 2003 CY Hospital Annual Selected File (September 2005 Extract) | XLS | cy-selected-file-hafd123103revised-905.xls | Open resource |
| 2001 - 2002 FY Hospital Annual Selected File | XLS | fy-selected-file-hafd0102.xls | Open resource |
| 2008 Pivot Table Hospital Annual Selected File | XLS | hafd2008pivot.xls | Open resource |
| 1996 CY Hospital Annual Selected File | Text | cy-selected-file-hafd1996.txt | Open resource |
| 1998 Pivot Table Hospital Annual Selected File | XLS | hafd1998pivot.xls | Open resource |
| 2004 - 2005 FY Hospital Annual Selected File (September 2006 Extract) | XLS | fy-selected-file-hafd0405-revised-906.xls | Open resource |
| 1996 Pivot Table Hospital Annual Selected File | XLS | hafd1996pivot.xls | Open resource |
| 1995 Pivot Table Hospital Annual Selected File | XLS | hafd1995pivot.xls | Open resource |
| All resource data | ZIP | pre-2012-hospital-annual-financial-data-selected-data-pivot-tables-o8wsoik6.zip | Open resource |
| 1998 CY Hospital Annual Selected File | Text | cy-selected-file-hafd1998.txt | Open resource |
| 1995 - 1999 (Combined) CY Hospital Annual Selected File | Text | In July 2001, HCAI performed an extract of its hospital annual financial database for report periods ended January 1, 1995 through December 31, 1999, and produced updated data files which reflect all corrections made by HCAI audit staff and hospital representatives. Comparison of the previously released data files with the revised data files may not have a material effect on statewide aggregations, but may have a significant effect on the data for individual hospitals. *This documentation is applicable for the combined, five-year data file and each of the separate, one-year data files. It also applies to the selected data file which covers report periods ended July 1, 1999 to June 29, 2000. The file does not include all hospitals and represents the final annual financial data file produced in which managed care data are not reported separately. | Open resource |
| 2000 and After CY Documentation | cy-selected-file-hafdocumentation-2000andafter.pdf | Open resource | |
| 2010 Pivot Table Hospital Annual Selected File | XLS | hafd2010pivot.xls | Open resource |
| 2009 Pivot Table Hospital Annual Selected File | XLS | hafd2009pivot.xls | Open resource |
| 2011 CY Hospital Annual Selected File (October 2013 Extract) | XLS | cy-selected-file-hafd11revised1013.xlsx | Open resource |
| Post-2011 Hospital Annual Financial Data - Selected Data & Pivot Tables | HTML | Open resource | |
| Individual Facility Report Search (SIERA) | Unknown | Financial Disclosure Report site, where you can view and save detailed financial disclosure reports submitted by California’s 450 hospitals and 1,200 long-term care facilities. | Open resource |