Jump to content

User:Enterprisey/Tenures at RfA

From Wikipedia, the free encyclopedia

Successful RfAs only.

I used year=365.25. I dunno if that's bad.

Disclaimer! Note that this data is not too useful because it only tracks registration date, not the date that active editing started (which could be very different for some editors! I started actively editing about 13 months after registering, for instance). But that would be time-consuming to collect by hand.

Graph showing statistics on this page
The data on this page in chart form

Data from Wikipedia:Requests for adminship by year and the API. Script at the bottom.

Username Registered RfA Years
Z1720 2006-06-14 29 Aug 2022 16.2085329682866
Femke 2013-11-22 18 Aug 2022 8.73693817020306
DatGuy 2015-11-18 15 Aug 2022 6.74104494638376
DanCherek 2020-12-19 9 Aug 2022 1.63769107916952
Tamzin 2012-11-03 3 May 2022 9.49532283823865
Colin M 2007-01-11 9 Apr 2022 15.2420716404289
Sdrqaz 2016-01-05 25 Mar 2022 6.21811544604152
Firefly 2005-12-26 11 Mar 2022 16.2059091946156
Modussiccandi 2018-05-02 1 Feb 2022 3.75416381473876
Blablubbs 2014-10-21 11 Sep 2021 6.89162673967602
BusterD 2005-07-22 9 Jul 2021 15.9648642482318
Trialpears 2019-02-05 12 Jun 2021 2.34953228382386
Less Unless 2019-10-04 23 May 2021 1.63495322838239
Ashleyyoursmile 2019-12-13 22 May 2021 1.44056582249601
TJMSmith 2017-10-06 22 Feb 2021 3.3818161076888
Hog Farm 2019-11-06 21 Jan 2021 1.21070043349304
Hammersoft 2006-12-15 15 Dec 2020 14.0019393109742
John M Wolfson 2018-06-12 25 Oct 2020 2.37143509012092
Jackmcbarn 2013-07-03 23 Sep 2020 7.22564453570614
LuK3 2008-06-07 23 Sep 2020 12.2961441934748
Ajpolino 2013-07-03 23 Sep 2020 7.22564453570614
Eddie891 2016-12-06 19 Aug 2020 3.70203057266712
Red Phoenix 2007-08-25 30 Jul 2020 12.9313255760894
Creffett 2018-11-28 17 May 2020 1.46794433036733
Cwmhiraeth 2010-10-23 15 May 2020 9.56103125712982
CaptainEek 2014-02-19 12 May 2020 6.22632899840292
Lee Vilenski 2017-10-05 12 Mar 2020 2.43440565822496
Cabayi 2008-02-29 3 Mar 2020 12.0087839379421
Money emoji 2018-03-16 22 Feb 2020 1.93896874287018
Ergo Sum 2015-04-22 26 Jan 2020 4.76443075519051
Wugapodes 2015-03-20 25 Jan 2020 4.85204198037874
QEDK 2010-05-28 24 Jan 2020 9.65970796258271
Nick Moyes 2010-01-07 23 Jan 2020 10.0430070727812
Rosguill 2018-01-03 23 Dec 2019 1.96908510152863
Newslinger 2018-04-06 23 Dec 2019 1.71446497832535
Dreamy Jazz 2015-12-23 2 Dec 2019 3.94307551905088
EvergreenFir 2013-02-18 15 Nov 2019 6.73842117271275
ToBeFree 2012-05-03 10 Nov 2019 7.52144649783253
Girth Summit 2008-01-18 26 Oct 2019 11.7704768423454
Kees08 2015-10-14 14 Oct 2019 4.00045630846452
GermanJoe 2010-08-20 6 Oct 2019 9.12845083276295
Nosebagbear 2012-08-16 3 Oct 2019 7.12981975815651
Barkeep49 2005-06-15 11 Sep 2019 14.2400182523386
Izno 2006-12-04 17 Aug 2019 12.7013461099703
Chetsford 2017-04-30 11 Aug 2019 2.28108601414556
Bradv 2008-01-23 11 Aug 2019 11.5487109285877
Floquenbeam 2008-08-13 2 Aug 2019 10.9682865617157
Johnuniq 2007-12-19 30 Jul 2019 11.6116814966918
Kosack 2007-05-20 7 Jul 2019 12.1318731462469
Valereee 2006-03-17 7 Jul 2019 13.3064111339265
HickoryOughtShirt?4 2017-11-05 1 May 2019 1.48437143509012
RexxS 2008-01-03 11 Apr 2019 11.2694501483003
Evad37 2012-06-08 18 Feb 2019 6.69735341090577
Enterprisey 2012-04-17 26 Jan 2019 6.7767510837326
JJMC89 2015-04-18 1 Jan 2019 3.70762035135752
Galobtter 2013-08-10 7 Dec 2018 5.32569016655259
Sir Sputnik 2008-01-24 21 Oct 2018 10.7410449463838
Justlettersandnumbers 2010-12-01 1 Oct 2018 7.83344741044946
L235 2010-02-10 3 Sep 2018 8.5617157198266
Sro23 2015-05-22 10 Jul 2018 3.13529545973078
TheSandDoctor 2017-01-08 16 Jun 2018 1.43509012092174
Pbsouthwood 2009-07-04 6 Jun 2018 8.92311202372804
Cordless Larry 2005-12-15 1 Apr 2018 12.2934063426877
331dot 2012-05-30 29 Mar 2018 5.82934063426877
Lourdes 2015-12-02 26 Feb 2018 2.23739447866758
Muboshgu 2005-11-22 29 Dec 2017 12.1018708647045
Joe Roe 2005-03-26 30 Nov 2017 12.6822952315765
TonyBallioni 2007-10-09 19 Oct 2017 10.0292037417294
Megalibrarygirl 2011-05-02 16 Oct 2017 6.45904631530915
Ansh666 2007-09-12 22 Sep 2017 10.0292037417294
Cullen328 2009-06-28 23 Jul 2017 8.06890257814282
GeneralizationsAreBad 2015-02-11 13 Jul 2017 2.41797855350217
Anarchyte 2015-04-02 7 Jul 2017 2.26465890942277
ONUnicorn 2006-03-29 30 May 2017 11.1708875199635
Clpo13 2006-03-07 10 May 2017 11.1763632215378
GoldenRing 2004-08-05 8 Apr 2017 12.673967602099
Amortias 2014-05-03 19 Feb 2017 2.80139174081679
Dodger67 2007-06-15 29 Jan 2017 9.62685375313712
Primefac 2010-01-23 16 Jan 2017 6.98208989276751
Mz7 2010-03-14 13 Jan 2017 6.83698380104951
Cyberpower678 2011-06-26 11 Jan 2017 5.54745608031029
Ferret 2007-05-09 11 Jan 2017 9.67887291809263
Ealdgyth 2007-05-27 10 Jan 2017 9.62685375313712
K6ka 2010-02-27 7 Jan 2017 6.8616244581337
Schwede66 2009-10-02 6 Jan 2017 7.26408852384212
NinjaRobotPirate 2007-03-05 5 Jan 2017 9.84040611453342

