AAØO Year in review

12/31/2020

• 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:

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

• 10 most contacted states:

• 10 Least contacted states:

• Most contacted countries:

• Top 10 furthest distance:

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;