MIMICiv-Pro2

Tables (31)

hosp_admission

  • hadm_id — NOT NULL — Primary key — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • admittime — NOT NULL
  • dischtime — NULL
  • deathtime — NULL
  • admission_type — NOT NULL
  • admit_provider_id
  • admission_location
  • discharge_location
  • insurance
  • language
  • marital_status
  • race
  • edregtime
  • edouttime
  • hospital_expire_flag

hosp_d_hcpcs

  • code — NOT NULL — Primary key — NOT NULL
  • category
  • long_description
  • short_description

hosp_d_icd_diagnoses

  • icd_code — NOT NULL — Primary key — NOT NULL
  • icd_version — NOT NULL — Primary key — NOT NULL
  • long_title

hosp_d_icd_procedures

  • icd_code — NOT NULL — Primary key — NOT NULL
  • icd_version — NOT NULL — Primary key — NOT NULL
  • long_title

hosp_d_labitems

  • itemid — NOT NULL — Primary key — NOT NULL
  • label
  • fluid — NOT NULL
  • category

hosp_diagnoses_icd

  • seq_num — NOT NULL — Primary key — NOT NULL
  • icd_code — Primary key — NOT NULL
  • icd_version — Primary key — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL

hosp_drgcodes

  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • drg_type
  • drg_code — NOT NULL
  • description
  • drg_severity
  • drg_mortality

hosp_emar

  • emar_id — NOT NULL — Primary key — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • emar_seq — NOT NULL
  • poe_id — NOT NULL
  • pharmacy_id
  • enter_provider_id
  • charttime — NOT NULL
  • medication
  • event_txt
  • scheduletime
  • storetime — NOT NULL

hosp_emar_detail

  • parent_field_ordinal — Primary key — NOT NULL
  • emar_id — NOT NULL — Foreign key → hosp_emar.emar_id — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • emar_seq — NOT NULL
  • administration_type
  • pharmacy_id
  • barcode_type
  • reason_for_no_barcode
  • complete_dose_not_given
  • dose_due
  • dose_due_unit
  • dose_given
  • dose_given_unit
  • will_remainder_of_dose_be_given
  • product_amount_given
  • product_unit
  • product_code
  • product_description
  • product_description_other
  • prior_infusion_rate
  • infusion_rate
  • infusion_rate_adjustment
  • infusion_rate_adjustment_amount
  • infusion_rate_unit
  • route
  • infusion_complete
  • completion_interval
  • new_iv_bag_hung
  • continued_infusion_in_other_location
  • restart_interval
  • side
  • site
  • non_formulary_visual_verification

hosp_hosp_omr

  • subject_id — NOT NULL
  • chartdate — NOT NULL
  • seq_num — NOT NULL
  • result_name — NOT NULL
  • result_value — NOT NULL

hosp_hpcsevents

  • seq_num — NOT NULL — Primary key — NOT NULL
  • hcpcs_cd — NOT NULL — Foreign key → hosp_d_hcpcs.code — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • chartdate — NOT NULL
  • short_description

hosp_labevents

  • labevent_id — NOT NULL — Primary key — NOT NULL
  • itemid — NOT NULL — Foreign key → hosp_d_labitems.itemid — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • hadm_id
  • specimen_id — NOT NULL
  • order_provider_id
  • charttime
  • storetime
  • value
  • valuenum
  • valueuom
  • ref_range_lower
  • ref_range_upper
  • flag
  • priority
  • comments

hosp_microbiologyevents

  • microevent_id — NOT NULL — Primary key — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • micro_specimen_id — NOT NULL
  • order_provider_id
  • chartdate — NOT NULL
  • charttime
  • spec_itemid — NOT NULL
  • spec_type_desc — NOT NULL
  • test_seq — NOT NULL
  • storedate
  • storetime
  • test_itemid
  • test_name
  • org_itemid
  • org_name
  • isolate_num
  • quantity
  • ab_itemid
  • ab_name
  • dilution_text
  • dilution_comparison
  • dilution_value
  • interpretation
  • comments

hosp_patients

  • subject_id — NOT NULL — Primary key — NOT NULL
  • gender — NOT NULL
  • anchor_age
  • anchor_year — NOT NULL
  • anchor_year_group — NOT NULL
  • dod

hosp_pharmacy

  • pharmacy_id — NOT NULL — Primary key — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • poe_id
  • starttime
  • stoptime
  • medication
  • proc_type — NOT NULL
  • status
  • entertime — NOT NULL
  • verifiedtime
  • route
  • frequency
  • disp_sched
  • infusion_type
  • sliding_scale
  • lockout_interval
  • basal_rate
  • one_hr_max
  • doses_per_24_hrs
  • duration
  • duration_interval
  • expiration_value
  • expiration_unit
  • expirationdate
  • dispensation
  • fill_quantity

