Skip to content

Instantly share code, notes, and snippets.

@thadguidry

thadguidry/drugs_with_rxnormid

Created January 14, 2021 16:38
Show Gist options
  • Save thadguidry/012e64dada71e374f253663860933953 to your computer and use it in GitHub Desktop.
Save thadguidry/012e64dada71e374f253663860933953 to your computer and use it in GitHub Desktop.
Download ZIP
All subclasses of Drugs including Pharmaceutical Products with an RXNormID
Raw
drugs_with_rxnormid
#Drugs (and all subclasses of Drugs) with an RXNormID
SELECT ?item ?itemLabel ?rxNormID
WHERE
{
?item wdt:P31/wdt:P279* wd:Q8386 .
?item wdt:P3345 ?rxNormID .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment