Drug Ingredients
To create the mappings, clinical data was pulled in two waves from an OMOP (v5.0) PEDSNet (v3.0)-normalized instance of Children's Hospital of Colorado data (#15-0445). A total of 56,200 drug-ingredient concepts were eligible for mapping (51,941 drugs; 11,807 ingredients). The first waved returned all drug concepts used at least 1 time in practice (9,175 drugs; 1,697 ingredients). The second wave returned all RxNorm concepts (42,766 drugs; 10,110 ingredients).
SQL Queries
- Drug Exposure Ingredients Used in Practice (
GitHub Gist) - Standard RxNorm Drug Ingredients Concepts (
GitHub Gist)
An example of the output data produced by these queries is shown below (click on image to enlarge it):
OMOP Drug Exposure ingredient concept ids were mapped to:
- Chemicals, hormones, and enzymes (Chemical Entities of Biological Interest (CHEBI))
- Organisms (NCBI Organism Taxonomy (NCBITaxon))
- Proteins (Protein Ontology (PR))
- Vaccines/Immunizations (Vaccine Ontology (VO))
An example of the mappings generated for the concepts in the table above shown below (click on image to enlarge it):
