España en Cifras

España en Cifras

Organisation: El Español (Spain)

Publication Date: 04/08/2016

Size of team/newsroom:large


“España en cifras” is a data journalism project to help understand what is happening in Spain through its principal indicators. This project was published weeks before the municipal elections of 2015. We have gathered in this tool the main demographic, social and economic indicators that explain the reality around the citizens: Are you better off than four years ago?

What makes this project innovative? What was its impact?

Election data presented intended to provide a historical context since the first electoral elections were held in 1979. This data collection consists of more than 75 sources at the municipal (8.120), provincial (52) and regional (17). It is the first time these data is collected to make it understandable to the audience in Spain. Data have been cleaned and structured to make them more understandable across different displays through comparison and analysis tools. Articles and reports based on data and open sources also have a prominent place in “España en cifras” From the tab "stories" you can access content related.

Technologies used for this project:

For data extraction has been used scraping tool Kimono and Python. The technologies used for analysis and data cleansing have been Open Refine, Excel and MYSQL. They have also been used to extract different tools tables trapped in PDF documents as Tabula. Data has been collected councilors obtained in each legislature by the parties. These figures provide the evolution of each Spanish municipality. These data were obtained through a request for information sent to the Ministry of Interior to be collected and published only the number of votes obtained by each party. In addition, the tool also shows the name of the mayors who govern today. But because of the large number of elections held since 1979 and the amount of information, we have followed a process automation for data extraction. Subsequent cleaning and structuring process has also use tools scraping, cleaning and data analysis. The names of the regional presidents and historical governance thereof has been obtained through a process of scraping since these data were published in PDF format and it was difficult to obtain.
Follow this project

Comments (0)

You have to be connected to contribute

You have to be connected to follow

Leave this project and no longer be informed about this project

By joining this project, you will be informed by email when an update or a new contribution is posted on the website.

Thank you for your active participation !

The GEN Community Team