WSPR & DXCC

Esta es la lista oficial de territorios para ARRL (Marzo de 2022)  y lo que ahora queremos es conocer cuantos "territorios DXCC" hemos alcanzado con nuestro equipo WSPR TX de los 340 existentes.

En la primera quincena de agosto de 2025 estuvieron activos 79 territorios en WSPR (Alemania, Argentina, Australia, Austria, Bélgica, Bielorusia, Brasil, Bulgaria, Caiman, Canada, Chatham, Chequia, Chile, China, Colombia, Costa Rica, Croacia, Dinamarca, Ecuador, Escocia, Eslovaquia, Eslovenia, España - Baleares, España - Canarias,España - Ceuta/Melilla, España - Península,Estados Unidos, Estonia, Filipinas, Finlandia, Francia, Gales, Georgia, Gibraltar,Grecia, Hungría, Indonesia, Inglaterra, Irlanda, Irlanda del Norte, Isla Jersey, Islandia, Islas Cook, Israel, Italia, Japón, Kaliningrado, Kazaskan, Kuwait, Kyrgyzstan, Letonia, Lituania, Luxemburgo, Moldavia, Namibia, Noruega,Nueva Zelanda, Países Bajos, Panama, Polonia, Portugal, Republica Corea, República Dominicana,Rumania,Rusia Asiática, Rusia Europea, Serbia, Singapour, St. Helena, Sudáfrica, Suecia, Suiza, Svalbard, Tailandia, Taiwan, Turquía, Ucrania, Uruguay, West Malasia).

Para ello consultamos la B.D. WSPRnet desde WSPR Rocks mediante un código SQL adecuado que nos agrupe los indicativos por "paises DXCC" y nos contabilice el numero de estaciones distintas que han recibido nuestras transmisiones.

A continuación un  primer ejemplo en el que he incluido los paises que ya he trabajado y algunos mas hasta un límite de 100 entradas, si se quieren incluir mas paises basta con hacer mas consultas hasta completar los 300 y pico que cuenta la lista. 

Copie y peque el código modificando el indicativo y las fechas:

