Ads not shown when logged in
Page 1 of 2 12 LastLast
Results 1 to 10 of 49

Thread: The updated County Information

Hybrid View

  1. #1
    Former Pubs Galore Coder
    Join Date
    Nov 2006
    Location
    Bristol
    Posts
    5,931

    Default The updated County Information

    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
    Attached Files Attached Files

  2. #2
    I'll stay on me own Andy Ven's Avatar
    Join Date
    Jul 2007
    Location
    Black Country
    Posts
    719

    Default

    West Midlands is looking good.

    Anyone fancy a trip to the Orkneys or Shetlands?

    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)
    Last edited by Andy Ven; 06-04-2010 at 18:47.
    Waes hael!

  3. #3
    The Beerhunter. RogerB's Avatar
    Join Date
    Dec 2009
    Location
    Dartford, Kentshire near Londinium.
    Posts
    1,976

    Default

    Quote Originally Posted by Andy Ven View Post
    West Midlands is looking good.

    Anyone fancy a trip to the Orkneys or Shetlands?
    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.

  4. #4
    I'll stay on me own Andy Ven's Avatar
    Join Date
    Jul 2007
    Location
    Black Country
    Posts
    719

    Default

    Quote Originally Posted by RogerB View Post
    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.
    Would you recommend a visit or go again yourself?
    Waes hael!

  5. #5
    Former Pubs Galore Coder
    Join Date
    Nov 2006
    Location
    Bristol
    Posts
    5,931

    Default

    The pictured/reviewed numbers relate to the closed pubs as well.

  6. #6
    The Beerhunter. RogerB's Avatar
    Join Date
    Dec 2009
    Location
    Dartford, Kentshire near Londinium.
    Posts
    1,976

    Default

    Quote Originally Posted by Andy Ven View Post
    Would you recommend a visit or go again yourself?
    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.

  7. #7
    We're not really 'ere! trainman's Avatar
    Join Date
    Jan 2010
    Location
    down 'ere, from oop there
    Posts
    2,246

    Default

    Quote Originally Posted by RogerB View Post
    We went up there during the World Cup '96
    Maybe Euro96 or World Cup98? But why on earth would you wanna be in Scotland then?
    World Cup94, maybe...

  8. #8
    I'll stay on me own Andy Ven's Avatar
    Join Date
    Jul 2007
    Location
    Black Country
    Posts
    719

    Default

    Quote Originally Posted by RogerB View Post
    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.
    Sounds good. I quite fancy hiring a tourer and driving around in a big loop but I wouldn't want midges to spoil my holiday (I accept we can't do anything about the weather). What would be a good time of year?
    Waes hael!

  9. #9
    Old & Bitter oldboots's Avatar
    Join Date
    Oct 2009
    Posts
    5,588

    Default

    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
    Last edited by oldboots; 07-04-2010 at 15:17.

  10. #10
    Former Pubs Galore Coder
    Join Date
    Nov 2006
    Location
    Bristol
    Posts
    5,931

    Default



    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.

Similar Threads

  1. Friday Stats: County information
    By Conrad in forum Chit Chat
    Replies: 26
    Last Post: 21-11-2009, 10:05
  2. Drank in at least in every English County
    By hopwas in forum Chit Chat
    Replies: 28
    Last Post: 06-11-2009, 12:04
  3. Replies: 0
    Last Post: 01-08-2007, 08:52

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •