Hospital Quarterly Financial & Utilization Report - Sum of Four Quarters

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
8 2018_r4_q1.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/7bd87b34-0cfa-4b08-83fd-67d509aaf914/download/2018_r4_q1.csv
33 For the years 2000 - 2014 only. https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/f21bc5e8-3aa5-4a2d-bdff-0bc914380e8c/download/qfur2000-2014doc.pdf
53 2023_r4_q1.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/9763904d-f141-4c1e-8dbb-22b351fcef18/download/2023_r4_q1.xlsx
53 2022_r4_q1.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/29972d3c-aa6e-4c25-b772-d2f61841c2b5/download/2022_r4_q1.xlsx
53 2021_r4_q2.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/a1529ed1-8603-41ce-b9bb-68fa7601efd6/download/2021_r4_q2.xlsx
53 2021_r4_q1.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/cf8f253b-d892-461b-be6b-3a649db4bf57/download/2021_r4_q1.xlsx
53 2020_r4_q4.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/79be3ed5-b71f-490a-96e7-49004bde4ad3/download/2020_r4_q4.xlsx
53 2020_r4_q2.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/cddae06f-217d-4194-943a-1adc4235b4a5/download/2020_r4_q2.xlsx
53 2020_r4_q1.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/76674d93-cce3-446d-b647-87deaec3e077/download/2020_r4_q1.xlsx
8 2019_r4_q4.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/2904cb1a-4c67-414e-91a8-c743c5e6ed40/download/2019_r4_q4.csv
8 2019_r4_q2.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/15d76a91-1136-4212-94ec-332d72c28da3/download/2019_r4_q2.csv
8 2017q4r4.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/519aa719-210c-48f9-ba17-7cc5715596a0/download/2017q4r4.csv
8 2017q2r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/d95a31ff-2813-4215-a681-6dcc38959f27/download/2017q2r4-sum-4-qtrs.csv
8 2016q4r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/0f4293c8-d71a-4a81-9676-9eac0f3fa825/download/2016q4r4-sum-4-qtrs.csv
8 2016q3r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/f0591dad-1f88-4ca6-831b-e2e175a40e3a/download/2016q3r4-sum-4-qtrs.csv
8 2016q2r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/e02234f7-9548-4022-8ae1-c6ce27afd60f/download/2016q2r4-sum-4-qtrs.csv
8 2016q1r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/3a789412-2385-4364-9b42-5e6604d2e84b/download/2016q1r4-sum-4-qtrs.csv
8 2015q3r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/5f4f1ec7-4e39-4bb9-a1e3-e60c6c1c8180/download/2015q3r4-sum-4-qtrs.csv
8 2015q1r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/2ec2b525-ccf3-407c-be21-9d4a361a1894/download/2015q1r4-sum-4-qtrs.csv
8 2014q4r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/982cba27-8c28-434d-8659-b8456f4d086a/download/2014q4r4-sum-4-qtrs.csv
8 2014q3r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/d01257c9-f78d-46f2-a643-9e236e3918bb/download/2014q3r4-sum-4-qtrs.csv
8 2014q1r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/7e505e81-ef9e-45b0-a1e4-6e421693bc98/download/2014q1r4-sum-4-qtrs.csv
8 2013q3r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/ea65500b-5515-4aa0-840c-7b47eda8ca6e/download/2013q3r4-sum-4-qtrs.csv
8 2013q2r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/1fb8ef57-732e-454c-9582-b0d5505086ba/download/2013q2r4-sum-4-qtrs.csv
21 https://data.chhs.ca.gov/dataset/pre-2012-hospital-quarterly-financial-utilization-report-sum-of-four-quarters
8 2018_r4_q2.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/054fa9c1-bdb7-41d7-8f15-0615155fd42e/download/2018_r4_q2.csv
8 2019_r4_q1.xls https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/1e1d503c-b594-4316-be11-4472df8a0a06/download/2019_r4_q1.xls
8 2013q1r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/ebd360c0-ae72-46d3-902a-d4a64d89f56c/download/2013q1r4-sum-4-qtrs.csv
53 2023_r4_q2.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/b85f305a-c14e-44d4-a8d6-8fc25f7a05fa/download/2023_r4_q2.xlsx
57 hospital-quarterly-financial-utilization-report-sum-of-four-quarters-gewsed.zip https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/bd0e8a42-b279-41bd-b904-0015d6f5f9d6/download/hospital-quarterly-financial-utilization-report-sum-of-four-quarters-gewsed.zip
8 2015q4r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/42fe0140-aea9-4512-9923-9fc255559184/download/2015q4r4-sum-4-qtrs.csv
53 hospital-quarterly-sum-of-qtrs-2012q4r4-revised-115.xls https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/8be96780-2be2-455a-a358-cfa85451c6c4/download/hospital-quarterly-sum-of-qtrs-2012q4r4-revised-115.xls
33 for 2015 and after https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/bdd6e94d-2b10-4efa-8bb8-866e2ec07b14/download/qfur2015afterdoc.pdf
53 2021_r4_q3.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/eb6d7fb1-8c2f-42bd-a9d5-f568d5ec611b/download/2021_r4_q3.xlsx
8 2018_r4_q4.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/ac938f5f-bb8c-497d-ad45-8acb94e1faf6/download/2018_r4_q4.csv
8 2015q2r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/f0993819-78a1-4f90-be75-56928dc2539e/download/2015q2r4-sum-4-qtrs.csv
57 hospital-quarterly-financial-utilization-report-sum-of-four-quarters-jyuqrqpf.zip https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/bd0e8a42-b279-41bd-b904-0015d6f5f9d6/download/hospital-quarterly-financial-utilization-report-sum-of-four-quarters-jyuqrqpf.zip
8 2017q1r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/c5daf568-9c8f-44a8-8a0a-0af2a6d94f6f/download/2017q1r4-sum-4-qtrs.csv
8 2018_r4_q3.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/61ecfe64-46d2-4c8d-b823-832d8259d6b0/download/2018_r4_q3.csv
53 2022_r4_q3.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/12751526-4930-49ab-856e-f16143d17e74/download/2022_r4_q3.xlsx
33 For quarters ended 2024 and after. https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/cbf8873c-40e5-4146-82cd-aea6c0b2158f/download/qfur2024afterdoc.pdf
33 For quarters ended 2015-2023 https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/3a9f110e-7c10-40f4-be5a-c8925bcbf7be/download/qfur2015-2023doc.pdf
8 2017q3r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/c784ebf7-80a3-4a90-880c-5b1fc0bb25bc/download/2017q3r4-sum-4-qtrs.csv
53 2023_r4_q4.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/26ac277c-a4f4-41a0-a51a-5f0a079b774c/download/2023_r4_q4.xlsx
53 2020_r4_q3.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/47ff04f7-7c7b-41aa-9cbe-f77606842ef8/download/2020_r4_q3.xlsx
8 2014q2r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/f77cb368-bedc-429e-bae0-01a34a763561/download/2014q2r4-sum-4-qtrs.csv
53 hospital-quarterly-sum-of-qtrs-2012q3r4.xls https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/50c00a87-f281-4c9f-ab58-177617b00ca7/download/hospital-quarterly-sum-of-qtrs-2012q3r4.xls
53 hospital-quarterly-sum-of-qtrs-2012q2r4.xls https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/b8e51e9d-784e-4af4-948c-b0eaf30044a0/download/hospital-quarterly-sum-of-qtrs-2012q2r4.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
57 hospital-quarterly-financial-utilization-report-sum-of-four-quarters-3le9qtaf.zip https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/bd0e8a42-b279-41bd-b904-0015d6f5f9d6/download/hospital-quarterly-financial-utilization-report-sum-of-four-quarters-3le9qtaf.zip
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/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/0c8d8f2c-2d1d-45cb-88bb-d68834ec42d6/download/data-importing-instructions-for-excel.docx
8 2025_r4_q1.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/41df82b8-3972-432c-b9d4-d385bda59592/download/2025_r4_q1.xlsx
53 2024_r4_q4.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/ec8ec509-e5c6-47c4-9634-47e4b921efaa/download/2024_r4_q4.xlsx
53 2023_r4_q3.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/d99dba44-6647-4dc9-b7c2-a06218c207c8/download/2023_r4_q3.xlsx
53 2022_r4_q4.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/b197e85d-426d-4b27-874f-6f13907df425/download/2022_r4_q4.xlsx
53 2022_r4_q2.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/989db20f-3e96-4e22-98cf-c726f8ed7d1d/download/2022_r4_q2.xlsx
53 2021_r4_q4.xlsx https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/ad114e22-c434-4bb2-9be6-79778289be57/download/2021_r4_q4.xlsx
8 2019_r4_q3.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/50db5d3f-8962-4a76-b513-d7e20025247d/download/2019_r4_q3.csv
8 2013q4r4-sum-4-qtrs.csv https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/f1d47400-6a5c-4584-b0ae-45e5eb30bc1b/download/2013q4r4-sum-4-qtrs.csv
53 hospital-quarterly-sum-of-qtrs-2011q1r4.xls https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/d0bb5f6d-1c40-4b06-bf3d-ccbf3fa787da/download/hospital-quarterly-sum-of-qtrs-2011q1r4.xls
57 hospital-quarterly-financial-utilization-report-sum-of-four-quarters-f4u4n0u4.zip https://data.chhs.ca.gov/dataset/4f757519-b1a4-49f8-9dfa-b4d95e20f8ed/resource/bd0e8a42-b279-41bd-b904-0015d6f5f9d6/download/hospital-quarterly-financial-utilization-report-sum-of-four-quarters-f4u4n0u4.zip

Tags

  • utilization
  • expenses
  • revenues
  • department-of-health-care-access-and-information
  • quarterly-financial-and-utilization-report
  • ogi
  • hospital

Topics

Categories