Description
The summation contains updated data which reflect all corrections made by HCAI audit staff and hospital representatives. Each file consists of one rolling 4th quarter file for the respective calendar year of data. Comparison of the previously released data files with the revised data files may not have a material effect on statewide aggregations, but may have a significant effect on the data for individual hospitals.
Resources
| Name | Format | Description | Link |
|---|---|---|---|
| 2018 Quarter 2 - Sum of Four Quarters | CSV | 2018_r4_q2.csv | 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 |
| 2016 Quarter 4 - Sum of Four Quarters | CSV | 2016q4r4-sum-4-qtrs.csv | Open resource |
| 2022 Quarter 3 - Sum of Four Quarters (01/13/2023) | XLS | 2022_r4_q3.xlsx | Open resource |
| 2019 Quarter 2 - Sum of Four Quarters | CSV | 2019_r4_q2.csv | Open resource |
| 2019 Quarter 1 - Sum of Four Quarters | CSV | 2019_r4_q1.xls | Open resource |
| 2013 Quarter 2 - Sum of Four Quarters (Rev 7/15) | CSV | 2013q2r4-sum-4-qtrs.csv | Open resource |
| 2023 Quarter 4 - Sum of Four Quarters (04/16/2024) | XLS | 2023_r4_q4.xlsx | Open resource |
| 2019 Quarter 4 - Sum of Four Quarters | CSV | 2019_r4_q4.csv | Open resource |
| 2022 Quarter 1 - Sum of Four Quarters (07/14/2022) | XLS | 2022_r4_q1.xlsx | Open resource |
| 2015 Quarter 1 - Sum of Four Quarters (Rev 4/16) | CSV | 2015q1r4-sum-4-qtrs.csv | Open resource |
| 2016 Quarter 1 - Sum of Four Quarters | CSV | 2016q1r4-sum-4-qtrs.csv | Open resource |
| Documentation for Hospital Quarterly Financial and Utilization Data Files | For quarters ended 2015-2023 | Open resource | |
| 2025 Quarter 1 - Sum of Four Quarters (07/30/2025) | CSV | 2025_r4_q1.xlsx | Open resource |
| 2015 Quarter 4 - Sum of Four Quarters (Rev 4/16) | CSV | 2015q4r4-sum-4-qtrs.csv | Open resource |
| 2020 Quarter 3 - Sum of Four Quarters (01/15/2021) | XLS | 2020_r4_q3.xlsx | Open resource |
| 2012 Quarter 3 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2012q3r4.xls | Open resource |
| 2019 Quarter 3 - Sum of Four Quarters | CSV | 2019_r4_q3.csv | Open resource |
| 2017 Quarter 4 - Sum of Four Quarters | CSV | 2017q4r4.csv | Open resource |
| 2015 Quarter 3 - Sum of Four Quarters (Rev 4/16) | CSV | 2015q3r4-sum-4-qtrs.csv | Open resource |
| 2018 Quarter 3 - Sum of Four Quarters | CSV | 2018_r4_q3.csv | Open resource |
| 2020 Quarter 1 - Sum of Four Quarters | XLS | 2020_r4_q1.xlsx | Open resource |
| 2020 Quarter 4 - Sum of Four Quarters (04/15/2021) | XLS | 2020_r4_q4.xlsx | Open resource |
| 2018 Quarter 1 - Sum of Four Quarters | CSV | 2018_r4_q1.csv | Open resource |
| 2014 Quarter 1 - Sum of Four Quarters (Rev 7/15) | CSV | 2014q1r4-sum-4-qtrs.csv | Open resource |
| 2012 Quarter 4 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2012q4r4-revised-115.xls | Open resource |
| 2023 Quarter 1 - Sum of Four Quarters (07/14/2023) | XLS | 2023_r4_q1.xlsx | Open resource |
| 2014 Quarter 4 - Sum of Four Quarters (Rev 7/15) | CSV | 2014q4r4-sum-4-qtrs.csv | Open resource |
| 2022 Quarter 2 - Sum of Four Quarters (10/13/2022) | XLS | 2022_r4_q2.xlsx | Open resource |
| 2021 Quarter 2 - Sum of Four Quarters (10/13/2021) | XLS | 2021_r4_q2.xlsx | Open resource |
| 2018 Quarter 4 - Sum of Four Quarters | CSV | 2018_r4_q4.csv | Open resource |
| 2021 Quarter 4 - Sum of Four Quarters (04/15/2022) | XLS | 2021_r4_q4.xlsx | Open resource |
| 2022 Quarter 4 - Sum of Four Quarters (04/14/2023) | XLS | 2022_r4_q4.xlsx | Open resource |
| 2023 Quarter 2 - Sum of Four Quarters (10/16/2023) | XLS | 2023_r4_q2.xlsx | Open resource |
| 2012 Quarter 2 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2012q2r4.xls | Open resource |
| All resource data | ZIP | hospital-quarterly-financial-utilization-report-sum-of-four-quarters-3le9qtaf.zip | Open resource |
| All resource data | ZIP | hospital-quarterly-financial-utilization-report-sum-of-four-quarters-f4u4n0u4.zip | Open resource |
| All resource data | ZIP | hospital-quarterly-financial-utilization-report-sum-of-four-quarters-gewsed.zip | Open resource |
| All resource data | ZIP | hospital-quarterly-financial-utilization-report-sum-of-four-quarters-jyuqrqpf.zip | Open resource |
| Documentation for Hospital Quarterly Financial & Utilization Data | for 2015 and after | Open resource | |
| 2017 Quarter 1 - Sum of Four Quarters | CSV | 2017q1r4-sum-4-qtrs.csv | Open resource |
| 2017 Quarter 3 - Sum of Four Quarters | CSV | 2017q3r4-sum-4-qtrs.csv | Open resource |
| Documentation for Hospital Quarterly Financial and Utilization Data Files | For quarters ended 2024 and after. | Open resource | |
| 2020 Quarter 2 - Sum of Four Quarters (10/19/2020) | XLS | 2020_r4_q2.xlsx | Open resource |
| 2021 Quarter 1 - Sum of Four Quarters (07/14/2021) | XLS | 2021_r4_q1.xlsx | Open resource |
| 2014 Quarter 3 - Sum of Four Quarters (Rev 7/15) | CSV | 2014q3r4-sum-4-qtrs.csv | Open resource |
| 2012 Quarter 1 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2011q1r4.xls | Open resource |
| 2017 Quarter 2 - Sum of Four Quarters | CSV | 2017q2r4-sum-4-qtrs.csv | Open resource |
| 2023 Quarter 3 - Sum of Four Quarters (01/16/2024) | XLS | 2023_r4_q3.xlsx | Open resource |
| 2016 Quarter 2 - Sum of Four Quarters | CSV | 2016q2r4-sum-4-qtrs.csv | Open resource |
| 2013 Quarter 3 - Sum of Four Quarters (Rev 7/15) | CSV | 2013q3r4-sum-4-qtrs.csv | Open resource |
| 2021 Quarter 3 - Sum of Four Quarters (01/13/2022) | XLS | 2021_r4_q3.xlsx | Open resource |
| 2013 Quarter 1 - Sum of Four Quarters (Rev 7/15) | CSV | 2013q1r4-sum-4-qtrs.csv | Open resource |
| 2024 Quarter 4 - Sum of Four Quarters (04/29/2024) | XLS | 2024_r4_q4.xlsx | Open resource |
| 2016 Quarter 3 - Sum of Four Quarters | CSV | 2016q3r4-sum-4-qtrs.csv | Open resource |
| 2015 Quarter 2 - Sum of Four Quarters (Rev 4/16) | CSV | 2015q2r4-sum-4-qtrs.csv | Open resource |
| 2013 Quarter 4 - Sum of Four Quarters (Rev 7/15) | CSV | 2013q4r4-sum-4-qtrs.csv | Open resource |
| Documentation for Hospital Quarterly Financial & Utilization Data (2000 - 2014) | For the years 2000 - 2014 only. | Open resource | |
| 2014 Quarter 2 - Sum of Four Quarters (Rev 7/15) | CSV | 2014q2r4-sum-4-qtrs.csv | Open resource |
| Pre-2012 Hospital Quarterly Financial & Utilization Report - Sum of Four Quarters | 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 |