What is in my radio log?
Claude.ai created some easy to use python scripts that put my logs into SQLite. Once the contacts are in a real database, asking questions about them is just SQL instead of scrolling through a spreadsheet.
One of the summaries that pleases me includes contacts outside of CONUS:
Confirmed QSOs outside the USA entity, by country (confirmation source: qsl_rcvd, lotw_qsl_rcvd, eqsl_qsl_rcvd, app_qrzlog_status)
Country QSOs Stations
------------------ ------ --------
Canada 57 53
Japan 25 24
France 7 7
Netherlands 5 5
Angola 4 1
Chile 4 3
Dominican Republic 4 4
Germany 4 4
Italy 4 4
Puerto Rico 4 4
Spain 4 4
Brazil 3 3
Alaska 2 2
Belize 2 2
England 2 2
Northern Ireland 2 2
Poland 2 2
Switzerland 2 2
Argentina 1 1
Asiatic Russia 1 1
Belgium 1 1
China 1 1
Costa Rica 1 1
Cuba 1 1
Czech Republic 1 1
Dodecanese 1 1
Ecuador 1 1
El Salvador 1 1
European Russia 1 1
Greece 1 1
Guam 1 1
Hungary 1 1
Indonesia 1 1
Lebanon 1 1
Luxembourg 1 1
Norway 1 1
Portugal 1 1
Romania 1 1
Sardinia 1 1
Serbia 1 1
Ukraine 1 1
Wales 1 1
------------------ ------ --------
TOTAL 161 42 country(s)
161 confirmed QSOs across 42 countries, with Canada and Japan leading the way. Angola sitting at 4 QSOs from a single station stands out too.
- ← Previous
How does VHF propagation get measured?