Rising number of amateur radio contacts / 2017-02-12

I noticed recently the number of radio contacts made by my new callsign PE4KH which I started using in March 2016 was getting close to the number of radio contacts made by my previous callsign PD4KH between March 2013 and March 2016. A typical rise in contacts, mostly due to my skills improving and participating in contests. So I wanted to view the rise per month and did some searching how to ask the cqrlog databases and plot the results.

Oh, and now PE4KH has more contacts after a few new contacts logged in PSK31 mode on the 20 meter band today.

For PD4KH:

mysql> select year(qsodate),month(qsodate),count(id_cqrlog_main) from cqrlog_main group by year(qsodate),month(qsodate) order by year(qsodate),month(qsodate);
+---------------+----------------+-----------------------+
| year(qsodate) | month(qsodate) | count(id_cqrlog_main) |
+---------------+----------------+-----------------------+
|          2013 |              7 |                     1 |
|          2013 |              8 |                     1 |
|          2013 |              9 |                     1 |
|          2014 |              4 |                     1 |
|          2014 |              6 |                     2 |
|          2014 |              8 |                     4 |
|          2014 |              9 |                    22 |
|          2014 |             10 |                    65 |
|          2014 |             11 |                   108 |
|          2014 |             12 |                   100 |
|          2015 |              1 |                   153 |
|          2015 |              2 |                   118 |
|          2015 |              3 |                    68 |
|          2015 |              4 |                   105 |
|          2015 |              5 |                   113 |
|          2015 |              6 |                    96 |
|          2015 |              7 |                    44 |
|          2015 |              8 |                    56 |
|          2015 |              9 |                   142 |
|          2015 |             10 |                    82 |
|          2015 |             11 |                    57 |
|          2015 |             12 |                    33 |
|          2016 |              1 |                   161 |
|          2016 |              2 |                    17 |
|          2016 |              3 |                    18 |
+---------------+----------------+-----------------------+
25 rows in set (0.00 sec)

For PE4KH:

mysql> select year(qsodate),month(qsodate),count(id_cqrlog_main) from cqrlog_main group by year(qsodate),month(qsodate) order by year(qsodate),month(qsodate);
+---------------+----------------+-----------------------+
| year(qsodate) | month(qsodate) | count(id_cqrlog_main) |
+---------------+----------------+-----------------------+
|          2016 |              3 |                   132 |
|          2016 |              4 |                   191 |
|          2016 |              5 |                   110 |
|          2016 |              6 |                   157 |
|          2016 |              7 |                   120 |
|          2016 |              8 |                   137 |
|          2016 |              9 |                   188 |
|          2016 |             10 |                   123 |
|          2016 |             11 |                    70 |
|          2016 |             12 |                    66 |
|          2017 |              1 |                   262 |
|          2017 |              2 |                    14 |
+---------------+----------------+-----------------------+
12 rows in set (0.00 sec)

And after massaging the data in gnuplot for a bit I had a nice graph.

The dip in February 2016 was caused by the radio exam coming up, studying was more important.