Downloads

Documentation and software downloads of WSPR programs and other WSJT-related modes of Joe Taylor, K1JT, are available from the WSJT web site. The entire database of millions of WSPR spots is available for public download in comma-separated value (CSV) format compressed with the gzip and zip utilities. Each file contains the data for one calendar month of spots. The data begins with the initial release of WSPR in March, 2008. The file for the current month is updated automatically once per day in the early morning UTC, and the monthly historical files are re-generated once every month. Compressed file sizes range from 1-20MB.

2008-03 gz zip
2008-04 gz zip
2008-05 gz zip
2008-06 gz zip
2008-07 gz zip
2008-08 gz zip
2008-09 gz zip
2008-10 gz zip
2008-11 gz zip
2008-12 gz zip
2009-01 gz zip
2009-02 gz zip
2009-03 gz zip
2009-04 gz zip
2009-05 gz zip
2009-06 gz zip
2009-07 gz zip
2009-08 gz zip
2009-09 gz zip
2009-10 gz zip
2009-11 gz zip
2009-12 gz zip
2010-01 gz zip
2010-02 gz zip
2010-03 gz zip
2010-04 gz zip
2010-05 gz zip
2010-06 gz zip
2010-07 gz zip
2010-08 gz zip
2010-09 gz zip
2010-10 gz zip
2010-11 gz zip
2010-12 gz zip
2011-01 gz zip
2011-02 gz zip
2011-03 gz zip
2011-04 gz zip
2011-05 gz zip
2011-06 gz zip
2011-07 gz zip
2011-08 gz zip
2011-09 gz zip
2011-10 gz zip
2011-11 gz zip
2011-12 gz zip
2012-01 gz zip
2012-02 gz zip
2012-03 gz zip
2012-04 gz zip
2012-05 gz zip
2012-06 gz zip
2012-07 gz zip
2012-08 gz zip
2012-09 gz zip
2012-10 gz zip
2012-11 gz zip
2012-12 gz zip
2013-01 gz zip
2013-02 gz zip
2013-03 gz zip
2013-04 gz zip
2013-05 gz zip
2013-06 gz zip
2013-07 gz zip
2013-08 gz zip
2013-09 gz zip
2013-10 gz zip
2013-11 gz zip
2013-12 gz zip
2014-01 gz zip
2014-02 gz zip
2014-03 gz zip
2014-04 gz zip
2014-05 gz zip
2014-06 gz zip
2014-07 gz zip
2014-08 gz zip
2014-09 gz zip


CSV File Format The fields in the CSV file are as follows:
Spot ID
A unique integer identifying the spot which otherwise carries no information. Used as primary key in the database table. Not all spot numbers exist, and the files may not be in spot number order
Timestamp
The time of the spot in unix time() format (seconds since 1970-01-01 00:00 UTC). To convert to an excel date value, use =time_cell/86400+"1/1/70" and then format it as a date/time.
Reporter
The station reporting the spot. Usually an amateur call sign, but several SWLs have participated using other identifiers. Maximum of 10 characters.
Reporter's Grid
Maidenhead grid locator of the reporting station, in 4- or 6-character format.
SNR
Signal to noise ratio in dB as reported by the receiving software. WSPR reports SNR referenced to a 2500 Hz bandwidth; typical values are -30 to +20dB.
Frequency
Frequency of the received signal in MHz
Call Sign
Call sign of the transmitting station. WSPR encoding of callsigns does not encode portable or other qualifying (slash) designators, so the call may not represent the true location of the transmitting station. Maximum of 6 characters.
Grid
Maidenhead grid locator of transmitting station, in 4- or 6-character format.
Power
Power, as reported by transmitting station in the transmission. Units are dBm (decibels relative to 1 milliwatt; 30dBm=1W). Typical values are 0-50dBm, though a few are negative (< 1 mW).
Drift
The measured drift of the transmitted signal as seen by the receiver, in Hz/minute. Mostly of use to make the transmitting station aware of systematic drift of the transmitter. Typical values are -3 to 3.
Distance
Approximate distance between transmitter and receiver along the great circle (short) path, in kilometers. Computed form the reported grid squares.
Azimuth
Approximate direction, in degrees, from transmitting station to receiving station along the great circle (short) path.
Band
Band of operation, computed from frequency as an index for faster retrieval. This may change in the future, but at the moment, it is just an integer representing the MHz component of the frequency with a special case for LF (-1: LF, 0: MF, 1: 160m, 3: 80m, 5: 60m, 7: 40m, 10: 30m, ...).
Version
Version string of the WSPR software in use by the receiving station. May be bank, as versions were not reported until version 0.6 or 0.7, and version reporting is only done through the realtime upload interface (not the bulk upload).
Code
Archives generated after 22 Dec 2010 have an additional integer Code field. Non-zero values will indicate that the spot is likely to be erroneous (bogus callsign, appears to be wrong band, appears to be an in-band mixing product, etc. When implemented, the specific codes will be documented here.