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.

  • Did you identify how to resolve this? – Diya Aug 8 '18 at 14:37

It is important to be aware that the ICD-9 codes are assigned to hospital stays primarily for billing purposes. The codes are recorded by a coding team upon patient discharge, following a review of the health records. No specific time or date is associated with the codes.

Two relevant timestamps are the admission and discharge times associated with the hospital stay ID ('hadm_id'). If you would like to find more specific time points associated with ICD-related events, one option would be to review the nursing notes.

  • Thank you Tomp. I looked at the noteevents and looks like not a reliable way to find out when the septic shock happened or onset of septic shock happened. Not sure how to find the onset (date & time) of the septic shock. any pointers is much appreciated. – Sara Mar 29 '16 at 16:35

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.