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
=> 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.