• • SELECT
  • CASE
  • WHEN LEFT(rx_sign, 2) = '3A' THEN 'Monaco'
  • WHEN LEFT(rx_sign, 2) = '4M' THEN 'Venezuela'
  • WHEN LEFT(rx_sign, 2) = '4V' THEN 'Haiti'
  • WHEN LEFT(rx_sign, 2) IN ('4X','4Z') THEN 'Israel'
  • WHEN LEFT(rx_sign, 2) IN ('5B', 'C4', 'P3') THEN 'Chipre'
  • WHEN LEFT(rx_sign, 2) = '5P' THEN 'Dinamarca'
  • WHEN LEFT(rx_sign, 2) = '9A' THEN 'Croacia'
  • WHEN LEFT(rx_sign, 2) = '9H' THEN 'Malta'
  • WHEN LEFT(rx_sign, 2) = 'C3' THEN 'Andorra'
  • WHEN LEFT(rx_sign, 2) IN ('BU','BV','BW','BX') THEN 'Taiwan'
  • WHEN LEFT(rx_sign, 1) = 'B' THEN 'China'
  • WHEN LEFT(rx_sign, 2) IN ('CA', 'CB', 'CC', 'CD', 'CE') THEN 'Chile'
  • WHEN LEFT(rx_sign, 2) = 'CN' THEN 'Marruecos'
  • WHEN LEFT(rx_sign, 2) IN ('CR', 'CS','CT') THEN 'Portugal'
  • WHEN LEFT(rx_sign, 2) IN ('DA', 'DB', 'DC', 'DD', 'DE', 'DF', 'DG', 'DH', 'DI', 'DJ', 'DK', 'DL', 'DM', 'DN', 'DO', 'DP', 'DQ','DR') THEN 'Alemania'
  • WHEN LEFT(rx_sign, 2) IN ('DU','DV','DW','DX','DY','DZ','4D','4E','4F','4G','4H','4I') THEN 'Filipinas'
  • WHEN LEFT(rx_sign, 3) IN ('EA6', 'EB6', 'EC6', 'ED6', 'EE6', 'EF6', 'EG6','EH6') THEN 'España - Baleares'
  • WHEN LEFT(rx_sign, 3) IN ('EA8', 'EB8', 'EC8', 'ED8', 'EE8', 'EF8', 'EG8','EH8') THEN 'España - Canarias'
  • WHEN LEFT(rx_sign, 3) IN ('EA9', 'EB9', 'EC9', 'ED9', 'EE9', 'EF9', 'EG9','EH9') THEN 'España - Ceuta/Melilla'
  • WHEN LEFT(rx_sign, 2) IN ('EA', 'EB', 'EC', 'ED', 'EE', 'EF', 'EG','EH') THEN 'España - Península'
  • WHEN LEFT(rx_sign, 2) = 'E5' THEN 'Islas Cook'
  • WHEN LEFT(rx_sign, 2) = 'E7' THEN 'Bosnia-Herzegovina'
  • WHEN LEFT(rx_sign, 2) IN ('EI', 'EJ') THEN 'Irlanda'
  • WHEN LEFT(rx_sign, 2) = 'ES' THEN 'Estonia'
  • WHEN LEFT(rx_sign, 1) = 'F' THEN 'Francia'
  • WHEN LEFT(rx_sign, 2) IN ('GB', 'GX', 'MX','2E') THEN 'Inglaterra'
  • WHEN LEFT(rx_sign, 2) IN ('GI', 'GN', 'MI','2I') THEN 'Irlanda del Norte'
  • WHEN LEFT(rx_sign, 2) IN ('GJ', 'GH', 'MJ','2J') THEN 'Isla Jersey'
  • WHEN LEFT(rx_sign, 2) IN ('GM', 'GS', 'MM','2M') THEN 'Escocia'
  • WHEN LEFT(rx_sign, 2) IN ('GU', 'GP', 'MU','2U') THEN 'Guersey'
  • WHEN LEFT(rx_sign, 2) IN ('GW', 'GC', 'MW','2W') THEN 'Gales'
  • WHEN LEFT(rx_sign, 2) IN ('GD', 'GT', 'MD','2D') THEN 'Isla de Man'
  • WHEN LEFT(rx_sign, 1) = 'G' AND SUBSTRING(rx_sign, 2, 1) REGEXP '[0-9]' THEN 'Inglaterra'
  • WHEN LEFT(rx_sign, 2) IN ('HA', 'HG') THEN 'Hungria'
  • WHEN LEFT(rx_sign, 2) IN ('HC', 'HD') THEN 'Ecuador'
  • WHEN LEFT(rx_sign, 2) IN ('HJ', 'HK') THEN 'Colombia'
  • WHEN LEFT(rx_sign, 2) IN ('HO', 'HP') THEN 'Panama'
  • WHEN LEFT(rx_sign, 2) IN ('HQ', 'HR') THEN 'Honduras'
  • WHEN LEFT(rx_sign, 2) = 'HB' THEN 'Suiza'
  • WHEN LEFT(rx_sign, 2) = 'HH' THEN 'Haiti'
  • WHEN LEFT(rx_sign, 2) = 'HI' THEN 'Republica Dominicana'
  • WHEN LEFT(rx_sign, 2)  IN ('HL', '6K')  THEN 'Republica Corea'
  • WHEN LEFT(rx_sign, 3) IN ('IS0', 'IM0') THEN 'Cerdeña'
  • WHEN LEFT(rx_sign, 1) = 'I' THEN 'Italia'
  • WHEN LEFT(rx_sign, 2) IN ('LA', 'LB','LC', 'LD', 'LE', 'LF', 'LG', 'LH', 'LI', 'LJ', 'LK', 'LL', 'LM', 'LN') THEN 'Noruega'
  • WHEN LEFT(rx_sign, 2) IN ('JA','JB','JC','JD','JE','JF','JG','JH','JI','JJ','JK','JL','JM','JN','JO','JP','JQ','JR','JS','7J','7K','7L','7N') THEN 'Japon'
  • WHEN LEFT(rx_sign, 2) = 'LX' THEN 'Luxemburgo'
  • WHEN LEFT(rx_sign, 2) = 'LY' THEN 'Lituania'
  • WHEN LEFT(rx_sign, 2) = 'LZ' THEN 'Bulgaria'
  • WHEN LEFT(rx_sign, 1) = 'M' AND SUBSTRING(rx_sign, 2, 1) REGEXP '[0-9]' THEN 'Inglaterra'
  • WHEN LEFT(rx_sign, 2) = 'OE' THEN 'Austria'
  • WHEN LEFT(rx_sign, 2) IN ('OK', 'OL') THEN 'Chequia'
  • WHEN LEFT(rx_sign, 2) IN ('OF', 'OG', 'OH', 'OI') THEN 'Finlandia'
  • WHEN LEFT(rx_sign, 2) = 'OM' THEN 'Eslovaquia'
  • WHEN LEFT(rx_sign, 2) IN ('ON', 'OO', 'OP','OQ', 'OR', 'OS','OT') THEN 'Belgica'
  • WHEN LEFT(rx_sign, 2) IN ('OU', 'OV', 'OW', 'OZ', '5Q') THEN 'Dinamarca'
  • WHEN LEFT(rx_sign, 2) IN ('PA', 'PB', 'PC','PD', 'PE', 'PF', 'PG', 'PH', 'PI') THEN 'Paises Bajos'
  • WHEN LEFT(rx_sign, 2) IN ('PP','PQ','PR','PS','PT','PU','PV','PW','PX','PY','ZV','ZW','ZX','ZY','ZZ') THEN 'Brasil'
  • WHEN LEFT(rx_sign, 2) = 'PZ' THEN 'Surinam'
  • WHEN LEFT(rx_sign, 2) IN ('R1','R3','R4','R5','R6','R7') THEN 'Rusia Europea'
  • WHEN LEFT(rx_sign, 2) = 'R2' THEN 'Kaliningrado'
  • WHEN LEFT(rx_sign, 2) IN ('R8','R9','R0') THEN 'Rusia Asiática'
  • WHEN rx_sign REGEXP '^(U[A-I]|R[A-Z])[1,3-7]' THEN 'Rusia Europea'
  • WHEN LEFT(rx_sign, 3) IN ('UA2', 'RA2') THEN 'Kaliningrado'
  • WHEN rx_sign REGEXP '^(U[A-I]|R[A-Z])[089]' THEN 'Rusia Asiática'
  • WHEN LEFT(rx_sign, 3) IN ('UA2', 'RA2') THEN 'Kaliningrado'
  • WHEN LEFT(rx_sign, 2) IN ('UN','UM','UO','UP','UQ') THEN 'Kazaskan'
  • WHEN LEFT(rx_sign, 2) = 'S5' THEN 'Eslovenia'
  • WHEN LEFT(rx_sign, 2) IN ('SA','SB','SC', 'SD', 'SE', 'SF', 'SG', 'SH', 'SI', 'SJ', 'SK', 'SL', 'SM', '7S','8S') THEN 'Suecia'
  • WHEN LEFT(rx_sign, 2) IN ('SN', 'SO', 'SP','SQ', 'SR') THEN 'Polonia'
  • WHEN LEFT(rx_sign, 2) IN ('SV', 'SW', 'SX','SY', 'SZ', 'J4') THEN 'Grecia'
  • WHEN LEFT(rx_sign, 2) IN ('TA', 'TB', 'TC') THEN 'Turquia'
  • WHEN LEFT(rx_sign, 2) IN ('TI', 'TE') THEN 'Costa Rica'
  • WHEN LEFT(rx_sign, 2) = 'TF' THEN 'Islandia'
  • WHEN LEFT(rx_sign, 2) = 'TK' THEN 'Corcega'
  • WHEN LEFT(rx_sign, 2) IN ('UR','US', 'UT', 'UU', 'UV', 'UW', 'UX', 'UY', 'UZ') THEN 'Ucrania'
  • WHEN LEFT(rx_sign, 2) = 'V5' THEN 'Namibia'
  • WHEN LEFT(rx_sign, 2) IN ('VA', 'VB', 'VC', 'VD', 'VE', 'VF', 'VG','VO','VP','VQ','VR','VS','VT','VU','VV','VX','VY') THEN 'Canada'
  • WHEN LEFT(rx_sign, 2) IN ('VK', 'AX') THEN 'Australia'
  • WHEN LEFT(rx_sign, 1) IN ('K', 'N', 'W') THEN 'Estados Unidos'
  • WHEN LEFT(rx_sign, 2) IN ('AA', 'AB', 'AC', 'AD', 'AE', 'AF', 'AG', 'AH', 'AI' , 'AJ', 'AK') THEN 'Estados Unidos'
  • WHEN LEFT(rx_sign, 2) = 'YL' THEN 'Letonia'
  • WHEN LEFT(rx_sign, 2) = 'YM' THEN 'Turquia'
  • WHEN LEFT(rx_sign, 2) IN ('YO', 'YP', 'YQ', 'YR') THEN 'Rumania'
  • WHEN LEFT(rx_sign, 2) IN ('YT', 'YU') THEN 'Serbia'
  • WHEN LEFT(rx_sign, 2) IN ('LO','LP','LQ','LR','LS','LT','LU','LV','LW') THEN 'Argentina'
  • WHEN LEFT(rx_sign, 3) = 'ZB2' THEN 'Gibraltar'
  • WHEN LEFT(rx_sign, 3) = 'ZD7' THEN 'St. Helena'
  • WHEN LEFT(rx_sign, 2) = 'ZF' THEN 'Caiman'
  • WHEN LEFT(rx_sign, 3) = 'ZL7' THEN ' Chatham '
  • WHEN LEFT(rx_sign, 3) = 'ZL8' THEN 'Kermadec'
  • WHEN LEFT(rx_sign, 3) = 'ZL9' THEN 'New Zealand Subantarctic Islands '
  • WHEN LEFT(rx_sign, 2) IN ('ZL', 'ZM') THEN 'Nueva Zelanda'
  • WHEN LEFT(rx_sign, 2) = 'ZP' THEN 'Paraguay'
  • WHEN LEFT(rx_sign, 2) IN ('ZR','ZS','ZT','ZU') THEN 'Sudafrica'
  • ELSE 'ZZ - Otros'
  • END AS pais,
  • COUNT(DISTINCT rx_sign) AS cantidad
  • FROM wspr.rx
  • WHERE tx_sign = 'EA5JTT'
  • AND time >= '2025-05-23'
  • AND time < NOW()
  • GROUP BY pais
  • ORDER BY pais ASC;

   

  En otros quedan indicativos para los cuales no hay una  clausula WHEN específica y sobre todo indicativos erroneos que se generan en la red WSPRnet

  
  

  

  Extracto de la salida del total de los 62 DXCC (Con las dos consultas) que se tenían a 9-8-2025

