Help us keep the lights on Support us
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.

Keep the Lights On

Investigative journalism strengthens democracy – it’s a necessity, not a luxury.

The Cable is Bristol’s independent, investigative newsroom. Owned and steered by more than 2,600 members, we produce award-winning journalism that digs deep into what’s happening in Bristol.

We are on a mission to become sustainable – will you help us get there?

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

Racist and traumatising: inside a Section 60 suspicionless stop and search operation

Officers searched innocent children, disproportionately targeted people of colour and undermined their anti-racism reforms during a 48-hour police operation in February. Their narrative that it was an effective knife-crime deterrent, done with consent, is misleading.

‘Like riding a wave – then the water cuts out’: Bristol’s TV workers hit by redundancies as companies close down

In a perfect storm caused by streamers, social media and Hollywood strikes, talented Bristol screen workers are being left in the cold by redundancies and companies shutting up shop, making a competitive industry even tougher for new and diverse talent.

Bristol’s queer communities are taking the fight against pinkwashing genocide

Pinkwashing, when powerful entities adopt a veneer of supporting LGBTQIA+ rights, has been a prominent PR tactic used by Israel to gloss over its brutal occupation of Palestinian territories. Queer communities are pushing back.

Filton 18: ‘The more you oppress people, the more they will rise’

The British state is treating Palestine Action activists who targeted an Elbit Systems Israeli arms facility on the outskirts of Bristol like terrorists – subjecting them to repressive sanctions in jail as they await trial.

Listen: People Just Do Something, with Joshua Dávila on putting the blockchain into use for the left

How do cryptocurrencies work? Why does the right love them so much? And how can blockchain technologies be used for more positive social purposes – or even authentically left-wing ones? Join Priyanka and Isaac to find out…

Are self-swab kits ‘the start of the end of sexual violence’, or could they cause more harm than good?

Against a backdrop of chronic underreporting of sexual assaults, thousands of self-administered rape test kits have been distributed across Bristol, targeting university campuses. But are users, already coping with trauma, being given the clarity they need to make informed choices?

Listen: Bristol Unpacked, with former Lord Mayor Paul Goggin on homelessness, mental health and the struggle for south Bristol votes

'It's been eventful', says Paul Goggin, of a life that has featured both rough sleeping and local politics. He joins Neil Maggs to talk housing, faith, and whether Labour should fear Reform in wards like Hartcliffe and Withywood.

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