The note events table

Table source: ICU database.

Table purpose: Contains all notes for patients.

Number of rows: 15,197

Links to:

• PATIENTS on SUBJECT_ID
• ADMISSIONS on SUBJECT_ID

Table columns

Detailed description

SUBJECT_ID

An identifier that specifies the patient: SUBJECT_ID is unique to a patient.

CHARTDATE

CHARTDATE records the date at which the note was charted. All records have a CHARTDATE.

DIAGNOSIS

DIAGNOSIS records the primary and secondary clinical diagnoses made by the treating physicians during a patient’s ICU stay. It reflects the underlying medical conditions, presenting complaints, or reasons for admission documented at the time of hospitalization or during the course of care.

RESPIRATORY_SUPPORT

RESPIRATORY_SUPPORT records the mode of respiratory assistance provided to the patient. It includes both non-invasive and invasive support modalities such as high-flow nasal cannula, oxygen delivery devices (e.g., nasal prongs, face mask), non-invasive ventilation, mechanical ventilation modes, as well as indications of room air when no respiratory support was required.

DESCRIPTION

DESCRIPTION contains free-text narrative written by clinicians during the patient’s ICU stay. Each entry represents a daily treatment chart or progress note, documenting comprehensive details of patient management at the bedside.