Projects submitted to the Data Journalism Awards competition

Right here you will find a list of all the projects submitted to the Data Journalism Awards competition.  

Monitor da Violência (Violence Monitor)
Country: Brazil
Organisation: G1
Investigation of the year
InteractiveInvestigationMapsCrime
Applicant
Thiago
Reis Corte
Team Members
Coordinator (besides me):Athos SampaioEditors:Amanda Polato, Ana Carolina Moreno, Carolina Dantas, Carlo Cauti, Clara Velasco, Cida Alves, Darlan Alvarenga, Débora Melo, Elida Oliveira, Felipe Grandin, Flávio Ismerim, Gabriela Bazzo, Gabriela Caesar, Helton Simões Gomes, Juliana Cardilli, Karina Trevizan, Letícia Macedo, Luciana Oliveira, Luiza Tenente, Marília Neves, Marta Cavallini, Megui Donadoni, Monique Oliveira, Pâmela Kometani, Peter Fussy, Ricardo Gallo, Roney Domingos, Rosanne D\'Agostino, Taís Laporta, Thaís Lima, Vanessa Fajardo and Vitor Sorano (Content), Rodrigo Cunha (Infographics)Designers:Alexandre Mauro and Roberta JaworskiDevelopers:Rogério BanquieriProducers and reporters:Janine Brasil, Quésia Melo and Aline Nascimento (G1 AC)Cau Rodrigues, Michelle Farias, Carolina Sanches, Roberta Cólen, Derek Gustavo, Waldson Costa, Natália Normande, Magda Ataíde, George Arroxelas and Suely Melo (G1 AL)Adneison Severiano, Indiara Bessa, Ive Rylo, Patrick Marques, Andrezza Lifsitch, Camila Henriques and Leandro Tapajós (G1 AM)Jorge Abreu, Jéssica Alves, Lorena Kubota and John Pacheco (G1 AP)Henrique Mendes, Natally Acioli, Alan Tiago, Danutta Rodrigues and Lílian Marques (G1 BA)André Teixeira, Cinthia Freitas, Denise Brandão, Gioras Xerez, Valdir Almeida, Verônica Prado, Marília Cordeiro and Ranniery Melo (G1 CE)Marília Marques, Eduardo Miranda and Maria Helena Martinho (G1 DF)Manoela Albuquerque and Viviane Machado (G1 ES)Elisângela Nascimento, Fernanda Borges, Murillo Velasco, Paula Resende, Sílvio Túlio, Vanessa Martins and Vitor Santana (G1 GO)João Ricardo and Márcia Carlile (G1 MA)Alex Araújo, Cíntia Paes, Flávia Cristini, Humberto Trajano, Michele Marie, Pedro Ângelo, Raquel Freitas and Thais Pimentel (G1 MG)Rafael Antunes, Daniela Ayres, Vanessa Pires, Bruno Sousa, Caroline Aleixo, Bárbara Almeida, Karla Pereira, Roberta Oliveira, Marielle Moura, Fellype Alberto, Mariana Dias and Victória Jenz (G1 Triângulo Mineiro, Centro-Oeste de MG e Zona da Mata)Adriana Lisboa, Marina Pereira, Ricardo Guimarães, Zana Ferreira, Patrícia Belo, Cristiane Rodrigues, Juliana Peixoto and Valdivan Veloso (G1 Grande Minas e Vales de Minas)Lucas Soares, Régis Melo, Fernanda Rodrigues and Lara Silva (G1 Sul de MG)Fernando da Mata, Juliene Katayama, Marcos Ribeiro, Nathália Rabelo and Nadyenka Castro (G1 MS)Pollyana Araújo, Denise Soares, André Souza and Lislaine dos Anjos (G1 MT)Andrea França, Taymã Rodrigo and Raiana Coelho (G1 PA e TV Liberal)Taiguara Rangel, Aline Oliveira, André Resende, Diogo Almeida, João Brandão Neto, Krystine Carneiro, Gabriel Costa and Iago Bruno (G1 PB)Marina Meireles, Ricardo Novelino, Bruno Marinho, Luiza Mendonça and Katherine Coutinho (G1 PE)Joalline Nascimento, Lafaete Vaz, Lindayanne Florêncio, Lyllyan Belo, Mário Flávio, Mavian Barbosa and Rodrigo Miranda (G1 Caruaru)Amanda Lima, Beatriz Braga, Emerson Rocha and Juliane Peixinho (G1 Petrolina)Catarina Costa, Maria Romero, Gilcilene Araújo, Júnior Feitosa, Carlos Rocha and Ellyo Teixeira (G1 PI)Adriana Justi, Alana Fonseca, Bibiana Dionísio, Thais Kaniak, Aline Pavaneli, Fabiula Wurneister, Letícia Paris, Erick Gimenes, Ederson Hising and Samuel Nunes (G1 PR)Felipe Grandin, Henrique Coelho, José Raphael Berrêdo, Leslie Leitão, Nicolás Satriano and Patrícia Teixeira (G1 Rio e TV Globo)Ariane Marques, Lívia Miranda, Fernanda Soares, Franklin Vogas, Vanessa Ornelas, Juan Andrade, Amaro Mota, Filipe Carboni and Julian Viana (G1 Norte Fluminense, Lagos e Região Serrana)Michele Martins, Rianne Netto, Isabel Sodré, Renan Tolentino, Vinicius Lima, Lara Gilly and Luís Filipe Pereira (G1 Sul do Rio e Costa Verde)Fernanda Zauli, Anderson Barbosa, Igor Jácome, Rafael Barbosa and Ricardo Oliveira (G1 RN)Jonatas Boni, Magda Oliveira, Rogério Aderbal, Eliete Marques, Jeferson Carlos, Diêgo Holanda, Hosana Morais and Jheniffer Núbia (G1 RO)Emily Costa, Jackson Félix and Inaê Brandão (G1 RR)Hygino Vasconcellos, Gabriela Haas, Otávio Daros, Jessica Perdonsini, Daniel Favero, Tatiana Lopes, Rafaella Fraga, Shállon Teobaldo, Janaina Lopes, Felipe Truda, Luã Hernandez and Alexandra Freitas (G1 RS)Carolina Holland, Fernanda Burigo, Joana Caldas, Mariana de Ávila, Mariana Faraco and Valéria Martins (G1 SC)Joelma Gonçalves (G1 SE)Glauco Araújo, Luiz Ottoni, Kleber Tomaz, Will Soares, Cíntia Acayaba, Paulo Toledo Piza and Paulo Guilherme (G1 SP)Mariana Bonora and Tiago Moraes (G1 Bauru)Patrícia Teixeira, Marcello Carvalho, Fernando Evans, Fernando Pacífico, Murillo Gomes, Ana Letícia Lima, Bruno Oliveira and Letícia Baptista (G1 Campinas)Paola Patriarca and Francine Galdino (G1 Itapetininga)Fernanda Lourenço, Jamile Santana, Cristina Requena, Maiara Barbosa and Gladys Peixoto (G1 Mogi das Cruzes e Suzano)Samantha Silva, Arthur Menicucci and Carol Giantomaso (G1 Piracicaba)Adriano Oliveira, Rodolfo Tiengo and Thaisa Figueiredo (G1 Ribeirão Preto)Renata Fernandes, Marcos Lavezo, Bruna Alves and Heloísa Casonato (G1 Rio Preto)Fernando Bertolini, Stefhanie Piovezan, Fabio Rodrigues, Raquel Baes, Ana Marin and Kalinka Bacacicci (G1 São Carlos)Mayara Corrêa, Ana Carolina Levorato, Fernanda Szabadi, Carlos Dias, Álisson Batista, Aline Albuquerque, Eduardo Ribeiro Jr. and Gabriel Morelli (G1 Sorocaba)Gelson Netto, Stephanie Fonseca and Wellington Roberto (G1 Presidente Prudente)João Paulo de Castro, Ivair Vieira Jr, José Cláudio Pimentel, Mariane Rossi and Alexandre Lopes (G1 Santos)Guilherme Machado, Leonardo Medeiros, Carlos Santos and Simone Gonçalves (G1 Vale do Paraíba)Patrício Reis, Jesana de Jesus, Edson Reis, João Guilherme Lobasz, Letícia Queiroz, Gilvana Giombelli, Matheus Mourão and Vilma Nascimento (G1 TO)
Project Description
This project is an unprecedented partnership among G1 (TV Globo\'s news portal), the Center for the Study of Violence at University of São Paulo (the largest university in Brazil) and the Brazilian Forum of Public Security (one of the most respected public security NGOs in Brazil). It focus on discussing violence in the country. It is a project that touches everyone and, therefore, it is aimed at the entire population. To make it possible, G1 staff reporters all over Brazil kept track of violent deaths through the course of one week. Most of these are crimes that generally become forgotten – cases of homicides, robberies, feminicides, deaths by police intervention, and suicides.There were 1,195 deaths in this period — one every 8 minutes on average. All these stories have been cleared and written by more than 230 journalists spread throughout Brazil and comprise all the reported cases of deaths from August 21st to 27nd. The result shows a violent country in which a man\'s life may cost R$ 20; where couples\' arguments end in tragedies; and where executions became a banality. This is a small sample — compared to the 60,000 annual homicide rate — but it represents a picture of the violence in Brazil. The project aims at showing the faces of the victims; trying to understand the causes of this epidemic of deaths, and at following, in this microcosm, the developments in each case. As a first step, a news piece was written for each one of the violent deaths. An interactive map, complete with search filters, showed the locations of the crimes as well as the victim\'s photos. In addition, experts were invited to examine the data, which resulted in two published texts analyzing the problem, along with a Q&A. The second step was a collective and collaborative effort to find the names of unidentified people. A campaign was launched, including on line news, TV and social media, so that people could help identify many of the victims. A Facebook group (https://www.facebook.com/groups/monitordaviolencia/) was created as a third step. G1 had never used this tool before, but we felt it was needed to discuss the project and other subjects related to violence, human rights and justice. The forth and most recent step was to show, two and a half months after the deaths, the progress of each of the inquiries. A new collective effort involving the more than 230 journalists resulted in an exclusive and revealing work. New filters were applied to the map (as were the status of each investigation), and new conjectural analysis were published by our partners. It is a living project: texts are updated as new information is discovered. And audacious: the idea is to shed light on the serious security problem and help reduce the number of violent deaths in the country.
What makes this project innovative?
The Violence Monitor marks the first time that a collective effort organized by a media outlet managed to record in detail and in an organized way all violent deaths occurred in a specific and substantial period of time (one week). This is especially due to the high number of cases (1.195). More than data, the project shows stories. A task force was set up in the SP office to manage and coordinate 55 different teams in all the states of Brazil. There were more than 230 journalists involved. A database was assembled from scratch, containing information such as the victims\' name, age, race, and gender. Also, the day, time, weapon used, and the exact location of the crime, among others. The project demanded careful work on people management and data debugging. However, more important than the computer techniques applied was the work by this team to handle and manage information. The map, unprecedented and exclusive, became a reference.
What was the impact of your project? How did you measure it?
The work had repercussions in various fields. In the media it was replicated by TVs, newspapers and news websites; it reached politics, as it was mentioned in a session in the Senate and in sessions held by State Legislative Assemblies; the impact on academia came in the form of studies and papers. The published material has reached a total audience of almost 1 million views and it has become a reference for discussions about violence in Brazil. When it was first launched and on its first major update (when the investigations of each case were revealed, two and a half months later) it was the opening subject of Jornal Nacional, on TV Globo, the leading broadcast news program in the country.The project was also presented at Coda.BR (the Brazilian Conference on Data Journalism) as one of the innovative works in the area last year.
Source and methodology
The data were collected by more than 230 reporters from Brazil, who obtained the information on the spot, through police, coroner\'s offices, morgues, victims\' families, prosecutors and other sources. The information was then passed on to a team in São Paulo formed by editors from all areas (education, science, economics, cars, data ...) prepared to put them on a spreadsheet and organize them properly. All standardization was made so that a map could be put together, with specific filters to each category. The data were then analyzed and validated by teams specialized in public security issues (formed by researchers from USP and members of the Brazilian Forum of Public Security). After the verification, the data was used to create the map.
Technologies Used
The map is based on html, CSS and javascript. All the content was placed, during the project, on a Google spreadsheet and transferred, then, to Carto – the data was collected through an API.