@TBolliger & @SPoore
The email address is confidential user information and might be a violation of our Privacy Policy. We should probably verify with someone in WMF-Legal before adding that to the report. To me it's unclear if we are allowed to send emails (from production) or we are allowed to export those emails (for internal uses).

Good point, David. Let's drop the email address requirement for now. We can go through the proper process with Legal if we need the emails.

'allow email' preference enabled

If you want to be technical about it, the allow email preference by itself is private. What is public is if both allowed email, and user_email_authenticated is set. But I doubt anyone really cares about exposing the preference, since the almost equivalent thing is exposed.

@Bawolff I don't see user_email_authenticated in the replicas. I do see ug_property = disableemail for users that have disabled it.

@TBolliger If we are gonna use the data on the replicas we can only know if users have explicitly disabled recieving emails. I would assume that since in this case they are all admins, they will have an email address and such email address would be confirmed. So technically, unless they have disabled it, they should be able to receive emails.

That's fine. And yes, it's safe to assume if they're an admin they have an email registered.

@TBolliger, I don't know if it is relevant, but we have both users with block rights who are not admins in Portuguese Wikipedia and admins with no emails attached to their accounts.

Actually people performing blocks in context of harrasment are not necessary top people by the number of blocks. In the top I suspect to be guys fighting vandals most actively, they are not necessary involved with more "social" blocks (though not necessary not involved too). Just a thing to keep in mind.

Perhaps something like top of admins by blocks of people with more than N edits (e.g. 500) would reflect "social" rather than CVN related blocks better.

We are gathering this list of users who frequently block others so we can consult about https://meta.wikimedia.org/wiki/Community_health_initiative/Blocking_tools_and_improvements, so it does not matter if they are an admin or not, and also doesn't matter if they are performing blocks for harassment vs. vandalism, etc.

For future reference, here is the query used to generate this data.