Una segunda consulta con algunos territorios mas
• SELECT 
• CASE 
• WHEN LEFT(rx_sign, 3) IN ('3B8') THEN 'Mauricio'
• WHEN LEFT(rx_sign, 3) IN ('3C0') THEN 'Anobon'
• WHEN LEFT(rx_sign, 2) IN ('3C') THEN 'Guinea Ecuatorial'
• WHEN LEFT(rx_sign, 2) IN ('3V') THEN 'Tunez'
• WHEN LEFT(rx_sign, 2) IN ('3W','XV') THEN 'Vietnam'
• WHEN LEFT(rx_sign, 2) = '3X' THEN 'Guinea'
• WHEN LEFT(rx_sign, 2) IN ('3O','47') THEN 'Montenegro'
• WHEN LEFT(rx_sign, 2) IN ('4J','4K') THEN 'Azerbaijan'
• WHEN rx_sign REGEXP '^4U[0-9]ITU$' THEN 'ONU (ITU)'
• WHEN rx_sign REGEXP '^4U[0-9]UN$' THEN 'ONU (HQ)'
• WHEN LEFT(rx_sign, 2) = '4L' THEN 'Georgia'
• WHEN LEFT(rx_sign, 2) = '4S' THEN 'SriLanka'
• WHEN LEFT(rx_sign, 2) = '4V' THEN 'Haiti'
• WHEN LEFT(rx_sign, 2) = '5A' THEN 'Libia'
• WHEN LEFT(rx_sign, 2) = '5N' THEN 'Nigeria'
• WHEN LEFT(rx_sign, 2) = '5R' THEN 'Mauritania'
• WHEN LEFT(rx_sign, 2) = '5T' THEN 'Madagascar'
• WHEN LEFT(rx_sign, 2) = '5U' THEN 'Niger'
• WHEN LEFT(rx_sign, 2) = '5V' THEN 'Togo'
• WHEN LEFT(rx_sign, 2) = '5W' THEN 'Samoa'
• WHEN LEFT(rx_sign, 2) = '5X' THEN 'Uganda'
• WHEN LEFT(rx_sign, 2) IN ('5Y','5Z') THEN 'Kenia'
• WHEN LEFT(rx_sign, 2) IN ('6V','6W') THEN 'Senegal'
• WHEN LEFT(rx_sign, 2) = '6Y' THEN 'Jamaica'
• WHEN LEFT(rx_sign, 2) = '9K' THEN 'Kuwait'
• WHEN LEFT(rx_sign, 2) = '9M' THEN 'West Malasia'
• WHEN LEFT(rx_sign, 2) = '9N' THEN 'Nepal'
• WHEN LEFT(rx_sign, 2) IN ('9Q','9R','9S','9T') THEN 'R. D.Congo'
• WHEN LEFT(rx_sign, 2) = '9U' THEN 'Burundi'
• WHEN LEFT(rx_sign, 2) = '9V' THEN 'Singapour'
• WHEN LEFT(rx_sign, 2) IN ('CV','CX') THEN 'Uruguay'
• WHEN LEFT(rx_sign, 2) = 'E3' THEN 'Eritrea'
• WHEN LEFT(rx_sign, 2) = 'E4' THEN 'Palestina'
• WHEN LEFT(rx_sign, 2) = 'ET' THEN 'Etiopia'
• WHEN LEFT(rx_sign, 2) IN ('EU', 'EV','EW') THEN 'Bieolorusia'
• WHEN LEFT(rx_sign, 2) = 'EX' THEN 'Kyrgyzstan'
• WHEN LEFT(rx_sign, 2) = 'EY' THEN 'Tajikistan'
• WHEN LEFT(rx_sign, 2) = 'EZ' THEN 'Turkmenistan'
• WHEN LEFT(rx_sign, 2) = 'E6' THEN 'Niue'
• WHEN LEFT(rx_sign, 2) IN ('EP', 'EQ') THEN 'Iran'
• WHEN LEFT(rx_sign, 2) IN ('UJ','UK','UL','UM') THEN 'Uzbekistan'
• WHEN LEFT(rx_sign, 2) = 'S2' THEN 'Bangladesh'
• WHEN LEFT(rx_sign, 2) = 'EK' THEN 'Armenia'
• WHEN LEFT(rx_sign, 2) = 'EL' THEN 'Liberia'
• WHEN LEFT(rx_sign, 2) = 'ER' THEN 'Moldavia'
• WHEN LEFT(rx_sign, 2) = 'JW' THEN 'Svalbard'
• WHEN LEFT(rx_sign, 2) IN ('HS','E2') THEN 'Tailandia'
• WHEN LEFT(rx_sign, 2) = 'HV' THEN 'Vaticano'
• WHEN LEFT(rx_sign, 2) = 'ZA' THEN 'Albania'
• WHEN LEFT(rx_sign, 2) = 'S7' THEN 'Seychelles'
• WHEN LEFT(rx_sign, 2) = 'S9' THEN 'Sao Tome & Principe'
• WHEN LEFT(rx_sign, 2) = 'V2' THEN 'Antigua'
• WHEN LEFT(rx_sign, 2) = 'V3' THEN 'Belice'
• WHEN LEFT(rx_sign, 2) = 'V4' THEN 'St. Kitts & Nevis'
• WHEN LEFT(rx_sign, 2) IN ('YB','YC','YD','YE','YF','YG','YH') THEN 'Indonesia'
• ELSE 'ZZ - Otros'
• END AS pais,
•   COUNT(DISTINCT rx_sign) AS cantidad
• FROM wspr.rx
• WHERE 
•   tx_sign =' EA5JTT'
•   AND time >= '2025-08-01'
•   AND time < NOW()
• GROUP BY pais
• ORDER BY pais ASC;

