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
2015 Calendar Year Hospital Utilization Pivot Table (12-30-2016) XLS 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. Open resource
2016 Calendar Year Hospital Utilization XLS hosp16utildatafinal.xlsx Open resource
2019 Calendar Year Hospital Utilization Pivot Table XLS 2019_hosp_util_pivot.xlsx Open resource
2016 Calendar Year Hospital Utilization Pivot Table XLS 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. Open resource
2014 Calendar Year Hospital Utilization Pivot Table XLS 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. Open resource
2020 Calendar Year Hospital Utilization Pivot Table XLS 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. Open resource
2022 Hospital Utilization Instructions PDF 2022_aur_hosp_instruct.pdf Open resource
2017 Hospital Annual Utilization (October 2018) XLS 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. Open resource
2014 Hospital Utilization Instructions PDF hosinstrct14.pdf Open resource
2017 Hospital Utilization Instructions PDF hosinstrct17.pdf Open resource
2022 Hospital Annual Utilization (Revised 11/28/2023) XLS hosp22_util_data_final_revised_11.28.2023.xlsx Open resource
2020 Hospital Utilization Instructions PDF 2020_aur_hosp_instruct.pdf Open resource
2012 Calendar Year Hospital Utilization XLS hosp12utildatafinal.xlsx Open resource
2018 Calendar Year Hospital Utilization Pivot Table XLS 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. Open resource
2012 Hospital Utilization Instructions PDF hosinstrct12.pdf Open resource
2013 Hospital Utilization Reporting Form PDF hosfrm13.pdf Open resource
2017 Calendar Year Hospital Utilization Pivot Table XLS 2017_hosp_util_pivot.xlsx Open resource
2024 Hospital Utilization Instructions PDF 2024_aur_hosp_instruct.pdf Open resource
2019 Hospital Annual Utilization (November 2020) XLS 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. Open resource
2022 Calendar Year Hospital Utilization Pivot Table XLS 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. Open resource
2022 Hospital Utilization Reporting Form PDF 2022_aur_hosp_form.pdf Open resource
2018 Hospital Annual Utilization (November 2019) XLS 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. Open resource
Hospital Annual Utilization Data - Machine-Readable Format CSV 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. Open resource
2015 Calendar Year Hospital Utilization XLS hosp15utildatafinal.xlsx Open resource
2018 Hospital Utilization Reporting Form PDF 2018_aur_hosp_form.pdf Open resource
Data Importing Instruction for Excel Doc data-importing-instructions-for-excel.docx Open resource
2015 Hospital Utilization Instructions PDF hosinstrct15.pdf Open resource
2016 Hospital Utilization Instructions PDF hosinstrct16.pdf Open resource
2012 Calendar Year Hospital Utilization Pivot Table XLS 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. Open resource
2020 Hospital Annual Utilization (Revised 06/15/2023) XLS 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. Open resource
2023 Hospital Utilization Instructions PDF 2023_aur_hosp_instruct.pdf Open resource
2021 Hospital Utilization Reporting Form PDF 2021_aur_hosp_form.pdf Open resource
2014 Hospital Utilization Reporting Form PDF hosfrm14.pdf Open resource
All resource data ZIP hospital-annual-utilization-report-li7v4_b9.zip Open resource
All resource data ZIP hospital-annual-utilization-report-_urt02xa.zip Open resource
All resource data ZIP hospital-annual-utilization-report-xpyrf7.zip Open resource
2021 Hospital Utilization Instructions PDF 2021_aur_hosp_instruct.pdf Open resource
2017 Hospital Utilization Reporting Form PDF hosfrm17.pdf Open resource
2018 Hospital Utilization Instructions PDF 2018_-instruct_aur_hosp.pdf Open resource
2012 Hospital Utilization Reporting Form PDF hosfrm12.pdf Open resource
2015 Hospital Utilization Reporting Form PDF hosfrm15.pdf Open resource
2016 Hospital Utilization Reporting Form PDF hosfrm16.pdf Open resource
2019 Hospital Utilization Instructions PDF 2019_-instruct_aur_hosp.pdf Open resource
2021 Calendar Year Hospital Utilization Pivot Table XLS 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. Open resource
2024 Hospital Utilization Reporting Form PDF 2024_aur_hosp_form.pdf Open resource
2013 Calendar Year Hospital Utilization Pivot Table XLS 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. Open resource
2020 Hospital Utilization Reporting Form PDF 2020_aur_hosp_form.pdf Open resource
2013 Calendar Year Hospital Utilization XLS hosp13utildatafinal.xlsx Open resource
2023 Hospital Annual Utilization (November 2024) XLS hosp23_util_data_final.xlsx Open resource
2023 Calendar Year Hospital Utilization Pivot Table XLS 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. Open resource
2014 Calendar Year Hospital Utilization XLS hosp14utildatafinal.xlsx Open resource
2021 Hospital Annual Utilization (Revised 06/15/2023) XLS 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. Open resource
2024 Hospital Annual Utilization (Preliminary) XLS hosp24_util_data_prelim.xlsx Open resource
2019 Hospital Utilization Reporting Form PDF 2019_aur_hosp_form.pdf Open resource
2023 Hospital Utilization Reporting Form PDF 2023_aur_hosp_form.pdf Open resource
2013 Hospital Utilization Instructions PDF hosinstrct13.pdf Open resource
Pre-2012 Hospital Annual Utilization Report & Pivot Tables HTML Click this link to view pre-2012 data Open resource
Individual Facility Report Search Tool (ALIRTS) Unknown The Automated Licensing Information and Report Tracking System (ALIRTS) contains license and utilization data information of healthcare facilities in California. Open resource

Tags

Topics

Categories