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    "

630m QRP WSPR overnight

In the last day (and overnight) my 10mW ERP from the earth-electrode "antenna" in the ground has been spotted by 16 stations with the furthermost LA3EQ (769km).

Sunspots - Monday January 29th

 Solar flux is 141 and the SSN 75.  A=8 and K=1.

630m 10mW ERP WSPR (Sunday)

 My gear was re-synced about and hour ago. So far this evening, I have been spotted by  4 unique stations.

Shetland Waves - NOT amateur radio

 

These northerly islands in Scotland are characterised by long days in summer and long nights in winter. Wind can be very strong.

10m 500mW WSPR TX (Sunday)

At about 1545z, I turned on the PA on my 10m WSPR TX beacon. Immediately, spots of me were received, so the 30dB power difference is very significant. I guess unless the local noise level is very low, stations struggle unless propagation is very good. 

Until the Es season, I do not propose to try 500uW WSPR on 10m again. I shall stick with 500mW. During the Es season I may well try 500uW again.

23 stations have spotted my 500mW 10m WSPR TX .

Probable last day (for now) on 10m WSPR at 500uW

Unless things dramatically change today, today will probably be my last day testing at QRPP on 10m WSPR. I shall try again in the Es season. It is now over a week since I have been spotted.

630m QRP WSPR overnight

My 10mW ERP WSPR from the earth-electrode "antenna" was on overnight. In all, 22 stations have spotted me in the last 24 hours with the furthermost DL4RAJ (990km).

Sunspots - Sunday January 28th

 Solar flux is 148 and the SSN 52.  A=5 and K=1.

630m QRP WSPR overnight

 17 stations spotted me overnight when I was running 10mW ERP from the earth-electrode “antenna” in the ground.

Day in London - NOT amateur radio

We spent today in London with our son and his children including having lunch. The photo shows our son with his daughter before her ballet.

10m QRPP WSPR (Saturday)

 Another day has passed and not a single spot obtained at 500uW. Unless things dramatically change  tomorrow, I propose to stop these tests now until the next Es season.

Stuff of dreams - NOT amateur radio

 

Back in 2013 I was in hospital for 3.5 months with a stroke and I was expected to spend the rest of my life being fed via a tube into my stomach. I used to have dreams about tuna fish pie. In the next year I recovered and food could be eaten by mouth. Apart from my voice and giddiness, I largely recovered. Things could have been very different.

Sunspots- Saturday January 27th

 Solar flux is 157 and the SSN 97.  A=6 and K=1.

10m 500uW WSPR this week - no success

All week my 10m WSPR beacon has been on 500uW with the PA off.  Unlike previous weeks, not a single spot!! It looks like conditions have to be really good of this miniscule power to work.

So, unless I get spots before Monday, I propose to go back to 500mW WSPR on Monday (real QRO!!).  It will be worth repeating the experiment in the Es season, when some signals can be very strong.

For now, with F2, I don't think I can learn any more.

11 years ago on 137 kHz

This was in 2013 at the old QTH.  At the time I was seeing how far away I could be spotted on that band. Not much later, I got to the Netherlands.

Sunspots- Friday January 26th

 Solar flux is 161 and the SSN 101. A=6 and K=0.

Rally this Sunday

The following has been notified to me.  As I always advise, contact organisers to avoid disappointment if travelling far.

Sunday January 28th  -  Lincoln Short Wave Club Winter Radio Rally, Market Rasen, LN8 3HT. Contact m5zzz@outlook.com .

500uW 10m WSPR (Thursday)

As I have had no 10m WSPR spots at all this week at 500uW, it would appear conditions have to be very good to get spots at this very low level. 

It will be interesting to repeat this test at 500uW in the Es season, as signals can sometimes be very strong by Es.  It is my expectation that I shall get 10m WSPR spots all over Europe with 500uW 10m WSPR in May and June. Quite a lot more would have been possible at 500mW (30dB stronger), but spots.

It is my view that everyone in the UK may legally use 10mW WSPR between 40.660 and 40.700 MHz in the ISM band without a licence. I am quite surprised more people have not taken advantage of this. This is NOT amateur radio. The ISM bands are internationally allocated and power restrictions are intended to reduce the chances of harmful interference. Callsigns can be made up, and if the format is OK, WSPRnet shows where you are being spotted. Each country has interface specifications (IR2030 in the UK) to agree power levels and other parameters.

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