Skip Navigation

Tools & Software
HCUP tools and software help health services researchers and decision makers to use HCUP and other similar databases. These products are developed by AHRQ through a Federal-State-Industry partnership.
 
Favorites
HCUPnet
HCUPnet is an online query system for identifying, tracking, analyzing, and comparing statistics on inpatient and outpatient care. HCUPnet provides statistics from the HCUP Nationwide Databases (NIS, KID, NEDS, and NRD) and the State Databases (SID, SASD, and SEDD) for those States that have agreed to participate.

HCUP Fast Stats
HCUP Fast Stats provides easy online access to the latest HCUP-based statistics for select State and national health information topics. HCUP Fast Stats uses interactive, side-by-side comparisons of visual statistical displays, trend figures, or simple tables to convey complex information at a glance.
AHRQ Quality Indicators (QIs)
AHRQ Quality Indicators (QIs) use hospital administrative data to highlight potential quality concerns, identify areas that need further study and investigation, and track changes over time.

MONAHRQ
MONAHRQ is a software product that enables organizations - such as state and local data organizations, Chartered Value Exchanges, hospital systems, and health plans - to input their own hospital administrative data and generate a data-driven Web site.
 
HCUP Tools & Software

The HCUP Tools and Software are analytic methods that, when applied to HCUP databases, systematically create new data elements from existing data, thereby enhancing a researcher's ability to conduct analyses. While designed to be used with HCUP databases, they may be applied to other administrative databases as well.

Tools for ICD-9-CM

ICD-9-CM codes were frozen in preparation for ICD-10 implementation and regular maintenance of the codes has been suspended. The HCUP Tools for ICD-9-CM should only be used with data for discharges before 10/1/2015.

Clinical Classifications Software (CCS) for ICD-9-CM
Clinical Classifications Software (CCS) provides a method for classifying ICD-9-CM diagnoses or procedures into clinically meaningful categories, which can be used for aggregate statistical reporting of a variety of types. (Updated for codes valid through FY 2015.)

Chronic Condition Indicator
The Chronic Condition Indicator (CCI) provides users an easy way to categorize ICD-9-CM diagnosis codes into one of two categories: chronic or not chronic. The tool can also assign ICD-9-CM diagnosis codes into 1 of 18 body system categories. (Codes valid through FY 2015.)

Elixhauser Comorbidity Software
Elixhauser Comorbidity Software assigns variables that identify coexisting conditions on hospital discharge records. (Codes valid through FY 2015.)

Procedure Classes
Procedure Classes facilitate research on hospital services using administrative data by identifying whether a procedure is (a) diagnostic or therapeutic, and (b) minor or major in terms of invasiveness and/or resource use. (Updated for codes valid through FY 2015.)


CPT Based Tools

yellow star Surgery Flags
Surgery Flags identify surgical procedures and encounters in ICD-9-CM or CPT-based inpatient and ambulatory surgery data. Two types of surgical categories are identified: NARROW surgery is based on a narrow, targeted, and restrictive definition and includes invasive surgical procedures. BROAD surgery includes procedures that fall under the NARROW category but adds less invasive therapeutic and diagnostic procedures that may are often performed in surgical settings. Users must agree to a license to use the Surgery Flags before accessing the software. (Updated for codes valid through 2015.)

Clinical Classifications Software for Services and Procedures
CCS-Services and Procedures provides a method for classifying Current Procedural Terminology (CPT) codes and Healthcare Common Procedure Coding System (HCPCS) codes into clinically meaningful procedure categories. The procedure categories are identical to the CCS, with the addition of specific categories unique to professional service codes in CPT/HCPCS. Users must agree to a license to use the CCS-Services and Procedures before accessing the software. (Updated for codes valid through 2016.)
Tools for ICD-10-CM/PCS

HCUP tools have be translated to ICD-10-CM/PCS in anticipation of conversion to the new coding system on October 1, 2015. We welcome comments. If you have questions or suggestions for changes, please contact hcup@ahrq.gov.

yellow star Clinical Classifications Software (CCS) for ICD-10-CM/PCS
Clinical Classifications Software (CCS) for ICD-10-CM/PCS provides a method for classifying ICD-10-CM diagnoses or ICD-10-PCS procedures into clinically meaningful categories, which can be used for aggregate statistical reporting of a variety of types. (Updated for codes valid through FY 2017.)

yellow star Chronic Condition Indicator for ICD-10-CM
Chronic Condition Indicator for ICD-10-CM provides users an easy way to categorize ICD-10-CM diagnosis codes into one of two categories: chronic or not chronic. The tool can also assign ICD-10-CM diagnosis codes into 1 of 18 body system categories. (Updated for codes valid through FY 2017.)

