title: "patients table"
linktitle: "patients"
date: 2020-08-10
weight: 1
description: >
Patients' gender, age, and date of death if information exists.
Information that is consistent for the lifetime of a patient is stored in this table.
Name | Postgres data type |
---|---|
subject_id |
INTEGER NOT NULL |
gender |
VARCHAR(1) NOT NULL |
anchor_age |
INTEGER NOT NULL |
anchor_year |
INTEGER NOT NULL |
anchor_year_group |
VARCHAR(255) NOT NULL |
dod |
TIMESTAMP(0) |
subject_id
subject_id
is a unique identifier which specifies an individual patient. Any rows associated with a single subject_id
pertain to the same individual. As subject_id
is the primary key for the table, it is unique for each row.
gender
gender
is the genotypical sex of the patient.
anchor_age
, anchor_year
, anchor_year_group
These columns provide information regarding the actual patient year for the patient admission, and the patient's age at that time.
anchor_year
is a shifted year for the patient.anchor_year_group
is a range of years - the patient's anchor_year
occurred during this range.anchor_age
is the patient's age in the anchor_year
. If a patient's anchor_age
is over 89 in the anchor_year
then their anchor_age
is set to 91, regardless of how old they actually were.anchor_year
of 2153, anchor_year_group
of 2008 - 2010, and an anchor_age
of 60.dod
The de-identified date of death for the patient. Date of death is extracted from two sources: the hospital information system and the Massachusetts State Registry of Vital Records and Statistics.
Individual patient records from MIMIC were matched to the vital records using a custom algorithm based on identifiers including name, social security number, and date of birth.
As a result of the linkage, out of hospital mortality is available for MIMIC-IV patients up to one year post-hospital discharge. All patient deaths occurring more than one year after hospital discharge are censored.
Survival studies should incorporate this into their design.