Mobile edits in 2020

Is there a list of different language versions of Wikipedia by number of edits from mobile?

Paraphrased from memory.

That was a question that piqued my interest in one of the Telegram channels. Since I am a statistics and data fan, I immediately started searching, but I couldn’t find the answer in the otherwise splendid stats.wikimedia.org. There are excellent statistics on page views from desktop versus mobile, but not edits.

Method

I was having a vague memory that I recently saw a similar query in Quarry. After some searching I found that Amir Aharoni already had doing something similar. I made some slight tweaks and had a version that could give you the edits for a full year. By just changing the language code I could then run the query over and over and collect the results in a table. My steam ran out after 136 languages and when the numbers were so small that the proportion varied wildly.

Table of mobile edits in 2020

Below is the table sorted by proportion of edits, if you want a sortable table, check it out on meta. Note that I am missing languages with a “-” in it (like zh-yue). Unfortunately my database skills couldn’t decode the error message. If someone figures out a fix, I’ll be happy to amend the table.

Language code	Mobile revisions	Total revisions	Mobile percentage
en	6645908	62369625	10.66%
es	1628512	9283780	17.54%
ja	1179981	5375370	21.95%
it	982182	7719894	12.72%
zh	855809	5866462	14.59%
fr	805308	12058227	6.68%
ko	750514	2822964	26.59%
fa	571736	2716408	21.05%
ru	520806	6841122	7.61%
pt	439006	2905382	15.11%
de	406647	10529048	3.86%
ar	383421	9835612	3.90%
id	334876	1302711	25.71%
he	282634	3190155	8.86%
vi	278095	6682191	4.16%
bn	225876	850517	26.56%
tr	184004	3156302	5.83%
pl	155298	3304388	4.70%
nl	140427	2427010	5.79%
th	131322	506742	25.91%
uk	115687	3468430	3.34%
hi	114280	601922	18.99%
el	96253	626224	15.37%
hu	91977	1277461	7.20%
az	82942	681065	12.18%
sv	80358	1561601	5.15%
ms	75365	272940	27.61%
cs	61461	1256223	4.89%
fi	55691	810251	6.87%
ro	49700	550028	9.04%
sr	40933	752157	5.44%
simple	40849	433851	9.42%
mr	39813	132041	30.15%
bg	36546	857347	4.26%
no	34440	976812	3.53%
da	30716	353663	8.69%
hr	30419	301791	10.08%
ta	28540	186236	15.32%
ca	28190	3282671	0.86%
ur	24759	267833	9.24%
ku	23709	85191	27.83%
ml	22039	167129	13.19%
uz	18094	72763	24.87%
sk	17748	167251	10.61%
hy	14933	888563	1.68%
te	14696	254212	5.78%
my	14199	131072	10.83%
ckb	12971	82267	15.77%
sq	10784	102595	10.51%
kn	9784	56504	17.32%
ne	9736	117723	8.27%
et	9162	259564	3.53%
lv	8702	183210	4.75%
as	8545	44219	19.32%
eu	8481	713073	1.19%
sl	7006	162451	4.31%
ga	6812	36553	18.64%
tl	6709	89644	7.48%
lt	6570	306661	2.14%
arz	6354	3189074	0.20%
km	6117	12299	49.74%
kk	5574	92434	6.03%
yi	5310	16063	33.06%
ka	5097	294008	1.73%
ps	5043	13408	37.61%
sh	4550	96378	4.72%
si	4384	21730	20.17%
eo	4331	267372	1.62%
gu	4258	45598	9.34%
gl	3850	310263	1.24%
mk	3725	468499	0.80%
bs	3588	158217	2.27%
sco	3556	65661	5.42%
so	3430	9083	37.76%
tg	3220	109721	2.93%
ha	3188	16904	18.86%
af	2959	248410	1.19%
be	2883	233933	1.23%
is	2859	38337	7.46%
yo	2419	15206	15.91%
ast	2414	457422	0.53%
or	2369	27917	8.49%
pa	2322	46689	4.97%
mn	2249	38954	5.77%
zu	1889	14535	13.00%
sw	1786	39205	4.56%
su	1553	9747	15.93%
ky	1509	12398	12.17%
an	1358	45731	2.97%
gom	1342	7031	19.09%
tk	1312	3266	40.17%
la	1306	101109	1.29%
jv	1188	36192	3.28%
mzn	1144	2754	41.54%
oc	1131	85125	1.33%
cy	1120	1324016	0.08%
als	947	36753	2.58%
am	942	2794	33.72%
nn	940	100996	0.93%
lij	880	20558	4.28%
sah	763	12756	5.98%
tcy	728	10730	6.78%
ceb	689	780112	0.09%
tt	617	445126	0.14%
lo	568	4252	13.36%
min	503	39186	1.28%
lb	484	72465	0.67%
arc	460	1152	39.93%
war	434	17266	2.51%
ace	408	4373	9.33%
mai	390	4937	7.90%
br	337	31306	1.08%
wuu	308	23367	1.32%
bar	306	21577	1.42%
hif	296	5216	5.67%
ba	284	70974	0.40%
fy	274	46048	0.60%
bcl	272	12752	2.13%
bjn	201	3565	5.64%
ltg	190	936	20.30%
nds	107	69176	0.15%
qu	103	4629	2.23%
gan	94	559	16.82%
cv	88	26954	0.33%
cdo	58	1306	4.44%
tet	54	814	6.63%
mwl	52	914	5.69%
se	41	4041	1.01%
iu	35	438	7.99%
myv	30	9845	0.30%
ady	26	970	2.68%
dz	21	216	9.72%
ve	16	303	5.28%
srn	13	247	5.26%
pih	11	276	3.99%
ee	7	164	4.27%

Future work

I would love to see this kind of data in stats.wikimedia.org. If not, finding a way to automize this would also be good, both for completing this dataset with all available languages, but also to do a time series back as far as we have data. However, I am unlikely to be able to do this by myself so if anyone wants to collaborate on it, I would be very happy.