![]() |
| Viento solar,. El máximo se produjo a als 19h del 19/1/2026 Fuente: HB9VQQ |
Lanzamos en https://wspr.rocks/ una query SQL para obtener los valores de los spots recibidos por la red WSPR de la estación EA5KRP entre los días 19 y 21 de enero de 2026 (Ver mas sobre querys a WSPRnet)
SELECT * FROM (
SELECT
toString(toDate(time)) AS fecha,
toInt32(COUNT(CASE WHEN band = '3' THEN 1 END)) AS band_3,
toInt32(COUNT(CASE WHEN band = '7' THEN 1 END)) AS band_7,
toInt32(COUNT(CASE WHEN band = '10' THEN 1 END)) AS band_10,
toInt32(COUNT(CASE WHEN band = '14' THEN 1 END)) AS band_14,
toInt32(COUNT(CASE WHEN band = '18' THEN 1 END)) AS band_18,
toInt32(COUNT(CASE WHEN band = '21' THEN 1 END)) AS band_21,
toInt32(COUNT(CASE WHEN band = '24' THEN 1 END)) AS band_24,
toInt32(COUNT(CASE WHEN band = '28' THEN 1 END)) AS band_28,
toInt32(COUNT(CASE WHEN band <> '99' THEN 1 END)) AS total,
0 AS orden
FROM wspr.rx
WHERE tx_sign = 'EA5RKP'
AND time >= '2026-01-19' AND time < '2026-01-22'
GROUP BY fecha
UNION ALL
SELECT
'TOTAL' AS fecha,
toInt32(COUNT(CASE WHEN band = '3' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '7' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '10' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '14' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '18' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '21' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '24' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '28' THEN 1 END)),
toInt32(COUNT(CASE WHEN band <> '99' THEN 1 END)),
1 AS orden
FROM wspr.rx
WHERE tx_sign = 'EA5RKP'
AND time >= '2026-01-19' AND time < '2026-01-22')
ORDER BY orden ASC, fecha ASC;
SELECT
toString(toDate(time)) AS fecha,
toInt32(COUNT(CASE WHEN band = '3' THEN 1 END)) AS band_3,
toInt32(COUNT(CASE WHEN band = '7' THEN 1 END)) AS band_7,
toInt32(COUNT(CASE WHEN band = '10' THEN 1 END)) AS band_10,
toInt32(COUNT(CASE WHEN band = '14' THEN 1 END)) AS band_14,
toInt32(COUNT(CASE WHEN band = '18' THEN 1 END)) AS band_18,
toInt32(COUNT(CASE WHEN band = '21' THEN 1 END)) AS band_21,
toInt32(COUNT(CASE WHEN band = '24' THEN 1 END)) AS band_24,
toInt32(COUNT(CASE WHEN band = '28' THEN 1 END)) AS band_28,
toInt32(COUNT(CASE WHEN band <> '99' THEN 1 END)) AS total,
0 AS orden
FROM wspr.rx
WHERE tx_sign = 'EA5RKP'
AND time >= '2026-01-19' AND time < '2026-01-22'
GROUP BY fecha
UNION ALL
SELECT
'TOTAL' AS fecha,
toInt32(COUNT(CASE WHEN band = '3' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '7' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '10' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '14' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '18' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '21' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '24' THEN 1 END)),
toInt32(COUNT(CASE WHEN band = '28' THEN 1 END)),
toInt32(COUNT(CASE WHEN band <> '99' THEN 1 END)),
1 AS orden
FROM wspr.rx
WHERE tx_sign = 'EA5RKP'
AND time >= '2026-01-19' AND time < '2026-01-22')
ORDER BY orden ASC, fecha ASC;
Se observa claramente una disminución de los spots el día 20 y esta es mayor a medida que aumenta la frecuencia (Propagación ionosférica en capa F)
fecha band_3 band_7 band_10 band_14 band_18 band_21 band_24 band_28 total
2026-01-19 77 595 3208 4368 2636 1857 774 745 14260
2026-01-20 31 1527 2103 1422 360 175 72 55 5745
2026-01-21 34 880 4035 6554 2622 1796 708 793 17423
Referencias
Advertencia importante
Las modificaciones, configuraciones y procedimientos descritos en este sitio pueden implicar riesgos técnicos, legales o de seguridad. El autor no se responsabiliza del mal funcionamiento de los equipos, daños permanentes, pérdida de garantía ni de posibles infracciones legales derivadas del uso de esta información.
El lector asume plena responsabilidad por cualquier acción que decida realizar basándose en el contenido de este blog.
© 2026 EA5JTT. Queda prohibida la reproducción total o parcial sin autorización expresa del autor.

No hay comentarios:
Publicar un comentario