inspectomop.queries.drug.drug_concepts_for_ingredient_concept_id

inspectomop.queries.drug.drug_concepts_for_ingredient_concept_id(concept_id, inspector, return_columns=None)

Get all drugs that contain a given ingredient.

Parameters:

• concept_id (int) – concept_id corresponding to a drug ingredient
• inspector (inspectomop.inspector.Inspector) –
• return_columns (list of str, optional) –
  • optional subset of columns to return from the query
  • columns : [‘ingredient_concept_id’, ‘ingredient_name’, ‘ingredient_concept_code’, ‘ingredient_concept_class_id’, ‘drug_concept_id’, ‘drug_name’,’drug_concept_code’, ‘drug_concept_class_id’]

Returns:

results

Return type:

inspectomop.results.Results

Notes

Original SQL

D04: Find drugs by ingredient:

SELECT
    A.concept_id Ingredient_concept_id,
    A.concept_Name Ingredient_name,
    A.concept_Code Ingredient_concept_code,
    A.concept_Class_id Ingredient_concept_class,
    D.concept_id Drug_concept_id,
    D.concept_Name Drug_name,
    D.concept_Code Drug_concept_code,
    D.concept_Class_id Drug_concept_class
FROM
    concept_ancestor CA,
    concept A,
    concept D
WHERE
    CA.ancestor_concept_id = A.concept_id
    AND CA.descendant_concept_id = D.concept_id
    AND sysdate BETWEEN A.valid_start_date AND A.valid_end_date
    AND sysdate BETWEEN D.valid_start_date AND D.valid_end_date
    AND CA.ancestor_concept_id = 966991;