Stats: Pubs photographed by county

[Dave M]

Feeling in one of my statto moods this afternoon and was just curious to know how complete the site is in terms of photos, so decided to look at the breakdown by county and thought I'd share the results.

The table shows:-
percentage of open pubs with a photo - number of open pubs with a photo - total number of open pubs - county


99.8% 824 826 Hertfordshire
99.7% 663 665 Bristol (County)
99.5% 728 732 Surrey
99.2% 2024 2041 London (Central)
99.0% 1125 1136 Essex
98.3% 1464 1490 Kent
96.9% 1385 1429 Lancashire
96.5% 2304 2388 London (Greater)
95.3% 1306 1371 North Yorkshire
95.2% 2217 2330 Manchester (Greater)
94.1% 1872 1990 West Yorkshire
93.5% 702 751 East Sussex
92.5% 468 506 Buckinghamshire
91.8% 1609 1753 West Midlands
88.8% 892 1004 Cheshire
88.1% 547 621 Shropshire
87.7% 647 738 Lothian
85.9% 927 1079 Merseyside
84.6% 241 285 Central
83.3% 925 1110 South Yorkshire
81.9% 962 1175 Derbyshire
81.8% 684 836 Cumbria
80.0% 345 431 Bedfordshire
80.0% 609 761 Suffolk
79.3% 520 656 Berkshire
78.8% 450 571 West Sussex
78.6% 372 473 Clwyd
76.8% 129 168 Isle Of Wight
74.6% 500 670 Cornwall
74.0% 154 208 Dumfries and Galloway
73.7% 387 525 East Riding of Yorkshire
73.6% 39 53 Rutland
72.0% 657 912 Somerset
71.8% 885 1232 Hampshire
71.3% 685 961 Nottinghamshire
71.2% 699 982 Staffordshire
69.3% 402 580 Worcestershire
68.5% 454 663 Cambridgeshire
66.8% 360 539 Warwickshire
65.6% 168 256 Herefordshire
65.1% 841 1292 Devon
62.8% 565 899 Norfolk
62.5% 384 614 Dorset
62.5% 427 683 Wiltshire
61.4% 439 715 Leicestershire
61.0% 439 720 Oxfordshire
59.6% 224 376 Gwynedd
58.7% 363 618 Gloucestershire
58.5% 199 340 Northumberland
57.2% 325 568 Dyfed
56.8% 460 810 County Durham
53.2% 251 472 Northamptonshire
51.7% 168 325 Fife
51.1% 71 139 Borders
50.2% 213 424 Highland
50.1% 506 1009 Lincolnshire
49.2% 184 374 West Glamorgan
49.1% 440 897 Tyne & Wear
47.9% 123 257 Powys
41.5% 188 453 Grampian
41.0% 680 1660 Strathclyde
33.3% 171 513 Tayside
32.2% 106 329 South Glamorgan
27.5% 123 447 Mid Glamorgan
21.5% 106 492 Gwent
16.1% 5 31 Western Isles
15.0% 54 360 Antrim
5.5% 3 55 Fermanagh
2.7% 4 149 Londonderry
2.3% 5 219 Down
1.5% 2 130 Tyrone
0.0% 0 20 Orkney
0.0% 0 82 Armagh
0.0% 0 22 Shetland Islands

[Strongers]

Wow!!!

That is very impressive!

[ROBCamra]

Right photographers, someone needs to go on holiday to Northern Ireland. :evilgrin:

[RogerB]

I'll have to dig out my old pics of the Orkneys - I'm sure I can find something with a pub in the background!

[Blackthorn]

Just two to do then to get Bristol top on 100%! Thanks mostly to Jonathan Wilde I might add.

