mimic-iv
Tables (31)
admissions
- hadm_id — INTEGER — Primary key — NOT NULL
- admittime — TIMESTAMP — NOT NULL
- dischtime — TIMESTAMP
- deathtime — TIMESTAMP
- admission_type — VARCHAR(40) — NOT NULL
- admit_provider_id — VARCHAR(10)
- admission_location — VARCHAR(60)
- discharge_location — VARCHAR(60)
- insurance — VARCHAR(255)
- language — VARCHAR(25)
- marital_status — VARCHAR(30)
- race — VARCHAR(80)
- edregtime — TIMESTAMP
- edouttime — TIMESTAMP
- hospital_expire_flag — SMALLINT
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
caregiver
- caregiver_id — INTEGER — Primary key — NOT NULL
chartevents
- subject_id — INTEGER — Primary key — NOT NULL
- itemid — INTEGER — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- stay_id — INTEGER — Foreign key → icustays.stay_id — NOT NULL
- charttime — TIME — NOT NULL
- storetime — TIME
- value — VARCHAR(500)
- valuenum — FLOAT
- valueuom — VARCHAR(500)
- warning — FLOAT
- caregiver_id — INTEGER
d_hcpcs
- code — VARCHAR(255) — Primary key — NOT NULL
- category — FLOAT
- long_description — VARCHAR(255)
- short_description — VARCHAR(180)
d_icd_diagnoses
- icd_code — VARCHAR(10) — Primary key — NOT NULL
- icd_version — INTEGER — Primary key — NOT NULL
- long_title — VARCHAR(255)
d_icd_procedures
- icd_code — VARCHAR(10) — Primary key — NOT NULL
- icd_version — INTEGER — Primary key — NOT NULL
- long_title — VARCHAR(255)
d_items
- itemid — INTEGER — Primary key — NOT NULL
- label — VARCHAR(200) — NOT NULL
- abbreviation — VARCHAR(100) — NOT NULL
- linksto — VARCHAR(50) — NOT NULL
- category — VARCHAR(100) — NOT NULL
- unitname — VARCHAR(100)
- param_type — VARCHAR(30) — NOT NULL
- lownormalvalue — FLOAT
- highnormalvalue — FLOAT
d_labitems
- itemid — INTEGER — Primary key — NOT NULL
- label — VARCHAR(100)
- fluid — VARCHAR(100)
- category — VARCHAR(100)
datetimeevents
- charttime — TIME — Primary key — NOT NULL
- stay_id — INTEGER — Foreign key → icustays.stay_id — NOT NULL
- itemid — INTEGER — Foreign key → d_items.itemid — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- storetime — TIME
- value — TIME — NOT NULL
- valueuom — VARCHAR(20)
- warning — INT
- caregiver_id — INTEGER — Foreign key → caregiver.caregiver_id — NOT NULL
diagnoses_icd
- seq_num — INTEGER — Primary key — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- icd_code — VARCHAR(10)
- icd_version — SMALLINT
drgcodes
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- drg_type — VARCHAR(20) — NOT NULL
- drg_code — INTEGER — NOT NULL
- description — VARCHAR(255) — NOT NULL
- drg_severity — FLOAT
- drg_mortality — FLOAT
emar
- emar_id — INTEGER — Primary key — NOT NULL
- emar_seq — INTEGER — Primary key — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id
- poe_id — VARCHAR(25) — NOT NULL
- pharmacy_id — INTEGER
- enter_provider_id (INDEX) — VARCHAR(255)
- charttime — TIMESTAMP — NOT NULL
- medication — VARCHAR(255)
- event_txt — VARCHAR(100)
- scheduletime — TIMESTAMP
- storetime — TIMESTAMP — NOT NULL
emar_detail
- emar_id — VARCHAR(25) — Primary key — NOT NULL
- emar_seq — INTEGER — Primary key — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- parent_field_ordinal — INTEGER
- administration_type — INTEGER
- pharmacy_id — INTEGER
- barcode_type — VARCHAR(50)
- reason_for_no_barcode — VARCHAR(255)
- complete_dose_not_given — VARCHAR(50)
- dose_due — VARCHAR(100)
- dose_due_unit — VARCHAR(50)
- dose_given — VARCHAR(100)
- dose_given_unit — VARCHAR(100)
- will_remainder_of_dose_be_given — VARCHAR(50)
- product_amount_given — FLOAT
- product_unit — VARCHAR(50)
- product_code — VARCHAR(100)
- product_description — VARCHAR(100)
- product_description_other — VARCHAR(100)
- prior_infusion_rate — FLOAT
- infusion_rate — FLOAT
- infusion_rate_adjustment — VARCHAR(100)
- infusion_rate_adjustment_amount — FLOAT
- infusion_rate_unit — VARCHAR(100)
- route — VARCHAR(100)
- infusion_complete — VARCHAR(100)
- completion_interval — VARCHAR(100)
- new_iv_bag_hung — VARCHAR(100)
- continued_infusion_in_other_location — VARCHAR(100)
- restart_interval — VARCHAR(100)
- side — VARCHAR(100)
- site — VARCHAR(100)
- non_formulary_visual_verification — VARCHAR(100)
hcpcsevents
- seq_num — INTEGER — Primary key — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- hcpcs_cd — VARCHAR(10) — Foreign key → d_hcpcs.code — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- chartdate — DATETIME — NOT NULL
- short_description — VARCHAR(100) — NOT NULL
icustays
- stay_id — INTEGER — Primary key — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- first_careunit — VARCHAR(20) — NOT NULL
- last_careunit — VARCHAR(20) — NOT NULL
- intime — VARCHAR(500) — NOT NULL
- outtime — VARCHAR(500) — NOT NULL
- los — FLOAT — NOT NULL
ingredientevents
- orderid — INTEGER — Primary key — NOT NULL
- starttime — TIME — Primary key — NOT NULL
- endtime — TIME — Primary key — NOT NULL
- itemid — INTEGER — Foreign key → d_items.itemid — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- stay_id — INTEGER — Foreign key → icustays.stay_id — NOT NULL
- storetime — VARCHAR(500) — NOT NULL
- amount — FLOAT
- amountuom — VARCHAR(20) — NOT NULL
- rate — DOUBLE
- rateuom — VARCHAR(20)
- linkorderid — INTEGER — NOT NULL
- statusdescription — VARCHAR(30) — NOT NULL
- originalamount — INTEGER — NOT NULL
- originalrate — FLOAT — NOT NULL
- caregiver_id — FLOAT — Foreign key → caregiver.caregiver_id — NOT NULL
inputevents
- orderid — INTEGER — Primary key — NOT NULL
- itemid — INTEGER — Foreign key → d_items.itemid — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- stay_id — INTEGER — Foreign key → icustays.stay_id — NOT NULL
- starttime — DATETIME — NOT NULL
- endtime — DATETIME — NOT NULL
- storetime — DATETIME — NOT NULL
- amount — FLOAT — NOT NULL
- amountuom — VARCHAR(500) — NOT NULL
- rate — FLOAT
- rateuom — VARCHAR(20)
- linkorderid — INTEGER — NOT NULL
- ordercategoryname — VARCHAR(100) — NOT NULL
- secondaryordercategoryname — VARCHAR(100)
- ordercomponenttypedescription — VARCHAR(100) — NOT NULL
- ordercategorydescription — VARCHAR(50)
- patientweight — VARCHAR(100) — NOT NULL
- totalamount — VARCHAR(100)
- totalamountuom — VARCHAR(20)
- isopenbag — INTEGER — NOT NULL
- continueinnextdept — INTEGER — NOT NULL
- statusdescription — VARCHAR(30) — NOT NULL
- originalamount — FLOAT — NOT NULL
- originalrate — FLOAT — NOT NULL
- caregiver_id — INTEGER — Foreign key → caregiver.caregiver_id — NOT NULL
labevents
- labevent_id — INTEGER — Primary key — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INTEGER
- specimen_id — INTEGER — NOT NULL
- itemid — INTEGER — Foreign key → d_labitems.itemid — NOT NULL
- order_provider_id — VARCHAR(10)
- charttime — DATETIME — NOT NULL
- storetime — DATETIME
- value — VARCHAR(200)
- valuenum — FLOAT
- valueuom — VARCHAR(20)
- ref_range_lower — FLOAT
- ref_range_upper — FLOAT
- flag — VARCHAR(10)
- priority — VARCHAR(7)
- comments — VARCHAR(200)
microbiologyevents
- microevent_id — INTEGER — Primary key — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id
- micro_specimen_id — INTEGER — NOT NULL
- order_provider_id — VARCHAR(10)
- chartdate — TIME — NOT NULL
- charttime — TIME
- spec_itemid — INTEGER — NOT NULL
- spec_type_desc — VARCHAR(100) — NOT NULL
- test_seq — INTEGER — NOT NULL
- storedate — TIME
- storetime — TIME
- test_itemid — INTEGER — NOT NULL
- test_name — VARCHAR(100) — NOT NULL
- org_itemid — INTEGER
- org_name — VARCHAR(100)
- isolate_num — INTEGER
- quantity — VARCHAR(50)
- ab_itemid — INTEGER
- ab_name — VARCHAR(50)
- dilution_text — VARCHAR(10)
- dilution_comparison — VARCHAR(20)
- dilution_value — FLOAT
- interpretation — VARCHAR(5)
- comments — VARCHAR(500)
omr
- chartdate — DATE — Primary key — NOT NULL
- seq_num — INTEGER — Primary key — NOT NULL
- result_name — VARCHAR(100) — Primary key — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- result_value — VARCHAR(255) — NOT NULL
outputevents
- charttime — TIMESTAMP — Primary key — NOT NULL
- stay_id — INTEGER — Foreign key → icustays.stay_id — NOT NULL
- itemid — INTEGER — Foreign key → d_items.itemid — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- storetime — TIME — NOT NULL
- value — INTEGER — NOT NULL
- valueuom — VARCHAR(20) — NOT NULL
- caregiver_id — INTEGER — NOT NULL
patients
- subject_id — INTEGER — Primary key — NOT NULL
- gender — VARCHAR(1) — NOT NULL
- anchor_age — INTEGER — NOT NULL
- anchor_year — INTEGER — NOT NULL
- anchor_year_group — VARCHAR(20) — NOT NULL
- dod — TIMESTAMP
pharmacy
- pharmacy_id — INTEGER — Primary key — NOT NULL
- poe_id — VARCHAR(25)
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- starttime — DATETIME — NOT NULL
- stoptime — DATETIME
- medication — VARCHAR(255)
- proc_type — VARCHAR(50) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- entertime — DATETIME — NOT NULL
- verifiedtime — DATETIME
- route — VARCHAR(50)
- frequency — VARCHAR(50)
- disp_sched — VARCHAR(255)
- infusion_type — VARCHAR(255)
- sliding_scale — VARCHAR(50)
- lockout_interval — FLOAT
- basal_rate — FLOAT
- one_hr_max — FLOAT
- doses_per_24_hrs — FLOAT
- duration — FLOAT
- duration_interval — VARCHAR(50)
- expiration_value — FLOAT
- expiration_unit — VARCHAR(50)
- expirationdate — INTEGER
- dispensation — VARCHAR(50)
- fill_quantity — FLOAT
poe
- poe_id — VARCHAR(25) — Primary key — NOT NULL
- poe_seq — INTEGER — Primary key — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- ordertime — DATETIME — NOT NULL
- order_type — VARCHAR(50) — NOT NULL
- order_subtype — VARCHAR(50)
- transaction_type — VARCHAR(50) — NOT NULL
- discontinue_of_poe_id — VARCHAR(25)
- discontinued_by_poe_id — VARCHAR(25)
- order_provider_id — VARCHAR(10)
- order_status — VARCHAR(50) — NOT NULL
poe_detail
- field_name — VARCHAR(255) — Primary key — NOT NULL
- poe_id — VARCHAR(25) — Foreign key → poe.poe_id — NOT NULL
- poe_seq — INTEGER — Foreign key → poe.poe_seq — NOT NULL
- field_value — VARCHAR(255) — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
prescriptions
- pharmacy_id — INTEGER — Primary key — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- poe_id (pod_id) — VARCHAR(500)
- poe_seq — INTEGER
- order_provider_id — VARCHAR(120)
- starttime — TIME — NOT NULL
- stoptime — TIME
- drug_type — VARCHAR(100) — NOT NULL
- drug — VARCHAR(100) — NOT NULL
- formulary_drug_cd — VARCHAR(120)
- gsn — VARCHAR(120)
- ndc — VARCHAR(20)
- prod_strength — VARCHAR(120)
- form_rx — VARCHAR(120)
- dose_val_rx — VARCHAR(120)
- dose_unit_rx — VARCHAR(120)
- form_val_disp — VARCHAR(120)
- form_unit_disp — VARCHAR(120)
- doses_per_24_hrs — FLOAT
- route — VARCHAR(120)
procedureevents
- orderid — INTEGER — Primary key — NOT NULL
- itemid — INTEGER — Primary key — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- stay_id — INTEGER — Foreign key → icustays.stay_id — NOT NULL
- starttime — TIME — NOT NULL
- endtime — TIME — NOT NULL
- storetime — TIME — NOT NULL
- value — FLOAT — NOT NULL
- valueuom — VARCHAR(20)
- location — VARCHAR(100)
- locationcategory — VARCHAR(100)
- linkorderid — INTEGER — NOT NULL
- ordercategoryname — VARCHAR(100) — NOT NULL
- ordercategorydescription — VARCHAR(50) — NOT NULL
- patientweight — FLOAT — NOT NULL
- isopenbag — INTEGER — NOT NULL
- continueinnextdept — INTEGER — NOT NULL
- statusdescription — VARCHAR(30) — NOT NULL
- ORIGINALAMOUNT — FLOAT — NOT NULL
- ORIGINALRATE — INTEGER — NOT NULL
- subject_id — INTEGER — NOT NULL
- caregiver_id — INTEGER — Foreign key → caregiver.caregiver_id — NOT NULL
procedures_icd
- seq_num — INTEGER — Primary key — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- chartdate — DATE — NOT NULL
- icd_code — VARCHAR(10) — NOT NULL
- icd_version — INTEGER — NOT NULL
provider
- provider_id — VARCHAR(10) — Primary key — NOT NULL
services
- transfertime — VARCHAR(20) — Primary key — NOT NULL
- hadm_id — INTEGER — Foreign key → admissions.hadm_id — NOT NULL
- subject_id — INTEGER — Foreign key → patients.subject_id — NOT NULL
- prev_service — VARCHAR(20)
- curr_service — VARCHAR(20) — NOT NULL
transfers
- transfer_id — INTEGER — Primary key — NOT NULL
- hadm_id — INTEGER
- eventtype — VARCHAR(20) — NOT NULL
- careunit — VARCHAR(20)
- intime — TIME — NOT NULL
- outtime — TIME
- subject_id — INTEGER — NOT NULL