DJ1YFK LOTW confirmation rate by DXCC October 2009 Overall: 20,328 / 100,732 = 20.2% +----------+-------+------+-------+ | thisdxcc | sent | rxed | ratio | +----------+-------+------+-------+ | 1A | 6 | 6 | 100 | | HH | 1 | 1 | 100 | | 5U | 6 | 6 | 100 | | H4 | 1 | 1 | 100 | | HV | 2 | 2 | 100 | | VK9C | 4 | 4 | 100 | | VU4 | 1 | 1 | 100 | | VP6d | 2 | 2 | 100 | | TR | 1 | 1 | 100 | | YS | 1 | 1 | 100 | | BS7 | 1 | 1 | 100 | | KH7K | 1 | 1 | 100 | | S0 | 4 | 4 | 100 | | T33 | 2 | 2 | 100 | | VK9W | 2 | 2 | 100 | | 4U1U | 2 | 2 | 100 | | ZL7 | 2 | 2 | 100 | | KH8s | 1 | 1 | 100 | | 3Yp | 1 | 1 | 100 | | A5 | 1 | 1 | 100 | | XT | 4 | 4 | 100 | | 4W | 1 | 1 | 100 | | TJ | 4 | 4 | 100 | | ZL8 | 2 | 2 | 100 | | BV9P | 1 | 1 | 100 | | 9L | 1 | 1 | 100 | | 3D2 | 1 | 1 | 100 | | YV0 | 2 | 2 | 100 | | HC8 | 34 | 32 | 94 | | 9V | 18 | 16 | 89 | | TZ | 8 | 7 | 88 | | VU7 | 8 | 7 | 88 | | D4 | 23 | 20 | 87 | | D6 | 7 | 6 | 86 | | HZ | 23 | 19 | 83 | | 5R | 5 | 4 | 80 | | 3B9 | 8 | 6 | 75 | | KL | 34 | 24 | 71 | | ZC4 | 50 | 35 | 70 | | GD | 57 | 39 | 68 | | ZD8 | 3 | 2 | 67 | | HK0a | 3 | 2 | 67 | | HR | 6 | 4 | 67 | | ZF | 54 | 35 | 65 | | PJ2 | 49 | 31 | 63 | | VP2M | 8 | 5 | 62 | | P4 | 114 | 69 | 61 | | GJ | 54 | 33 | 61 | | VK9N | 5 | 3 | 60 | | JX | 5 | 3 | 60 | | VP8h | 5 | 3 | 60 | | J3 | 19 | 11 | 58 | | S9 | 7 | 4 | 57 | | OD | 21 | 12 | 57 | | YK | 7 | 4 | 57 | | 9M2 | 27 | 15 | 56 | | J7 | 18 | 10 | 56 | | 8P | 43 | 24 | 56 | | 4O | 53 | 29 | 55 | | KH6 | 11 | 6 | 55 | | 9K | 24 | 13 | 54 | | CT3 | 149 | 78 | 52 | | A6 | 33 | 17 | 52 | | KP2 | 35 | 18 | 51 | | 5A | 14 | 7 | 50 | | TL | 2 | 1 | 50 | | A9 | 2 | 1 | 50 | | KH2 | 12 | 6 | 50 | | CY9 | 2 | 1 | 50 | | FH | 6 | 3 | 50 | | A2 | 4 | 2 | 50 | | 9Q | 2 | 1 | 50 | | 5X | 2 | 1 | 50 | | 3X | 8 | 4 | 50 | | EY | 23 | 11 | 48 | | C6 | 32 | 15 | 47 | | GM | 643 | 301 | 47 | | FY | 15 | 7 | 47 | | ZP | 15 | 7 | 47 | | 4J | 59 | 27 | 46 | | 9M6 | 20 | 9 | 45 | | TF | 68 | 30 | 44 | | XE | 34 | 15 | 44 | | LX | 94 | 40 | 43 | | 9U | 7 | 3 | 43 | | J5 | 5 | 2 | 40 | | 4U1I | 15 | 6 | 40 | | K | 14133 | 5572 | 39 | | VP2V | 8 | 3 | 38 | | VP5 | 37 | 14 | 38 | | 5N | 8 | 3 | 38 | | VE | 1161 | 437 | 38 | | HI | 23 | 8 | 35 | | 5B | 302 | 105 | 35 | | LA | 664 | 232 | 35 | | HK | 29 | 10 | 34 | | 9H | 77 | 26 | 34 | | S7 | 3 | 1 | 33 | | YA | 6 | 2 | 33 | | EK | 21 | 7 | 33 | | C9 | 3 | 1 | 33 | | J8 | 3 | 1 | 33 | | EL | 3 | 1 | 33 | | TU | 9 | 3 | 33 | | KG4 | 3 | 1 | 33 | | SV5 | 63 | 20 | 32 | | PA | 1534 | 488 | 32 | | OE | 296 | 95 | 32 | | CU | 65 | 20 | 31 | | EA8 | 315 | 95 | 30 | | HB | 521 | 154 | 30 | | XU | 10 | 3 | 30 | | A7 | 21 | 6 | 29 | | VP2E | 7 | 2 | 29 | | J2 | 7 | 2 | 29 | | F | 1490 | 413 | 28 | | V2 | 29 | 8 | 28 | | GI | 89 | 25 | 28 | | SM | 2022 | 572 | 28 | | CT | 219 | 61 | 28 | | VR | 23 | 6 | 26 | | AP | 4 | 1 | 25 | | ZL | 106 | 27 | 25 | | CP | 4 | 1 | 25 | | FJ | 4 | 1 | 25 | | EA | 1142 | 291 | 25 | | FG | 17 | 4 | 24 | | SV9 | 72 | 17 | 24 | | CN | 55 | 13 | 24 | | V4 | 17 | 4 | 24 | | HL | 54 | 13 | 24 | | EA6 | 111 | 27 | 24 | | VU | 31 | 7 | 23 | | C5 | 9 | 2 | 22 | | V3 | 37 | 8 | 22 | | CE9 | 14 | 3 | 21 | | ZS | 47 | 10 | 21 | | EI | 267 | 56 | 21 | | LY | 1964 | 405 | 21 | | BY | 80 | 16 | 20 | | 3A | 20 | 4 | 20 | | ON | 708 | 145 | 20 | | 3B6 | 5 | 1 | 20 | | YB | 46 | 9 | 20 | | 8R | 5 | 1 | 20 | | 4X | 225 | 45 | 20 | | 9X | 5 | 1 | 20 | | G | 5004 | 996 | 20 | | SP | 2594 | 482 | 19 | | OH0 | 165 | 32 | 19 | | JA | 1566 | 297 | 19 | | YL | 1104 | 195 | 18 | | OA | 11 | 2 | 18 | | EX | 72 | 13 | 18 | | YV | 95 | 17 | 18 | | S5 | 1296 | 231 | 18 | | SV | 387 | 69 | 18 | | JT | 23 | 4 | 17 | | C3 | 6 | 1 | 17 | | R1FJ | 6 | 1 | 17 | | YO | 1284 | 216 | 17 | | GU | 117 | 20 | 17 | | VK | 121 | 19 | 16 | | OH | 1473 | 233 | 16 | | ZB | 19 | 3 | 16 | | V5 | 19 | 3 | 16 | | OZ | 510 | 80 | 16 | | ER | 155 | 23 | 15 | | ES | 413 | 63 | 15 | | JW | 34 | 5 | 15 | | PY | 273 | 42 | 15 | | UR | 4894 | 702 | 14 | | PZ | 14 | 2 | 14 | | CX | 35 | 5 | 14 | | LU | 184 | 26 | 14 | | JY | 21 | 3 | 14 | | VP9 | 14 | 2 | 14 | | UK | 42 | 6 | 14 | | EU | 822 | 105 | 13 | | HB0 | 46 | 6 | 13 | | I | 1733 | 221 | 13 | | OK | 3053 | 354 | 12 | | YN | 16 | 2 | 12 | | 9G | 16 | 2 | 12 | | FS | 8 | 1 | 12 | | 6Y | 18 | 2 | 11 | | UA | 12377 | 1303 | 11 | | 5H | 19 | 2 | 11 | | LZ | 1308 | 145 | 11 | | DL | 12267 | 1312 | 11 | | R1MV | 10 | 1 | 10 | | OX | 21 | 2 | 10 | | UA9 | 4060 | 410 | 10 | | ST | 10 | 1 | 10 | | TI | 29 | 3 | 10 | | IS | 124 | 13 | 10 | | SU | 20 | 2 | 10 | | TK | 50 | 5 | 10 | | 4L | 75 | 7 | 9 | | HS | 55 | 5 | 9 | | HA | 2063 | 180 | 9 | | E7 | 306 | 28 | 9 | | 9A | 1208 | 101 | 8 | | 9Y | 12 | 1 | 8 | | KP4 | 60 | 5 | 8 | | TA | 122 | 10 | 8 | | 7Q | 12 | 1 | 8 | | 9N | 12 | 1 | 8 | | YI | 24 | 2 | 8 | | 6W | 25 | 2 | 8 | | 3B8 | 14 | 1 | 7 | | FM | 29 | 2 | 7 | | EA9 | 34 | 2 | 6 | | UA2 | 272 | 14 | 5 | | DU | 28 | 1 | 4 | | CM | 50 | 2 | 4 | | OJ0 | 23 | 1 | 4 | | GW | 346 | 15 | 4 | | OY | 154 | 5 | 3 | | OM | 890 | 15 | 2 | | ZA | 41 | 1 | 2 | | YU | 1583 | 38 | 2 | | UN | 433 | 8 | 2 | | Z3 | 173 | 1 | 1 | +----------+-------+------+-------+ Older Data: 31-Dec-2008 Overall LOTW rate: 17.4% (91628 sent, 15950 received) +----------+-------+------+--------+ | dxcc | sent | rxed | ratio | +----------+-------+------+--------+ | 1A | 6 | 6 | 100.00 | | VP6d | 2 | 2 | 100.00 | | 5U | 6 | 6 | 100.00 | | TR | 1 | 1 | 100.00 | | KH7K | 1 | 1 | 100.00 | | S0 | 4 | 4 | 100.00 | | T33 | 2 | 2 | 100.00 | | BS7 | 1 | 1 | 100.00 | | KH8s | 1 | 1 | 100.00 | | XT | 4 | 4 | 100.00 | | TJ | 4 | 4 | 100.00 | | ZL8 | 2 | 2 | 100.00 | | 4U1U | 2 | 2 | 100.00 | | BV9P | 1 | 1 | 100.00 | | HH | 1 | 1 | 100.00 | | 3Yp | 1 | 1 | 100.00 | | H4 | 1 | 1 | 100.00 | | 3D2 | 1 | 1 | 100.00 | | HV | 2 | 2 | 100.00 | | VK9C | 4 | 4 | 100.00 | | HC8 | 34 | 32 | 94.12 | | 9V | 18 | 16 | 88.89 | | VU7 | 8 | 7 | 87.50 | | TZ | 8 | 7 | 87.50 | | D6 | 7 | 6 | 85.71 | | HZ | 22 | 18 | 81.82 | | D4 | 22 | 18 | 81.82 | | 5R | 5 | 4 | 80.00 | | 3B9 | 8 | 6 | 75.00 | | ZC4 | 40 | 27 | 67.50 | | HR | 6 | 4 | 66.67 | | ZD8 | 3 | 2 | 66.67 | | ZF | 53 | 35 | 66.04 | | VP2M | 8 | 5 | 62.50 | | GD | 50 | 31 | 62.00 | | VK9N | 5 | 3 | 60.00 | | JX | 5 | 3 | 60.00 | | P4 | 108 | 64 | 59.26 | | KL | 34 | 20 | 58.82 | | 8P | 41 | 24 | 58.54 | | J3 | 19 | 11 | 57.89 | | 9M2 | 26 | 15 | 57.69 | | GJ | 49 | 28 | 57.14 | | PJ2 | 49 | 28 | 57.14 | | YK | 7 | 4 | 57.14 | | S9 | 7 | 4 | 57.14 | | KP2 | 30 | 17 | 56.67 | | KH2 | 11 | 6 | 54.55 | | 9K | 24 | 13 | 54.17 | | CT3 | 144 | 76 | 52.78 | | A9 | 2 | 1 | 50.00 | | FH | 6 | 3 | 50.00 | | 5A | 14 | 7 | 50.00 | | CY9 | 2 | 1 | 50.00 | | A2 | 4 | 2 | 50.00 | | ZL7 | 2 | 1 | 50.00 | | 4U1I | 12 | 6 | 50.00 | | 9Q | 2 | 1 | 50.00 | | 5X | 2 | 1 | 50.00 | | 3X | 8 | 4 | 50.00 | | YV0 | 2 | 1 | 50.00 | | A6 | 32 | 16 | 50.00 | | TL | 2 | 1 | 50.00 | | 4O | 45 | 22 | 48.89 | | FY | 15 | 7 | 46.67 | | VP5 | 32 | 14 | 43.75 | | EY | 21 | 9 | 42.86 | | ZP | 14 | 6 | 42.86 | | XE | 33 | 14 | 42.42 | | LX | 90 | 38 | 42.22 | | TF | 62 | 26 | 41.94 | | J5 | 5 | 2 | 40.00 | | VP2V | 8 | 3 | 37.50 | | K | 13501 | 4966 | 36.78 | | GM | 591 | 215 | 36.38 | | HI | 22 | 8 | 36.36 | | VE | 1124 | 404 | 35.94 | | 9H | 77 | 26 | 33.77 | | YA | 6 | 2 | 33.33 | | HK0a | 3 | 1 | 33.33 | | J8 | 3 | 1 | 33.33 | | EL | 3 | 1 | 33.33 | | TU | 9 | 3 | 33.33 | | C9 | 3 | 1 | 33.33 | | KG4 | 3 | 1 | 33.33 | | S7 | 3 | 1 | 33.33 | | SV5 | 61 | 20 | 32.79 | | CU | 61 | 20 | 32.79 | | LA | 628 | 203 | 32.32 | | 5B | 278 | 85 | 30.58 | | C6 | 31 | 9 | 29.03 | | VP2E | 7 | 2 | 28.57 | | J7 | 18 | 5 | 27.78 | | HK | 29 | 8 | 27.59 | | V2 | 29 | 8 | 27.59 | | SM | 1884 | 514 | 27.28 | | EA8 | 295 | 79 | 26.78 | | V4 | 15 | 4 | 26.67 | | PA | 1411 | 372 | 26.36 | | A7 | 19 | 5 | 26.32 | | ZL | 99 | 26 | 26.26 | | CT | 192 | 50 | 26.04 | | SV9 | 66 | 17 | 25.76 | | GI | 82 | 21 | 25.61 | | HB | 496 | 125 | 25.20 | | FJ | 4 | 1 | 25.00 | | CP | 4 | 1 | 25.00 | | VR | 20 | 5 | 25.00 | | OE | 277 | 69 | 24.91 | | EA6 | 110 | 27 | 24.55 | | EA | 1063 | 250 | 23.52 | | ZS | 44 | 10 | 22.73 | | C5 | 9 | 2 | 22.22 | | XU | 9 | 2 | 22.22 | | CE9 | 14 | 3 | 21.43 | | CN | 53 | 11 | 20.75 | | KH6 | 10 | 2 | 20.00 | | VP8h | 5 | 1 | 20.00 | | 3A | 20 | 4 | 20.00 | | 3B6 | 5 | 1 | 20.00 | | 8R | 5 | 1 | 20.00 | | 9X | 5 | 1 | 20.00 | | V3 | 36 | 7 | 19.44 | | OH0 | 155 | 30 | 19.35 | | EX | 68 | 13 | 19.12 | | LY | 1731 | 330 | 19.06 | | JT | 21 | 4 | 19.05 | | EI | 245 | 46 | 18.78 | | YB | 43 | 8 | 18.60 | | GU | 108 | 20 | 18.52 | | ON | 681 | 126 | 18.50 | | G | 4594 | 844 | 18.37 | | F | 1395 | 255 | 18.28 | | OA | 11 | 2 | 18.18 | | 4X | 199 | 36 | 18.09 | | FG | 17 | 3 | 17.65 | | S5 | 1197 | 206 | 17.21 | | JA | 1344 | 228 | 16.96 | | C3 | 6 | 1 | 16.67 | | YV | 91 | 15 | 16.48 | | VK | 110 | 18 | 16.36 | | SV | 364 | 59 | 16.21 | | VU | 31 | 5 | 16.13 | | OZ | 467 | 74 | 15.85 | | ZB | 19 | 3 | 15.79 | | OH | 1400 | 214 | 15.29 | | UK | 40 | 6 | 15.00 | | YO | 1163 | 172 | 14.79 | | CX | 34 | 5 | 14.71 | | JY | 21 | 3 | 14.29 | | VP9 | 14 | 2 | 14.29 | | J2 | 7 | 1 | 14.29 | | SP | 2339 | 327 | 13.98 | | YN | 15 | 2 | 13.33 | | HB0 | 46 | 6 | 13.04 | | PY | 262 | 34 | 12.98 | | YL | 1004 | 130 | 12.95 | | ES | 372 | 47 | 12.63 | | 6Y | 16 | 2 | 12.50 | | FS | 8 | 1 | 12.50 | | 9G | 16 | 2 | 12.50 | | LU | 181 | 22 | 12.15 | | V5 | 17 | 2 | 11.76 | | JW | 34 | 4 | 11.76 | | LZ | 1148 | 129 | 11.24 | | I | 1627 | 182 | 11.19 | | TK | 46 | 5 | 10.87 | | BY | 74 | 8 | 10.81 | | HS | 47 | 5 | 10.64 | | OX | 19 | 2 | 10.53 | | 5H | 19 | 2 | 10.53 | | UR | 4393 | 461 | 10.49 | | EU | 750 | 78 | 10.40 | | OK | 2890 | 292 | 10.10 | | 4L | 70 | 7 | 10.00 | | R1MV | 10 | 1 | 10.00 | | ST | 10 | 1 | 10.00 | | SU | 20 | 2 | 10.00 | | UA | 10442 | 1007 | 9.64 | | 7Q | 11 | 1 | 9.09 | | DL | 11641 | 1035 | 8.89 | | KP4 | 57 | 5 | 8.77 | | UA9 | 3285 | 269 | 8.19 | | IS | 113 | 9 | 7.96 | | HA | 1900 | 146 | 7.68 | | UA2 | 196 | 14 | 7.14 | | FM | 28 | 2 | 7.14 | | 3B8 | 14 | 1 | 7.14 | | 9A | 1111 | 76 | 6.84 | | HL | 45 | 3 | 6.67 | | EA9 | 32 | 2 | 6.25 | | ER | 145 | 7 | 4.83 | | OJ0 | 23 | 1 | 4.35 | | DU | 23 | 1 | 4.35 | | CM | 47 | 2 | 4.26 | | YI | 24 | 1 | 4.17 | | 6W | 24 | 1 | 4.17 | | TA | 107 | 4 | 3.74 | | E7 | 280 | 10 | 3.57 | | 4J | 56 | 2 | 3.57 | | TI | 29 | 1 | 3.45 | | GW | 313 | 10 | 3.19 | | ZA | 41 | 1 | 2.44 | | YU | 1452 | 32 | 2.20 | | OM | 846 | 13 | 1.54 | | UN | 379 | 5 | 1.32 | | OY | 144 | 1 | 0.69 | | Z3 | 163 | 1 | 0.61 | | ET | 7 | 0 | 0.00 | | FR | 6 | 0 | 0.00 | | J6 | 4 | 0 | 0.00 | | ZK2 | 1 | 0 | 0.00 | | 3DA | 2 | 0 | 0.00 | | SVa | 1 | 0 | 0.00 | | 9Y | 12 | 0 | 0.00 | | E4 | 6 | 0 | 0.00 | | 1S | 2 | 0 | 0.00 | | 7P | 1 | 0 | 0.00 | | YS | 1 | 0 | 0.00 | | 9M6 | 18 | 0 | 0.00 | | TG | 1 | 0 | 0.00 | | 5V | 1 | 0 | 0.00 | | AP | 4 | 0 | 0.00 | | EK | 19 | 0 | 0.00 | | 3V | 46 | 0 | 0.00 | | VK9W | 2 | 0 | 0.00 | | PJ7 | 23 | 0 | 0.00 | | TT | 2 | 0 | 0.00 | | 4S | 10 | 0 | 0.00 | | 9N | 12 | 0 | 0.00 | | D2 | 2 | 0 | 0.00 | | FW | 1 | 0 | 0.00 | | 5W | 1 | 0 | 0.00 | | HC | 12 | 0 | 0.00 | | S2 | 2 | 0 | 0.00 | | 3W | 7 | 0 | 0.00 | | FK | 3 | 0 | 0.00 | | T5 | 3 | 0 | 0.00 | | A4 | 39 | 0 | 0.00 | | 7X | 25 | 0 | 0.00 | | HP | 18 | 0 | 0.00 | | V8 | 2 | 0 | 0.00 | | VQ9 | 20 | 0 | 0.00 | | BV | 17 | 0 | 0.00 | | EP | 6 | 0 | 0.00 | | 9J | 22 | 0 | 0.00 | | T7 | 8 | 0 | 0.00 | | ZD7 | 3 | 0 | 0.00 | | 5N | 2 | 0 | 0.00 | | A5 | 1 | 0 | 0.00 | | PY0F | 5 | 0 | 0.00 | | TY | 2 | 0 | 0.00 | | CE | 15 | 0 | 0.00 | | EZ | 7 | 0 | 0.00 | | 9U | 7 | 0 | 0.00 | | JDo | 1 | 0 | 0.00 | | P2 | 1 | 0 | 0.00 | | 5Z | 13 | 0 | 0.00 | | FO | 1 | 0 | 0.00 | | T8 | 2 | 0 | 0.00 | | KH0 | 2 | 0 | 0.00 | | PZ | 14 | 0 | 0.00 | | XW | 5 | 0 | 0.00 | | 8Q | 12 | 0 | 0.00 | | CE0Y | 1 | 0 | 0.00 | | Z2 | 2 | 0 | 0.00 | | 4W | 1 | 0 | 0.00 | | 9L | 1 | 0 | 0.00 | | FP | 6 | 0 | 0.00 | | 5T | 2 | 0 | 0.00 | | R1FJ | 6 | 0 | 0.00 | | XX9 | 1 | 0 | 0.00 | | OD | 21 | 0 | 0.00 | | TN | 1 | 0 | 0.00 | | VU4 | 1 | 0 | 0.00 | +----------+-------+------+--------+ 275 rows in set (5.84 sec) mysql> select dxcc as thisdxcc, count(*) as sent, (select count(dxcc) from log_dj1yfk where dxcc=thisdxcc and qslrl='Y') as rxed, (100*(select count(dxcc) from log_dj1yfk where dxcc=thisdxcc and qslrl='Y')/count(*)) as ratio from log_dj1yfk where 1 group by dxcc order by ratio desc;