AAØO Year in review

• 4,260 total contacts this year (10,476 lifetime total QSOs)
• Finished CW Academy and got my CW Ops number, #2626
• 11 Parks on the Air activations, 1st time doing CW activation, 264 POTA activation QSOs, 17 hunter QSOs
• Became VE Liaison to the ARRL VEC, 11 new Technicians so far
• Moved and got a new antenna, Zerofive 10-80m ground plane vertical
• Confirmed LOTW totals:
  • 6,692 QSLs
  • 171 DXCC Mixed
  • 97 DXCC CW
  • 117 DXCC Phone
  • 141 DXCC Digital
  • just need Idaho SSB for Worked All States Triple play
• Submitted logs for 25 contests
• Participated in 75 CWT mini contests, 64 over 10 contacts, 34 QSO high score(huge improvement this year)
• AA3B was my most contacted callsign, with 37 QSOs (in CWT’s), K3WW was 2nd with 29
• CW was by far my most frequent mode:

Mode	Count
CW	2873
FM	4
FT4	15
FT8	103
LSB	34
RTTY	914
SSB	289
USB	28

• 20m followed by 40m was the most popular band

Band	Count
2m	2
6m	10
10m	20
12m	5
15m	105
17m	9
20m	2425
30m	15
40m	1540
60m	2
70cm	2
80m	124
160m	1

• 10 most contacted states:

State	Count
PA	215
CA	181
TX	164
TN	127
VA	119
IL	115
ON	114
NY	113
GA	103

• 10 Least contacted states:

State	Count
ND	3
WY	4
AK	4
VT	5
ME	6
NE	9
SD	9
HI	9
ID	11
RI	11

• Most contacted countries:

Country	Count
Canada	240
Italy	66
Fed. Republic of Germany	56
Hungary	43
Croatia	41
Spain	37
Brazil	34
France	34
Czech Republic	33
Slovenia	31

• Top 10 furthest distance:

Call sign	Distance	Country	Band	Mode
YB1HK	17463	Indonesia	30m	FT8
VK4MA	14477	Australia	15m	FT8
5Z4/G3AB	12985	Kenya	20m	FT8
ZM1A	12849	New Zealand	20m	CW
ZR1ADI	12693	Republic of South Africa	60m	FT8
9K2KH	11814	Kuwait	40m	FT8
JH1GEX	11739	Japan	20m	CW
3D2AG	11733	Rotuma Is.	12m	FT8
3D2AG	11733	Rotuma Is.	10m	FT8
UN1HQ	11129	Kazakhstan	20m	CW

Goals for next year

• Design new QSL card
• Make a satellite QSO with my D72
• Get the club tower sorted out
• Improve enough at CW to operate a contest Run station
• Activate the POTA park closest to my house (requires a boat)

Log4OM v2 SQL queries for this data, for reference:

SELECT COUNT(*) FROM log;

SELECT COUNT(*) FROM log WHERE YEAR(qsodate) = 2020;

SELECT band AS 'Band',COUNT(*) AS 'Count' FROM log WHERE YEAR(qsodate) = 2020 GROUP BY band;

SELECT MODE AS 'Mode',COUNT(*) AS 'Count' FROM log WHERE YEAR(qsodate) = 2020 GROUP BY MODE;

SELECT callsign AS 'Call sign',COUNT(*) AS 'Count' FROM log WHERE YEAR(qsodate) = 2020 GROUP BY callsign ORDER BY COUNT(*) DESC;

SELECT state AS 'State',COUNT(*) AS 'Count' FROM log WHERE YEAR(qsodate) = 2020 and (country = 'Hawaii' OR country = 'United States' OR country = 'Alaska')
	GROUP BY state ORDER BY COUNT(*) DESC LIMIT 0,10;

SELECT state AS 'State',COUNT(*) AS 'Count' FROM log WHERE YEAR(qsodate) = 2020 AND (country = 'Hawaii' OR country = 'United States' OR country = 'Alaska')
	GROUP BY state ORDER BY COUNT(*) ASC LIMIT 0,10;
	
SELECT country AS 'Country',COUNT(*) AS 'Count' FROM log WHERE YEAR(qsodate) = 2020 AND country != 'Hawaii' and country != 'United States' and country != 'Alaska'
	GROUP BY country ORDER BY COUNT(*) DESC LIMIT 0,10;

SELECT callsign AS 'Call sign',round(DISTANCE) AS 'Distance',country AS 'Country',band AS 'Band',MODE AS 'Mode'
  FROM log WHERE YEAR(qsodate) = 2020 AND country != 'United States' ORDER BY DISTANCE DESC LIMIT 0,10;

# pota activated
SELECT COUNT(*) FROM log WHERE qslmsg LIKE 'K-%' AND YEAR(qsodate) = 2020;
# pota hunted
SELECT COUNT(*) FROM log WHERE COMMENT LIKE 'K-%' AND YEAR(qsodate) = 2020;