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)

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):
    return pd.DataFrame(get_data_for_projects(get_projects(family)))

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	9	0	9	1	2
6	altwiki	0	2	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	25	0	25	7	5
13	arywiki	0	3	3	2	0
14	arzwiki	5	1	6	0	0
15	astwiki	9	0	9	2	3
16	aswiki	3	0	3	2	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	5	0	5	3	0
23	azwiki	15	0	15	3	3
24	banwiki	2	0	2	1	0
25	barwiki	3	0	3	3	0
26	bat_smgwiki	4	0	4	1	2
27	bawiki	6	0	6	2	1
28	bclwiki	0	3	3	1	0
29	be_x_oldwiki	3	0	3	1	1
30	bewiki	9	0	9	2	1
31	bgwiki	24	0	24	1	6
32	bhwiki	1	0	1	1	0
33	biwiki	0	1	1	0	0
34	bjnwiki	1	0	1	1	0
35	bmwiki	0	0	0	0	0
36	bnwiki	12	0	12	1	1
37	bowiki	0	0	0	0	0
38	bpywiki	1	1	2	0	0
39	brwiki	2	0	2	0	0
40	bswiki	7	0	7	7	2
41	bugwiki	0	0	0	0	0
42	bxrwiki	0	1	1	0	0
43	cawiki	28	0	28	4	2
44	cbk_zamwiki	1	0	1	0	0
45	cdowiki	3	0	3	0	2
46	cebwiki	5	0	5	0	2
47	cewiki	2	0	2	1	0
48	chrwiki	0	0	0	0	0
49	chwiki	0	0	0	0	0
50	chywiki	0	0	0	0	0
51	ckbwiki	6	0	6	3	0
52	cowiki	0	1	1	0	0
53	crhwiki	1	0	1	0	0
54	crwiki	1	0	1	0	0
55	csbwiki	2	0	2	0	1
56	cswiki	33	0	33	3	4
57	cuwiki	1	0	1	0	0
58	cvwiki	2	0	2	0	0
59	cywiki	15	0	15	2	2
60	dagwiki	0	3	3	1	0
61	dawiki	24	0	24	2	2
62	dewiki	178	10	188	20	5
63	dinwiki	0	0	0	0	0
64	diqwiki	2	0	2	0	0
65	dsbwiki	0	0	0	0	0
66	dtywiki	1	0	1	0	0
67	dvwiki	1	1	2	1	1
68	dzwiki	0	0	0	0	0
69	eewiki	1	0	1	0	0
70	elwiki	22	0	22	2	6
71	emlwiki	2	0	2	0	0
72	enwiki	1045	0	1045	11	20
73	eowiki	14	0	14	2	2
74	eswiki	64	0	64	3	63
75	etwiki	32	0	32	4	2
76	euwiki	9	0	9	2	3
77	extwiki	0	0	0	0	0
78	fawiki	36	0	36	9	7
79	ffwiki	0	0	0	0	0
80	fiu_vrowiki	3	0	3	1	1
81	fiwiki	29	0	29	11	4
82	fjwiki	0	0	0	0	0
83	fowiki	3	0	3	0	2
84	frpwiki	1	0	1	1	1
85	frrwiki	4	0	4	2	2
86	frwiki	158	0	158	15	7
87	furwiki	1	0	1	0	0
88	fywiki	8	0	8	0	4
89	gagwiki	0	0	0	0	0
90	ganwiki	1	0	1	0	0
91	gawiki	6	0	6	0	3
92	gcrwiki	0	0	0	0	0
93	gdwiki	6	0	6	0	5
94	glkwiki	2	0	2	0	0
95	glwiki	6	0	6	2	1
96	gnwiki	1	0	1	0	0
97	gomwiki	1	1	2	0	0
98	gorwiki	0	1	1	0	0
99	gotwiki	0	0	0	0	0
100	guwiki	2	0	2	1	0
101	gvwiki	2	0	2	0	1
102	hakwiki	0	0	0	0	0
103	hawiki	1	3	4	0	0
104	hawwiki	0	0	0	0	0
105	hewiki	0	33	33	17	3
106	hifwiki	1	0	1	0	0
107	hiwiki	4	0	4	1	0
108	hrwiki	13	0	13	2	4
109	hsbwiki	3	0	3	0	0
110	htwiki	0	1	1	0	0
111	huwiki	26	0	26	3	8
112	hywiki	9	0	9	2	0
113	hywwiki	1	1	2	0	0
114	iawiki	6	0	6	0	2
115	idwiki	40	0	40	5	5
116	iewiki	0	1	1	0	0
117	igwiki	2	0	2	0	0
118	ikwiki	0	0	0	0	0
119	ilowiki	1	0	1	1	0
120	inhwiki	1	0	1	1	0
121	iowiki	4	0	4	0	0
122	iswiki	17	0	17	2	17
123	itwiki	119	0	119	7	5
124	iuwiki	1	0	1	0	0
125	jamwiki	0	0	0	0	0
126	jawiki	39	0	39	10	4
127	jbowiki	2	0	2	0	1
128	jvwiki	5	0	5	0	1
129	kaawiki	0	0	0	0	0
130	kabwiki	0	0	0	0	0
131	kawiki	3	0	3	3	2
132	kbdwiki	0	1	1	0	0
133	kbpwiki	0	1	1	0	0
134	kgwiki	1	0	1	0	0
135	kiwiki	0	0	0	0	0
136	kkwiki	16	0	16	1	2
137	klwiki	1	1	2	0	0
138	kmwiki	3	0	3	0	2
139	knwiki	3	0	3	0	1
140	koiwiki	0	0	0	0	0
141	kowiki	26	0	26	4	6
142	krcwiki	1	0	1	0	1
143	kshwiki	2	0	2	0	1
144	kswiki	0	2	2	1	0
145	kuwiki	2	0	2	2	0
146	kvwiki	0	0	0	0	0
147	kwwiki	0	1	1	0	0
148	kywiki	1	1	2	0	0
149	ladwiki	4	0	4	0	4
150	lawiki	20	0	20	1	2
151	lbewiki	0	1	1	1	0
152	lbwiki	4	0	4	2	1
153	lezwiki	2	0	2	1	0
154	lfnwiki	0	0	0	0	0
155	lgwiki	0	0	0	0	0
156	lijwiki	6	0	6	0	0
157	liwiki	6	0	6	0	2
158	lldwiki	0	1	1	0	0
159	lmowiki	5	0	5	0	2
160	lnwiki	2	0	2	0	0
161	lowiki	0	0	0	0	0
162	ltgwiki	0	0	0	0	0
163	ltwiki	9	0	9	3	1
164	lvwiki	12	0	12	3	3
165	madwiki	0	0	0	0	0
166	maiwiki	4	1	5	1	0
167	map_bmswiki	0	0	0	0	0
168	mdfwiki	1	0	1	0	0
169	mgwiki	2	0	2	0	0
170	mhrwiki	0	0	0	0	0
171	minwiki	5	0	5	0	0
172	miwiki	1	0	1	0	1
173	mkwiki	11	0	11	4	2
174	mlwiki	14	0	14	1	2
175	mniwiki	0	1	1	1	0
176	mnwiki	3	1	4	0	0
177	mnwwiki	0	2	2	1	0
178	mrjwiki	0	0	0	0	0
179	mrwiki	9	0	9	1	1
180	mswiki	13	0	13	1	3
181	mtwiki	4	0	4	1	3
182	mwlwiki	0	0	0	0	0
183	myvwiki	2	0	2	1	0
184	mywiki	3	0	3	1	1
185	mznwiki	2	0	2	0	0
186	nahwiki	2	0	2	0	0
187	napwiki	2	0	2	0	0
188	nawiki	0	1	1	0	0
189	nds_nlwiki	6	0	6	2	3
190	ndswiki	3	0	3	1	1
191	newiki	4	0	4	3	1
192	newwiki	1	0	1	0	0
193	niawiki	0	2	2	1	0
194	nlwiki	35	0	35	4	3
195	nnwiki	13	0	13	3	2
196	novwiki	1	0	1	0	0
197	nowiki	36	0	36	3	5
198	nqowiki	0	0	0	0	0
199	nrmwiki	0	0	0	0	0
200	nsowiki	0	0	0	0	0
201	nvwiki	1	0	1	0	0
202	nywiki	0	1	1	0	0
203	ocwiki	3	0	3	0	1
204	olowiki	0	1	1	0	0
205	omwiki	0	0	0	0	0
206	orwiki	4	0	4	1	0
207	oswiki	2	0	2	0	0
208	pagwiki	0	0	0	0	0
209	pamwiki	1	0	1	0	0
210	papwiki	1	3	4	0	0
211	pawiki	8	0	8	2	0
212	pcdwiki	1	0	1	0	0
213	pdcwiki	0	0	0	0	0
214	pflwiki	3	0	3	0	0
215	pihwiki	0	0	0	0	0
216	piwiki	0	0	0	0	0
217	plwiki	101	0	101	11	3
218	pmswiki	3	0	3	0	1
219	pnbwiki	1	0	1	1	0
220	pntwiki	0	0	0	0	0
221	pswiki	0	0	0	0	0
222	ptwiki	65	0	65	5	11
223	pwnwiki	0	0	0	0	0
224	quwiki	1	0	1	0	0
225	rmwiki	2	0	2	0	0
226	rmywiki	0	1	1	0	0
227	rnwiki	0	0	0	0	0
228	roa_rupwiki	0	0	0	0	0
229	roa_tarawiki	1	0	1	0	0
230	rowiki	15	0	15	2	0
231	ruewiki	0	0	0	0	0
232	ruwiki	75	0	75	9	5
233	rwwiki	0	0	0	0	0
234	sahwiki	2	0	2	0	1
235	satwiki	2	0	2	0	0
236	sawiki	4	0	4	0	0
237	scnwiki	5	0	5	0	2
238	scowiki	2	1	3	0	0
239	scwiki	3	0	3	1	0
240	sdwiki	3	0	3	2	0
241	sewiki	5	0	5	1	3
242	sgwiki	0	0	0	0	0
243	shiwiki	0	3	3	0	0
244	shnwiki	0	1	1	1	0
245	shwiki	11	0	11	3	3
246	simplewiki	15	0	15	0	4
247	siwiki	2	0	2	0	0
248	skrwiki	0	1	1	0	0
249	skwiki	8	0	8	0	0
250	slwiki	23	0	23	1	6
251	smnwiki	0	5	5	0	0
252	smwiki	0	0	0	0	0
253	snwiki	0	0	0	0	0
254	sowiki	0	0	0	0	0
255	sqwiki	10	0	10	2	4
256	srnwiki	0	0	0	0	0
257	srwiki	17	0	17	17	4
258	sswiki	2	0	2	0	0
259	stqwiki	3	0	3	0	0
260	stwiki	0	0	0	0	0
261	suwiki	6	0	6	1	1
262	svwiki	65	0	65	5	4
263	swwiki	13	0	13	1	2
264	szlwiki	1	1	2	0	0
265	szywiki	0	0	0	0	0
266	tawiki	33	0	33	1	4
267	taywiki	0	1	1	0	0
268	tcywiki	1	0	1	1	0
269	test2wiki	109	1	110	7	50
270	testwiki	345	9	354	19	65
271	tetwiki	1	0	1	0	0
272	tewiki	12	0	12	1	3
273	tgwiki	5	0	5	0	0
274	thwiki	14	0	14	6	3
275	tiwiki	0	1	1	1	0
276	tkwiki	0	1	1	0	0
277	tlwiki	9	0	9	2	4
278	tnwiki	0	0	0	0	0
279	towiki	1	0	1	0	0
280	tpiwiki	0	0	0	0	0
281	trvwiki	0	2	2	0	0
282	trwiki	24	0	24	7	6
283	tswiki	1	0	1	0	0
284	ttwiki	4	1	5	1	0
285	tumwiki	0	0	0	0	0
286	twwiki	0	1	1	0	0
287	tyvwiki	0	0	0	0	0
288	tywiki	0	0	0	0	0
289	udmwiki	3	0	3	2	1
290	ugwiki	0	0	0	0	0
291	ukwiki	42	0	42	6	6
292	urwiki	9	0	9	3	3
293	uzwiki	11	0	11	2	3
294	vecwiki	3	0	3	3	2
295	vepwiki	0	0	0	0	0
296	vewiki	0	0	0	0	0
297	viwiki	19	0	19	5	3
298	vlswiki	4	0	4	0	1
299	vowiki	1	0	1	0	0
300	warwiki	2	0	2	0	0
301	wawiki	2	0	2	1	1
302	wowiki	1	0	1	0	0
303	wuuwiki	3	0	3	0	1
304	xalwiki	0	0	0	0	0
305	xhwiki	0	0	0	0	0
306	xmfwiki	2	0	2	0	0
307	yiwiki	2	0	2	0	0
308	yowiki	2	0	2	0	0
309	zawiki	0	0	0	0	0
310	zeawiki	2	0	2	0	1
311	zh_classicalwiki	3	3	6	5	0
312	zh_min_nanwiki	4	0	4	0	3
313	zh_yuewiki	12	0	12	1	2
314	zhwiki	61	0	61	14	7
315	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	2	1	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	4	0	4	0	4
11	bnwiktionary	1	1	2	0	0
12	brwiktionary	0	0	0	0	0
13	bswiktionary	3	0	3	0	0
14	cawiktionary	3	0	3	2	1
15	chrwiktionary	0	0	0	0	0
16	cowiktionary	0	0	0	0	0
17	csbwiktionary	0	0	0	0	0
18	cswiktionary	3	0	3	0	2
19	cywiktionary	0	0	0	0	0
20	dawiktionary	2	0	2	0	0
21	dewiktionary	16	0	16	2	3
22	diqwiktionary	0	1	1	0	0
23	dvwiktionary	0	0	0	0	0
24	elwiktionary	8	0	8	1	3
25	enwiktionary	104	0	104	15	8
26	eowiktionary	0	0	0	0	0
27	eswiktionary	7	0	7	2	7
28	etwiktionary	3	0	3	1	1
29	euwiktionary	1	0	1	0	0
30	fawiktionary	2	1	3	1	0
31	fiwiktionary	9	0	9	9	1
32	fjwiktionary	0	0	0	0	0
33	fowiktionary	0	0	0	0	0
34	frwiktionary	33	0	33	31	4
35	fywiktionary	0	0	0	0	0
36	gawiktionary	1	0	1	0	0
37	gdwiktionary	0	0	0	0	0
38	glwiktionary	1	0	1	0	0
39	gnwiktionary	0	0	0	0	0
40	gomwiktionary	0	0	0	0	0
41	guwiktionary	0	1	1	0	0
42	gvwiktionary	0	0	0	0	0
43	hawiktionary	0	1	1	0	0
44	hewiktionary	6	0	6	3	3
45	hifwiktionary	0	0	0	0	0
46	hiwiktionary	0	0	0	0	0
47	hrwiktionary	1	0	1	0	0
48	hsbwiktionary	0	0	0	0	0
49	huwiktionary	3	0	3	0	1
50	hywiktionary	1	0	1	0	0
51	iawiktionary	0	0	0	0	0
52	idwiktionary	5	0	5	1	2
53	iewiktionary	0	0	0	0	0
54	iowiktionary	1	0	1	0	0
55	iswiktionary	2	0	2	1	2
56	itwiktionary	4	0	4	3	1
57	iuwiktionary	0	0	0	0	0
58	jawiktionary	4	0	4	0	2
59	jbowiktionary	0	0	0	0	0
60	jvwiktionary	0	0	0	0	0
61	kawiktionary	1	0	1	1	0
62	kkwiktionary	0	0	0	0	0
63	klwiktionary	0	0	0	0	0
64	kmwiktionary	0	0	0	0	0
65	knwiktionary	0	1	1	0	0
66	kowiktionary	0	0	0	0	0
67	kswiktionary	0	1	1	0	0
68	kuwiktionary	5	0	5	1	0
69	kwwiktionary	0	0	0	0	0
70	kywiktionary	0	0	0	0	0
71	lawiktionary	0	0	0	0	0
72	lbwiktionary	0	0	0	0	0
73	liwiktionary	2	0	2	1	1
74	lmowiktionary	0	1	1	0	0
75	lnwiktionary	0	0	0	0	0
76	lowiktionary	0	0	0	0	0
77	ltwiktionary	4	0	4	3	2
78	lvwiktionary	0	0	0	0	0
79	mgwiktionary	1	0	1	0	0
80	minwiktionary	1	0	1	0	0
81	miwiktionary	0	0	0	0	0
82	mkwiktionary	1	0	1	0	0
83	mlwiktionary	5	0	5	1	1
84	mniwiktionary	0	1	1	1	0
85	mnwiktionary	0	0	0	0	0
86	mnwwiktionary	0	0	0	0	0
87	mrwiktionary	0	0	0	0	0
88	mswiktionary	1	0	1	0	0
89	mtwiktionary	0	0	0	0	0
90	mywiktionary	0	1	1	1	0
91	nahwiktionary	0	0	0	0	0
92	nawiktionary	0	0	0	0	0
93	ndswiktionary	1	0	1	0	0
94	newiktionary	0	0	0	0	0
95	niawiktionary	0	2	2	1	0
96	nlwiktionary	9	0	9	3	5
97	nnwiktionary	1	0	1	0	1
98	nowiktionary	4	0	4	1	2
99	ocwiktionary	1	0	1	0	0
100	omwiktionary	0	0	0	0	0
101	orwiktionary	1	0	1	0	0
102	pawiktionary	0	0	0	0	0
103	plwiktionary	14	0	14	3	1
104	pnbwiktionary	0	0	0	0	0
105	pswiktionary	0	0	0	0	0
106	ptwiktionary	4	0	4	1	2
107	quwiktionary	0	0	0	0	0
108	roa_rupwiktionary	0	0	0	0	0
109	rowiktionary	2	0	2	0	2
110	ruwiktionary	13	0	13	3	3
111	rwwiktionary	0	0	0	0	0
112	sawiktionary	0	0	0	0	0
113	scnwiktionary	1	0	1	0	1
114	sdwiktionary	0	0	0	0	0
115	sgwiktionary	0	0	0	1	0
116	shnwiktionary	0	1	1	1	0
117	shwiktionary	3	0	3	2	2
118	shywiktionary	0	1	1	0	0
119	simplewiktionary	2	0	2	0	2
120	siwiktionary	0	1	1	0	0
121	skrwiktionary	0	2	2	0	0
122	skwiktionary	3	0	3	2	0
123	slwiktionary	1	0	1	0	0
124	smwiktionary	0	0	0	0	0
125	sowiktionary	0	0	0	0	0
126	sqwiktionary	0	0	0	0	0
127	srwiktionary	6	0	6	4	3
128	sswiktionary	1	0	1	0	0
129	stwiktionary	0	0	0	0	0
130	suwiktionary	0	0	0	0	0
131	svwiktionary	13	0	13	1	2
132	swwiktionary	0	1	1	0	0
133	tawiktionary	6	0	6	1	2
134	tewiktionary	3	0	3	0	0
135	tgwiktionary	0	0	0	0	0
136	thwiktionary	3	0	3	1	0
137	tiwiktionary	0	0	0	0	0
138	tkwiktionary	0	0	0	0	0
139	tlwiktionary	0	0	0	0	0
140	tnwiktionary	0	0	0	0	0
141	tpiwiktionary	0	0	0	0	0
142	trwiktionary	4	0	4	3	1
143	tswiktionary	0	0	0	0	0
144	ttwiktionary	0	0	0	0	0
145	ugwiktionary	0	0	0	0	0
146	ukwiktionary	3	0	3	1	1
147	urwiktionary	0	0	0	0	0
148	uzwiktionary	0	1	1	0	0
149	vecwiktionary	2	0	2	1	0
150	viwiktionary	8	0	8	2	2
151	vowiktionary	0	0	0	0	0
152	wawiktionary	1	1	2	1	0
153	wowiktionary	1	0	1	0	0
154	yiwiktionary	0	0	0	0	0
155	yuewiktionary	0	0	0	0	0
156	zh_min_nanwiktionary	0	0	0	0	0
157	zhwiktionary	5	2	7	2	0
158	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	5	0	5	1	0
3	bewikiquote	0	0	0	0	0
4	bgwikiquote	4	0	4	1	4
5	brwikiquote	0	0	0	0	0
6	bswikiquote	1	0	1	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	14	0	14	1	3
14	eowikiquote	1	1	2	0	0
15	eswikiquote	5	0	5	0	3
16	etwikiquote	0	2	2	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	3	0	3	0	2
24	hiwikiquote	0	0	0	0	0
25	hrwikiquote	1	0	1	0	0
26	huwikiquote	2	0	2	0	1
27	hywikiquote	0	1	1	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	0	0	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	2
52	slwikiquote	0	0	0	0	0
53	sqwikiquote	0	1	1	1	0
54	srwikiquote	5	0	5	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	3	0	3	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	1	1	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	2	0	2	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	10	0	10	0	10
18	etwikibooks	0	0	0	0	0
19	euwikibooks	0	0	0	0	0
20	fawikibooks	1	0	1	0	0
21	fiwikibooks	4	0	4	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	2	2	1	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	1	0	1	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	0	0	0	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	1	1	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	3	0	3	1	1
56	rowikibooks	1	0	1	0	0
57	ruwikibooks	0	1	1	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	5	0	5	3	3
64	svwikibooks	3	0	3	0	0
65	tawikibooks	1	0	1	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	3	1	4	0	0
73	urwikibooks	0	0	0	0	0
74	viwikibooks	1	1	2	3	0
75	zhwikibooks	6	0	6	1	0

