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.
Input:
| 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:
Output field list:
| Field |
Description |
| specialty |
The concept name of the specialty concept
|
prescriptions_count
|
The count of drug exposure records providers from the specialties are listed as prescribing provider.
|
Sample output record:
| Field |
Value |
specialty
|
Family Practice |
prescriptions_count
|
214825 |
| 