I am a beginning user of the MIMIC III database, and I would like to query the database to get a list of all patients in Mimic III that have had a blood transfusion (ICD 9 code 9901 - 9905). Does any one know of a tutorial that might help me do this query? Thank you for any help or suggestions you can give.

  • 1
    SELECT DISTINCT(subject_id) FROM mimiciii.procedures_icd WHERE icd9_code IN ('9901','9902','9903','9904','9905') ORDER BY subject_id – Dr D.C. Ross Jan 31 '20 at 10:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.