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.
To view a statewide Pivot Profile based on the latest available data, click here.
- 2007 WinZip.exe 936.24 KB | WinZip.zip 868.15 KB (09/08 Extract)
- 2006 WinZip.exe 969.56 KB | WinZip.zip 901.47 KB (09/08 Extract)
- 2005 WinZip.exe 971.7 KB | WinZip.zip 903.61 KB (09/07 Extract)
- 2004 WinZip.exe 996.71 KB | WinZip.zip 928.63 KB (10/06 Extract)
- 2003 WinZip.exe 1017.68 KB | WinZip.zip 949.58 KB (10/05 Extract)
- 2002 WinZip.exe 983.63 KB | WinZip.zip 915.55 KB
- 2001 WinZip.exe 1007.99 KB | WinZip.zip 939.9 KB
- 2000** WinZip.exe 862.38 KB | WinZip.zip 794.3 KB
- 1999 WinZip.exe 821.03 KB | WinZip.zip 752.94 KB
- 1998 WinZip.exe 832.07 KB | WinZip.zip 763.99 KB
- 1997 WinZip.exe 851.78 KB | WinZip.zip 783.7 KB
- 1996 WinZip.exe 865.41 KB | WinZip.zip 797.33 KB
- 1995 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.

