# List_Councils.txt
# 29/03/24
# List of all Scottish Councils - aka Scottish Local Authority (SLA).
# For: Local Government Election 2022.
# Source used:  https://www.mygov.scot/organisations
# Comments begin at and include a #  .
# Column Names:
#   "ID"                  Primary Key. Used to maintain correct sorting.   e.g.  "C01" - "C99"
#   "CouncilNameShort"    Used for consistent file/folder-naming.  e.g. "C01_Aberdeen_City"
#   "CouncilNameFull"     Full Council Name.                       e.g. "Aberdeen City Council"
#   "NumWards"            Number of Wards.
#   "ElectionResultsURL"  The URL to the Election Results section of this Council's website.
#   "Notes"               Any special considerations e.g. "Uncontested_Ward" => contains at least 1 Uncontested ward.
#                         UncontestedWorkaroundFile
#
#
# ERRORS/CORRECTIONS/COMMENTS
# This list is VERY far from exhaustive!!  These were discovered en passant - there are probably many more!
# C01  Aberdeen City   No PreferencesByBallotBox   [PreferenceProfile  .txt]
# C04  Argyll and Bute    Preference Profile offered as both .BLT and .XLSX
#      Preference Profile .XLSX has quotes missing from data at foot of file.
# C05  City of Edinburgh Council
#      Abbreviated filenames!!!!  e.g.  CANDID_1.PDF
# C06  Clackmannanshire - files out of order!!
#      Poor naming:  6677.pdf,,,  !!
# C07  Comhairle_Eilean_Siar
#      Comhairle nan Eilean Siar = West Island Council.  Na h-Eileanan Siar = The Western Isles.
#      NO Ward_01  Uncontested_Ward
#      Missing files - ALL!!!  Wards:  (01  Uncontested_Ward), 06, 11.
#      ward02_declaration.pdf          should contain  DeclarationOfResults
#      ward02_preference_report.pdf    should contain  PreferenceSummary
#      H:/STV_Data_Files/Top_Level/C07_Comhairle_Eilean_Siar/Ward_05/C07_W05_PREFERENCEPROFILE__ward_05_preferenceprofile.txt
#      12/01/24.  "Access to Comhairle nan Eilean Siar’s IT system, including its website, have been affected by a Criminal Cyber Incident on the 7th November.
#      The incident has caused significant disruption and the current priority is to restore and secure data and ensure the continued delivery of
#      services to those in our communities who need them most.".
# C08  Dumfries and Galloway Council     Preference Profile files in a ZIP. Issue overcome with Ward 01.
#      Ward 01   Last 2 candidates in BLT don't have an Afilliation.
# C09  Dundee - has ZIP for each Ward                                          <<<<< ZIP
#      PreferencesByBallotBox missing in each set
# C10  East Ayrshire Council        Ward 05 <<<<<<<<ENCODE ERROR   BLT is PDF   "Keyrin James VON-DÖRING" "Scottish Libertarian Party"
# C11  East Dunbartonshire    Transfer animation!! Could be useful elsewhere    <<<<<  simply, Gerry Mulvenna's website (election.indylive.radio)
#      NO FILES!!  - just report-like, poorly-formatted web pages!!
#      Only Preference profile files available.   .xlsx (but 1 is really .txt!)  Quotes missing!!
#      "Emma SHEPPARD" "Scottish Greens – Think Global Act Local"    <<<<<<<<ENCODE  Wards 3,6
#                      "Scottish Greens Think Global Act Local"  on web page
#      As confirmed on 26/02/24:
#      Transfer Report - Ward 1
#      No files - just poorly-formatted web pages.
#      Only Preference profile files available.   .xlsx (but 1 is really .txt!)  Quotes missing!!
#      https://www.eastdunbarton.gov.uk/transfer-report-ward-1
#      Columnisation lost - numbers are left-aligned (like text).
#      No figures for Stage 2 - completely blank.
#      There are many other errors.
#      Appears as if copied-and-pasted from eCounting report files. Why??!!
#      BLT download presented as .XLSX  :
#        Wards 3,6.   BLT file:      "Scott FERGUSON" "Scottish Greens – Think Global Act Local"    << Party name <<<<<
#                     C11 Web site:                   "Scottish Greens Think Global Act Local"
# C12  East Lothian    Results at foot of long page
# C14  Falkirk    Candidates Votes Per Stage.pdf     Candidate singular
# C16  Glasgow City - has ZIP for each Ward  - some multi-versions             <<<<< ZIP
#      PreferenceProfile still using .BLT file
#      PreferencesByBallotBox missing in each set  ... but ...
#      Link at top of page: Published First Preference's Reports by Ballot Box for the Local Elections 2022   Actually PreferencesByBallotBox
#      Link at top of page: pdf icon Explanation of csv file on first preference [413kb]    Actually "How to understand the Preference Profile for each electoral ward" - but old contents
#      Ward 22 - Dennistoun    "Ois???? Duncan" encoded incorrectly    PreferenceProfile_V0001_Ward-22-Dennistoun_06052022_163757.blt  <<<<<ENCODE ERROR
# C17  Inverclyde - has ZIP for each/ALL Wards  - SINGLE ZIP FOR ALL WARDS     <<<<< SINGLE ZIP FOR ALL WARDS
#      NO Ward_01  Uncontested_Ward
#      Filenames incorrect style - all wards
#         Candidate Votes Per Stage.pdf     Vote -> Votes
#         Transfers.pdf                     Trnsfers -> Transfers
#      Candidate Vote Per Stage.pdf    should contain   CandidateVotesPerStage
#      Very messy side-bar for individual downloads
# C18  Midlothian            PreferenceProfile still using .BLT file
#      "More information about the Ward 6 Midlothian South results (PDF)" -> Ward_6_Midlothian_South_declaration_of_result.pdf
# C19  North Ayrshire        Ward_01 PreferenceProfile file VERY long!!  56 pages  ~3,000 lines!!  12/5.
# C20  North Lanarkshire     PreferenceProfile files in .XLSX format !!
#      Convert file from XLSX to TXT
#      ISSUE:  double-quotes missing from text at foot of file.
#      The quotes are missing from the opened spreadsheet - so not loaded correctly.
#        Melissa Laima Juliet KANE "Scottish Liberal Democrats"
#        James KING "Scottish Conservative and Unionist"
#        Lindsay SIEVEWRIGHT "Scottish National Party (SNP)"
#        Ward 1 - Kilsyth
#      should be:
#        "Melissa Laima Juliet KANE" "Scottish Liberal Democrats"
#        "James KING" "Scottish Conservative and Unionist"
#        "Lindsay SIEVEWRIGHT" "Scottish National Party (SNP)"
#        "Ward 1 - Kilsyth"
# C21  Orkney Islands        PreferenceProfile still using .BLT file
# C22  Perth and Kinross     PreferenceProfile files in .PDF format !!
#      P&K We recommend the Preference Profile is read in conjunction with the voting information - guidance (PDF) [242KB].
# C23  Renfrewshire Council
#      Ward 03   File links swapped     Ward 09  File missing
#      PDF-TXT CONVERSION - CORRUPTION                             <<<<<<<<<<<
#         I might have manually corrected the intermediate files - that's why apparent success!!!
#         Other PDF-TXT Councils: C10 C19 C22   All OK
#         05/02/24  Manually updated/transferred C23 files and links.
#      C22  OK!  Check others!!
#      H:\Des_STV_Data_Files\Top_Level\C23_Renfrewshire\Ward_01\
#        C23_W01_PREFERENCEPROFILE__Preference_profile_for_Ward_1_Renfrew_North_and_Braehead.pdf.TXT
#      Preference_profile_for_Ward_1_Renfrew_North_and_Braehead.pdf
#      "Microsoft Word - PreferenceProfile_V0001_Ward-1---Renfrew-North-and-Braehead_06052022_151122"
#      Used early-project PreferenceProfile files.
#      Missing file:  Preferences by ballot box for Ward 9
# C24  Scottish Borders      PreferenceProfile files in .XLSX format - Ward 02 Quotes missing!!!
#      Very disorganised web page!  File links scattered.  Extra step to download each file.
#      PreferenceProfile file         Ward 02  Quotes missing !!!
# C25  Shetland Islands      PreferenceProfile still using .BLT file
# C26  South Ayrshire        PreferenceProfile files in .XLSX format !!
#      PreferenceProfile files    .xlsx     Quotes missing
#      Later:
#         """Philip SAXTON"" ""Scottish Labour Party"""
#         """Ward 1 - Troon"""
# C27  South Lanarkshire     PreferenceProfile files in .TXT format         !!MISSING DATA!!   !!!IN FLUX!!!  OK NOW???
#      LOTS OF ISSUES !!!
#      Only 4 file types available. All merged/combined into a single file!!!!
#      Only saved the PreferenceProfile files ... but ...
#        Ward Description missing
#        Candidate Party missing
#        Quotes missing
#      Suspect that the files were previously available in expected style and number.
#                                                                           !!MISSING DATA!!
#        Ward 7 - East Kilbride Central South      MISSING DATA AT START !!!     6 3  ADDED!!
#        95 1 0
#        44 1 2 0
#        Ward 17 - Hamilton North and East         MISSING DATA AT START !!!     7 3  ADDED!!
#        48 1 0
#        5 1 2 0
# C28  Stirling              PreferenceProfile still using .BLT file
# C29  Highland              PreferenceProfile still using .BLT file
#   Ward 11 - UNCONTESTED WARD - NO indication on council website.
#   Ward 10:
#   C29_W10_PREFERENCEPROFILE__PreferenceProfile_V0001_Eilean_a__Che___06052022_161539.blt.TXT
#       "Peter Ó DONNGHAILE" "Scottish Labour Party"                 <<<<<<<<ENCODE ERROR
#       "Ruraidh STEWART" "Scottish Conservative and Unionist"
#       "Fay THOMSON" "Independent"
#       "Eilean a' Cheò"                                              <<<<<<<<ENCODE ERROR - CORRECTED-BY-UTF-8
# C30  Moray                 PreferenceProfile files in .TXT format
#      All files named as style  99999.*  !!
#      Ward 06   "Jérémie FERNANDES" "Scottish National Party (SNP)"     <<<<<<<<ENCODE ERROR
#        Old: "Jérémie FERNANDES" "Scottish National Party (SNP)"
#        New: "J????r????mie FERNANDES" "Scottish National Party (SNP)"
#      Hex:  22 4a c3 83 c6 92 c3 82 c2 a9 72 c3 83 c6 92 c3 82 c2 a9 6d 69 65 20 46 45 52 4e 41
#            4e 44 45 53 22 20 22 53 63 6f 74 74 69 73 68 20 4e 61 74 69 6f 6e 61 6c 20 50 61 72 74
# C31  West Dunbartonshire   PreferenceProfile files in .CSV format !!
# C32  West Lothian          PreferenceProfile files in .CSV format !!


