Number of administrators on Wikimedia wikis

This notebook lists number of administrators (both temporary and permanent) on all Wikimedia wikis.

The following users are excluded:

• system accounts,
• administrators who are also a member of the bot group

from wmfdata import mariadb
import pandas as pd

pd.set_option('display.max_rows', None)

You are using wmfdata v1.3.2, but v1.3.3 is available.

To update, run `pip install --upgrade git+https://github.com/wikimedia/wmfdata-python.git@release --ignore-installed`.

To see the changes, refer to https://github.com/wikimedia/wmfdata-python/blob/release/CHANGELOG.md

private_wikis = open('/srv/mediawiki-config/dblists/private.dblist').read().split('\n')
closed_wikis = open('/srv/mediawiki-config/dblists/closed.dblist').read().split('\n')
growth_wikis = open('/srv/mediawiki-config/dblists/growthexperiments.dblist').read().split('\n')

%%capture
def get_projects(family='wikipedia'):
    dblist = open('/srv/mediawiki-config/dblists/%s.dblist' % family).read().split('\n')
    dblist.pop()
    dblist.pop(0)
    
    res = []
    for project in dblist:
        if project in private_wikis or project in closed_wikis:
            continue
        res.append(project)
    return res

def get_data_for_projects(projects=[]):
    data = {
        'Project': [],
        'Permanent admins': [],
        'Temporary admins': [],
        'Total admins': [],
        'Interface admins': [],
        'Bureaucrats': [],
    }
    for dbname in projects:
        conn = mariadb.connect(dbname)
        with conn.cursor() as cur:
            cur.execute('''
            SELECT
                ug_expiry IS NULL AS permanent,
                ug_group,
                COUNT(*)
            FROM user_groups
            JOIN user ON user_id=ug_user
            WHERE
                ug_group IN ("sysop", "interface-admin", "bureaucrat") AND
                
                -- Ignore system accounts
                user_token NOT LIKE "%INVALID%" AND
                
                -- Ignore bots
                ug_user NOT IN (
                    SELECT ug_user FROM user_groups WHERE ug_group="bot"
                )
            GROUP BY
                ug_expiry IS NULL,
                ug_group
            ''')
            tmp = cur.fetchall()
        
        data['Project'].append(dbname)
        data['Total admins'].append(sum([x[2] if x[1] == 'sysop' else 0 for x in tmp]))
        group_data = {
            'sysop': {
                'permanent': 0,
                'temporary': 0
            },
            'bureaucrat': {
                'permanent': 0,
                'temporary': 0
            },
            'interface-admin': {
                'permanent': 0,
                'temporary': 0
            }
        }
        for row in tmp:
            if row[0] == 1:
                group_data[row[1]]['permanent'] = row[2]
            else:
                group_data[row[1]]['temporary'] = row[2]
        data['Permanent admins'].append(group_data['sysop']['permanent'])
        data['Temporary admins'].append(group_data['sysop']['temporary'])
        data['Interface admins'].append(sum([x[2] if x[1] == 'interface-admin' else 0 for x in tmp]))
        data['Bureaucrats'].append(sum([x[2] if x[1] == 'bureaucrat' else 0 for x in tmp]))
    return pd.DataFrame(data)

def get_data(family):
    df = pd.DataFrame(get_data_for_projects(get_projects(family)))
    df.to_csv('/home/urbanecm/tmp/sysops-per-wiki/%s.tsv' % family, sep='\t', index=False)
    return df

Wikipedias

get_data('wikipedia')

	Project	Permanent admins	Temporary admins	Total admins	Interface admins	Bureaucrats
0	abwiki	0	1	1	0	0
1	acewiki	1	1	2	1	0
2	adywiki	0	0	0	0	0
3	afwiki	15	0	15	1	4
4	akwiki	0	0	0	0	0
5	alswiki	8	0	8	1	2
6	altwiki	1	1	2	1	0
7	amiwiki	0	0	0	0	0
8	amwiki	1	0	1	0	0
9	angwiki	1	0	1	0	0
10	anwiki	5	0	5	0	2
11	arcwiki	1	0	1	0	0
12	arwiki	26	0	26	7	6
13	arywiki	0	3	3	2	0
14	arzwiki	5	1	6	0	0
15	astwiki	10	0	10	2	3
16	aswiki	3	1	4	3	0
17	atjwiki	0	3	3	0	0
18	avkwiki	5	0	5	0	0
19	avwiki	0	1	1	1	0
20	awawiki	0	0	0	0	0
21	aywiki	0	0	0	0	0
22	azbwiki	4	0	4	2	0
23	azwiki	16	0	16	2	3
24	banwiki	2	0	2	1	0
25	barwiki	2	0	2	2	0
26	bat_smgwiki	4	0	4	1	2
27	bawiki	6	0	6	2	1
28	bclwiki	0	2	2	0	0
29	be_x_oldwiki	3	0	3	1	1
30	bewiki	10	0	10	2	1
31	bgwiki	23	0	23	1	6
32	bhwiki	1	0	1	1	0
33	biwiki	0	1	1	0	0
34	bjnwiki	1	0	1	1	0
35	blkwiki	0	1	1	1	0
36	bmwiki	0	0	0	0	0
37	bnwiki	12	0	12	2	2
38	bowiki	0	0	0	0	0
39	bpywiki	1	1	2	0	0
40	brwiki	5	0	5	3	0
41	bswiki	7	0	7	7	2
42	bugwiki	0	0	0	0	0
43	bxrwiki	0	0	0	0	0
44	cawiki	28	0	28	4	2
45	cbk_zamwiki	1	0	1	0	0
46	cdowiki	3	0	3	0	2
47	cebwiki	5	0	5	0	2
48	cewiki	2	0	2	1	0
49	chrwiki	0	0	0	0	0
50	chwiki	0	0	0	0	0
51	chywiki	0	0	0	0	0
52	ckbwiki	6	0	6	3	0
53	cowiki	0	1	1	0	0
54	crhwiki	1	0	1	0	0
55	crwiki	1	0	1	0	0
56	csbwiki	2	0	2	0	1
57	cswiki	31	0	31	4	4
58	cuwiki	1	0	1	0	0
59	cvwiki	1	0	1	0	0
60	cywiki	15	0	15	2	2
61	dagwiki	0	3	3	1	0
62	dawiki	24	0	24	2	2
63	dewiki	178	8	186	21	4
64	dinwiki	0	0	0	0	0
65	diqwiki	2	0	2	0	0
66	dsbwiki	0	0	0	0	0
67	dtywiki	1	0	1	0	0
68	dvwiki	1	1	2	1	1
69	dzwiki	0	0	0	0	0
70	eewiki	1	1	2	0	0
71	elwiki	21	0	21	2	6
72	emlwiki	2	0	2	0	0
73	enwiki	1022	0	1022	9	21
74	eowiki	14	0	14	2	2
75	eswiki	62	0	62	4	62
76	etwiki	33	0	33	4	2
77	euwiki	9	0	9	2	3
78	extwiki	0	0	0	0	0
79	fawiki	33	0	33	8	7
80	ffwiki	0	1	1	0	0
81	fiu_vrowiki	3	0	3	1	1
82	fiwiki	31	0	31	11	3
83	fjwiki	0	0	0	0	0
84	fowiki	2	0	2	0	2
85	frpwiki	1	0	1	1	1
86	frrwiki	4	0	4	2	2
87	frwiki	156	0	156	15	7
88	furwiki	1	0	1	0	0
89	fywiki	7	0	7	0	3
90	gagwiki	0	0	0	0	0
91	ganwiki	0	0	0	0	0
92	gawiki	6	0	6	1	3
93	gcrwiki	0	0	0	0	0
94	gdwiki	5	0	5	0	4
95	glkwiki	2	0	2	0	0
96	glwiki	7	0	7	2	2
97	gnwiki	1	0	1	0	0
98	gomwiki	1	1	2	1	0
99	gorwiki	0	1	1	1	0
100	gotwiki	0	0	0	0	0
101	guwiki	2	0	2	1	0
102	guwwiki	0	2	2	0	0
103	gvwiki	2	0	2	0	1
104	hakwiki	0	0	0	0	0
105	hawiki	3	1	4	0	0
106	hawwiki	0	0	0	0	0
107	hewiki	0	30	30	17	3
108	hifwiki	1	0	1	0	0
109	hiwiki	4	0	4	1	0
110	hrwiki	10	0	10	2	4
111	hsbwiki	3	0	3	0	0
112	htwiki	0	1	1	0	0
113	huwiki	23	0	23	3	7
114	hywiki	9	0	9	2	0
115	hywwiki	2	2	4	0	0
116	iawiki	5	0	5	0	2
117	idwiki	43	0	43	5	5
118	iewiki	0	2	2	0	0
119	igwiki	3	1	4	0	0
120	ikwiki	0	1	1	0	0
121	ilowiki	1	0	1	1	0
122	inhwiki	1	0	1	1	0
123	iowiki	4	0	4	0	0
124	iswiki	17	0	17	2	17
125	itwiki	122	0	122	7	6
126	iuwiki	1	0	1	0	0
127	jamwiki	0	0	0	0	0
128	jawiki	40	0	40	11	4
129	jbowiki	1	0	1	0	1
130	jvwiki	3	0	3	0	1
131	kaawiki	0	1	1	0	0
132	kabwiki	0	0	0	0	0
133	kawiki	5	0	5	5	2
134	kbdwiki	0	0	0	0	0
135	kbpwiki	0	0	0	0	0
136	kcgwiki	0	1	1	0	0
137	kgwiki	0	0	0	0	0
138	kiwiki	0	0	0	0	0
139	kkwiki	14	0	14	1	2
140	klwiki	1	1	2	0	0
141	kmwiki	4	1	5	0	2
142	knwiki	3	0	3	1	1
143	koiwiki	0	0	0	0	0
144	kowiki	26	0	26	4	6
145	krcwiki	1	0	1	0	1
146	kshwiki	2	0	2	0	1
147	kswiki	0	1	1	1	0
148	kuwiki	2	0	2	2	0
149	kvwiki	0	0	0	0	0
150	kwwiki	0	1	1	0	0
151	kywiki	2	1	3	0	0
152	ladwiki	4	0	4	0	4
153	lawiki	20	0	20	1	2
154	lbewiki	0	1	1	1	0
155	lbwiki	4	0	4	2	1
156	lezwiki	2	0	2	1	0
157	lfnwiki	0	0	0	0	0
158	lgwiki	0	0	0	0	0
159	lijwiki	6	0	6	0	0
160	liwiki	6	0	6	0	2
161	lldwiki	0	2	2	0	0
162	lmowiki	4	0	4	0	1
163	lnwiki	2	0	2	0	0
164	lowiki	0	0	0	0	0
165	ltgwiki	0	0	0	0	0
166	ltwiki	9	0	9	3	1
167	lvwiki	12	0	12	3	3
168	madwiki	0	0	0	0	0
169	maiwiki	3	1	4	1	0
170	map_bmswiki	0	0	0	0	0
171	mdfwiki	1	0	1	0	0
172	mgwiki	2	0	2	0	0
173	mhrwiki	0	0	0	0	0
174	minwiki	4	0	4	0	0
175	miwiki	1	0	1	0	1
176	mkwiki	11	0	11	4	2
177	mlwiki	14	0	14	3	2
178	mniwiki	0	1	1	1	0
179	mnwiki	2	0	2	0	0
180	mnwwiki	0	1	1	0	0
181	mrjwiki	0	0	0	0	0
182	mrwiki	11	0	11	1	1
183	mswiki	14	0	14	2	3
184	mtwiki	4	0	4	1	3
185	mwlwiki	0	0	0	0	0
186	myvwiki	2	1	3	2	0
187	mywiki	3	0	3	1	1
188	mznwiki	2	0	2	0	0
189	nahwiki	2	0	2	0	0
190	napwiki	2	0	2	0	0
191	nawiki	0	0	0	0	0
192	nds_nlwiki	5	0	5	1	3
193	ndswiki	3	0	3	1	1
194	newiki	3	0	3	2	1
195	newwiki	1	0	1	0	0
196	niawiki	0	2	2	1	0
197	nlwiki	35	0	35	5	3
198	nnwiki	13	0	13	3	2
199	novwiki	1	1	2	0	0
200	nowiki	44	0	44	3	5
201	nqowiki	0	0	0	0	0
202	nrmwiki	0	0	0	0	0
203	nsowiki	0	0	0	0	0
204	nvwiki	1	0	1	0	0
205	nywiki	0	1	1	0	0
206	ocwiki	3	0	3	0	1
207	olowiki	0	1	1	0	0
208	omwiki	0	0	0	0	0
209	orwiki	5	0	5	1	0
210	oswiki	2	0	2	0	0
211	pagwiki	0	0	0	0	0
212	pamwiki	1	0	1	0	0
213	papwiki	1	0	1	0	0
214	pawiki	8	0	8	1	0
215	pcdwiki	1	0	1	0	0
216	pcmwiki	0	2	2	0	0
217	pdcwiki	0	0	0	0	0
218	pflwiki	3	0	3	0	0
219	pihwiki	0	0	0	0	0
220	piwiki	0	1	1	0	0
221	plwiki	97	0	97	11	3
222	pmswiki	3	0	3	0	1
223	pnbwiki	1	0	1	1	0
224	pntwiki	0	0	0	0	0
225	pswiki	0	0	0	0	0
226	ptwiki	52	0	52	4	9
227	pwnwiki	0	0	0	0	0
228	quwiki	1	0	1	0	0
229	rmwiki	2	0	2	0	0
230	rmywiki	0	0	0	0	0
231	rnwiki	0	0	0	0	0
232	roa_rupwiki	0	0	0	0	0
233	roa_tarawiki	1	0	1	0	0
234	rowiki	15	0	15	2	0
235	ruewiki	0	0	0	0	0
236	ruwiki	71	0	71	7	4
237	rwwiki	0	0	0	0	0
238	sahwiki	2	0	2	0	1
239	satwiki	2	1	3	0	0
240	sawiki	3	0	3	0	0
241	scnwiki	4	0	4	0	2
242	scowiki	2	1	3	0	0
243	scwiki	3	0	3	1	0
244	sdwiki	3	0	3	2	0
245	sewiki	5	0	5	0	3
246	sgwiki	0	0	0	0	0
247	shiwiki	0	2	2	0	0
248	shnwiki	0	1	1	1	0
249	shwiki	11	0	11	3	3
250	simplewiki	17	0	17	0	4
251	siwiki	2	0	2	0	0
252	skrwiki	0	1	1	0	0
253	skwiki	9	0	9	0	1
254	slwiki	21	0	21	1	6
255	smnwiki	0	5	5	0	0
256	smwiki	0	0	0	0	0
257	snwiki	0	0	0	0	0
258	sowiki	0	0	0	0	0
259	sqwiki	9	0	9	2	4
260	srnwiki	0	0	0	0	0
261	srwiki	17	0	17	18	3
262	sswiki	2	0	2	0	0
263	stqwiki	3	1	4	1	0
264	stwiki	0	0	0	0	0
265	suwiki	6	0	6	1	1
266	svwiki	65	0	65	5	4
267	swwiki	13	0	13	1	2
268	szlwiki	1	1	2	0	0
269	szywiki	0	0	0	0	0
270	tawiki	30	0	30	1	4
271	taywiki	0	0	0	0	0
272	tcywiki	1	0	1	1	0
273	test2wiki	115	0	115	8	53
274	testwiki	283	8	291	17	64
275	tetwiki	1	0	1	0	0
276	tewiki	12	0	12	1	3
277	tgwiki	5	0	5	0	0
278	thwiki	14	0	14	6	3
279	tiwiki	0	1	1	1	0
280	tkwiki	0	2	2	0	0
281	tlwiki	9	0	9	2	4
282	tnwiki	0	1	1	0	0
283	towiki	1	0	1	0	0
284	tpiwiki	0	1	1	0	0
285	trvwiki	0	0	0	0	0
286	trwiki	23	0	23	9	6
287	tswiki	1	0	1	0	0
288	ttwiki	4	0	4	1	0
289	tumwiki	0	1	1	1	0
290	twwiki	0	1	1	0	0
291	tyvwiki	0	0	0	0	0
292	tywiki	0	0	0	0	0
293	udmwiki	3	0	3	2	1
294	ugwiki	0	0	0	0	0
295	ukwiki	44	0	44	6	6
296	urwiki	9	0	9	3	3
297	uzwiki	18	0	18	3	3
298	vecwiki	3	0	3	3	2
299	vepwiki	0	0	0	0	0
300	vewiki	0	0	0	0	0
301	viwiki	19	0	19	5	3
302	vlswiki	4	0	4	0	1
303	vowiki	0	1	1	0	0
304	warwiki	2	0	2	0	0
305	wawiki	2	0	2	1	1
306	wowiki	1	0	1	0	0
307	wuuwiki	3	0	3	0	1
308	xalwiki	0	0	0	0	0
309	xhwiki	0	0	0	0	0
310	xmfwiki	2	0	2	0	0
311	yiwiki	2	0	2	0	0
312	yowiki	2	0	2	0	0
313	zawiki	0	0	0	0	0
314	zeawiki	2	0	2	0	1
315	zh_classicalwiki	3	2	5	4	0
316	zh_min_nanwiki	4	0	4	0	3
317	zh_yuewiki	12	0	12	0	2
318	zhwiki	62	0	62	14	7
319	zuwiki	0	0	0	0	0

Wiktionaries

get_data('wiktionary')

	Project	Permanent admins	Temporary admins	Total admins	Interface admins	Bureaucrats
0	afwiktionary	1	0	1	0	1
1	amwiktionary	0	0	0	0	0
2	angwiktionary	0	0	0	0	0
3	anwiktionary	1	0	1	0	1
4	arwiktionary	3	0	3	1	0
5	astwiktionary	0	0	0	0	0
6	aywiktionary	0	0	0	0	0
7	azwiktionary	0	1	1	0	0
8	bclwiktionary	0	1	1	1	0
9	bewiktionary	1	0	1	0	0
10	bgwiktionary	3	0	3	0	3
11	bjnwiktionary	0	0	0	0	0
12	bnwiktionary	1	1	2	1	0
13	brwiktionary	0	0	0	0	0
14	bswiktionary	3	0	3	0	0
15	cawiktionary	3	0	3	2	1
16	chrwiktionary	0	0	0	0	0
17	cowiktionary	0	0	0	0	0
18	csbwiktionary	0	0	0	0	0
19	cswiktionary	3	0	3	0	2
20	cywiktionary	0	0	0	0	0
21	dawiktionary	2	0	2	0	0
22	dewiktionary	15	0	15	2	2
23	diqwiktionary	0	1	1	0	0
24	dvwiktionary	0	0	0	0	0
25	elwiktionary	8	0	8	1	3
26	enwiktionary	107	0	107	16	8
27	eowiktionary	0	0	0	0	0
28	eswiktionary	7	0	7	2	7
29	etwiktionary	4	0	4	1	1
30	euwiktionary	1	0	1	0	0
31	fawiktionary	1	1	2	1	0
32	fiwiktionary	8	0	8	8	1
33	fjwiktionary	0	0	0	0	0
34	fowiktionary	0	0	0	0	0
35	frwiktionary	31	0	31	29	4
36	fywiktionary	0	0	0	0	0
37	gawiktionary	1	0	1	0	0
38	gdwiktionary	0	0	0	0	0
39	glwiktionary	1	0	1	0	0
40	gnwiktionary	0	0	0	0	0
41	gomwiktionary	0	0	0	0	0
42	guwiktionary	0	1	1	0	0
43	guwwiktionary	0	1	1	0	0
44	gvwiktionary	0	0	0	0	0
45	hawiktionary	0	1	1	0	0
46	hewiktionary	6	0	6	3	3
47	hifwiktionary	0	0	0	0	0
48	hiwiktionary	0	0	0	0	0
49	hrwiktionary	1	0	1	0	0
50	hsbwiktionary	0	0	0	0	0
51	huwiktionary	3	0	3	0	1
52	hywiktionary	1	0	1	0	0
53	iawiktionary	0	0	0	0	0
54	idwiktionary	4	0	4	1	1
55	iewiktionary	0	0	0	0	0
56	iowiktionary	1	0	1	0	0
57	iswiktionary	2	0	2	1	2
58	itwiktionary	4	0	4	3	1
59	iuwiktionary	0	0	0	0	0
60	jawiktionary	4	0	4	0	2
61	jbowiktionary	0	0	0	0	0
62	jvwiktionary	0	1	1	0	0
63	kawiktionary	1	0	1	1	0
64	kkwiktionary	0	0	0	0	0
65	klwiktionary	0	0	0	0	0
66	kmwiktionary	0	1	1	0	0
67	knwiktionary	0	0	0	0	0
68	kowiktionary	0	0	0	0	0
69	kswiktionary	0	1	1	0	0
70	kuwiktionary	5	0	5	1	0
71	kwwiktionary	0	0	0	0	0
72	kywiktionary	0	0	0	0	0
73	lawiktionary	0	0	0	0	0
74	lbwiktionary	0	1	1	0	0
75	liwiktionary	2	0	2	1	1
76	lmowiktionary	0	1	1	0	0
77	lnwiktionary	0	0	0	0	0
78	lowiktionary	0	0	0	0	0
79	ltwiktionary	4	0	4	3	2
80	lvwiktionary	0	0	0	0	0
81	mgwiktionary	1	0	1	0	0
82	minwiktionary	1	0	1	0	0
83	miwiktionary	0	0	0	0	0
84	mkwiktionary	1	0	1	0	0
85	mlwiktionary	4	0	4	1	1
86	mniwiktionary	0	1	1	1	0
87	mnwiktionary	0	0	0	0	0
88	mnwwiktionary	0	0	0	0	0
89	mrwiktionary	0	1	1	1	0
90	mswiktionary	1	0	1	0	0
91	mtwiktionary	0	0	0	0	0
92	mywiktionary	0	1	1	1	0
93	nahwiktionary	0	0	0	0	0
94	nawiktionary	0	0	0	0	0
95	ndswiktionary	1	0	1	0	0
96	newiktionary	0	0	0	0	0
97	niawiktionary	0	2	2	0	0
98	nlwiktionary	10	0	10	3	5
99	nnwiktionary	1	0	1	0	1
100	nowiktionary	4	0	4	1	2
101	ocwiktionary	1	0	1	0	0
102	omwiktionary	0	0	0	0	0
103	orwiktionary	1	0	1	0	0
104	pawiktionary	0	0	0	0	0
105	plwiktionary	14	0	14	3	1
106	pnbwiktionary	0	0	0	0	0
107	pswiktionary	0	0	0	0	0
108	ptwiktionary	4	0	4	1	2
109	quwiktionary	0	0	0	0	0
110	roa_rupwiktionary	0	0	0	0	0
111	rowiktionary	2	0	2	0	2
112	ruwiktionary	13	0	13	3	3
113	rwwiktionary	0	0	0	0	0
114	sawiktionary	0	0	0	0	0
115	scnwiktionary	1	0	1	0	1
116	sdwiktionary	0	0	0	0	0
117	sgwiktionary	0	0	0	0	0
118	shnwiktionary	0	1	1	1	0
119	shwiktionary	1	1	2	1	0
120	shywiktionary	0	0	0	0	0
121	simplewiktionary	2	0	2	0	2
122	siwiktionary	0	1	1	0	0
123	skrwiktionary	0	1	1	0	0
124	skwiktionary	3	0	3	2	0
125	slwiktionary	1	0	1	0	0
126	smwiktionary	0	0	0	0	0
127	sowiktionary	0	0	0	0	0
128	sqwiktionary	0	0	0	0	0
129	srwiktionary	3	0	3	4	2
130	sswiktionary	1	0	1	0	0
131	stwiktionary	0	0	0	0	0
132	suwiktionary	0	0	0	0	0
133	svwiktionary	13	0	13	1	2
134	swwiktionary	0	1	1	0	0
135	tawiktionary	6	0	6	1	2
136	tewiktionary	2	0	2	0	0
137	tgwiktionary	0	0	0	0	0
138	thwiktionary	3	0	3	1	0
139	tiwiktionary	0	0	0	0	0
140	tkwiktionary	0	0	0	0	0
141	tlwiktionary	0	0	0	0	0
142	tnwiktionary	0	1	1	0	0
143	tpiwiktionary	0	0	0	0	0
144	trwiktionary	3	0	3	2	0
145	tswiktionary	0	0	0	0	0
146	ttwiktionary	0	0	0	0	0
147	ugwiktionary	0	0	0	0	0
148	ukwiktionary	3	0	3	1	1
149	urwiktionary	0	0	0	0	0
150	uzwiktionary	0	1	1	0	0
151	vecwiktionary	2	0	2	1	0
152	viwiktionary	9	0	9	2	2
153	vowiktionary	0	0	0	0	0
154	wawiktionary	1	1	2	1	0
155	wowiktionary	1	0	1	0	0
156	yiwiktionary	0	0	0	0	0
157	yuewiktionary	0	0	0	0	0
158	zh_min_nanwiktionary	0	0	0	0	0
159	zhwiktionary	6	2	8	2	0
160	zuwiktionary	0	0	0	0	0

