Return to search results
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.
Resources
55 resources available
-
Pre-2012 Hospital Annual Financial Data - Selected Data & Pivot Tables
HTML -
2017 Pivot Table - Hospital Annual Selected File (October 2019 Extract)
XLS -
2017 - 2018 FY Hospital Annual Selected File (April 2020 Extract)
XLSX -
2016 - 2017 FY Hospital Annual Selected File (April 2019 Extract)
XLS -
2018 CY Hospital Annual Selected File (November 2020 Extract)
XLSX -
2019 Pivot Table - Hospital Annual Selected File (April 2022 Extract)
XLS -
2018 Pivot Table - Hospital Annual Selected File (November 2020 Extract)
XLS -
2012 - 2016 Hospital Trends Pivot
XLS -
2016 Pivot Table - Hospital Annual Selected File (September 2018 Extract)
XLSX -
2021-2022 FY Hospital Annual Selected File (October 2024 Extract)
XLSX -
2013 - 2014 FY Hospital Annual Selected File (September 2015 Extract)
XLSX -
2015 CY Hospital Annual Selected File (March 2018 Extract)
XLSX -
2012-2013 FY Hospital Annual Selected File (June 2014 Extract)
XLSX -
2012 - 2017 CY Hospital Annual Selected File (Machine-Readable format)
CSV -
2022 Pivot Table - Hospital Annual Selected File (October 2024 Extract)
XLS -
2016 CY Hospital Annual Selected File (September 2018 Extract)
XLSX -
2021 Pivot Table - Hospital Annual Selected File (October 2023 Extract)
XLS -
2015 - 2016 FY Hospital Annual Selected File (September 2018 Extract)
XLSX -
2013 Pivot Table Hospital Annual Selected File
XLSX -
2021 Pivot Table - Hospital Annual Selected File (April 2023 Extract)
XLS -
2020 Pivot Table - Hospital Annual Selected File (October 2022 Extract)
XLS -
2014 - 2015 FY Hospital Annual Selected File (April 2017 Extract)
XLSX -
2013 - 2017 Hospital Trends Pivot (October 2019 Extract)
XLS -
2015 - 2019 Hospital Trends Pivot (April 2022 Extract)
XLS -
2014 - 2018 Hospital Trends Pivot (May 2021 Extract)
XLS -
2014 Pivot Table Hospital Annual Selected File
XLSX -
2019-2020 FY Hospital Annual Selected File (April 2022 Extract)
XLSX -
2020 CY Hospital Annual Selected File (October 2022 Extract)
XLSX -
2017 CY Hospital Annual Selected File (October 2019 Extract)
XLSX -
2018-2019 FY Hospital Annual Selected File (May 2021 Extract)
XLSX -
2014 CY Hospital Annual Selected File (April 2017 Extract)
XLSX -
2012 CY Hospital Annual Selected File (October 2014 Extract)
XLSX -
2019 CY Hospital Annual Selected File (April 2022 Extract)
XLSX -
2012 Pivot Table Hospital Annual Selected File
XLS -
2021 CY Hospital Annual Selected File (October 2023 Extract)
XLSX -
2023-2024 FY Hospital Annual Selected File (October 2025 Extract)
XLSX -
2022 CY Hospital Annual Selected File (October 2024 Extract)
XLSX -
2013 CY Hospital Annual Selected File (September 2014 Extract)
XLSX -
2022-2023 FY Hospital Annual Selected File (October 2025 Extract)
XLSX -
2020-2021 FY Hospital Annual Selected File (October 2022 Extract)
XLSX -
2023 CY Hospital Annual Selected File (October 2025 Extract)
XLSX -
2015 Pivot Table Hospital Annual Selected File
XLSX -
2023 Pivot Table - Hospital Annual Selected File (October 2025 Extract)
XLSM -
2024 Pivot Table - Hospital Annual Selected File (October 2025 Extract)
XLSM -
Data Dictionary - 2023 CY Hospital Annual Selected File (October 2025 Extract)
CSV -
Individual Facility Report Search (SIERA)
DATA -
Data Importing Instructions for Excel
DOC -
2015 - 2019 Hospital Trends Charts (April 2022 Extract)
PDF -
2024 CY Hospital Annual Selected File (October 2025 Extract)
XLSX -
All resource data
ZIP -
Hospital Annual Selected File - Documentation
PDF -
2013 - 2017 Hospital Trends Charts (October 2019 Extract)
PDF -
Hospital Trends Glossary
PDF -
2014 - 2018 Hospital Trends Charts (May 2021 Extract)
PDF -
2012 - 2016 Hospital Trends Charts
PDF
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| contactPoint |
{
"fn": "Accounting and Reporting Systems Section",
"@type": "vcard:Contact",
"hasEmail": "mailto:dataandreports@hcai.ca.gov"
}
|
| 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. |
| distribution |
[
{
"@type": "dcat:Distribution",
"title": "Pre-2012 Hospital Annual Financial Data - Selected Data & Pivot Tables",
"format": "HTML",
"accessURL": "https://data.chhs.ca.gov/dataset/pre-2012-hospital-annual-financial-data-selected-data-pivot-tables?__no_cache__=True"
},
{
"@type": "dcat:Distribution",
"title": "2017 Pivot Table - Hospital Annual Selected File (October 2019 Extract)",
"format": "XLS",
"mediaType": "application/vnd.ms-excel",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=009fa104-696a-4446-a626-f6d73ba86380&limit=0",
"description": "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",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/42be7a51-1a40-4b12-9513-904562db0de6/download/hafd2017pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2017 - 2018 FY Hospital Annual Selected File (April 2020 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=010e029b-99b9-4336-bdb8-2a0212234d0f&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/6d971588-0321-410f-8def-6ac2eacbb682/download/hadr-17-18.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2016 - 2017 FY Hospital Annual Selected File (April 2019 Extract)",
"format": "XLS",
"mediaType": "application/vnd.ms-excel",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=134a0554-383f-4fb1-813a-1cebd523312e&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/30a68091-5935-4811-bc9a-1682f5d06a22/download/hadr-2016-2017.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2018 CY Hospital Annual Selected File (November 2020 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=14a57de9-08bc-46a3-a09c-b7572b0c1617&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/efcd34e6-5718-4457-92fb-786f753cabdf/download/hadr-18.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2019 Pivot Table - Hospital Annual Selected File (April 2022 Extract)",
"format": "XLS",
"mediaType": "application/vnd.ms-excel",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=1b89e9b8-a1c2-4b38-bd1b-5251778bf40c&limit=0",
"description": "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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/84d0a088-3689-40b4-ab82-6b04e8c0b213/download/hafd2019pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2018 Pivot Table - Hospital Annual Selected File (November 2020 Extract)",
"format": "XLS",
"mediaType": "application/vnd.ms-excel",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=1dd24045-9ad0-4c35-b39b-3416e5a4bf05&limit=0",
"description": "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",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/6c6d350a-3de1-41ac-890e-874a61e1d997/download/hafd2018pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2012 - 2016 Hospital Trends Pivot",
"format": "XLS",
"mediaType": "application/vnd.ms-excel",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=22c33708-1a72-4557-a1e3-4379b4c3b11e&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/882faca2-49ea-44b1-83cb-c904af145210/download/2012-2016-hospital-trends-pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2016 Pivot Table - Hospital Annual Selected File (September 2018 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=3739c47d-4296-4810-abad-c9e686f3fc66&limit=0",
"description": "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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/e7d882f8-ff3d-48a2-ac71-44ce0091bf47/download/hafd2016pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2021-2022 FY Hospital Annual Selected File (October 2024 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=38814c09-f335-407a-a164-a2ff34c9f2fb&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/a6745a1c-7edb-47b2-a483-cd003a6293e5/download/hadr-2021-2022.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2013 - 2014 FY Hospital Annual Selected File (September 2015 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=3fe620b8-fe76-471f-8317-cd78c4fd9103&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/46f11db1-ccae-4b0c-b07c-2c7b34fdd677/download/hafd1314-092015-extract.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2015 CY Hospital Annual Selected File (March 2018 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=4587bae8-60ba-4ecf-afe6-0b82b907c1c6&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/048d9f12-a0f1-4bd7-a117-d5455b05ab4d/download/hafd15-32018-extract.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2012-2013 FY Hospital Annual Selected File (June 2014 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=49701b4f-9a4d-4f41-9d1d-9a1f777d72b8&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/f1b6a613-a4d9-4e70-a6d5-f34bbb1a5248/download/hafd1213-062014-extract.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2012 - 2017 CY Hospital Annual Selected File (Machine-Readable format)",
"format": "CSV",
"mediaType": "text/csv",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=50114563-deae-4fcb-8900-9533f9d59f8f&limit=0",
"description": "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)",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/81602900-aa04-4fcb-b70b-19bc0553f79b/download/selected-file_2012_2017_machinereadable.csv",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2022 Pivot Table - Hospital Annual Selected File (October 2024 Extract)",
"format": "XLS",
"mediaType": "application/vnd.ms-excel",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=5312b1a3-1deb-4857-bcd9-57f650c0c39b&limit=0",
"description": "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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/e6a7cc46-836f-4437-8ad1-e485d6ea0514/download/hafd2022pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2016 CY Hospital Annual Selected File (September 2018 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=54bc1fe2-96cc-47b6-bd92-91a928b3baf0&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/71c967e3-baf2-42b8-a0fa-b7c73500971e/download/hadf16-_092018.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2021 Pivot Table - Hospital Annual Selected File (October 2023 Extract)",
"format": "XLS",
"mediaType": "application/vnd.ms-excel",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=54e88af2-159a-473f-a8ea-1cca238876a5&limit=0",
"description": "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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/29bacfe7-a98d-4183-9282-a5803a3d4c6e/download/hafd2021-pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2015 - 2016 FY Hospital Annual Selected File (September 2018 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=5df36683-380f-4b96-80f7-8d215bf8f92f&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/0417f024-e604-45c9-9a7f-27f3c7947af7/download/hafd1516_092018.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2013 Pivot Table Hospital Annual Selected File",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=6e1050de-9c00-4a74-a501-2e2e9db964f8&limit=0",
"description": "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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/b83cd02b-5b4f-41bb-8fd3-6e3b320db231/download/hafd2013pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2021 Pivot Table - Hospital Annual Selected File (April 2023 Extract)",
"format": "XLS",
"mediaType": "application/vnd.ms-excel",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=779d33d3-9689-43f0-9152-a2e9f6804a31&limit=0",
"description": "Archive version retained for SB 525 (2023) hospital list requirements.",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/70fae5b8-7ba2-423c-a3d3-ffd5e7b036e3/download/hafd2021-pivot_april-2023-extract.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2020 Pivot Table - Hospital Annual Selected File (October 2022 Extract)",
"format": "XLS",
"mediaType": "application/vnd.ms-excel",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=783f29bd-cdb0-4751-a3b5-67d4834e6f20&limit=0",
"description": "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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/e9f12f88-8909-44f4-b888-deaa1ab1ffe7/download/hafd2020-pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2014 - 2015 FY Hospital Annual Selected File (April 2017 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=79031e68-7adb-434b-ad42-0e65e7090b7e&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/edbf3b2f-4e84-40ef-9859-ddd9ebca9d41/download/hafd1415-042017-extract.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2013 - 2017 Hospital Trends Pivot (October 2019 Extract)",
"format": "XLS",
"mediaType": "application/vnd.ms-excel",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=83df99ad-e965-4a5c-b761-5c12cb6ccdce&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/3b3127df-82bd-49c7-afef-409e5285ef69/download/2013-2017-hospital-trends-pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2015 - 2019 Hospital Trends Pivot (April 2022 Extract)",
"format": "XLS",
"mediaType": "application/vnd.ms-excel",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=83ea9f3e-e5cc-46db-9333-a0a8e346f242&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/55a80dcf-da3b-4616-806b-53ce44d93f7d/download/2015-2019-hospital-trends-pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2014 - 2018 Hospital Trends Pivot (May 2021 Extract)",
"format": "XLS",
"mediaType": "application/vnd.ms-excel",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=897f48ee-9c03-4ec2-8ed2-ff1e6f09eb12&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/ec126df1-4eea-4289-b8d7-8e6739a40183/download/2014-2018-hospital-trends-pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2014 Pivot Table Hospital Annual Selected File",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=936b87b2-7f9d-40ff-b4ac-673659d9ee1c&limit=0",
"description": "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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/133a9bb9-a228-4470-9b75-0510368f666c/download/hafd2014pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2019-2020 FY Hospital Annual Selected File (April 2022 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=988f8a51-def3-4410-8bd3-1803c5763d16&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/f1aaf6ec-f9f0-4c24-bacf-83882c29728a/download/hadr-19-20.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2020 CY Hospital Annual Selected File (October 2022 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=9a045971-e48b-42d2-9009-3ecb1ef8f939&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/95614502-4a18-4c0a-a820-a780f4a7f1a2/download/hadr-20.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2017 CY Hospital Annual Selected File (October 2019 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=a0d9812e-54d8-4df0-b1a1-d2110f1386de&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/7f253787-c4e9-472c-a2e9-892ef8f34900/download/hadr-17.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2018-2019 FY Hospital Annual Selected File (May 2021 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=a285a474-2433-4f05-9cb9-faf5885217dd&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/e2b51a4b-62a1-4af4-8f15-52422deabad5/download/hadr-18-19.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2014 CY Hospital Annual Selected File (April 2017 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=a7052bb8-93a2-4ca0-893e-4fe6e2b0429e&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/cea4b41a-5d9d-4898-b0aa-fad2aabbc132/download/hafd14-42017-extract.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2012 CY Hospital Annual Selected File (October 2014 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=a97784d5-2208-45e3-878a-b7a3ffb4464d&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/3721ee6a-3dbb-48d9-9011-ee116f0d7afe/download/hafd12-10-2014-extract.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2019 CY Hospital Annual Selected File (April 2022 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=ab1d9248-e310-465c-8a93-736d20079083&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/c09beb74-f89f-49a7-b296-bb2fb46331d3/download/hadr-19.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2012 Pivot Table Hospital Annual Selected File",
"format": "XLS",
"mediaType": "application/vnd.ms-excel",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=b6bb5e54-98f2-4800-9db0-6a26ebebea3e&limit=0",
"description": "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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/947eed6f-10f9-4424-9ce9-951dd0d4f954/download/hafd2012pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2021 CY Hospital Annual Selected File (October 2023 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=bb8b6737-f83d-45bb-b656-8dfaf483585e&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/48e753b3-db5a-4ddf-b88c-3a726e13b5e3/download/hadr-21.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2023-2024 FY Hospital Annual Selected File (October 2025 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=bc554c1f-560b-4555-b2a0-9ff99570a89e&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/304eec12-4282-407c-8db7-6b780cceaadf/download/hadr-2023-2024.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2022 CY Hospital Annual Selected File (October 2024 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=c333ad60-3007-4a4c-8e1c-b4a8bc7e453e&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/28df017b-7693-4d83-b105-69eeca4a12e0/download/hadr-2022.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2013 CY Hospital Annual Selected File (September 2014 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=c6ea34af-ae36-407f-ab0f-3ddb6d453787&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/0e6d1890-ca81-49cf-af9e-4b9f64eecdc2/download/hafd13-92015-extract.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2022-2023 FY Hospital Annual Selected File (October 2025 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=d44c4778-097e-4719-afff-eb7e7ddbaf69&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/7ce592fc-88da-4a72-9ec8-60f0efa6c844/download/hadr-2022-2023.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2020-2021 FY Hospital Annual Selected File (October 2022 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=d8fba98b-6204-43e5-85e0-5dab7c53dfaa&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/d30305d9-b150-43fb-8d99-2189fe5af87d/download/hadr-20-21.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2023 CY Hospital Annual Selected File (October 2025 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=e0034e54-db36-4564-8caf-747be662ade9&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/244efb23-daf0-4137-9609-1bc25e4612b8/download/hadr-2023.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2015 Pivot Table Hospital Annual Selected File",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=eaccd068-63f2-4d30-8854-1a110a35a0b5&limit=0",
"description": "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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/18ab3d0f-2281-404b-8bf1-e4d296995cc6/download/hafd2015pivot.xls",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "2023 Pivot Table - Hospital Annual Selected File (October 2025 Extract)",
"format": "XLSM",
"mediaType": "application/vnd.ms-excel.sheet.macroEnabled.12",
"description": "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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/879f1a0c-c476-4248-bdae-0c883d02e5a0/download/hafd2023pivot.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "2024 Pivot Table - Hospital Annual Selected File (October 2025 Extract)",
"format": "XLSM",
"mediaType": "application/vnd.ms-excel.sheet.macroEnabled.12",
"description": "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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/bd8a9580-0d34-4f70-bb9e-7feb56a43eff/download/hafd2024pivot.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "Data Dictionary - 2023 CY Hospital Annual Selected File (October 2025 Extract)",
"format": "CSV",
"mediaType": "text/csv",
"description": "Data Dictionary for https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/244efb23-daf0-4137-9609-1bc25e4612b8/download/hadr-2023.xlsx",
"downloadURL": "https://data.ca.gov/datastore/dictionary_download/e0034e54-db36-4564-8caf-747be662ade9",
"isDataDictionary": true
},
{
"@type": "dcat:Distribution",
"title": "Individual Facility Report Search (SIERA)",
"format": "data",
"mediaType": "application/octet-stream",
"description": "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.",
"downloadURL": "https://siera.oshpd.ca.gov/FinancialDisclosure.aspx"
},
{
"@type": "dcat:Distribution",
"title": "Data Importing Instructions for Excel",
"format": "DOC",
"mediaType": "application/msword",
"description": "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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/1664fdb7-0b40-450e-8257-1b355884fb26/download/data-importing-instructions-for-excel.docx"
},
{
"@type": "dcat:Distribution",
"title": "2015 - 2019 Hospital Trends Charts (April 2022 Extract)",
"format": "PDF",
"mediaType": "application/pdf",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/0e1a9d04-d47c-46f5-9f68-67435eed62f9/download/2015-2019-hospital-trends-charts.pdf"
},
{
"@type": "dcat:Distribution",
"title": "2024 CY Hospital Annual Selected File (October 2025 Extract)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/3969a3b0-ec23-4962-b09d-89840a326b44/download/hadr-2024.xlsx"
},
{
"@type": "dcat:Distribution",
"title": "All resource data",
"format": "ZIP",
"mediaType": "application/zip",
"downloadURL": "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-p5t4_cgt.zip"
},
{
"@type": "dcat:Distribution",
"title": "Hospital Annual Selected File - Documentation",
"format": "PDF",
"mediaType": "application/pdf",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/842c8bcb-bfac-4aa9-9de8-b11eb049f6de/download/hafdselectedfiledoc2004.pdf"
},
{
"@type": "dcat:Distribution",
"title": "2013 - 2017 Hospital Trends Charts (October 2019 Extract)",
"format": "PDF",
"mediaType": "application/pdf",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/8981f51f-e2fa-467a-a4d5-55721ac1ac22/download/2013-2017-hospital-trends-charts.pdf"
},
{
"@type": "dcat:Distribution",
"title": "Hospital Trends Glossary",
"format": "PDF",
"mediaType": "application/pdf",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/9cfde79f-b156-4d3b-9ca9-8916b05e9a65/download/2012-2016-hospital-trends-glossary.pdf"
},
{
"@type": "dcat:Distribution",
"title": "2014 - 2018 Hospital Trends Charts (May 2021 Extract)",
"format": "PDF",
"mediaType": "application/pdf",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/baa572d1-0fde-4ebb-b734-c6588c50e3c5/download/2014-2018-hospital-trends-charts.pdf"
},
{
"@type": "dcat:Distribution",
"title": "2012 - 2016 Hospital Trends Charts",
"format": "PDF",
"mediaType": "application/pdf",
"downloadURL": "https://data.chhs.ca.gov/dataset/ea0c8ca9-023e-46a3-b95b-b9d4ab8ec195/resource/cebcc1d8-108b-438a-86e9-30605a9c11c7/download/2012-2016-hospital-trends-charts.pdf"
}
]
|
| identifier | 08590a2d-7630-4de3-b0f7-19b111edf82c |
| issued | 2018-05-03T16:06:24.195629 |
| keyword |
[
"ALOS",
"FTE",
"assets",
"average length of stay",
"beds",
"cost center",
"department of health care access and information",
"discharges",
"discharges by payer source",
"equity",
"expenses",
"financial ratios",
"hospital",
"income statement",
"labor",
"liabilities",
"net income",
"ogi",
"per adjusted patient day",
"productive hours",
"revenue",
"uncompensated care costs"
]
|
| license | http://www.opendefinition.org/licenses/cc-by |
| modified | 2025-10-08T19:46:27.785913 |
| publisher |
{
"name": "Department of Health Care Access and Information",
"@type": "org:Organization"
}
|
| theme |
[
"Health and Human Services"
]
|
| title | Hospital Annual Financial Data - Selected Data & Pivot Tables |
