Hey all, I found the Facts and Figures page on the Database, and it’s cool! But I was wondering: is it possible to find or create more detailed breakdowns anywhere? For example, I’m curious to slice and dice the stats by time (e.g. “within the last year”), and place ("summits in W6/NC-*), and find out which combinations of band + mode were used successfully (by number of QSOs).
To make it more concrete, I want to answer questions like:
In the last 12 months, for activations in W6/NC-*, what were the top 20 {band + mode} pairs with the most logged SOTA QSOs?
For S2S QSOs in the above query, what were the most common Associations and Regions of the other summit?
If there’s a web frontend where I can explore the QSO data, that’d be really cool! But I’m not afraid to write my own SQL queries, if that’s what it takes… In another thread I found a link to the SOTA database JSON API, which would get me part of the way there, but it doesn’t appear to expose QSOs, just alerts and spots. Are there any other data sources or sites I should try?
Thanks!