For the last three months, I have been following projects shared on NICAR-ESP-L, a mailing list where journalists debate about data journalism (tip: subscribe to it if you are a Spanish speaker interested in this field!).
There have been some fascinating reports based on broad issues such as following the money, women presence and corruption.
Below are 3 good pieces that caught my eye. These data journalism teams have been tackling general issues from different points of view, gathering data from several sources and making the information more accessible to the audience:
The Universal Data tackles black boxes of governments and public trusts in Venezuela.
The team aimed to systematise the federal government trust fund so that everyone could understand the importance of following these financial instruments coming from public resources.
The final product were 624 trusts assets from 2006 to 2014, where the federal government entered more than 2 billion pesos (around £7,8625.61).
Data journalists explained the methodology used to find the information, scrap the data and create visualisations here. Some difficulties were to deal with public services to make the data clearer or convert PDF’s to Excel files.
They used D3 to visualise the data.
This project depicts the number of women in Spain and their power when it comes to making decisions on politics, media, economy, justice and academy.
Created within the III Data journalism workshop held by MediaLab Prado, the team consisted of Olaya Argüeso Pérez, Nerea Novo Paleo, Laura González Carrasco, Teresa Pérez Gallo, Eva Filgueira Guimerá, Cristina Nualart and Diego Andrés Ramírez Aragón.
To information came from several sources: Ministerio de Educación, university websites, Agenda de la Comunicación, Instituto de la Mujer, CNMV, Unión Interparlamentaria, etc.
They mainly used Tableau to visualise the data.
The result of the Catalan elections last September spotted one district in Barcelona where the Popular Party (PP) won 32,6% of the votes. In the city, the total amount of votes won by the PP was less than 10%.
Eldiario.es gathered information about the last elections on this neighbourhood to find a pattern. On the last municipal elections, 35% of people living in this area also voted the PP.
Visualisations were both created on CartoDB and from the scratch.