I'm dipping my toes into the openFDA dataset and want to do some searches related to congenital anomalies. I know this data is searchable because the folks at Social Health Insights have built a wonderful tool utilizing this as a search parameter.

I've done some reading about the fields in the FAERS structure and the following queries work:

  1. ?search=_exists_:seriousnessdeath&limit=5
  2. ?search=_exists_:seriousnesslifethreatening&limit=5
  3. ?search=_exists_:seriousnesshospitalization&limit=5
  4. ?search=_exists_:seriousnessdisabling&limit=5
  5. ?search=_exists_:seriousnessother&limit=5

But the same query doesn't work for seriousnesscongenitalanomaly


Any ideas what I'm doing wrong?


Thanks for the complement on our ResearchAE.com project. Glad you found it useful and as an example of what people can do with the openFDA data.

To answer your question, I believe the query you mean to be doing is this:


Clickable link for that openFDA query: https://api.fda.gov/drug/event.json?search=exists:seriousnesscongenitalanomali&limit=5

  • Perfect. Thanks, Mark. Keep up the good work at ResearchAE. – Ryan Jul 26 '14 at 15:00
  • Ryan - No problem! BTW - I noticed from your profile that you're in Indy too. Consider tweeting out to @geek_nurse who is in Indy too and built most of researchae.com. Have fun! – Mark Silverberg Jul 26 '14 at 15:02
  • Will do, for sure! – Ryan Jul 28 '14 at 10:09

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.