Wikisources

get_data('wikisource')

	Project	Permanent admins	Temporary admins	Total admins	Interface admins	Bureaucrats
0	arwikisource	9	0	9	1	1
1	aswikisource	0	0	0	0	0
2	azwikisource	1	0	1	2	0
3	banwikisource	0	1	1	1	0
4	bewikisource	1	0	1	0	0
5	bgwikisource	0	2	2	0	0
6	bnwikisource	2	1	3	3	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	1	1	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	12	0	12	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	7	0	7	2	2
34	jawikisource	3	0	3	1	1
35	jvwikisource	0	0	0	0	0
36	knwikisource	1	0	1	0	0
37	kowikisource	2	0	2	0	0
38	lawikisource	7	0	7	1	7
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	2	0	2	0	0
47	nowikisource	1	0	1	0	0
48	orwikisource	0	1	1	1	0
49	pawikisource	4	0	4	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	2	0	2	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	0	3	0	0
1	bswikinews	0	0	0	0	0
2	cawikinews	2	0	2	1	1
3	cswikinews	1	1	2	2	0
4	dewikinews	5	0	5	0	1
5	elwikinews	1	0	1	0	0
6	enwikinews	17	0	17	1	4
7	eowikinews	0	0	0	0	0
8	eswikinews	11	0	11	4	11
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	0	0
13	itwikinews	4	0	4	4	4
14	jawikinews	3	0	3	2	2
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	2	2	4	2	0
20	ptwikinews	4	1	5	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	7	0	7	4	6
25	svwikinews	7	0	7	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	0	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	1	0	1	0	0
8	frwikiversity	7	0	7	3	2
9	hiwikiversity	0	1	1	0	0
10	itwikiversity	0	2	2	0	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	1	0

