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 <[email protected]> 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=users&ususers=KTC&usprop=gender > https://en.wikipedia.org/w/api.php?format=json&action=query&list=users&ususers=Fluffernutter&usprop=gender > > 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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/gendergap -- [email protected] https://commons.wikimedia.org/wiki/User:Fae Personal and confidential, please do not circulate or re-quote. _______________________________________________ Gendergap mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/gendergap
