.

Tables (31)

admissions

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER
  • admittime — TIMESTAMP
  • dischtime — TIMESTAMP
  • deathtime — TIMESTAMP
  • admission_type — VARCHAR(255)
  • admit_provider_id — VARCHAR(255) — Foreign key → provider.provider_id
  • admission_location — VARCHAR(255)
  • discharge_location — VARCHAR(255)
  • insurance — VARCHAR(255)
  • language — VARCHAR(255)
  • marital_status — VARCHAR(255)
  • race — VARCHAR(255)
  • edregtime — TIMESTAMP
  • edouttime — TIMESTAMP
  • hospital_expire_flag — INTEGER

caregiver

  • caregiver_id — INTEGER

chartevents

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • stay_id — INTEGER — Foreign key → icustays.stay_id
  • caregiver_id — INTEGER — Foreign key → caregiver.caregiver_id
  • charttime — TIMESTAMP
  • storetime — TIMESTAMP
  • itemid — INTEGER — Foreign key → d_items.itemid
  • value — NUMERIC
  • valuenum — NUMERIC
  • valueuom — VARCHAR(255)
  • warning — VARCHAR(255)

d_hcpcs

  • code — VARCHAR(255)
  • category — VARCHAR(255)
  • long_description — VARCHAR(255)
  • short_description — VARCHAR(255)

d_icd_diagnoses

  • icd_code — VARCHAR(255)
  • icd_version — INTEGER
  • long_title — VARCHAR(255)

d_icd_procedures

  • icd_code — VARCHAR(255)
  • icd_version — INTEGER
  • long_title — VARCHAR(255)

d_items

  • itemid — INTEGER
  • label — VARCHAR(255)
  • abbreviation — VARCHAR(255)
  • linksto — VARCHAR(255)
  • category — VARCHAR(255)
  • unitname — VARCHAR(255)
  • param_type — VARCHAR(255)
  • lownormalvalue — NUMERIC
  • highnormalvalue — NUMERIC

d_labitems

  • itemid — INTEGER
  • label — VARCHAR(255)
  • fluid — VARCHAR(255)
  • category — VARCHAR(255)

datetimeevents

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • stay_id — INTEGER — Foreign key → icustays.stay_id
  • caregiver_id — INTEGER — Foreign key → caregiver.caregiver_id
  • charttime — TIMESTAMP
  • storetime — TIMESTAMP
  • itemid — INTEGER — Foreign key → d_items.itemid
  • value — NUMERIC
  • valueuom — VARCHAR(255)
  • warning — VARCHAR(255)

diagnoses_icd

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • seq_num — INTEGER
  • icd_code — VARCHAR(255) — Foreign key → d_icd_diagnoses.icd_code
  • icd_version — INTEGER — Foreign key → d_icd_diagnoses.icd_version

drgcodes

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • drg_type — VARCHAR(255)
  • drg_code — VARCHAR(255)
  • description — VARCHAR(255)
  • drg_severity — NUMERIC
  • drg_mortality — NUMERIC

emar

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • emar_id — VARCHAR(255)
  • emar_seq — INTEGER
  • poe_id — VARCHAR(255) — Foreign key → poe.poe_id
  • pharmacy_id — INTEGER — Foreign key → pharmacy.pharmacy_id
  • enter_provider_id — VARCHAR(255) — Foreign key → provider.provider_id
  • charttime — TIMESTAMP
  • medication — VARCHAR(255)
  • event_txt — VARCHAR(255)
  • scheduletime — TIMESTAMP
  • storetime — TIMESTAMP

emar_detail

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • emar_id — VARCHAR(255) — Foreign key → emar.emar_id
  • emar_seq — INTEGER
  • parent_field_ordinal — VARCHAR(255)
  • administration_type — VARCHAR(255)
  • pharmacy_id — INTEGER — Foreign key → pharmacy.pharmacy_id
  • barcode_type — VARCHAR(255)
  • reason_for_no_barcode — VARCHAR(255)
  • complete_dose_not_given — VARCHAR(255)
  • dose_due — VARCHAR(255)
  • dose_due_unit — VARCHAR(255)
  • dose_given — VARCHAR(255)
  • dose_given_unit — VARCHAR(255)
  • will_remainder_of_dose_be_given — VARCHAR(255)
  • product_amount_given — VARCHAR(255)
  • product_unit — VARCHAR(255)
  • product_code — VARCHAR(255)
  • product_description — VARCHAR(255)
  • product_description_other — VARCHAR(255)
  • prior_infusion_rate — VARCHAR(255)
  • infusion_rate — VARCHAR(255)
  • infusion_rate_adjustment — VARCHAR(255)
  • infusion_rate_adjustment_amount — VARCHAR(255)
  • infusion_rate_unit — VARCHAR(255)
  • route — VARCHAR(255)
  • infusion_complete — VARCHAR(255)
  • completion_interval — VARCHAR(255)
  • new_iv_bag_hung — VARCHAR(255)
  • continued_infusion_in_other_location — VARCHAR(255)
  • restart_interval — VARCHAR(255)
  • side — VARCHAR(255)
  • site — VARCHAR(255)
  • non_formulary_visual_verification — VARCHAR(255)

