Download the data

The full dataset for the 2022 local 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 combined with results data transcribed from Scottish council websites by @gerrymulvenna.

This dataset is made available under the CC-By-SA 4.0 license. You should attribute authorship to @gerrymulvenna, stating that it contains candidate data provided by the Democracy Club.

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. transfers13 - transfer value accruing to this candidate at stage 13 of the count; may be blank if count didn't advance this far
38. total_votes13 - transfer value accruing to this candidate at stage 13 of the count; may be blank if count didn't advance this far
39. electorate - the total electorate with a franchise in the ward this candidate is standing
40. total_poll - total votes cast in this ward
41. valid_poll - number of valid votes received in this ward
42. rejected - number of votes rejected in this ward
43. quota - the Single Transerable Vote quota for this ward = 1 + int(valid_poll / (seats + 1))
44. seats - the number of councillors to be elected in this ward
45. candidates - the number of candidates standing in this ward