Code (it's bad):

// use on [[Wikipedia:Requests for adminship by year]]
$(function(){
    $('div.navbox,div#toc').remove();
    $('#mw-content-text ul').first().remove();
    $('#mw-content-text h2').first().remove();
    $('#mw-content-text h2').first().remove();
    $('#mw-content-text p').first().remove();
    $('#mw-content-text div.thumb').first().remove();
    $('thead').remove();
    $('th sup').each(function(_i,e){
        $(e).remove();//$(e).replaceWith('#'+e.textContent);
    });
    $('a.mw-collapsible-text').click();
    $('table.mw-collapsible > tbody > tr > th').parent().remove();
    $('table.wikitable tr').each(function(_i,e){
        if(!e.textContent.includes('Successful'))$(e).remove();
    });
    var rfaDates = {};
    var usernames = $('table.wikitable').slice(0,6).find('tr').map(function(_i,e){
        var username = $(e).find('th').get(0).textContent.trim();
        if(rfaDates[username]){
            // dupe...
            console.log(e);
            throw(username + ',' + rfaDates[username] + ',');
        }
        rfaDates[username]=$(e).find('td').get(2).textContent.trim();
    }).get();
    console.log(rfaDates.length);
    var graphData = [];
    new mw.Api().get({
        action:'query',
        list:'users',
        usprop:'registration',
        ususers:Object.keys(rfaDates).join('|')
    }).then(function(data){
        data.query.users.forEach(function(user){
            var rfaDate = rfaDates[user.name];
            var regDate;
            if(!user.registration){
                if(user.name==='Ashleyyoursmile'){
                    regDate = '2019-12-13';
                }else if(user.name==='Creffett'){// -> GeneralNotability
                    regDate='2018-11-28';
                }else if(user.name==='Money emoji'){// -> Moneytrees
                    regDate='2018-03-16';
                }else if(user.name==='Muboshgu'){// too old to have a registration date. scary...
                    regDate='2005-11-22';
                }else{
                    throw new Error(user.name);
                }
            }else{
                regDate = user.registration.substring(0,10);
            }
            var diff=(Date.parse(rfaDate)-Date.parse(regDate))/(1000*60*60*24*365.25);
            graphData.push([rfaDate,diff]);
            console.log(user.name+','+regDate+','+rfaDate+','+diff);
        });
        console.log(JSON.stringify(graphData));
    });
});