Wikipedia:Time Between Edits

From Wikipedia, the free encyclopedia
  (Redirected from User:Katalaveno/TBE)
Jump to: navigation, search
English language Wikipedia measured by time between every 10,000,000th edit

This table and chart measures editing on the English Wikipedia in terms of the time it takes for every ten million edits. This page was originally started by Katalaveno at User:Katalaveno/TBE, and notes in the first person are by them.

There are two ways of measuring edits on Wikipedia, one from the magic word {{REVISIONID}} and the other from {{NUMBEROFEDITS}}. This chart uses the former because it is easy to find the date of any edit by revisionID


Time between edits (incrementing by 10,000,000)[edit]

Edit Number (id) Link to Edit Date Time between 10 million edits[note 1]
291430 [note 2] [1] (earliest edit date) 20:08, 2001 January 16
1 (see note 1) [2] 10:25, 2002 January 26
10,000,000 [3] 10:26, 2005 February 6 1483 days (~211 weeks)
20,000,000 [4] 16:03, 2005 July 31 175 days (  ~25 weeks)
30,000,000[note 3] [5] 04:23, 2005 December 3 125 days (  ~17 weeks)
40,000,000 [6] 07:42, 2006 February 17   76 days (  ~10 weeks)
50,000,000 [7] 19:54, 2006 April 24   66 days (    ~9 weeks)
60,000,000(see note 3) [8] 10:22, 2006 June 22   59 days (    ~8 weeks)
70,000,000 [9] 08:10, 2006 August 16   55 days (    ~7 weeks)
80,000,000(see note 3) [10] 05:19, 2006 October 7   52 days (    ~7 weeks)
90,000,000 [11] 06:17, 2006 November 25   49 days (    ~7 weeks)
100,000,000 [12] 11:12, 2007 January 11   47 days (    ~6 weeks)
110,000,000 [13] 00:57, 2007 February 22   42 days (    ~6 weeks)
120,000,000 [14] 12:11, 2007 April 3   40 days (    ~5 weeks)
130,000,000 [15] 22:26, 2007 May 10   37 days (    ~5 weeks)
140,000,000(see note 3) [16] 18:30, 2007 June 22   43 days (    ~6 weeks)
150,000,000 [17] 12:37, 2007 August 8   47 days (    ~6 weeks)
160,000,000 [18] 08:34, 2007 September 24   47 days (    ~6 weeks)
170,000,000 [19] 20:55, 2007 November 7   44 days (    ~6 weeks)
180,000,000 [20] 15:32, 2007 December 24   47 days (    ~6 weeks)
190,000,000 [21] 14:04, 2008 February 8   46 days (    ~6 weeks)
200,000,000 [22] 00:24, 2008 March 22   43 days (    ~6 weeks)
210,000,000 [23] 00:42, 2008 May 4   43 days (    ~6 weeks)
220,000,000 [24] 21:40, 2008 June 17   44 days (    ~6 weeks)
230,000,000 [25] 16:23, 2008 August 5   49 days (    ~7 weeks)
240,000,000 [26] 16:04, 2008 September 21   47 days (    ~7 weeks)
250,000,000 [27] 09:33, 2008 November 6   46 days (    ~6 weeks)
260,000,000 [28] 23:06, 2008 December 24   48 days (    ~7 weeks)
270,000,000 [29] 10:07, 2009 February 11   49 days (    ~7 weeks)
280,000,000 [30] 08:59, 2009 March 27   44 days (    ~6 weeks)
290,000,000 [31] 20:49, 2009 May 14   48 days (    ~7 weeks)
300,000,000 [32] 01:14, 2009 July 3   50 days (    ~7 weeks)
310,000,000 [33] 12:53, 2009 August 25   53 days (    ~8 weeks)
320,000,000 [34] 08:05, 2009 October 15   51 days (    ~7 weeks)
330,000,000 [35] 00:00, 2009 December 6   52 days (    ~7 weeks)
340,000,000(see note 3) [36] 17:22, 2010 January 25   50 days (    ~7 weeks)
350,000,000 [37] 09:37 2010 March 15   49 days (    ~7 weeks)
360,000,000 [38] 01:05 2010 May 4   50 days (    ~7 weeks)
370,000,000 [39] 19:26 2010 June 24   51 days (    ~7 weeks)
380,000,000 [40] 14:21 2010 August 20   57 days (    ~8 weeks)
390,000,000 [41] 23:43 2010 October 10   51 days (    ~7 weeks)
400,000,000 [42] 17:48 2010 December 1   52 days (    ~7 weeks)
410,000,000 [43] 13:23 2011 January 25   55 days (    ~8 weeks)
420,000,000 [44] 13:26 2011 March 21   55 days (    ~8 weeks)
430,000,000 [45] 02:02 2011 May 20   60 days (    ~8 weeks)
440,000,000 [46] 16:04 2011 July 17   58 days (    ~8 weeks)
450,000,000 [47] 03:49, 2011 September 12   57 days (    ~8 weeks)
460,000,000 [48] 13:57, 2011 November 10   59 days (    ~8 weeks)
470,000,000 [49] 19:50, 2012 January 6   57 days (    ~8 weeks)[note 4]
480,000,000 [50] 11:43, 2012 March 3   57 days (    ~8 weeks)
490,000,000 [51] 15:36, 2012 April 30   58 days (    ~8 weeks)
500,000,000 [52] 23:35, 2012 June 29   60 days (    ~9 weeks)
510,000,000 [53] 16:50, 2012 August 30   62 days (    ~9 weeks)
520,000,000 [54] 15:02, 2012 October 26   57 days (    ~8 weeks)
530,000,000 [55] 11:38, 2012 December 27   62 days (    ~9 weeks)
540,000,000 [56] 22:21, 2013 February 23   58 days (    ~8 weeks)
550,000,000 [57] 09:40, 2013 April 12   48 days (    ~7 weeks) (see note 5)
560,000,000 [58] 06:07, 2013 June 15   64 days (    ~9 weeks)
570,000,000 [59] 10:41, 2013 August 24   70 days (    ~10 weeks)
580,000,000 [60] 08:01, 3 November 2013   71 days (    ~10 weeks)
590,000,000 [61] 19:01, 9 January 2014   67 days (    ~10 weeks)
600,000,000 [62] 07:24, 17 March 2014   67 days (    ~10 weeks)
610,000,000 [63] 18:44, 24 May 2014   68 days (    ~10 weeks)
620,000,000 [64] 19:47, 5 August 2014   73 days (    ~10 weeks)
630,000,000 [65] 16:36, 17 October 2014   73 days (    ~10 weeks)
640,000,000 [66] 22:12, 28 December 2014   72 days (    ~10 weeks)
650,000,000 [67] 15:14, 5 March 2015   67 days (    ~10 weeks)
660,000,000 [68] 04:47, 30 April 2015   56 days (    ~8 weeks)
670,000,000 [69] 03:09, 5 July 2015   66 days (    ~9 weeks)
680,000,000 [70] 03:35, 8 September 2015   65 days (    ~9 weeks)
690,000,000 [71] 16:59, 10 November 2015   63 days (    ~9 weeks)
700,000,000 [72] 18:26, 15 January 2016   66 days (    ~9 weeks)
710,000,000 [73] 10:43, 14 March 2016   59 days (    ~8 weeks)
720,000,000 [74] 18:26, 13 May 2016   60 days (    ~9 weeks)
730,000,000 [75] 2:31, 16 July 2016   64 days (    ~9 weeks)
740,000,000 [76] 13:44, 18 September 2016   64 days (    ~9 weeks)
750,000,000 [77] 08:13, 17 November 2016   60 days (    ~9 weeks)
760,000,000 [78] 10:17, 14 January 2017   58 days (    ~8 weeks)
770,000,000 [79] 21:12, 12 March 2017   57 days (    ~8 weeks)
780,000,000 [80] 10:30, 12 May 2017   61 days (    ~9 weeks)


