Produce a list of wiki projects ranked by number of eligible voters in Board elections
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Qgil
	Mar 30 2021, 11:40 AM

Description

My team is starting to organize outreach for the upcoming Board election, and we need a bit of analytics. Can you help us, please?

We would like to have a list of wiki projects sorted by the number of eligible voters, or anything available in that direction. The closest we have found so far is this list of wiki projects sorted by any editing activity in the past 30 days. I wonder whether quarry & friends could help here, or an already existing list we don't know of.

The eligibility criteria used in previous elections are:

At least 300 edits in total.
At least 30 edits in the past 6 months.

If creating this list is too difficult or expensive, a ranking of wiki projects by monthly active editors would be good enough as well. What matters to us is the ranking of projects, not the exact number of counted editors in each project.

If you could provide or point us to a list by April 15, that would be great.

Related Objects

Mentioned In: T287023: Sending two mass emails to eligible voters for the board elections 2021

Event Timeline

Qgil created this task.Mar 30 2021, 11:40 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 30 2021, 11:40 AM

Building the list is not complicated with the tools we have. The concern I have is about delay in data: our computation system get's updated every month. If end-of-march data snapshot is ok, then it's a wrap :) If the recent data is of importance it complicates the matter.

If creating this list is too difficult or expensive, a ranking of wiki projects by monthly active editors would be good enough as well. What matters to us is the ranking of projects, not the exact number of counted editors in each project.

@Qgil are you aware of the wiki comparison tool? Column I in the "Dec 2020" tab has each project's average monthly active editors from 2020.

@JAllemandou end of March would be totally fine but, actually, I think this spreadsheet that @nshahquinn-wmf links to is all we need! Give me a bit of time to check it in detail, and if this is all that we need I'll resolve the task. Thank you for your quick responses!

Ok, after checking with my team, this list is good to get us going, and if this is all we can get, it's fine. However, if building the list based on the criteria defined above and the data set from March is not too complicated, we would still welcome it.

I think such a list would be interesting for many volunteers, not just us. We could publish it on Meta with the data and use it as a basis for our coordination work there.

I'll wait for March data to flow in (probably April 3rd) and then will generate the data.

About publishing the data, I know that some communities are less happy than others about user-related stats - I'll fully trust your judgement @Qgil :)

Hi!
We tried this query to extract the rank of wikis per voter base:

WITH base_data AS (
    SELECT
        wiki_db,
        event_user_id,
        MAX(event_user_revision_count) AS rev_count,
        COUNT(1) AS revs_last_6_months
    FROM wmf.mediawiki_history
    WHERE
        snapshot = '2021-02' AND
        event_entity = 'revision' AND
        event_type = 'create' AND
        event_timestamp >= '2020-09-01' AND
        NOT ARRAY_CONTAINS(event_user_is_bot_by, 'group') AND
        event_user_id IS NOT NULL
    GROUP BY
        wiki_db,
        event_user_id
    HAVING
        revs_last_6_months >= 30 AND
        rev_count >= 300
)
SELECT
    wiki_db,
    COUNT(1) AS voters
FROM base_data
GROUP BY wiki_db
ORDER BY voters DESC
LIMIT 100
;

The results are the following:

