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=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
> 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