Skip to main content

Posts

Showing posts with the label N2AKJ

Things I Learned: Using Datasette to search for Ham Radio QSOs in a Date Range

 I've been doing a lot of amplifier testing over the last week with the Tuna Topper as part of what has become Project TouCans. It's led to many more QSOs—meaning, more than one per week—from the house. I maybe haven't remembered to log them all, and so I wasn't too surprised when I saw that  N2AKJ had logged a Parks on the Air, ( POTA ), contact with me last Thursday when they activated K-2114 Nissequogue River State Park . Still, since I didn't remember the QSO, I wanted to make sure I was at least on the air. And.... There's an app for that! Using the RBN network data automatically accumulated by rm-rbn-history about QSOs and RBN spots from my callsign—KD0FNR— served through datasette , I was able to determine if I'd been on the air when the QSO was logged. Spoiler alert: I was. Understanding the SQL formatting to get the information was a bit tricky, so I'm documenting the SQL statement here so I can go back to it later. select rowid, id, tx_lng,...