This is an investigation material about how budget money was spent in 2020 on butts related to COVID-19. The analysis was carried out on the goods that were purchased, at what price, which organizations acted as its suppliers.
Thanks to the analysis carried out in the material, the general public was able to trace the path from the procuring entity to the supplier. Find out how effectively the money was spent, and whether the authorities made all the necessary efforts to treat patients with COVID-19.
To work on the project, I used the Excel database for the purchases, downloaded from the portal of public procurement of Kyrgyzstan. Programmers helped me with data uploading. Open contractual partnership. The analysis and part were carried out manually due to the fact that not all data were downloaded in the required format and due to duplicate information. In addition, the datawrapper program was used to visualize the data.
What was the hardest part of this project?
The hardest part of working with this tool is selecting important data and also cleaning it up. Many data were not read automatically, so they had to be processed manually, and this is several thousand items and names of goods.
What can others learn from this project?
Especially for colleagues interested in procurement data during the COVID-19 pandemic in Kyrgyzstan, the editors opened access to raw data that they can analyze and prepare their own materials based on it. Thus, this material can become the basis for the preparation of other interesting and useful research.