.
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