Home
>
Pro Tools
> Query
select round(avg(frequency)) as freqAvg , substring(tx_sign, 1, 1) as id1 , substring(tx_sign, 3, 1) as id3 , (freqAvg - 14097000) as freqOffset , (freqOffset / 40) as freqToBand , toInt8((freqAvg - 14097000) / 40) + 1 as freqBand , if(freqBand <= 2, freqBand, freqBand - 1) as freqBandDisp , toMinute(time) % 10 as min , count(*) as count from wspr.rx where time between '2023-03-13 00:00:00' and '2023-04-12 00:00:00' and band = 14 and match(tx_sign,'^[01Q].[0-9]') = 1 group by (id1, id3, min) order by (id1, id3, freqBand, min)
query
Result table:
(download)
or
(copy to clipboard)
Inspired by http://wspr.rocks/livequeries/
Database Fields
Clickhouse Database Field Types