Other SOTA sites: SOTAwatch | SOTA Home | Database | Video | Photos | Shop | Mapping | FAQs | Facebook | Contact SOTA

Data mining the database for fun and profit -pt1

Just for fun here are the total activator points scored per year for each association. The period runs Jan 1st to Dec 31st for each and that most associations did not start on Jan 1st so the 1st year they appear will in the tables will be for less than a full year. Also many associations start with only a few summits per region and grow as their qualifying summits are documented. Does not include bonus points.

StartDate – EndDate ---- Associationname - Points
01/01/2002 - 31/12/2002 - England - 839
01/01/2002 - 31/12/2002 - Wales - 458
01/01/2002 - 31/12/2002 - Scotland - 146
01/01/2002 - 31/12/2002 - Northern Ireland - 42
01/01/2002 - 31/12/2002 - Isle Of Man - 18

StartDate – EndDate — Associationname - Points
01/01/2003 - 31/12/2003 - England - 2265
01/01/2003 - 31/12/2003 - Wales - 1416
01/01/2003 - 31/12/2003 - Scotland - 1116
01/01/2003 - 31/12/2003 - Germany (Low Mountains) - 783
01/01/2003 - 31/12/2003 - Ireland - 232
01/01/2003 - 31/12/2003 - Northern Ireland - 118
01/01/2003 - 31/12/2003 - South Africa - 25
01/01/2003 - 31/12/2003 - Isle Of Man - 18
01/01/2003 - 31/12/2003 - Greece - 6

StartDate – EndDate ---- Associationname - Points
01/01/2004 - 31/12/2004 - Germany (Low Mountains) - 5067
01/01/2004 - 31/12/2004 - England - 3278
01/01/2004 - 31/12/2004 - Wales - 2250
01/01/2004 - 31/12/2004 - Scotland - 1846
01/01/2004 - 31/12/2004 - Germany (Alpine) - 307
01/01/2004 - 31/12/2004 - Austria - 104
01/01/2004 - 31/12/2004 - Isle Of Man - 66
01/01/2004 - 31/12/2004 - Northern Ireland - 61
01/01/2004 - 31/12/2004 - Greece - 36
01/01/2004 - 31/12/2004 - Ireland - 26
01/01/2004 - 31/12/2004 - South Africa - 18

StartDate – EndDate ---- Associationname - Points
01/01/2005 - 31/12/2005 - Germany (Low Mountains) - 7941
01/01/2005 - 31/12/2005 - England - 4396
01/01/2005 - 31/12/2005 - Wales - 2324
01/01/2005 - 31/12/2005 - Scotland - 1749
01/01/2005 - 31/12/2005 - Hungary - 323
01/01/2005 - 31/12/2005 - Germany (Alpine) - 298
01/01/2005 - 31/12/2005 - Switzerland - 250
01/01/2005 - 31/12/2005 - Austria - 171
01/01/2005 - 31/12/2005 - Greece - 62
01/01/2005 - 31/12/2005 - Ireland - 54
01/01/2005 - 31/12/2005 - South Africa - 53
01/01/2005 - 31/12/2005 - Northern Ireland - 52
01/01/2005 - 31/12/2005 - Isle Of Man - 34

StartDate – EndDate ---- Associationname - Points
01/01/2006 - 31/12/2006 - Germany (Low Mountains) - 9979
01/01/2006 - 31/12/2006 - England - 5054
01/01/2006 - 31/12/2006 - Wales - 2700
01/01/2006 - 31/12/2006 - Switzerland - 1547
01/01/2006 - 31/12/2006 - Scotland - 1516
01/01/2006 - 31/12/2006 - Hungary - 732
01/01/2006 - 31/12/2006 - Germany (Alpine) - 448
01/01/2006 - 31/12/2006 - Austria - 415
01/01/2006 - 31/12/2006 - Isle Of Man - 180
01/01/2006 - 31/12/2006 - Greece - 112
01/01/2006 - 31/12/2006 - Northern Ireland - 79
01/01/2006 - 31/12/2006 - South Africa - 38

StartDate – EndDate ---- Associationname - Points
01/01/2007 - 31/12/2007 - Germany (Low Mountains) - 17342
01/01/2007 - 31/12/2007 - England - 5712
01/01/2007 - 31/12/2007 - Wales - 3289
01/01/2007 - 31/12/2007 - Switzerland - 2534
01/01/2007 - 31/12/2007 - Czechia - 2131
01/01/2007 - 31/12/2007 - Scotland - 1632
01/01/2007 - 31/12/2007 - Austria - 1408
01/01/2007 - 31/12/2007 - France - 1233
01/01/2007 - 31/12/2007 - Hungary - 980
01/01/2007 - 31/12/2007 - Germany (Alpine) - 626
01/01/2007 - 31/12/2007 - Greece - 587
01/01/2007 - 31/12/2007 - Belgium - 206
01/01/2007 - 31/12/2007 - Northern Ireland - 154
01/01/2007 - 31/12/2007 - Isle Of Man - 86
01/01/2007 - 31/12/2007 - Ireland - 72
01/01/2007 - 31/12/2007 - South Africa - 37
01/01/2007 - 31/12/2007 - USA - 1

