Organisation: El Universal (Mexico)

Publication Date: 04/10/2016


Trusts, the black boxes of governments, was carried out with two basic premises: Sort and systematize all existing trust in the federal government and that anyone understood how important it is to follow up on these financial instruments, because they come from public resources. During these months we have seen irregularities and opacities in these black boxes do not concern mostly the federal government, but local governments and even autonomous bodies who are allowed to create trust and entering into these contracts for various reasons. The result? We took on the task of taking a first step with this investigation in terms of the 614 trusts that existed from 2006 to 2014 in the federal government and those who were admitted more than 2 billion pesos. Subsequent task will investigate trusts entities. One of the first big challenges was, in principle, systematize all public trusts reported by the Ministry of Hacienda and the Congress. Of these trusts, we find information available from 2006, although since 2004 the then Federal Institute for Access to Information (IFAI) ordered its organization and systematization of the Ministry of Hacienda. The answer to no information available online, by Hacienda was simple: Because programs and softwares different for the creation and systematization of these files are used (this already means in itself, a big challenge for open government seeking boost). The first step was to order and systematize the information that we had. Then convert data from PDF to Excel and then convert the information to programs such as SQL or JSON for graphics. Another reason difficult to explain was the fact that several data are in "income" but with a negative sign. This information, Hacienda tried to explain the "availability" had not yet contemplated. After obtaining the data bases ready to work them, one of the main obstacles was how to graph this information. Finally managed to show through the browser 614 different graphics that allow acquaint the reader with the most important parts of the trust: Income (how much money you put into that bank account Hacienda), availability (as in a bank account, how much money It has today) and egress (which was removed from the bank account), allowing you to see, over the years (from 2006-2014) how much money was "moved" over time and behavior that had these trusts. Another relevant graph is which includes all trusts to show them by subject, as well as the priorities of the federal government as to how to spend the money they have in the trusts are denoted. The last graph is the one that concentrates topics and branches, to show all dependencies and how much money they accumulated who concentrated the largest number of trusts.


Follow this project

Commentaires (0)

You have to be connected to contribute

You have to be connected to follow

Leave this project and no longer be informed about this project

By joining this project, you will be informed by email when an update or a new contribution is posted on the website.

Thank you for your active participation !

The GEN Community Team