Software for National Risk Assessment Activities

Risk Assessment Activities, Focal Points, RethinkDB, R, Shiny
First published in EFSA Supporting Publications
24 April 2019
26 January 2018
External Scientific Report


In specific contract No 9 issued under the framework agreement OC/EFSA/AMU/2015/02, EFSA requested Open Analytics to implement a web application for tracking national risk assessment activities. The web application has three modules: one for visualization of the data, one for editing risk assessment activities and one for managing purposes. Functionalities of the edit module are set according the type of user that has logged into the web application. There are three user types: (1) EFSA Manager, able to add/edit records from all countries; (2) Focal Point, able to add/edit records from its own country; (3) EFSA Read‐Only User, not able to edit/add any records. The visualization module is accessible by all users with the same functionalities. A database is set up based on historical data, allowing real‐time updates of the data and secure editing by multiple users simultaneously. Similarly, a database for all country‐specific organisations is created.

Panel members at the time of adoption

Machteld Varewyck Tobias Verbeke
amu [at]
Question Number
The present document has been produced and adopted by the bodies identified above as author(s). This task has been carried out exclusively by the author(s) in the context of a contract between the European Food Safety Authority and the author(s), awarded following a tender procedure. The present document is published complying with the transparency principle to which the Authority is subject. It may not be considered as an output adopted by the Authority. The European Food Safety Authority reserves its rights, view and position as regards the issues addressed and the conclusions reached in the present document, without prejudice to the rights of the authors.