yellow star Elixhauser Comorbidity Software for ICD-10-CM
Elixhauser Comorbidity Software for ICD-10-CM assigns variables that identify coexisting conditions on hospital discharge records. (Updated for codes valid through FY 2017.)

yellow star Procedure Classes for ICD-10-PCS
Procedure Classes for ICD-10-PCS facilitate research on hospital services using administrative data by identifying whether an ICD-10-PCS procedure is (a) diagnostic or therapeutic, and (b) minor or major in terms of invasiveness and/or resource use. (Updated for codes valid through FY 2017.)

yellow star Utilization Flags for ICD-10-PCS
Utilization Flags for ICD-10-PCS reveal additional information about use of health care services by combining information from UB-04 revenue codes and ICD-10-PCS procedure codes to create flags, or indicators, of utilization. Use of procedures and services such as ICU, CCU, NICU, and specific diagnostic tests and therapies can be assessed with these Utilization Flags. (Updated for codes valid through FY 2017.)


Other Tools

Clinical Classifications Software (CCS) for Mortality Reporting
Clinical Classifications Software (CCS) for mortality reporting provides a method for classifying ICD-10 mortality diagnoses into clinically meaningful categories, which can be used for aggregate statistical reporting of a variety of types. Note that this is the original ICD-10 system for mortality reporting; not ICD-10-CM/PCS coding which will be implemented on October 1, 2015. Codes are valid through 2009.

Utilization Flags
Utilization Flags reveal additional information about use of health care services by combining information from UB-04 revenue codes and ICD-9-CM procedure codes to create flags, or indicators, of utilization. Use of procedures and services such as ICU, CCU, NICU, and specific diagnostic tests and therapies can be assessed with these Utilization Flags. (Updated for codes valid through 2014.)
 
HCUP Supplemental Files

The HCUP Supplemental Files augment applicable HCUP databases with additional data elements or analytically useful information that is not available when the HCUP databases are originally released. They cannot be used with other administrative databases.
Cost-to-Charge Ratio (CCR) Files*
The HCUP Cost-to-Charge Ratio Files are hospital-level files designed to supplement the data elements in the NIS, KID, NRD, and SID databases. These files can be used to estimate the resource cost of inpatient care and its variation across hospitals and conditions.

Hospital Market Structure (HMS) Files*
The HCUP Hospital Market Structure Files are hospital-level files designed to supplement the data elements in the NIS, KID, and SID databases.

HCUP Supplemental Variables for Revisit Analyses***
The HCUP Supplemental Variables for Revisit Analyses are discharge-level files designed to facilitate analyses that need to track patients within a state and across time and hospital settings (inpatient, emergency department, and ambulatory surgery) while adhering to strict privacy guidelines.

American Hospital Association (AHA) Linkage Files**
The AHA Linkage Files are hospital-level files that contain a small number of data elements that allow researchers to link hospital identifiers on the HCUP State Databases to the American Hospital Association Annual Survey Databases (Health Forum, LLC © 2012). Linkage is only possible in States that allow the release of hospital identities.
Nationwide Inpatient Sample (NIS) Hospital Ownership Files**
The NIS Hospital Ownership Files are hospital-level files designed to facilitate analysis of the NIS by hospital ownership categories. These HCUP supplemental files allow the user to identify in the 1998-2007 NIS the following three types of hospitals: government, nonfederal; private, non-profit; and private, investor-own.

1993-2011 NIS Trend Weights (NIS-Trend Weights) Files**
The 1993-2011 NIS Trend Weights Files adjust for 2012 NIS design changes and should be used for analyses spanning 2012 and earlier NIS data. The new NIS Trend Weights replace the earlier 1988-1997 NIS Trend Weights, which adjusted for 1998 NIS design changes.

1993-2002 Nationwide Inpatient Sample (NIS) Supplemental Discharge-Level Files*
The 1993-2002 Nationwide Inpatient Sample (NIS) Supplemental Discharge-Level Files provide the NIS data user with both the trend weights and data elements that are consistently defined across data years. The purpose of the NIS Supplemental Discharge-Level Files is to ease the burden on researchers conducting longitudinal analyses.

Kids’ Inpatient Database Trend (KID-Trend) File**
The KID-Trend File is a discharge-level file that provides KID data users with trend weights consistently defined between 1997 and later years.
 
* Available through the online HCUP Central Distributor and via hard copy application.
** Available for download using the link provided for the supplemental file details.
*** Recent years included in core database files with purchase; older years available only through request form on the hard copy application page.

Internet Citation: HCUP Tools and Software. Healthcare Cost and Utilization Project (HCUP). December 2016. Agency for Healthcare Research and Quality, Rockville, MD. www.hcup-us.ahrq.gov/tools_software.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 12/9/16