Wikiquotes

get_data('wikiquote')

	Project	Permanent admins	Temporary admins	Total admins	Interface admins	Bureaucrats
0	afwikiquote	0	0	0	0	0
1	arwikiquote	3	0	3	0	0
2	azwikiquote	4	0	4	1	0
3	bewikiquote	0	0	0	0	0
4	bgwikiquote	4	0	4	1	4
5	brwikiquote	0	1	1	1	0
6	bswikiquote	0	0	0	0	0
7	cawikiquote	2	0	2	2	0
8	cswikiquote	2	0	2	2	1
9	cywikiquote	0	0	0	0	0
10	dawikiquote	2	0	2	0	0
11	dewikiquote	5	0	5	0	2
12	elwikiquote	0	0	0	0	0
13	enwikiquote	15	0	15	1	3
14	eowikiquote	1	1	2	0	0
15	eswikiquote	4	0	4	0	2
16	etwikiquote	0	1	1	0	0
17	euwikiquote	0	0	0	0	0
18	fawikiquote	2	1	3	0	2
19	fiwikiquote	3	0	3	0	1
20	frwikiquote	5	0	5	3	1
21	glwikiquote	0	0	0	0	0
22	guwikiquote	0	0	0	0	0
23	hewikiquote	2	0	2	0	1
24	hiwikiquote	0	0	0	0	0
25	hrwikiquote	1	0	1	0	0
26	huwikiquote	2	0	2	0	1
27	hywikiquote	0	0	0	0	0
28	idwikiquote	1	0	1	0	0
29	iswikiquote	0	0	0	0	0
30	itwikiquote	10	0	10	2	10
31	jawikiquote	1	0	1	0	1
32	kawikiquote	0	0	0	0	0
33	knwikiquote	0	0	0	0	0
34	kowikiquote	1	0	1	0	0
35	kuwikiquote	0	0	0	0	0
36	kywikiquote	0	0	0	0	0
37	lawikiquote	0	0	0	0	0
38	liwikiquote	1	0	1	0	0
39	ltwikiquote	1	0	1	0	0
40	mlwikiquote	1	0	1	0	0
41	mrwikiquote	0	0	0	0	0
42	nlwikiquote	3	0	3	0	3
43	nnwikiquote	1	0	1	0	1
44	nowikiquote	1	0	1	0	1
45	plwikiquote	7	0	7	2	2
46	ptwikiquote	2	0	2	0	1
47	rowikiquote	0	1	1	0	0
48	ruwikiquote	4	0	4	2	2
49	sahwikiquote	0	0	0	0	0
50	sawikiquote	0	0	0	0	0
51	skwikiquote	1	0	1	0	1
52	slwikiquote	0	0	0	0	0
53	sqwikiquote	0	1	1	1	0
54	srwikiquote	4	0	4	3	4
55	suwikiquote	0	0	0	0	0
56	svwikiquote	1	0	1	0	1
57	tawikiquote	0	0	0	0	0
58	tewikiquote	0	0	0	0	0
59	thwikiquote	1	0	1	1	0
60	trwikiquote	4	0	4	2	0
61	ukwikiquote	5	0	5	2	1
62	urwikiquote	1	0	1	0	0
63	uzwikiquote	0	0	0	0	0
64	viwikiquote	0	0	0	0	0
65	wowikiquote	0	0	0	0	0
66	zhwikiquote	2	1	3	1	0

