MIMIC IV E-R
Tables (31)
admissions
- hadm_id — INT NOT NULL — Primary key
- admittime — TIMESTAMP NOT NULL
- dischtime — TIMESTAMP — NOT NULL
- deathtime — TIMESTAMP — NOT NULL
- admission_type — VARCHAR(40) NOT NULL
- admit_provider_id — VARCHAR(10) — NOT NULL
- admission_location — VARCHAR(60) — NOT NULL
- discharge_location — VARCHAR(60) — NOT NULL
- insurance — VARCHAR(255) — NOT NULL
- language — VARCHAR(10) — NOT NULL
- marital_status — VARCHAR(30) — NOT NULL
- race — VARCHAR(80) — NOT NULL
- edregtime — TIMESTAMP — NOT NULL
- edouttime — TIMESTAMP — NOT NULL
- hospital_expire_flag — SMALLINT — NOT NULL
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
caregiver
- caregiver_id — INT NOT NUL L — Primary key
chartevents
- stay_id — INT NOT NULL — Primary key
- caregiver_id — INT
- charttime — TIMESTAMP NOT NULL
- storetime — TIMESTAMP
- value — VARCHAR(200)
- valuenum — FLOAT
- valueuom — VARCHAR(20)
- warning — SMALLINT
d_hcpcs
- code — CHAR(5) NOT NULL — Primary key — NOT NULL
- category — SMALLINT — NOT NULL
- long_description — TEXT — NOT NULL
- short_description — VARCHAR(180)
d_icd_diagnoses
- icd_code — CHAR(7) NOT NULL — Primary key — NOT NULL
- icd_version — SMALLINT NOT NULL — Primary key
- long_title — VARCHAR(255) — NOT NULL
d_icd_procedures
- icd_code — CHAR(7) NOT NULL — Primary key — NOT NULL
- icd_version — SMALLINT NOT NULL — Primary key
- long_title — VARCHAR(222) — NOT NULL
d_items
- itemid (Field) — INT NOT NULL — Primary key
- label (Field2) — VARCHAR(100) NOT NULL
- abbreviation (Field3) — VARCHAR(50) NOT NULL
- linksto (Field4) — VARCHAR(30) NOT NULL
- category (Field5) — VARCHAR(50) NOT NULL
- unitname (Field6) — VARCHAR(50)
- param_type (Field7) — VARCHAR(20) NOT NULL
- lownormalvalue (Field8) — FLOAT
- highnormalvalue (Field9) — FLOAT
d_labitems
- itemid — INT NOT NULL — Primary key — NOT NULL
- label — VARCHAR(50)
- fluid — VARCHAR(50)
- category — VARCHAR(50)
datetimeevents (Untitled2)
- itemid (Field7) — INT NOT NULL — Primary key
- stay_id (Field3) — INT NOT NULL
- caregiver_id (Field4) — INT
- charttime (Field5) — TIMESTAMP NOT NULL
- storetime (Field6) — TIMESTAMP
- value (Field8) — TIMESTAMP NOT NULL
- valueom (Field9) — TIMESTAMP NOT NULL
- warning (Field10) — SMALLINT
- itemid (Field) — INT NOT NULL — Foreign key → d_items.itemid
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
- stay_id (Field32) — INT NOT NULL — Foreign key → icustays.stay_id
- hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
diagnoses_icd
- hadm_id — INT NOT NULL — Primary key
- seq_num — INT NOT NULL — Primary key
- icd_code — CHAR(7) — Primary key — NOT NULL
- icd_version — SMALLINT — Primary key
- hadm_id (hadm_id2) — INT NOT NULL — Foreign key → admissions.hadm_id
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
drgcodes
- hadm_id — INT NOT NULL — Primary key
- hadm_id (hadm_id2) — INT NOT NULL — Foreign key → admissions.hadm_id
- drg_type — VARCHAR(4) — NOT NULL
- drg_code — VARCHAR(10) NOT NULL
- description — VARCHAR(195)
- drg_severity — SMALLINT — NOT NULL
- drg_mortality — SMALLINT — NOT NULL
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
emar
- emar_id — VARCHAR(25) NOT NULL — Primary key
- emar_seq — INT NOT NULL
- poe_id — VARCHAR(25) NOT NULL
- pharmacy_id — INT
- enter_provider_id — VARCHAR(10)
- charttime — TIMESTAMP NOT NULL
- medication — TEXT
- event_txt — VARCHAR(100)
- scheduletime — TIMESTAMP
- storetime — TIMESTAMP NOT NULL
- hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
emar_detail (Untitled)
- emar_id (Key2) — VARCHAR(25) NOT NULL — Primary key — NOT NULL
- parent_field_ordinal (Key) — VARCHAR(10) — Primary key — NOT NULL
- emar_seq (Field3) — INT NOT NULL
- administration_type (Field5) — VARCHAR(50)
- pharmacy_id (Field6) — INT
- barcode_type (Field7) — VARCHAR(4)
- reason_for_no_barcode (Field8) — TEXT
- complete_dose_not_given (Field9) — VARCHAR(5)
- dose_due (Field10) — VARCHAR(100)
- dose_due_unit (Field11) — VARCHAR(50)
- dose_given (Field12) — VARCHAR(255)
- dose_given_unit (Field13) — VARCHAR(50)
- will_remainder_of_dose_be_given (Field14) — VARCHAR(5)
- product_amount_given (Field15) — VARCHAR(30)
- product_unit (Field16) — VARCHAR(30)
- product_code (Field17) — VARCHAR(30)
- product_description (Field18) — VARCHAR(255)
- product_description_other (Field19) — VARCHAR(255)
- prior_infusion_rate (Field20) — VARCHAR(40)
- infusion_rate (Field21) — VARCHAR(40)
- infusion_rate_adjustment (Field22) — VARCHAR(50)
- infusion_rate_adjustment_amount (Field23) — VARCHAR(30)
- infusion_rate_unit (Field24) — VARCHAR(30)
- route (Field25) — VARCHAR(10)
- infusion_complete (Field26) — VARCHAR(1)
- completion_interval (Field27) — VARCHAR(50)
- new_iv_bag_hung (Field28) — VARCHAR(1)
- continued_infusion_in_other_location (Field29) — VARCHAR(1)
- restart_interval (Field30) — VARCHAR(2305)
- side (Field31) — VARCHAR(10)
- site (Field32) — VARCHAR(255)
- non_formulary_visual_verification (Field33) — VARCHAR(1)
- subject_id (Key3) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
hcpcsevents (Untitled8)
- hadm_id (Key) — INT NOT NULL — Primary key — NOT NULL
- hcpcs_cd (Key2) — CHAR(5) NOT NULL — Primary key — NOT NULL
- seq_num (Key3) — INT NOT NULL — Primary key — NOT NULL
- hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
- hcpcs_cd — CHAR(5) NOT NULL — Foreign key → d_hcpcs.code — NOT NULL
- chartdate (Field3) — DATE
- short_description (Field6) — VARCHAR(180)
- subject_id (Key4) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
icustays (Untitled3)
- stay_id (Field3) — INT NOT NULL — Primary key
- first_careunit (Field4) — VARCHAR(255)
- last_careunit (Field5) — VARCHAR(255)
- intime (Field6) — TIMESTAMP
- outtime (Field7) — TIMESTAMP
- los (Field8) — FLOAT
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
ingredientevents (Untitled4)
- itemid (Field8) — INTEGER NOT NULL — Primary key
- orderid (Field13) — INT NOT NULL — Primary key
- subject_id (Field) — INT NOT NULL
- hadm_id (Field2) — INT NOT NULL
- stay_id (Field3) — INT NOT NULL
- caregiver_id (Field4) — INT
- starttime (Field5) — TIMESTAMP NOT NULL
- endtime (Field6) — TIMESTAMP NOT NULL
- storetime (Field7) — TIMESTAMP
- amount (Field9) — FLOAT
- amountuom (Field10) — VARCHAR(20)
- rate (Field11) — FLOAT
- rateuom (Field12) — VARCHAR(20)
- linkorderid (Field14) — INT
- statusdescription (Field15) — VARCHAR(20)
- originalamount (Field16) — FLOAT
- ariginalrate (Field17) — FLOAT
inputevents (Untitled5)
- orderid (Field13) — INT NOT NULL — Primary key
- itemid (Field8) — INT NOT NULL — Primary key
- itemid (Field20) — INT NOT NULL — Foreign key → d_items.itemid
- Fieldsubject_id (Field) — INT NOT NULL
- caregiver_id (Field4) — INT
- starttime (Field5) — TIMESTAMP NOT NULL
- endtime (Field6) — TIMESTAMP NOT NULL
- storetime (Field7) — TIMESTAMP
- amount (Field9) — FLOAT
- amountuom (Field10) — VARCHAR(20)
- rate (Field11) — FLOAT
- rateuom (Field12) — VARCHAR(20)
- linkorderid (Field14) — INT
- ordercategoryname (Field15) — VARCHAR(50)
- secondaryordercategoryname (Field16) — VARCHAR(50)
- ordercomponenttypedescription (Field17) — VARCHAR(100)
- ordercategorydescription (Field18) — VARCHAR(30)
- patientweight (Field19) — FLOAT
- hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
- stay_id (Field3) — INT NOT NULL — Foreign key → icustays.stay_id
labevents (Untitled9)
- labevent_id (Key) — INT NOT NULL — Primary key — NOT NULL
- hadm_id (Field3) — INT
- specimen_id (Field4) — INT NOT NULL
- order_provider_id (Field6) — VARCHAR(10)
- charttime (Field7) — TIMESTAMP(0)
- storetime (Field8) — TIMESTAMP(0)
- value (Field9) — VARCHAR(200)
- valuenum (Field10) — DOUBLE PRECISION
- valueuom (Field11) — VARCHAR(20)
- ref_range_lower (Field12) — DOUBLE PRECISION
- ref_range_upper (Field13) — DOUBLE PRECISION
- flag (Field14) — VARCHAR(10)
- priority (Field15) — VARCHAR(7)
- comments (Field16) — TEXT
- subject_id (Key2) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
microbiologyevents (Untitled10)
- microevent_id (Key) — INT NOT NULL — Primary key — NOT NULL
- micro_specimen_id (Field4) — INT NOT NULL
- order_provider_id (Field5) — VARCHAR(10)
- chartdate (Field6) — TIMESTAMP(0) NOT NULL
- charttime (Field7) — TIMESTAMP(0)
- spec_itemid (Field8) — INT NOT NULL
- spec_type_desc (Field9) — VARCHAR(100) NOT NULL
- test_seq (Field10) — INT NOT NULL
- storedate (Field11) — TIMESTAMP(0)
- storetime (Field12) — TIMESTAMP(0)
- test_itemid (Field13) — INT
- test_name (Field14) — VARCHAR(100)
- org_itemid (Field15) — INT
- org_name (Field16) — VARCHAR(100)
- isolate_num (Field17) — SMALLINT
- quantity (Field18) — VARCHAR(50)
- ab_itemid (Field19) — INT
- ab_name (Field20) — VARCHAR(30)
- dilution_text (Field21) — VARCHAR(10)
- dilution_comparison (Field22) — VARCHAR(20)
- dilution_value (Field23) — DOUBLE PRECISION
- interpretation (Field24) — VARCHAR(5)
- comments (Field25) — TEXT
- subject_id (Key2) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
omr (Untitled11)
- subject_id (Key) — INT NOT NULL — Primary key — NOT NULL
- chartdate (Field2) — DATE NOT NULL
- seq_num (Field3) — INT NOT NULL
- result_name (Field4) — VARCHAR(100) NOT NULL
- result_value (Field5) — TEXT NOT NULL
outputevents (Untitled6)
- stay_id (Field3) — INT NOT NULL — Primary key
- charttime (Field5) — TIMESTAMP(3) NOT NULL — Primary key
- itemid (Field7) — INT NOT NULL — Primary key
- itemid (Field10) — INT NOT NULL — Foreign key → d_items.itemid
- caregiver_id (Field4) — INT
- storetime (Field6) — TIMESTAMP(3) NOT NULL
- value (Field8) — NOT NULL
- valueuom (Field9) — VARCHAR(20)
- hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
- stay_id (Field32) — INT NOT NULL — Foreign key → icustays.stay_id
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
patients (Untitled12)
- subject_id (Key) — INT NOT NULL — Primary key — NOT NULL
- gender (Field2) — CHAR(1) NOT NULL
- anchor_age (Field3) — SMALLINT
- anchor_year (Field4) — SMALLINT NOT NULL
- anchor_year_group (Field5) — VARCHAR(20) NOT NULL
- dod (Field6) — DATE
pharmacy (Untitled13)
- pharmacy_id (Key) — INT NOT NULL — Primary key — NOT NULL
- poe_id (Field4) — VARCHAR(25)
- starttime (Field5) — TIMESTAMP(3)
- stoptime (Field6) — TIMESTAMP(3)
- medication (Field7) — TEXT
- proc_type (Field8) — VARCHAR(50) NOT NULL
- status (Field9) — VARCHAR(50)
- entertime (Field10) — TIMESTAMP(3) NOT NULL
- verifiedtime (Field11) — TIMESTAMP(3)
- route (Field12) — VARCHAR(50)
- frequency (Field13) — VARCHAR(50)
- disp_sched (Field14) — VARCHAR(255)
- infusion_type (Field15) — VARCHAR(15)
- sliding_scale (Field16) — VARCHAR(1)
- lockout_interval (Field17) — VARCHAR(50)
- basal_rate (Field18) — REAL
- one_hr_max (Field19) — VARCHAR(10)
- doses_per_24_hrs (Field20) — REAL
- duration (Field21) — REAL
- duration_interval (Field22) — VARCHAR(50)
- expiration_value (Field23) — INT
- expiration_unit (Field24) — VARCHAR(50)
- expirationdate (Field25) — TIMESTAMP(3)
- dispensation (Field26) — VARCHAR(50)
- fill_quantity (Field27) — VARCHAR(50)
- subject_id (Key2) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
poe (Untitled14)
- poe_id (Key) — VARCHAR(25) NOT NULL — Primary key — NOT NULL
- poe_seq (Field2) — INT NOT NULL
- subject_id (Field3) — INT NOT NULL
- hadm_id (Field4) — INT
- ordertime (Field5) — TIMESTAMP(0) NOT NULL
- order_type (Field6) — VARCHAR(25) NOT NULL
- order_subtype (Field7) — VARCHAR(50)
- transaction_type (Field8) — VARCHAR(15)
- discontinue_of_poe_id (Field9) — VARCHAR(25)
- discontinued_by_poe_id (Field10) — VARCHAR(25)
- order_provider_id (Field11) — VARCHAR(10)
- order_status (Field12) — VARCHAR(15)
- subject_id (Key2) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
poe_detail
- poe_id — VARCHAR(25) NOT NULL — Primary key — NOT NULL
- field_name — VARCHAR(255) NOT NULL — Primary key — NOT NULL
- poe_id (Key2) — VARCHAR(25) NOT NULL — Foreign key → poe.poe_id — NOT NULL
- poe_seq (poe_se) — INT NOT NULL
- field_value — TEXT
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
prescriptions
- pharmacy_id — INT NOT NULL — Primary key — NOT NULL
- drug_type — VARCHAR(20) NOT NULL — Primary key — NOT NULL
- drug — VARCHAR(255) NOT NULL — Primary key — NOT NULL
- poe_id — VARCHAR(25)
- poe_seq — INT
- order_provider_id — VARCHAR(10)
- starttime — TIMESTAMP(3)
- stoptime — TIMESTAMP(3)
- formulary_drug_cd — VARCHAR(50)
- gsn — VARCHAR(255)
- ndc — VARCHAR(25)
- prod_strength — VARCHAR(255)
- form_rx — VARCHAR(25)
- dose_val_rx — VARCHAR(100)
- dose_unit_rx — VARCHAR(50)
- form_val_disp — VARCHAR(50)
- form_unit_disp — VARCHAR(50)
- doses_per_24_hrs — REAL
- route — VARCHAR(50)
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
procedureevents (Untitled7)
- orderid (Field14) — INT — Primary key
- caregiver_id (Field4) — INT
- starttime (Field5) — TIMESTAMP NOT NULL
- endtime (Field6) — TIMESTAMP NOT NULL
- storetime (Field7) — TIMESTAMP NOT NULL
- value (Field10) — FLOAT
- valueuom (Field11) — VARCHAR(20)
- location (Field12) — VARCHAR(100)
- locationcategory (Field13) — VARCHAR(50)
- linkorderid (Field15) — INT
- ordercategoryname (Field16) — VARCHAR(50)
- ordercategorydescription (Field17) — VARCHAR(30)
- patientweight (Field18) — FLOAT
- isopenbag (Field19) — SMALLINT
- continueinnextdept (Field20) — SMALLINT
- statusdescription (Field21) — VARCHAR(20)
- itemid (Field) — INT NOT NULL — Foreign key → d_items.itemid
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
- stay_id (Field3) — INT NOT NULL — Foreign key → icustays.stay_id
- hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
procedures_icd
- hadm_id — INT NOT NULL — Primary key — NOT NULL
- seq_num — INT NOT NULL — Primary key — NOT NULL
- icd_code — VARCHAR(7) — Primary key — NOT NULL
- icd_version — SMALLINT — Primary key — NOT NULL
- hadm_id (hadm_id2) — INT NOT NULL — Foreign key → admissions.hadm_id
- chartdate — DATE NOT NULL
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
provider
- provider_id — VARCHAR(10) NOT NULL — Primary key
services
- hadm_id — INT NOT NULL — Primary key — NOT NULL
- transfertime — TIMESTAMP NOT NULL — Primary key — NOT NULL
- curr_service — VARCHAR(10) — Primary key — NOT NULL
- hadm_id (hadm_id2) — INT NOT NULL — Foreign key → admissions.hadm_id
- prev_service — VARCHAR(10)
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
transfers
- transfer_id — INT NOT NULL — Primary key
- hadm_id — INT
- eventtype — VARCHAR(10)
- careunit — VARCHAR(255)
- intime — TIMESTAMP
- outtime — TIMESTAMP
- subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL