Closing 2021 in amateur radio / 2022-02-16

I noticed I didn't do a "Closing 2021 in amateur radio" post yet, so time to catch up. Looking back at the Review of 2020 in amateur radio with plans for 2021 I can say:

• Practising morse has happened! Just no exam yet, but that is mainly due to the current circumstances
• Satellite contacts: none.
• Morse and phone in contest: yes!
• New qsl cards ordered and in use

And the plans for 2022:

• More and more morse, and that exam. There is an exam date now and it will be possible to get the wanted 'CW included' on my radio amateur identification
• Again satellites
• In contests: try to get more morse and phone contacts.
• Use the better propagation to get contacts on different bands

More detailed statistics over 2021

And I had to check my own notes again how I got these numbers last year, so I'm adding the sql queries I typed at the mysql/mariadb client. With the database behind cqrlog available I can make all kinds of queries.

By month

The influence of months with (digital) contests isn't as strong as in previous years.

+-------+-----+
| month | cnt |
+-------+-----+
|     1 | 234 |
|     2 | 204 |
|     3 | 238 |
|     4 | 161 |
|     5 | 131 |
|     6 | 111 |
|     7 | 211 |
|     8 |  19 |
|     9 | 232 |
|    10 | 204 |
|    11 | 191 |
|    12 | 101 |
+-------+-----+

Query: select month(qsodate) as month,count(id_cqrlog_main) as cnt from cqrlog_main where year(qsodate)=2021 group by month order by month;

By band

No real surprises there. And the feeling that 10 meter was improving isn't showing in the statistics yet.

+------+-----+
| band | cnt |
+------+-----+
| 40M  | 699 |
| 20M  | 849 |
| 17M  | 151 |
| 15M  |  40 |
| 10M  | 243 |
| 2M   |  51 |
| 70CM |   4 |
+------+-----+

Query: select band,count(id_cqrlog_main) as cnt from cqrlog_main where year(qsodate)=2021 group by band order by freq;

By mode

Almost double the number of morse contacts compared to the previous year.

+-------+-----+
| mode  | cnt |
+-------+-----+
| JT65  |   2 |
| PSK31 |   3 |
| FM    |  19 |
| FT4   |  35 |
| PSK63 | 226 |
| CW    | 240 |
| SSB   | 267 |
| RTTY  | 386 |
| FT8   | 859 |
+-------+-----+

Query: select mode,count(id_cqrlog_main) as cnt from cqrlog_main where year(qsodate)=2021 group by mode order by cnt;