Search Engine: Centralizes, integrates, and facilitates the search for data on public contracts and contractors. Monitors procurement processes and alerts about potential corruption risks.
Evaluator: Studies public procurement processes, including the legal framework, ongoing policies, their implementation, and results. Additionally, it offers recommendations based on the findings of its evaluations.
To achieve the integration of public data, Sembrando Sentido has created an information system that uploads data from the Puerto Rico Comptroller's Office Contract Query page, and through a series of scrapers, identifies and extracts information presented about these contractors from the Corporations Registry of the Department of State and the Political Donors Registry of the Electoral Comptroller.
The scrapers use the open-source library puppeteer to navigate and extract data. If a single 'match' is found, the general data is extracted, uploaded, and integrated into our database. When more than one 'match' or no 'match' is found, the system uses the Open Refine Reconciliation API from Open Corporates and its algorithms to try to identify the corporation.
In cases where the system does not identify the corporation, the team and volunteers at Sembrando Sentido have gone the extra mile by manually investigating and identifying the match between corporate and individual records. Additionally, our system, using developed parameters, categorizes the entity by types (such as government agencies, corporations, individuals, etc.) to facilitate analysis. In the case of matching Political Donors, the system seeks to match the names of contractors or their officers with the names registered in the corresponding Registry, and if an exact name (excluding the middle name) is found in the Registry, the system extracts the information and marks the contract as 'Donor' in the database.
Through this system, a database is created that integrates and centralizes the data, thereby facilitating its presentation and analysis.
The beta version of Contratos En Ley is just the beginning of promoting clear, complete, accessible, and integrated public information. Currently, we are working to develop rigorous evaluations of public contracts, create a contract monitor, and expand the search engine to extract decentralized public data from over 56 government portals.
We are striving to share more information, make it completely public, and standardize it according to the Open Contracting Data Standard. We are also working on an API for those who request direct access to our database.
At no time does the scraper access confidential information, manipulate the exposed data, or seek to cause any harm to the mentioned Public Records or the data exposed in them. The data extracted originates from, and remains as, it is presented in the mentioned Public Records without any changes. We are not the official or original source of this data, and it may contain undetected errors or omissions, as well as mistakes in data matching.
For this reason, we cannot guarantee the quality of the presented data, but we do provide a mechanism to report errors, and we make ourselves available to verify and present corrections as possible. Even so, since we cannot guarantee the quality of the presented data, the user chooses to consume the data at their own risk.
We are not, and will not be, responsible for any damages or losses of any kind resulting from the use of the presented public data. Additionally, although we have a robust security system, we cannot guarantee that our system's servers will not be affected by viruses or improper interventions that may affect the data or the continuity of the Search Engine at any time.
Our goal is to make information about public contractors and public contracting processes more complete, integrated, and widely available. However, we must ensure that we continue providing the service for the benefit of everyone, which requires us to establish certain restrictions on the use of the site.
The absence of a robots.txt file does not mean we allow arbitrary scraping, as it can place an excessive load on our servers. If our system detects suspicious activities, such as hacking attempts or damage caused by a user, the use of our Search Engine may be prohibited under certain circumstances. If you wish to obtain direct access to all the data in our database, please contact us: imasses@sembrandosentido.org.
We obtain the information in our databases from the government and other sources through various means, including directly from government websites and APIs, as well as integrating publicly available data or through information requests. We dedicate significant time, effort, and even money to obtain these data and turn them into a viable and highly usable resource. We do not claim any rights over the data we receive from government sources, and we attribute them whenever possible. However, we do claim rights over the evaluations we conduct and expect respect for the same.
We appreciate citing the information about our platform or evaluations when any work directly relies on the work of Contratos En Ley. The work of Sembrando Sentido, through its project Contratos En Ley, is protected by Puerto Rico intellectual property laws and a Creative Commons license. For any questions or requests, write to us: imasses@sembrandosentido.org.