-
Notifications
You must be signed in to change notification settings - Fork 25
Open
Description
The FAERS build used 20150717 VOCAB and LAERTES now uses 20160311 Vocab and some concepts are now deprecated.
However there only seems to be 3 CONCEPT_IDs with this issue:
19121608 Influenza virus vaccine
45892244 Articaine / Epinephrine Prefilled Syringe
46233855 oldaterol / tiotropium Metered Dose Inhaler
Found this using this query:
SELECT EVIDENCE_TYPE, SUPPORTS, DRUG_CONCEPT_ID, DRUG_CONCEPT_NAME, COUNT(*)
FROM EV_INGREDIENTS
WHERE INGREDIENT_EXISTS = 0
AND EVIDENCE_TYPE LIKE 'aers%'
GROUP BY EVIDENCE_TYPE, SUPPORTS, DRUG_CONCEPT_ID, DRUG_CONCEPT_NAME
ORDER BY 5 DESC, 1, 3 Metadata
Metadata
Assignees
Labels
No labels