This week we were excited to take part in (and win!) an Open Data Hackathon organized by the Metamorfosis Foundation, a prominent NGO in North Macedonia whose mission and vision are to “… strengthen the awareness and capacity of citizens and civil society …”. The whole experience was very interesting, from the consultations with the organizers and advisers, to the presentations and the projects of the other participants. We were overall very proud to further contribute to the discussions about open data in North Macedonia. This is a topic that we have been practicing and advocating for a long time, and we are glad that such initiatives are (finally) getting proper funding for development and implementation.

The hackathon competition was open for projects that will deliver a web application to visualize already available open data, or help with opening of datasets, making them closer to the public and easier to use. Discindo’s plan was to focus on some aspect of the financial functioning of local governments, because transparent financial practices, those that allow constituents to access, investigate, and understand how their tax money is being spent, are critical for building and maintaining citizens’ trust. Tools that facilitate such transparent local government budgets also seemed very fitting with the goals of the Metamorphosis Open Data initiatives. We therefore proposed to develop a web application that will enable municipalities to summarize, visualize, and deposit their yearly budgets of income or expenses into an open database accessible to everyone. Our solution addressed both relevant sides: Local governments benefit by having access to a tool for easy and intuitive communication of their finances to the public. Constituents benefit by being able to query, monitor, and compare local government budgets across years and municipalities.

Our demo application can be accessed here: https://discindo.shinyapps.io/OpenBudgetNMK/. Even at this early stage, the app has important functionality: to upload, join with metadata, aggregate, and visualize a yearly budget. Without such a tool, even with the best intentions, it is hard to communicate the details of the budget to the public, as the software used to generate the files outputs the data with numeric codes that have no meaning to the non-expert. We will complete development of the application this summer in anticipation of some substantive usage soon, as Metamorphosis starts collaborating closely with 50 municipalities in their efforts to implement open and transparent data practices.

As with most projects at Discindo, the OpenBudgetMKD application is based on R and {shiny}, uses {bs4Dash} for its excellent UI components, is packaged with{golem}, and will be available in Macedonian, Albanian, and English. From a programming perspective, the most interesting aspect for us was implementing internationalization using the {shiny.i18n} package and integrating this into a {golem}ized {shiny} application.