It looks like BrewDog (http://www.pubsgalore.co.uk/pubs/631/) and Bristol Fashion (http://www.pubsgalore.co.uk/pubs/79134/) are the only two outstanding. Couldn't you pop out and do them on a lunch time Dave? :)

[Quinno]

Just two to do then to get Bristol top on 100%! Thanks mostly to Jonathan Wilde I might add.

It looks like BrewDog (http://www.pubsgalore.co.uk/pubs/631/) and Bristol Fashion (http://www.pubsgalore.co.uk/pubs/79134/) are the only two outstanding. Couldn't you pop out and do them on a lunch time Dave? :)

Dammit I walked past the Brewdog a few weeks back and I had my camera! If only I'd known...

[aleandhearty]

I walked past the Brewdog a few weeks back...

Always the best option! :D

[sheffield hatter]

Thanks for the stats, Dave. Just the sort of get out of bed call that photographers need...

I've been having a go at some of the photoless pubs in South Yorkshire, outside Sheffield (still one to do (http://www.pubsgalore.co.uk/pubs/76173/) there, but I'm waiting for the weather to improve as it's a long way to cycle). Picked up a few in Barnsley this week, and if my recent posts in the That Doesn't Go There! (http://forums.pubsgalore.co.uk/forumdisplay.php?6-That-Doesn-t-Go-There!) forum bear fruit:pray:, I'll have completed Barnsley town centre without leaving my computer desk. (Can't find the emoticon for a smug grin.)

[Rex_Rattus]

Thanks Dave. Interesting stuff. It seems that things generally get more patchy when you leave England. 101 unphotographed London pubs? We'll have to up our game.

Oh, and thanks for the new word (statto) - new to me anyway.

[Quinno]

Oh, and thanks for the new word (statto) - new to me anyway.

http://www.youtube.com/watch?v=mFtpdDhXwCU :D

[Oggwyn Trench]

Most of Shropshires unphotographed pubs are around Oswestry , will have to have a wander round up there when the football seasons finished .

[oldboots]

Sadly a third of the unphotographed pubs in North Yorkshire are in Middlesbrough, I knew we should have left Cleveland alone. There's a few in Saltburn so I might have a day at the seaside and hope the wind isn't blowing from Teesside :whistle:

[Mobyduck]

Really interesting stuff Dave, I like these kind of facts, need to up the game in my native Hampshire,being far flung N.E Hants I tend to gravitate toward Surrey and the big smoke but will try to up my game a little more locally, the trouble with this is, public transport out in the sticks is useless if not non existent and driving is a bit counter productive. Still, will have to try a bit harder.

[Dave M]

Glad people are enjoying these, I thought they might prove quite interesting. :)


Just two to do then to get Bristol top on 100%! Thanks mostly to Jonathan Wilde I might add.

It looks like BrewDog (http://www.pubsgalore.co.uk/pubs/631/) and Bristol Fashion (http://www.pubsgalore.co.uk/pubs/79134/) are the only two outstanding. Couldn't you pop out and do them on a lunch time Dave? :)

Sadly I don't work in the centre any more so not quite as easy to pop out - I was very tempted to hold off posting the stats till after I'd had a chance to go and get those two.


http://www.youtube.com/watch?v=mFtpdDhXwCU :D

Thanks for that! Statto was my hero back in the day. I actually own a couple of those Statto-esque dressing gowns. :muppet:

[london calling]

Just two to do then to get Bristol top on 100%! Thanks mostly to Jonathan Wilde I might add.

It looks like BrewDog (http://www.pubsgalore.co.uk/pubs/631/) and Bristol Fashion (http://www.pubsgalore.co.uk/pubs/79134/) are the only two outstanding. Couldn't you pop out and do them on a lunch time Dave? :)

Bristol Fashion has just entered my list of great pub names.

[Dave M]

Bristol Fashion has just entered my list of great pub names.

The name is definitely good, shame about the pub it is wasted on. It is a pretty dull Beefeater. :(

Anyway a certain muppet has just managed to track down a photo of BrewDog that he took last November and the Bristol Fashion from March 2007! :muppet:

So the latest table now looks like this:-


100.0% 665 665 Bristol (County)
99.8% 824 826 Hertfordshire
99.5% 728 732 Surrey
99.2% 2036 2053 London (Central)
99.0% 1126 1137 Essex
98.3% 1464 1490 Kent
96.9% 1385 1429 Lancashire
96.5% 2305 2389 London (Greater)
95.2% 1307 1373 North Yorkshire
95.2% 2217 2330 Manchester (Greater)
94.1% 1872 1990 West Yorkshire
93.4% 702 752 East Sussex
92.5% 468 506 Buckinghamshire
91.8% 1609 1753 West Midlands
88.8% 891 1003 Cheshire
88.1% 547 621 Shropshire
87.6% 647 739 Lothian
85.8% 927 1081 Merseyside
84.6% 241 285 Central
83.4% 926 1110 South Yorkshire
81.9% 962 1175 Derbyshire
81.8% 684 836 Cumbria
80.0% 345 431 Bedfordshire
80.0% 609 761 Suffolk
79.3% 520 656 Berkshire
78.9% 377 478 Clwyd
78.8% 450 571 West Sussex
76.8% 129 168 Isle Of Wight
74.6% 500 670 Cornwall
74.0% 154 208 Dumfries and Galloway
73.7% 387 525 East Riding of Yorkshire
73.6% 39 53 Rutland
72.0% 657 912 Somerset
71.8% 885 1232 Hampshire
71.3% 687 963 Nottinghamshire
71.1% 699 983 Staffordshire
69.4% 402 579 Worcestershire
68.5% 454 663 Cambridgeshire
66.8% 360 539 Warwickshire
65.6% 168 256 Herefordshire
65.1% 841 1292 Devon
62.9% 571 908 Norfolk
62.5% 384 614 Dorset
62.5% 427 683 Wiltshire
61.4% 439 715 Leicestershire
61.0% 439 720 Oxfordshire
59.6% 224 376 Gwynedd
58.6% 363 619 Gloucestershire
58.5% 199 340 Northumberland
57.2% 325 568 Dyfed
56.7% 460 811 County Durham
53.2% 251 472 Northamptonshire
51.7% 168 325 Fife
51.1% 71 139 Borders
50.2% 213 424 Highland
50.2% 510 1016 Lincolnshire
49.2% 184 374 West Glamorgan
49.1% 440 896 Tyne & Wear
47.9% 123 257 Powys
41.5% 188 453 Grampian
41.0% 680 1659 Strathclyde
33.3% 171 513 Tayside
32.2% 106 329 South Glamorgan
27.7% 124 447 Mid Glamorgan
21.5% 106 492 Gwent
16.1% 5 31 Western Isles
15.0% 54 360 Antrim
5.5% 3 55 Fermanagh
2.7% 4 149 Londonderry
2.3% 5 219 Down
1.5% 2 130 Tyrone
0.0% 0 20 Orkney
0.0% 0 22 Shetland Islands
0.0% 0 82 Armagh

[Maldenman]

A great performance overall for a site like this, proud to be part of it.

[Blackthorn]

Excellent, good work Dave. It's only right that Bristol should be top I think seeing as you're based here.

I just need to put a bit more work in to the reviews. 63% is not so good.

[Wild Rover]

Excellent stuff Dave,and this would be great if you had the time to do it on a monthly basis

[AlanH]

Oh I do love stats. It shows some very interesting results. Like Herts 99.8% but Bedford letting the whole area down on only 80.0%. I knew Wales would be low (I hope I have helped Clwyd stay on top) but South Wales is extremely poor, even (especially!) in the high population areas in Glamorgan.

But the real champion and first to 100% must be The Isle of Man with 89 out of 89 plus all seven closed pubs.
The photographers there certainly weren't legless!

[Aqualung]

Is Dumfries and Galloway an actual place??

I always thought it was a reference to Celebrity Big Brother!

[sheffield hatter]

... Bedford letting the whole area down on only 80.0%.

I've done as much of Luton as I can get to, but there's no way I'm going to go to Luton Airport to photograph this one (http://www.pubsgalore.co.uk/pubs/79055/), even if it is "land side" rather than "air side". Any volunteers?

[Al 10000]

Thanks for the Stats Dave,

I always like looking at things like that,there no surprise that Nottinghamshire is well down the list,who would want to visit the grim areas of north Nottinghamshire,i did but years ago when there were lots of pubs open in the old pit towns but i did'nt take any photos.
I dont think it likely that i will ever revisit these areas.

[AlanH]

If the photographers of Bristol are now bored with nothing left to capture, they should renew their passports and travel over (or under) the river to Wales where the neighbouring county of Gwent is the least photographed in Great Britain.
Take a trip up to Abergavenny or one of the two areas with 0% photos (Blaenavon and Ebbw Vale).

I am checking how long it will take to get down to South Wales on my bus pass.;)

[Dave M]

Excellent stuff Dave,and this would be great if you had the time to do it on a monthly basis

I am really rubbish at remembering to repost these sort of things on a regular basis, so as an alternative you can look at them at any time on a new Pub photos by county page (http://www.pubsgalore.co.uk/stats/photos-counties.php).

[Al 10000]

I am really rubbish at remembering to repost these sort of things on a regular basis, so as an alternative you can look at them at any time on a new Pub photos by county page (http://www.pubsgalore.co.uk/stats/photos-counties.php).

That is a great idea Dave,

Does this page update as soon as you add a photo to a pub that has not been photgraphed before.

[Dave M]

It updates at the point I approve the photo.

So for example Shropshire currently has 88.5% coverage and is in 17th position - but I have a few outstanding photos that need approving from Alan H which I think may push it up past Cheshire and into 16th.

Also Old Boots has submitted a few in North Yorkshire that may well be enough to move it above Greater Manchester in the table - still a few more needed to overtake Lancashire though... :)

[Quinno]

It updates at the point I approve the photo.

So for example Shropshire currently has 88.5% coverage and is in 17th position - but I have a few outstanding photos that need approving from Alan H which I think may push it up past Cheshire and into 16th.

Also Old Boots has submitted a few in North Yorkshire that may well be enough to move it above Greater Manchester in the table - still a few more needed to overtake Lancashire though... :)

I ruddy love SQL

[RogerB]

I've done as much of Luton as I can get to, but there's no way I'm going to go to Luton Airport to photograph this one (http://www.pubsgalore.co.uk/pubs/79055/), even if it is "land side" rather than "air side". Any volunteers?

I'm flying to France from Luton in October so if it's still there to be done...

[ROBCamra]

Most of Shropshires unphotographed pubs are around Oswestry , will have to have a wander round up there when the football seasons finished .

I was in Oswestry for about an hour on Tuesday. Didn't take the camera though. :o

[Mobyduck]

I checked out my reasonably local area ,(North Hampshire) and was quite surprised how many pubs are lacking photos , time to pull the finger out.

[AlanH]

I ruddy love SQL

:confused:

[AlanH]

I was in Oswestry for about an hour on Tuesday. Didn't take the camera though. :o

So was I. Drinking Offa's Dyke beers at £1.85 in The Old Vaults (http://www.pubsgalore.co.uk/pubs/32140/) :drinkup:
I DID take my camera! :)

(I have been there every day as my wife is in hospital there :( [that's Oswestry ...... NOT the pub!])

[Quinno]

:confused:

en.wikipedia.org/wiki/SQL

It's what I'm fairly sure Dave is using for these stats. I use it at work too.

[PaulOfHorsham]

Next up: a little dab of jQuery to sort the table by any column! :pray::rolleyes:

[Dave M]

Next up: a little dab of jQuery to sort the table by any column! :pray::rolleyes:I wouldn't get too hopeful on that if I were you! I'm really not good with front end development! :(

[Dave M]

And I really have to say well done to BF for clearly going out of his way to make trips to The Poacher (http://www.pubsgalore.co.uk/pubs/78836/) and Ancient Briton (http://www.pubsgalore.co.uk/pubs/14799/) :notworthy:

[Bucking Fastard]

Not that big a sacrifice,The Poacher is not far from where I work,and the Ancient Briton was on the way to the M1 and a boating and boozing extravaganza in the East Midlands.Good to see Hertfordshire in the 100% list however.Thanks for getting them authorised so quickly :notworthy:

[bcfczuluarmy]

Just seen this. Thanks for the comment Blackthorn regarding contributions to Bristol. I did wonder why the missing Bristol 2 randomly got pictures added shame I didn't take pictures when I was in them on 19/01/13, was dark when I got to Brew Dog and completely forgot when in Bristol Fashion :(

Any chance of Closed Pubs pictures stats?

[Al 10000]

I am really rubbish at remembering to repost these sort of things on a regular basis, so as an alternative you can look at them at any time on a new Pub photos by county page (http://www.pubsgalore.co.uk/stats/photos-counties.php).

I thought i would give the pubs photo page a bump so we could see how thing are going without going through the pages.

[Strongers]

Hats off to David Ross for venturing onto the Shetlands! :notworthy:

[Pangolin]

Any chance of an update Dave?

I think I just eliminated the last one in Surrey as it is closed: the Handsome Pig (http://www.pubsgalore.co.uk/pubs/35877/), formerly Marco Pierre White's King's Head (although it is actually in West Sussex anyway - the old post code issue).

[sheffield hatter]

Any chance of an update Dave?

I think I just eliminated the last one in Surrey as it is closed: the Handsome Pig (http://www.pubsgalore.co.uk/pubs/35877/), formerly Marco Pierre White's King's Head (although it is actually in West Sussex anyway - the old post code issue).

No need to wait for Dave, just use this link (http://www.pubsgalore.co.uk/stats/photos-counties.php), which confirms Surrey has joined the 100% club. Still need to get the photo in case the pub reopens!

[bcfczuluarmy]

just use this link (http://www.pubsgalore.co.uk/stats/photos-counties.php),

Cheers for that link as I knew it was on here somewhere which gave your own stats per area but couldn't find it. I really must finish Bristol as I've only 30 left to do but mostly all in town and I can't be bothered to wonder around at the moment. Maybe when I've finished jaunts around Stroud I'll sort it.

Will that make me the first 100% per County photographed????

Edit I've checked my records and I've got less than 30 to do so can admin tell me the 30 left for Bristol?

[Blackthorn]

Will that make me the first 100% per County photographed????

I'd be very surprised if it didn't. That would be a most impressive achievement Jon. Are you going for 100% in Gloucestershire, Wiltshire & Somerset as well?

[Dave M]

Just approved a massive backlog of photos and noticed a lot of people have been very busy finding previously unphotographed pubs so went off and checked the stats.

We have now just passed 42,000 pubs photographed (http://www.pubsgalore.co.uk/stats/photos-counties.php) and North Yorkshire has reached 100% for which I think we have Old Boots to thank for making a few special trips!

Anyway great effort by everyone on the site, thank you all and keep the photos coming :notworthy:

[bcfczuluarmy]

Just approved a massive backlog of photos

I noticed today, that leaves me with 3 to photograph in Bristol County and only 2 closed ones left then I'll be 100% for all of them listed I think. I've got pictures of a fair few older closed ones but no point adding them as they are long gone. Some of them I find it hard to believe never made it on here when I wracked my brain remembering some done pre 2000.

Your efforts are appreciated. http://www.306gti6.com/images/smileys/thumbsup.gif

[oldboots]

and North Yorkshire has reached 100% for which I think we have Old Boots to thank for making a few special trips!



OCD Rules!

Thanks for working through them all Dave.

[sheffield hatter]

OCD Rules!

Well done OB & OCD.

I'm trying to apply my own version of OCD to South Yorkshire, but there's a stumbling block - the Wetherspoons (http://www.pubsgalore.co.uk/pubs/56329/) "airside" at Robin Hood Airport. No amount of misdirected enthusiasm is going to get me airside at this airport, so we need a volunteer to take a photo of this elusive 'Spoons. (Please.)

[bcfczuluarmy]

Not even my dad has done that one yet so sorry can't help with a picture. He did however mention it has limited opening hours.

[bcfczuluarmy]

I now have 100% photos of Bristol County Done. Still got 2 closed pubs to photo what got built as it was a shopping centre that saw them destroyed then that's every pub listed in Bristol County photographed.

[Strongers]

I now have 100% photos of Bristol County Done. Still got 2 closed pubs to photo what got built as it was a shopping centre that saw them destroyed then that's every pub listed in Bristol County photographed.

:notworthy:

[hondo]

I now have 100% photos of Bristol County Done. Still got 2 closed pubs to photo what got built as it was a shopping centre that saw them destroyed then that's every pub listed in Bristol County photographed.
well done :cheers:

[Mobyduck]

I now have 100% photos of Bristol County Done. Still got 2 closed pubs to photo what got built as it was a shopping centre that saw them destroyed then that's every pub listed in Bristol County photographed.
Happy Snapper. :cheers:

[sheffield hatter]

I've just submitted the photos on the final previously unphotographed pub in Barnsley (http://www.pubsgalore.co.uk/townsp/barnsley/south-yorkshire/) - that just leaves Doncaster to do and then South Yorkshire will be complete. The bad news is, there's about 90 of them! (And they're scattered around among nearly as many suburbs and villages - that's an awful lot of cycling and with winter coming on, too.) So if anyone has a bit of time on their hands, please get yourself up to Doncaster and photograph some pubs. :pray:


PS Thanks to Dave for getting those last Barnsley photos up so quickly.

[Quinno]

if anyone has a bit of time on their hands, please get yourself up to Doncaster and photograph some pubs. :pray:

Now that's optimism!

[Bucking Fastard]

So if anyone has a bit of time on their hands, please get yourself up to Doncaster and photograph some pubs. :pray:




I seem to remember that Strongers is going to Donny after the PuG Leeds meet up ,so you could prevail on his good nature. He does seem to pack a lot of pubs into his crawls.:notworthy:However as most of the unreviewed pubs in Doncaster Town are in the notorious Silver Street he may have his hands full imbibing there on a Saturday night.:evilgrin: