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

  1. Download and unzip Pivot Profile, preferably to your desktop.
  2. From Pivot worksheet, select variables using drop-down boxes.
  3. 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.

The Hospital Annual Financial Data for California documentation 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.

Page last revised: July 29, 2015