SafeICU v1.0 documentation

SafeICU is a relational database containing tables of patient data from patients who stayed in the intensive care units at AIIMS, Delhi. Each table is similar to a spreadsheet: each column contains a specific type of information and each row corresponds to an entity such as a patient or event.

Tables are linked via SUBJECT_ID, which uniquely identifies each patient across all tables. Some tables also use ROW_ID, a row identifier unique within that table.

List of tables

The following tables are used to define and track patient stays:

PATIENT. Contains one record per unique patient in the database and defines the SUBJECT_ID, which serves as the primary identifier.

ADMISSION. Contains hospitalization details for each patient, linked through SUBJECT_ID.

The following tables contain data collected in the intensive care unit:

NOTE EVENTS. Contains treatment charts summarizing diagnoses and medications given, recorded by caregivers.

VITAL SIGNS. Vital-sign measurements—covering heart rate, respiratory rate, blood pressure, oxygen saturation, and temperature.

The following tables contain data collected in the hospital record system:

LAB EVENTS. Includes results of laboratory investigations such as hematology, biochemistry, and infection markers, along with measurement units and collection timestamps.

MICROBIOLOGY EVENTS. Captures results of microbiological tests, including culture findings, organism identification, and antimicrobial susceptibility.

Table descriptions

Use the links below to jump to detailed documentation for each table:

• The patients table
• The admissions table
• The lab events table
• The microbiology events table
• The note events table
• The vitals table