Pre-2012 Hospital Annual Financial Data - Selected Data & Pivot Tables
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.
Data files
| Data title and description | Access data | File details | Last updated |
|---|---|---|---|
2000 CY Partial (7/1/99 - 6/29/00) Hospital Annual Selected File | Download | TXT | 06/28/24 |
2000 CY Partial (6/30/00 - 12/31/00) Hospital Annual Selected File | Download | TXT | 06/28/24 |
1995 - 1999 (Combined) CY Hospital Annual Selected File 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. | Download | TXT | 06/28/24 |
1999 CY Hospital Annual Selected File | Download | TXT | 06/28/24 |
1998 CY Hospital Annual Selected File | Download | TXT | 06/28/24 |
1997 CY Hospital Annual Selected File | Download | TXT | 06/28/24 |
1996 CY Hospital Annual Selected File | Download | TXT | 06/28/24 |
1995 CY Hospital Annual Selected File | Download | TXT | 06/28/24 |
All resource data | Download | ZIP | 08/29/24 |
Supporting files
| Data title and description | Access data | File details | Last updated |
|---|---|---|---|
Post-2011 Hospital Annual Financial Data - Selected Data & Pivot Tables | Download | HTML | 06/28/24 |
Individual Facility Report Search (SIERA) 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. | Download | ASPX | 06/28/24 |
Data Importing Instructions for Excel | Download | DOCX | 06/28/24 |
2000 and After CY Documentation | Download | PDF | 06/28/24 |
2011 CY Hospital Annual Selected File (October 2013 Extract) | Download | XLSX | 06/28/24 |
2011 - 2012 FY Hospital Annual Selected File (October 2013 Extract) | Download | XLSX | 06/28/24 |
2011 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
2010 CY Hospital Annual Selected File (September 2012 Extract) | Download | XLS | 06/28/24 |
2010 - 2011 FY Hospital Annual Selected File (September 2012 Extract) | Download | XLSX | 06/28/24 |
2010 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
2009 CY Hospital Annual Selected File (September 2011 Extract) | Download | XLSX | 06/28/24 |
2009 - 2010 FY Hospital Annual Selected File (September 2011 Extract) | Download | XLSX | 06/28/24 |
2009 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
2008 CY Hospital Annual Selected File (September 2010 Extract) | Download | XLS | 06/28/24 |
2008 - 2009 FY Hospital Annual Selected File (September 2010 Extract) | Download | XLS | 06/28/24 |
2008 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
2007 CY Hospital Annual Selected File (September 2009 Extract) | Download | XLS | 06/28/24 |
2007 - 2008 FY Hospital Annual Selected File (September 2009 Extract) | Download | XLS | 06/28/24 |
2007 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
2006 CY Hospital Annual Selected File (September 2008 Extract) | Download | XLS | 06/28/24 |
2006 - 2007 FY Hospital Annual Selected File (September 2008 Extract) | Download | XLS | 06/28/24 |
2006 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
2005 CY Hospital Annual Selected File (September 2007 Extract) | Download | XLS | 06/28/24 |
2005 - 2006 FY Hospital Annual Selected File (September 2007 Extract) | Download | XLS | 06/28/24 |
2005 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
2004 CY Hospital Annual Selected File (September 2006 Extract) | Download | XLS | 06/28/24 |
2004 - 2005 FY Hospital Annual Selected File (September 2006 Extract) | Download | XLS | 06/28/24 |
2004 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
2003 CY Hospital Annual Selected File (September 2005 Extract) | Download | XLS | 06/28/24 |
2003 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
2002 CY Hospital Annual Selected File (October 2004 Extract) | Download | XLS | 06/28/24 |
2002 - 2003 FY Hospital Annual Selected File (October 2004 Extract) | Download | XLS | 06/28/24 |
2002 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
2001 CY Hospital Annual Selected File (September 2004 Extract) | Download | XLS | 06/28/24 |
2001 - 2002 FY Hospital Annual Selected File | Download | XLS | 06/28/24 |
2001 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
2000 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
1995 - 1999 Documentation Hospital Annual Selected File | Download | PDF | 06/28/24 |
1997 - 1999 Documentation Hospital Annual Selected File | Download | PDF | 06/28/24 |
1999 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
1998 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
1997 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
1996 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |
1995 Pivot Table Hospital Annual Selected File | Download | XLS | 06/28/24 |