Data Unlocked

Bringing data to life

West Midlands European Elections 2014

By 1 Comment

Last week we collected and visualised the data for the local elections. To be complete, we have now scraped the European election results and made a Tableau visualisation of them.

The electoral process is different for the European Elections, as it is a form of Proportional Representation. Also, the results are more widely scattered on the map, this makes it more difficult to visualise and I think this makes it less clear than the Local Elections.

One thing I’ve added is a table showing the percentage of the vote per party for each of the electoral areas on the map. Because the numbers of people voting varies so much across areas this table is probably the best for seeing where particular parties are strongest. See if you can guess where UKIP got the highest proportion of votes in the West Midlands…..

If I get time, it would be nice to code the maps with LeafletJS as it has better panning. If you click and hold on the map below for a couple of seconds you will, eventually, be able to move the map around.

As for the local elections, the raw data is stored in the Open Data West Midlands Store.

Birmingham Local Elections 2014

By Leave a Comment

I was fortunate to be able to see the count for Birmingham Local Elections this year (thank you @bccnewsroom).

Birmingham Council were very quick to publish the results on their web page, but unfortunately they did this using tables. That doesn’t make it terribly easy for anybody to come along, grab the data and reuse it in any way.

So, I wrote a quick scraper and collected the data into a CSV file which I placed in the West Midlands Open Datastore. By doing this it means that anybody can take that file, import it into another programme, such as spreadsheet software, and do some analysis on it.

I decided to use Tableau to create a quick visualisation, which you can see below. Each pie chart shows the breakdown of votes cast in the ward with the size of the pie chart determined by the total number of votes cast in the ward.


 

The data visualisation guru, @CarolineBeavon has kindly added a much more user friendly view:

If you select a party from the drop down box at the top, the map on the left will update to show you where they received their votes. The map on the right shows which party won in each ward across the city.

Further down (you may need to scroll) on the left is a breakdown of the votes cast in each ward and on the right the total number of votes cast for each party across the city.

Creating a visualisation that helps people explore election results isn’t easy. We hope what we’ve done is useful and welcome suggestions of other ways that it might be done.