4

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

?search=_exists_:seriousnesscongenitalanomaly&limit=5

Any ideas what I'm doing wrong?

1 Answer 1

4

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:

https://api.fda.gov/drug/event.json?search=_exists_:seriousnesscongenitalanomali&limit=5

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

3
  • Perfect. Thanks, Mark. Keep up the good work at ResearchAE.
    – Ryan
    Jul 26, 2014 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! Jul 26, 2014 at 15:02
  • Will do, for sure!
    – Ryan
    Jul 28, 2014 at 10:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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