ExperimentalWe used data and feedback to make a user-friendly site. We’d love your feedback.
Back to data.ca.gov.

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 descriptionAccess dataFile detailsLast 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
08/11/23

All resource data

DownloadZIP
08/11/23

Supporting files

Data title and descriptionAccess dataFile detailsLast 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
08/11/23

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
08/11/23

Hospital Annual Selected File - Documentation

PDF
08/11/23

2022 CY Hospital Annual Selected File (April 2024 Extract)

XLSX
10/28/23

2022 Pivot Table - Hospital Annual Selected File (April 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
04/19/24

2021-2022 FY Hospital Annual Selected File (April 2024 Extract)

XLSX
08/11/23

2021 CY Hospital Annual Selected File (October 2023 Extract)

XLSX
08/11/23

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
08/11/23

2021 Pivot Table - Hospital Annual Selected File (April 2023 Extract)

Archive version retained for SB 525 (2023) hospital list requirements.

XLS
02/03/24

2020-2021 FY Hospital Annual Selected File (October 2022 Extract)

XLSX
08/11/23

2020 CY Hospital Annual Selected File (October 2022 Extract)

XLSX
08/11/23

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
08/11/23

2019-2020 FY Hospital Annual Selected File (April 2022 Extract)

XLSX
08/11/23

2015 - 2019 Hospital Trends Pivot (April 2022 Extract)

XLS
08/11/23

2015 - 2019 Hospital Trends Charts (April 2022 Extract)

PDF
08/11/23

2019 CY Hospital Annual Selected File (April 2022 Extract)

XLSX
08/11/23

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
08/11/23

2018-2019 FY Hospital Annual Selected File (May 2021 Extract)

XLSX
08/11/23

2014 - 2018 Hospital Trends Pivot (May 2021 Extract)

XLS
08/11/23

2014 - 2018 Hospital Trends Charts (May 2021 Extract)

PDF
08/11/23

2018 CY Hospital Annual Selected File (November 2020 Extract)

XLSX
08/11/23

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
08/11/23

2017 - 2018 FY Hospital Annual Selected File (April 2020 Extract)

XLSX
08/11/23

2013 - 2017 Hospital Trends Pivot (October 2019 Extract)

XLS
08/11/23

2013 - 2017 Hospital Trends Charts (October 2019 Extract)

PDF
08/11/23

Hospital Trends Glossary

PDF
08/11/23

2017 CY Hospital Annual Selected File (October 2019 Extract)

XLSX
08/11/23

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
08/11/23

2012 - 2016 Hospital Trends Pivot

XLS
08/11/23

2012 - 2016 Hospital Trends Charts

PDF
08/11/23

2016 CY Hospital Annual Selected File (September 2018 Extract)

XLSX
08/11/23

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
08/11/23

2016 - 2017 FY Hospital Annual Selected File (April 2019 Extract)

XLS
08/11/23

2015 CY Hospital Annual Selected File (March 2018 Extract)

XLSX
08/11/23

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
08/11/23

2015 - 2016 FY Hospital Annual Selected File (September 2018 Extract)

XLSX
08/11/23

2014 CY Hospital Annual Selected File (April 2017 Extract)

XLSX
08/11/23

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
08/11/23

2014 - 2015 FY Hospital Annual Selected File (April 2017 Extract)

XLSX
08/11/23

2013 CY Hospital Annual Selected File (September 2014 Extract)

XLSX
08/11/23

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
08/11/23

2013 - 2014 FY Hospital Annual Selected File (September 2015 Extract)

XLSX
08/11/23

2012 CY Hospital Annual Selected File (October 2014 Extract)

XLSX
08/11/23

2012-2013 FY Hospital Annual Selected File (June 2014 Extract)

XLSX
08/11/23

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
08/11/23

Pre-2012 Hospital Annual Financial Data - Selected Data & Pivot Tables

HTML
08/11/23

API endpoint

Dataset Name

Use the query web API to retrieve data with a set of basic parameters. Copy the API endpoint you need to start.

Usage documentation