StartDate – EndDate ---- Associationname - Points
01/01/2008 - 31/12/2008 - Germany (Low Mountains) - 20859
01/01/2008 - 31/12/2008 - England - 5376
01/01/2008 - 31/12/2008 - Czechia - 5289
01/01/2008 - 31/12/2008 - Wales - 2773
01/01/2008 - 31/12/2008 - Slovenia - 2623
01/01/2008 - 31/12/2008 - Switzerland - 2425
01/01/2008 - 31/12/2008 - Austria - 1868
01/01/2008 - 31/12/2008 - Scotland - 1519
01/01/2008 - 31/12/2008 - France - 1233
01/01/2008 - 31/12/2008 - Germany (Alpine) - 973
01/01/2008 - 31/12/2008 - Hungary - 961
01/01/2008 - 31/12/2008 - Greece - 506
01/01/2008 - 31/12/2008 - Norway - 209
01/01/2008 - 31/12/2008 - Northern Ireland - 193
01/01/2008 - 31/12/2008 - Belgium - 187
01/01/2008 - 31/12/2008 - Ireland - 95
01/01/2008 - 31/12/2008 - Liechtenstein - 64
01/01/2008 - 31/12/2008 - Poland - 51
01/01/2008 - 31/12/2008 - Isle Of Man - 39
01/01/2008 - 31/12/2008 - Sweden - 33
01/01/2008 - 31/12/2008 - Finland - 26
01/01/2008 - 31/12/2008 - South Africa - 14
01/01/2008 - 31/12/2008 - Netherlands - 8
01/01/2008 - 31/12/2008 - USA - 1

StartDate – EndDate ---- Associationname - Points
01/01/2009 - 31/12/2009 - Czechia - 6665
01/01/2009 - 31/12/2009 - Slovenia - 5867
01/01/2009 - 31/12/2009 - Germany (Low Mountains) - 5700
01/01/2009 - 31/12/2009 - England - 4521
01/01/2009 - 31/12/2009 - Austria - 4372
01/01/2009 - 31/12/2009 - Wales - 3259
01/01/2009 - 31/12/2009 - Switzerland - 2642
01/01/2009 - 31/12/2009 - Hungary - 2086
01/01/2009 - 31/12/2009 - France - 1614
01/01/2009 - 31/12/2009 - Scotland - 1607
01/01/2009 - 31/12/2009 - Greece - 969
01/01/2009 - 31/12/2009 - Germany (Alpine) - 772
01/01/2009 - 31/12/2009 - Belgium - 387
01/01/2009 - 31/12/2009 - Norway - 310
01/01/2009 - 31/12/2009 - Poland - 138
01/01/2009 - 31/12/2009 - Isle Of Man - 111
01/01/2009 - 31/12/2009 - USA - 110
01/01/2009 - 31/12/2009 - Northern Ireland - 69
01/01/2009 - 31/12/2009 - Sweden - 65
01/01/2009 - 31/12/2009 - Macedonia - 48
01/01/2009 - 31/12/2009 - Canada - 39
01/01/2009 - 31/12/2009 - Finland - 38
01/01/2009 - 31/12/2009 - Liechtenstein - 24
01/01/2009 - 31/12/2009 - Ireland - 13
01/01/2009 - 31/12/2009 - Netherlands - 9
01/01/2009 - 31/12/2009 - Corsica - 6

