inspectomop.queries.drug.ingredient_concept_ids_for_ingredient_names

inspectomop.queries.drug.ingredient_concept_ids_for_ingredient_names(ingredient_names, inspector, return_columns=None)

Get concept_ids for a list of ingredients.

Parameters:
  • ingredient_names (list of str) –
  • inspector (inspectomop.inspector.Inspector) –
  • return_columns (list of str, optional) –
    • optional subset of columns to return from the query
    • columns : [‘ingredient_name’, ‘concept_id’]
Returns:

results
Return type:

inspectomop.results.Results

Notes

Original SQL:

SELECT
    concept_id,
    concept_name
FROM
    concept,
WHERE
    vocabulary_id = 'RxNorm'
    AND concept_class_id = 'Ingredient'
    AND lower(concept_name) IN ('ingredient_name_1')