Research talk:Blocks on the English-language Wikipedia

Rangeblocks vs. editors

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)

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)

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)