wiki_db	voters
enwiki	20659
wikidatawiki	9098
commonswiki	8542
dewiki	4820
frwiki	3513
jawiki	2986
eswiki	2603
ruwiki	2558
zhwiki	2057
itwiki	1895
plwiki	1111
ptwiki	1066
nlwiki	921
metawiki	847
ukwiki	752
hewiki	751
fawiki	684
kowiki	602
enwiktionary	541
svwiki	491
cswiki	489
arwiki	481
viwiki	401
huwiki	392
trwiki	389
idwiki	386
fiwiki	378
cawiki	309
hywiki	287
nowiki	238
thwiki	227
mediawikiwiki	226
enwikisource	200
srwiki	191
incubatorwiki	187
bnwiki	171
elwiki	168
frwikisource	166
bgwiki	154
azwiki	147
rowiki	136
dawiki	135
frwiktionary	133
hrwiki	130
simplewiki	124
etwiki	106
enwikivoyage	96
mswiki	89
euwiki	89
skwiki	86
hiwiki	77
glwiki	73
eowiki	72
slwiki	71
specieswiki	71
lvwiki	67
enwikiquote	67
tawiki	66
ltwiki	65
kawiki	65
mlwiki	65
enwikibooks	65
bewiki	65
dewiktionary	59
mkwiki	54
zh_yuewiki	54
dewikisource	52
enwikiversity	51
ruwiktionary	49
tawikisource	48
itwikisource	47
plwiktionary	45
urwiki	42
plwikisource	41
kkwiki	39
tewiki	37
mywiki	35
ruwikivoyage	35
ruwikisource	35
ckbwiki	34
zhwikisource	33
ttwiki	33
lawiki	33
sqwiki	32
dewikibooks	32
mrwiki	31
itwikiquote	30
sourceswiki	30
hewikisource	30
ruwikinews	29
ruwikimedia	28
sawikisource	28
enwikinews	28
bawiki	28
afwiki	28
bnwikisource	28
cswiktionary	27
scowiki	27
aswiki	26
cywiki	26

We made some assumptions, please confirm or contest them:

Edits to all namespaces count
Editors belonging to the BOT group don't count
Cross-project edits don't count
Edits to deleted pages count

If it's OK, we'll run this query on the new snapshot (March) in a few days when data is available, and give you the results.
Cheers!

Gosh, guys, you're fast! Thank you so much.

@mforns this query looks good to me, and the list of results is very interesting already. Except that "LIMIT 100" which I guess is the instruction that caps the list to 100 projects listed? (which makes sense when throwing a quick test, no complaints).

About publishing the list and possible criticism... I don't know, this is a bit like publishing the census so everyone knows whether they can vote or not (in this case at a project level, not an individual level). Here I can see a lot of value for contributors of projects NOT appearing in the list, or seeing 1-2 voters when they'd expect more. It can help small projects being aware of this election and it might help them mobilize potential voters by... editing! :)

If you see other possible concerns please share them.

@mforns I'm not sure this would be more accurate or technically possible (or whether it would make a big difference in the ranking), but here is an idea for better criteria:

Each user is evaluated according to their total number of edits in any project, not only one (more than 300, at least 30 in the past 6 months).
Each user is counted only in their home wiki.

If I understand the current query correctly, if a user has many edits in two different wiki projects, they will be counted twice, correct? If in such scenario users only are counted once across all their wiki projects, then it's good.

A typical use case are users editing Wikipedia in a language as well as e.g. Wikisource etc, or Wikidata / Commons.

Hi, I am a part-time facilitator on Quim's team. I have a couple of suggestions:

A rule for user not blocked (on any Wikimedia project)
These were the rules used by the account eligibility tool for last elections. I am not sure though if it will be particularly helpful or change the numbers significantly.

Thank you @KCVelaga for the suggestion and link to code :)
I assume we should base our rules on the following description: https://github.com/Pathoschild/Wikimedia-contrib/blob/main/tool-labs/accounteligibility/framework/EventFactory.php#L135
If so, there would be two differences between this year's rules and the ones from 2017: 30 edits instead of 20 over the last 6 months, and not blocked on any wiki (the rule you suggested) instead of blocked on maximum one wiki.
Can you confirm this is ok?
Also, one caveat to note is that the quality of our user-blocked data has not thoroughly been checked, and while I trust it, there might (will) be some differences with the database result. Just sayin' :)

Also, from @Qgil question:

if a user has many edits in two different wiki projects, they will be counted twice, correct?

Your understanding is correct, and that means the result would be incorrect :)
My question is then: how can we know the home-wiki of a user?

I have what I think are good news. :)

While it is exciting to get more accurate results and I have been the first one proposing to fine tune the query... What our team needs is in fact only a ranking of wiki projects. The approximation of your first query with the February data is good enough already. If you can run a full query (not capped to top 100 results) based on the March data, that will be great and more than enough.

I have what I think are good news. :)

While it is exciting to get more accurate results and I have been the first one proposing to fine tune the query... What our team needs is in fact only a ranking of wiki projects. The approximation of your first query with the February data is good enough already. If you can run a full query (not capped to top 100 results) based on the March data, that will be great and more than enough.

