The inputevents_cv table

Table source: CareVue ICU databases.

Table purpose: Input data for patients.

Number of rows: 17,527,935

Links to:

  • PATIENTS on SUBJECT_ID
  • ADMISSIONS on HADM_ID
  • ICUSTAYS on ICUSTAY_ID
  • D_ITEMS on ITEMID
  • CAREGIVERS on CGID

A high level description of the data is available here.

Table columns

Name Postgres data type
ROW_ID INT
SUBJECT_ID INT
HADM_ID INT
ICUSTAY_ID INT
CHARTTIME TIMESTAMP(0)
ITEMID INT
AMOUNT DOUBLE PRECISION
AMOUNTUOM VARCHAR(30)
RATE DOUBLE PRECISION
RATEUOM VARCHAR(30)
STORETIME TIMESTAMP(0)
CGID BIGINT
ORDERID BIGINT
LINKORDERID BIGINT
STOPPED VARCHAR(30)
NEWBOTTLE INT
ORIGINALAMOUNT DOUBLE PRECISION
ORIGINALAMOUNTUOM VARCHAR(30)
ORIGINALROUTE VARCHAR(30)
ORIGINALRATE DOUBLE PRECISION
ORIGINALRATEUOM VARCHAR(30)
ORIGINALSITE VARCHAR(30)

Detailed Description

SUBJECT_ID, HADM_ID, ICUSTAY_ID

Identifiers which specify the patient: SUBJECT_ID is unique to a patient, HADM_ID is unique to a patient hospital stay and ICUSTAY_ID is unique to a patient ICU stay.

CHARTTIME

CHARTTIME represents the time at which the measurement was charted - that is - recorded on the clinical information system at the bedside. For amounts received (usually volumes), the CHARTTIME represents the time at which that volume was received. That is, it can be considered an “end time”, i.e. X millilitres of solution was administered to the patient by this CHARTTIME. For rates, the CHARTTIME represents the time at which that rate was set. That is, it can be considered a “start time”, i.e. the patient is now receiving X mcg/kg/min of a drug at this CHARTTIME.

See the understanding IOEVENTS page for a bit more detail about how this table was formed from the raw data.

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). Metavision ITEMID values are all above 220000. A subset of commonly used medications in CareVue data have ITEMID values are between 30000-39999. The remaining input/output ITEMID values are between 40000-49999.

AMOUNT, AMOUNTUOM

AMOUNT and AMOUNTUOM list the amount of a drug or substance administered to the patient either between the STARTTIME and ENDTIME (if both are available) or at the ENDTIME (when the exact start time is unknown, but usually up to an hour before).

RATE, RATEUOM

RATE and RATEUOM list the rate at which the drug or substance was administered to the patient either between the STARTTIME and ENDTIME (if both are available), or it lists the rate at which the drug is currently administered at the ENDTIME.

STORETIME

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

CGID

CGID is the identifier for the caregiver who validated the given measurement.

ORDERID, LINKORDERID

ORDERID links multiple items contained in the same solution together. For example, when a solution of noradrenaline and normal saline is administered both noradrenaline and normal saline occur on distinct rows but will have the same ORDERID.

LINKORDERID links the same order across multiple instantiations: for example, if the rate of delivery for the solution with noradrenaline and normal saline is changed, two new rows which share the same new ORDERID will be generated, but the LINKORDERID will be the same.

STOPPED, NEWBOTTLE

STOPPED indicates whether the infusion has been disconnected or continued. NEWBOTTLE indicates if a new preparation of the solution was hung at the bedside.

ORIGINALAMOUNT, ORIGINALAMOUNTUOM, ORIGINALROUTE, ORIGINALRATE, ORIGINALRATEUOM , ORIGINALSITE

These columns provide information about the solution the medication was a part of when it was first entered into the information system.

MIMIC-III v1.4 documentation