Skip Navigation U.S. Department of Health and Human Services www.hhs.gov
Agency for Healthcare Research Quality www.ahrq.gov
Archive print banner

Healthcare Cost and Utilization Project (HCUP) Healthcare Data and Tools... And an Overview of HCUPnet

This information is for reference purposes only. It was current when produced and may now be outdated. Archive material is no longer maintained, and some links may not work. Persons with disabilities having difficulty accessing this information should contact us at: https://info.ahrq.gov. Let us know the nature of the problem, the Web address of what you want, and your contact information.

Please go to www.ahrq.gov for current information.


On December 7, 2007, Anne Elixhauser made a presentation entitled Healthcare Cost and Utilization Project (HCUP) Healthcare Data and Tools... And an Overview of HCUPnet. This is the text version of the event's slide presentation. Please select the following link to access the slides: (PowerPoint® File, 6.9 MB).

Slides: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30


Slide 1: Healthcare Cost and Utilization Project (HCUP) Healthcare Data and Tools... And an Overview of HCUPnet

Anne Elixhauser, Ph.D.
State Healthcare Quality Improvement Workshop
December 7, 2007-Philadelphia, PA

On the top of the slide are the logos for the Department of Health & Human Services and the AHRQ logo. The Department of Health & Human Services logo is an artistic image of an eagle with the outlined profile of faces. The AHRQ logo reads, "AHRQ — Agency for Healthcare Research and Quality: Advancing Excellence in Health Care, www.ahrq.gov."

Return to Top


Slide 2: The HCUP Partnership: A Voluntary Federal-State-Private Sector Collaboration

This presentation uses a template with a blue background and a header with the AHRQ and Department of Health & Human Services logos on the left and the HCUP logo on the right. The header and body of the slide are separated by two horizontal lines, one light blue line and one dark blue.

The body of the slide shows a map of the United States. States are color coded according to their HCUP partnership status.

  • Hawaii, Washington, Oregon, California, Nevada, Utah, Arizona, Colorado, Texas, Oklahoma, Kansas, Nebraska, South Dakota, Minnesota, Iowa, Missouri, Arkansas, Tennessee, Kentucky, Indiana, Illinois, Wisconsin, Ohio, Michigan, West Virginia, Florida, Georgia, South Carolina, North Carolina, Virginia, Maryland, New Jersey, New York, Connecticut, Rhode Island, Massachusetts, New Hampshire, and Vermont are HCUP Partners.
  • New Mexico is not an HCUP partner due to a legal barrier.
  • Alabama, Mississippi, Idaho, Montana, and Wyoming do not collect inpatient data.
  • Alaska, Louisiana, Pennsylvania, North Dakota, Maine, Delaware, and the District of Columbia are not HCUP partners.

The box below the map contains the following text: 38 states in partnership and 90% of all discharges.

Return to Top


Slide 3: The Foundation of HCUP is Billing Data

On the left is a graphic of a UB-92 (UB-04) Billing Form

To the right of form is a bracket with the following text:

Patient demographics (age, sex)
Diagnoses & procedures
  (ICD-9-CM, DRG)
Expected payer
Length of stay
Patient disposition
Admission source & type
Admission month
Charges

Return to Top


Slide 4: The Making of HCUP Data

A white arrow starting in the upper left quadrant of the slide circles the slide and ends in the lower left quadrant. The arrows follow pictures and graphics of Patient enters hospital, Billing record created, and Hospital sends billing data and any additional data elements to data organizations, and ends with States store data in varying formats. The arrow points to the HCUP logo with "AHRQ standardizes data to create uniform HCUP databases" underneath.

Return to Top


Slide 5: What is HCUP? And what is not?

There are two columns in the table.

The left column entitled "What it is" lists: Claims (bills)for health care encounters; All payer, including the uninsured; Hospital, ambulatory surgery, emergency department data; All claims; Accessible multiple ways: raw data, regular reports, online.

The right column entitled "What it is not" lists: A survey; Specific to a single payer, e.g. Medicare; Outpatient visits, pharmacy, laboratory; A sample; Just another database.

