I want to find all patients that have measurements for some predefined variables. However items names for carevue and metavision db are different (e.g. Carevue - 'NBP [Systolic], metavision- "Non Invasive Blood Pressure systolic"). Do you have some script to unify these two tables? What strategy should I follow?


I found in mimic github the script pivoted-vital.sql that solved my problem:

This query pivots the vital signs for the first 24 hours of a patient's stay
Vital signs include heart rate, blood pressure, respiration rate, and temperature

  • This query pivots more than the first 24 hours. – costa_25 Mar 6 '18 at 14:01

Your Answer

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

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