Con una pequeña modificación tendremos la lista de territorios DXCC ARRL como SWL (60 a 9-8-2025):

• SELECT
• CASE
• WHEN LEFT(tx_sign, 2) = '3A' THEN 'Monaco'
• WHEN LEFT(tx_sign, 2) = '4M' THEN 'Venezuela'
• WHEN LEFT(tx_sign, 2) = '4V' THEN 'Haiti'
• WHEN LEFT(tx_sign, 2) IN ('4X','4Z') THEN 'Israel'
• WHEN LEFT(tx_sign, 2) IN ('5B', 'C4', 'P3') THEN 'Chipre'
• WHEN LEFT(tx_sign, 2) = '5P' THEN 'Dinamarca'
• WHEN LEFT(tx_sign, 2) = '9A' THEN 'Croacia'
• WHEN LEFT(tx_sign, 2) = '9H' THEN 'Malta'
• WHEN LEFT(tx_sign, 2) = 'C3' THEN 'Andorra'
• WHEN LEFT(tx_sign, 2) IN ('BU','BV','BW','BX') THEN 'Taiwan'
• WHEN LEFT(tx_sign, 1) = 'B' THEN 'China'
• WHEN LEFT(tx_sign, 2) IN ('CA', 'CB', 'CC', 'CD', 'CE') THEN 'Chile'
• WHEN LEFT(tx_sign, 2) = 'CN' THEN 'Marruecos'
• WHEN LEFT(tx_sign, 2) IN ('CR', 'CS','CT') THEN 'Portugal'
• WHEN LEFT(tx_sign, 2) IN ('DA', 'DB', 'DC', 'DD', 'DE', 'DF', 'DG', 'DH', 'DI', 'DJ', 'DK', 'DL', 'DM', 'DN', 'DO', 'DP', 'DQ','DR') THEN 'Alemania'
• WHEN LEFT(tx_sign, 2) IN ('DU','DV','DW','DX','DY','DZ','4D','4E','4F','4G','4H','4I') THEN 'Filipinas'
• WHEN LEFT(tx_sign, 3) IN ('EA6', 'EB6', 'EC6', 'ED6', 'EE6', 'EF6', 'EG6','EH6') THEN 'España - Baleares'
• WHEN LEFT(tx_sign, 3) IN ('EA8', 'EB8', 'EC8', 'ED8', 'EE8', 'EF8', 'EG8','EH8') THEN 'España - Canarias'
• WHEN LEFT(tx_sign, 3) IN ('EA9', 'EB9', 'EC9', 'ED9', 'EE9', 'EF9', 'EG9','EH9') THEN 'España - Ceuta/Melilla'
• WHEN LEFT(tx_sign, 2) IN ('EA', 'EB', 'EC', 'ED', 'EE', 'EF', 'EG','EH') THEN 'España - Península'
• WHEN LEFT(tx_sign, 2) = 'E5' THEN 'Islas Cook'
• WHEN LEFT(tx_sign, 2) = 'E7' THEN 'Bosnia-Herzegovina'
• WHEN LEFT(tx_sign, 2) IN ('EI', 'EJ') THEN 'Irlanda'
• WHEN LEFT(tx_sign, 2) = 'ES' THEN 'Estonia'
• WHEN LEFT(tx_sign, 2) IN ('EU', 'EV','EW') THEN 'Bieolorusia'
• WHEN LEFT(tx_sign, 1) = 'F' THEN 'Francia'
• WHEN LEFT(tx_sign, 2) IN ('GB', 'GX', 'MX','2E') THEN 'Inglaterra'
• WHEN LEFT(tx_sign, 2) IN ('GI', 'GN', 'MI','2I') THEN 'Irlanda del Norte'
• WHEN LEFT(tx_sign, 2) IN ('GJ', 'GH', 'MJ','2J') THEN 'Isla Jersey'
• WHEN LEFT(tx_sign, 2) IN ('GM', 'GS', 'MM','2M') THEN 'Escocia'
• WHEN LEFT(tx_sign, 2) IN ('GU', 'GP', 'MU','2U') THEN 'Guersey'
• WHEN LEFT(tx_sign, 2) IN ('GW', 'GC', 'MW','2W') THEN 'Gales'
• WHEN LEFT(tx_sign, 2) IN ('GD', 'GT', 'MD','2D') THEN 'Isla de Man'
• WHEN LEFT(tx_sign, 1) = 'G' AND SUBSTRING(tx_sign, 2, 1) REGEXP '[0-9]' THEN 'Inglaterra'
• WHEN LEFT(tx_sign, 2) IN ('HA', 'HG') THEN 'Hungria'
• WHEN LEFT(tx_sign, 2) IN ('HC', 'HD') THEN 'Ecuador'
• WHEN LEFT(tx_sign, 2) IN ('HJ', 'HK') THEN 'Colombia'
• WHEN LEFT(tx_sign, 2) IN ('HO', 'HP') THEN 'Panama'
• WHEN LEFT(tx_sign, 2) IN ('HQ', 'HR') THEN 'Honduras'
• WHEN LEFT(tx_sign, 2) = 'HB' THEN 'Suiza'
• WHEN LEFT(tx_sign, 2) = 'HH' THEN 'Haiti'
• WHEN LEFT(tx_sign, 2) = 'HI' THEN 'Republica Dominicana'
• WHEN LEFT(tx_sign, 2)  IN ('HL', '6K')  THEN 'Republica Corea'
• WHEN LEFT(tx_sign, 3) IN ('IS0', 'IM0') THEN 'Cerdeña'
• WHEN LEFT(tx_sign, 1) = 'I' THEN 'Italia'
• WHEN LEFT(tx_sign, 2) IN ('LA', 'LB','LC', 'LD', 'LE', 'LF', 'LG', 'LH', 'LI', 'LJ', 'LK', 'LL', 'LM', 'LN') THEN 'Noruega'
• WHEN LEFT(tx_sign, 2) IN ('LO','LP','LQ','LR','LS','LT','LU','LV','LW') THEN 'Argentina'
• WHEN LEFT(tx_sign, 2) IN ('JA','JB','JC','JD','JE','JF','JG','JH','JI','JJ','JK','JL','JM','JN','JO','JP','JQ','JR','JS','7J','7K','7L','7N') THEN 'Japon'
• WHEN LEFT(tx_sign, 2) = 'LX' THEN 'Luxemburgo'
• WHEN LEFT(tx_sign, 2) = 'LY' THEN 'Lituania'
• WHEN LEFT(tx_sign, 2) = 'LZ' THEN 'Bulgaria'
• WHEN LEFT(tx_sign, 1) = 'M' AND SUBSTRING(tx_sign, 2, 1) REGEXP '[0-9]' THEN 'Inglaterra'
• WHEN LEFT(tx_sign, 2) = 'OE' THEN 'Austria'
• WHEN LEFT(tx_sign, 2) IN ('OK', 'OL') THEN 'Chequia'
• WHEN LEFT(tx_sign, 2) IN ('OF', 'OG', 'OH', 'OI') THEN 'Finlandia'
• WHEN LEFT(tx_sign, 2) = 'OM' THEN 'Eslovaquia'
• WHEN LEFT(tx_sign, 2) IN ('ON', 'OO', 'OP','OQ', 'OR', 'OS','OT') THEN 'Belgica'
• WHEN LEFT(tx_sign, 2) IN ('OU', 'OV', 'OW', 'OZ', '5Q') THEN 'Dinamarca'
• WHEN LEFT(tx_sign, 2) IN ('PA', 'PB', 'PC','PD', 'PE', 'PF', 'PG', 'PH', 'PI') THEN 'Paises Bajos'
• WHEN LEFT(tx_sign, 2) IN ('PP','PQ','PR','PS','PT','PU','PV','PW','PX','PY','ZV','ZW','ZX','ZY','ZZ') THEN 'Brasil'
• WHEN LEFT(tx_sign, 2) = 'PZ' THEN 'Surinam'
• WHEN LEFT(tx_sign, 2) IN ('R1','R3','R4','R5','R6','R7') THEN 'Rusia Europea'
• WHEN LEFT(tx_sign, 2) = 'R2' THEN 'Kaliningrado'
• WHEN LEFT(tx_sign, 2) IN ('R8','R9','R0') THEN 'Rusia Asiática'
• WHEN tx_sign REGEXP '^(U[A-I]|R[A-Z])[1,3-7]' THEN 'Rusia Europea'
• WHEN LEFT(tx_sign, 3) IN ('UA2', 'RA2') THEN 'Kaliningrado'
• WHEN tx_sign REGEXP '^(U[A-I]|R[A-Z])[089]' THEN 'Rusia Asiática'
• WHEN LEFT(tx_sign, 3) IN ('UA2', 'RA2') THEN 'Kaliningrado'
• WHEN LEFT(tx_sign, 2) IN ('UN','UM','UO','UP','UQ') THEN 'Kazaskan'
• WHEN LEFT(tx_sign, 2) = 'S5' THEN 'Eslovenia'
• WHEN LEFT(tx_sign, 2) IN ('SA','SB','SC', 'SD', 'SE', 'SF', 'SG', 'SH', 'SI', 'SJ', 'SK', 'SL', 'SM', '7S','8S') THEN 'Suecia'
• WHEN LEFT(tx_sign, 2) IN ('SN', 'SO', 'SP','SQ', 'SR') THEN 'Polonia'
• WHEN LEFT(tx_sign, 2) IN ('SV', 'SW', 'SX','SY', 'SZ', 'J4') THEN 'Grecia'
• WHEN LEFT(tx_sign, 2) IN ('TA', 'TB', 'TC') THEN 'Turquia'
• WHEN LEFT(tx_sign, 2) IN ('TI', 'TE') THEN 'Costa Rica'
• WHEN LEFT(tx_sign, 2) = 'TF' THEN 'Islandia'
• WHEN LEFT(tx_sign, 2) = 'TK' THEN 'Corcega'
• WHEN LEFT(tx_sign, 2) IN ('UR','US', 'UT', 'UU', 'UV', 'UW', 'UX', 'UY', 'UZ') THEN 'Ucrania'
• WHEN LEFT(tx_sign, 2) = 'V5' THEN 'Namibia'
• WHEN LEFT(tx_sign, 2) IN ('VA', 'VB', 'VC', 'VD', 'VE', 'VF', 'VG','VO','VP','VQ','VR','VS','VT','VU','VV','VX','VY') THEN 'Canada'
• WHEN LEFT(tx_sign, 2) IN ('VK', 'AX') THEN 'Australia'
• WHEN LEFT(tx_sign, 1) IN ('K', 'N', 'W') THEN 'Estados Unidos'
• WHEN LEFT(tx_sign, 2) IN ('AA', 'AB', 'AC', 'AD', 'AE', 'AF', 'AG', 'AH', 'AI' , 'AJ', 'AK') THEN 'Estados Unidos'
• WHEN LEFT(tx_sign, 2) = 'YL' THEN 'Letonia'
• WHEN LEFT(tx_sign, 2) = 'YM' THEN 'Turquia'
• WHEN LEFT(tx_sign, 2) IN ('YO', 'YP', 'YQ', 'YR') THEN 'Rumania'
• WHEN LEFT(tx_sign, 2) IN ('YT', 'YU') THEN 'Serbia'
• WHEN LEFT(tx_sign, 2) = 'ZA' THEN 'Albania'
• WHEN LEFT(tx_sign, 3) = 'ZB2' THEN 'Gibraltar'
• WHEN LEFT(tx_sign, 3) = 'ZD7' THEN 'St. Helena'
• WHEN LEFT(tx_sign, 2) = 'ZF' THEN 'Caiman'
• WHEN LEFT(tx_sign, 3) = 'ZL9' THEN 'New Zealand Subantarctic Islands '
• WHEN LEFT(tx_sign, 2) IN ('ZL', 'ZM') THEN 'Nueva Zelanda'
• WHEN LEFT(tx_sign, 2) = 'ZP' THEN 'Paraguay'
• WHEN LEFT(tx_sign, 2) IN ('ZR','ZS','ZT','ZU') THEN 'Sudafrica'
• ELSE 'ZZ - Otros'
• END AS pais,
• COUNT(DISTINCT tx_sign) AS cantidad
• FROM wspr.rx
• WHERE rx_sign = 'EA5JTT'
• AND time >= '2025-05-23'
• AND time < NOW()
• GROUP BY pais
• ORDER BY pais ASC;

