Research talk:Counting Wikipedians/Work log/2015-02-11
Add topicAppearance
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