HCUP Summary Trend Tables

The HCUP Summary Trend Tables include monthly information on hospital utilization derived from the HCUP State Inpatient Databases (SID) and HCUP State Emergency Department Databases (SEDD). Information on emergency department (ED) utilization is dependent on availability of HCUP data; not all HCUP Partners participate in the SEDD.

The HCUP Summary Trend Tables include downloadable Microsoft® Excel tables with information on the following topics:


* The Excel files for Tables 3a-3d created on 4/1/2021 (accessible between 4/12/2021 and 5/17/2021) contained data that was displayed incorrectly. Statistics were shifted forward three months (e.g., counts displayed for June 2020 should have been displayed for April 2020). The corrected version of these tables (dated 5/18/2021) are available below.

For each type of inpatient stay, there is an Excel file for the number of discharges, the percent of discharges, the average length of stay, and the in-hospital mortality rate per 100 discharges.1 Within each Excel file there are State-specific worksheets with information on the monthly trends. For most files, the monthly trends begin in January 2017. Also included in each Excel file is a description of the HCUP databases and methodology.

Graphs from HCUP Summary Trend Tables

A focused report with graphs derived from Table 2d displays the monthly trends in the rate of in-hospital mortality per 100 discharges from January 2019 through June 2020 for nine States:


HCUP Summary Trend Tables

The following is a list of the available HCUP Summary Trend Tables. Each table is available for download. A ZIP folder with all tables is also available for download (ZIP File, 38.2 MB).

Overview of Monthly Trends in Inpatient and Emergency Department Utilization

Table 1. Overview of Monthly Trends in Inpatient and Emergency Department Utilization (Excel file, 531 KB)

All Inpatient Encounter Types

Table 2a. All Inpatient Encounter Types: Monthly Trends in the Number of Discharges (Excel file, 1.1 MB)
Table 2b. All Inpatient Encounter Types: Monthly Trends in the Percent of Discharges (Excel file, 1.1 MB)
Table 2c. All Inpatient Encounter Types: Monthly Trends in the Average Length of Stay (Excel file, 1.0 MB)
Table 2d. All Inpatient Encounter Types: Monthly Trends in the In-Hospital Mortality Rate (Excel file, 1.0 MB)

Inpatient Stays by Priority Condition: COVID-19
    The Excel files for Tables 3a-3d created on 4/1/2021 (accessible between 4/12/2021 and 5/17/2021) contained data that was displayed incorrectly. Statistics were shifted forward three months (e.g., counts displayed for June 2020 should have been displayed for April 2020). The corrected version of these tables (dated 5/18/2021) are available below.
Table 3a. Inpatient Stays by Priority Condition of COVID-19: Monthly Trends in the Number of Discharges (Excel file, 198 KB)
Table 3b. Inpatient Stays by Priority Condition of COVID-19: Monthly Trends in the Percent of Discharges (Excel file, 201 KB)
Table 3c. Inpatient Stays by Priority Condition of COVID-19: Monthly Trends in the Average Length of Stay (Excel file, 196 KB)
Table 3d. Inpatient Stays by Priority Condition of COVID-19: Monthly Trends in the In-Hospital Mortality Rate (Excel file, 197 KB)

Inpatient Stays by Priority Condition: Influenza

Table 4a. Inpatient Stays by Priority Condition of Influenza: Monthly Trends in the Number of Discharges (Excel file, 787 KB)
Table 4b. Inpatient Stays by Priority Condition of Influenza: Monthly Trends in the Percent of Discharges (Excel file, 826 KB)
Table 4c. Inpatient Stays by Priority Condition of Influenza: Monthly Trends in the Average Length of Stay (Excel file, 742 KB)
Table 4d. Inpatient Stays by Priority Condition of Influenza: Monthly Trends in the In-Hospital Mortality Rate (Excel file, 741 KB)

Inpatient Stays by Priority Condition: Other Acute or Viral Respiratory Infections

Table 5a. Inpatient Stays by Priority Condition of Other Acute or Viral Respiratory Infections: Monthly Trends in the Number of Discharges (Excel file, 921 KB)
Table 5b. Inpatient Stays by Priority Condition of Other Acute or Viral Respiratory Infections: Monthly Trends in the Percent of Discharges (Excel file, 972 KB)
Table 5c. Inpatient Stays by Priority Condition of Other Acute or Viral Respiratory Infections: Monthly Trends in the Average Length of Stay (Excel file, 875 KB)
Table 5d. Inpatient Stays by Priority Condition of Other Acute or Viral Respiratory Infections: Monthly Trends in the In-Hospital Mortality Rate (Excel file, 893 KB)

Inpatient Encounter Type: Normal Newborns

Table 6a. Inpatient Encounter Type of Normal Newborns: Monthly Trends in the Number of Discharges (Excel file, 808 KB)
Table 6b. Inpatient Encounter Type of Normal Newborns: Monthly Trends in the Percent of Discharges (Excel file, 827 KB)
Table 6c. Inpatient Encounter Type of Normal Newborns: Monthly Trends in the Average Length of Stay (Excel file, 769 KB)


Inpatient Encounter Type: Deliveries

Table 7a. Inpatient Encounter Type of Deliveries: Monthly Trends in the Number of Discharges (Excel file, 831 KB)
Table 7b. Inpatient Encounter Type of Deliveries: Monthly Trends in the Percent of Discharges (Excel file, 844 KB)
Table 7c. Inpatient Encounter Type of Deliveries: Monthly Trends in the Average Length of Stay (Excel file, 793 KB)


Inpatient Encounter Type: Non-Elective Inpatient Stays Admitted Through the ED