Para afinar la SELECT  se puede usar un código que permita listar el grupo 'ZZ - Otros' donde encontraremos territorios que no han sido tratados y también indicativos erróneos

• SELECT DISTINCT rx_sign
• FROM (
• SELECT 
•   rx_sign,
•   CASE 
•     WHEN LEFT(rx_sign, 2) = '3A' THEN 'Monaco'
• WHEN LEFT(rx_sign, 2) = '4M' THEN 'Venezuela'
• WHEN LEFT(rx_sign, 2) = '4V' THEN 'Haiti'
•     WHEN LEFT(rx_sign, 2) IN ('4X','4Z') THEN 'Israel'
• WHEN LEFT(rx_sign, 2) IN ('5B', 'C4', 'P3') THEN 'Chipre'
•     WHEN LEFT(rx_sign, 2) = '5P' THEN 'Dinamarca'
•     WHEN LEFT(rx_sign, 2) = '9A' THEN 'Croacia'
•     WHEN LEFT(rx_sign, 2) = '9H' THEN 'Malta'
•     WHEN LEFT(rx_sign, 2) = 'C3' THEN 'Andorra'
•   WHEN LEFT(rx_sign, 2) IN ('BU','BV','BW','BX') THEN 'Taiwan'
•   WHEN LEFT(rx_sign, 1) = 'B' THEN 'China'
•     WHEN LEFT(rx_sign, 2) IN ('CA', 'CB', 'CC', 'CD', 'CE') THEN 'Chile'
•     WHEN LEFT(rx_sign, 2) = 'CN' THEN 'Marruecos'
•     WHEN LEFT(rx_sign, 2) IN ('CS','CT')  THEN 'Portugal'
•     WHEN LEFT(rx_sign, 2) = 'CU' THEN 'Azores'
•     WHEN LEFT(rx_sign, 2) IN ('DA', 'DB', 'DC', 'DD', 'DE', 'DF', 'DG', 'DH', 'DI', 'DJ', 'DK', 'DL', 'DM', 'DN', 'DO', 'DP', 'DQ','DR') THEN 'Alemania'
•     WHEN LEFT(rx_sign, 2) IN ('DU','DV','DW','DX','DY','DZ','4D','4E','4F','4G','4H','4I') THEN 'Filipinas'
•     WHEN LEFT(rx_sign, 3) IN ('EA6', 'EB6', 'EC6', 'ED6', 'EE6', 'EF6', 'EG6','EH6') THEN 'España - Baleares'
•     WHEN LEFT(rx_sign, 3) IN ('EA8', 'EB8', 'EC8', 'ED8', 'EE8', 'EF8', 'EG8','EH8') THEN 'España - Canarias'
•   WHEN LEFT(rx_sign, 3) IN ('EA9', 'EB9', 'EC9', 'ED9', 'EE9', 'EF9', 'EG9','EH9') THEN 'España - Ceuta/Melilla'
•  WHEN LEFT(rx_sign, 2) IN ('EA', 'EB', 'EC', 'ED', 'EE', 'EF', 'EG','EH') THEN 'España - Península'
•   WHEN LEFT(rx_sign, 2) = 'E7' THEN 'Bosnia-Herzegovina'
•   WHEN LEFT(rx_sign, 2) = 'EW' THEN 'Bielorusia'
•     WHEN LEFT(rx_sign, 2) IN ('EI', 'EJ') THEN 'Irlanda'
•     WHEN LEFT(rx_sign, 2) = 'ES' THEN 'Estonia'
•     WHEN LEFT(rx_sign, 1) = 'F' THEN 'Francia'
•     WHEN LEFT(rx_sign, 2) IN ('GB', 'GX', 'MX','2E') THEN 'Inglaterra'
•     WHEN LEFT(rx_sign, 2) IN ('GI', 'GN', 'MI','2I') THEN 'Irlanda del Norte'
•     WHEN LEFT(rx_sign, 2) IN ('GJ', 'GH', 'MJ','2J') THEN 'Isla Jersey'
•     WHEN LEFT(rx_sign, 2) IN ('GM', 'GS', 'MM','2M') THEN 'Escocia'
•     WHEN LEFT(rx_sign, 2) IN ('GU', 'GP', 'MU','2U') THEN 'Guersey'
•     WHEN LEFT(rx_sign, 2) IN ('GW', 'GC', 'MW','2W') THEN 'Gales'
•     WHEN LEFT(rx_sign, 2) IN ('GD', 'GT', 'MD','2D') THEN 'Isla de Man'
•     WHEN LEFT(rx_sign, 1) = 'G' AND SUBSTRING(rx_sign, 2, 1) REGEXP '[0-9]' THEN 'Inglaterra'
• WHEN LEFT(rx_sign, 2) IN ('HA', 'HG') THEN 'Hungria'
•   WHEN LEFT(rx_sign, 2) IN ('HC', 'HD') THEN 'Ecuador'
• WHEN LEFT(rx_sign, 2) IN ('HJ', 'HK') THEN 'Colombia'
• WHEN LEFT(rx_sign, 2) IN ('HO', 'HP') THEN 'Panama'
• WHEN LEFT(rx_sign, 2) IN ('HQ', 'HR') THEN 'Honduras'
•     WHEN LEFT(rx_sign, 2) = 'HB' THEN 'Suiza'
•   WHEN LEFT(rx_sign, 2) = 'HH' THEN 'Haiti'
• WHEN LEFT(rx_sign, 2) = 'HI' THEN 'Republica Dominicana'
• WHEN LEFT(rx_sign, 2) = 'HL' THEN 'Republica Corea'
•     WHEN LEFT(rx_sign, 3) IN ('IS0', 'IM0') THEN 'Cerdeña'
•     WHEN LEFT(rx_sign, 1) = 'I' THEN 'Italia'
•     WHEN LEFT(rx_sign, 2) IN ('LA', 'LB','LC', 'LD', 'LE', 'LF', 'LG', 'LH', 'LI', 'LJ', 'LK', 'LL', 'LM', 'LN') THEN 'Noruega'
•     WHEN LEFT(rx_sign, 2) IN ('JA','JB','JC','JD','JE','JF','JG','JH','JI','JJ','JK','JL','JM','JN','JO','JP','JQ','JR','JS','7J','7K','7L','7N') THEN 'Japon'
• WHEN LEFT(rx_sign, 2) = 'LX' THEN 'Luxemburgo'
•     WHEN LEFT(rx_sign, 2) = 'LZ' THEN 'Bulgaria'
•     WHEN LEFT(rx_sign, 1) = 'M' AND SUBSTRING(rx_sign, 2, 1) REGEXP '[0-9]' THEN 'Inglaterra'
• WHEN LEFT(rx_sign, 2) = 'OE' THEN 'Austria'
•     WHEN LEFT(rx_sign, 2) IN ('OK', 'OL') THEN 'Chequia'
•     WHEN LEFT(rx_sign, 2) IN ('OF', 'OG', 'OH', 'OI') THEN 'Finlandia'
•     WHEN LEFT(rx_sign, 2) = 'OM' THEN 'Eslovaquia'
•     WHEN LEFT(rx_sign, 2) IN ('ON', 'OO', 'OP','OQ', 'OR', 'OS','OT') THEN 'Belgica'
•     WHEN LEFT(rx_sign, 2) IN ('OU', 'OV', 'OW','OZ') THEN 'Dinamarca'
•     WHEN LEFT(rx_sign, 2) IN ('PA', 'PB', 'PC','PD', 'PE', 'PF', 'PG', 'PH', 'PI') THEN 'Paises Bajos'
•     WHEN LEFT(rx_sign, 2) IN ('PP','PQ','PR','PS','PT','PU','PV','PW','PX','PY','ZV','ZW','ZX','ZY','ZZ') THEN 'Brasil'
• WHEN LEFT(rx_sign, 2) = 'PZ' THEN 'Surinam'
•     WHEN LEFT(rx_sign, 2) IN ('R1','R3','R4','R5','R6','R7') THEN 'Rusia Europea'
• WHEN LEFT(rx_sign, 2) = 'R2' THEN 'Kaliningrado'
•   WHEN LEFT(rx_sign, 2) IN ('R8','R9','R0') THEN 'Rusia Asiática'
• WHEN rx_sign REGEXP '^(U[A-I]|R[A-Z])[1,3-7]' THEN 'Rusia Europea'
• WHEN LEFT(rx_sign, 3) IN ('UA2', 'RA2') THEN 'Kaliningrado'
• WHEN rx_sign REGEXP '^(U[A-I]|R[A-Z])[089]' THEN 'Rusia Asiática'
• WHEN LEFT(rx_sign, 3) IN ('UA2', 'RA2') THEN 'Kaliningrado'
• WHEN LEFT(rx_sign, 2) IN ('UN','UM','UO','UP','UQ') THEN 'Kazaskan'
•     WHEN LEFT(rx_sign, 2) = 'S5' THEN 'Eslovenia'
•     WHEN LEFT(rx_sign, 2) IN ('SA','SB','SC', 'SD', 'SE', 'SF', 'SG', 'SH', 'SI', 'SJ', 'SK', 'SL', 'SM', '7S','8S') THEN 'Suecia'
•     WHEN LEFT(rx_sign, 2) IN ('SN', 'SO', 'SP','SQ', 'SR') THEN 'Polonia'
•     WHEN LEFT(rx_sign, 2) IN ('SV', 'SW', 'SX','SY', 'SZ', 'J4') THEN 'Grecia'
•     WHEN LEFT(rx_sign, 2) IN ('TA', 'TB', 'TC') THEN 'Turquia'
•   WHEN LEFT(rx_sign, 2) IN ('TI', 'TE') THEN 'Costa Rica'
•     WHEN LEFT(rx_sign, 2) = 'TF' THEN 'Islandia'
• WHEN LEFT(rx_sign, 2) = 'TK' THEN 'Corcega'
•     WHEN LEFT(rx_sign, 2) IN ('UR','US', 'UT', 'UU', 'UV', 'UW', 'UX', 'UY', 'UZ') THEN 'Ucrania'
•     WHEN LEFT(rx_sign, 2) = 'V5' THEN 'Namibia'
• WHEN LEFT(rx_sign, 2) IN ('VA', 'VB', 'VC', 'VD', 'VE', 'VF', 'VG','VO','VP','VQ','VR','VS','VT','VU','VV','VX','VY') THEN 'Canada'
•     WHEN LEFT(rx_sign, 2) IN ('VK', 'AX') THEN 'Australia'
•     WHEN LEFT(rx_sign, 1) IN ('K', 'N', 'W') THEN 'Estados Unidos'
•     WHEN LEFT(rx_sign, 2) IN ('AA', 'AB', 'AC', 'AD', 'AE', 'AF', 'AG', 'AH', 'AI' , 'AJ', 'AK') THEN 'Estados Unidos'
•     WHEN LEFT(rx_sign, 2) = 'YL' THEN 'Letonia'
•     WHEN LEFT(rx_sign, 2) = 'YM' THEN 'Turquia'
•     WHEN LEFT(rx_sign, 2) IN ('YO', 'YP', 'YQ', 'YR') THEN 'Rumania'
•     WHEN LEFT(rx_sign, 2) IN ('YT', 'YU') THEN 'Serbia'
•     WHEN LEFT(rx_sign, 2) IN ('LO','LP','LQ','LR','LS','LT','LU','LV','LW') THEN 'Argentina'
•     WHEN LEFT(rx_sign, 3) = 'ZB2' THEN 'Gibraltar'
•     WHEN LEFT(rx_sign, 3) = 'ZD7' THEN 'St. Helena'
•     WHEN LEFT(rx_sign, 2) = 'ZF'  THEN 'Caiman'
•   WHEN LEFT(rx_sign, 3) = 'ZL7' THEN ' Chatham '
•   WHEN LEFT(rx_sign, 3) = 'ZL8' THEN 'Kermadec'
•   WHEN LEFT(rx_sign, 3) = 'ZL9' THEN 'New Zealand Subantarctic Islands '
•     WHEN LEFT(rx_sign, 2) IN ('ZL', 'ZM') THEN 'Nueva Zelanda'
•   WHEN LEFT(rx_sign, 2) = 'ZP' THEN 'Paraguay'
• WHEN LEFT(rx_sign, 2) IN ('ZR','ZS','ZT','ZU') THEN 'Sudafrica'
•     ELSE 'ZZ - Otros'
•   END AS pais
• FROM wspr.rx
•   WHERE tx_sign = 'EA5JTT'
•     AND time >= '2025-08-01'
•     AND time < NOW()
• ) AS sub
• WHERE pais = 'ZZ - Otros'
• ORDER BY rx_sign;

