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æ <fae...@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 <k...@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 > > > > -- > fae...@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 >
_______________________________________________ Gendergap mailing list Gendergap@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/gendergap
