Drug Exposure‎ > ‎

DEX04: Distribution of gender in persons taking a drug

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

 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 drug.concept_name AS drug_name
     , drug_concept_id
     , gender.concept_name AS gender
     , count(*) as num_persons
  FROM -- patient, gender, exposure to drug
     ( SELECT DISTINCT person_id, gender_concept_id,  drug_concept_id
         FROM drug_exposure
         JOIN person USING( person_id )
        WHERE drug_concept_id
           IN /* crestor 20 and 40 mg tablets */
            ( 40165254, 40165258 )
  JOIN vocabulary.concept drug ON drug.concept_id = drug_concept_id
  JOIN vocabulary.concept gender ON gender.concept_id = gender_concept_id
 GROUP BY drug.concept_name, drug_concept_id, gender.concept_name
 ORDER BY drug_name, gender;

Output field list:
 Field  Description
drug_name An unambiguous, meaningful and descriptive name for the drug concept.
drug_concept_id A foreign key that refers to a standard concept identifier in the vocabulary for the drug concept.
The gender of the counted persons exposed to drug.
The number of persons of a particular gender exposed to drug.

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