Drug Exposure‎ > ‎

DEX13: Distribution of provider specialities prescribing a given drug

This query provides the provider specialties prescribing a given drug, and the frequencies for each provider prescribing the drug (drug exposure records). Note that many databases do not record the prescribing provider for drugs. See vocabulary queries for obtaining valid drug_concept_id values. 

 Parameter  Example  Mandatory  Notes
drug_concept_id 19121608 Yes Influenza virus vaccine

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

SELECT concept_name AS specialty
, count(*) AS prescriptions_count
FROM -- first prescribing provider for statin
( SELECT person_id, prescribing_provider_id
FROM drug_exposure
WHERE drug_concept_id = 19121608 /* Influenza virus vaccine */
AND NVL( prescribing_provider_id, 0 ) > 0
 JOIN provider ON provider_id = prescribing_provider_id
JOIN vocabulary.concept ON concept_id = specialty_concept_id
GROUP BY concept_name
ORDER BY prescriptions_count desc;
Output field list:
 Field  Description
specialty The concept name of the specialty concept
The count of drug exposure records providers from the specialties are listed as prescribing provider.

Sample output record:
 Field  Value
 Family Practice