1

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 anyone know of a tutorial that might help me do this query?

Improve this question
1
  • 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
    Commented Jan 31, 2020 at 10:53

0

Reset to default

Your Answer

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

Browse other questions tagged or ask your own question.