Canada Vigilance Adverse Reaction Online Database

Vote

Comments

Permalink

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.

Thanks!

Permalink

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?

Permalink

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 http://www.hc-sc.gc.ca/dhp-mps/medeff/databasdon/index-eng.php 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 http://www.hc-sc.gc.ca/contact/index-eng.php.

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

Permalink

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