OK! We'll do as soon as the snapshot for March is ready.

Mehman97 subscribed.Apr 5 2021, 1:45 PM

OscarCTR subscribed.Apr 5 2021, 1:59 PM

There you go @Qgil :)

spark.sql("""
WITH base_data AS (
    SELECT
        wiki_db,
        event_user_id,
        MAX(event_user_revision_count) AS rev_count,
        COUNT(1) AS revs_last_6_months
    FROM wmf.mediawiki_history
    WHERE
        snapshot = '2021-03' AND
        event_entity = 'revision' AND
        event_type = 'create' AND
        event_timestamp >= '2020-10-01' AND
        NOT ARRAY_CONTAINS(event_user_is_bot_by, 'group') AND
        event_user_id IS NOT NULL
    GROUP BY
        wiki_db,
        event_user_id
    HAVING
        revs_last_6_months >= 30 AND
        rev_count >= 300
)
SELECT
    wiki_db,
    COUNT(1) AS voters
FROM base_data
GROUP BY wiki_db
ORDER BY voters DESC
""").show(1000, false)


+--------------------+------+                                                   
|wiki_db             |voters|
+--------------------+------+
|enwiki              |20882 |
|wikidatawiki        |9281  |
|commonswiki         |8453  |
|dewiki              |4868  |
|frwiki              |3566  |
|jawiki              |3024  |
|eswiki              |2648  |
|ruwiki              |2615  |
|zhwiki              |2041  |
|itwiki              |1893  |
|plwiki              |1132  |
|ptwiki              |1068  |
|nlwiki              |922   |
|metawiki            |885   |
|ukwiki              |757   |
|hewiki              |743   |
|fawiki              |705   |
|kowiki              |591   |
|enwiktionary        |540   |
|cswiki              |504   |
|svwiki              |497   |
|arwiki              |483   |
|idwiki              |405   |
|trwiki              |403   |
|huwiki              |403   |
|viwiki              |396   |
|fiwiki              |377   |
|cawiki              |315   |
|hywiki              |258   |
|mediawikiwiki       |238   |
|nowiki              |236   |
|thwiki              |223   |
|enwikisource        |197   |
|incubatorwiki       |195   |
|srwiki              |192   |
|elwiki              |171   |
|frwikisource        |170   |
|bnwiki              |165   |
|bgwiki              |157   |
|azwiki              |154   |
|dawiki              |138   |
|frwiktionary        |138   |
|hrwiki              |136   |
|rowiki              |136   |
|simplewiki          |126   |
|etwiki              |106   |
|enwikivoyage        |96    |
|euwiki              |90    |
|skwiki              |90    |
|mswiki              |85    |
|hiwiki              |77    |
|eowiki              |75    |
|enwikiquote         |73    |
|specieswiki         |71    |
|lvwiki              |70    |
|glwiki              |70    |
|kawiki              |69    |
|slwiki              |67    |
|bewiki              |67    |
|tawiki              |66    |
|enwikibooks         |65    |
|mlwiki              |62    |
|dewiktionary        |61    |
|ltwiki              |60    |
|mkwiki              |55    |
|zh_yuewiki          |52    |
|enwikiversity       |51    |
|ruwiktionary        |50    |
|itwikisource        |50    |
|dewikisource        |49    |
|tawikisource        |47    |
|plwiktionary        |46    |
|kkwiki              |42    |
|urwiki              |41    |
|plwikisource        |39    |
|tewiki              |38    |
|ckbwiki             |36    |
|ruwikisource        |35    |
|mrwiki              |34    |
|zhwikisource        |34    |
|sqwiki              |33    |
|sourceswiki         |33    |
|ttwiki              |32    |
|dewikibooks         |32    |
|lawiki              |32    |
|mywiki              |32    |
|ruwikivoyage        |31    |
|ruwikinews          |31    |
|itwikiquote         |30    |
|afwiki              |30    |
|bawiki              |29    |
|bnwikisource        |29    |
|cswiktionary        |29    |
|hewikisource        |28    |
|bswiki              |28    |
|enwikinews          |27    |
|aswiki              |27    |
|sawikisource        |27    |
|scowiki             |26    |
|ruwikimedia         |26    |
|aswikisource        |25    |
|be_x_oldwiki        |25    |
|dewikivoyage        |25    |
|tlwiki              |24    |
|hiwikisource        |23    |
|nnwiki              |23    |
|knwiki              |23    |
|cywiki              |23    |
|uzwiki              |22    |
|gawiki              |22    |
|dewikiversity       |22    |
|shwiki              |21    |
|iswiki              |21    |
|testwiki            |21    |
|pawiki              |21    |
|nlwiktionary        |20    |
|newiki              |19    |
|svwiktionary        |19    |
|arzwiki             |19    |
|jvwiki              |19    |
|kuwiki              |18    |
|eswiktionary        |17    |
|uawikimedia         |17    |
|cebwiki             |17    |
|frwikiversity       |17    |
|elwiktionary        |16    |
|itwikivoyage        |16    |
|orwiki              |16    |
|zhwiktionary        |16    |
|alswiki             |16    |
|kuwiktionary        |16    |
|lbwiki              |16    |
|swwiki              |16    |
|ptwiktionary        |15    |
|szywiki             |15    |
|itwiktionary        |15    |
|minwiki             |15    |
|brwiki              |15    |
|astwiki             |15    |
|svwikisource        |15    |
|jawiktionary        |14    |
|wuuwiki             |14    |
|itwikibooks         |14    |
|ocwiki              |14    |
|pawikisource        |13    |
|sewikimedia         |13    |
|sdwiki              |13    |
|slwikisource        |13    |
|avkwiki             |13    |
|lmowiki             |13    |
|warwiki             |12    |
|hawiki              |12    |
|tewikisource        |12    |
|zh_min_nanwiki      |12    |
|satwiki             |12    |
|frwikibooks         |12    |
|nlwikibooks         |12    |
|fiwiktionary        |12    |
|hywwiki             |11    |
|fywiki              |11    |
|guwikisource        |11    |
|zhwikinews          |11    |
|itwikiversity       |11    |
|trwiktionary        |11    |
|cswikisource        |11    |
|ruwikiquote         |11    |
|guwiki              |11    |
|testwikidatawiki    |11    |
|knwikisource        |11    |
|siwiki              |11    |
|plwikiquote         |11    |
|trwikisource        |11    |
|ukwikisource        |11    |
|hewiktionary        |11    |
|eswikinews          |11    |
|betawikiversity     |11    |
|thwiktionary        |11    |
|idwikimedia         |10    |
|mrwikisource        |10    |
|eswikiquote         |10    |
|mnwiki              |10    |
|cawiktionary        |10    |
|frwikivoyage        |10    |
|tawiktionary        |10    |
|cewiki              |10    |
|azbwiki             |10    |
|tgwiki              |10    |
|thwikisource        |10    |
|vecwiki             |10    |
|hywikisource        |10    |
|lijwiki             |9     |
|kywiki              |9     |
|outreachwiki        |9     |
|ptwikiversity       |9     |
|zh_classicalwiki    |9     |
|bclwiki             |9     |
|ndswiki             |9     |
|zhwikiversity       |9     |
|idwikisource        |9     |
|yowiki              |9     |
|eswikisource        |9     |
|suwiki              |9     |
|kmwiki              |8     |
|kwwiki              |8     |
|abwiki              |8     |
|pnbwiki             |8     |
|tcywiki             |8     |
|frwikinews          |8     |
|arywiki             |8     |
|ptwikisource        |8     |
|ptwikinews          |8     |
|iawiki              |8     |
|wawiki              |8     |
|barwiki             |8     |
|frwikiquote         |8     |
|lowiki              |7     |
|gomwiki             |7     |
|plwikibooks         |7     |
|anwiki              |7     |
|cswikiversity       |7     |
|mznwiki             |7     |
|lawikisource        |7     |
|tawikiquote         |7     |
|hiwikibooks         |7     |
|xmfwiki             |7     |
|slwikiversity       |7     |
|trwikiquote         |7     |
|eswikibooks         |7     |
|idwiktionary        |7     |
|fawiktionary        |7     |
|banwiki             |7     |
|itwikinews          |7     |
|pswiki              |7     |
|cvwiki              |7     |
|mnwwiki             |7     |
|zhwikivoyage        |6     |
|jawikibooks         |6     |
|sowiki              |6     |
|diqwiki             |6     |
|ukwikiquote         |6     |
|ugwiki              |6     |
|hywiktionary        |6     |
|jawikisource        |6     |
|iowiki              |6     |
|ptwikibooks         |6     |
|cswikibooks         |6     |
|crhwiki             |6     |
|rowikisource        |6     |
|fawikisource        |6     |
|jawikivoyage        |6     |
|ukwikivoyage        |6     |
|huwiktionary        |6     |
|nlwikisource        |6     |
|pamwiki             |6     |
|cawikisource        |6     |
|ruwikiversity       |6     |
|iowiktionary        |6     |
|ruwikibooks         |6     |
|sahwiki             |6     |
|maiwiki             |5     |
|plwikimedia         |5     |
|sawiki              |5     |
|hifwiki             |5     |
|gdwiki              |5     |
|oswiki              |5     |
|kowikisource        |5     |
|iewiki              |5     |
|lezwiki             |5     |
|bhwiki              |5     |
|zhwikiquote         |5     |
|ukwiktionary        |5     |
|szlwiki             |5     |
|fawikiquote         |5     |
|glkwiki             |5     |
|inhwiki             |5     |
|lldwiki             |5     |
|myvwiki             |5     |
|brwikisource        |5     |
|liwiki              |5     |
|pmswiki             |5     |
|eswikivoyage        |5     |
|vowiki              |5     |
|zhwikibooks         |5     |
|mtwiki              |5     |
|scwiki              |5     |
|mgwiki              |5     |
|bjnwiki             |5     |
|huwikisource        |4     |
|cswikiquote         |4     |
|nds_nlwiki          |4     |
|ocwiktionary        |4     |
|glwiktionary        |4     |
|idwikibooks         |4     |
|cowiki              |4     |
|ilowiki             |4     |
|fowiki              |4     |
|yiwiki              |4     |
|kawiktionary        |4     |
|bewikisource        |4     |
|ptwikiquote         |4     |
|plwikinews          |4     |
|elwikisource        |4     |
|frpwiki             |4     |
|etwikiquote         |4     |
|orwikisource        |4     |
|eowiktionary        |4     |
|nowikimedia         |4     |
|papwiki             |4     |
|nlwikimedia         |4     |
|quwiki              |4     |
|frrwiki             |4     |
|arwiktionary        |4     |
|viwiktionary        |4     |
|emlwiki             |4     |
|mswiktionary        |4     |
|wawiktionary        |4     |
|dewikinews          |4     |
|angwiki             |4     |
|hewikiquote         |4     |
|olowiki             |3     |
|cawikimedia         |3     |
|htwiki              |3     |
|ruewiki             |3     |
|dewikiquote         |3     |
|nowiktionary        |3     |
|stqwiki             |3     |
|nahwiki             |3     |
|bnwikibooks         |3     |
|skwiktionary        |3     |
|gorwiki             |3     |
|srwikisource        |3     |
|fawikibooks         |3     |
|vepwiki             |3     |
|cswikinews          |3     |
|arwikiquote         |3     |
|omwiki              |3     |
|guwiktionary        |3     |
|azwikiquote         |3     |
|kabwiki             |3     |
|euwikisource        |3     |
|kowiktionary        |3     |
|nlwikiquote         |3     |
|arwikinews          |3     |
|nqowiki             |3     |
|shnwiki             |3     |
|simplewiktionary    |3     |
|cawikiquote         |3     |
|napwiki             |3     |
|acewiki             |3     |
|huwikibooks         |3     |
|etwiktionary        |3     |
|atjwiki             |3     |
|cawikibooks         |3     |
|snwiki              |3     |
|eswikiversity       |3     |
|pcdwiki             |3     |
|dtywiki             |3     |
|gnwiki              |3     |
|viwikibooks         |3     |
|test2wiki           |3     |
|urwiktionary        |3     |
|fiu_vrowiki         |3     |
|bgwiktionary        |3     |
|gomwiktionary       |3     |
|ltwiktionary        |3     |
|fiwikiquote         |3     |
|lfnwiki             |3     |
|azwikibooks         |3     |
|bat_smgwiki         |3     |
|dawikisource        |3     |
|azwikisource        |3     |
|cawikinews          |3     |
|scnwiki             |3     |
|lawiktionary        |3     |
|plwikivoyage        |3     |
|mlwikisource        |3     |
|tyvwiki             |3     |
|fiwikisource        |3     |
|udmwiki             |3     |
|zuwiki              |3     |
|vecwiktionary       |2     |
|bnwikivoyage        |2     |
|ladwiki             |2     |
|lijwikisource       |2     |
|vlswiki             |2     |
|fawikivoyage        |2     |
|hsbwiki             |2     |
|pagwiki             |2     |
|hrwiktionary        |2     |
|bdwikimedia         |2     |
|skwikiquote         |2     |
|euwiktionary        |2     |
|sewiki              |2     |
|nlwikivoyage        |2     |
|hiwiktionary        |2     |
|shywiktionary       |2     |
|eowikiquote         |2     |
|dsbwiki             |2     |
|rmwiki              |2     |
|knwiktionary        |2     |
|hrwikiquote         |2     |
|sqwikiquote         |2     |
|arwikisource        |2     |
|hewikivoyage        |2     |
|bnwiktionary        |2     |
|bgwikisource        |2     |
|fiwikibooks         |2     |
|arwikiversity       |2     |
|mhrwiki             |2     |
|avwiki              |2     |
|roa_tarawiki        |2     |
|nvwiki              |2     |
|mlwiktionary        |2     |
|iswiktionary        |2     |
|kmwiktionary        |2     |
|uzwiktionary        |2     |
|thwikibooks         |2     |
|trwikimedia         |2     |
|nsowiki             |2     |
|cywikisource        |2     |
|jawikinews          |2     |
|gagwiki             |2     |
|kswiki              |2     |
|slwikiquote         |2     |
|cdowiki             |2     |
|mrwikibooks         |2     |
|thwikiquote         |2     |
|nlwikinews          |2     |
|kvwiki              |2     |
|hawwiki             |2     |
|bawikibooks         |2     |
|adywiki             |2     |
|yuewiktionary       |2     |
|eowikisource        |2     |
|liwikinews          |2     |
|astwiktionary       |2     |
|mkwikisource        |2     |
|jvwiktionary        |2     |
|idwikiquote         |2     |
|foundationwiki      |2     |
|hewikibooks         |2     |
|nawiki              |2     |
|koiwiki             |2     |
|bpywiki             |2     |
|hakwiki             |2     |
|igwiki              |2     |
|fawikinews          |2     |
|brwiktionary        |2     |
|lawikibooks         |2     |
|tkwiki              |2     |
|viwikisource        |2     |
|ltwikiquote         |2     |
|mrjwiki             |2     |
|dawikibooks         |2     |
|napwikisource       |2     |
|jbowiki             |2     |
|eowikinews          |2     |
|lrcwiki             |2     |
|mdfwiki             |1     |
|orwiktionary        |1     |
|ukwikibooks         |1     |
|rowiktionary        |1     |
|xalwiki             |1     |
|fjwiki              |1     |
|bewiktionary        |1     |
|siwikibooks         |1     |
|fowiktionary        |1     |
|kmwikibooks         |1     |
|cywiktionary        |1     |
|tgwiktionary        |1     |
|nowikibooks         |1     |
|tswiki              |1     |
|hewikinews          |1     |
|srwikinews          |1     |
|pflwiki             |1     |
|ukwikinews          |1     |
|kshwiki             |1     |
|akwiki              |1     |
|jamwiki             |1     |
|zh_min_nanwikisource|1     |
|srwiktionary        |1     |
|lnwiki              |1     |
|bswiktionary        |1     |
|cbk_zamwiki         |1     |
|sahwikiquote        |1     |
|shnwiktionary       |1     |
|arcwiki             |1     |
|rwwiki              |1     |
|kowikinews          |1     |
|tlwiktionary        |1     |
|gdwiktionary        |1     |
|tlwikibooks         |1     |
|tiwiki              |1     |
|huwikiquote         |1     |
|swwiktionary        |1     |
|mgwiktionary        |1     |
|srnwiki             |1     |
|aywiki              |1     |
|zeawiki             |1     |
|awawiki             |1     |
|bewikimedia         |1     |
|dvwiki              |1     |
|sswiki              |1     |
|hifwiktionary       |1     |
|newwiki             |1     |
|pmswikisource       |1     |
|kawikiquote         |1     |
|guwikiquote         |1     |
|ltwikisource        |1     |
|xhwiki              |1     |
|extwiki             |1     |
|fiwikiversity       |1     |
|hywikiquote         |1     |
|donatewiki          |1     |
|ptwikimedia         |1     |
|lawikiquote         |1     |
|hiwikiquote         |1     |
|kbpwiki             |1     |
|siwiktionary        |1     |
|arwikibooks         |1     |
|tewikibooks         |1     |
|vecwikisource       |1     |
|fiwikimedia         |1     |
|hiwikiversity       |1     |
|sahwikisource       |1     |
|kowikiversity       |1     |
|amwikimedia         |1     |
|tewikiquote         |1     |
|lbewiki             |1     |
|kiwiki              |1     |
|liwikiquote         |1     |
|jawikiversity       |1     |
|iawiktionary        |1     |
|mrwiktionary        |1     |
|brwikimedia         |1     |
|rswikimedia         |1     |
|kowikibooks         |1     |
|bgwikiquote         |1     |
|svwikiversity       |1     |
|azwiktionary        |1     |
|ltwikibooks         |1     |
|eowikibooks         |1     |
|liwiktionary        |1     |
|dinwiki             |1     |
|mywiktionary        |1     |
|csbwiki             |1     |
|slwikibooks         |1     |
|slwiktionary        |1     |
|mwlwiki             |1     |
|svwikibooks         |1     |
|dawiktionary        |1     |
|dkwikimedia         |1     |
|trwikibooks         |1     |
|euwikibooks         |1     |
|miwiki              |1     |
|etwikibooks         |1     |
|nowikisource        |1     |
|omwiktionary        |1     |
|minwiktionary       |1     |
|klwiki              |1     |
|fiwikinews          |1     |
|nnwikiquote         |1     |
|amwiki              |1     |
+--------------------+------+

