Drug Era‎ > ‎

DER09: Counts of persons taking drugs

This query is used to count the persons with any number of eras with exposure 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. If the input is omitted, all possible values are summarized.

 Parameter  Example  Mandatory  Notes
list of drug_concept_id 1304643, 1549080 Yes

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

select count(distinct r.person_id) as persons_count
from drug_era r
where r.drug_concept_id in (1304643, 1549080)
Output field list:
 Field  Description
drug_concept_id A foreign key that refers to a standard concept identifier in the vocabulary for the drug concept.
person_id A foreign key identifier to the person who is subjected to the drug during the drug era. The demographic details of that person are stored in the person table.
count The number of individual drug exposure occurrences used to construct the drug era.

Sample output record:
 Field  Description