OHDSI Home | Forums | Wiki | Github

How can I query the vocabularies for "All Antibiotics"?

Vocabulary Users
,
#1

I am currently trying to use the hierarchy structure of the vocabulary in order to be able to find all instances of antibiotics within the vocabulary. What would be a sample query to find all antibiotic drugs?

#2

@mimictoomopplease:

I assume by “antibiotics” you mean antibacterial drugs, correct? No chemo, no antivirals, no antifungals, no local antiseptics. Try ATC J01 concept_id 21602796 “ANTIBACTERIALS FOR SYSTEMIC USE”.

#3

Yes that is what I meant. Would the query simply be finding all of the descendants of the concept code you mentioned above?

#4

@mimictoomopplease:

Yes.

select descendant_concept_id from concept_ancestor where ancestor_concept_id=21602796
t