Si quisieramos conocer por ejemplo el DXCC WSPR para una banda en concreto habria que incluir en la clausula WHERE una condición como la siguiente

AND band ='3'

Espero que os haya sido de utilidad, de la misma forma se podria hacer para que nos contabilizara:

• Continentes
• zonas ITU 
• Zonas CQ

Zonas CQ Fuente: EI8IC

Ejemplo de SELECT para obtener las zonas CQ que se han trabajado

• SELECT
• CASE
• WHEN LEFT(rx_sign, 2) = '3A' THEN '14'
• WHEN LEFT(rx_sign, 2) IN ('4X','4Z') THEN '20'
• WHEN LEFT(rx_sign, 2) IN ('5B', 'C4', 'P3') THEN '20'
• WHEN LEFT(rx_sign, 2) = '9H' THEN '15'
• WHEN LEFT(rx_sign, 2) = 'C3' THEN '14'
• ELSE 'ZZ - Otros'
• END AS Zona_CQ,
• COUNT(DISTINCT rx_sign) AS N_Contactos
• FROM wspr.rx
• WHERE tx_sign = 'EA5JTT'
• AND time >= '2025-05-23'
• AND time < NOW()
• GROUP BY Zona_CQ
• ORDER BY Zona_CQ ASC;

Zonas ITU  Fuente: EI8IC

