SELECT cc.category_name , cs.category_id , cs.callsign , cs.host_callsign , YEAR(EventInstances.start_date) as yyyy , cs.score , cs.q_total , cs.m_total , cs.section_id , cs.dxcc_prefix , CASE WHEN cs.event_id = 1 AND vhf_region_id BETWEEN 1 AND 17 THEN vhf_region_id WHEN cs.event_id = 1 AND vhf_region_id NOT BETWEEN 1 AND 17 THEN 18 ELSE NULL END AS vhf_region_id , FORMAT(EXTRACTVALUE(cs.details,'minutes_on')/60.0,1) AS hours_on , GROUP_CONCAT(co.callsign ORDER BY co.callsign SEPARATOR ' ') AS ops , CASE WHEN cs.club_status > 10 THEN NULL ELSE cs.clb_abbr END AS club_abbr , CASE WHEN cs.club_status > 10 THEN NULL ELSE ContestClubs.clb_name END AS club_name , cs.details , cs.score_id , cs.late_log_flag FROM ContestScores cs JOIN ContestCategories cc ON cs.category_id = cc.category_id JOIN EventInstances ON cs.instance_id = EventInstances.instance_id JOIN EventInfo ON cs.event_id = EventInfo.event_id LEFT OUTER JOIN ContestOperators co ON cs.score_id = co.score_id LEFT OUTER JOIN ContestArrlSections cas ON cs.section_id = cas.section_id LEFT OUTER JOIN ContestClubs ON cs.clb_abbr = ContestClubs.clb_abbr WHERE cs.event_id = 21 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 130 AND cs.category_id = 'MSHP' GROUP BY cs.score_id ORDER BY cs.score DESC
From the list below, select the contest or call sign for which you want to view scores and then click on Go.
Show Operators Show Club
❮❮First ❮Prev Page 1 of 7 Next❯ Last❯❯
Rank | Category | Call Sign | QTH | Year | Score | QSOs | Mults | Hours | Operators | Club | 160 | 80 | 40 | 20 | 15 | 10 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | MSHP | ZW5B | PY | 2013 | 4,159,652 | 3,571 | 371 | PP5XX PY2KC PY2YU PY5EG | ||||||||
2 | MSHP | CW5W | CX | 2013 | 4,147,168 | 3,248 | 361 | CX2DK CX3AL CX4SS CX5CBA CX5T PY3VK | ||||||||
3 | MSHP | HK1NA | HK | 2013 | 3,869,040 | 3,724 | 343 | HJ1FAR HK1R HK1T | ||||||||
4 | MSHP | PJ2T | PJ2 | 2013 | 3,707,550 | 3,639 | 315 | N5OT N9YS NT6X W0CG W6DR | ||||||||
5 | MSHP | K1LZ | EMA | 2013 | 3,569,956 | 3,086 | 338 | AE2W N8BO | Yankee Clipper Contest Club | |||||||
6 | MSHP | CN3A | CN | 2013 | 3,458,478 | 3,605 | 339 | IK2QEI IK2SGC | ||||||||
7 | MSHP | TM6M | F | 2013 | 2,960,604 | 2,450 | 347 | F1AKK F4DXW F8DBF F8FTY | ||||||||
8 | MSHP | K0RF | CO | 2013 | 2,841,960 | 3,004 | 330 | K0RF W0UA | ||||||||
9 | MSHP | NP2X | KP2 | 2013 | 2,831,708 | 3,261 | 278 | K9VV WP2XX | ||||||||
10 | MSHP | NX5M | STX | 2013 | 2,803,744 | 2,917 | 328 | KJ5T KU5B N5DUW N5XJ NW7DX NX5M | ||||||||
11 | MSHP | N9RV | MT | 2013 | 2,311,184 | 3,035 | 232 | N9RV W8LVN | Northern Rockies DX Association | |||||||
12 | MSHP | W7RN | NV | 2013 | 2,278,348 | 2,658 | 281 | K5RC KH2TJ KM9R KU7Y | Northern California Contest Club | |||||||
13 | MSHP | 4O3A | 4O | 2013 | 2,256,390 | 2,098 | 305 | 4O3A YU1EW YU1JW | ||||||||
14 | MSHP | W4UH | SFL | 2013 | 2,238,520 | 2,116 | 293 | AD4Z AI4QY W4UH WA0USA | Florida Contest Group | |||||||
15 | MSHP | ED1R | EA | 2013 | 2,227,876 | 2,286 | 317 | EA1AR EA4AOC EA4CWN EC1KR EC4DX | ||||||||
16 | MSHP | IQ9UI | I | 2013 | 2,180,046 | 2,140 | 319 | I4UFH IK1HJS IT9AUG IT9CHU IT9CJC IT9EQO IT9GSF | ||||||||
17 | MSHP | VE9AA | MAR | 2013 | 2,173,000 | 2,711 | 265 | Maritime Contest Club | ||||||||
18 | MSHP | N6RZ | EB | 2013 | 2,099,692 | 2,244 | 287 | K6AW KX7M W6NV | Northern California Contest Club | |||||||
19 | MSHP | N7DD | AZ | 2013 | 2,074,800 | 2,730 | 266 | N7DD W8TK | Arizona Outlaws Contest Club | |||||||
20 | MSHP | N1RR | WMA | 2013 | 2,054,360 | 2,388 | 290 | K6ND N1RR @K6ND | Yankee Clipper Contest Club | |||||||
21 | MSHP | PX2F | PY | 2013 | 2,018,370 | 2,517 | 285 | PY2BK PY2CDR PY2EL PY2EX PY2LED PY2PT PY2SHF | ||||||||
22 | MSHP | W6YX | SCV | 2013 | 1,984,422 | 2,251 | 281 | K6SF N7MH NF1R | Northern California Contest Club | |||||||
23 | MSHP | LW6DG | LU | 2013 | 1,961,680 | 2,488 | 280 | LU1DK LU1DP LU4DX LU7DR LU7EC LU8EEM LU9DZP LW6DG | ||||||||
24 | MSHP | TK5EP | TK | 2013 | 1,947,892 | 2,227 | 281 | |||||||||
25 | MSHP | WX3B | MDC | 2013 | 1,939,912 | 2,252 | 299 | K3AJ N8IVN WA3AER WX3B | Potomac Valley Radio Club | |||||||
26 | MSHP | NP2N | KP2 | 2013 | 1,913,280 | 2,511 | 240 | K1ZE N3XF W1EQ | ||||||||
27 | MSHP | K4TD | AL | 2013 | 1,910,400 | 1,677 | 300 | Alabama Contest Group | ||||||||
28 | MSHP | K9NW | IN | 2013 | 1,903,808 | 2,044 | 302 | Mad River Radio Club | ||||||||
29 | MSHP | PR1T | PY | 2013 | 1,889,826 | 2,354 | 267 | PY1CPF PY1MK PY1NB PY1ZV | ||||||||
30 | MSHP | W5KFT | STX | 2013 | 1,876,160 | 2,108 | 286 | K5PI W5KFT W5MJ | Central Texas DX and Contest Club | |||||||
31 | MSHP | VK4KW | VK | 2013 | 1,860,840 | 2,660 | 270 | VK4BAA VK4TS | ||||||||
32 | MSHP | W1NA | EMA | 2013 | 1,841,936 | 2,061 | 292 | I8NHJ I8ULL W1NA | Yankee Clipper Contest Club | |||||||
33 | MSHP | AA9A | WI | 2013 | 1,834,800 | 2,116 | 278 | |||||||||
34 | MSHP | ZF1A | ZF | 2013 | 1,793,616 | 2,919 | 237 | AE9YL K9LA W6VNR | ||||||||
35 | MSHP | AA1JD | WMA | 2013 | 1,780,384 | 2,594 | 236 | AA1JD AA1LH NC1M | ||||||||
36 | MSHP | N3RR | MDC | 2013 | 1,761,936 | 1,687 | 284 | Potomac Valley Radio Club | ||||||||
37 | MSHP | PT3T | PY | 2013 | 1,732,906 | 2,132 | 287 | PY3BM PY3KN PY3MM PY3NZ PY3UK PY3XX PY3Y | ||||||||
38 | MSHP | CE3CT | CE | 2013 | 1,708,022 | 2,431 | 257 | |||||||||
39 | MSHP | VK4WIL | VK | 2013 | 1,674,420 | 2,168 | 258 | VK4MN VK4QH VK4SN | ||||||||
40 | MSHP | DR1D | DL | 2013 | 1,661,400 | 1,889 | 300 | DK3DM DL3KO PY2SEX | ||||||||
41 | MSHP | K5KG | WCF | 2013 | 1,629,184 | 1,657 | 296 | Florida Contest Group | ||||||||
42 | MSHP | VE1OP | MAR | 2013 | 1,626,096 | 1,983 | 228 | Maritime Contest Club | ||||||||
43 | MSHP | GW7X | GW | 2013 | 1,599,696 | 2,050 | 252 | G8DX GW0ARK GW0RYT @GW4BLE | ||||||||
44 | MSHP | K4FJ | VA | 2013 | 1,597,436 | 1,722 | 293 | K3KG K4FJ | Potomac Valley Radio Club | |||||||
45 | MSHP | IQ2CJ | I | 2013 | 1,589,060 | 1,763 | 310 | IK2JUB IK2NCJ IW2HAJ | ||||||||
46 | MSHP | HA30S | HA | 2013 | 1,587,488 | 1,652 | 304 | HA1DAC HA1DAI HA1TJ HA6NF HA8DM | ||||||||
47 | MSHP | N7AT | AZ | 2013 | 1,574,148 | 2,236 | 233 | K8IA N7LR N7RQ W9CF | Arizona Outlaws Contest Club | |||||||
48 | MSHP | SJ2W | SM | 2013 | 1,562,268 | 1,588 | 303 | SM2IUF SM2LIY SM2UVU | ||||||||
49 | MSHP | W2YC | SNJ | 2013 | 1,544,060 | 1,611 | 287 | W2YC WK2G | Frankford Radio Club | |||||||
50 | MSHP | DL2CC | DL | 2013 | 1,535,808 | 1,567 | 304 | DL2CC DL2SAX | ||||||||
51 | MSHP | LW5HR | LU | 2013 | 1,512,702 | 1,775 | 257 | LW4HR LW5HR | ||||||||
52 | MSHP | JH5RXS | JA | 2013 | 1,510,410 | 2,013 | 253 | |||||||||
53 | MSHP | WW4LL | GA | 2013 | 1,451,480 | 1,906 | 262 | N4OO W4KTR WW4LL | Georgia Contest Group | |||||||
54 | MSHP | JA3YBK | JA | 2013 | 1,434,004 | 1,648 | 286 | JG3KIV JS1PWV | ||||||||
55 | MSHP | W4ML | VA | 2013 | 1,421,310 | 1,454 | 295 | W4MYA | Central Virginia Contest Club | |||||||
56 | MSHP | W1KM | EMA | 2013 | 1,417,520 | 1,658 | 232 | KA1IOR N1TB W1KM | Yankee Clipper Contest Club | |||||||
57 | MSHP | OL1X | OK | 2013 | 1,391,020 | 1,436 | 314 | OK1FDR OK1XQ OK4PA | ||||||||
58 | MSHP | IO5O | I | 2013 | 1,383,564 | 1,859 | 294 | IK5RLP IK5ROS IK5ZWU IO5O IW5EFX IZ5EME | ||||||||
59 | MSHP | OK1RI | OK | 2013 | 1,355,916 | 1,502 | 313 | |||||||||
60 | MSHP | W1TJL | CT | 2013 | 1,351,152 | 1,712 | 264 | K1EBY N1IXF W1TJL | Yankee Clipper Contest Club | |||||||
61 | MSHP | NF6A | SCV | 2013 | 1,338,140 | 1,837 | 230 | K6XX KK6GMH | Northern California Contest Club | |||||||
62 | MSHP | HG7T | HA | 2013 | 1,330,056 | 1,773 | 261 | HA5MY HA7TM | ||||||||
63 | MSHP | HA8JV | HA | 2013 | 1,329,288 | 1,417 | 291 | |||||||||
64 | MSHP | W8MJ | MI | 2013 | 1,313,272 | 1,574 | 278 | Mad River Radio Club | ||||||||
65 | MSHP | OH1F | OH | 2013 | 1,308,912 | 1,337 | 296 | OH1NOA OH6GDX | ||||||||
66 | MSHP | SP8R | SP | 2013 | 1,291,152 | 1,445 | 296 | SP7VC SP8BRQ | ||||||||
67 | MSHP | K3WW | EPA | 2013 | 1,273,700 | 1,554 | 271 | Frankford Radio Club | ||||||||
68 | MSHP | LZ2JR | LZ | 2013 | 1,259,518 | 1,641 | 251 | LZ2JR LZ2RS LZ5CA | ||||||||
69 | MSHP | SN8W | SP | 2013 | 1,252,920 | 1,582 | 265 | SP8CUR SP8CUW SP8GQU SP8GWI SQ8JLU | ||||||||
70 | MSHP | SK3GM | SM | 2013 | 1,246,728 | 1,377 | 287 | SM3UZS SM3VAC | ||||||||
71 | MSHP | N5XZ | STX | 2013 | 1,226,664 | 1,915 | 162 | Texas DX Society | ||||||||
72 | MSHP | PI4DX | PA | 2013 | 1,224,984 | 1,989 | 258 | PA3EVY PC5Z PD1DX | ||||||||
73 | MSHP | N9NC | NH | 2013 | 1,221,660 | 1,862 | 165 | Yankee Clipper Contest Club | ||||||||
74 | MSHP | UW7LL | UR | 2013 | 1,210,300 | 1,509 | 266 | |||||||||
75 | MSHP | PA6K | PA | 2013 | 1,209,340 | 1,801 | 230 | PA2AWU PD9DX PE1BBI | ||||||||
76 | MSHP | N0AT | MN | 2013 | 1,208,752 | 1,490 | 248 | K0BBC N0AT | Minnesota Wireless Assn | |||||||
77 | MSHP | VE5MX | SK | 2013 | 1,203,482 | 1,607 | 217 | Saskatchewan Contest Club | ||||||||
78 | MSHP | R7AB | UA | 2013 | 1,185,408 | 1,491 | 252 | RM6AA RU7A UA6AA | ||||||||
79 | MSHP | DL5CW | DL | 2013 | 1,183,320 | 1,207 | 285 | DL5CW DL7AU | ||||||||
80 | MSHP | LZ5R | LZ | 2013 | 1,181,440 | 1,396 | 260 | Z32ZM | ||||||||
81 | MSHP | PS2T | PY | 2013 | 1,177,682 | 1,331 | 269 | PU2RSD PY2EQ PY2XQ PY2ZEA | ||||||||
82 | MSHP | K0EU | CO | 2013 | 1,171,716 | 1,883 | 222 | Grand Mesa Contesters of Colorado | ||||||||
83 | MSHP | EF5Y | EA | 2013 | 1,151,304 | 1,623 | 178 | EA5GTQ EA5RS | ||||||||
84 | MSHP | JS3CTQ | JA | 2013 | 1,138,588 | 1,601 | 229 | |||||||||
85 | MSHP | VE3CX | ONN | 2013 | 1,134,080 | 1,493 | 256 | Contest Club Ontario | ||||||||
86 | MSHP | TM1A | F | 2013 | 1,132,160 | 1,505 | 244 | F4AJQ F4BDG F4HFD F5NQL F5PBM F5RAB F5VH | ||||||||
87 | MSHP | HF9Q | SP | 2013 | 1,130,876 | 1,324 | 269 | SP9GFI SP9QMP SP9XCN | ||||||||
88 | MSHP | LX1NO | LX | 2013 | 1,054,650 | 1,410 | 237 | |||||||||
89 | MSHP | N0KV | CO | 2013 | 1,039,808 | 1,769 | 224 | Mile High DX Assn | ||||||||
90 | MSHP | KE3X | MDC | 2013 | 968,552 | 1,095 | 268 | KE3X W4IX | Potomac Valley Radio Club | |||||||
91 | MSHP | K5EK | NC | 2013 | 926,376 | 1,122 | 242 | Carolina DX Association | ||||||||
92 | MSHP | DK2OY | DL | 2013 | 922,484 | 1,103 | 271 | |||||||||
93 | MSHP | OQ4U | ON | 2013 | 908,000 | 1,862 | 227 | |||||||||
94 | MSHP | 8P8T | 8P | 2013 | 897,836 | 1,267 | 193 | K0BJ KI1U N1TA | ||||||||
95 | MSHP | N3QE | MDC | 2013 | 892,664 | 1,013 | 241 | Potomac Valley Radio Club | ||||||||
96 | MSHP | VK4NM | VK | 2013 | 885,772 | 1,758 | 229 | VK4LAT VK4NM | ||||||||
97 | MSHP | K3EST | EB | 2013 | 882,124 | 2,681 | 166 | Northern California Contest Club | ||||||||
98 | MSHP | NX6T | SDG | 2013 | 881,360 | 1,189 | 230 | AF6WF K4RB K6KAL N0DY N6EEG N6ERD N6KI NN6X WA3IHV | Southern California Contest Club | |||||||
99 | MSHP | K0KX | MN | 2013 | 878,178 | 805 | 309 | Minnesota Wireless Assn | ||||||||
100 | MSHP | PI4TUE | PA | 2013 | 876,652 | 962 | 262 | PA3FGA PA5MW PC5A PD5AX | ||||||||
❮❮First ❮Prev Page 1 of 7 Next❯ Last❯❯
Scores in italics were received after the deadline and/or are not eligible for awards.