Drug Exposure‎ > ‎

DEX25: Counts of drug records

This query is used to count drugs (drug_concept_id) across all drug exposure records. 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 possible values are summarized.

 Parameter  Example  Mandatory  Notes
list of drug_concept_id 906805, 1517070, 19010522 Yes Metoclopramid, Desmopressin, Cyclosprin

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

SELECT count(1) as exposure_occurrence_count 
FROM drug_exposure d
WHERE d.drug_concept_id in (906805, 1517070, 19010522)
Output field list:
 Field  Description
exposure_occurrence_count The number of individual drug exposure occurrences used to construct the drug era.

Sample output record:
 Field  Value
exposure_occurrence_count  88318