Project description

After the last italian General Election this project analyze the results of the vote, looking at significant patterns. The Project visualizes 4 italies, 4 colors after the general elections. What came out was not a simple division north and south, as a lot of axperts and commentators said. One of the most interesting patterns about this general election came out from Milan and Turin vote, the main cities of the north. In the second article the project focused on the case of Lombardy, to understand if the farther away a town is from the main cities the more League’s avg percentages grow.

What makes this project innovative?

Going against the main commentaries, that talked of a simplistic division north and south, this project went trough the vote, visualizing in an affective way the results of the main 4 parties. It communicate some insights in an effevtive manner, making important insights jump out. The example is the situation of Milan and Turin, where the Democratic Party won the city, Five star Movemente the cities/town close to the main cities and the League the suburbs. This first intuition was the point of start of the second article, in which the distance of every italian town from the main cities was calculated to understand if the percetages of the League was related to the distance from the main cities. The visualizations permitt also to make an informative drill down.

What was the impact of your project? How did you measure it?

The project showed that the situation in Italy was really complicated, and even if the Democratic party lost in terms of percentages it won several main cities of the north. The project was shared by a lot of people to understand better the results and the vote. Even the European Data Journalism Network shared the project on theri website.The project was a perfect example of collaboration and gave evidence of how open data can help journalist and people to understand what's happening in their country. The data was collected by OnData, while after several weeks people are still waiting for the official files from Viminale.

Source and methodology

The data was collected by OnData, an italian association for the promotion of transparency and open data. After a work of collaboration beetween OnData and some freelancer the data was ready to be used. In this project the electoral results was joined using Tableau and Alteryx with geographical data from Istat. In the second article these data was also crossed with data about population and the distance beetween all the town/cities of Lombardy from the main cities (calculated expressly for the project). The data was collected by OnData, while after several weeks people are still waiting for the official files from Viminale.

Technologies Used

Two main tools was used to discover and visualize these data: Alteryx for data cleansing and data preparation, Tableau for visualization. Other than these tools was also used Adobe illustrator and Photoshop to create icons, images and the animation for the second article.

Project members

OnData scraped the electoral data, with Andrea Borruso as main referent. Riccardo Saporiti made the first cleansing of the electoral data. All the rest (data preparation, data cleansing, cross db join and visualization) was made by Filippo Mastroianni


Additional links

Project owner administration

Contributor username


Click Follow to keep up with the evolution of this project:
you will receive a notification anytime the project leader updates the project page.