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 = 3 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 217 AND cs.division_id LIKE 'NW' 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  K7CW WWA 2015 39,298 401 98   Pacific Northwest VHF Society                  
2  SOHP  W7FI WWA 2015 25,010 262 82   Pacific Northwest VHF Society                  
3  SOHP  N7EPD WWA 2015 22,420 207 76   Pacific Northwest VHF Society                  
4  SOHP  KD7TS WWA 2015 18,971 196 61   Pacific Northwest VHF Society                  
5  SOHP  KE7SW WWA 2015 15,300 167 68   Pacific Northwest VHF Society                  
 
6  SOHP  W7MEM ID 2015 14,615 170 79   Idaho DX Assoc                  
7  SOHP  KB7ME WWA 2015 14,348 184 68   Pacific Northwest VHF Society                  
8  SOHP  K0JJ OR 2015 10,962 178 54   Pacific Northwest VHF Society                  
9  SOHP  N7ZO OR 2015 6,390 142 45                    
10  SOHP  K6UM OR 2015 5,332 124 43   Pacific Northwest VHF Society                  
 
11  SOHP  W7DRM WWA 2015 4,600 115 40                    
12  SOHP  KG7P WWA 2015 4,130 80 35   Pacific Northwest VHF Society                  
13  SOHP  KB7N WWA 2015 2,772 84 33   Radio Club of Redmond                  
14  SOHP  K7ND WWA 2015 2,660 52 28   Pacific Northwest VHF Society                  
15  SOHP  KF7CQ ID 2015 2,405 60 37   Pacific Northwest VHF Society                  
 
16  SOHP  WC7Q WWA 2015 1,925 77 25   Western Washington DX Club                  
17  SOHP  KL7UW AK 2015 1,064 34 28   Alaska VHF-Up Group                  
18  SOHP  KD7PY WWA 2015 1,032 43 24   Pacific Northwest VHF Society                  
19  SOHP  N7BAV OR 2015 330 22 15                    
20  SOHP  KL7XJ AK 2015 84 8 7   Alaska VHF-Up Group                  
 
21  SOHP  K7EG WWA 2015 55 11 5   Western Washington DX Club                  
22  SOHP  KL7KY AK 2015 33 11 3                    

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

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