hcpcsevents

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • chartdate — DATE
  • hcpcs_cd — VARCHAR(255) — Foreign key → d_hcpcs.code
  • seq_num — INTEGER
  • short_description — VARCHAR(255)

icustays

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • stay_id — INTEGER
  • first_careunit — VARCHAR(255)
  • last_careunit — VARCHAR(255)
  • intime — TIMESTAMP
  • outtime — TIMESTAMP
  • los — NUMERIC

ingredientevents

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • stay_id — INTEGER — Foreign key → icustays.stay_id
  • caregiver_id — INTEGER — Foreign key → caregiver.caregiver_id
  • starttime — TIMESTAMP
  • endtime — TIMESTAMP
  • storetime — TIMESTAMP
  • itemid — INTEGER — Foreign key → d_items.itemid
  • amount — NUMERIC
  • amountuom — VARCHAR(255)
  • rate — NUMERIC
  • rateuom — VARCHAR(255)
  • orderid — INTEGER
  • linkorderid — INTEGER
  • statusdescription — VARCHAR(255)
  • originalamount — NUMERIC
  • originalrate — NUMERIC

inputevents

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • stay_id — INTEGER — Foreign key → icustays.stay_id
  • caregiver_id — INTEGER — Foreign key → caregiver.caregiver_id
  • starttime — TIMESTAMP
  • endtime — TIMESTAMP
  • storetime — TIMESTAMP
  • itemid — INTEGER — Foreign key → d_items.itemid
  • amount — NUMERIC
  • amountuom — VARCHAR(255)
  • rate — NUMERIC
  • rateuom — VARCHAR(255)
  • orderid — INTEGER
  • linkorderid — INTEGER
  • ordercategoryname — VARCHAR(255)
  • secondaryordercategoryname — VARCHAR(255)
  • ordercomponenttypedescription — VARCHAR(255)
  • ordercategorydescription — VARCHAR(255)
  • patientweight — NUMERIC
  • totalamount — NUMERIC
  • totalamountuom — VARCHAR(255)
  • isopenbag — VARCHAR(255)
  • continueinnextdept — VARCHAR(255)
  • statusdescription — VARCHAR(255)
  • originalamount — NUMERIC
  • originalrate — NUMERIC

labevents

  • labevent_id — INTEGER
  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • specimen_id — INTEGER
  • itemid — INTEGER — Foreign key → d_labitems.itemid
  • order_provider_id — VARCHAR(255) — Foreign key → provider.provider_id
  • charttime — TIMESTAMP
  • storetime — TIMESTAMP
  • value — NUMERIC
  • valuenum — NUMERIC
  • valueuom — VARCHAR(255)
  • ref_range_lower — NUMERIC
  • ref_range_upper — NUMERIC
  • flag — VARCHAR(255)
  • priority — VARCHAR(255)
  • comments — VARCHAR(255)

microbiologyevents

  • microevent_id — INTEGER
  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • micro_specimen_id — INTEGER
  • order_provider_id — VARCHAR(255) — Foreign key → provider.provider_id
  • chartdate — DATE
  • charttime — TIMESTAMP
  • spec_itemid — INTEGER
  • spec_type_desc — VARCHAR(255)
  • test_seq — INTEGER
  • storedate — TIMESTAMP
  • storetime — TIMESTAMP
  • test_itemid — INTEGER
  • test_name — VARCHAR(255)
  • org_itemid — INTEGER
  • org_name — VARCHAR(255)
  • isolate_num — INTEGER
  • quantity — VARCHAR(255)
  • ab_itemid — INTEGER
  • ab_name — VARCHAR(255)
  • dilution_text — VARCHAR(255)
  • dilution_comparison — VARCHAR(255)
  • dilution_value — NUMERIC
  • interpretation — VARCHAR(255)
  • comments — VARCHAR(255)

omr

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • chartdate — DATE
  • seq_num — INTEGER
  • result_name — VARCHAR(255)
  • result_value — VARCHAR(255)

outputevents

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • stay_id — INTEGER — Foreign key → icustays.stay_id
  • caregiver_id — INTEGER — Foreign key → caregiver.caregiver_id
  • charttime — TIMESTAMP
  • storetime — TIMESTAMP
  • itemid — INTEGER — Foreign key → d_items.itemid
  • value — NUMERIC
  • valueuom — VARCHAR(255)

