Looking for very old WSPR spots with WSPR Rocks

 The creator of WSPR Rocks, Phill VK7JJ has been very helpful and has helped show me how to access WSPR spots back to 2008 using the SQL feature.

Perhaps it is best I share from the email he sent me. Clearly, you will have to adapt the query to suite your needs, but you get the idea.

" 1.  click the SQL tab in http://wspr.rocks and copy and paste the redish text below into the upper editing panel on the SQL page

2.  click the [run query here] button to test your query.  If it returns a bunch of spots rather than an error message that's good, so click the [run query in wspr.rocks] button to execute it in wspr.rocks.

The time, callsign and band criteria should just about be self explanatory, adjust the times to suit but retain the exact format.

If you end up exceeding the 5,000 spot display limit then let me know.  If you want to get rid of the false decode of OH3FR then include this line in the query:   and rx_sign != 'OH3FR'

73  Phil

select * from wspr.rx where

time between '2023-12-01 00:00:00' and '2024-01-24 00:00:00'

and tx_sign = 'G3XBM'

and band = 28

order by time desc    "

WSPR Rocks

This is an excellent site. With it, you can see WSPR spots as maps and look back easily over the last 5 weeks. 

Yesterday, using SQL, the owner (Phil VK7JJ) kindly showed me how to go back to 2008! I had been hoping to use it to do a map of all my 500uW spots, but then I realised the snag! 

My little beacon is pre-programmed to report all spots as 500mW, so spots with the PA off (500uW) cannot be distinguished if over 5 weeks old. In the last 5 weeks I have, as an experiment, just been running 500uW (0.5mW). It has been an eye opener.

See http://wspr.rocks/ .

WSPRnet still faulty?

This morning, WSPRnet still reports an error, so I went on WSPR Rocks instead. I do not know what the problem is.