The noteevents table
Table source: Hospital database.
Table purpose: Contains all notes for patients.
Number of rows: 2,083,180
- PATIENTS on
- ADMISSIONS on
- CAREGIVERS on
TEXTis often large and contains many newline characters: it may be easier to read if viewed in a distinct program rather than the one performing the queries.
- Echo reports, ECG reports, and radiology reports are available for both inpatient and outpatient stays. If a patient is an outpatient, there will not be an
HADM_IDassociated with the note. If the patient is an inpatient, but was not admitted to the ICU for that particular hospital admission, then there will not be an
HADM_IDassociated with the note.
- Echos are generated using templates and in some cases there may be discrepancies in severity. For example one report may contain: “Mild PA systolic hypertension. Severe PA systolic hypertension.” indicating that the caregiver may not have removed the appropriate item from the template.
|Name||Postgres data type|
Identifiers which specify the patient:
SUBJECT_ID is unique to a patient and
HADM_ID is unique to a patient hospital stay.
CHARTDATE records the date at which the note was charted.
CHARTDATE will always have a time value of 00:00:00.
CHARTTIME records the date and time at which the note was charted. If both
CHARTTIME exist, then the date portions will be identical. All records have a
CHARTDATE. A subset are missing
CHARTTIME. More specifically, notes with a
CATEGORY value of ‘Discharge Summary’, ‘ECG’, and ‘Echo’ never have a
CHARTDATE. Other categories almost always have both
CHARTDATE, but there is a small amount of missing data for
CHARTTIME (usually less than 0.5% of the total number of notes for that category).
STORETIME records the date and time at which a note was saved into the system.
Notes with a
CATEGORY value of ‘Discharge Summary’, ‘ECG’, ‘Radiology’, and ‘Echo’ never have a
STORETIME. All other notes have a
DESCRIPTION define the type of note recorded. For example, a
CATEGORY of ‘Discharge’ indicates that the note is a discharge note, and a
DESCRIPTION of ‘Summary’ in conjunction with this indicates that the note is a discharge summary.
CGID is the identifier for the caregiver who input the note.
A ‘1’ in the
ISERROR column indicates that a physician has identified this note as an error.
TEXT contains the note text.