The vitals table

Sampling frequency: Every 15 seconds (0.25 Hz).

File organization: One CSV per patient, linked via SUBJECT_ID.

Timestamps: Recorded during routine care.

Table columns

Name Data type
SUBJECT_IDINT
TIME_STARTTIMESTAMP(0)
VITALSINT
TEMPERATUREINT

Detailed description

SUBJECT_ID

SUBJECT_ID is a unique identifier that specifies an individual patient. It is a candidate key for the table, so it is unique for each row. Information that remains consistent throughout a patient's lifetime is stored in this table.

TIME_START

TIME_START is a timestamp indicating the start time of each 15-second recording interval. All physiological parameters in that row correspond to this timestamp.

VITALS

VITALS (Heart Rate, Respiratory Rate, Oxygen Saturation, Pulse Rate, Arterial Systolic Pressure) records core physiological parameters continuously measured by bedside monitors every 15 seconds.

TEMPERATURE

TEMPERATURE (Abdominal Temperature, Foot Temperature) represents continuous temperature measurements recorded every 15 seconds from two distinct probe sites.