Excel · dataset · 2025
Hospital Annual Financial Data - Selected Data & Pivot Tables
Listed in California Open Data
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.
Description
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.
Read the rest (1 more)
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.
Links
Get the data
- Individual Facility Report Search (SIERA) siera.oshpd.ca.gov/FinancialDisclosure.aspx ↗
download · from data ca gov
- Data Importing Instructions for Excel data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/1664fdb7… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/81602900… ↗
2012 - 2017 CY Hospital Annual Selected File (Machine-Readable format)
download · from data ca gov
- Hospital Annual Selected File - Documentation data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/842c8bcb… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/105ab534… ↗
2024-2025 FY Hospital Annual Selected File (April 2026 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/3969a3b0… ↗
2024 CY Hospital Annual Selected File (April 2026 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/bd8a9580… ↗
2024 Pivot Table - Hospital Annual Selected File (April 2026 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/304eec12… ↗
2023-2024 FY Hospital Annual Selected File (April 2026 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/244efb23… ↗
2023 CY Hospital Annual Selected File (October 2025 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/879f1a0c… ↗
2023 Pivot Table - Hospital Annual Selected File (October 2025 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/7ce592fc… ↗
2022-2023 FY Hospital Annual Selected File (October 2025 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/28df017b… ↗
2022 CY Hospital Annual Selected File (October 2024 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/e6a7cc46… ↗
2022 Pivot Table - Hospital Annual Selected File (October 2024 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/a6745a1c… ↗
2021-2022 FY Hospital Annual Selected File (October 2024 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/48e753b3… ↗
2021 CY Hospital Annual Selected File (October 2023 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/29bacfe7… ↗
2021 Pivot Table - Hospital Annual Selected File (October 2023 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/70fae5b8… ↗
2021 Pivot Table - Hospital Annual Selected File (April 2023 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/d30305d9… ↗
2020-2021 FY Hospital Annual Selected File (October 2022 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/95614502… ↗
2020 CY Hospital Annual Selected File (October 2022 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/e9f12f88… ↗
2020 Pivot Table - Hospital Annual Selected File (October 2022 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/f1aaf6ec… ↗
2019-2020 FY Hospital Annual Selected File (April 2022 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/55a80dcf… ↗
2015 - 2019 Hospital Trends Pivot (April 2022 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/0e1a9d04… ↗
2015 - 2019 Hospital Trends Charts (April 2022 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/c09beb74… ↗
2019 CY Hospital Annual Selected File (April 2022 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/84d0a088… ↗
2019 Pivot Table - Hospital Annual Selected File (April 2022 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/e2b51a4b… ↗
2018-2019 FY Hospital Annual Selected File (May 2021 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/ec126df1… ↗
2014 - 2018 Hospital Trends Pivot (May 2021 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/baa572d1… ↗
2014 - 2018 Hospital Trends Charts (May 2021 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/efcd34e6… ↗
2018 CY Hospital Annual Selected File (November 2020 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/6c6d350a… ↗
2018 Pivot Table - Hospital Annual Selected File (November 2020 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/6d971588… ↗
2017 - 2018 FY Hospital Annual Selected File (April 2020 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/3b3127df… ↗
2013 - 2017 Hospital Trends Pivot (October 2019 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/8981f51f… ↗
2013 - 2017 Hospital Trends Charts (October 2019 Extract)
download · from data ca gov
- Hospital Trends Glossary data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/9cfde79f… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/7f253787… ↗
2017 CY Hospital Annual Selected File (October 2019 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/42be7a51… ↗
2017 Pivot Table - Hospital Annual Selected File (October 2019 Extract)
download · from data ca gov
- 2012 - 2016 Hospital Trends Pivot data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/882faca2… ↗
download · from data ca gov
- 2012 - 2016 Hospital Trends Charts data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/cebcc1d8… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/71c967e3… ↗
2016 CY Hospital Annual Selected File (September 2018 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/e7d882f8… ↗
2016 Pivot Table - Hospital Annual Selected File (September 2018 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/30a68091… ↗
2016 - 2017 FY Hospital Annual Selected File (April 2019 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/048d9f12… ↗
2015 CY Hospital Annual Selected File (March 2018 Extract)
download · from data ca gov
- 2015 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/18ab3d0f… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/0417f024… ↗
2015 - 2016 FY Hospital Annual Selected File (September 2018 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/cea4b41a… ↗
2014 CY Hospital Annual Selected File (April 2017 Extract)
download · from data ca gov
- 2014 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/133a9bb9… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/edbf3b2f… ↗
2014 - 2015 FY Hospital Annual Selected File (April 2017 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/0e6d1890… ↗
2013 CY Hospital Annual Selected File (September 2014 Extract)
download · from data ca gov
- 2013 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/b83cd02b… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/46f11db1… ↗
2013 - 2014 FY Hospital Annual Selected File (September 2015 Extract)
download · from data ca gov
Where it is published
- California Open Data dataset page data.ca.gov/dataset/hospital-annual-financial-data-selected-data-pivot-tab… ↗
landing page · from data ca gov
Documentation and papers
- Publisher page hcai.ca.gov/data-and-reports/cost-transparency/hospital-financials ↗
documentation · from data ca gov
Catalogue records · 1
- CKAN API data.ca.gov/api/3/action/package_show?id=08590a2d-7630-4de3-b0f7-19b111edf… ↗
metadata API · from data ca gov
Topics
- Stated by source
- Health and Human Services
- From keywords
- Economics & Finance · Medicine & Health · Social Science
Provenance · 1 source records, 11 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| California Open Data | 08590a2d-7630-4de3-b0f7-19b111edf82c | 13 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| access_level | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[field].local:field:economics-finance | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[field].local:field:medicine-health | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[field].local:field:social-science | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[topic].ckan_group:data_ca_gov:health-human-services | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| created_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| description | source · data ca gov | connector:data_ca_gov@1.0.0 | /notes |
| license_text | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| publication_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| title | source · data ca gov | connector:data_ca_gov@1.0.0 | /title |
| updated_date | source · data ca gov | connector:data_ca_gov@1.0.0 |