Wikibooks

get_data('wikibooks')

	Project	Permanent admins	Temporary admins	Total admins	Interface admins	Bureaucrats
0	afwikibooks	0	0	0	0	0
1	arwikibooks	4	1	5	0	0
2	azwikibooks	1	0	1	0	0
3	bawikibooks	0	0	0	0	0
4	bewikibooks	0	0	0	0	0
5	bgwikibooks	0	0	0	0	0
6	bnwikibooks	0	1	1	1	0
7	bswikibooks	0	0	0	0	0
8	cawikibooks	1	0	1	1	0
9	cswikibooks	3	0	3	3	2
10	cvwikibooks	0	0	0	0	0
11	cywikibooks	0	0	0	0	0
12	dawikibooks	0	0	0	0	0
13	dewikibooks	7	0	7	1	0
14	elwikibooks	0	0	0	0	0
15	enwikibooks	9	0	9	2	1
16	eowikibooks	1	0	1	0	0
17	eswikibooks	9	0	9	0	9
18	etwikibooks	0	1	1	0	0
19	euwikibooks	0	0	0	0	0
20	fawikibooks	1	1	2	0	0
21	fiwikibooks	3	0	3	0	0
22	frwikibooks	4	0	4	7	2
23	fywikibooks	0	0	0	0	0
24	glwikibooks	0	0	0	0	0
25	hewikibooks	5	0	5	1	1
26	hiwikibooks	0	1	1	0	0
27	hrwikibooks	2	0	2	1	1
28	huwikibooks	1	0	1	0	1
29	hywikibooks	0	0	0	0	0
30	iawikibooks	0	0	0	0	0
31	idwikibooks	3	0	3	0	0
32	iswikibooks	1	0	1	0	0
33	itwikibooks	3	0	3	3	1
34	jawikibooks	3	0	3	0	2
35	kawikibooks	0	0	0	0	0
36	kkwikibooks	0	0	0	0	0
37	kmwikibooks	0	0	0	0	0
38	kowikibooks	1	0	1	0	0
39	kuwikibooks	0	0	0	0	0
40	kywikibooks	0	0	0	0	0
41	lawikibooks	0	0	0	0	0
42	liwikibooks	0	0	0	0	0
43	ltwikibooks	0	0	0	0	0
44	mgwikibooks	0	0	0	0	0
45	mkwikibooks	0	0	0	0	0
46	mlwikibooks	0	0	0	0	0
47	mrwikibooks	0	1	1	1	0
48	mswikibooks	1	0	1	0	0
49	newikibooks	0	0	0	0	0
50	nlwikibooks	9	0	9	0	3
51	nowikibooks	0	0	0	0	0
52	ocwikibooks	0	0	0	0	0
53	pawikibooks	0	0	0	0	0
54	plwikibooks	2	0	2	1	0
55	ptwikibooks	2	0	2	1	1
56	rowikibooks	1	0	1	0	0
57	ruwikibooks	1	1	2	0	0
58	sawikibooks	0	0	0	0	0
59	siwikibooks	0	1	1	0	0
60	skwikibooks	2	0	2	0	1
61	slwikibooks	2	0	2	0	0
62	sqwikibooks	0	0	0	0	0
63	srwikibooks	4	0	4	2	3
64	svwikibooks	3	0	3	0	0
65	tawikibooks	0	0	0	0	0
66	tewikibooks	0	0	0	0	0
67	tgwikibooks	0	0	0	0	0
68	thwikibooks	2	0	2	2	0
69	tlwikibooks	0	0	0	0	0
70	trwikibooks	1	0	1	0	0
71	ttwikibooks	0	0	0	0	0
72	ukwikibooks	2	1	3	0	0
73	urwikibooks	0	0	0	0	0
74	viwikibooks	1	1	2	2	0
75	zhwikibooks	6	0	6	1	0

