Basics of open data, retrieval and analysis of data in Excel and data visualization were the topics covered at the one-day training of representatives of the ZIP Institute, conducted in the premises of the Metamorphosis Foundation.

The training was held as a preparation for the implementation of the project proposal of the ZIP Institute “Rate.me – System for reporting on the services of catering facilities” which won at the Call for proposals for open data projects announced by the Metamorphosis Foundation. The purpose is to collect the positive and negative practices of catering facilities in Macedonia, where food and drinks are served. They need data on the issued permits for catering facilities, the categories to which they belong, such as nightclubs, bars, discos, etc.

They also want to include data for the penalties for catering facilities and the incidents that occurred at these places, including violations of the legal norms.

Aside from the ZIP Institute the project proposal of “ICT for changes” was also selected for implementation. ICT for changes will work on a project called “Data journalism – research system based on public procurement in the Republic of Macedonia”. They proposed to collect data from the electronic procurement system, which is publicly available, to be organized and presented in a way that will be useful for journalists in Macedonia.

The Coalition of Citizens’ Associations – “All for Fair Trials” will work on a project based on Open Data for a Transparent Judiciary. They already have their own database from the 12-year monitoring of the judiciary in Macedonia that they want to open and make it publicly available through the creation of a new website.

The Rural Development Network (RDN) will collect data from the National program – direct payments in agriculture and the IPA-IPARD projects in Macedonia, which will then be sorted, analyzed and published on their website.

The competition is part of the project “Open Data Civil Society Network” implemented in cooperation with the Open Knowledge Foundation, and aimed at building the capacity of civil society organizations to promote an open agenda, through the establishment of the School of Data – Macedonia.