I am working on a project to predict Septic Shock on MIMIC III data set.
I am using the following ICD9-CODes to detect Sepsis but not sure how to get the date + time stamp when the patient was diagnosed. diagnoses_icd table does not have a date and time stamp.
"99591";"Sepsis" "99592";"Severe sepsis" "78552";"Septic shock"
Not sure how the diagnoses_icd table was linked to Date and Time for the patients, say Septic Shock. Thanks.