Research talk:Counting Wikipedians/Work log/2015-02-11

Thursday, February 12, 2015[edit]

Nealmcb came to #wikimedia-analytics asked about running a query to gather enwiki editors who would be eligible to vote for elections on wiki.

[...] for some particular election, e.g. for Wikimedia Steward[1]. According to [2], that currently requires 600 edits, 50 of which are recent.

EpochFail obtained this result:

So, I ran a query and found 12,043 users who matched the criteria.

SELECT user_id, user_name, COUNT(rev_id) AS recent_revisions  
FROM revision  
INNER JOIN user ON user_id = rev_user
WHERE user_editcount >= 600 AND 
      user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot') AND 
      rev_timestamp > "20140811" 
GROUP BY user_id
HAVING recent_revisions >= 50;

Regretfully, I couldn't get the query to run in 10 minutes on quarry, so I used the analytics servers to do it. You can download the dataset here: http://datasets.wikimedia.org/public-datasets/enwiki/etc/enwiki.eligible_user.tsv