Hospital Annual Financial Data - Selected Data & Pivot Tables
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.
Data files
| Data title and description | Access data | File details | Last updated |
|---|---|---|---|
2012 - 2017 CY Hospital Annual Selected File (Machine-Readable format) 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. | Download | CSV | 09/10/24 |
All resource data | Download | ZIP | 10/10/24 |
Supporting files
| Data title and description | Access data | File details | Last updated |
|---|---|---|---|
Individual Facility Report Search (SIERA) 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. | DATA | 09/10/24 | |
Data Importing Instructions for Excel 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. | DOC | 09/10/24 | |
Hospital Annual Selected File - Documentation | PDF | 09/10/24 | |
2023 CY Hospital Annual Selected File (October 2024 Extract) | XLSX | 10/10/24 | |
2023 Pivot Table - Hospital Annual Selected File (October 2024 Extract) 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. | XLS | 10/10/24 | |
2022-2023 FY Hospital Annual Selected File (October 2024 Extract) | XLSX | 10/10/24 | |
2022 CY Hospital Annual Selected File (October 2024 Extract) | XLSX | 10/10/24 | |
2022 Pivot Table - Hospital Annual Selected File (October 2024 Extract) 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. | XLS | 09/10/24 | |
2021-2022 FY Hospital Annual Selected File (October 2024 Extract) | XLSX | 10/10/24 | |
2021 CY Hospital Annual Selected File (October 2023 Extract) | XLSX | 09/10/24 | |
2021 Pivot Table - Hospital Annual Selected File (October 2023 Extract) 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. | XLS | 09/10/24 | |
2021 Pivot Table - Hospital Annual Selected File (April 2023 Extract) Archive version retained for SB 525 (2023) hospital list requirements. | XLS | 09/10/24 | |
2020-2021 FY Hospital Annual Selected File (October 2022 Extract) | XLSX | 09/10/24 | |
2020 CY Hospital Annual Selected File (October 2022 Extract) | XLSX | 09/10/24 | |
2020 Pivot Table - Hospital Annual Selected File (October 2022 Extract) 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. | XLS | 09/10/24 | |
2019-2020 FY Hospital Annual Selected File (April 2022 Extract) | XLSX | 09/10/24 | |
2015 - 2019 Hospital Trends Pivot (April 2022 Extract) | XLS | 09/10/24 | |
2015 - 2019 Hospital Trends Charts (April 2022 Extract) | PDF | 09/10/24 | |
2019 CY Hospital Annual Selected File (April 2022 Extract) | XLSX | 09/10/24 | |
2019 Pivot Table - Hospital Annual Selected File (April 2022 Extract) 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. | XLS | 09/10/24 | |
2018-2019 FY Hospital Annual Selected File (May 2021 Extract) | XLSX | 09/10/24 | |
2014 - 2018 Hospital Trends Pivot (May 2021 Extract) | XLS | 09/10/24 | |
2014 - 2018 Hospital Trends Charts (May 2021 Extract) | PDF | 09/10/24 | |
2018 CY Hospital Annual Selected File (November 2020 Extract) | XLSX | 09/10/24 | |
2018 Pivot Table - Hospital Annual Selected File (November 2020 Extract) 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 | XLS | 09/10/24 | |
2017 - 2018 FY Hospital Annual Selected File (April 2020 Extract) | XLSX | 09/10/24 | |
2013 - 2017 Hospital Trends Pivot (October 2019 Extract) | XLS | 09/10/24 | |
2013 - 2017 Hospital Trends Charts (October 2019 Extract) | PDF | 09/10/24 | |
Hospital Trends Glossary | PDF | 09/10/24 | |
2017 CY Hospital Annual Selected File (October 2019 Extract) | XLSX | 09/10/24 | |
2017 Pivot Table - Hospital Annual Selected File (October 2019 Extract) 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 | XLS | 09/10/24 | |
2012 - 2016 Hospital Trends Pivot | XLS | 09/10/24 | |
2012 - 2016 Hospital Trends Charts | PDF | 09/10/24 | |
2016 CY Hospital Annual Selected File (September 2018 Extract) | XLSX | 09/10/24 | |
2016 Pivot Table - Hospital Annual Selected File (September 2018 Extract) 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. | XLSX | 09/10/24 | |
2016 - 2017 FY Hospital Annual Selected File (April 2019 Extract) | XLS | 09/10/24 | |
2015 CY Hospital Annual Selected File (March 2018 Extract) | XLSX | 09/10/24 | |
2015 Pivot Table Hospital Annual Selected File 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. | XLSX | 09/10/24 | |
2015 - 2016 FY Hospital Annual Selected File (September 2018 Extract) | XLSX | 09/10/24 | |
2014 CY Hospital Annual Selected File (April 2017 Extract) | XLSX | 09/10/24 | |
2014 Pivot Table Hospital Annual Selected File 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. | XLSX | 09/10/24 | |
2014 - 2015 FY Hospital Annual Selected File (April 2017 Extract) | XLSX | 09/10/24 | |
2013 CY Hospital Annual Selected File (September 2014 Extract) | XLSX | 09/10/24 | |
2013 Pivot Table Hospital Annual Selected File 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. | XLSX | 09/10/24 | |
2013 - 2014 FY Hospital Annual Selected File (September 2015 Extract) | XLSX | 09/10/24 | |
2012 CY Hospital Annual Selected File (October 2014 Extract) | XLSX | 09/10/24 | |
2012-2013 FY Hospital Annual Selected File (June 2014 Extract) | XLSX | 09/10/24 | |
2012 Pivot Table Hospital Annual Selected File 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. | XLS | 09/10/24 | |
Pre-2012 Hospital Annual Financial Data - Selected Data & Pivot Tables | HTML | 09/10/24 |