2017-02-12
Rising number of amateur radio contacts
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.