Regiones ITU Fuente: EI8IC

Continentes  Fuente: EI8IC

Distritos de España (De la misma forma se puede hacer con el resto de territorios DXCC o paises)

• SELECT 
• CASE 
• WHEN LEFT(rx_sign, 3) IN ('EA1', 'EB1', 'EC1', 'ED1', 'EE1', 'EF1', 'EG1','EH1') THEN 'España - Distrito 1 '
• WHEN LEFT(rx_sign, 3) IN ('EA2', 'EB2', 'EC2', 'ED2', 'EE2', 'EF2', 'EG2','EH2') THEN 'España - Distrito 2 '
• WHEN LEFT(rx_sign, 3) IN ('EA3', 'EB3', 'EC3', 'ED3', 'EE3', 'EF3', 'EG3','EH3') THEN 'España - Distrito 3 '
• WHEN LEFT(rx_sign, 3) IN ('EA4', 'EB4', 'EC4', 'ED4', 'EE4', 'EF4', 'EG4','EH4') THEN 'España - Distrito 4 '
• WHEN LEFT(rx_sign, 3) IN ('EA5', 'EB5', 'EC5', 'ED5', 'EE5', 'EF5', 'EG5','EH5') THEN 'España - Distrito 5 '
• WHEN LEFT(rx_sign, 3) IN ('EA6', 'EB6', 'EC6', 'ED6', 'EE6', 'EF6', 'EG6','EH6') THEN 'España - Distrito 6  Baleares'
• WHEN LEFT(rx_sign, 3) IN ('EA7', 'EB7', 'EC7', 'ED7', 'EE7', 'EF7', 'EG6','EH7') THEN 'España - Distrito 7 '
• WHEN LEFT(rx_sign, 3) IN ('EA8', 'EB8', 'EC8', 'ED8', 'EE8', 'EF8', 'EG8','EH8') THEN 'España - Distrito 8 Canarias'
• WHEN LEFT(rx_sign, 3) IN ('EA9', 'EB9', 'EC9', 'ED9', 'EE9', 'EF9', 'EG9','EH9') THEN 'España - Distrito 9 Ceuta/Melilla'
• WHEN LEFT(rx_sign, 2) IN ('AM', 'AN', 'AO') THEN 'España - Indicativos especiales'
• END AS Distrito,
• COUNT(DISTINCT rx_sign) AS cantidad
• FROM wspr.rx
• WHERE 
•  time >= '2025-03-01'
•   AND time < NOW()
• GROUP BY Distrito
• ORDER BY Distrito ASC;

