Project description

In 2017, for the first time in the history of Brazil, a president was charged by the Public Prosecutor’s Office for the practice of common crimes during his mandate. In addition, Michel Temer received two different accusations in the same year.
According to the first indictment, President Temer had received bribes from JBS, the world’s largest meatpacking company and one of the largest companies in Brazil. The indictment was based on the plea-bargain deal of JBS owners and audios of conversations with the president recorded by them.
The second indictment accused the president and five other members of his party for taking part in a criminal organization and for obstructing the justice.
In order for the cases to be judged by the Supreme Court, votes from two-thirds of the members of the Chamber of Deputies (342 votes) were required. On August 2, 2017, the first indictment was rejected by the parliamentarians. Less than 3 months later, the same happened to the second indictment.
In order to help the general Brazilian public understand these extremely important votings for the country, Nexo’s Data and Technology Teams published 16 charts about the division of the deputies’ votes under various criteria: party, region of the country, gender, skin color, patrimony, type of vote during the process of impeachment of former president Dilma Rousseff, federal money received in the year, electoral donations, among other criteria.

What makes this project innovative?

The vote detailing on the indictment against President Michel Temer produced by Nexo was the most complete among Brazilian outlets. The first work was published an hour and a half after the end of the vote in the Chamber of Deputies. The second, half an hour later.

What was the impact of your project? How did you measure it?

The graphics on the vote of the two indictments against President Michel Temer were shared 2,500 times on Facebook, including by two deputies who attended the voting session. The piece published on August 2, 2017, was the 15th most viewed Nexo graphic in 2017.

Source and methodology

Sources of data included the Lower House (Câmara dos Deputados or Chamber of Deputies) for the list and profile information of voters; Portal do Senado (Senate information website) for information on budget amendments; the electoral court (TSE) for campaign donations; and referenced lists of defendant politicians from Transparência Brasil and Congresso em Foco. The hard part was matching information from different databases, with different name spelling for members of Congress. Therefore, we used the social security number (CPF) as the primary key.

Technologies Used

Calculations and most of data processing was done in R, while the final dataset was in a Google Spreadsheet in order to update real time data from voting fastly. Furthermore, other journalists from the newsroom could access the database to complement their texts. Finally, to build the visualizations in D3, the table was converted to a JSON object.

Project members

Gabriel Zanlorenssi - Data Scientist, Rodolfo Almeida - Infographist, Renata Rizzi - Editor

Link

Additional links

Project owner administration

Contributor username

Followers

Click Follow to keep up with the evolution of this project:
you will receive a notification anytime the project leader updates the project page.