Wikipedia talk:List of Wikipedians by number of edits
Interesting page. Generated with an SQL query?
Also, this brings up the issue again: who are the active contributors? Certainly not all the user accounts. I guess there's no point in deleting the ones not being used? Or is there? --KQ
Two SQL queries actually, since I do not know enough SQL to know whether it is possible to check the current and the old ones at once. After that I added the numbers up by hand, and used Unix 'sort' to get them in the right order.
As for deleting unused user accounts: I could imagine there would be some use in it, as it would free up the username for a new user. However, such things get important only when we have ten thousands rather than hundreds of users, I think. Andre Engels
It would be very interesting to find out who has made contributions in the last six months say... that would tell you who has probably lost interest in the project and those old accounts could be deleted in a giant housecleaning expedition. KJ
107. It's a rude awakening. But at least I am better than Larry Sanger ;-))
These counts are from the database, which didn't exist until the installation of Magnus's Phase II software. It therefore undercounts those who contributed to the project in its early days--Larry Sanger, Tim Shell, me, Magnus, and probably others. --LDC
- Including me. :-P (but, really, all that cut-n-paste of CIA info etc. probably shouldn't be counted.) --KQ
A more interesting query might be "Most active in the last month" (or other similar time period)... -- Khendon
- Yes, I agree. THat would be cool too. --KQ 20:09 Sep 21, 2002 (UTC)
Hmm, I'm on the list two times, as IPs and 'myself' (possibly three times (one .xxx)) . If I combine all three I leap up to 21st, how sad. User:TwoOneTwo
- I'm on the list twice too. Emphasizes how little I leave the house, I guess. --KQ
- I've modified my script to combine some usernames. See below for the script & full list. --Brion 22:57 Sep 21, 2002 (UTC)
Hmm. Shortly after I joined the project in January I recall hearing that Larry Sanger hit 5000 edits. Yet his total on this list is less than half that. Did UseMod and the conversion miss over half of Larry's edits or am I not remembering things correctly? --mav
- UseMod scrapped the history of an article after a few weeks, keeping only the most recent revisions. He should definitely be higher on the list. --KQ 21:33 Sep 21, 2002 (UTC)
Here's the perl script used to generate the list, in case anybody else wants to update it. (It's ugly and hackish, forgive me.):
# Save the results of the following queries to 'curs' and 'olds' respectively:
# SELECT count(*),cur_user_text FROM cur GROUP BY cur_user_text
# SELECT count(*),old_user_text FROM old GROUP BY old_user_text
%equivs = (
"KoyaanisQatsi" => "Koyaanis Qatsi",
"Koyaanisqatsi" => "Koyaanis Qatsi",
"Koyaansqatsi2350" => "Koyaanis Qatsi",
"Larry_Sanger" => "Larry Sanger",
"LarrySanger" => "Larry Sanger",
"LeeDanielCrocker" => "Lee Daniel Crocker",
"Magnus" => "Magnus Manske",
"ManningBartlett" => "Manning Bartlett",
"[email protected]" => "Perry Bebbington",
"Ray G. Van De Walker" => "Ray Van De Walker",
"Simon_J_Kissane" => "Simon J Kissane",
"CareyEvans" => "Cary Evans",
"Chris_mahan" => "Chris mahan",
"ChuckSmith" => "Chuck Smith",
"Dave_McKee" => "Dave McKee",
"David_spector" => "David spector",
"DickBeldin" => "Dick Beldin",
"F. Lee Horn" => "F. Lee Horn",
"GregLindahl" => "Greg Lindahl",
"Greg_Lindahl" => "Greg Lindahl",
"66.47.62.78" => "H. Jonat",
"66.47.62.xxx" => "H. Jonat",
"HannesHirzel" => "Hannes Hirzel",
"JimboWales" => "Jimbo Wales",
"62.253.64.7" => "TwoOneTwo",
"62.253.64.xxx" => "TwoOneTwo"
);
open CUR, "<curs";
while ($x = <CUR>) {
chomp $x;
$x =~ /^([0-9]+) ([\x20-\xff]+[\S])[\x1-\x20]*$/;
if($equivs{$2}) { $u = $equivs{$2}; } else { $u=$2; }
$count{$u} = $1;
}
print qq(<table border="1">\n);
open OLD, "<olds";
while ($x = <OLD>) {
chomp $x;
$x =~ /^(\d+) ([\x20-\xff]+[\S])[\x1-\x20]*$/;
if($equivs{$2}) { $u = $equivs{$2}; } else { $u=$2; }
$count{$u} += $1;
}
@count2 = map { { ($_ => $count{$_}) } }
sort { $count{$b} <=> $count{$a}
or $b cmp $a
} keys %count;
$maxcount = 200;
foreach $x (@count2) {
$n++;
($u, $c) = each %$x;
print qq(<tr><td align="right">$n<td>$u<td align="right">$c\n);
last if ($n >= $maxcount);
}
print qq(</table>\n);
What gives? I hit diff on Recent Changes for this subject page and got this error instantly;
Fatal error: Maximum execution time of 30 seconds exceeded in /usr/local/apache/htdocs/w/DifferenceEngine.php on line 371
- I don't get it instantly, I get it after waiting 30 seconds. --Brion 23:06 Sep 21, 2002 (UTC)
Except for Helga (H. Jonat), no one with 1,000 or more contributions to their name has had any trouble with NPOV violations or edit wars. (Okay, I am probably biased in favor of myself; if I'm a troublemaker, I'm blissfully unaware of this. :-)
So we can state as a general rule that it takes a thousand contributions to get the hang of NPOV. This rule shall henceforth be known as "Poor's Law of Neutrality". Now don't everyone make a fuss over me. A small statue would be okay, or an endowed chair in my name will suffice... --Ed Poor
"75 Quercusrobur 1220"- Oh God, a brutal reminder that I really must get out more often.... quercus robur
Am I calculating the user contribution count wrong? Larry Sanger's entries seem to have shrunk. --Cousin Eddie
The old list included statistics for various IP Addresses and ranges. I wonder why that wasn't added to this one. In any case, we have 84 accounts with more than 1,000 edits, which is pretty impressive. Given that some of the post-1,000 edits from September were IP Address ranges, there has been a good amount of growth. I just wish I would have created a rambot account earlier so I'd know the difference. Oh well. -- Ram-Man
Are you sure you did this right Ed? I thought for sure I've cut-back on my Wikipedia contribs in the last two and a half months, and yet I have nearly 7 thousand more edits. Andre's numbers and many other's also look inflated. --mav
Mav, you're a beast of burden! -- RM
- Yep - I guess I'm editing in my sleep. Oh, that's right, I only sleep 5 hours a day due to Wikipedia. I wish I was like Batman and was able to only sleep 2 hours a day - think of all the extra edits I would get in! ;-) I'm hopeless and I fear you are in the same boat now. --mav
- I'm not sure whether to feel relieved or envious that I've fallen from 10th to 14th place. On the other hand, I'd win a count of CVS commits to the software hands-down. ;) --Brion 23:12 Dec 10, 2002 (UTC)
- Yes. CVS commits are at least as important as regular wiki edits. Perhaps a most active developer list is in order? We couldn't make any edits without the software. --mav
- Nonsense -- some post-it notes, a little xeroxing, and the USPS would do wonders. It would just be, um, slower and more expensive. --Brion 23:46 Dec 10, 2002 (UTC)
- LOL I would love to see somebody try to pull that off! --mav
Mav, one point of worry or relief (however you view it): You are not number 2 in number of edits between the previous list and this one... Here are the accounts with over 3000 edits between September 21 and December 10 (number of edits on previous list, number of edits on this list, difference):
1. RamMan 677 ( 90) 44654 ( 1) 43977 2. Olivier 1593 ( 45) 8732 ( 7) 7137 3. maveric149 13956 ( 1) 20004 ( 2) 6148 4. Andre Engels 7405 ( 2) 12281 ( 3) 4876 5. Tokerboy 1677 ( 40) 6423 (10) 4746 6. Lir --- 4271 (19) >4034 7. Rambot --- 4203 (21) >3966 8. Renata 489 (114) 4209 (20) 3720 9. Derek Ross 1631 ( 44) 4503 (18) 2872 10. Ed Poor 6086 ( 6) 8957 ( 6) 2871 11. Tarquin 3872 ( 12) 6378 (12) 2506 12. Zoe 3982 ( 11) 6367 (13) 2385 13. KoyaanisQatsi 7150 ( 4) 9420 ( 4) 2270 14. Tzartzam --- 2275 (42) >2038 15. Axel Boldt 7348 ( 3) 9386 ( 5) 2038 16. Isis 2766 ( 21) 4794 (16) 2028 17. Damian Yerrick --- 2091 (50) >1854
--- are accounts/people who were not on the previous list; they had at most 237 edits at that time. Andre Engels 23:59 Dec 10, 2002 (UTC)
- Thanks. Although 6,000+ still seems like a lot. --mav
- Hmmm.. You do a lot of editing though. That time period above is almost the entire length of time i've been a part of wikipedia (minus the 677 from the first couple of weeks). Now I have a hard time estimating it, but I would estimate the number of non-bot edits i've done would be somewhere around 6,000 +/- 2,000. And you do a lot of manual edits! -- Ram-Man
- Arghhhh! #2 after RamMan!! Even though a big part of my edits are minor ones, that's a lot. Maybe it's time fo me to keep my Wikipedia time under control... olivier 08:39 Dec 11, 2002 (UTC)
- There is no way to control it. I thought I had things under control but I actually increased my edit rate! Wikipedia has me in it clutches. There is no hope! ;-) --mav
- Oliver, if it makes you feel worse, I probably would be only #2 or #3 in the above list if you took out the bot edits. So basically you have been most active in the last couple of months. -- Ram-Man
- Oh, you mean Olivier! Phew, you had me confused for a moment there - I thought you were talking to me! :) But of course, I'm only at at no. 162 on the main chart, with my measly 436 edits. I know, I'm far too lazy... -- Oliver PEREIRA 03:51 Dec 12, 2002 (UTC)
- RamMan, I already knew!!! :-( olivier 06:03 Dec 12, 2002 (UTC)