This page is a rough beta allowing you to directly query Arne's stunning WSPR spot database at https://wspr.live
The sample queries are from casual testing and may be buggy and better written. See Arne's site for more information.
73 Phil VK7JJ

=> Things you may have wondered
Spot count:  
total spots

Spot date:  
earliest spot
|
latest spot

Distance:  
max
|
avg

Power:  
max
|
avg
|
min

SNR:  
max
|
avg
|
min

RX callsign:  
100 longest
|
100 shortest

TX callsign:  
100 longest
|
100 shortest


=> Write your own free form ClickHouse queries below. Spot and other db keys that may be queried are as listed here
CH db keys: 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
CH bands : -1:LF, 0:MF, 1:160m, 3:80m, 5:60m, 7:40m, 10:30m, 14:20, 18:17, 21:15, 24:12, 28:10, 50:6, 70:4, 144:2, 432:70, 1296:23
WSPR 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:1000
Values: power in the database is in dBm, refer to the dBm:W conversion above. Distance is in kilometres. id is WSPRnet's unique spotnum.
• numbers must be single-quoted when used as keys eg. '-34'
• call signs must be uppercase single-quoted eg. 'VK7DIK'
• ClickHouse operators and sample queries are available in this tutorial

=> Enter your query here:   ->
[copy results to clipboard] Create a browser link to a search: hold down the option/alt key and click the [Submit query] button.
Database query responses and SQL syntax errors are displayed here. Click table column labels to sort. - save your own queries to the Saved list. Back them up to disk regularly. - saving an item using an existing name replaces the original. - if you delete or lose all your queries the default set will be restored next browser refresh. - force reload the sample queries by clicking 'restore' with the AltKey held down. - re-order or edit your saved query file in something like the free 'JSON Editor' (select Tree view) in the Apple store.