Input:
| Parameter |
Example |
Mandatory |
Notes |
| ancestor_concept_id |
4324992 |
Yes |
Antithrombins
|
Sample query run:
The following is a sample run of the query. The input parameters are highlighted in blue.
SELECT count(distinct d.person_id) as person_count
FROM vocabulary.concept_ancestor ca,
drug_exposure d
WHERE ca.ancestor_concept_id = 4324992
AND d.drug_concept_id = ca.descendant_concept_id
group by ca.ancestor_concept_id
;
Output:
Output field list:
| Field |
Description |
person_count
|
A foreign key that refers to a standard concept identifier in the vocabulary for the drug concept. |
Sample output record:
| Field |
Description |
| drug_concept_id |
|
| descendant_concept_id |
|
| ancestor_concept_id |
|
|
|
