I'm not an expert on "big data manipulation", but I know my way around Excel pretty well. So I took on Jerry and David's challenge, and here are the results.
There are just over 2.2 million QSOs in the database, but that includes non-US stations/grids, and QSOs that don't include grids. Filtering to just QSOs with US stations with grids included and grids within the 436 that count for the 070 award takes the total down to about 598 thousand. I then tallied (not manually!) how many QSOs were with each of those 436 grids. Note that this counts QSOs, not unique callsigns (so there are many duplicates in the count). I also did not do any real quality checking other than that they were valid 4-character grids that matched one of the 436. So if someone had logged me at my home QTH (which is FN20), but put EN20 or DN20 as the grid, it was counted as that errant grid.
- There are eleven grids that have no QSOs at all:
- There are thirty other grids with less than ten QSOs each:
- There are four grids with over 10,000 QSOs each.
I'll be posting the results spreadsheet to the Yahoo page if anyone wants to check on other grids.