This is a preview version of OpenVigil. Maybe, some calculations and buttons will not work as expected!
This version operates on Canadian pharmacovigilance data - please use english (pardonnez-moi) MedDRA terms for adverse events
and INN or USAN drugnames!
Note that the user interface is not yet completely updated. Please ignore the FDA-specific terminology.
This web application permits you to access pharmacovigilance data and process a query on it, e.g. extracting individual safety reports (ISR) or counts or disproportionality analyses on selected cases.
Visit openvigil.sf.net for the Legalese, info on cave-ats, tutorials and
analysis examples as well as other tools for accessing, extracting, mining and analysing pharmacovigilance data
like OpenVigil 2 (includes drugname mapping and advanced filtering options) or OpenVigilFDA (uses up-to-date
cleaned data via the openFDA API.
Press to display more information about the database structure and content.
Refer to this overview of this installation to obtain detailed information for citation of data extracted by this installation.
Registered tables are:
Interesting fields for novice users might be DRUG.DRUGNAME (=name given by the pharmacovigilance data source, e.g., USAN or INN, but other names are used (list), too) and REAC.PT (the adverse reaction coded as MedDRA Preferred Term (click here for a list).
For advanced users: a description of the content of tables and columns in these tables can be found in chapters B. FILE DESCRIPTIONS, C. DATA ELEMENT DESCRIPTIONS, D. DATA ELEMENT CONTENTS AND MAXIMUM LENGTHS of the FDA Asc_nts.doc database description document (created by the FDA and can also be found in the archive of the original FDA AERS quaterly data file packages).
Note that DEMO.CASE is called DEMO.CASENO in OpenVigil 1.
OpenVigil 1 uses a DMAP table (which is automatically generated when using cleaned pharmacovigilance data (e.g., German or Canadian data).
When using U.S. american FDA AERS ASCII data, mapping (e.g., via RxNorm) is necessary. OpenVigil 2 and OpenVigilFDA provide automatic drugname mapping.
Import failures from the original pharmacovigilance data source into this database can be found in the data import table from aers2sql for this instance of OpenVigil. Pitfalls and shortcomings of pharmacovigilance data analyses are described in the OpenVigil Cave-At document.