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 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 Web site that can be used by consumers or health care professionals to compare care providers.
*Note* Effective September 27, 2017, technical support and software updates will no longer be available for the MONAHRQ tool. Existing software and supporting materials will remain available on the MONAHRQ Web site, as well as the open source project.
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-CM/PCS 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.) Software has been added to compute an index for in-hospital mortality and an index for readmissions.
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.)
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.)
CPT Based Tools
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 2018.)
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 ICD-9-CM codes valid through 2015 and CPT codes valid through 2017.)
Tools for ICD-10-CM/PCS
HCUP tools have been translated to ICD-10-CM/PCS as part of the conversion to the new coding system on October 1, 2015. We welcome comments. If you have questions or suggestions for changes, please contact email@example.com.
Caution: These ICD-10-CM/PCS tools were created prior to the availability of ICD-10-CM/PCS-coded data. AHRQ is conducting analyses of ICD-10-CM/PCS data; preliminary findings suggest some unexpected discontinuities between the tools based on ICD-9-CM and those based on ICD-10-CM/PCS. See this page www.hcup-us.ahrq.gov/datainnovations/icd10_resources.jsp for details. The tools will undergo periodic updates and corrections as data using ICD-10-CM/PCS codes come into greater use. 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.
Beta 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 2018.)
Beta 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 2018.)
Beta 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 2018.)
Beta 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 2018.)
Beta 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 2018.)
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). June 2018. 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 firstname.lastname@example.org.|
|Privacy Notice, Viewers & Players|
|Last modified 6/20/18|