Research talk:Blocks on the English-language Wikipedia

From Meta, a Wikimedia project coordination wiki

Rangeblocks vs. editors[edit]

I expect this ihas already been thought about, but I would like to see a graph of total number of IP adresses blocked in rangeblocks vs. active editors (5+ edits / month). It would be interesting to know if there is a correlation between rangeblocks and the beginning of the editor decline in mid-2007. Last time I checked was over a year ago and we had close to 11 million IP addresses blocked at that point. 64.40.54.4 06:18, 27 November 2013 (UTC)[reply]

Could be interesting; I'll pull in the active editor numbers and compare against things like open proxy blocks when I've rewritten the code. Thanks for the suggestion! Okeyes (WMF) (talk) 16:59, 27 November 2013 (UTC)[reply]
Thanks for the note, Oliver. I was curious, so I grabbed editor data from stats:EN/TablesWikipediaEN.htm and rangeblock data from en:Wikipedia:Database reports/Range blocks. The rangeblock data only went back to August 2009, so I'm limited by that. Here's a table of the data.
Date Active editors IP's in rangeblocks
Aug 2009 38,623 6,727,662
Sep 2009 37,255 6,168,382
Oct 2009 38,517 5,791,864
Nov 2009 37,937 5,662,110
Dec 2009 36,683 6,027,875
Jan 2010 38,656 6,258,678
Feb 2010 37,157 5,791,222
Mar 2010 39,082 6,395,728
Apr 2010 37,848 6,950,324
May 2010 38,218 6,954,356
Jun 2010 35,207 7,262,952
Jul 2010 34,851 6,698,654
Aug 2010 35,446 7,101,194
Sep 2010 33,913 6,743,305
Oct 2010 34,486 7,023,560
Nov 2010 33,887 7,675,024
Dec 2010 33,216 7,606,594
Jan 2011 36,671 7,486,394
Feb 2011 35,679 8,130,442
Mar 2011 37,553 7,784,490
Apr 2011 36,291 6,835,140
May 2011 35,949 7,491,804
Jun 2011 34,768 7,420,234
Jul 2011 34,547 7,308,898
Aug 2011 34,703 7,306,442
Sep 2011 33,814 7,279,378
Oct 2011 34,105 7,059,986
Nov 2011 33,523 7,477,354
Dec 2011 33,221 6,996,072
Jan 2012 34,198 7,248,216
Feb 2012 33,260 7,955,768
Mar 2012 33,673 7,790,740
Apr 2012 33,146 8,573,020
May 2012 33,556 9,318,066
Jun 2012 32,363 9,973,050
Jul 2012 33,304 10,735,998
Aug 2012 33,019 11,409,546
Sep 2012 31,005 11,102,978
Oct 2012 32,417 11,465,195
Nov 2012 32,079 11,579,506
Dec 2012 31,416 11,300,434
Jan 2013 33,283 13,395,414
Feb 2013 31,157 13,450,222
Mar 2013 33,181 14,347,258
Apr 2013 33,368 14,178,926
May 2013 33,072 14,774,552
Jun 2013 30,860 13,902,412
Jul 2013 30,866 14,570,453
Aug 2013 30,879 15,434,306
Sep 2013 28,699 14,884,160
Oct 2013 30,917 15,284,292
Nov 2013 15,928,304
What I find most interesting—when graphing the data—is that the number of IPs blocked seems to grow exponentially starting around March 2012. It will be interesting to see the graph around mid-2007 when the editor decline started happening. Best. 64.40.54.190 06:14, 5 December 2013 (UTC)[reply]