Julius: Data Capture Tool for Transparency Portals

  • Pedro P. Berger Ministry of Public Affairs of the State of Espírito Santo (MPES)
  • Matheus W. Souza Ministry of Public Affairs of the State of Espírito Santo (MPES)
  • Heitor Quartezani Ministry of Public Affairs of the State of Espírito Santo (MPES)
  • Guilherme Merisio Ministry of Public Affairs of the State of Espírito Santo (MPES)
  • Iara A. Fazolo Ministry of Public Affairs of the State of Espírito Santo (MPES)
  • Luciana G. F. De Andrade Ministry of Public Affairs of the State of Espírito Santo (MPES)
  • Sandro T. Silva Ministry of Public Affairs of the State of Espírito Santo (MPES)
DOI: https://doi.org/10.5753/sbbd_estendido.2024.244011

Abstract


The tool captures and consolidates data from transparency portal APIs of the 78 municipalities in the state of Espírito Santo, assisting in investigations of public procurement and contracts. The project faced technical challenges, such as the diversity of APIs and the need for data standardization. The application is available as open-source and provides a public database containing all the content from the transparency portals in a structured format.

Keywords: Data Capture Tool, Transparency Portals

References

Brasil (2011). Lei nº 12.527, de 18 de novembro de 2011. Regula o acesso a informações previsto na Constituição Federal e dá outras providências. Disponível em: [link]. Acesso em: 22 jul. 2024.

Docker Inc. (2024). Docker Documentation. Retrieved from [link]

Merkel, D. (2014). Docker: Lightweight Linux Containers for Consistent Development and Deployment. Linux Journal, 2014(239), 2.

Ministério Público do Estado do Espírito Santo (2024). Julius: ferramenta de captura de dados. Disponível em: [link]. Acesso em: 22 jul. 2024.

PLATT NETO, O. A. (2023) Abordagem sistemática para avaliação de portais de transparência (ASAPoT). Governet – Boletim de Orçamento e Finanças, Curitiba, v. 19, n. 217, p. 412-417.

Python Software Foundation. (2024). Python Documentation. Retrieved from [link]

R Core Team. (2024). R: A Language and Environment for Statistical Computing. R Foundation for Statistical Computing. Retrieved from [link].

SQLite. (2024). SQLite Home Page. Retrieved from [link]
Published
2024-10-14
How to Cite

Select a Format
BERGER, Pedro P.; SOUZA, Matheus W.; QUARTEZANI, Heitor; MERISIO, Guilherme; FAZOLO, Iara A.; ANDRADE, Luciana G. F. De; SILVA, Sandro T.. Julius: Data Capture Tool for Transparency Portals. In: WORKSHOP ON DATA SCIENCE AGAINST CORRUPTION IN THE PUBLIC SECTOR (DS-COPS) - BRAZILIAN SYMPOSIUM ON DATABASES (SBBD), 39. , 2024, Florianópolis/SC. Anais [...]. Porto Alegre: Sociedade Brasileira de Computação, 2024 . p. 260-265. DOI: https://doi.org/10.5753/sbbd_estendido.2024.244011.