Return to Top


Slide 6: HCUP is a Family of Databases, Tools, Products

From the HCUP logo in the upper left quadrant, arrows point to graphics of HCUP Databases, Software Tools, HCUPnet, Research Publications, and User Support.

Return to Top


Slide 7: Types of HCUP Databases

Superimposed on top of a map of the United States are three boxes with an identical graphic of a disk underneath the text. From right to left, the boxes are labeled: State Emergency Department Databases (SEDD), State Ambulatory Surgery Databases (SASD), and State Inpatient Databases (SID). Two red arrows from the State Inpatient Databases box point to two more disks underneath the box that are labeled Nationwide Inpatient Sample (NIS) and Kids' Inpatient Database (KID).

Return to Top


Slide 8: HCUP Supports High Impact Health Services, Policy, and Clinical Research

The following logos appear on this slide: HSR, American Journal of Public Health, The New England Journal of Medicine, Cancer, Health Affairs, JAMA, Annals of Surgery, Journal of General Internal Medicine, Pediatrics, Health Economics, The National Academies, PharmacoEconomics, Newsweek, The Lancet, International Journal of Health Care Finance & Economics, The Journal of Rural Health, Inquiry, Morbidity and Mortality Weekly Report, National Healthcare Disparities Report, and Obstetrics & Gynecology.

Return to Top


Slide 9: HCUP Supports Federal and Non-Federal Initiatives

The following logos appear on this slide: U.S. Office of Management and Budget, FDA, The Commonwealth Fund, Allies Against Asthma, HRSA, NIAID, Utah Department of Health, CDC, Injury Control Research Center, NASA, SAMHSA, National Institutes of Health, National Oceanic and Atmospheric Administration, U.S. Government Accountability Office, Suicide Prevention Resource Center, American Urological Association, Medpac, CMS, March of Dimes, and Institute of Medicine.

Return to Top


Slide 10: Supports Policy Deliberations and Legislation

HCUP was used to determine national and state burden of hospital care following motorcycle injuries.

Analyses used in West Virginia's hearings to remove their motorcycle-helmet law.

To the right of the text are graphics of a motorcycle and a helmet.

Return to Top


Slide 11: AHRQ Quality Indicators

  • Most widely used HCUP tool.
  • Used for reporting hospital quality of care.
  • AHRQ provides benchmarks against which to compare your numbers.

To the left of the text are images of AHRQ Guide to Prevention Quality Indicators, AHRQ Guide to Patient Safety Indicators, AHRQ Guide to Inpatient Quality Indicators, and a Pediatric Quality Indicators Fact Sheet.

Return to Top


Slide 12: HCUP Fact Books

This slide shows cover images of HCUP Fact Book 5, HCUP Fact Book 8, and HCUP Fact Book 10.

Return to Top


Slide 13: HCUP Statistical Briefs

The image on the left is of HCUP Statistical Brief #36. The image on the right is a bar graph labeled Figure 1. Trends of total hospital stays for potentially preventable conditions, 1997-2004.

Return to Top


Slide 14: Other Statistical Briefs Include:

  • Hospital stays related to depression.
  • Trends in risk-adjusted mortality.
  • Trends in preventable hospitalizations.
  • Infections with MRSA in U.S. hospitals.
  • Childbirth-related stays in U.S. hospitals.
  • Adverse drug events.
  • Admissions for traumatic brain injury.
  • Bariatric surgery utilization and outcomes.
  • The national hospital bill.
  • ...

Return to Top


Slide 15: Facts and Figures

The image on the left is a bar graph entitled "Discharge Prevalence for All-listed Diabetes by Median Income of Patients' Zip Code, 2005." The image on the right is the cover of HCUP Facts and Figures: Statistics on Hospital-Based Care in the United States, 2005.

Return to Top


Slide 16: HCUPnet: Quick, Free Access to HCUP Data

  • Free, interactive online query system.
  • Users generate tables of outcomes by diagnoses and procedures.
  • Data can be cross-classified by patient and hospital characteristics.
    http://hcupnet.ahrq.gov

