HCUP State Level Trend Inpatient Stay 2003-2015

$79 / year

The dataset has information on the number of inpatient stays for every available calendar quarter at the level of State, hospitalization type, and expected payer. This results in 36 rows of data per available State.

Complexity

Data for this report were from the HCUP State Inpatient Databases (SID) and quarterly data if available. The unit of analysis is the hospital discharge (i.e., the hospital stay), not a person or patient. This means that a person who is admitted to the hospital multiple times in one year will be counted each time as a separate “discharge” from the hospital. Counts are summarized by discharge quarter. Information based on quarterly data should be considered preliminary. Quarterly data will be replaced by the State’s complete annual SID for the year when it is available. This analysis was limited to patients treated in community, non-rehabilitation hospitals in the State. Discharge counts for inpatient stays excluded transfers out to another acute care hospital.

Adult discharges were categorized into five hospitalization types in the following hierarchical order: maternal, mental health/substance use, injury, surgical, and medical. Medical discharges are identified by a medical DRG. The DRG grouper first assigns the discharge to an MDC based on the principal diagnosis. For each MDC there is a list of procedure codes that qualify as operating room procedures. If the discharge involves an operating room procedure, it is assigned to one of the surgical DRGs within the MDC category; otherwise it is assigned to a medical DRG. If the DRG indicated the information on the record was ungroupable (i.e., not identifiable as medical or surgical), then the discharge was assumed to be medical. This rarely occurred (less than 0.1 percent of total discharges). Available States are participating in both HCUP and the HCUP Fast Stats tool.

Quarterly counts have been rounded up to the nearest 50 inpatient stays. If a cell in the Data worksheet is empty, either the number has been suppressed due to small sample size or the data are unavailable (i.e., not all States have data for all quarters). This file includes all back year data, not all of which will be displayed in HCUP Fast Stats. Discharge counts are adjusted for community, non-rehabilitation hospitals that were not included in the SID or quarterly data. Weighting for missing hospitals used the following information from the American Hospital Association (AHA) Annual Survey of Hospitals to define strata within the State: Ownership (government, private nonprofit, and private investor-owned), Size of the hospital based on the number of beds (small, medium, and large categories defined within region), Location combined with teaching status (rural, urban nonteaching, urban teaching). Counts less than 26 were suppressed for confidentiality and will cause a discontinuity in the trend lines displayed in the figures.

Date Created

2016-03-25

Last Modified

2016-06-20

Version

2016.06

Update Frequency

Never

Temporal Coverage

2003-2015

Spatial Coverage

US

Source

John Snow Labs => Healthcare Cost and Utilization Project

Source License URL

John Snow Labs Standard License

Source License Requirements

N/A

Source Citation

N/A

Keywords

 - Inpatient stay, Lenth of hospital stay, Hospital Observation, Average hopstial stay, Inpatient services, Inpatient admission, Inpatient facility, Inpatient hospital services

Other Titles

Hospital Cost and Utilization Project State Trend Inpatient Stay 2003-2015, Length Of Inpatient Stay State Trend 2003-2015, Statewise Length of stay Inpatient Hospitalization Trend 2003-2015

NameDescriptionTypeConstraints
StateName of the StatestringmaxLength : 14
Hospitalization_TypeType of Hospitalisation uses Coding criteria for the six hospitalization types based on International Classification of Diseases, Ninth Revision, Clinical Modification (ICD-9-CM) diagnosis codes, Clinical Classifications Software (CCS) categories, and diagnosis-related groups (DRGs).stringmaxLength : 27
Expected_PayerThe “expected payer” data element in HCUP databases provides information on the type of payer that the hospital expects to be the source of payment for the hospital bill.stringmaxLength : 9
Y2003_Q1Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2003_Q2Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2003_Q3Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2003_Q4Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2004_Q1Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2004_Q2Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2004_Q3Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2004_Q4Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2005_Q1Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2005_Q2Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2005_Q3Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2005_Q4Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2006_Q1Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2006_Q2Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2006_Q3Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2006_Q4Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2007_Q1Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2007_Q2Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2007_Q3Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2007_Q4Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2008_Q1Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2008_Q2Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2008_Q3Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2008_Q4Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2009_Q1Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2009_Q2Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2009_Q3Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2009_Q4Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2010_Q1Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2010_Q2Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2010_Q3Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2010_Q4Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2011_Q1Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2011_Q2Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2011_Q3Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2011_Q4Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2012_Q1Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2012_Q2Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2012_Q3Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2012_Q4Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2013_Q1Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2013_Q2Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2013_Q3Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2013_Q4Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2014_Q1Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2014_Q2Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2014_Q3Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2014_Q4Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2015_Q1Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2015_Q2Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
Y2015_Q3Number of inpatient stay in the particular quarter of yearnumberlevel : Nominal
StateHospitalization_TypeExpected_PayerY2003_Q1Y2003_Q2Y2003_Q3Y2003_Q4Y2004_Q1Y2004_Q2Y2004_Q3Y2004_Q4Y2005_Q1Y2005_Q2Y2005_Q3Y2005_Q4Y2006_Q1Y2006_Q2Y2006_Q3Y2006_Q4Y2007_Q1Y2007_Q2Y2007_Q3Y2007_Q4Y2008_Q1Y2008_Q2Y2008_Q3Y2008_Q4Y2009_Q1Y2009_Q2Y2009_Q3Y2009_Q4Y2010_Q1Y2010_Q2Y2010_Q3Y2010_Q4Y2011_Q1Y2011_Q2Y2011_Q3Y2011_Q4Y2012_Q1Y2012_Q2Y2012_Q3Y2012_Q4Y2013_Q1Y2013_Q2Y2013_Q3Y2013_Q4Y2014_Q1Y2014_Q2Y2014_Q3Y2014_Q4Y2015_Q1Y2015_Q2Y2015_Q3
IowaMaternalMedicare
UtahMaternalMedicare
MaineMaternalMedicare
TexasMaternalMedicare
AlaskaMaternalMedicare
HawaiiMaternalMedicare
KansasMaternalMedicare
NevadaMaternalMedicare
OregonMaternalMedicare
ArizonaMaternalMedicare