Healthcare Information Division - Annual Financial Data
Pivot Profiles
The following Pivot Profiles were developed using the hospital annual financial data covering report periods ending in the year listed. Beginning with 2004, the file contains 5 worksheets - the data, the pivot table, the profile, charts and a glossary.
Three Easy Steps to Use Pivot Profiles
- Download and unzip Pivot Profile, preferably to your desktop.
- From Pivot worksheet, select variables using drop-down boxes.
- Go to Profile worksheet to view results.
Click here for detailed instructions on how to download and use Pivot Profiles.
If you need technical assistance, please call HIRC at (916) 326-3802.
- 2010 Excel.xlsm 1.33 MB | WinZip.exe 1.45 MB | WinZip.zip 1.32 MB (9/11 Extract)
- 2009 Excel.xls 4.27 MB | WinZip.exe 1.42 MB | WinZip.zip 1.29 MB (9/11 Extract)
- 2008 Excel.xls 2.45 MB | WinZip.exe 1020 KB | WinZip.zip 884.88 KB (09/10 Extract)
- 2007 Excel.xls 2.71 MB | WinZip.exe 991.68 KB | WinZip.zip 923.59 KB (09/09 Extract)
- 2006 Excel.xls 2.64 MB | WinZip.exe 998.44 KB | WinZip.zip 930.35 KB (10/08 Extract)
- 2005 Excel.xls 2.62 MB | WinZip.exe 1000.98 KB | WinZip.zip 932.89 KB (09/07 Extract)
- 2004 Excel.xls 2.77 MB | WinZip.exe 1 MB | WinZip.zip 959.87 KB (10/06 Extract)
- 2003 Excel.xls 2.6 MB | WinZip.exe 1.01 MB | WinZip.zip 965.31 KB (10/05 Extract)
- 2002 Excel.xls 2.54 MB | WinZip.exe 999.15 KB | WinZip.zip 931.07 KB
- 2001 Excel.xls 2.6 MB | WinZip.exe 1019.08 KB | WinZip.zip 950.99 KB
- 2000** Excel.xls 2.33 MB | WinZip.exe 875.97 KB | WinZip.zip 807.88 KB
- 1999 Excel.xls 1.93 MB | WinZip.exe 821.03 KB | WinZip.zip 752.94 KB
- 1998 Excel.xls 1.98 MB | WinZip.exe 832.07 KB | WinZip.zip 763.99 KB
- 1997 Excel.xls 2.05 MB | WinZip.exe 851.78 KB | WinZip.zip 783.7 KB
- 1996 Excel.xls 2.09 MB | WinZip.exe 865.41 KB | WinZip.zip 797.33 KB
- 1995 Excel.xls 2.13 MB | WinZip.exe 881.23 KB | WinZip.zip 813.14 KB
The Hospital Annual Financial Data for California documentation (pdf) is provided as a reference.
**Note: The 2000 pivot profile files are for 6/30/00 to 12/31/00 only due to change in reporting requirements.
Attention Data Users: Please exercise caution when interpreting OSHPD data. The use of improper assumptions and analytical methods may result in erroneous or misleading conclusions. Conclusions drawn from OSHPD data are the sole responsibility of the user. Users should be aware that financial and utilization data products are based on a dynamic database that is constantly being updated. As a result, the same data item for a facility may change over time or be different between products.
If you are unable to download ZIP or EXE files, please e-mail the OSHPDWebmaster.
Extracted files can be e-mailed to users at no charge.