inst/QueryLibrary/Aggregate/drug_exposure/DEX19.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

DEX19: How many people are taking a drug for a given indication?

Description

Query

The following is a sample run of the query. The input parameters are highlighted in

/* indication and associated drug ids */
SELECT c1.concept_name, COUNT(DISTINCT de.person_id) AS count_value
  FROM @vocab.concept c1
  JOIN @vocab.concept_ancestor ca
    ON ca.ancestor_concept_id = c1.concept_id
  JOIN @cdm.drug_exposure de
    ON ca.descendant_concept_id = de.drug_concept_id
  JOIN @vocab.concept c2
    ON de.drug_concept_id  = c2.concept_id
 WHERE c1.concept_name     = 'Tuberculosis'   
   AND c1.concept_class_id = 'Ind / CI'
   AND c2.domain_id        = 'Drug'
   AND c2.vocabulary_id    = 'RxNorm'
   AND c2.standard_concept = 'S'
 GROUP BY c1.concept_name;  

Input

| Parameter | Example | Mandatory | Notes | | --- | --- | --- | --- | | concept_name | Tuberculosis | Yes |

Output

| Field | Description | | --- | --- | | concept_name | The reason the medication was stopped, where available. Reasons include regimen completed, changed, removed, etc. | | count | |

Example output record

| Field | Description | | --- | --- | | concept_name | | | count | |

Documentation

https://github.com/OHDSI/CommonDataModel/wiki/

sib-swiss/dsQueryLibraryServer documentation built on Feb. 13, 2025, 8:07 p.m.