The project is an investigative report on the homicides of children and adolescents in the municipalities included and not included in the Plan El Salvador Seguro, a plan by the government of El Salvador (Central America) to reduce insecurity in the municipalities most affected by violence in the country. The project was able to demonstrate that in the municipalities not included in the plan, the homicide rates of children and adolescents are as much or higher than in the municipalities that the plan included. The report is aimed at the audience of eldiariodehoy.com, critical, influential citizens and decision makers.
What makes this project innovative?
In addition, a small game was included where the user is invited to choose the weapon with which he believes that children and adolescents are killed more frequently. The objective was to present in a different way a topic that could be trite in a country where between 8 and 12 people are murdered every day.
What was the impact of your project? How did you measure it?
In addition to the metrics, authorities and security experts reacted to the publication. On December 15, in a radio interview, the director of the National Civil Police, Howart Cotto, said he disagreed with the focus of the report, as he did not recognize that he has managed to reduce homicides in some areas of the country.
On December 12, salvadoran security expert Carlos Ponce published an opinion column where he stated that the report opened the door to start a debate on the methodology of El Plan El Salvador Seguro.
Source and methodology
The crossing of the databases allowed the calculation of homicide rates for children under 18 for every 10 thousand inhabitants.
Then the database of municipalities with homicide rates greater than 5 was crossed and crossed with the database of municipalities included in the Plan. In this way it was possible to determine which municipalities that had been excluded from the Plan had higher rates of homicides than those of some municipalities included.
However, the final analysis was carried out using dynamic Excel tables.
Once the municipalities with the highest homicide rates of children and adolescents were identified, it was decided to visit two of them to interview relatives and former teachers of the victims.
The design of the web site (back-front) was in charge of David Morales.
The interactive map with the data of the municipalities with the highest homicide rates included or not in the Safe El Salvador Plan was prepared by Carlos Palomo using the Google Fusion Tables tool.