Hospital Annual Utilization Report & Pivot Tables

Description

The complete data set of annual utilization data reported by hospitals contains basic licensing information including bed classifications; patient demographics including occupancy rates, the number of discharges and patient days by bed classification, and the number of live births; as well as information on the type of services provided including the number of surgical operating rooms, number of surgeries performed (both inpatient and outpatient), the number of cardiovascular procedures performed, and licensed emergency medical services provided.

Resources

Name Format Description Link
33 2022_aur_hosp_form.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/6bee725e-f2d8-4759-9e42-a0061488f766/download/2022_aur_hosp_form.pdf
33 2022_aur_hosp_instruct.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/1dc652a2-4585-470a-8236-58b6872fc9fa/download/2022_aur_hosp_instruct.pdf
33 2021_aur_hosp_form.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/a046c2e5-6067-46d0-bb6f-8c9ba6d7fb5b/download/2021_aur_hosp_form.pdf
33 2021_aur_hosp_instruct.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/a8a76c64-bffb-4894-98ca-a4c2fc43db7d/download/2021_aur_hosp_instruct.pdf
33 2020_aur_hosp_form.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/d71434db-9adc-4537-8295-715fb955d8cb/download/2020_aur_hosp_form.pdf
33 2020_aur_hosp_instruct.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/37008ff2-de72-4f2b-b8bc-c2142f343ed5/download/2020_aur_hosp_instruct.pdf
33 hosfrm17.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/aa51adcf-5789-4589-9cf0-dac4b7e9aac1/download/hosfrm17.pdf
33 hosinstrct17.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/24f975e6-b4e3-4add-847a-3dd55c46a43f/download/hosinstrct17.pdf
53 hosp16utildatafinal.xlsx https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/115efc1b-0d15-477c-9b89-4617ada14d5f/download/hosp16utildatafinal.xlsx
33 hosfrm15.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/c1ec00af-7f67-409c-b47d-2e2b09900811/download/hosfrm15.pdf
53 hosp15utildatafinal.xlsx https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/830d2ec5-436d-4375-aeb7-0a52d2e4a68e/download/hosp15utildatafinal.xlsx
33 hosfrm14.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/a18c9107-e4c8-42c0-a2ca-f9e93f9e7754/download/hosfrm14.pdf
33 hosinstrct14.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/214a3e88-e63f-4061-a479-6b1c4807397d/download/hosinstrct14.pdf
53 hosp14utildatafinal.xlsx https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/dfd6a52d-c14f-41c1-bbb8-cc93c2893190/download/hosp14utildatafinal.xlsx
33 hosfrm13.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/5409eee8-21d1-4d4a-8a36-479b0ce70f93/download/hosfrm13.pdf
33 hosinstrct13.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/f99effa4-d3b8-4c9b-97a4-dd304d46c93b/download/hosinstrct13.pdf
53 hosp13utildatafinal.xlsx https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/d71c944c-8de0-41f2-b92c-46377f0c5f21/download/hosp13utildatafinal.xlsx
33 hosinstrct16.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/9066799e-394e-40c3-911d-dce47a361341/download/hosinstrct16.pdf
57 hospital-annual-utilization-report-xpyrf7.zip https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/a3fae18e-510d-4cc7-b73d-d0d3537abe3f/download/hospital-annual-utilization-report-xpyrf7.zip
33 hosfrm12.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/b7ae53ce-0f57-43fa-9eb3-7d0848242eda/download/hosfrm12.pdf
33 2023_aur_hosp_instruct.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/9b739643-1581-427a-9b8d-781a94ffa75c/download/2023_aur_hosp_instruct.pdf
33 2019_-instruct_aur_hosp.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/c5b7d5c8-cd85-403f-9963-57a804326a33/download/2019_-instruct_aur_hosp.pdf
33 2018_-instruct_aur_hosp.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/b08eae33-b840-4c84-bfe8-bcb5f8838bdf/download/2018_-instruct_aur_hosp.pdf
33 2023_aur_hosp_form.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/f346f6ef-d027-4df9-be92-4100ec649bf7/download/2023_aur_hosp_form.pdf
53 hosp12utildatafinal.xlsx https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/49b5ebfa-04a7-40b3-9fdf-bcd5270a9802/download/hosp12utildatafinal.xlsx
33 2019_aur_hosp_form.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/e9cf7a2e-1690-4033-9fcc-d16cdad68c86/download/2019_aur_hosp_form.pdf
53 2017_hosp_util_pivot.xlsx https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/54383cf7-fff6-43f9-b953-308f8bd767a5/download/2017_hosp_util_pivot.xlsx
33 hosinstrct12.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/531b0df8-7842-46b2-bdf4-26546ee68681/download/hosinstrct12.pdf
57 hospital-annual-utilization-report-li7v4_b9.zip https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/a3fae18e-510d-4cc7-b73d-d0d3537abe3f/download/hospital-annual-utilization-report-li7v4_b9.zip
33 hosfrm16.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/c4764cd2-6993-431e-8015-3de03ca1cc2a/download/hosfrm16.pdf
53 hosp22_util_data_final_revised_11.28.2023.xlsx https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/2b63a9e4-f695-4ea1-b229-5dff70f04ae8/download/hosp22_util_data_final_revised_11.28.2023.xlsx
33 2018_aur_hosp_form.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/845e3f01-0d14-4194-a527-ecbf59a5bc15/download/2018_aur_hosp_form.pdf
53 Based on the complete Data Set of annual utilization pivot table contains basic licensing information including bed classifications; patient demographics including occupancy rates, the number of discharges and patient days by bed classification, and the number of live births; as well as information on the type of services provided including the number of surgical operating rooms, number of surgeries performed (both inpatient and outpatient), the number of cardiovascular procedures performed, and licensed emergency medical services provided. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/4ee65e8c-ca6e-42d3-9aec-adcc56383856/download/2018_hosp_util_pivot_20191231.xlsx
33 hosinstrct15.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/8ad41ab3-27a3-4875-95e1-b330ba3db072/download/hosinstrct15.pdf
33 2024_aur_hosp_form.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/d032d056-21db-432d-b55b-cb560c6911d0/download/2024_aur_hosp_form.pdf
33 2024_aur_hosp_instruct.pdf https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/67e29d7f-a3b4-44ad-90b3-936959f99fff/download/2024_aur_hosp_instruct.pdf
53 hosp23_util_data_final.xlsx https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/d7b1bd2c-fd8c-4ebe-b1ac-1de197c01e5e/download/hosp23_util_data_final.xlsx
53 Based on the complete Data Set of annual utilization pivot table contains basic licensing information including bed classifications; patient demographics including occupancy rates, the number of discharges and patient days by bed classification, and the number of live births; as well as information on the type of services provided including the number of surgical operating rooms, number of surgeries performed (both inpatient and outpatient), the number of cardiovascular procedures performed, and licensed emergency medical services provided. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/c5d3b100-470b-430e-b5a4-371a33e42292/download/2021_hosp_util_pivot.xlsx
53 Important note about preliminary and final utilization data: Starting with the 2005 annual utilization data file, there will be two phases of data released. The preliminary data file released in the spring will contain data that has passed the prescribed set of fatal errors in the ALIRTS system and was therefore accepted into HCAI. The second data file released in the fall will be the desk-audited data and is considered the final version of the annual utilization data file. Please note that this preliminary set of data will only be live and downloadable on the web page up and to the point that the final version is released and then the preliminary data file will be replaced by the final data file. The pivot tables will be created in the fall for the desk audited data. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/69b3e5b9-6e48-4598-af9e-72cdf4d34134/download/hosp19_util_data_final.xlsx
53 Important note about preliminary and final utilization data: Starting with the 2005 annual utilization data file, there will be two phases of data released. The preliminary data file released in the spring will contain data that has passed the prescribed set of fatal errors in the ALIRTS system and was therefore accepted into HCAI. The second data file released in the fall will be the desk-audited data and is considered the final version of the annual utilization data file. Please note that this preliminary set of data will only be live and downloadable on the web page up and to the point that the final version is released and then the preliminary data file will be replaced by the final data file. The pivot tables will be created in the fall for the desk audited data. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/71b3ecc0-961d-44ff-8f6b-fdaded864380/download/hosp18_util_data_final.xlsx
53 Important note about preliminary and final utilization data: Starting with the 2005 annual utilization data file, there will be two phases of data released. The preliminary data file released in the spring will contain data that has passed the prescribed set of fatal errors in the ALIRTS system and was therefore accepted into HCAI. The second data file released in the fall will be the desk-audited data and is considered the final version of the annual utilization data file. Please note that this preliminary set of data will only be live and downloadable on the web page up and to the point that the final version is released and then the preliminary data file will be replaced by the final data file. The pivot tables will be created in the fall for the desk audited data. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/1f5723e4-9ecd-46ad-ae4f-328b7bc5ec95/download/hosp17_util_data_final.xlsx
53 Based on the complete Data Set of annual utilization pivot table contains basic licensing information including bed classifications; patient demographics including occupancy rates, the number of discharges and patient days by bed classification, and the number of live births; as well as information on the type of services provided including the number of surgical operating rooms, number of surgeries performed (both inpatient and outpatient), the number of cardiovascular procedures performed, and licensed emergency medical services provided. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/0ed0c13c-6471-492a-8b7c-a2637458f3f6/download/2015hosputilpivot20161230.xlsm
53 Based on the complete Data Set of annual utilization pivot table contains basic licensing information including bed classifications; patient demographics including occupancy rates, the number of discharges and patient days by bed classification, and the number of live births; as well as information on the type of services provided including the number of surgical operating rooms, number of surgeries performed (both inpatient and outpatient), the number of cardiovascular procedures performed, and licensed emergency medical services provided. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/17472681-117c-4b97-87eb-a5d15957a8aa/download/2014hosputilpivot8-10.xlsm
0 The Automated Licensing Information and Report Tracking System (ALIRTS) contains license and utilization data information of healthcare facilities in California. https://lfis.hcai.ca.gov/
10 data-importing-instructions-for-excel.docx https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/8919688d-ff9d-45ba-9e70-0de95c7da3d5/download/data-importing-instructions-for-excel.docx
53 hosp24_util_data_prelim.xlsx https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/e4f70066-c0ca-40f9-8f54-0ea033f900d9/download/hosp24_util_data_prelim.xlsx
53 Based on the complete Data Set of annual utilization pivot table contains basic licensing information including bed classifications; patient demographics including occupancy rates, the number of discharges and patient days by bed classification; as well as information on the type of services provided including the number of surgical operating rooms, number of surgeries performed (both inpatient and outpatient), the number of cardiovascular procedures performed, and licensed emergency medical services provided. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/dfb5fe7b-35a4-4478-adf7-9a5736aaf216/download/hosp_util_pivot_2023.xlsx
53 Based on the complete Data Set of annual utilization pivot table contains basic licensing information including bed classifications; patient demographics including occupancy rates, the number of discharges and patient days by bed classification; as well as information on the type of services provided including the number of surgical operating rooms, number of surgeries performed (both inpatient and outpatient), the number of cardiovascular procedures performed, and licensed emergency medical services provided. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/6af715ad-0de7-4b85-bd59-2746016ced2b/download/2022_hosp_util_pivot.xlsx
53 Important note about preliminary and final utilization data: Starting with the 2005 annual utilization data file, there will be two phases of data released. The preliminary data file released in the spring will contain data that has passed the prescribed set of fatal errors in the ALIRTS system and was therefore accepted into HCAI. The second data file released in the fall will be the desk-audited data and is considered the final version of the annual utilization data file. Please note that this preliminary set of data will only be live and downloadable on the web page up and to the point that the final version is released and then the preliminary data file will be replaced by the final data file. The pivot tables will be created in the fall for the desk audited data. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/e2ef5e5a-1dbc-4b67-894f-5bad34b79798/download/hosp21_util_data_final-revised-06.15.2023.xlsx
53 Important note about preliminary and final utilization data: Starting with the 2005 annual utilization data file, there will be two phases of data released. The preliminary data file released in the spring will contain data that has passed the prescribed set of fatal errors in the ALIRTS system and was therefore accepted into HCAI. The second data file released in the fall will be the desk-audited data and is considered the final version of the annual utilization data file. Please note that this preliminary set of data will only be live and downloadable on the web page up and to the point that the final version is released and then the preliminary data file will be replaced by the final data file. The pivot tables will be created in the fall for the desk audited data. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/9916ce3d-9158-4b0e-9109-4f7bde9b40eb/download/hosp20_util_data_final-revised-06.15.2023.xlsx
53 Based on the complete Data Set of annual utilization pivot table contains basic licensing information including bed classifications; patient demographics including occupancy rates, the number of discharges and patient days by bed classification, and the number of live births; as well as information on the type of services provided including the number of surgical operating rooms, number of surgeries performed (both inpatient and outpatient), the number of cardiovascular procedures performed, and licensed emergency medical services provided. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/19a02e57-a4d1-408c-9ec9-dd3c56f7a0ca/download/2020_hosp_util_pivot.xlsx
53 2019_hosp_util_pivot.xlsx https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/144b3a4f-2fda-44bb-9934-bc5d17b29176/download/2019_hosp_util_pivot.xlsx
8 This is a machine-readable format. Preliminary data will not be included in this data resource - only final desk-audited data will be included. Important note about preliminary and final utilization data: Starting with the 2005 annual utilization data file, there will be two phases of data released. The preliminary data file released in the spring will contain data that has passed the prescribed set of fatal errors in the ALIRTS system and was therefore accepted into HCAI. The second data file released in the fall will be the desk-audited data and is considered the final version of the annual utilization data file. Please note that this preliminary set of data will only be live and downloadable on the web page up and to the point that the final version is released and then the preliminary data file will be replaced by the final data file. The pivot tables will be created in the fall for the desk audited data. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/78622c04-a158-4c95-8ea3-7660725e9526/download/2012_current_year_hosp_util_mr.csv
53 Based on the complete Data Set of annual utilization pivot table contains basic licensing information including bed classifications; patient demographics including occupancy rates, the number of discharges and patient days by bed classification, and the number of live births; as well as information on the type of services provided including the number of surgical operating rooms, number of surgeries performed (both inpatient and outpatient), the number of cardiovascular procedures performed, and licensed emergency medical services provided. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/14c55276-0026-4b43-87d2-d5ba6196ef53/download/2016hosputilpivot.xlsm
53 Based on the complete Data Set of annual utilization pivot table contains basic licensing information including bed classifications; patient demographics including occupancy rates, the number of discharges and patient days by bed classification, and the number of live births; as well as information on the type of services provided including the number of surgical operating rooms, number of surgeries performed (both inpatient and outpatient), the number of cardiovascular procedures performed, and licensed emergency medical services provided. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/d527cab8-83c4-4d54-b2d5-bcd8a817faa8/download/auhr2013profile.xlsm
53 Based on the complete Data Set of annual utilization pivot table contains basic licensing information including bed classifications; patient demographics including occupancy rates, the number of discharges and patient days by bed classification, and the number of live births; as well as information on the type of services provided including the number of surgical operating rooms, number of surgeries performed (both inpatient and outpatient), the number of cardiovascular procedures performed, and licensed emergency medical services provided. https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/98f94d11-8f15-4892-84cb-4a9a6eaa0e71/download/auhr2012profile.xlsm
21 Click this link to view pre-2012 data https://data.chhs.ca.gov/dataset/pre-2012-hospital-annual-utilization-report-pivot-tables
57 hospital-annual-utilization-report-_urt02xa.zip https://data.chhs.ca.gov/dataset/1902083c-f16a-434d-b8ac-f7a573a305df/resource/a3fae18e-510d-4cc7-b73d-d0d3537abe3f/download/hospital-annual-utilization-report-_urt02xa.zip

Tags

  • capital
  • patients
  • emergency-room-use
  • equipment
  • er
  • capacity
  • department-of-health-care-access-and-information
  • beds
  • births
  • severity

Topics

Categories