StartDate – EndDate ---- Associationname - Points
01/01/2010 - 31/12/2010 - Czechia - 9458
01/01/2010 - 31/12/2010 - Germany (Low Mountains) - 7253
01/01/2010 - 31/12/2010 - Slovenia - 6383
01/01/2010 - 31/12/2010 - Austria - 4978
01/01/2010 - 31/12/2010 - England - 4595
01/01/2010 - 31/12/2010 - Wales - 3005
01/01/2010 - 31/12/2010 - Switzerland - 2215
01/01/2010 - 31/12/2010 - Scotland - 1869
01/01/2010 - 31/12/2010 - France - 1675
01/01/2010 - 31/12/2010 - Greece - 1481
01/01/2010 - 31/12/2010 - Hungary - 1465
01/01/2010 - 31/12/2010 - USA - 1061
01/01/2010 - 31/12/2010 - Germany (Alpine) - 633
01/01/2010 - 31/12/2010 - Belgium - 381
01/01/2010 - 31/12/2010 - Norway - 353
01/01/2010 - 31/12/2010 - Ireland - 272
01/01/2010 - 31/12/2010 - Poland - 261
01/01/2010 - 31/12/2010 - Spain (North West) - 181
01/01/2010 - 31/12/2010 - South Korea - 169
01/01/2010 - 31/12/2010 - Liechtenstein - 166
01/01/2010 - 31/12/2010 - Macedonia - 138
01/01/2010 - 31/12/2010 - Canada - 136
01/01/2010 - 31/12/2010 - Northern Ireland - 128
01/01/2010 - 31/12/2010 - Isle Of Man - 123
01/01/2010 - 31/12/2010 - Sweden - 119
01/01/2010 - 31/12/2010 - Ukraine - 88
01/01/2010 - 31/12/2010 - Luxembourg - 66
01/01/2010 - 31/12/2010 - Romania - 64
01/01/2010 - 31/12/2010 - Spain (North) - 59
01/01/2010 - 31/12/2010 - Falkland Islands - 26
01/01/2010 - 31/12/2010 - Denmark - 22
01/01/2010 - 31/12/2010 - Canary Islands - 20
01/01/2010 - 31/12/2010 - Finland - 18
01/01/2010 - 31/12/2010 - Corsica - 18
01/01/2010 - 31/12/2010 - Netherlands - 17
01/01/2010 - 31/12/2010 - Spain (Central) - 14
01/01/2010 - 31/12/2010 - Bosnia and Herzegovinia - 12
01/01/2010 - 31/12/2010 - Spain (South East) - 12
01/01/2010 - 31/12/2010 - South Africa - 12
01/01/2010 - 31/12/2010 - Spain (Catalunya) - 7
01/01/2010 - 31/12/2010 - Malta - 5
01/01/2010 - 31/12/2010 - Nova Scotia - 2

Here is 2011 but this is only up to July 11th!

StartDate – EndDate ---- Associationname - Points
01/01/2011 - 31/12/2011 - Germany (Low Mountains) - 5423
01/01/2011 - 31/12/2011 - Slovenia - 5369
01/01/2011 - 31/12/2011 - Czechia - 5167
01/01/2011 - 31/12/2011 - Austria - 3479
01/01/2011 - 31/12/2011 - England - 2873
01/01/2011 - 31/12/2011 - Wales - 2581
01/01/2011 - 31/12/2011 - Scotland - 1451
01/01/2011 - 31/12/2011 - Switzerland - 1389
01/01/2011 - 31/12/2011 - USA - 1085
01/01/2011 - 31/12/2011 - France - 1047
01/01/2011 - 31/12/2011 - Spain (North West) - 828
01/01/2011 - 31/12/2011 - Spain (North) - 804
01/01/2011 - 31/12/2011 - Greece - 731
01/01/2011 - 31/12/2011 - Hungary - 592
01/01/2011 - 31/12/2011 - Poland - 533
01/01/2011 - 31/12/2011 - Germany (Alpine) - 519
01/01/2011 - 31/12/2011 - Belgium - 494
01/01/2011 - 31/12/2011 - South Korea - 227
01/01/2011 - 31/12/2011 - Norway - 196
01/01/2011 - 31/12/2011 - Ireland - 181
01/01/2011 - 31/12/2011 - Spain (Central) - 126
01/01/2011 - 31/12/2011 - Italy - 90
01/01/2011 - 31/12/2011 - Northern Ireland - 55
01/01/2011 - 31/12/2011 - Canary Islands - 54
01/01/2011 - 31/12/2011 - Spain (Catalunya) - 48
01/01/2011 - 31/12/2011 - Canada - 44
01/01/2011 - 31/12/2011 - Macedonia - 36
01/01/2011 - 31/12/2011 - Liechtenstein - 36
01/01/2011 - 31/12/2011 - Spain (South East) - 34
01/01/2011 - 31/12/2011 - Sweden - 33
01/01/2011 - 31/12/2011 - Romania - 28
01/01/2011 - 31/12/2011 - Bosnia and Herzegovinia - 26
01/01/2011 - 31/12/2011 - Isle Of Man - 24
01/01/2011 - 31/12/2011 - South Africa - 19
01/01/2011 - 31/12/2011 - Finland - 17
01/01/2011 - 31/12/2011 - Portugal - 16
01/01/2011 - 31/12/2011 - Netherlands - 13
01/01/2011 - 31/12/2011 - Luxembourg - 12
01/01/2011 - 31/12/2011 - Ukraine - 1
01/01/2011 - 31/12/2011 - Malta - 1

Andy, MM0FMF
Database Manager