Hospital Annual Financial Data - Selected Data & Pivot Tables

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
53 hadr-21-22.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/a6745a1c-7edb-47b2-a483-cd003a6293e5/download/hadr-21-22.xlsx
53 hadr-20-21.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/d30305d9-b150-43fb-8d99-2189fe5af87d/download/hadr-20-21.xlsx
53 hadr-20.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/95614502-4a18-4c0a-a820-a780f4a7f1a2/download/hadr-20.xlsx
53 hadr-19-20.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/f1aaf6ec-f9f0-4c24-bacf-83882c29728a/download/hadr-19-20.xlsx
53 2015-2019-hospital-trends-pivot.xls https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/55a80dcf-da3b-4616-806b-53ce44d93f7d/download/2015-2019-hospital-trends-pivot.xls
33 2015-2019-hospital-trends-charts.pdf https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/0e1a9d04-d47c-46f5-9f68-67435eed62f9/download/2015-2019-hospital-trends-charts.pdf
53 hadr-21.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/48e753b3-db5a-4ddf-b88c-3a726e13b5e3/download/hadr-21.xlsx
53 hadr-17-18.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/6d971588-0321-410f-8def-6ac2eacbb682/download/hadr-17-18.xlsx
53 Archive version retained for SB 525 (2023) hospital list requirements. https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/70fae5b8-7ba2-423c-a3d3-ffd5e7b036e3/download/hafd2021-pivot_april-2023-extract.xls
33 2014-2018-hospital-trends-charts.pdf https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/baa572d1-0fde-4ebb-b734-c6588c50e3c5/download/2014-2018-hospital-trends-charts.pdf
53 hadr-18.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/efcd34e6-5718-4457-92fb-786f753cabdf/download/hadr-18.xlsx
53 hadr-22.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/28df017b-7693-4d83-b105-69eeca4a12e0/download/hadr-22.xlsx
33 2012-2016-hospital-trends-glossary.pdf https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/9cfde79f-b156-4d3b-9ca9-8916b05e9a65/download/2012-2016-hospital-trends-glossary.pdf
53 hadr-17.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/7f253787-c4e9-472c-a2e9-892ef8f34900/download/hadr-17.xlsx
53 2012-2016-hospital-trends-pivot.xls https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/882faca2-49ea-44b1-83cb-c904af145210/download/2012-2016-hospital-trends-pivot.xls
33 2012-2016-hospital-trends-charts.pdf https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/cebcc1d8-108b-438a-86e9-30605a9c11c7/download/2012-2016-hospital-trends-charts.pdf
53 hadf16-_092018.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/71c967e3-baf2-42b8-a0fa-b7c73500971e/download/hadf16-_092018.xlsx
53 hafd1516_092018.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/0417f024-e604-45c9-9a7f-27f3c7947af7/download/hafd1516_092018.xlsx
53 hafd1415-042017-extract.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/edbf3b2f-4e84-40ef-9859-ddd9ebca9d41/download/hafd1415-042017-extract.xlsx
53 hafd13-92015-extract.xls https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/0e6d1890-ca81-49cf-af9e-4b9f64eecdc2/download/hafd13-92015-extract.xls
53 hafd12-10-2014-extract.xls https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/3721ee6a-3dbb-48d9-9011-ee116f0d7afe/download/hafd12-10-2014-extract.xls
21 https://data.chhs.ca.gov/dataset/pre-2012-hospital-annual-financial-data-selected-data-pivot-tables?__no_cache__=True
10 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. https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/1664fdb7-0b40-450e-8257-1b355884fb26/download/data-importing-instructions-for-excel.docx
53 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. https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/e6a7cc46-836f-4437-8ad1-e485d6ea0514/download/hafd2022pivot.xls
0 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. https://siera.oshpd.ca.gov/FinancialDisclosure.aspx
33 hafdselectedfiledoc2004.pdf https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/842c8bcb-bfac-4aa9-9de8-b11eb049f6de/download/hafdselectedfiledoc2004.pdf
53 2013-2017-hospital-trends-pivot.xls https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/3b3127df-82bd-49c7-afef-409e5285ef69/download/2013-2017-hospital-trends-pivot.xls
53 hafd15-32018-extract.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/048d9f12-a0f1-4bd7-a117-d5455b05ab4d/download/hafd15-32018-extract.xlsx
53 hadr-19.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/c09beb74-f89f-49a7-b296-bb2fb46331d3/download/hadr-19.xlsx
53 hadr-18-19.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/e2b51a4b-62a1-4af4-8f15-52422deabad5/download/hadr-18-19.xlsx
53 2014-2018-hospital-trends-pivot.xls https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/ec126df1-4eea-4289-b8d7-8e6739a40183/download/2014-2018-hospital-trends-pivot.xls
53 hadr-2016-2017.xls https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/30a68091-5935-4811-bc9a-1682f5d06a22/download/hadr-2016-2017.xls
53 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. https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/18ab3d0f-2281-404b-8bf1-e4d296995cc6/download/hafd2015pivot.xls
53 hafd1314-092015-extract.xls https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/46f11db1-ccae-4b0c-b07c-2c7b34fdd677/download/hafd1314-092015-extract.xls
8 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) https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/81602900-aa04-4fcb-b70b-19bc0553f79b/download/selected-file_2012_2017_machinereadable.csv
33 2013-2017-hospital-trends-charts.pdf https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/8981f51f-e2fa-467a-a4d5-55721ac1ac22/download/2013-2017-hospital-trends-charts.pdf
53 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 https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/42be7a51-1a40-4b12-9513-904562db0de6/download/hafd2017pivot.xls
53 hafd14-42017-extract.xlsx https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/cea4b41a-5d9d-4898-b0aa-fad2aabbc132/download/hafd14-42017-extract.xlsx
53 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. https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/b83cd02b-5b4f-41bb-8fd3-6e3b320db231/download/hafd2013pivot.xls
57 hospital-annual-financial-data-selected-data-pivot-tables-5z_chw.zip https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/4ff376d6-cf36-4b2a-8556-7a220774ad6f/download/hospital-annual-financial-data-selected-data-pivot-tables-5z_chw.zip
53 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. https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/e9f12f88-8909-44f4-b888-deaa1ab1ffe7/download/hafd2020-pivot.xls
53 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. https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/84d0a088-3689-40b4-ab82-6b04e8c0b213/download/hafd2019pivot.xls
53 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. https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/e7d882f8-ff3d-48a2-ac71-44ce0091bf47/download/hafd2016pivot.xls
53 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. https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/133a9bb9-a228-4470-9b75-0510368f666c/download/hafd2014pivot.xls
53 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. https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/29bacfe7-a98d-4183-9282-a5803a3d4c6e/download/hafd2021-pivot.xls
53 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 https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/6c6d350a-3de1-41ac-890e-874a61e1d997/download/hafd2018pivot.xls
53 hafd1213-062014-extract.xls https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/f1b6a613-a4d9-4e70-a6d5-f34bbb1a5248/download/hafd1213-062014-extract.xls
53 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. https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/947eed6f-10f9-4424-9ce9-951dd0d4f954/download/hafd2012pivot.xls

Tags

  • fte
  • productive-hours
  • liabilities
  • expenses
  • discharges-by-payer-source
  • alos
  • average-length-of-stay
  • department-of-health-care-access-and-information
  • discharges
  • beds
  • revenue
  • ogi
  • equity
  • assets
  • hospital
  • labor
  • per-adjusted-patient-day
  • uncompensated-care-costs
  • financial-ratios
  • cost-center
  • income-statement
  • net-income

Topics

Categories