one take away is how few voters there are.
we have a lot of feminist editathons coming up should we consider recruiting at events to get new editors over 150 edits, with a view of block voting in next year's election?
if we organize now, we could run a civility slate of candidates.
On Tue, Dec 9, 2014 at 9:08 AM, Fæ faewik@gmail.com wrote:
OOPS,
Absolutely correct, I had a programme error. Re-running this gives a more credible set of numbers: Total voted: 590 Total identified with gender: 255 Male 224 Female 31
So open males = 38%, open females = 5%. Which indicates that a good *guesstimate* of the number of women voting was 11%.
I might also have skipped a voter, I think there should be 591, but I have given up on debugging that one.
Fae
On 9 December 2014 at 13:55, Katie Chan ktc@ktchan.info wrote:
On 09/12/2014 13:45, Fæ wrote:
The statistic comes from querying the English Wikipedia database. This includes a table of user preferences which itself is where the on-wiki preferences stores information like preferred gender.
Here's the SQL for anyone interested (it includes other redundant stuff, I was re-using something I already had to hand): SELECT user_name, user_editcount, LEFT(user_registration,4) AS reg, GROUP_CONCAT(DISTINCT ug_group SEPARATOR ' ') AS grps, GROUP_CONCAT(DISTINCT CONCAT(up_property,':',up_value)) AS prop FROM user u LEFT JOIN user_properties ON up_user=u.user_id LEFT JOIN user_groups ON u.user_id=ug_user WHERE user_name="''' +u +'''" AND up_property="gender" GROUP BY user_name ORDER BY user_editcount DESC;
(Where "u" is a variable iterating over the listed voters.)
As others are pointing out, the statistic of 1/590 is a fact
Err....
https://en.wikipedia.org/w/api.php?format=json&action=query&list=use...
https://en.wikipedia.org/w/api.php?format=json&action=query&list=use...
and others.
KTC
-- Katie Chan Any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent the view of any organisation the author is associated with or employed by.
Experience is a good school but the fees are high. - Heinrich Heine
This email has been checked for viruses by Avast antivirus software. http://www.avast.com
Gendergap mailing list Gendergap@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/gendergap
-- faewik@gmail.com https://commons.wikimedia.org/wiki/User:Fae Personal and confidential, please do not circulate or re-quote.
Gendergap mailing list Gendergap@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/gendergap