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

MONAHRQ
MONAHRQ is a software product that enables organizations - such as state and local data organizations, hospital systems, and health plans - to input either publicly available or their own data and quality metrics for hospitals, nursing homes, and physicians, and then generate a data-driven website that can be used by consumers or healthcare professionals to compare care providers.
*Note* Effective September 27, 2017, technical support and software updates are no longer available for the MONAHRQ tool. Existing software and supporting materials will remain available on the MONAHRQ website, as well as the open source project.
 
HCUP Tools & Software

The HCUP Tools and Software can be applied to HCUP databases, to 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, the analytic tools may be applied to other administrative databases. We welcome comments. If you have questions or suggestions for changes, please contact hcup@ahrq.gov.
 
Note: The U.S. transitioned to the International Classification of Diseases, 10th Revision, Clinical Modification/Procedure Coding System (ICD-10-CM/PCS) coding scheme on October 1, 2015. The HCUP tools for International Classification of Diseases, 9th Revision, Clinical Modification (ICD-9-CM) should only be used with data for discharges before 10/1/15.

The HCUP tools were translated to ICD-10-CM/PCS prior to the availability of ICD-10-CM/PCS-coded data. The translated tools are considered in beta version, until a refined version of the tool can be developed. Preliminary findings suggest some unexpected discontinuities between the tools based on ICD-9-CM and the beta version of tools based on ICD-10-CM/PCS. See the ICD-10-CM/PCS Resources page for details. The tools will continue to undergo refinements over the next several years. You are advised to visit this page regularly to download and apply the most recent version of the HCUP tools for your data throughout your research process.
 
Tools for ICD-10-CM/PCS

NEW! Clinical Classifications Software Refined (CCSR) for ICD-10-CM Diagnoses
Clinical Classifications Software Refined (CCSR) for ICD-10-CM diagnoses aggregates over 72,000 ICD-10-CM diagnosis codes into a manageable number of clinically meaningful categories organized across 21 body systems, which generally follow the structure of the ICD-10-CM diagnosis chapters. The CCSR replaces the beta version of the CCS for ICD-10-CM diagnoses. It provides a means by which to identify specific clinical conditions using ICD-10-CM diagnosis codes. The CCSR capitalizes on the specificity built into ICD-10-CM coding by creating new clinical categories that did not exist in previous versions of the CCS tool and allowing ICD-10-CM codes to be classified in more than one category. The CCSR is intended to be used analytically to examine patterns of healthcare in terms of cost, utilization, and outcomes; rank utilization by diagnoses; and risk adjust by clinical condition. (Codes valid through FY 2020.)

Beta Versions of HCUP Tools for ICD-10-CM/PCS

Clinical Classifications Software (CCS) for ICD-10-PCS (beta version)
Clinical Classifications Software (CCS) for ICD-10-PCS (beta version) provides a method for classifying 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 2020.) A fully refined version of the CCS for ICD-10-PCS is expected to be released in 2020.

Chronic Condition Indicator for ICD-10-CM (beta version)
Chronic Condition Indicator for ICD-10-CM (beta version) provides a method for categorizing 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 2020.) A fully refined version of the Chronic Condition Indicator for ICD-10-CM is expected to be released in 2019.

Elixhauser Comorbidity Software for ICD-10-CM (beta version)
Elixhauser Comorbidity Software for ICD-10-CM (beta version) assigns variables that identify coexisting conditions on hospital discharge records. (Updated for codes valid through FY 2020.) A fully refined version of the Comorbidity Software for ICD-10-CM is expected to be released in 2019.

Procedure Classes for ICD-10-PCS (beta version)
Procedure Classes for ICD-10-PCS (beta version) provides a method for 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 2020.) A fully refined version of the Procedure Classes for ICD-10-PCS is expected to be released in 2020.

Utilization Flags for ICD-10-PCS (beta version)
Utilization Flags for ICD-10-PCS (beta version) combines 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 2020.) A fully refined version of the Utilization Flags for ICD-10-PCS is expected to be released in 2021.

Surgery Flags for ICD-10-PCS
Surgery Flags for ICD-10-PCS have not yet been developed. Development of the ICD-10-PCS-based surgery flag is expected to begin in 2020.
Tools for ICD-9-CM

Clinical Classifications Software (CCS) for ICD-9-CM
Clinical Classifications Software (CCS) for ICD-9-CM 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 for ICD-9-CM
Chronic Condition Indicator (CCI) for ICD-9-CM 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 for ICD-9-CM
Elixhauser Comorbidity Software for ICD-9-CM assigns variables that identify coexisting conditions on hospital discharge records. (Codes valid through FY 2015.) The software computes an index for in-hospital mortality and an index for readmissions.

Procedure Classes for ICD-9-CM
Procedure Classes for ICD-9-CM identifies 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.)

Utilization Flags for ICD-9-CM
Utilization Flags for ICD-9-CM combines 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 FY 2015.)

Surgery Flags for ICD-9-CM
Surgery Flags for ICD-9-CM provides a method for identifying surgical procedures and encounters using ICD-9-CM based data. Two types of surgical categories are identified: NARROW and BROAD. The NARROW surgery category is based on a narrow, targeted, and restrictive definition and includes invasive surgical procedures. The BROAD surgery category includes procedures that fall under the NARROW category in addition to less invasive therapeutic and diagnostic procedures that are often performed in surgical settings. (Updated for codes valid through FY 2015.)

Tools for CPT/HCPCS

Clinical Classifications Software for Services and Procedures
CCS-Services and Procedures provides a method for classifying Healthcare Common Procedure Coding System (HCPCS) Level I (or Current Procedural Terminology (CPT) codes) and HCPCS Level II codes into clinically meaningful procedure categories. The procedure categories are identical to the CCS for ICD-9-CM and beta version of the CCS for ICD-10-PCS, 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 to include codes effective January 2019.)

Surgery Flags for Services and Procedures
Surgery Flags for Services and Procedures provides a method for identifying surgical procedures and encounters using CPT-based data. Two types of surgical categories are identified: NARROW and BROAD. The NARROW surgery category is based on a narrow, targeted, and restrictive definition and includes invasive surgical procedures. The BROAD surgery category includes procedures that fall under the NARROW category in addition to less invasive therapeutic and diagnostic procedures that are often performed in surgical settings. Users must agree to a license to use the Surgery Flags for Services and Procedures before accessing the software. (Updated to include codes effective January 2019.)
 

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 for 2003, 2006, and 2009.

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. For recent data years, revisit variables are included in the core database files with purchase; older years are available by contacting the HCUP Central Distributor at HCUPDistributor@ahrq.gov or 866-556-HCUP (4287).

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.
** Available for download using the link provided for the supplemental file details.
*** Recent years included in core database files with purchase; older years available by contacting the HCUP Central Distributor at HCUPDistributor@ahrq.gov or 866-556-HCUP (4287).

Internet Citation: HCUP Tools and Software. Healthcare Cost and Utilization Project (HCUP). February 2020. 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 2/19/20