Notes:

  1. This appears to be the "first" edit in the database; it may have an oldid=1 but the earliest edit date found in the database is this edit dated January 16, 2001 at 4:08pm. Curious wiki historians can read WP:Wikipedia's oldest articles which contains some interesting information about the earliest "surviving" edits.
  2. The database did not find the text of this edit. The next edit that the database found is listed instead.
  3. In 2012/13 Wikipedia migrated its intrawiki links from a many to many system to a hub and spoke system centred on Wikidata. Removing the old Wikilinks involved a significant editing spike in early 2013. Subsequently the change will have lost many millions of minor bot edits.
  4. Removing {{Persondata}} in 2016 involved significant activity, since up to 1.5 million biographies were affected.

Projections[edit]

Around January 2007, the time between every 10,000,000th edit was about 6 weeks. It hovered around that mark for about two years, and then began to increase; by August/October 2014 it had nearly reached 10 and a half weeks. Subsequently editing has picked up again with 8 and a half to 9 weeks being the norm for 2015 and 2016.

The current value for {{NUMBEROFEDITS}} is 896,812,476. My calculations seem to predict that {{NUMBEROFEDITS}} will hit 1,000,000,000 by about Wednesday, November 28, 2018.

Graph of Table 1 Data[edit]

This graph is a detail of data points from July 31, 2005 to January 25, 2011.
Time Between Edits Graph Jul05-Present.png


Notes:

  1. How did this Start? I was interested in getting an idea of the overall edit growth on Wikipedia in the last few years. One way I thought to do it was to take a look the time between every 10,000,000th edit. On March 22, 2008, I noticed in the URL of the diffs I was seeing that the oldid value had just passed 200,000,000. So, that gave me 20 data points to start with.
  2. I have had queries as to why time is not 'on the x-axis' in this graph. The reason is that I am using, as regular intervals, blocks of 10,000,000 Wikipedia edits, not time. I am specifically examining the amount of days (which will vary) between each block of ten million edits. Therefore, in this case, time is dependent upon the number of edits made, so time (measured in days) is the dependent variable and edits (measured in blocks of 10,000,000 edits) is the independent variable.
  3. Why is there a Table 1 but no other tables? There used to be a Table 2 but I removed it.
  4. Why is {{REVISIONID}} over a hundred million less than whilst {{NUMBEROFEDITS}} is 896,812,476? I would prefer to use {{NUMBEROFEDITS}} Keep in mind that the oldid value I am using is the same as the value contained in the magic word {{REVISIONID}} and not the magic word {{NUMBEROFEDITS}}. I would prefer to use {{NUMBEROFEDITS}} as that includes all edits, both existing and deleted. However, there seems to be no way to backtrack that value in time. If I am wrong about that, I would appreciate knowing a method.


Notes[edit]

  1. ^ The date calculators (duration & dateadd) can be used to count days.
  2. ^ The earliest known edit to Wikipedia is dated January 16, 2001. This is almost a year before the edit with oldid=1 which is January 26, 2002. Since the oldids of these older edits are included within the block of the first 10,000,000 edits, the earliest date on record is used for the calculation of the number of days between the first edit and the 10,000,000th edit logged in the database.
  3. ^ This edit is missing, presumably deleted, the next was used
  4. ^ Due to the Sopa blackout of 18/19 January 2012 there were only 142 edits in 24 hours. 471995871 and 471996013 were the edits immediately before and after the blackout.