Wikisources

get_data('wikisource')

	Project	Permanent admins	Temporary admins	Total admins	Interface admins	Bureaucrats
0	arwikisource	8	0	8	1	1
1	aswikisource	0	1	1	1	0
2	azwikisource	1	0	1	2	0
3	banwikisource	0	0	0	0	0
4	bewikisource	1	1	2	0	0
5	bgwikisource	0	2	2	0	0
6	bnwikisource	3	0	3	2	0
7	brwikisource	2	0	2	0	0
8	bswikisource	0	0	0	0	0
9	cawikisource	2	0	2	2	1
10	cswikisource	3	0	3	3	2
11	cywikisource	2	0	2	0	0
12	dawikisource	1	0	1	0	0
13	dewikisource	15	0	15	2	2
14	elwikisource	5	0	5	2	2
15	enwikisource	21	0	21	2	3
16	eowikisource	0	1	1	1	0
17	eswikisource	7	0	7	3	2
18	etwikisource	1	0	1	0	0
19	euwikisource	0	0	0	0	0
20	fawikisource	2	1	3	1	0
21	fiwikisource	3	0	3	2	1
22	fowikisource	0	0	0	0	0
23	frwikisource	16	0	16	4	2
24	glwikisource	3	0	3	1	1
25	guwikisource	1	0	1	0	0
26	hewikisource	13	0	13	4	4
27	hiwikisource	3	0	3	3	0
28	hrwikisource	3	0	3	0	2
29	huwikisource	3	0	3	0	1
30	hywikisource	2	0	2	0	0
31	idwikisource	4	0	4	1	1
32	iswikisource	0	0	0	0	0
33	itwikisource	8	0	8	2	2
34	jawikisource	3	0	3	1	1
35	jvwikisource	0	1	1	0	0
36	knwikisource	1	0	1	0	0
37	kowikisource	2	0	2	0	0
38	lawikisource	6	0	6	1	6
39	lijwikisource	0	0	0	0	0
40	liwikisource	0	0	0	0	0
41	ltwikisource	1	1	2	0	0
42	mkwikisource	1	0	1	0	0
43	mlwikisource	3	0	3	0	1
44	mrwikisource	1	0	1	1	0
45	napwikisource	0	2	2	1	0
46	nlwikisource	1	0	1	0	0
47	nowikisource	1	0	1	0	0
48	orwikisource	0	1	1	1	0
49	pawikisource	5	0	5	3	1
50	plwikisource	14	0	14	4	2
51	pmswikisource	0	0	0	0	0
52	ptwikisource	1	0	1	0	0
53	rowikisource	0	2	2	0	0
54	ruwikisource	4	0	4	3	1
55	sahwikisource	0	0	0	0	0
56	sawikisource	2	0	2	1	0
57	skwikisource	1	0	1	0	1
58	slwikisource	3	0	3	0	1
59	srwikisource	3	0	3	3	3
60	svwikisource	3	0	3	0	2
61	tawikisource	3	0	3	1	0
62	tewikisource	4	0	4	1	0
63	thwikisource	1	1	2	2	0
64	trwikisource	2	0	2	1	0
65	ukwikisource	5	0	5	3	1
66	vecwikisource	1	0	1	1	1
67	viwikisource	2	0	2	2	0
68	wawikisource	0	1	1	1	0
69	yiwikisource	0	0	0	0	0
70	zh_min_nanwikisource	0	0	0	0	0
71	zhwikisource	6	0	6	0	0

