Tuesday, 6 February 2018

06/02 January Total for the years 2008 to 2018

I have been playing on DemOn, worked out how to manipulate the SQLs etc and can do almost all that I could on IPMR.
The 2012 drop in numbers is the first year after the Group split and half the members formed their own group. Spot the winter finch years! Greenfinch numbers have drop considerably from 2013. Most of the species captured in numbers seem to be dropping with one or two exceptions. Yellowhammer captures mostly came from Boxford Common, wagtails and pipits from KSTW 
Species
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
TOT
Blackbird
7
20
30
23
13
13
5
4
3
4
10
132
Blackcap
1
1
2
4
2
1
1
12
Blue Tit
255
215
446
671
392
278
282
195
219
137
137
3227
Brambling
5
5
10
Bullfinch
4
7
1
7
2
3
1
2
1
28
Cetti's Warbler
1
1
Chaffinch
37
34
62
48
32
15
7
5
5
3
1
249
Chiffchaff
2
2
Coal Tit
11
31
76
32
18
35
30
31
29
28
35
356
Collared Dove
2
1
3
Common Redpoll
10
10
Dunnock
16
30
40
23
21
17
13
5
10
11
15
201
Fieldfare
3
2
5
Goldcrest
3
5
1
8
6
3
1
1
9
7
44
Goldfinch
31
71
64
155
88
37
29
28
30
43
24
600
Great Spotted Woodpecker
11
6
2
16
17
6
9
6
4
3
3
83
Great Tit
174
139
249
250
158
86
74
61
58
43
87
1379
Green Woodpecker
1
1
Greenfinch
19
15
8
47
40
5
7
5
1
5
5
157
Grey Wagtail
1
1
House Sparrow
1
3
4
9
4
1
1
23
Jackdaw
1
1
Jay
1
1
2
Kestrel
1
1
2
Kingfisher
1
1
1
1
4
Lesser Redpoll
196
11
63
129
1
400
Long-tailed Tit
15
53
45
75
33
39
21
4
29
22
18
354
Marsh Tit
14
6
5
4
7
1
9
3
6
2
3
60
Meadow Pipit
9
3
3
15
Moorhen
5
5
Nuthatch
5
5
6
12
4
1
5
5
2
13
58
Pied Wagtail (yarrellii)
1
12
1
1
2
17
Redwing
3
1
1
1
1
7
Reed Bunting
1
2
15
4
1
23
Robin
23
53
55
46
34
16
11
3
8
24
22
295
Rook
2
1
3
Siskin
3
57
4
45
1
6
116
Song Thrush
1
1
2
1
3
1
9
Sparrowhawk
2
1
3
Starling
5
7
3
3
2
1
1
22
Treecreeper
2
2
2
3
2
3
1
1
16
Willow Tit
1
1
2
Woodpigeon
1
1
2
1
1
6
Wren
3
4
6
7
7
5
2
1
2
3
3
43
Yellowhammer
1
5
6
Grand Total
649
707
1169
1714
918
682
516
356
546
344
392
7993

No comments: