i2b2 Web Client
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

Question

 

Find patients who have a diagnosis of Acute MI documented at any time in their history and they have a medication with a dose greater than 500 mg and a medication that is taken once a day documented during the same instance.


Result

There are 3 patients who have had

  • A medication with a dose of 500 mg and 
  • AND a frequency of once a day entered as a fact in the observation_fact table
  • Where the medication dose and frequency have the same encounter_num , concept_cd, provider_id, start_date, AND instance_num
  • AND the diagnosis of acute MI
  • AND the medication dose and frequency all have the same patient_num



Step-by-step guide