Scottish Council elections 2017

Explore results and candidates for #council17 in Scotland

Download the data

The full dataset for the 2017 council elections in Scotland presented on this website is available for download as a single CSV (comma-separated values) file. It is presented in an unofficial capacity. The official results are published by each of the 32 Scottish councils with summary data published by the Electoral Management Board for Scotland. The dataset is a combination of candidate data collated by the Democracy Club and adapted under CC BY-SA 3.0 license and results data transcribed from Scottish council websites by @gerrymulvenna with the exception of data for the Scottish Borders Council, which was transcribed by Andrew Teale.

This dataset is made available under the CC-By-SA 4.0 license. You should attribute authorship to @gerrymulvenna, stating that it contains data from the Democracy Club and Andrew Teale, and provide a link to the same license.

Columns in the data

The CSV data file has a flat structure combining ward-level fields with candidate-level fields. The following fields are included as columns in the data:

  1. id - a unique numeric identifer for each candidate generated by the Democracy Club
  2. name - candidate name, transcribed by the Democracy Club
  3. party_name - the political party name transcribed by the Democracy Club
  4. council_id - an arbitrary human-readable unique identifier for each council
  5. council_name - the council name
  6. election - the Democracy Club identifier for the council election
  7. cand_ward_id - the Democracy Club identifer for the ward being contested
  8. map_ward_id - the unique identifier for each ward, as used by the mapping data from the Local Government Boundary Commission for Scotland
  9. ward_name - the name of the ward
  10. contested - 1 if ward was contested, 0 if not contested
  11. elected - 1 if candidate elected, 0 if not elected
  12. status - "Elected" or "Excluded" during count; can also be "Not elected" if candidate was neither elected nor excluded
  13. occurred_on_count - the stage of the count at which a candidate was Elected or Excluded; may be blank if candidate was neither elected nor excluded
  14. first_prefs - number of first preference votes for this candidate
  15. transfers02 - transfer value accruing to this candidate at stage 2 of the count; may be blank if count didn't advance this far
  16. total_votes02 - cummulative total votes for this candidate at stage 2 of the count; may be blank if count didn't advance this far
  17. transfers03 - transfer value accruing to this candidate at stage 3 of the count; may be blank if count didn't advance this far
  18. total_votes03 - cummulative total votes for this candidate at stage 3 of the count; may be blank if count didn't advance this far
  19. transfers04 - transfer value accruing to this candidate at stage 4 of the count; may be blank if count didn't advance this far
  20. total_votes04 - cummulative total votes for this candidate at stage 4 of the count; may be blank if count didn't advance this far
  21. transfers05 - transfer value accruing to this candidate at stage 5 of the count; may be blank if count didn't advance this far
  22. total_votes05 - cummulative total votes for this candidate at stage 5 of the count; may be blank if count didn't advance this far
  23. transfers06 - transfer value accruing to this candidate at stage 6 of the count; may be blank if count didn't advance this far
  24. total_votes06 - cummulative total votes for this candidate at stage 6 of the count; may be blank if count didn't advance this far
  25. transfers07 - transfer value accruing to this candidate at stage 7 of the count; may be blank if count didn't advance this far
  26. total_votes07 - cummulative total votes for this candidate at stage 7 of the count; may be blank if count didn't advance this far
  27. transfers08 - transfer value accruing to this candidate at stage 8 of the count; may be blank if count didn't advance this far
  28. total_votes08 - cummulative total votes for this candidate at stage 8 of the count; may be blank if count didn't advance this far
  29. transfers09 - transfer value accruing to this candidate at stage 9 of the count; may be blank if count didn't advance this far
  30. total_votes09 - cummulative total votes for this candidate at stage 9 of the count; may be blank if count didn't advance this far
  31. transfers10 - transfer value accruing to this candidate at stage 10 of the count; may be blank if count didn't advance this far
  32. total_votes10 - cummulative total votes for this candidate at stage 10 of the count; may be blank if count didn't advance this far
  33. transfers11 - transfer value accruing to this candidate at stage 11 of the count; may be blank if count didn't advance this far
  34. total_votes11 - cummulative total votes for this candidate at stage 11 of the count; may be blank if count didn't advance this far
  35. transfers12 - transfer value accruing to this candidate at stage 12 of the count; may be blank if count didn't advance this far
  36. total_votes12 - transfer value accruing to this candidate at stage 12 of the count; may be blank if count didn't advance this far
  37. electorate - the total electorate with a franchise in the ward this candidate is standing
  38. total_poll - total votes cast in this ward
  39. valid_poll - number of valid votes received in this ward
  40. rejected - number of votes rejected in this ward
  41. quota - the Single Transerable Vote quota for this ward = 1 + int(valid_poll / (seats + 1))
  42. seats - the number of councillors to be elected in this ward
  43. candidates - the number of candidates standing in this ward
';