I'm trying to build a workflow model for subjects in the MIMIC-III data set. there's clearly no shortage of activities in here but if I were trying to track the major steps in the process (treatment protocol?) it might start with a patient (subject_id) admission (hadm_id), showing up at a site (admission_location), and subsequently leaving (discharge_location). But given the number of items in Chartevents, Datetimeevents, Procedureevents and others, quite a bit takes place at the detail level and it's not clear if there's a summary level available or one that I can create.

So if I was trying to show the patient arriving, getting some treatment (perhaps a treatment in some major category e.g. the service description in Services or diagnosis), getting admitted, getting more treatment (same or new diagnosis), getting admitted to the ICU, getting more treatment (same or new diagnosis), getting better and getting discharged.

Is there a strategy that might be helpful to map out the basic flow from a higher level?

  • Sorry my Latin is weak. Yes "etal" was supposed to be et al or just in simple terms "and others". As for "10K'", it's shorthand for 10,000 feet and is used to mean at a higher level. in my case I'm looking for major activities that may have a number of supporting minor activities and, in my shorthand, these major activities would be the ones at 10K'. I hope this helps. Commented Apr 4, 2018 at 14:46

1 Answer 1


The transfers table will track patients; so that gives you the "flow" of a patient through the hospital.

As for capturing the "major" events, that's pretty subjective, and the data is wholly ICU focused with very little data captured outside the ICU. So, you could use code in the mimic-code repository to define dialysis, ventilation, vasopressor usage, or something similar, but this would be ICU specific.

Alternatively, you could use the CPT codes or ICD-9 procedure codes to define events which occurred in the hospital, but these codes aren't timestamped.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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