Selection of the projects that I have worked on over the past couple of years. In most of them I have worked with civio, an spanish non-profit that promotes transparency, accountability and free access to public data to fight for a stronger democracy and empower citizens to have a more proactive role in modern society.
España en Llamas (Spanish)
First Data Journalism project that I have worked on (Hooray!!!). It started with a FOIA request to the spanish government to release the data for every individual forest fires that had occur in Spain from 2001 onwards.
After many data wrangling tasks, we achieved a clean database with all the geolocated forest fires with all the available metadata for each one of them. We then created a site that covers some interesting stories we found in the data as well as an interactive map that allows readers to focus on the fires that are more keen to them.
- Backend: GIS related tools to transform coordinates, DB transformations
- Frontend: Google Maps API & D3.js for the interactive map
El Indultómetro (Spanish)
Project also developed in collaboration with civio that compiles, analyzes and classifies all the information in the spanish official gazette about pardons since 1996.
Let's readers search by the type of offense, compare annual data and determine how each party in the government has used this controversial measure.
- Backend: Ruby mechanize and nokogiri for data collection, Sinatra for the site
- Frontend: HTML5, CSS3, d3.js, Timeline.js for the visualizations
Donde van mis impuestos (Spanish)
Side project integrated inside a bigger site developed by civio that breaks down spanish budget expenditures. The module compares the regional budget expenditures in Spain from 2006 onwards.
- Backend: Ruby gems mechanize & nokogiri to build the scraper
- Frontend: HTML5, CSS3, D3.js for the visualization
Congreso ¿quién es quien? (Spanish)
We gather data for every spanish member of the parliament since modern democracy (1977) together with some metadata related to their activities inside the congress over time.
- Backend: Python requests and beautifulsoup for the data collection, Rails for the site
- Frontend: HTML5, CSS3, dc.js for the home page visualization
Info Amazonia Cattle Ranching
It's main goal is to visually show the correlation between cattle ranching growth and its deforestation impact on the Brazilian Amazon.
- Backend: Tilemill, GDAL
- Frontend: Mapbox