ICU stays

ICU level table

The icustays table

Table source: Hospital database.

Table purpose: Defines each ICU stay in the database using STAY_ID.

Number of rows: 65,794

Links to:

  • PATIENTS on subject_id
  • ADMISSIONS on hadm_id

Important considerations

  • stay_id is a generated identifier that is not based on any raw data identifier. The hospital and ICU databases are not intrinsically linked and so do not have any concept of an ICU encounter identifier.
  • The ICUSTAYS table is derived from the TRANSFERS table. Specifically, it excludes rows in TRANSFERS where the ward is not an ICU.

Table columns

Name Postgres data type
SUBJECT_ID INT
HADM_ID INT
STAY_ID INT
FIRST_CAREUNIT VARCHAR(20)
LAST_CAREUNIT VARCHAR(20)
INTIME TIMESTAMP(0)
OUTTIME TIMESTAMP(0)
LOS DOUBLE

Detailed Description

subject_id, hadm_id, stay_id

Identifiers which specify the patient: subject_id is unique to a patient, hadm_id is unique to a patient hospital stay and stay_id is unique to a patient ward stay.

FIRST_CAREUNIT, LAST_CAREUNIT

FIRST_CAREUNIT and LAST_CAREUNIT contain, respectively, the first and last ICU type in which the patient was cared for. As an stay_id groups all ICU admissions within 24 hours of each other, it is possible for a patient to be transferred from one type of ICU to another and have the same stay_id.

Care units are derived from the TRANSFERS table, and definition for the abbreviations can be found in the documentation for TRANSFERS.

INTIME, OUTTIME

INTIME provides the date and time the patient was transferred into the ICU. OUTTIME provides the date and time the patient was transferred out of the ICU.

LOS

LOS is the length of stay for the patient for the given ICU stay, which may include one or more ICU units. The length of stay is measured in fractional days.


Last modified August 14, 2020: update website to use docsy (adc506c)