Cookbook of sql scripts for MIMIC-II

List of functions

• Age (age.sql)
• Basic Patient Info (basic_patient_info.sql)
• Billirubun (bun.sql)
• SAPS-I formula (create_saps_formula.sql)
• Calculate Elixhauser scores (exlihauser_comorbidity.sql)
• Glasgow Coma Score (gcs.sql)
• Blood glucose (glucose.sql)
• Bicarbonate (hco.sql)
• Hematocrit (hct.sql)
• Heart Rate (heart_rate.sql)
• Height (height.sql)
• Insulin delivered (insulin_doses.sql)
• Blood pressure from hospital survivors (min_surviving_bp.sql)
• Number of patients (number_of_patients.sql)
• Blood serum potassium (potassium.sql)
• Respitation rate (rr.sql)
• Create SAPS-I (saps_create_24hr_minmax.sql)
• Systolic Blood Pressure (sbp.sql)
• Sodium in blood serum (sodium.sql)
• Insert SOFA scores (sofa_score_inserts.sql)
• Urine Output (uo.sql)
• White blood cell count (wbc.sql)