Help us to Keep The Lights On for another decade! Back the Cable
The Bristol Cable

Methodology: Calculating Ward-Level Turnout – WoE Mayoral Election 2017

Data sources

Words: Lucas Batt

The turnout data is taken from the Bristol verification totals for the West of England Mayoral Election 2017 (bottom of the page). The data appears in four separate pdfs, and was collated to verify the number of ballot papers issued and collected per polling station. The results data for each candidate was not released at the same level of detail.

Each verification statement is a page containing the turnout results for polling districts in a particular ward. These ward-level counts also include a number of centralised postal votes. In the tables, an eligible electorate is given, and as well as a corresponding turnout percentage, which is worked out, per polling station, by dividing the “number of papers found in box” with the eligible electorate.

A ward-level turnout can be calculated by adding the turnout for each polling station in a given ward and dividing that by the ward’s total eligible electorate. However this gives a misleading turnout percentage, as it excludes the eligible electorate who chose to submit a postal vote instead of going to vote on the day of the election.

Nonetheless, a good go of working out the actual ward-level turnout can be made. The West of England Combined Authority website released turnout by region, with Bristol’s results being broken down into its four parliamentary constituencies: Bristol East, Bristol South, Bristol West, and Bristol North-West. These regional results of verified votes turn out to match perfectly with the results from the polling station data, when including the polling districts. Additionally, the eligible electorate matches perfectly, which is significant as there is no eligible electorate stated for the postal votes, which shows the polling station counts to not show the full turnout picture.

So, the postal vote for each region (such as Bristol East) can fairly confidently be divided proportionately by each ward in that region in order to work out a more accurate turnout per ward. For example, Bristol East has 7,199 postal votes out of 21,092 total votes. The eligible electorate figure for each ward is divided by the total eligible electorate for Bristol East, which gives a figure showing the percent of the constituency eligible electorate per ward. The Bristol East postal vote figure is then multi

plied by each one of those figures, giving an estimated proportion of the postal votes per ward. That figure is added to the original ‘number of papers found in box’ figure to give the estimated total votes in that ward. And that can be divided by the ward eligible electorate figure for the estimated turnout percentage.

It’s not perfect, as certain wards may have more or fewer than the average number of postal voters in that constituency, however it’s the best that can be done with the available data, and a pretty decent estimated turnout at the ward level.

Join 2,500 Cable members redefining local media

Your support will help the Cable grow, deepening our connections in the city and investigating the issues that matter most in our communities.

Join now

What makes us different?

Comments

Report a comment. Comments are moderated according to our Comment Policy.

Post a comment

Mark if this comment is from the author of the article

By posting a comment you agree to our Comment Policy.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related content

LIVE: Bristol general election results, as Greens win Bristol Central and Labour gains seats off Tories

Bristol general election results 2024: Labour will be looking to take seats off the Tories on the edge of Bristol in the general election, while the Greens have their eyes on Bristol Central.

Watch: Why you should back the Cable – in 60 seconds

A breakdown of all the things we've managed to achieve for Bristol in almost a decade of reporting.

We’re working to diversify the Cable team. Let’s start with our freelancer base

The Cable exists to challenge the structure of the media, but we are not representative enough of our city. Here’s what we’re doing to change things.

Listen: Cable Longreads – ‘Hollow victory’: a rape survivor’s journey through broken justice system

Cable reporter Priyanka Raval investigated whether the police's new approach to prosecuting sexual violence is really making a difference to survivors.

‘Collective power is where it’s at’: City Academy workers celebrate strike action successes

Union members at the east Bristol secondary school have achieved most of a series of asks from the academy trust that manages it, after announcing rolling walkouts. Workers say the action has brought staff together.

Cable Live x Bristol Transformed – can Apartheid-Free Zones help liberate Palestine?

The panel asks what was the St Paul’s Apartheid-Free Zone – and how can it be a model in today’s fight for Palestinian freedom?

Watchdog finds ‘serious failings’ after concluding council does not know what state its housing is in

Bristol City Council has been called out by a government regulator for not meeting new quality standards, with thousands of repairs and damp and mould cases long overdue for action and many safety check records missing.

VIDEO: Chief constable challenged on ‘anti-racist policing’ progress and stop and search reform

It’s been a year since Avon and Somerset’s chief constable Sarah Crew admitted her service was institutionally racist, but what is she actually doing about it?

‘The only language the university speaks is money’: pro-Palestine students now facing eviction

A possession order brought by Bristol University to evict the protest camp has been rejected - but only until further hearings on 19 July.

Join our newsletter

Get the essential stories you won’t find anywhere else

Subscribe to the Cable newsletter to get our weekly round-up direct to your inbox every Saturday

Join our newsletter

Subscribe to the Cable newsletter

Get our latest stories & essential Bristol news
sent to your inbox every Saturday morning