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_ID | INT |
| TIME_START | TIMESTAMP(0) |
| VITALS | INT |
| TEMPERATURE | INT |
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.