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