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(a)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(a)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=us…
https://en.wikipedia.org/w/api.php?format=json&action=query&list=us…
> 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(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/gendergap
--
faewik(a)gmail.com
https://commons.wikimedia.org/wiki/User:Fae
Personal and confidential, please do not circulate or re-quote.
_______________________________________________
Gendergap mailing list
Gendergap(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/gendergap