First up is staff since those are relatively easy. Staff accounts will almost always be either Foobar (WMF) or Foobar-WMF

SELECT gu_name, gu_email, gu_registration FROM globaluser WHERE gu_locked=0 AND (gu_name LIKE "%(WMF)" OR gu_name LIKE "%-WMF");

That gives me 695 rows but needed cleanup:

• 20 staff members joined after the cutoff date (listed in the criteria as 2022-01-17)
• I believe 3 of the accounts here should have been locked as no longer with the Foundation - reported them to ITS for locking
• The list also includes these bot accounts which shouldn't be able to vote, so I removed them (the bot check should prevent them anyway, but probably worth just taking them out):
  • Trademarks (WMF)
  • Ops Monitor (WMF)
  • RelEngBot (WMF)
  • MoveCom-WMF

That leaves me with 668 accounts to be added to the list.

Next, affiliates. In particular the affiliates with specific accounts for their members:

• Wikimedia Armenia
• Wikimedia Argentina
• Wikimedia Österreich / Austria
• Wiki Movement Brazil User Group (Wiki Movimento Brasil)
• Wikimedia Canada
• Wikimedia CH / Switzerland
• Wikimedia Chile
• Wikimedia Colombia
• Wikimedia Česká republika / Czech Republic
• Wikimedia Deutchland / Germany
• Wikimedia France
• Wikimedia Indonesia
• Wikimedia Italia / Italy
• Wikimedia Korea/Hanguk
• Wikimedia México / Mexico
• Wikimedia Nederland / the Netherlands
• Wikimedia Norge / Norway
• Wikimedia Polska / Poland
• Wikimedia Sverige / Sweden
• Wikimedia Ukraine
• Wikimedia UK

These are usually regular and involve a suffix indicating affiliation (usually the abbreviation of the affiliate in brackets, except France which uses "WMFr" and no brackets).

Note that I'm pretty sure that not all accounts that meet this query will be a member of staff or a contractor for an affiliate. Some of the accounts will be old and belong to people who are no longer with the affiliate.

SELECT gu_name, gu_email, gu_registration FROM globaluser WHERE gu_locked=0 AND (gu_name LIKE '%(WMAM)' OR gu_name LIKE '%(WMAR)' OR gu_name LIKE '%(WMAT)' OR gu_name LIKE '%(WMB)' OR gu_name LIKE '%(WMCA)' OR gu_name LIKE '%(WMCH)' OR gu_name LIKE '%(WMCL)' OR gu_name LIKE '%(WMCO)' OR gu_name LIKE '%(WMCZ)' OR gu_name LIKE '%(WMDE)' OR gu_name LIKE '%WMFr' OR gu_name LIKE '%(WMFr)' OR gu_name LIKE '%(WMID)' OR gu_name LIKE '%(WMIT)' OR gu_name LIKE '%(WMKR)' OR gu_name LIKE '%(WMMX)' OR gu_name LIKE '%(WMNL)' OR gu_name LIKE '%(WMNO)' OR gu_name LIKE '%(WMPL)' OR gu_name LIKE '%(WMSE)' OR gu_name LIKE '%(WMUA)' OR gu_name LIKE '%(WMUK)');

This output 545 accounts. I trimmed out the ones that were too new (15 of them registered after 2022-01-17) and some of them obviously named as bots, role, or test accounts for a total of 523.

foks@mwmaint1002:~$ mwscript extensions/SecurePoll/cli/wm-scripts/importGlobalVoterList.php --wiki=metawiki --list-name ucoc-vote-2022 ucoc-staff.txt | tee special-users.log
Adding ABaso (WMF)
Adding ABreault (WMF)

<snip>

Adding Ylva Linn Liliegren (WMCH)
Adding Łukasz Garczewski (WMPL)

948 users added. I'm assuming the other 293 were already on the list as eligible in the first pass

In T303071#7758273, @jrbs wrote:

Since the solution in T288455#7277461 seems rather complicated, and ultimately only appeared to add six people to the voter roll, we've made the call to have those stuck in the middle here email ucocproject (at) wikimedia.org should they need to be added.

For the record, we only had to add one developer exemption to the vote this time around.