As requested in the 100 not out thread these are the up to date County stats advanced on since the last one at the end of October. I have also attached a zip of the csv from which this information is built to this and the last thread.
England, Bedfordshire
521 Pubs
465 Open pubs
197 Reviews
157 Pubs with reviews
817 Photos
200 Pubs with photos
England, Berkshire
666 Pubs
631 Open pubs
183 Reviews
137 Pubs with reviews
869 Photos
220 Pubs with photos
England, Buckinghamshire
632 Pubs
575 Open pubs
184 Reviews
158 Pubs with reviews
937 Photos
503 Pubs with photos
England, Cambridgeshire
718 Pubs
694 Open pubs
150 Reviews
115 Pubs with reviews
1376 Photos
232 Pubs with photos
England, Central London
2451 Pubs
2058 Open pubs
2479 Reviews
1326 Pubs with reviews
17846 Photos
2299 Pubs with photos
England, Cheshire
966 Pubs
911 Open pubs
345 Reviews
258 Pubs with reviews
1009 Photos
657 Pubs with photos
England, Cornwall
670 Pubs
662 Open pubs
245 Reviews
189 Pubs with reviews
640 Photos
368 Pubs with photos
England, County Durham
824 Pubs
773 Open pubs
175 Reviews
149 Pubs with reviews
325 Photos
255 Pubs with photos
England, Cumbria
836 Pubs
816 Open pubs
146 Reviews
126 Pubs with reviews
626 Photos
399 Pubs with photos
England, Derbyshire
1228 Pubs
1171 Open pubs
262 Reviews
206 Pubs with reviews
595 Photos
506 Pubs with photos
England, Devon
1324 Pubs
1282 Open pubs
334 Reviews
275 Pubs with reviews
2955 Photos
761 Pubs with photos
England, Dorset
614 Pubs
591 Open pubs
198 Reviews
154 Pubs with reviews
201 Photos
145 Pubs with photos
England, East Riding of Yorkshire
462 Pubs
450 Open pubs
203 Reviews
158 Pubs with reviews
242 Photos
188 Pubs with photos
England, East Sussex
769 Pubs
751 Open pubs
280 Reviews
186 Pubs with reviews
1292 Photos
496 Pubs with photos
England, Essex
1354 Pubs
1165 Open pubs
504 Reviews
396 Pubs with reviews
8323 Photos
1314 Pubs with photos
England, Gloucestershire
726 Pubs
718 Open pubs
68 Reviews
59 Pubs with reviews
162 Photos
125 Pubs with photos
England, Greater Bristol
504 Pubs
448 Open pubs
199 Reviews
148 Pubs with reviews
491 Photos
291 Pubs with photos
England, Greater London
2969 Pubs
2553 Open pubs
2091 Reviews
1491 Pubs with reviews
9192 Photos
2475 Pubs with photos
England, Greater Manchester
2635 Pubs
2386 Open pubs
790 Reviews
649 Pubs with reviews
3333 Photos
1890 Pubs with photos
England, Hampshire
1384 Pubs
1276 Open pubs
493 Reviews
411 Pubs with reviews
1817 Photos
701 Pubs with photos
England, Herefordshire
220 Pubs
216 Open pubs
74 Reviews
63 Pubs with reviews
103 Photos
62 Pubs with photos
England, Hertfordshire
858 Pubs
789 Open pubs
392 Reviews
304 Pubs with reviews
2384 Photos
505 Pubs with photos
England, Isle Of Wight
167 Pubs
163 Open pubs
42 Reviews
37 Pubs with reviews
206 Photos
92 Pubs with photos
England, Kent
1666 Pubs
1480 Open pubs
725 Reviews
590 Pubs with reviews
8115 Photos
1288 Pubs with photos
England, Lancashire
1736 Pubs
1532 Open pubs
514 Reviews
431 Pubs with reviews
3377 Photos
1470 Pubs with photos
England, Leicestershire
834 Pubs
807 Open pubs
144 Reviews
125 Pubs with reviews
592 Photos
166 Pubs with photos
England, Lincolnshire
1057 Pubs
1039 Open pubs
161 Reviews
146 Pubs with reviews
307 Photos
240 Pubs with photos
England, Merseyside
1101 Pubs
1022 Open pubs
254 Reviews
216 Pubs with reviews
783 Photos
620 Pubs with photos
England, Norfolk
965 Pubs
896 Open pubs
209 Reviews
175 Pubs with reviews
2814 Photos
424 Pubs with photos
England, North Yorkshire
1429 Pubs
1359 Open pubs
768 Reviews
570 Pubs with reviews
2050 Photos
1028 Pubs with photos
England, Northamptonshire
551 Pubs
539 Open pubs
119 Reviews
108 Pubs with reviews
426 Photos
148 Pubs with photos
England, Northumberland
304 Pubs
300 Open pubs
102 Reviews
74 Pubs with reviews
163 Photos
118 Pubs with photos
England, Nottinghamshire
930 Pubs
875 Open pubs
80 Reviews
66 Pubs with reviews
273 Photos
179 Pubs with photos
England, Oxfordshire
774 Pubs
751 Open pubs
129 Reviews
112 Pubs with reviews
427 Photos
191 Pubs with photos
England, Rutland
62 Pubs
60 Open pubs
3 Reviews
3 Pubs with reviews
12 Photos
7 Pubs with photos
England, Shropshire
707 Pubs
666 Open pubs
379 Reviews
260 Pubs with reviews
421 Photos
281 Pubs with photos
England, Somerset
1048 Pubs
1009 Open pubs
244 Reviews
205 Pubs with reviews
982 Photos
381 Pubs with photos
England, South Yorkshire
1225 Pubs
1177 Open pubs
206 Reviews
177 Pubs with reviews
686 Photos
583 Pubs with photos
England, Staffordshire
1204 Pubs
1131 Open pubs
598 Reviews
418 Pubs with reviews
784 Photos
469 Pubs with photos
England, Suffolk
847 Pubs
779 Open pubs
175 Reviews
147 Pubs with reviews
3282 Photos
488 Pubs with photos
England, Surrey
839 Pubs
779 Open pubs
353 Reviews
295 Pubs with reviews
1148 Photos
383 Pubs with photos
England, Tyne & Wear
803 Pubs
791 Open pubs
137 Reviews
107 Pubs with reviews
166 Photos
125 Pubs with photos
England, Warwickshire
614 Pubs
591 Open pubs
163 Reviews
137 Pubs with reviews
386 Photos
254 Pubs with photos
England, West Midlands
2112 Pubs
1703 Open pubs
1386 Reviews
980 Pubs with reviews
2620 Photos
1624 Pubs with photos
England, West Sussex
601 Pubs
574 Open pubs
167 Reviews
134 Pubs with reviews
725 Photos
308 Pubs with photos
England, West Yorkshire
2438 Pubs
2123 Open pubs
692 Reviews
538 Pubs with reviews
2814 Photos
1850 Pubs with photos
England, Wiltshire
682 Pubs
650 Open pubs
194 Reviews
153 Pubs with reviews
602 Photos
238 Pubs with photos
England, Worcestershire
591 Pubs
572 Open pubs
166 Reviews
144 Pubs with reviews
401 Photos
265 Pubs with photos
Isle of Man, Isle of Man
91 Pubs
84 Open pubs
15 Reviews
13 Pubs with reviews
160 Photos
89 Pubs with photos
Northern Ireland, Antrim
344 Pubs
343 Open pubs
55 Reviews
41 Pubs with reviews
61 Photos
42 Pubs with photos
Northern Ireland, Armagh
82 Pubs
82 Open pubs
0 Reviews
0 Pubs with reviews
0 Photos
0 Pubs with photos
Northern Ireland, Down
228 Pubs
224 Open pubs
11 Reviews
10 Pubs with reviews
8 Photos
3 Pubs with photos
Northern Ireland, Fermanach
56 Pubs
56 Open pubs
1 Reviews
1 Pubs with reviews
3 Photos
3 Pubs with photos
Northern Ireland, Londonderry
156 Pubs
156 Open pubs
1 Reviews
1 Pubs with reviews
3 Photos
2 Pubs with photos
Northern Ireland, Tyrone
130 Pubs
130 Open pubs
3 Reviews
3 Pubs with reviews
2 Photos
2 Pubs with photos
Scotland, Borders
146 Pubs
142 Open pubs
18 Reviews
17 Pubs with reviews
46 Photos
38 Pubs with photos
Scotland, Central
289 Pubs
282 Open pubs
53 Reviews
50 Pubs with reviews
256 Photos
209 Pubs with photos
Scotland, Dumfries and Galloway
207 Pubs
206 Open pubs
42 Reviews
35 Pubs with reviews
145 Photos
76 Pubs with photos
Scotland, Fife
291 Pubs
289 Open pubs
30 Reviews
24 Pubs with reviews
49 Photos
34 Pubs with photos
Scotland, Grampian
423 Pubs
417 Open pubs
53 Reviews
45 Pubs with reviews
70 Photos
54 Pubs with photos
Scotland, Highland
368 Pubs
365 Open pubs
57 Reviews
49 Pubs with reviews
174 Photos
120 Pubs with photos
Scotland, Lothian
813 Pubs
746 Open pubs
230 Reviews
201 Pubs with reviews
800 Photos
566 Pubs with photos
Scotland, Orkney
21 Pubs
21 Open pubs
0 Reviews
0 Pubs with reviews
0 Photos
0 Pubs with photos
Scotland, Shetland Islands
17 Pubs
17 Open pubs
0 Reviews
0 Pubs with reviews
0 Photos
0 Pubs with photos
Scotland, Strathclyde
1480 Pubs
1456 Open pubs
183 Reviews
158 Pubs with reviews
307 Photos
230 Pubs with photos
Scotland, Tayside
475 Pubs
469 Open pubs
41 Reviews
40 Pubs with reviews
59 Photos
41 Pubs with photos
Scotland, Western Isles
4 Pubs
4 Open pubs
1 Reviews
1 Pubs with reviews
0 Photos
0 Pubs with photos
Wales, Clwyd
527 Pubs
512 Open pubs
77 Reviews
70 Pubs with reviews
279 Photos
186 Pubs with photos
Wales, Dyfed
499 Pubs
481 Open pubs
81 Reviews
72 Pubs with reviews
278 Photos
176 Pubs with photos
Wales, Gwent
438 Pubs
438 Open pubs
40 Reviews
33 Pubs with reviews
65 Photos
52 Pubs with photos
Wales, Gwynedd
311 Pubs
307 Open pubs
80 Reviews
70 Pubs with reviews
151 Photos
99 Pubs with photos
Wales, Mid Glamorgan
440 Pubs
419 Open pubs
85 Reviews
74 Pubs with reviews
125 Photos
108 Pubs with photos
Wales, Powys
215 Pubs
208 Open pubs
42 Reviews
41 Pubs with reviews
97 Photos
78 Pubs with photos
Wales, South Glamorgan
286 Pubs
281 Open pubs
52 Reviews
38 Pubs with reviews
118 Photos
58 Pubs with photos
Wales, West Glamorgan
371 Pubs
365 Open pubs
53 Reviews
43 Pubs with reviews
152 Photos
104 Pubs with photos
Do the pubs with reviews, pubs with photos etc stats relate to all pubs or just open pubs? (Obviously the demolished pubs with no current photo or review are never going to get covered)
I've done the Orkneys! Didn't get much time there but had a couple of pints in Kirkwall but it was in my pre-review days and I wouldn't for the life of me remember which pubs we did.
I've done the Orkneys! Didn't get much time there but had a couple of pints in Kirkwall but it was in my pre-review days and I wouldn't for the life of me remember which pubs we did.
Absolutely! I'd be up there tomorrow given half the chance. We did a wildlife boat trip around Stroma, a small uninhabited island just off John O'Groats which is a must if you like that kind of thing although 100,000 guillemots perched in a cove do tend to reek a bit. We also went to the mainland and did the ancient sites (Skara Brae, the Ring of Brodgar etc) which are fascinating plus there are plenty of interesting WW1 & 2 sites as well as Scapa Flow where the German fleet was scuttled.
We went up there during the World Cup '96 and stayed in Fort William for the first week and then some obscure village I can't remember the name of about an hour's drive from John O'Groats for the second. Pubs are few and far between anywhere in the Scottish Highlands and islands and as far as the Orkneys are concerned, apart from Kirkwall on the main island you won't find much. I would think there would be a few Orkney beers (Red MacGregor seems to be the one that usually crops up in the real world) but don't expect much variety if you go.
I woke up in a cold sweat in the middle of the night having realised that there wasn't a World Cup in '96. I thought no problem, no bugger will notice before I get into work at 8.30am and amend it to '98.
Call me a sad geek with too much time if you like, and you'd probably be right, but I had a look at the stats since Conrad provided the CSv version. For those who like this sort of thing there are some interesting surprises.
Coverage, or if you prefer penetration, is easy so here's the top 10 (based on pubs with a review/photo as a percentage of open pubs) Octobers rank in brackets
Reviews
1. Central London (3)
2. Greater London (4)
3. West Midlands (1)
4. North Yorks (2)
5. Kent (24)
6. Shropshire (9)
7. Hertfordshire (32)
8. Surrey (16)
9. Staffordshire (8)
10. East Riding of Yorkshire (5)
Photos
1. Essex (11th for reviews)
2. Central London
3. Isle of Man
4. Greater London
5. Lancashire
6. W Midlands
7. Buckinghamshire
8. W Yorks
9. Kent
10. Greater Manchester
The bottom five
Reviews
Shetland, Orkney, Armagh, Londonderry and Fermanagh
(for just England in reverse order Rutland, Nottinghamshire, Gloucestershire, Tyne & Wear, Lincolnshire)
Photos
Shetland, Orkney, Armagh, Western Isles and Londonderry
(for just England in reverse order Rutland, Tyne & Wear, Gloucestershire, Nottinghamshire, Leicestershire)
and finally where we have been busiest adding reviews between October and now (as a percentage rise)
1. Hertfordshire
2. E Sussex
3. Lothian
4. Kent
5. Central London
6. Borders
7. S Yorks
8. Gtr London
9. Shropshire
10. Antrim
You are always welcome to any numbers you want, but just in case you are bothered you should do your numbers as pubs with a review/photo as a percentage of all pubs.
I don't imagine it will make any real difference, but I would need to give you different numbers to supply that.