Following on from my previous post Local Authority Data, I thought I’d highlight some of the other great data sources that are available at the local authority level.
You can’t escape Brexit in the UK at the moment, and apologies if you have just had enough, but if not, did you know that all the EU Referendum 2016 results are available at the local authority level? I have an updated Local Authority Explorer dashboard on my Tableau Public page that allows you to explore the referendum results by your local authority, but what I find fascinating is when you combine the referendum results with the demographic and political party data that is also available online.
The viz above combines the political composition of local councils with how residents voted in the 2016 Referendum. Depth of colour indicates strength of vote and region can be changed top right (so you can check out your own area). Hover over the lower chart to get the numbers for each party.
What I find interesting is the distribution of % leave results for each party at the national level (change region to ‘All’). Conservative controlled areas voted predominately to leave, Labour were more evenly distributed, but surprisingly more than half of the 11 Lib Dem controlled areas voted to leave. I know local party politics don’t always mirror the national position, but even so, I would have thought more Lib Dem areas would have voted remain.
The viz above covers more familiar data and was in part inspired by this Guardian EU Referendum article. Hover over individual marks to highlight individual councils and get the relevant percentages. The correlation on the top 2 views is clear and less so on the bottom 2, but both are equally interesting. The % turnout vs % leave scatterplot has a pyramid-like shape indicating that as voter turnout rose, the closer the result became, perhaps reflecting the reality that the UK is truly a divided nation on this issue.
The demographic data used above comes from the ONS population estimates for 2016. This data is presented by age and so a median age calculation can be made (although not straight forward – check out this excellent post by Jonathan Drummey of datablick on how to create a reusable weighted median calculation in Tableau). The key socioeconomic data comes form the 2011 Census on the ONS website. They also have many other data sets that are presented at local authority level.
I hope you found these Brexit themed visualisations interesting rather than irritating / depressing / inspiring – delete as appropriate 🙂 If you have any questions, feel free to contact me directly or leave a comment below.