patients

  • subject_id — INTEGER
  • gender — VARCHAR(255)
  • anchor_age — INTEGER
  • anchor_year — INTEGER
  • anchor_year_group — VARCHAR(255)
  • dod — DATE

pharmacy

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • pharmacy_id — INTEGER
  • poe_id — VARCHAR(255) — Foreign key → poe.poe_id
  • starttime — TIMESTAMP
  • stoptime — TIMESTAMP
  • medication — VARCHAR(255)
  • proc_type — VARCHAR(255)
  • status — VARCHAR(255)
  • entertime — TIMESTAMP
  • verifiedtime — TIMESTAMP
  • route — VARCHAR(255)
  • frequency — VARCHAR(255)
  • disp_sched — VARCHAR(255)
  • infusion_type — VARCHAR(255)
  • sliding_scale — VARCHAR(255)
  • lockout_interval — VARCHAR(255)
  • basal_rate — NUMERIC
  • one_hr_max — VARCHAR(255)
  • doses_per_24_hrs — NUMERIC
  • duration — NUMERIC
  • duration_interval — VARCHAR(255)
  • expiration_value — NUMERIC
  • expiration_unit — VARCHAR(255)
  • expirationdate — TIMESTAMP
  • dispensation — VARCHAR(255)
  • fill_quantity — VARCHAR(255)

poe

  • poe_id — VARCHAR(255)
  • poe_seq — INTEGER
  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • ordertime — TIMESTAMP
  • order_type — VARCHAR(255)
  • order_subtype — VARCHAR(255)
  • transaction_type — VARCHAR(255)
  • discontinue_of_poe_id — VARCHAR(255)
  • discontinued_by_poe_id — VARCHAR(255)
  • order_provider_id — VARCHAR(255) — Foreign key → provider.provider_id
  • order_status — VARCHAR(255)

poe_detail

  • poe_id — VARCHAR(255) — Foreign key → poe.poe_id
  • poe_seq — INTEGER
  • subject_id — INTEGER — Foreign key → patients.subject_id
  • field_name — VARCHAR(255)
  • field_value — VARCHAR(255)

prescriptions

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • pharmacy_id — INTEGER — Foreign key → pharmacy.pharmacy_id
  • poe_id — VARCHAR(255) — Foreign key → poe.poe_id
  • poe_seq — INTEGER
  • order_provider_id — VARCHAR(255) — Foreign key → provider.provider_id
  • starttime — TIMESTAMP
  • stoptime — TIMESTAMP
  • drug_type — VARCHAR(255)
  • drug — VARCHAR(255)
  • formulary_drug_cd — VARCHAR(255)
  • gsn — VARCHAR(255)
  • ndc — VARCHAR(255)
  • prod_strength — VARCHAR(255)
  • form_rx — VARCHAR(255)
  • dose_val_rx — VARCHAR(255)
  • dose_unit_rx — VARCHAR(255)
  • form_val_disp — VARCHAR(255)
  • form_unit_disp — VARCHAR(255)
  • doses_per_24_hrs — NUMERIC
  • route — VARCHAR(255)

procedureevents

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • stay_id — INTEGER — Foreign key → icustays.stay_id
  • caregiver_id — INTEGER — Foreign key → caregiver.caregiver_id
  • starttime — TIMESTAMP
  • endtime — TIMESTAMP
  • storetime — TIMESTAMP
  • itemid — INTEGER — Foreign key → d_items.itemid
  • value — NUMERIC
  • valueuom — VARCHAR(255)
  • location — VARCHAR(255)
  • locationcategory — VARCHAR(255)
  • orderid — INTEGER
  • linkorderid — INTEGER
  • ordercategoryname — VARCHAR(255)
  • ordercategorydescription — VARCHAR(255)
  • patientweight — NUMERIC
  • isopenbag — VARCHAR(255)
  • continueinnextdept — VARCHAR(255)
  • statusdescription — VARCHAR(255)
  • ORIGINALAMOUNT — NUMERIC
  • ORIGINALRATE — NUMERIC

procedures_icd

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • seq_num — INTEGER
  • chartdate — DATE
  • icd_code — VARCHAR(255) — Foreign key → d_icd_procedures.icd_code
  • icd_version — INTEGER — Foreign key → d_icd_procedures.icd_version

provider

  • provider_id — VARCHAR(255)

services

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • transfertime — TIMESTAMP
  • prev_service — VARCHAR(255)
  • curr_service — VARCHAR(255)

transfers

  • subject_id — INTEGER — Foreign key → patients.subject_id
  • hadm_id — INTEGER — Foreign key → admissions.hadm_id
  • transfer_id — INTEGER
  • eventtype — VARCHAR(255)
  • careunit — VARCHAR(255)
  • intime — TIMESTAMP
  • outtime — TIMESTAMP