• Elitre subscribed.Apr 7 2021, 1:55 PM

Thank you so much! This task can be resolved.

When the actual election timeline is shared, we are likely to file a task about a precise calculation of eligible voters by home wiki (before the election) and a precise calculation of actual voters per home wiki (after the election). The motivation is to offer accurate participation per project, which will help these communities and the movement in general to better understand which communities are more and less involved in our governance processes, and take action for future elections.

I have no idea who could / should be involved in this task, and no matter what we would involve the Elections Committee and any volunteers involved in elections tech/data. I just wanted to leave it here in case someone is interested. :)

Ping @kzimmerman on the above comment - Let's synchronize on who does what :)

JAllemandou closed this task as Resolved.Apr 8 2021, 11:35 AM

JAllemandou claimed this task.

@JAllemandou @Qgil I think it makes sense for this kind of task to be handled by Product Analytics in the future.

@Niharika & @DannyH - on the product side, do requests related to Board elections fall under the umbrella of Trust & Safety? If so, a request like this would likely go to the data scientist supporting that team.

No worries, let me check first what the Elections Committee and other potential volunteers interested in elections tech can and are interested in providing.

@kzimmerman I would believe so.

@Qgil you and I should sync-up about how to handle these requests in the future. :)

Jony subscribed.May 4 2021, 4:00 PM

Xeno_WMF mentioned this in T287023: Sending two mass emails to eligible voters for the board elections 2021.Jul 20 2021, 4:04 PM

Produce a list of wiki projects ranked by number of eligible voters in Board electionsClosed, ResolvedPublicActions

Description

Related Objects

Event Timeline

Produce a list of wiki projects ranked by number of eligible voters in Board elections
Closed, ResolvedPublic
Actions