Description
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.
Resources
| Name | Format | Description | Link |
|---|---|---|---|
| Data Dictionary - 2023 CY Hospital Annual Selected File (October 2025 Extract) | CSV | Data Dictionary for https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/244efb23-daf0-4137-9609-1bc25e4612b8/download/hadr-2023.xlsx | Open resource |
| 2015 - 2016 FY Hospital Annual Selected File (September 2018 Extract) | XLS | hafd1516_092018.xlsx | Open resource |
| 2015 CY Hospital Annual Selected File (March 2018 Extract) | XLS | hafd15-32018-extract.xlsx | Open resource |
| 2015 - 2019 Hospital Trends Charts (April 2022 Extract) | 2015-2019-hospital-trends-charts.pdf | Open resource | |
| 2013 CY Hospital Annual Selected File (September 2014 Extract) | XLS | hafd13-92015-extract.xls | Open resource |
| 2014 Pivot Table Hospital Annual Selected File | XLS | Based on the complete data set, the pivot tables uses a summarized version of the file and displays the data on profile pages which by categories that include General Hospital Information, Inpatient Utilization by Payer, Licensed Beds and Utilization by Type of Care, Nursery Information, Outpatient Visits by Payer, Ambulatory and Referred Outpatient Visits, Managed Care Contract Utilization, Operating Room, Number of Surgeries, and Births, Summary Income Statement, Patient Revenue Information, Expense Information, Balance Sheet Information, & Labor and Productivity Information. | Open resource |
| Data Importing Instructions for Excel | Doc | Please note that this data contains fields with leading zeroes. In order to use this data with Microsoft Excel, you must save the file to your computer and then import the data. If you double-click on the .csv file and allow Excel to open the file automatically, the leading zeroes will disappear. | Open resource |
| 2015 Pivot Table Hospital Annual Selected File | XLS | Based on the complete data set, the pivot tables uses a summarized version of the file and displays the data on profile pages which by categories that include General Hospital Information, Inpatient Utilization by Payer, Licensed Beds and Utilization by Type of Care, Nursery Information, Outpatient Visits by Payer, Ambulatory and Referred Outpatient Visits, Managed Care Contract Utilization, Operating Room, Number of Surgeries, and Births, Summary Income Statement, Patient Revenue Information, Expense Information, Balance Sheet Information, & Labor and Productivity Information. | Open resource |
| 2023 CY Hospital Annual Selected File (October 2025 Extract) | XLS | hadr-2023.xlsx | Open resource |
| 2022 CY Hospital Annual Selected File (October 2024 Extract) | XLS | hadr-2022.xlsx | Open resource |
| 2021 Pivot Table - Hospital Annual Selected File (October 2023 Extract) | XLS | Based on the complete data set, the pivot table uses a summarized version of the file and displays the data on profile pages which by categories that include General Hospital Information, Inpatient Utilization by Payer, Licensed Beds and Utilization by Type of Care, Nursery Information, Outpatient Visits by Payer, Ambulatory and Referred Outpatient Visits, Managed Care Contract Utilization, Operating Room, Number of Surgeries, and Births, Summary Income Statement, Patient Revenue Information, Expense Information, Balance Sheet Information, & Labor and Productivity Information. | Open resource |
| 2023-2024 FY Hospital Annual Selected File (October 2025 Extract) | XLS | hadr-2023-2024.xlsx | Open resource |
| 2016 - 2017 FY Hospital Annual Selected File (April 2019 Extract) | XLS | hadr-2016-2017.xls | Open resource |
| 2012 CY Hospital Annual Selected File (October 2014 Extract) | XLS | hafd12-10-2014-extract.xls | Open resource |
| 2024 CY Hospital Annual Selected File (October 2025 Extract) | XLS | hadr-2024.xlsx | Open resource |
| 2013 - 2017 Hospital Trends Pivot (October 2019 Extract) | XLS | 2013-2017-hospital-trends-pivot.xls | Open resource |
| 2017 Pivot Table - Hospital Annual Selected File (October 2019 Extract) | XLS | Based on the complete data set, the pivot tables uses a summarized version of the file and displays the data on profile pages which by categories that include General Hospital Information, Inpatient Utilization by Payer, Licensed Beds and Utilization by Type of Care, Nursery Information, Outpatient Visits by Payer, Ambulatory and Referred Outpatient Visits, Managed Care Contract Utilization, Operating Room, Number of Surgeries, and Births, Summary Income Statement, Patient Revenue Information, Expense Information, Balance Sheet Information, & Labor and Productivity Information | Open resource |
| 2013 - 2014 FY Hospital Annual Selected File (September 2015 Extract) | XLS | hafd1314-092015-extract.xls | Open resource |
| 2021 CY Hospital Annual Selected File (October 2023 Extract) | XLS | hadr-21.xlsx | Open resource |
| All resource data | ZIP | hospital-annual-financial-data-selected-data-pivot-tables-p5t4_cgt.zip | Open resource |
| 2015 - 2019 Hospital Trends Pivot (April 2022 Extract) | XLS | 2015-2019-hospital-trends-pivot.xls | Open resource |
| 2018 Pivot Table - Hospital Annual Selected File (November 2020 Extract) | XLS | Based on the complete data set, the pivot tables uses a summarized version of the file and displays the data on profile pages which by categories that include General Hospital Information, Inpatient Utilization by Payer, Licensed Beds and Utilization by Type of Care, Nursery Information, Outpatient Visits by Payer, Ambulatory and Referred Outpatient Visits, Managed Care Contract Utilization, Operating Room, Number of Surgeries, and Births, Summary Income Statement, Patient Revenue Information, Expense Information, Balance Sheet Information, & Labor and Productivity Information | Open resource |
| 2017 - 2018 FY Hospital Annual Selected File (April 2020 Extract) | XLS | hadr-17-18.xlsx | Open resource |
| 2021 Pivot Table - Hospital Annual Selected File (April 2023 Extract) | XLS | Archive version retained for SB 525 (2023) hospital list requirements. | Open resource |
| 2016 CY Hospital Annual Selected File (September 2018 Extract) | XLS | hadf16-_092018.xlsx | Open resource |
| 2022-2023 FY Hospital Annual Selected File (October 2025 Extract) | XLS | hadr-2022-2023.xlsx | Open resource |
| 2017 CY Hospital Annual Selected File (October 2019 Extract) | XLS | hadr-17.xlsx | Open resource |
| 2012 - 2017 CY Hospital Annual Selected File (Machine-Readable format) | CSV | This file contains data that has been reformatted to be machine-readable from the following files that are available separately: Calendar Year 2012 (October 2014) Calendar Year 2013 (September 2015) Calendar Year 2014 (April 2017) Calendar Year 2015 (March 2018) Calendar Year 2016 (March 2018) Calendar Year 2017 (September 2018) | Open resource |
| Hospital Annual Selected File - Documentation | hafdselectedfiledoc2004.pdf | Open resource | |
| 2019 Pivot Table - Hospital Annual Selected File (April 2022 Extract) | XLS | Based on the complete data set, the pivot tables uses a summarized version of the file and displays the data on profile pages which by categories that include General Hospital Information, Inpatient Utilization by Payer, Licensed Beds and Utilization by Type of Care, Nursery Information, Outpatient Visits by Payer, Ambulatory and Referred Outpatient Visits, Managed Care Contract Utilization, Operating Room, Number of Surgeries, and Births, Summary Income Statement, Patient Revenue Information, Expense Information, Balance Sheet Information, & Labor and Productivity Information. | Open resource |
| 2023 Pivot Table - Hospital Annual Selected File (October 2025 Extract) | XLS | Based on the complete data set, the pivot table uses a summarized version of the file and displays the data on profile pages which by categories that include General Hospital Information, Inpatient Utilization by Payer, Licensed Beds and Utilization by Type of Care, Nursery Information, Outpatient Visits by Payer, Ambulatory and Referred Outpatient Visits, Managed Care Contract Utilization, Operating Room, Number of Surgeries, and Births, Summary Income Statement, Patient Revenue Information, Expense Information, Balance Sheet Information, & Labor and Productivity Information. | Open resource |
| 2012 - 2016 Hospital Trends Pivot | XLS | 2012-2016-hospital-trends-pivot.xls | Open resource |
| 2013 - 2017 Hospital Trends Charts (October 2019 Extract) | 2013-2017-hospital-trends-charts.pdf | Open resource | |
| 2012 Pivot Table Hospital Annual Selected File | XLS | Based on the complete data set, the pivot tables uses a summarized version of the file and displays the data on profile pages which by categories that include General Hospital Information, Inpatient Utilization by Payer, Licensed Beds and Utilization by Type of Care, Nursery Information, Outpatient Visits by Payer, Ambulatory and Referred Outpatient Visits, Managed Care Contract Utilization, Operating Room, Number of Surgeries, and Births, Summary Income Statement, Patient Revenue Information, Expense Information, Balance Sheet Information, & Labor and Productivity Information. | Open resource |
| 2020 CY Hospital Annual Selected File (October 2022 Extract) | XLS | hadr-20.xlsx | Open resource |
| Hospital Trends Glossary | 2012-2016-hospital-trends-glossary.pdf | Open resource | |
| 2021-2022 FY Hospital Annual Selected File (October 2024 Extract) | XLS | hadr-2021-2022.xlsx | Open resource |
| 2013 Pivot Table Hospital Annual Selected File | XLS | Based on the complete data set, the pivot tables uses a summarized version of the file and displays the data on profile pages which by categories that include General Hospital Information, Inpatient Utilization by Payer, Licensed Beds and Utilization by Type of Care, Nursery Information, Outpatient Visits by Payer, Ambulatory and Referred Outpatient Visits, Managed Care Contract Utilization, Operating Room, Number of Surgeries, and Births, Summary Income Statement, Patient Revenue Information, Expense Information, Balance Sheet Information, & Labor and Productivity Information. | Open resource |
| 2014 - 2018 Hospital Trends Charts (May 2021 Extract) | 2014-2018-hospital-trends-charts.pdf | Open resource | |
| 2024 Pivot Table - Hospital Annual Selected File (October 2025 Extract) | XLS | Based on the complete data set, the pivot table uses a summarized version of the file and displays the data on profile pages which by categories that include General Hospital Information, Inpatient Utilization by Payer, Licensed Beds and Utilization by Type of Care, Nursery Information, Outpatient Visits by Payer, Ambulatory and Referred Outpatient Visits, Managed Care Contract Utilization, Operating Room, Number of Surgeries, and Births, Summary Income Statement, Patient Revenue Information, Expense Information, Balance Sheet Information, & Labor and Productivity Information. | Open resource |
| 2019 CY Hospital Annual Selected File (April 2022 Extract) | XLS | hadr-19.xlsx | Open resource |
| 2014 CY Hospital Annual Selected File (April 2017 Extract) | XLS | hafd14-42017-extract.xlsx | Open resource |
| 2012 - 2016 Hospital Trends Charts | 2012-2016-hospital-trends-charts.pdf | Open resource | |
| 2020-2021 FY Hospital Annual Selected File (October 2022 Extract) | XLS | hadr-20-21.xlsx | Open resource |
| 2018-2019 FY Hospital Annual Selected File (May 2021 Extract) | XLS | hadr-18-19.xlsx | Open resource |
| 2022 Pivot Table - Hospital Annual Selected File (October 2024 Extract) | XLS | Based on the complete data set, the pivot table uses a summarized version of the file and displays the data on profile pages which by categories that include General Hospital Information, Inpatient Utilization by Payer, Licensed Beds and Utilization by Type of Care, Nursery Information, Outpatient Visits by Payer, Ambulatory and Referred Outpatient Visits, Managed Care Contract Utilization, Operating Room, Number of Surgeries, and Births, Summary Income Statement, Patient Revenue Information, Expense Information, Balance Sheet Information, & Labor and Productivity Information. | Open resource |
| 2016 Pivot Table - Hospital Annual Selected File (September 2018 Extract) | XLS | Based on the complete data set, the pivot tables uses a summarized version of the file and displays the data on profile pages which by categories that include General Hospital Information, Inpatient Utilization by Payer, Licensed Beds and Utilization by Type of Care, Nursery Information, Outpatient Visits by Payer, Ambulatory and Referred Outpatient Visits, Managed Care Contract Utilization, Operating Room, Number of Surgeries, and Births, Summary Income Statement, Patient Revenue Information, Expense Information, Balance Sheet Information, & Labor and Productivity Information. | Open resource |
| 2020 Pivot Table - Hospital Annual Selected File (October 2022 Extract) | XLS | Based on the complete data set, the pivot table uses a summarized version of the file and displays the data on profile pages which by categories that include General Hospital Information, Inpatient Utilization by Payer, Licensed Beds and Utilization by Type of Care, Nursery Information, Outpatient Visits by Payer, Ambulatory and Referred Outpatient Visits, Managed Care Contract Utilization, Operating Room, Number of Surgeries, and Births, Summary Income Statement, Patient Revenue Information, Expense Information, Balance Sheet Information, & Labor and Productivity Information. | Open resource |
| 2014 - 2018 Hospital Trends Pivot (May 2021 Extract) | XLS | 2014-2018-hospital-trends-pivot.xls | Open resource |
| 2014 - 2015 FY Hospital Annual Selected File (April 2017 Extract) | XLS | hafd1415-042017-extract.xlsx | Open resource |
| 2018 CY Hospital Annual Selected File (November 2020 Extract) | XLS | hadr-18.xlsx | Open resource |
| 2019-2020 FY Hospital Annual Selected File (April 2022 Extract) | XLS | hadr-19-20.xlsx | Open resource |
| 2012-2013 FY Hospital Annual Selected File (June 2014 Extract) | XLS | hafd1213-062014-extract.xls | Open resource |
| Pre-2012 Hospital Annual Financial Data - Selected Data & Pivot Tables | HTML | Open resource | |
| Individual Facility Report Search (SIERA) | Unknown | 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. | Open resource |
Tags
- alos
- assets
- average-length-of-stay
- beds
- cost-center
- department-of-health-care-access-and-information
- discharges
- discharges-by-payer-source
- equity
- expenses
- financial-ratios
- fte
- hospital
- income-statement
- labor
- liabilities
- net-income
- ogi
- per-adjusted-patient-day
- productive-hours
- revenue
- uncompensated-care-costs