Skip to content

Instantly share code, notes, and snippets.

@jurgens

jurgens/number of comments per day

Created July 16, 2014 13:18
Show Gist options
  • Save jurgens/50d552c1a10af9d1d31d to your computer and use it in GitHub Desktop.
Save jurgens/50d552c1a10af9d1d31d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
number of comments per day
+----------+---------------+
| count(*) | DATE(created) |
+----------+---------------+
| 11 | 2014-01-01 |
| 8 | 2014-01-02 |
| 24 | 2014-01-03 |
| 13 | 2014-01-04 |
| 3 | 2014-01-05 |
| 25 | 2014-01-06 |
| 30 | 2014-01-07 |
| 18 | 2014-01-08 |
| 12 | 2014-01-09 |
| 27 | 2014-01-10 |
| 9 | 2014-01-11 |
| 8 | 2014-01-12 |
| 28 | 2014-01-13 |
| 39 | 2014-01-14 |
| 13 | 2014-01-15 |
| 35 | 2014-01-16 |
| 17 | 2014-01-17 |
| 12 | 2014-01-18 |
| 12 | 2014-01-19 |
| 36 | 2014-01-20 |
| 9 | 2014-01-21 |
| 27 | 2014-01-22 |
| 24 | 2014-01-23 |
| 47 | 2014-01-24 |
| 12 | 2014-01-25 |
| 7 | 2014-01-26 |
| 9 | 2014-01-27 |
| 12 | 2014-01-28 |
| 32 | 2014-01-29 |
| 18 | 2014-01-30 |
| 16 | 2014-01-31 |
| 15 | 2014-02-01 |
| 8 | 2014-02-02 |
| 15 | 2014-02-03 |
| 23 | 2014-02-04 |
| 13 | 2014-02-05 |
| 9 | 2014-02-06 |
| 25 | 2014-02-07 |
| 3 | 2014-02-08 |
| 2 | 2014-02-09 |
| 7 | 2014-02-10 |
| 5 | 2014-02-11 |
| 10 | 2014-02-12 |
| 10 | 2014-02-13 |
| 13 | 2014-02-14 |
| 15 | 2014-02-15 |
| 1 | 2014-02-16 |
| 7 | 2014-02-17 |
| 12 | 2014-02-18 |
| 11 | 2014-02-19 |
| 12 | 2014-02-20 |
| 5 | 2014-02-21 |
| 8 | 2014-02-22 |
| 2 | 2014-02-23 |
| 19 | 2014-02-24 |
| 33 | 2014-02-25 |
| 19 | 2014-02-26 |
| 60 | 2014-02-27 |
| 17 | 2014-02-28 |
| 17 | 2014-03-01 |
| 8 | 2014-03-02 |
| 21 | 2014-03-03 |
| 20 | 2014-03-04 |
| 9 | 2014-03-05 |
| 8 | 2014-03-06 |
| 35 | 2014-03-07 |
| 6 | 2014-03-08 |
| 13 | 2014-03-09 |
| 3 | 2014-03-10 |
| 16 | 2014-03-11 |
| 15 | 2014-03-12 |
| 21 | 2014-03-13 |
| 20 | 2014-03-14 |
| 4 | 2014-03-15 |
| 6 | 2014-03-16 |
| 22 | 2014-03-17 |
| 10 | 2014-03-18 |
| 8 | 2014-03-19 |
| 12 | 2014-03-20 |
| 8 | 2014-03-21 |
| 5 | 2014-03-22 |
| 7 | 2014-03-23 |
| 7 | 2014-03-24 |
| 13 | 2014-03-25 |
| 30 | 2014-03-26 |
| 14 | 2014-03-27 |
| 39 | 2014-03-28 |
| 17 | 2014-03-29 |
| 9 | 2014-03-30 |
| 17 | 2014-03-31 |
| 25 | 2014-04-01 |
| 29 | 2014-04-02 |
| 19 | 2014-04-03 |
| 10 | 2014-04-04 |
| 3 | 2014-04-05 |
| 2 | 2014-04-06 |
| 3 | 2014-04-07 |
| 5 | 2014-04-08 |
| 13 | 2014-04-09 |
| 6 | 2014-04-10 |
| 15 | 2014-04-11 |
| 8 | 2014-04-12 |
| 1 | 2014-04-13 |
| 24 | 2014-04-14 |
| 7 | 2014-04-15 |
| 10 | 2014-04-16 |
| 16 | 2014-04-17 |
| 3 | 2014-04-18 |
| 11 | 2014-04-19 |
| 2 | 2014-04-20 |
| 21 | 2014-04-22 |
| 13 | 2014-04-23 |
| 23 | 2014-04-24 |
| 29 | 2014-04-25 |
| 3 | 2014-04-26 |
| 9 | 2014-04-28 |
| 19 | 2014-04-29 |
| 6 | 2014-04-30 |
| 10 | 2014-05-01 |
| 19 | 2014-05-02 |
| 4 | 2014-05-03 |
| 1 | 2014-05-04 |
| 12 | 2014-05-06 |
| 8 | 2014-05-07 |
| 4 | 2014-05-08 |
| 11 | 2014-05-09 |
| 12 | 2014-05-10 |
| 6 | 2014-05-11 |
| 13 | 2014-05-12 |
| 13 | 2014-05-13 |
| 3 | 2014-05-14 |
| 25 | 2014-05-15 |
| 11 | 2014-05-16 |
| 5 | 2014-05-17 |
| 6 | 2014-05-18 |
| 13 | 2014-05-19 |
| 19 | 2014-05-20 |
| 12 | 2014-05-21 |
| 4 | 2014-05-22 |
| 18 | 2014-05-23 |
| 13 | 2014-05-24 |
| 5 | 2014-05-25 |
| 5 | 2014-05-26 |
| 9 | 2014-05-27 |
| 3 | 2014-05-28 |
| 13 | 2014-05-29 |
| 12 | 2014-05-30 |
| 3 | 2014-05-31 |
| 3 | 2014-06-01 |
| 1 | 2014-06-02 |
| 17 | 2014-06-03 |
| 35 | 2014-06-04 |
| 15 | 2014-06-05 |
| 15 | 2014-06-06 |
| 1 | 2014-06-07 |
| 6 | 2014-06-08 |
| 8 | 2014-06-09 |
| 6 | 2014-06-10 |
| 12 | 2014-06-11 |
| 6 | 2014-06-12 |
| 11 | 2014-06-13 |
| 5 | 2014-06-14 |
| 5 | 2014-06-15 |
| 6 | 2014-06-16 |
| 9 | 2014-06-17 |
| 6 | 2014-06-18 |
| 11 | 2014-06-19 |
| 4 | 2014-06-20 |
| 6 | 2014-06-21 |
| 6 | 2014-06-22 |
| 10 | 2014-06-23 |
| 4 | 2014-06-24 |
| 22 | 2014-06-25 |
| 12 | 2014-06-26 |
| 8 | 2014-06-27 |
| 8 | 2014-06-28 |
| 3 | 2014-06-29 |
| 8 | 2014-06-30 |
| 20 | 2014-07-01 |
| 20 | 2014-07-02 |
| 26 | 2014-07-03 |
| 16 | 2014-07-04 |
| 7 | 2014-07-05 |
| 5 | 2014-07-06 |
| 4 | 2014-07-07 |
| 26 | 2014-07-08 |
| 12 | 2014-07-09 |
| 13 | 2014-07-10 |
| 24 | 2014-07-11 |
| 13 | 2014-07-12 |
| 7 | 2014-07-13 |
| 10 | 2014-07-14 |
| 10 | 2014-07-15 |
| 6 | 2014-07-16 |
+----------+---------------+
194 rows in set (0.05 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment