0

I am trying to extract the top 100 drugs related to the highest number of adverse reaction of a specific type.

For example, I would like to extract the top 100 drugs that have been reported as associated with the adverse reaction "nausea".

The query I use is the following:

https://api.fda.gov/drug/event.json?search=patient.reaction.reactionmeddrapt:nausea&limit=100&count=patient.drug.activesubstance.activesubstancename 

The problem is that, for compound names that include a space, the two terms are reported as separate (e.g. "HYDROXYZINE HYDROCHLORIDE" is reported as "HYDROXYZINE" and "HYDROCHLORIDE"). As a consequence, "hydrochloride" is obviously reported on top for most of the compounds just for being the most used solvent in compound names, but the list goes on also for multiple other solvents.

How can I extract the complete compound names from the query?

Thanks

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.