Canada Vigilance Adverse Reaction Online Database




Submitted by Hao Yi on Sun, 03/02/2014 - 18:47

Please consolidate the dose units in report_drug such that all the doses are in the same order of magnitude. (e.g. mg --> grams) (mg/kg --> mg taken since weight is reported). Also, please check for the integrity of the data with respect to dosages as some are off by orders of magnitude. Lastly, please check for typographical errors when inputting drug names.



Submitted by AP on Tue, 11/29/2016 - 19:49

Hello, I have some valuable inputs but first can you please confirm if questions or comments here are replied by owner on this page?


Submitted by open-ouvert on Wed, 11/30/2016 - 14:35

AP - we share comments and questions on our site with the dataholder - in this case, we'll forward your comment to Health Canada. This database can also be found here and if you prefer to forward suggestions or comments directly to Health Canada offices, have a look here for some specific ways to get in touch

Hope this is helpful!
Karin - the open-ouvert team


Submitted by Asif Patel on Mon, 12/05/2016 - 19:37

Since this is critical for user who exports the data from these extract files to create a database I thought of sharing it here.
In API world "" are delimiters in extract files which is seen here too. However I experienced that even data is entered with quotations (" ") in some extracts files and it results in missing data when imported into a database. Machine can't distinguish it. e.g. Drug Product Ingredient table: $"ENBREL "IMMUNEX""$. The end result is only ENBREL. IMMUNEX is lost due to extra quotation. I understand that its verbatim but please use some other special characters that are not delimiters. Please take any necessary action to solve this perhaps before next quarterly update release.

Add new comment