The admissions table gives information regarding a patient’s admission to the hospital. Since each unique hospital visit for a patient is assigned a unique
hadm_id, the admissions table can be considered as a definition table for
hadm_id. Information available includes timing information for admission and discharge, demographic information, the source of the admission, and so on.
- patients on
- The data is sourced from the admission, discharge and transfer database from the hospital (often referred to as ‘ADT’ data).
- Organ donor accounts are sometimes created for patients who died in the hospital. These are distinct hospital admissions with very short, sometimes negative lengths of stay. Furthermore, their
deathtimeis frequently the same as the earlier patient admission’s
|Name||Postgres data type|
The admissions table defines all hospitalizations in the database. Hospitalizations are assigned a unique random integer known as the
Each row of this table contains a unique
hadm_id, which represents a single patient’s admission to the hospital.
hadm_id ranges from 2000000 - 2999999. It is possible for this table to have duplicate
subject_id, indicating that a single patient had multiple admissions to the hospital. The ADMISSIONS table can be linked to the PATIENTS table using
admittime provides the date and time the patient was admitted to the hospital, while
dischtime provides the date and time the patient was discharged from the hospital. If applicable,
deathtime provides the time of in-hospital death for the patient. Note that
deathtime is only present if the patient died in-hospital, and is almost always the same as the patient’s
dischtime. However, there can be some discrepancies due to typographical errors.
admission_type is useful for classifying the urgency of the admission. There are 9 possibilities: ‘AMBULATORY OBSERVATION’, ‘DIRECT EMER.’, ‘DIRECT OBSERVATION’, ‘ELECTIVE’, ‘EU OBSERVATION’, ‘EW EMER.’, ‘OBSERVATION ADMIT’, ‘SURGICAL SAME DAY ADMISSION’, ‘URGENT’.
admission_location provides information about the location of the patient prior to arriving at the hospital. Note that as the emergency room is technically a clinic, patients who are admitted via the emergency room usually have it as their admission location.
discharge_location is the disposition of the patient after they are discharged from the hospital.
ethnicity columns provide information about patient demographics for the given hospitalization.
Note that as this data is documented for each hospital admission, they may change from stay to stay.
The date and time at which the patient was registered and discharged from the emergency department.
This is a binary flag which indicates whether the patient died within the given hospitalization.
1 indicates death in the hospital, and
0 indicates survival to hospital discharge.
Was this page helpful?
Glad to hear it! Please raise an issue here to tell us how we can improve.
Sorry to hear that. Please raise an issue here to tell us how we can improve.