Return to Top


Slide 17: Welcome to HCUPnet

This slide is a screen shot of the HCUPnet home page: http://hcupnet.ahrq.gov/. Superimposed on the screenshot are two yellow boxes. The upper right box contains the following text: HCUPnet is a powerful online query tool that gives you free, instant access to healthcare statistics. The other dialogue box points to the National Statistics on All Stays section of the screenshot and says: HCUPnet provides national information on hospital stays based on the Nationwide Inpatient Sample.

Return to Top


Slide 18: Select State and Year:

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box on the lower right has the following text: ...and it gives access to data from participating states from HCUP's State Inpatient Databases.

Return to Top


Slide 19: Select the type of query you want:

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box in the lower right reads: HCUPnet takes you through a step-by-step process to select the information you want.

Return to Top


Slide 20: Do you want information on:

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box in the lower right has the following text: You select the level of diagnosis and procedure information: ICD codes, Clinical Classifications, DRGS.

Return to Top


Slide 21: Select outcomes and measures for which you want statistics

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box in the lower right has the following text: HCUPnet provides information on:

  • Numbers of discharges.
  • Hospital LOS and charges.
  • Discharge status.
  • How patients were admitted.

Return to Top


Slide 22: Select patient and hospital characteristics

This slide is a screen shot of the HCUPnet online database. The text in the yellow dialogue box in the middle on the right says: Are you interested in particular patient groups? Specific hospital characteristics?

Return to Top


Slide 23: State statistics - 2005 New York - principal procedure only

This slide is a data table that contains data for principal procedure performed in New York State in 2005.

The yellow dialogue box in the lower right has the following text: You get your results instantly. HCUPnet is based on aggregated statistics to speed data transfer and protect patient confidentiality.

Return to Top


Slide 24: State Statistics - New York - all-listed

This slide is a line graph entitled "Total number of discharges CCS all-listed procedure category 158, Spinal Fusion." The x-axis is labeled with consecutive years from 1997 until 2005. The y-axis is labeled with the total number of discharges in 2,000 increments from zero until 18,000. The points along the line from left to right are: 8,701 in 1997, 10,306 in 1998, 10,827 in 1999, 12,008 in 2000, 12,968 in 2001, 13,793 in 2002, 15,342 in 2003, 16,195 in 2004, and 16,808 in 2005. The bottom of the page has a table with corresponding values of the points on the graph.

Superimposed on the line graph is a yellow dialogue box pointing to the line graph with the following text: You can request information on trends for the nation and for any participating state.

Return to Top


Slide 25: Repeat this query on another database

This slide is a screen shot of the HCUPnet online database. The text in the yellow dialogue box says: You can repeat your query instantly on another database.

Return to Top


Slide 26: Results

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box contains the following text: HCUPnet also provides information on ED visits for some states.

Return to Top


Slide 27: Indicator Selection

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box on the lower right contains the following text: ...and on national-level information on quality of care, based on the AHRQ Quality Indicators.

Return to Top


Slide 28: Welcome to HCUPnet

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box points to Welcome to HCUPnet and contains the following text: Visit HCUPnet at: http://hcupnet.ahrq.gov.

Return to Top


Slide 29: What types of questions can HCUPnet answer?

  • What are the most common conditions treated in hospitals in my state?
  • What are the most expensive conditions? procedures?
  • How many CABGs were performed in 2003?
  • What percentage of hospitalizations are uninsured?
  • For what conditions are uninsured patients hospitalized? patients covered by Medicaid?
  • What is the trend in hospitalizations for MRSA?
  • What is the cost of C-section versus vaginal deliveries?
  • What types of hospitals treat what kinds of patients?
  • What types of patients are seen in the emergency department and then admitted to the hospital?

Return to Top


Slide 30: For more information

Return to Top

Return to Contents

The information on this page is archived and provided for reference purposes only.

 

AHRQ Advancing Excellence in Health Care