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
In [1]:
from wmfdata import mariadb
import pandas as pd

pd.set_option('display.max_rows', None)
In [2]:
import wmfdata
wmfdata.utils.insert_code_toggle()
In [3]:
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')
In [4]:
%%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
In [5]:
def get_data_for_projects(projects=[]):
    data = {
        'Project': [],
        'Has Growth features?': [],
        '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['Has Growth features?'].append(str(dbname in growth_wikis))
        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)
In [6]:
def get_data(family):
    return pd.DataFrame(get_data_for_projects(get_projects(family)))

Wikipedias

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

Wiktionaries

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

Wikiquotes

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

Wikibooks

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

Wikisources

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

Wikinews

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

Wikiversities

In [13]:
get_data('wikiversity')
Out[13]:
Project Has Growth features? Permanent admins Temporary admins Total admins Interface admins Bureaucrats
0 arwikiversity False 0 1 1 0 0
1 betawikiversity False 9 0 9 0 3
2 cswikiversity False 3 0 3 0 1
3 dewikiversity False 11 0 11 2 8
4 elwikiversity False 0 0 0 0 0
5 enwikiversity False 14 0 14 0 4
6 eswikiversity False 2 0 2 0 0
7 fiwikiversity False 1 0 1 0 0
8 frwikiversity False 7 0 7 3 2
9 hiwikiversity False 0 1 1 1 0
10 itwikiversity False 0 2 2 0 0
11 jawikiversity False 2 0 2 2 0
12 kowikiversity False 0 2 2 0 0
13 ptwikiversity False 2 0 2 3 0
14 ruwikiversity False 3 0 3 0 0
15 slwikiversity False 2 0 2 0 0
16 svwikiversity False 0 0 0 0 0
17 zhwikiversity False 2 1 3 1 0

Wikivoyages

In [14]:
get_data('wikivoyage')
Out[14]:
Project Has Growth features? Permanent admins Temporary admins Total admins Interface admins Bureaucrats
0 bnwikivoyage False 0 1 1 0 0
1 dewikivoyage False 12 0 12 2 4
2 elwikivoyage False 0 1 1 0 0
3 enwikivoyage False 46 0 46 4 8
4 eowikivoyage False 0 1 1 0 0
5 eswikivoyage False 1 1 2 1 1
6 fawikivoyage False 1 0 1 0 0
7 fiwikivoyage False 0 0 0 0 0
8 frwikivoyage False 5 0 5 1 2
9 hewikivoyage False 1 0 1 0 0
10 hiwikivoyage False 0 0 0 0 0
11 itwikivoyage False 5 0 5 2 3
12 jawikivoyage False 0 1 1 1 0
13 nlwikivoyage False 6 0 6 1 5
14 plwikivoyage False 1 0 1 1 0
15 pswikivoyage False 0 0 0 0 0
16 ptwikivoyage False 1 1 2 0 0
17 rowikivoyage False 0 0 0 0 0
18 ruwikivoyage False 4 0 4 2 1
19 svwikivoyage False 2 0 2 0 1
20 trwikivoyage False 0 3 3 2 0
21 ukwikivoyage False 0 4 4 1 0
22 viwikivoyage False 0 0 0 0 0
23 zhwikivoyage False 4 0 4 3 0

Special wikis

In [15]:
get_data_for_projects(['metawiki', 'wikidatawiki', 'commonswiki', 'specieswiki', 'incubatorwiki'])
Out[15]:
Project Has Growth features? Permanent admins Temporary admins Total admins Interface admins Bureaucrats
0 metawiki False 61 3 64 19 3
1 wikidatawiki False 59 0 59 17 3
2 commonswiki False 207 0 207 30 7
3 specieswiki False 24 0 24 1 6
4 incubatorwiki False 11 0 11 3 6
In [ ]: