=> Write your own free form ClickHouse queries below. The db column names and spot values required for queries are this colour.
db columns :id, time, band, rx_sign, rx_lat, rx_lon, rx_loc, tx_sign, tx_lat, tx_lon, tx_loc, distance, azimuth, rx_azimuth, frequency, power, snr, drift, version, code
bands : -1:LF, 0:MF, 1:160m, 3:80m, 5:60m, 7:40m, 10:30m, 14:20m, 18:17m, 21:15m, 24:12m, 28:10m, 50:6m, 70:4m, 144:2m, 432:70cm, 1296:23cm
dBm:W : 0:0.001, 3:0.002, 7:0.005, 10:0.01, 13:0.02, 17:0.05, 20:0.1, 23:0.2, 27:0.5, 30:1, 33:2, 37:5, 40:10, 43:20, 47:50, 50:100, 53:200, 57:500, 60:1000W
mode : code 1 = mode 2 (WSPR2,FST4W-120), code 2 = mode 15 (FST4W-900), code 4 = mode 5 (FST4W-300), code 8 = mode 30 (FST4W-1800)
• call signs must be uppercase single-quoted eg. 'VK7DIK'
• power in the database is in dBm, refer to the dBm:W conversion above. Distance is in kilometres. id is WSPRnet's unique spotnum.
• ClickHouse operators and sample queries are available in
this tutorial