I run two queries for the daily number of reports for bextra and avandia:



The avandia search produces the results I expect, the bextra search does not. The bextra search is run for the months prior to its withdrawal. I do not believe that there wasn't a single report in those months. Can anyone clarify what's going on?


The short answer is that when you do the following API call, you see that bextra shows up in the patient.drug.medicinalproduct instead of patient.drug.brand_name.


So I suggest doing the following:


You can read up on why this is at https://github.com/FDA/openfda/issues/22

| improve this answer | |

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.