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 = 14 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 97 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W3') AND cs.category_id = 'SOHP' GROUP BY cs.score_id ORDER BY cs.score DESC

Contest Scores

From the list below, select the contest or call sign for which you want to view scores and then click on Go.

 

or

Show Operators   Show Club  

❮❮First  ❮Prev     Page 1 of 1     Next❯  Last❯❯
RankCategoryCall SignQTHYearScoreQSOsMultsHoursOperatorsClub160 80 40 20 15 10
1  SOHP  AA1K DE 2009 2,398,200 2,302 350   Frankford Radio Club   62/45   196/66   410/70   1,522/114   96/43   16/12
2  SOHP  K3CR WPA 2009 2,116,500 2,087 340   LZ4AX North Coast Contesters   44/38   176/63   413/70   1,325/111   113/49   16/9
3  SOHP  K3ZO MDC 2009 1,777,554 1,900 314   Potomac Valley Radio Club   42/34   94/53   449/74   1,180/105   96/33   39/15
4  SOHP  K3TC MDC 2009 676,368 865 264   Potomac Valley Radio Club   34/25   79/51   100/48   551/97   84/33   17/10
5  SOHP  N1WR MDC 2009 522,648 741 238   Potomac Valley Radio Club   17/15   68/44   94/46   452/89   110/44   
 
6  SOHP  N3UM MDC 2009 433,605 697 211   Potomac Valley Radio Club   21/17   79/44   96/45   437/78   64/27   
7  SOHP  KF3B EPA 2009 407,154 697 199   Frankford Radio Club   40/33      59/28   505/98   93/40   
8  SOHP  N3YW EPA 2009 221,550 434 175   Frankford Radio Club      65/39   56/29   256/78   57/29   
9  SOHP  N3RJ EPA 2009 218,436 450 167   Frankford Radio Club      40/28   77/41   273/64   59/33   1/1
10  SOHP  K3VOA MDC 2009 207,690 433 161   K4ZW Potomac Valley Radio Club   19/18   50/38   51/35   270/48   43/22   
 
11  SOHP  N3BNA EPA 2009 127,347 241 187   Frankford Radio Club   21/19   41/39   45/39   88/65   46/25   
12  SOHP  N3TIR WPA 2009 119,727 267 159     5/5   41/31   68/37   91/54   50/25   12/7
13  SOHP  W2TN EPA 2009 114,678 298 138        27/25   38/27   220/79   13/7   
14  SOHP  W3GK EPA 2009 102,960 293 120   Frankford Radio Club   5/5   22/19   7/5   209/71   45/17   5/3
15  SOHP  W3FVT EPA 2009 95,976 278 124   Frankford Radio Club   4/4   23/18   39/24   175/60   37/18   
 
16  SOHP  K3ATO EPA 2009 75,867 216 121   Frankford Radio Club   8/7   23/19   67/39   90/39   28/17   
17  SOHP  WA3MKB EPA 2009 54,609 169 109        44/32   13/13   76/48   36/16   
18  SOHP  KB3OJM DE 2009 54,384 183 103        25/20   13/9   113/57   32/17   
19  SOHP  W3RA WPA 2009 41,796 163 86   Allegheny Valley Radio Association      5/5   44/31   94/38   20/12   
20  SOHP  K3NK EPA 2009 36,636 147 86           21/18   85/48   41/20   
 
21  SOHP  K3MRG EPA 2009 36,279 148 87        16/15   70/39   41/22   21/11   
22  SOHP  W2GG MDC 2009 25,425 114 75   Potomac Valley Radio Club   2/2   5/5   5/5   56/38   46/25   
23  SOHP  W3SQ EPA 2009 23,064 131 62   Frankford Radio Club            106/46   25/16   
24  SOHP  K3RMB WPA 2009 22,140 126 60           3/3   93/48   30/9   
25  SOHP  KA3UBG EPA 2009 12,780 71 60                    
 
26  SOHP  K3YG EPA 2009 11,457 69 57        1/1   5/5   46/35   17/16   
27  SOHP  K3ISH EPA 2009 11,205 83 45              44/27   39/18   
28  SOHP  W3ZGD EPA 2009 9,006 81 38              72/33   9/5   
29  SOHP  KB3P EPA 2009 2,070 30 23              24/18   6/5   

❮❮First  ❮Prev     Page 1 of 1     Next❯  Last❯❯

Scores in italics were received after the deadline and/or are not eligible for awards.