Wikinews

get_data('wikinews')

	Project	Permanent admins	Temporary admins	Total admins	Interface admins	Bureaucrats
0	arwikinews	3	1	4	0	0
1	bswikinews	0	0	0	0	0
2	cawikinews	2	0	2	1	1
3	cswikinews	0	1	1	1	0
4	dewikinews	4	0	4	0	1
5	elwikinews	0	0	0	0	0
6	enwikinews	17	0	17	1	4
7	eowikinews	0	0	0	0	0
8	eswikinews	10	0	10	4	10
9	fawikinews	1	0	1	0	0
10	fiwikinews	0	0	0	0	0
11	frwikinews	11	0	11	4	2
12	hewikinews	1	1	2	1	0
13	itwikinews	4	0	4	4	4
14	jawikinews	2	0	2	1	1
15	kowikinews	0	1	1	0	0
16	liwikinews	1	0	1	0	0
17	nlwikinews	1	1	2	0	0
18	nowikinews	0	0	0	0	0
19	plwikinews	3	1	4	2	0
20	ptwikinews	4	0	4	1	0
21	rowikinews	2	0	2	0	1
22	ruwikinews	6	0	6	1	1
23	sqwikinews	0	0	0	0	0
24	srwikinews	5	0	5	4	4
25	svwikinews	2	0	2	0	2
26	tawikinews	0	0	0	0	0
27	ukwikinews	2	0	2	0	0
28	zhwikinews	2	1	3	2	0