# For CSV file format:
#"ID (Primary Key)","CouncilNameShort","CouncilNameFull","NumWards","Electorate","ElectionResultsURL","Notes"


#  TEST DATA
#C07,"C07_Comhairle_Eilean_Siar","Comhairle nan Eilean Siar",11,"https://www.cne-siar.gov.uk/your-council/elections-and-voting/local-government-election-2022/results/","Uncontested_Ward"
#C29,"C29_The_Highland","The Highland Council",21,"https://www.highland.gov.uk/slg22result","Uncontested_Ward"
#C16,"C16_Glasgow_City","Glasgow City Council",23,"https://www.glasgow.gov.uk/index.aspx?articleid=29269",""
#C19,"C19_North_Ayrshire","North Ayrshire Council",9,"https://north-ayrshire.cmis.uk.com/north-ayrshire/VotingElections/ElectionResults/2022ScottishLocalGovernmentElections.aspx",""


#   MASTER DATA

C01,"C01_Aberdeen_City","Aberdeen City Council",13,"https://www.aberdeencity.gov.uk/LG2022/local-government-election-2022-results",""
C02,"C02_Aberdeenshire","Aberdeenshire Council",19,"https://www.aberdeenshire.gov.uk/council-and-democracy/elections/results/council-elections-2022/",""
C03,"C03_Angus","Angus Council",8,"https://www.angus.gov.uk/council_and_democracy/elections_and_voting/local_government_elections_5_may_2022/local_elections_5_may_2022_results",""
C04,"C04_Argyll_and_Bute","Argyll and Bute Council",11,"https://www.argyll-bute.gov.uk/local-government-election-5-may-2022-results",""
C05,"C05_City_of_Edinburgh","City of Edinburgh Council",17,"https://www.edinburgh.gov.uk/election-results/local-government-elections-2022-results",""
C06,"C06_Clackmannanshire","Clackmannanshire Council",5,"https://www.clacks.gov.uk/site/documents/elections/localgovernmentresults2022reports/",""
C07,"C07_Comhairle_Eilean_Siar","Comhairle nan Eilean Siar",11,"https://www.cne-siar.gov.uk/your-council/elections-and-voting/local-government-election-2022/results/","Uncontested_Ward"
C08,"C08_Dumfries_and_Galloway","Dumfries and Galloway Council",12,"https://www.dumgal.gov.uk/article/24716/Council-elections-May-2022",""
C09,"C09_Dundee_City","Dundee City Council",8,"https://www.dundeecity.gov.uk/local-elections-2022/local-elections-2022-results",""
C10,"C10_East_Ayrshire","East Ayrshire Council",9,"https://www.east-ayrshire.gov.uk/CouncilAndGovernment/ElectionsAndVoting/ElectionResults/ResultsforEastAyrshireCouncilLocalElections.aspx",""
C11,"C11_East_Dunbartonshire","East Dunbartonshire Council",7,"https://www.eastdunbarton.gov.uk/residents/council-democracy/elections-and-voting/local-government-election-results-2022",""
C12,"C12_East_Lothian","East Lothian Council",6,"https://www.eastlothian.gov.uk/downloads/210600/elections_and_voting",""
C13,"C13_East_Renfrewshire","East Renfrewshire Council",5,"https://www.eastrenfrewshire.gov.uk/local-election-results-2022",""
C14,"C14_Falkirk","Falkirk Council",9,"https://www.falkirk.gov.uk/services/council-democracy/elections-voting/election-results/local-election-results/",""
C15,"C15_Fife","Fife Council",22,"https://www.fife.gov.uk/kb/docs/articles/council-and-democracy/elections2/election-results/local-government-election-results/local-elections-2022",""
C16,"C16_Glasgow_City","Glasgow City Council",23,"https://www.glasgow.gov.uk/index.aspx?articleid=29269",""
C17,"C17_Inverclyde","Inverclyde Council",7,"https://www.inverclyde.gov.uk/law-and-licensing/democracy-and-elections/2022-local-government-elections","Uncontested_Ward"
C18,"C18_Midlothian","Midlothian Council",6,"https://www.midlothian.gov.uk/info/799/elections_and_voting/726/local_government_election_2022",""
C19,"C19_North_Ayrshire","North Ayrshire Council",9,"https://north-ayrshire.cmis.uk.com/north-ayrshire/VotingElections/ElectionResults/2022ScottishLocalGovernmentElections.aspx",""
C20,"C20_North_Lanarkshire","North Lanarkshire Council",21,"https://www.northlanarkshire.gov.uk/your-council/elections-and-voting/scottish-council-elections-5-may-2022/scottish-council-election-results",""
C21,"C21_Orkney_Islands","Orkney Islands Council",6,"https://www.orkney.gov.uk/Council/C/local-government-election-5-may-2022.htm",""
C22,"C22_Perth_and_Kinross","Perth and Kinross Council",12,"https://www.pkc.gov.uk/article/22625/Local-Government-Election-Results-in-2022",""
C23,"C23_Renfrewshire","Renfrewshire Council",12,"https://www.renfrewshire.gov.uk/article/12323/Local-government-elections-2022",""
C24,"C24_Scottish_Borders","Scottish Borders Council",11,"https://www.scotborders.gov.uk/downloads/download/1471/2022_local_government_election_information",""
C25,"C25_Shetland_Islands","Shetland Islands Council",7,"https://www.shetland.gov.uk/downloads/download/1457/local-council-election-2022","Uncontested_Ward"
C26,"C26_South_Ayrshire","South Ayrshire Council",8,"https://www.south-ayrshire.gov.uk/lge2022",""
C27,"C27_South_Lanarkshire","South Lanarkshire Council",20,"https://www.southlanarkshire.gov.uk/downloads/download/1112/",""
C28,"C28_Stirling","Stirling Council",7,"https://www.stirling.gov.uk/council-democracy/politicians-elections-democracy/elections-voting/election-results/stirling-council-results/",""
C29,"C29_The_Highland","The Highland Council",21,"https://www.highland.gov.uk/slg22result","Uncontested_Ward"
C30,"C30_The_Moray","The Moray Council",8,"http://www.moray.gov.uk/moray_standard/page_137242.html","Uncontested_Ward"
C31,"C31_West_Dunbartonshire","West Dunbartonshire Council",6,"https://www.west-dunbarton.gov.uk/council/voting-and-elections/election-results/council-election-results/2022-local-election-results-by-ward/",""
C32,"C32_West_Lothian","West Lothian Council",9,"https://www.westlothian.gov.uk/local-results-2022",""

#EOF