ezFAERS: Encoding FDA Adverse Event Reporting System with Drug Identifiers for Improved Data Quality and Query Performance

Current FAERS data: 2004Q1 – 2017Q2 (update every 6 months).

The entire Encoded-FAERS relational database is also available for download as MySQL, PostgreSQL, or SQLite data dump upon request. Please send your request to xudong@isu.edu

Please cite this work:
ezFAERS: Encoding FDA Adverse Event Reporting System with Drug Identifiers for Improved Data Quality and Query Performance. Xu D*, Caylor ML, Niu J, Tivis RD, Gawron JE, Tao A, Dang HK, Johnson RW, Economen PJ, Ham AG, Lai JK, Culbertson VL, 2018, web access http://dxulab.org/software

How to use:

Step 1: Select a search type or user input and enter data.
Step 2: Select desired search options.
Step 3: Click Search.

For more information on the FAERS database structure click here.

Search by name Search by code User MySQL query


Search Options:

Match type: Equals Like Regular Expression
Equals: Exact match. Like: Uses mysql built in wildcard matching. (% is the wildcard character.) Searches can also be done using regular expressions to match names.

Do not querry entries from duplicate Safety Reports.
Group by: Medicinal Product GPI8 DrugBank
Results: 10 20 50 all