Drug Queries‎ > ‎

D29: Find ingredient approval

This query is designed to provide approval information for the ingredient

Input:
 Parameter  Example  Mandatory  Notes
 Ingredient Concept ID  1713332  Yes Concept ID for ingredient - 'Amoxicillin'

Sample query run:
The following are sample runs of the query. The input parameters are highlighted in blue.
SELECT ingredient_concept_id,
       c.concept_name AS ingredient_name,
       approval_date,
       approved_by
FROM drug_approval a, concept c
WHERE ingredient_concept_id = concept_id
  AND ingredient_concept_id = 1713332
Output:
Output field list:
 Field  Description
 Ingredient_Concept_ID  Concept ID of the ingredient
 Ingredient_Name  Name of the ingredient
 Approval_Date  Date when ingredient has been approved
 Approved_By  Agency that has that approved ingredient

Sample output record:
 Field  Value
 Ingredient_Concept_ID  1713332
 Ingredient_Name  Amoxicillin
 Approval_Date  12/9/1974
 Approved_By  FDA
Comments