Skip to content

Instantly share code, notes, and snippets.

@encbladexp

encbladexp/forum-post-by-year.txt Secret

Last active June 15, 2016 14:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save encbladexp/ee8bbe9f977e1d2a49b0339e73dada48 to your computer and use it in GitHub Desktop.
Save encbladexp/ee8bbe9f977e1d2a49b0339e73dada48 to your computer and use it in GitHub Desktop.
Download ZIP
uu stats
Raw
forum-post-by-year.txt
+----------------+----------+
| YEAR(pub_date) | count(*) |
+----------------+----------+
| 2004 | 7512 |
| 2005 | 121447 |
| 2006 | 358282 |
| 2007 | 632849 |
| 2008 | 613865 |
| 2009 | 530273 |
| 2010 | 429373 |
| 2011 | 328279 |
| 2012 | 272264 |
| 2013 | 214257 |
| 2014 | 200046 |
| 2015 | 147615 |
| 2016 | 69710 |
+----------------+----------+
13 rows in set (1.07 sec)
Raw
ikhaya-articles-by-year.txt
+----------------+----------+
| YEAR(pub_date) | count(*) |
+----------------+----------+
| 2005 | 36 |
| 2006 | 307 |
| 2007 | 491 |
| 2008 | 513 |
| 2009 | 344 |
| 2010 | 277 |
| 2011 | 199 |
| 2012 | 242 |
| 2013 | 300 |
| 2014 | 196 |
| 2015 | 158 |
| 2016 | 61 |
+----------------+----------+
Raw
wiki-revisions-by-year.txt
+-------------------+----------+
| YEAR(change_date) | count(*) |
+-------------------+----------+
| 2005 | 4844 |
| 2006 | 20470 |
| 2007 | 36891 |
| 2008 | 45371 |
| 2009 | 50239 |
| 2010 | 46385 |
| 2011 | 43118 |
| 2012 | 35686 |
| 2013 | 28650 |
| 2014 | 19866 |
| 2015 | 16858 |
| 2016 | 7038 |
+-------------------+----------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment