Hospital Annual Financial Data: Selected Data
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.
To make it easier to compare hospitals by year, hospital reports with report periods ending within a given calendar year are grouped together.
Beginning in 2000, hospital reports with report periods ending within a given fiscal year (July-June) are grouped together. The hospital reporting form was changed for report periods ended June 30, 2004. As a result, a 2003/04 fiscal year data file and a June 30, 2004 partial year data file that includes this report period was not produced.
The data files below, in comma delimited text format (.TXT) and Excel Downloads, contain most of pages 0 through 9 for the stated report period of the Hospital Financial Disclosure Report submitted annually by California hospitals. Excluded due to their length or infrequent usage are: Page 1, Lines 110-320; Pages 3.1, 3.2, and 3.4; and Page 5.1, Lines 255-320.
The full database is available on CD-ROM upon request. To order, please contact the Healthcare Information Resource Center at (916) 326-3802 or E-mail HIRC.
Note: Each Text Download is an average size of 1 MB and each Excel Download is an average size of 1.3 MB each. These files are listed by Report Cycle year and the date range indicates the timeframe for the Hospital's Report Year End date. Thus a calendar year of data for 2006 would fall in cycle year 32.
Documentation for Years 23 - 31 and Report forms(P00.xls through P09.xls) can be downloaded to help choose pages or variables and simplify references to variable names in the data files. The following pages are included in each Download:
|Page #||Page Contents|
|3.3||Related Hospital Information|
|4.1||Patient Census Statistics|
|4.2||Ambulatory, Ancillary and Other Utilization Statistics|
|5||Balance Sheet - Unrestricted Fund|
|5.1||Supplemental Long-Term Debt Information|
|5.2||Statement of Changes in Plant, Property and Equipment|
|6||Balance Sheet - Restricted Funds|
|7||Statement of Changes in Equity|
|8||Statement of Income - Unrestricted Fund (Operating and Non-Operating Revenues and Expenses)|
|8.1||Statement of Income - Unrestricted Fund (Operating and Non-Operating Revenues and Expenses)|
|9||Statement of Cash Flows - Unrestricted Fund|
This page was last updated on Thursday, October 19, 2017.