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

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. QSL count plot

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

Tags: , , ,

IPv6 check

Running test...
, reachable as koos+website@idefix.net. PGP encrypted e-mail preferred. PGP key 5BA9 368B E6F3 34E4 local copy PGP key 5BA9 368B E6F3 34E4 via keyservers

RSS
Meningen zijn die van mezelf, wat ik schrijf is beschermd door auteursrecht. Sommige publicaties bevatten een expliciete vermelding dat ze ongevraagd gedeeld mogen worden.
My opinions are my own, what I write is protected by copyrights. Some publications contain an explicit license statement which allows sharing without asking permission.
Other webprojects: Camp Wireless, wireless Internet access at campsites, The Virtual Bookcase, book reviews
This page generated by $Id: newsitem.cgi,v 1.55 2021/11/09 13:09:49 koos Exp $ in 0.006376 seconds.