Wikiversities

get_data('wikiversity')

	Project	Permanent admins	Temporary admins	Total admins	Interface admins	Bureaucrats
0	arwikiversity	0	1	1	0	0
1	betawikiversity	8	0	8	1	3
2	cswikiversity	3	0	3	0	1
3	dewikiversity	11	0	11	2	8
4	elwikiversity	0	0	0	0	0
5	enwikiversity	15	0	15	0	4
6	eswikiversity	2	0	2	0	0
7	fiwikiversity	0	0	0	0	0
8	frwikiversity	6	0	6	2	2
9	hiwikiversity	0	1	1	0	0
10	itwikiversity	0	3	3	3	0
11	jawikiversity	2	0	2	2	0
12	kowikiversity	0	1	1	0	0
13	ptwikiversity	2	0	2	2	0
14	ruwikiversity	4	0	4	0	0
15	slwikiversity	2	0	2	0	0
16	svwikiversity	0	0	0	0	0
17	zhwikiversity	1	2	3	0	0

Wikivoyages

get_data('wikivoyage')

	Project	Permanent admins	Temporary admins	Total admins	Interface admins	Bureaucrats
0	bnwikivoyage	0	1	1	1	0
1	dewikivoyage	11	0	11	3	3
2	elwikivoyage	0	0	0	0	0
3	enwikivoyage	41	0	41	3	7
4	eowikivoyage	0	1	1	0	0
5	eswikivoyage	1	0	1	0	1
6	fawikivoyage	1	0	1	0	0
7	fiwikivoyage	0	0	0	0	0
8	frwikivoyage	5	0	5	1	2
9	hewikivoyage	1	0	1	0	0
10	hiwikivoyage	0	0	0	0	0
11	itwikivoyage	5	0	5	3	3
12	jawikivoyage	0	1	1	1	0
13	nlwikivoyage	3	0	3	1	2
14	plwikivoyage	1	0	1	1	0
15	pswikivoyage	0	0	0	0	0
16	ptwikivoyage	0	0	0	0	0
17	rowikivoyage	0	0	0	0	0
18	ruwikivoyage	4	0	4	2	1
19	shnwikivoyage	0	1	1	1	0
20	svwikivoyage	2	0	2	0	1
21	trwikivoyage	0	2	2	2	0
22	ukwikivoyage	0	1	1	0	0
23	viwikivoyage	0	1	1	0	0
24	zhwikivoyage	2	2	4	1	0

Special wikis

get_data_for_projects(['metawiki', 'wikidatawiki', 'commonswiki', 'specieswiki', 'incubatorwiki'])

	Project	Permanent admins	Temporary admins	Total admins	Interface admins	Bureaucrats
0	metawiki	64	5	69	23	4
1	wikidatawiki	60	0	60	14	3
2	commonswiki	187	1	188	26	7
3	specieswiki	24	0	24	1	6
4	incubatorwiki	12	0	12	5	7