Input:
<None>
Sample query run:
The following is a sample run of the query. The input parameters are highlighted in blue
SELECT concept_name, count(*) as drug_type_count
FROM drug_exposure
JOIN vocabulary.concept ON concept_id = drug_type_concept_id
GROUP BY concept_name
ORDER BY drug_type_count DESC;
Output:
Output field list:
| Field |
Description |
| drug_exposure |
Changed name from drug_ exposure_type. Reference values are now stored as concepts in the concept table. |
| concept_name |
The reason the medication was stopped, where available. Reasons include regimen completed, changed, removed, etc. |
| drug_type_concept_id |
A foreign key to the predefined concept identifier in the vocabulary reflecting the type of drug exposure recorded. It indicates how the drug exposure was represented in the source data: as medication history, filled prescriptions, etc. |
| drug_type_count |
|
Sample output record:
| Field |
Description |
| drug_exposure |
|
| concept_name |
|
| drug_type_concept_id |
|
| drug_type_count |
|
|
|