Wikivoyages

get_data('wikivoyage')

	Project	Permanent admins	Temporary admins	Total admins	Interface admins	Bureaucrats
0	bnwikivoyage	0	1	1	1	0
1	dewikivoyage	12	0	12	2	4
2	elwikivoyage	0	1	1	0	0
3	enwikivoyage	46	0	46	4	8
4	eowikivoyage	0	1	1	0	0
5	eswikivoyage	1	1	2	1	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	6	0	6	1	5
14	plwikivoyage	1	1	2	1	0
15	pswikivoyage	0	0	0	0	0
16	ptwikivoyage	1	1	2	0	0
17	rowikivoyage	0	0	0	0	0
18	ruwikivoyage	4	0	4	2	1
19	svwikivoyage	2	0	2	0	1
20	trwikivoyage	0	1	1	3	0
21	ukwikivoyage	0	1	1	0	0
22	viwikivoyage	0	0	0	0	0
23	zhwikivoyage	3	0	3	2	0

Special wikis

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

	Project	Permanent admins	Temporary admins	Total admins	Interface admins	Bureaucrats
0	metawiki	62	6	68	20	3
1	wikidatawiki	59	0	59	17	3
2	commonswiki	201	0	201	28	7
3	specieswiki	25	0	25	1	6
4	incubatorwiki	11	0	11	3	7