HCUPnet

HCUPnet (https://hcupnet.ahrq.gov/) is an online query system that provides healthcare statistics and information from the HCUP national (NIS, NEDS, KID, and NRD) and State (SID, SASD, and SEDD) databases for those States that have agreed to participate. HCUPnet can be used for identifying, tracking, analyzing, and comparing statistics on hospital inpatient stays, emergency care, and ambulatory surgery, as well as obtaining measures of quality-based information from the AHRQ Quality Indicators. Select statistics are available at a national- and county-level. HCUPnet can also be used for trend analysis with healthcare data available from 1993 forward. HCUPnet also includes a feature called hospital readmissions that provides users with some statistics on hospital readmissions within 7 and 30 days of hospital discharge.

HCUP Fast Stats

HCUP Fast Stats (https://www.hcup-us.ahrq.gov/faststats/landing.jsp) is a web-based tool that provides easy access to the latest HCUP-based statistics for healthcare information topics. HCUP Fast Stats uses visual statistical displays in standalone graphs, trend figures, or simple tables to convey complex information at a glance. Fast Stats topics are updated regularly (quarterly or annually, as newer data become available) for timely, topic-specific national and State-level statistics.

The following topics are available:

• State Trends in Hospital Use by Payer (formerly called Effect of Health Insurance Expansion on Hospital Use and Effect of Medicaid Expansion on Hospital Use). This topic includes statistics from up to 44 States on the number of hospital discharges by payer group.
• National Hospital Utilization and Costs. This topic focuses on national statistics on inpatient stays: Trends, Most Common Diagnoses, and Most Common Operations.
• State Trends in Emergency Department Visits by Payer. These ED statistics are a supplement to the existing State-level inpatient stay trends by expected payer.
• Opioid-Related Hospital Use, National and State. This topic reports population-based rates of opioid-related hospital use by discharge quarter. Trends are available for inpatient stays and emergency department visits by expected payer.
• Neonatal Abstinence Syndrome (NAS), National and State. This new topic provides trends in NAS-related newborn hospitalizations at the national and State level. Rates of NAS per 1,000 newborn hospitalizations are presented overall as well as by sex, expected payer, community-level income, and patient location.
• Hurricane Impact on Hospital Use. This new topic provides historical inpatient and treat-and-release emergency department utilization information from 11 U.S. hurricanes between 2005 and 2017. Supported by the Patient-Centered Outcomes Research Trust Fund (PCORTF) and created in collaboration with the Office of the Assistant Secretary for Planning and Evaluation (ASPE) and the Office of the Assistant Secretary for Preparedness and Response (ASPR), this topic is designed to help HCUP users understand medical care utilization during and after past hurricanes to assist in the preparation for and deployment of medical services in future disasters.

Clinical Classifications Software (CCS)

The Clinical Classifications Software (CCS) provides a method for classifying diagnoses or procedures into clinically meaningful categories. These can be used for aggregate statistical reporting of a variety of topics, such as identifying populations for disease- or procedure-specific studies or developing statistical reports providing information (i.e., charges and length of stay) about relatively specific conditions. Four versions of the CCS Software are available:

• The Clinical Classifications Software Refined (CCSR) for ICD-10-CM aggregates more than 70,000 ICD-10-CM diagnosis codes into a manageable number of clinically meaningful categories. The categories are organized across 21 body systems, which generally follow the structure of the ICD-10-CM diagnosis chapters.
• The Clinical Classification Software (CCS) for ICD-10-PCS procedures (beta version) categorizes more than 77,000 ICD-10-PCS procedure codes into clinically meaningful categories and can be used to identify populations for procedure-specific studies or to develop statistical reports about relatively specific procedures.
• Clinical Classifications Software (CCS) for ICD-9-CM is based on the International Classification of Diseases, 9th Revision, Clinical Modification (ICD-9-CM), a uniform and standardized coding system. The CCS for ICD-9-CM provides a diagnosis and procedure categorization scheme that can be used to classify more than 14,000 ICD-9-CM diagnosis and 3,900 procedure codes into a manageable number of clinically meaningful categories. The CCS for ICD-9-CM was updated annually starting January 1980 through September 30, 2015. ICD-9-CM codes were frozen in preparation for ICD-10-CM implementation and regular maintenance of the codes has been suspended.
• Clinical Classifications Software (CCS) for Services and Procedures provides users with a method of classifying Current Procedural Terminology (CPT®) codes and Healthcare Common Procedure Coding System (HCPCS) codes into 244 clinically meaningful procedure categories. More than 9,000 CPT/HCPCS codes and 6,000 HCPCs codes are accounted for.

The CCS versions and their user guides are available for download from the HCUP-US website: https://www.hcup-us.ahrq.gov/tools_software.jsp.

Chronic Condition Indicator

The Chronic Condition Indicator (CCI) facilitates health services research on diagnoses using administrative data. The CCI tools categorize ICD-9-CM/ICD-10-CM diagnoses codes into two classifications: chronic or not chronic. A chronic condition is defined as a condition that lasts 12 months or longer and meets one or both of the following tests: (a) it places limitations on self-care, independent living, and social interactions; and (b) it results in the need for ongoing intervention with medical products, services, and special equipment.

Two versions of the CCI software are available, CCI for ICD-9-CM and CCI for ICD-10-CM (beta version). The ICD-9-CM CCI was updated annually and is valid for codes from January 1, 1980, through September 20, 2015. The ICD-10-CM CCI is updated annually and is valid for codes from October 1, 2015, forward. The CCI Software is available for download on the HCUP-US website: https://www.hcup-us.ahrq.gov/tools_software.jsp.

Elixhauser Comorbidity Software

Elixhauser Comorbidity Software assigns variables that identify comorbidities in hospital discharge records using ICD-9-CM or ICD-10-CM diagnosis coding. Two versions of the Elixhauser Comorbidity Software are available: Elixhauser Comorbidity Software for ICD-10-CM (beta version) and Elixhauser Comorbidity Software for ICD-9-CM. The Elixhauser Software for ICD-9-CM was updated annually from January 1, 1980, through September 30, 2015. The Elixhauser Comorbidity Software for ICD-10-CM (beta version) is updated annually and based on the ICD-10-CM and MS-DRG codes that are valid through September 30 of the designated fiscal year after October 1, 2015. The Elixhauser Comorbidity Software is available for download on the HCUP-US website: https://www.hcup-us.ahrq.gov/tools_software.jsp.

Procedure Classes

Procedure Classes facilitate research on hospital services using administrative data by identifying whether an ICD-9-CM or ICD-10-CM procedure is (a) diagnostic or therapeutic, and (b) minor or major in terms of invasiveness and/or resource use. There are two versions of Procedure Classes tools, Procedure Classes for ICD-9-CM and Procedure Classes for ICD-10-PCS (beta version). The Procedure Classes can be used to categorize procedure codes into one of four broad categories: minor diagnostic, minor therapeutic, major diagnostic, and major therapeutic.

The Procedure Classes for ICD-9-CM were updated annually from January 1, 1980, through September 30, 2015. The Procedure Classes for ICD-10-PCS (beta version) are updated annually and valid for codes from October 1, 2015, forward. Procedure Classes are available for download from the HCUP-US website: https://www.hcup-us.ahrq.gov/tools_software.jsp.

Utilization Flags

Utilization Flags combine information from Uniform Billing (UB-04) revenue codes and ICD-9-CM or ICD-10-PCS procedure codes to create flags—or indicators—of utilization of services rendered in healthcare settings such as hospitals, emergency departments, and ambulatory surgery centers. The Utilization Flags can be used to study a broad range of services, including simple diagnostic tests and resource-intense procedures, such as use of intensive care units. They can also be used to more reliably examine utilization of diagnostic and therapeutic services. There are two types of Utilization Flags, Utilization Flags for ICD-9-CM and Utilization Flags for ICD-10-CM/PCS (beta version). The Utilization Flags for ICD-9-CM were updated annually from January 1, 2003, through September 30, 2015. The Utilization Flags for ICD-10-CM/PCS (beta version) are updated annually and valid for codes from October 1, 2015, forward. The Utilization Flags are available for download from the HCUP-US website: https://www.hcup-us.ahrq.gov/tools_software.jsp.

Surgery Flags

Surgery Flag Software classifies procedures and encounters in ICD-9-CM or CPT-based inpatient and ambulatory surgery into two types of surgical categories: NARROW and BROAD. NARROW surgery is based on a narrow, targeted, and restrictive definition and includes invasive surgical procedures. An invasive therapeutic surgical procedure involves incision, excision, manipulation, or suturing of tissue that penetrates or breaks the skin; typically requires use of an operating room; and requires regional anesthesia, general anesthesia, or sedation to control pain. BROAD surgery includes procedures that fall under the NARROW category but adds less invasive therapeutic surgeries and diagnostic procedures often performed in surgical settings. Users must agree to a license agreement with the American Medical Association to use the Surgery Flags before accessing the software. The Surgery Flags are available for download from the HCUP-US website: https://www.hcup-us.ahrq.gov/tools_software.jsp.

AHRQ Quality Indicators (QIs)

The AHRQ Quality Indicators (QIs) (https://www.qualityindicators.ahrq.gov/) are standardized, evidence-based measures of healthcare quality that can be used with readily available hospital inpatient administrative data to measure and track clinical performance and outcomes. The AHRQ QIs consist of four modules measuring various aspects of quality:

• Prevention Quality Indicators (PQIs) identify issues of access to outpatient care, including appropriate followup care after hospital discharge. More specifically, the PQIs use data from hospital discharges to identify admissions that might have been avoided through access to high-quality outpatient care. The PQIs are population based and adjusted for covariates.
• Inpatient Quality Indicators (IQIs) provide a perspective on quality of care inside hospitals, including:
  • Inpatient mortality for surgical procedures and medical conditions;
  • Utilization of procedures for which there are questions of overuse, underuse, and misuse; and
  • Volume of procedures for which hospital procedure volume is an important indicator of performance.

• Patient Safety Indicators (PSIs) provide information on potentially avoidable safety events that represent opportunities for improvement in the delivery of care. More specifically, they focus on potential in-hospital complications and adverse events following surgeries, procedures, and childbirth.
• Pediatric Quality Indicators (PDIs) focus on potentially preventable complications and iatrogenic events for pediatric patients treated in hospitals and on preventable hospitalizations among pediatric patients, taking into account the special characteristics of the pediatric population.

Cost-to-Charge Ratio Files (CCR)

The Cost-to-Charge Ratio (CCR) Files (https://www.hcup-us.ahrq.gov/db/state/costtocharge.jsp) are hospital-level files designed to convert the hospital total charge data to total cost estimates for services when merged with data elements exclusively in the HCUP NIS, KID, NRD, and SID. HCUP databases are limited to information on total hospital charges, which reflect the amount billed to the payer per patient encounter. Total charges do not reflect the actual cost of providing care or the payment received by the hospital for services provided. This total charge data can be converted into cost estimates using the CCR Files, which include hospital-wide values of the all-payer inpatient cost-to-charge ratio for nearly every hospital in the participating NIS, KID, NRD, and SID. The CCR Files are updated annually and available for the HCUP inpatient databases beginning with 2001 data. CCR Files for use with the HCUP emergency department databases (NEDS and SEDD) are under development.

Hospital Market Structure (HMS) Files

The Hospital Market Structure (HMS) Files (https://www.hcup-us.ahrq.gov/toolssoftware/hms/hms.jsp) are hospital-level files designed to supplement the data elements in the NIS, KID, and SID databases. The HMS Files contain various measures of hospital market competition. Hospital market definitions were based on hospital locations, and in some cases, patient ZIP Codes. Hospital locations were obtained from the American Hospital Association (AHA) Annual Survey Database, Area Resource File (ARF), HCUP Historical Urban/Rural – County (HURC) file, and ArcView GIS. Patient ZIP Codes were obtained from the SID.

HMS Files are useful for performing empirical analyses that examine the effects of hospital competition on the cost, access, and quality of hospital services. The HCUP HMS Files are available for the 1997, 2000, 2003, 2006, and 2009 data years.

HCUP Supplemental Variables for Revisit Analyses

The HCUP Supplemental Variables for Revisit Analyses (https://www.hcup-us.ahrq.gov/toolssoftware/revisit/revisit.jsp) allow users to track sequential visits for a patient within a State and across facilities and hospital settings (inpatient, emergency department, and ambulatory surgery) while adhering to strict privacy guidelines. Users can use the available clinical information to determine if sequential visits are unrelated, an expected followup, complications from a previous treatment, or an unexpected revisit or rehospitalization. The supplemental files must be merged with the corresponding SID, SASD, or SEDD for any analysis. Beginning with 2009 data, the revisit variables are included in the Core file of the HCUP State Databases when possible.

NIS and KID Trend Files

The NIS-Trends (https://www.hcup-us.ahrq.gov/db/nation/nis/nistrends.jsp) and KID-Trends (https://www.hcup-us.ahrq.gov/db/nation/kid/kidtrends.jsp) files are available to help researchers conduct longitudinal analyses. They are discharge-level files that provide researchers with the trend weights and, in the case of the NIS-Trends, data elements that are consistently defined across data years.

American Hospital Association (AHA) Linkage Files

The American Hospital Association (AHA) Linkage Files (https://www.hcup-us.ahrq.gov/db/state/ahalinkage/aha_linkage.jsp) are hospital-level files that contain a small number of data elements that allow researchers to supplement the HCUP State Databases with information from the AHA Annual Survey Databases (https://www.ahadata.com/aha-annual-survey-database). The files are designed to support richer empirical analysis where hospital characteristics may be important factors. Linkage is only possible in States that allow the release of hospital identifiers and are unique by State and year.