Drug Exposure‎ > ‎

DEX01: Counts of persons with any number of exposures to a certain drug

This query is used to count the persons with at least one exposures to a certain drug (drug_concept_id).  See vocabulary queries for obtaining valid drug_concept_id values. The input to the query is a value (or a comma-separated list of values) of a drug_concept_id. If the input is omitted, all drugs in the data table are summarized.

Input:
 Parameter  Example  Mandatory  Notes
list of drug_concept_id 40165254, 40165258 No
Crestor 20 and 40 mg tablets

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

SELECT concept_name AS drug_name
     , drug_concept_id
     , count(*) as num_persons
  FROM -- unique patient id taking drug
     ( SELECT person_id, drug_concept_id
         FROM drug_exposure
        WHERE drug_concept_id
           IN /* crestor 20 and 40 mg tablets */
            ( 40165254, 40165258 )
     )
  JOIN vocabulary.concept ON concept_id = drug_concept_id
 GROUP BY concept_name, drug_concept_id;

Output:
Output field list:
 Field  Description
drug_name An unambiguous, meaningful and descriptive name for the concept.
drug_concept_id A foreign key that refers to a standard concept identifier in the vocabulary for the drug concept. 
num_persons The patients count

Sample output record:
 Field  Content
drug_name  Rosuvastatin calcium 20 MG Oral Tablet [Crestor]
drug_concept_id  40165254
num_persons  191244
Comments