The patients table
Table source: Hospital database.
Table purpose: Defines each SUBJECT_ID in the database, i.e., defines a single patient.
Number of rows: 1,196
Links to:
- ADMISSIONS on SUBJECT_ID
Table columns
| Name | Data type |
|---|---|
| ROW_ID | INT |
| SUBJECT_ID | INT |
| GENDER | VARCHAR(5) |
| AGE_YEARS | FLOAT |
| EXPIRE_FLAG | VARCHAR(5) |
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.
GENDER
GENDER is the patient's genotypical sex.
AGE_YEARS
AGE_YEARS indicates the age of the patient, expressed in years,
calculated at the time of ICU admission.
EXPIRE_FLAG
EXPIRE_FLAG is a binary indicator denoting in-hospital mortality. A value of 1 indicates that the patient died during hospitalization, while 0 indicates survival until discharge.