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 |
|