Uma aplicação web para visualização de dados governamentais de notas fiscais eletrônicas: transparência de dados governamentais

Abstract

The Access to Information Law establishes that the State must ensure transparency by publishing Government Open Data. However, in the context of Electronic Invoices (NF-e), this information is provided in a raw format (CSV), which makes it difficult for ordinary citizens to interpret. This study proposes a way to mitigate this issue by developing a complete web application for structuring and visualizing government NF-e datasets. The adopted methodology involved an Extract, Transform, and Load (ETL) process using a Python script to load and normalize the database, which was then stored in a PostgreSQL relational database. For the development of the web platform, Spring Boot was used in the backend and Angular in the frontend. As a result, an interactive portal was created, enabling detailed queries, dynamic filtering, and graphical visualization of public expenditures, thus facilitating oversight and access to information for citizens.