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 interactive tool for identifying, tracking, analyzing, and comparing statistics on hospital and emergency care. HCUPnet provides statistics from the HCUP nationwide databases (NIS, KID, and NEDS) and the State-level databases (SID, SASD, and SEDD) for those States that have agreed to participate.

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.
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.
 
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

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.)

Comorbidity Software
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 2013.)

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 2014.)
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 2014.)

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 2014.)

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

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 2014.)


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 2013.)
 
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, 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.

Nationwide Inpatient Sample Trends (NIS-Trends) Files
The NIS-Trends Files are discharge-level files that 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-Trends Files is to ease the burden on researchers conducting longitudinal analyses.

Kids’ Inpatient Database Trends (KID-Trends) File
The KID-Trends File is a discharge-level file that provides KID data users with trend weights consistently defined between 1997 and later years.

Internet Citation: HCUP Tools and Software. Healthcare Cost and Utilization Project (HCUP). November 2014. 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 11/17/14