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 = 98 AND cs.division_id LIKE 'HU' 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
SOHP  N2RJ NNJ 2010 1,126,488 1,504 251   Frankford Radio Club      75/39   532/73   742/93   155/46   
SOHP  K2XA ENY 2010 1,003,950 1,160 291   Hudson Valley Contesters and DXers   30/24   213/57   206/60   444/86   257/62   10/2
SOHP  KM2O ENY 2010 596,754 784 257   Hudson Valley Contesters and DXers      76/49   173/53   249/77   248/66   38/12
SOHP  WB2SIH ENY 2010 189,720 340 186     1/1   60/38   95/52   99/48   75/41   10/6
SOHP  WA2HMM NLI 2010 154,878 314 166        36/30   50/28   99/45   100/50   29/13
 
SOHP  K3QDV ENY 2010 99,918 284 122   Hudson Valley Contesters and DXers      4/4   38/27   170/64   72/27   
SOHP  W2OSR NLI 2010 90,558 238 129        1/1   37/30   115/62   85/36   
SOHP  K2NYG NLI 2010 85,281 220 131     8/8      68/40   91/50   53/33   
SOHP  K2BBQ NLI 2010 67,743 194 117   Great South Bay ARC      9/8   58/36   59/40   68/33   
10  SOHP  KC2QJB NNJ 2010 63,654 210 103           39/28   147/56   24/19   
 
11  SOHP  K2FJ NNJ 2010 54,288 161 116   Bergen ARA      56/39   30/24   35/23   34/24   6/6
12  SOHP  K2ZB NNJ 2010 42,408 163 93   Bergen ARA      4/4   19/18   68/34   72/37   
13  SOHP  WG2Y NNJ 2010 35,076 167 79   Bergen ARA            125/55   42/24   
14  SOHP  K4BNC NNJ 2010 19,866 91 77        10/10   13/13   56/42   12/12   
15  SOHP  KC2KZJ NNJ 2010 15,912 79 68        8/8   21/18   36/31   14/11   
 
16  SOHP  KC2HZW ENY 2010 2,484 37 23                 37/23   

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

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