Número de WSPR RX en España activasde marzo a agosto de 2025 = 171

Imaginemos que queremos listar todos los prefijos (pais) que hemos recibido

• SELECT 
•   CASE 
•     WHEN match(tx_sign, '^[0-9][A-Z]') THEN substring(tx_sign, 1, 2)
•   WHEN match(tx_sign, '^[A-Z][A-Z]') THEN substring(tx_sign, 1, 2)
•     WHEN match(tx_sign, '^[A-Z]') THEN substring(tx_sign, 1, 1)
•     ELSE 'otros'
•   END AS prefix,
•   count(DISTINCT tx_sign) AS total
• FROM wspr.rx
• WHERE 
• rx_sign = 'EA5JTT'
•   AND time > '2025-05-01'
•   AND (   match(tx_sign, '^[0-9][A-Z]') OR 
• match(tx_sign, '^[A-Z][A-Z]') OR 
• match(tx_sign, '^[A-Z]'))
• AND NOT match(tx_sign, '^[01Q]')
• GROUP BY prefix
• ORDER BY prefix ASC;

(pais + zona) que hemos recibido y contabilizar las veces que hemos recibido cada uno de ellos (se admiten repeticiones de indicativos)

• SELECT 
•   CASE 
•     WHEN match(tx_sign, '^[0-9][A-Z][0-9]') THEN substring(tx_sign, 1, 3)
•   WHEN match(tx_sign, '^[A-Z][A-Z][0-9]') THEN substring(tx_sign, 1, 3)
•     WHEN match(tx_sign, '^[A-Z][0-9]') THEN substring(tx_sign, 1, 2)
•     ELSE 'otros'
•   END AS prefix,
•   count(*) AS total
• FROM wspr.rx
• WHERE 
• rx_sign = 'EA5JTT'
•   AND time > '2025-05-01'
•   AND (   match(tx_sign, '^[0-9][A-Z][0-9]') OR 
• match(tx_sign, '^[A-Z][A-Z][0-9]') OR 
• match(tx_sign, '^[A-Z][0-9]'))
• AND NOT match(tx_sign, '^[01Q]')
• GROUP BY prefix
• ORDER BY prefix ASC;

Sin repeticiones de indicativos

• SELECT 
• CASE 
•  WHEN match(tx_sign, '^[0-9][A-Z][0-9]') THEN substring(tx_sign, 1, 3)
•  WHEN match(tx_sign, '^[A-Z][A-Z][0-9]') THEN substring(tx_sign, 1, 3)
•  WHEN match(tx_sign, '^[A-Z][0-9]') THEN substring(tx_sign, 1, 2)
•  ELSE 'otros'
• END AS prefix,
• count(DISTINCT tx_sign) AS total
• FROM wspr.rx
• WHERE 
•   rx_sign = 'EA5JTT'
•   AND time > '2025-05-01'
•   AND (   match(tx_sign, '^[0-9][A-Z][0-9]') OR 
• match(tx_sign, '^[A-Z][A-Z][0-9]') OR 
• match(tx_sign, '^[A-Z][0-9]'))
•   AND NOT match(tx_sign, '^[01Q]')
• GROUP BY prefix
• ORDER BY prefix ASC;