Outputevents

ICU level table

The outputevents table

Table source: MetaVision ICU database.

Table purpose: Output data for patients.

Number of rows: 3,703,137

Links to:

  • PATIENTS on subject_id
  • ADMISSIONS on hadm_id
  • ICUSTAYS on stay_id
  • D_ITEMS on itemid

Table columns

Name Data type
SUBJECT_ID Integer
HADM_ID Integer
STAY_ID Integer
CHARTTIME Date with times
STORETIME Date with times
ITEMID Integer
VALUE Floating point number
VALUEUOM Text
WARNING Binary (0 or 1)

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

CHARTTIME

CHARTTIME is the time of an output event.

STORETIME

STORETIME records the time at which an observation was manually input or manually validated by a member of the clinical staff.

ITEMID

Identifier for a single measurement type in the database. Each row associated with one ITEMID (e.g. 212) corresponds to an instantiation of the same measurement (e.g. heart rate).

VALUE, VALUEUOM

VALUE and VALUEUOM list the amount of a substance at the CHARTTIME (when the exact start time is unknown, but usually up to an hour before).


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