Table 8a. Inpatient Encounter Type of Non-Elective Inpatient Stays Admitted Through the ED: Monthly Trends in the Number of Discharges (Excel file, 977 KB)
Table 8b. Inpatient Encounter Type of Non-Elective Inpatient Stays Admitted Through the ED: Monthly Trends in the Percent of Discharges (Excel file, 976 KB)
Table 8c. Inpatient Encounter Type of Non-Elective Inpatient Stays Admitted Through the ED: Monthly Trends in the Average Length of Stay (Excel file, 933 KB)
Table 8d. Inpatient Encounter Type of Non-Elective Inpatient Stays Admitted Through the ED: Monthly Trends in the In-Hospital Mortality Rate (Excel file, 951 KB)

Inpatient Encounter Type: Non-Elective Inpatient Stays Not Admitted Through the ED

Table 9a. Inpatient Encounter Type of Non-Elective Inpatient Stays Not Admitted Through the ED: Monthly Trends in the Number of Discharges (Excel file, 939 KB)
Table 9b. Inpatient Encounter Type of Non-Elective Inpatient Stays Not Admitted Through the ED: Monthly Trends in the Percent of Discharges (Excel file, 974 KB)
Table 9c. Inpatient Encounter Type of Non-Elective Inpatient Stays Not Admitted Through the ED: Monthly Trends in the Average Length of Stay (Excel file, 919 KB)
Table 9d. Inpatient Encounter Type of Non-Elective Inpatient Stays Not Admitted Through the ED: Monthly Trends in the In-Hospital Mortality Rate (Excel file, 922 KB)

Inpatient Encounter Type: Elective Inpatient Stays

Table 10a. Inpatient Encounter Type of Elective Inpatient Stays: Monthly Trends in the Number of Discharges (Excel file, 927 KB)
Table 10b. Inpatient Encounter Type of Elective Inpatient Stays: Monthly Trends in the Percent of Discharges (Excel file, 963 KB)
Table 10c. Inpatient Encounter Type of Elective Inpatient Stays: Monthly Trends in the Average Length of Stay (Excel file, 888 KB)
Table 10d. Inpatient Encounter Type of Elective Inpatient Stays: Monthly Trends in the In-Hospital Mortality Rate (Excel file, 873 KB)

Inpatient Service Line: Maternal and Neonatal Conditions

Table 11a. Inpatient Service Line of Maternal and Neonatal Conditions: Monthly Trends in the Number of Discharges (Excel file, 819 KB)
Table 11b. Inpatient Service Line of Maternal and Neonatal Conditions: Monthly Trends in the Percent of Discharges (Excel file, 824 KB)
Table 11c. Inpatient Service Line of Maternal and Neonatal Conditions: Monthly Trends in the Average Length of Stay (Excel file, 794 KB)


Inpatient Service Line: Mental Health and Substance Use Disorders

Table 12a. Inpatient Service Line of Mental Health and Substance Use Disorders: Monthly Trends in the Number of Discharges (Excel file, 900 KB)
Table 12b. Inpatient Service Line of Mental Health and Substance Use Disorders: Monthly Trends in the Percent of Discharges (Excel file, 958 KB)
Table 12c. Inpatient Service Line of Mental Health and Substance Use Disorders: Monthly Trends in the Average Length of Stay (Excel file, 868 KB)
Table 12d. Inpatient Service Line of Mental Health and Substance Use Disorders: Monthly Trends in the In-Hospital Mortality Rate (Excel file, 792 KB)

Inpatient Service Line: Injuries

Table 13a. Inpatient Service Line of Injuries: Monthly Trends in the Number of Discharges (Excel file, 933 KB)
Table 13b. Inpatient Service Line of Injuries: Monthly Trends in the Percent of Discharges (Excel file, 1.0 MB)
Table 13c. Inpatient Service Line of Injuries: Monthly Trends in the Average Length of Stay (Excel file, 899 KB)
Table 13d. Inpatient Service Line of Injuries: Monthly Trends in the In-Hospital Mortality Rate (Excel file, 911 KB)

Inpatient Service Line: Surgeries

Table 14a. Inpatient Service Line of Surgeries: Monthly Trends in the Number of Discharges (Excel file, 952 KB)
Table 14b. Inpatient Service Line of Surgeries: Monthly Trends in the Percent of Discharges (Excel file, 979 KB)
Table 14c. Inpatient Service Line of Surgeries: Monthly Trends in the Average Length of Stay (Excel file, 923 KB)
Table 14d. Inpatient Service Line of Surgeries: Monthly Trends in the In-Hospital Mortality Rate (Excel file, 917 KB)

Inpatient Service Line: Other Medical Conditions

Table 15a. Inpatient Service Line of Other Medical Conditions: Monthly Trends in the Number of Discharges (Excel file, 981 KB)
Table 15b. Inpatient Service Line of Other Medical Conditions: Monthly Trends in the Percent of Discharges (Excel file, 979 KB)
Table 15c. Inpatient Service Line of Other Medical Conditions: Monthly Trends in the Average Length of Stay (Excel file, 929 KB)
Table 15d. Inpatient Service Line of Other Medical Conditions: Monthly Trends in the In-Hospital Mortality Rate (Excel file, 953 KB)

1 There is no Excel file for the in-hospital morality rate for normal newborns, deliveries, and the service line of maternal and neonatal conditions because the rates are extremely low and have little variability over time.

Internet Citation: HCUP Summary Trend Tables. Healthcare Cost and Utilization Project (HCUP). May 2021. Agency for Healthcare Research and Quality, Rockville, MD. www.hcup-us.ahrq.gov/reports/trendtables/summarytrendtables.jsp.
Are you having problems viewing or printing pages on this website?
If you have comments, suggestions, and/or questions, please contact hcup@ahrq.gov.
Privacy Notice, Viewers & Players
Last modified 5/18/21