DEX18: What is the distribution of DRUG_TYPE_CONCEPT_ID (modes of distribution) for a given drug?

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.