hosp_poe

  • poe_id — NOT NULL — Primary key — NOT NULL
  • poe_seq — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • ordertime — NOT NULL
  • order_type — NOT NULL
  • order_subtype
  • transaction_type
  • discontinue_of_poe_id
  • discontinued_by_poe_id
  • order_provider_id
  • order_status

hosp_poe_detail

  • field_name — NOT NULL — Primary key — NOT NULL
  • poe_id — NOT NULL — Foreign key → hosp_poe.poe_id — NOT NULL
  • poe_seq — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • field_value

hosp_prescriptions

  • pharmacy_id — NOT NULL — Primary key — NOT NULL
  • drug_type — NOT NULL — Primary key — NOT NULL
  • drug — NOT NULL — Primary key — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • poe_id
  • poe_seq
  • order_provider_id
  • starttime
  • stoptime
  • formulary_drug_cd
  • gsn
  • ndc
  • prod_strength
  • form_rx
  • dose_val_rx
  • dose_unit_rx
  • form_val_disp
  • form_unit_disp
  • doses_per_24_hrs
  • route

hosp_procedures_icd

  • seq_num — NOT NULL — Primary key — NOT NULL
  • icd_code — Primary key — NOT NULL
  • icd_version — Primary key — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • chartdate — NOT NULL

hosp_provider

  • provider_id — NOT NULL — Primary key — NOT NULL

hosp_service

  • transfertime — NOT NULL — Primary key — NOT NULL
  • curr_service — Primary key — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • prev_service

hosp_transfers

  • transfer_id — NOT NULL — Primary key — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • hadm_id
  • eventtype
  • careunit
  • intime
  • outtime

icu_Ingredientevents

  • subject_id
  • hadm_id (hamd_id)
  • stay_id
  • caregiver_id
  • starttime
  • endtime
  • storetime
  • itemid
  • amount
  • amountuom
  • rate
  • rateuom
  • orderid
  • linkorderid
  • statusdescription
  • originalamount
  • originalrate

icu_caregiver

  • caregiver_id — NOT NULL

icu_chartevents

  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • stay_id — Foreign key → icu_icustays.stay_id — NOT NULL
  • caregiver_id
  • carttime
  • storetime
  • itemid — Foreign key → icu_d_items.itemid — NOT NULL
  • value
  • valuenum
  • valueuom
  • warning

icu_d_items

  • itemid — Primary key — NOT NULL
  • label
  • abbreviation
  • linksto
  • category
  • unitname
  • param_type
  • lownormalvalue
  • highnormalvalue

icu_datetimeevents

  • charttime — Primary key — NOT NULL
  • itemid — Foreign key → icu_d_items.itemid — NOT NULL
  • stay_id — Foreign key → icu_icustays.stay_id — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • caregiver_id
  • storetime
  • value

icu_icustays

  • stay_id — Primary key — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • first_careunit
  • last_careunit
  • intime
  • outtime
  • los

icu_inputevents

  • orderid — Primary key — NOT NULL
  • itemid — Foreign key → icu_d_items.itemid — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • stay_id — Foreign key → icu_icustays.stay_id — NOT NULL
  • caregiver_id
  • starttimes (starttime)
  • endtime
  • storetime
  • amount
  • amountuom
  • rate
  • rateuom
  • linkorderid
  • ordercategoryname
  • secondaryordercategoryname
  • ordercomponenttypedescription
  • patientweight
  • totalamount
  • totalamountuom
  • isopenbag
  • statusdescription
  • originalamount

icu_outputevents

  • charttime — Primary key — NOT NULL
  • itemid — Foreign key → icu_d_items.itemid — NOT NULL
  • stay_id — Foreign key → icu_icustays.stay_id — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • caregiver_id
  • storetime
  • value
  • valueuom

icu_procedureevents

  • orderid — Primary key — NOT NULL
  • hadm_id — NOT NULL — Foreign key → hosp_admission.hadm_id — NOT NULL
  • subject_id — NOT NULL — Foreign key → hosp_patients.subject_id — NOT NULL
  • stay_id — Foreign key → icu_icustays.stay_id — NOT NULL
  • caregiver_id
  • starttime
  • endtime
  • storetime
  • itemid — Foreign key → icu_d_items.itemid — NOT NULL
  • value
  • valueuom
  • location
  • locationcategoryname
  • linkorderid
  • ordercategoryname
  • ordercategorydescription
  • patientweight
  • isopenbag
  • continueinnextdept
  • statusdescription
  • originalamount
  • originalrate