Open Pubs - Huntingdonshire

1. Home
2. Open Pubs

Description

Subset of the Open Pubs dataset including only pubs falling within the Huntingdonshire local authority.

Includes pub name, address, and position in eastings and northings and latitude and longitude as open data.

Download

Download

Filename: open_pubs_huntingdonshire.csv

Version

February 2022

Source

Derived from the Food Standard Agency's Food Hygiene Ratings and the ONS Postcode Directory.

Licence

Open data - free to use for any purpose.

Food Standard Agency's Food Hygiene Ratings is licensed under the FSA's terms & conditions.

The ONS Postcode Directory is licensed under the Open Government Licence.

Fields

Field	Possible Values	Comments
fsa_id	int	Food Standard Agency's ID for this pub.
name	string	Name of the pub.
address	string	Address fields separated by commas.
postcode	string	Postcode of the pub.
easting	int
northing	int
latitude	decimal
longitude	decimal
local authority	string	Local authority this pub falls under.

Data

List of pubs included in Open Pubs under Huntingdonshire:

• The Crown Inn
  Crown Inn Public House, Phoenix Park, Wyboston, Bedford, PE19 8EN
• Addison Arms
  Public House Addison Arms Sawtry Road, Glatton, Cambridgeshire, PE28 5RZ
• Alconbury Sports & Social Club
  Alconbury Sports And Social Club Alconbury Sports And Social Club Great North Road, Alconbury, Cambridgeshire, PE28 4EX
• Axe And Compass Ltd
  Axe And Compass Axe And Compass High Street, Hemingford Abbots, Cambridgeshire, PE28 9AH
• Barley Mow
  Public House Barley Mow 27 Crosshall Road, Eaton Ford, Cambridgeshire, PE19 7AB
• Black Bull Godmanchester
  Public House The Black Bull 32 Post Street, Godmanchester, Cambridgeshire, PE29 2AQ
• Black Horse
  Public House Black Horse 14 Overend, Elton, Cambridgeshire, PE8 6RU
• Brampton Institute
  Brampton Institute 18 High Street, Brampton, Cambridgeshire, PE28 4TG
• Brampton Memorial Centre
  Brampton Memorial Centre And Playing Field Thrapston Road, Brampton, Cambridgeshire, PE28 4UE
• Brampton Mill
  Brampton Mill Brampton Mill Bromholme Lane, Brampton, Cambridgeshire, PE28 4NE
• Cookhouse & Pub The Highwayman
  Managers Accommodation The Highwayman 2 Marlborough Road, Colmworth Business Park, Eaton Socon, Cambridgeshire, PE19 8YP
• Cross Keys
  Public House Cross Keys 21 Elton Road, Wansford, Cambridgeshire, PE8 6JD
• D & L Hospitality Ltd
  Public House Royal Oak 13 Crown Street, St Ives, Cambridgeshire, PE27 5EB
• Da Vincis
  83 High Street, Huntingdon, Cambridgeshire, PE29 3ER
• Dog And Castle
  Public House The Dog And Castle The Green, Woodwalton, Cambridgeshire, PE28 5YN
• Duck And Drake
  Public House Duck And Drake 34 Main Street, Yaxley, Cambridgeshire, PE7 3LY
• Eaton Socon Ex-service Club
  20 School Lane, Eaton Socon, Cambridgeshire, PE19 8GW
• Farmer Hospitality Limited
  Cambridgeshire Hunter Cambridgeshire Hunter Berkley Street, Eynesbury, Cambridgeshire, PE19 2NF
• Floods Tavern
  27 The Broadway, St Ives, Cambridgeshire, PE27 5BX
• Fox And Hounds
  80 Main Street, Great Gidding, Cambridgeshire, PE28 5NU
• George & Dragon
  Public House George And Dragon 267 Great North Road, Eaton Socon, Cambridgeshire, PE19 8BL
• Green Man Pub (Wet Sales)
  The Green Man 39 The Avenue, Leighton Bromswold, Cambridgeshire, PE28 5AW
• Greystones
  Greystones Public House The Green Greystones Public House High Street, Sawtry, Cambridgeshire, PE28 5ST
• Hail Weston Pub Company Ltd
  Public House The Royal Oak 79 High Street, Hail Weston, Cambridgeshire, PE19 5JW
• Hare & Hounds
  Public House Hare And Hounds Berkley Street, Eynesbury, Cambridgeshire, PE19 2TX
• Hare On The Green
  40 The Green, Brampton, Cambridgeshire, PE28 4RH
• Haywain
  The Haywain Constable Road, St Ives, Cambridgeshire, PE27 3EP
• Huntingdon Boat Club
  Huntingdon Rowing Club Huntingdon Rowing Club Hartford Road, Huntingdon, Cambridgeshire, PE29 3RP
• Huntingdon Masonic Hall Ltd
  5 Sovereign Court, Huntingdon, Cambridgeshire, PE29 6XU
• Huntingdon Pool And Snooker Club
  St Benedicts Court St Benedicts Court High Street, Huntingdon, Cambridgeshire, PE29 3PN
• Huntingdon Town Football Club
  Huntingdon Football Club Kings Ripton Road, Sapley, Cambridgeshire, PE28 2NU
• Hunts Sailing Club
  Hunts Sailing Club Hunts Sailing Club Harrison Way, St Ives, Cambridgeshire, PE27 4YA
• King Of The Belgians
  27 Main Street, Hartford, Cambridgeshire, PE29 1XU
• Lord Protector
  Lord Protector Lord Protector Mayfield Road, Huntingdon, Cambridgeshire, PE29 1NH
• Mad Cat Inn
  Public House Mad Cat Inn High Street, Pidley, Cambridgeshire, PE28 3BX
• Manor House Hotel
  The Manor House Hotel The Manor House Hotel Chapel Street, Alconbury, Cambridgeshire, PE28 4DY
• Market Inn
  Public House Market Inn Market Hill, Huntingdon, Cambridgeshire, PE29 3NJ
• Montagu Working Men's Club
  14 Hartford Road, Huntingdon, Cambridgeshire, PE29 3QD
• Nelsons Head
  7 Merryland, St Ives, Cambridgeshire, PE27 5ED
• Pig N Falcon
  Pig N Falcon 9 New Street, St Neots, Cambridgeshire, PE19 1AE
• Prince Of Wales
  Public House Prince Of Wales Potton Road, Hilton, Cambridgeshire, PE28 9NG
• Rafa Club
  44 Huntingdon Street, St Neots, Cambridgeshire, PE19 1DU
• Richardsons Catering
  5 Sovereign Court, Huntingdon, Cambridgeshire, PE29 6XU
• Rose And Crown
  99 High Street, Somersham, Cambridgeshire, PE28 3EE
• Royal Air Force Association
  152 Main Street, Yaxley, Cambridgeshire, PE7 3LB
• Royal British Legion
  210 Broadway, Yaxley, Cambridgeshire, PE7 3NR
• S Bar
  Flat 4 2 - 4 High Street, Stilton, Cambridgeshire, PE7 3RA
• Samuel Pepys ( Pub )
  146 High Street, Huntingdon, Cambridgeshire, PE29 3TF
• Sandford House
  The Sandford House Hotel The Sandford House Hotel George Street, Huntingdon, Cambridgeshire, PE29 3BD
• Sawtry Ex-servicemens Club
  10 Gidding Road, Sawtry, Cambridgeshire, PE28 5TS
• Seven Wives
  The Seven Wives The Seven Wives Ramsey Road, St Ives, Cambridgeshire, PE27 5RF
• St Neots Conservative Club
  12 New Street, St Neots, Cambridgeshire, PE19 1AE
• St Neots Rowing Club
  St Neots Rowing Club St Neots Rowing Club Priory Lane, St Neots, Cambridgeshire, PE19 2BH
• St Neots Rugby Club
  The Clubhouse The Clubhouse New Street, St Neots, Cambridgeshire, PE19 1RU
• The Admiral Wells
  Public House The Admiral Wells Public House Station Road, Holme, Cambridgeshire, PE7 3PH
• The Ale House Kitchen
  65 High Street, Ramsey, Cambridgeshire, PE26 1AB
• The Angel
  Public House The Angel 76 High Street, Ramsey, Cambridgeshire, PE26 1BS
• The Barley Mow
  Public House The Barley Mow 42 Main Street, Hartford, Cambridgeshire, PE29 1XU
• The Bell
  Public House The Bell 50 High Street, Great Paxton, Cambridgeshire, PE19 6RF
• The Bell
  The Bell Inn Green End Road, Sawtry, Cambridgeshire, PE28 5UY
• The Black Bull
  25 Church Road, Brampton, Cambridgeshire, PE28 4PF
• The Coach House
  Public House The Coach House 18 High Street, St Neots, Cambridgeshire, PE19 1JA
• The Cock Inn
  The Cock Inn 47 High Street, Hemingford Grey, Cambridgeshire, PE28 9BJ
• The Comrades Club
  58 Cambridge Street, Godmanchester, Cambridgeshire, PE29 2AY
• The Cross Keys
  Public House The Cross Keys High Street, Upwood, Cambridgeshire, PE26 2QE
• The Crown Inn
  48 High Street, Earith, Cambridgeshire, PE28 3PP
• The Crown Inn
  Crown Inn 8 Duck Street, Elton, Cambridgeshire, PE8 6RQ
• The Crown Inn Restaurant
  Crown Inn Crown Inn Bridge Road, Broughton, Cambridgeshire, PE28 3AY
• The Cuckoo
  Public House The Cuckoo 20 Oundle Road, Alwalton, Cambridgeshire, PE7 3UP
• The Eaton Oak
  The Eaton Oak The Eaton Oak Great North Road, Eaton Ford, Cambridgeshire, PE19 7DB
• The Eight Bells
  Public House Eight Bells High Street, Abbotsley, Cambridgeshire, PE19 6UJ
• The Elm
  Public House The Abbots Elm Moat Lane, Abbots Ripton, Cambridgeshire, PE28 2PA
• The Exhibition
  Public House The Exhibition London Road, Godmanchester, Cambridgeshire, PE29 2HZ
• The Falcon Tavern
  10 Market Hill, Huntingdon, Cambridgeshire, PE29 3NR
• The Farmers
  The Farmers 200 Broadway, Yaxley, Cambridgeshire, PE7 3NT
• The George Hotel
  The George George Street, Huntingdon, Cambridgeshire, PE29 3AB
• The George Inn
  Public House The George 1 Ramsey Road, Ramsey Forty Foot, Cambridgeshire, PE26 2XN
• The George Inn
  Public House The George 7 High Street, Spaldwick, Cambridgeshire, PE28 0TD
• The Green Man
  Public House Green Man 1 East Street, Colne, Cambridgeshire, PE28 3LZ
• The Greenhill Cafe Bar
  Cambridge Golf And Conference Centre, Cambridge Road, Hemingford Abbots, Huntingdon, PE28 9HQ
• The Hartford Mill
  Hartford Marina Banks End, Wyton, Cambridgeshire, PE28 2AA
• The Horseshoe Inn
  Public House The Horseshoes 90 High Street, Offord Darcy, Cambridgeshire, PE19 5RH
• The Hyde Park Pub
  Public House Hyde Park 46 New Street, St Neots, Cambridgeshire, PE19 1AJ
• The Jolly Sailor
  Public House Jolly Sailor 43 Great Whyte, Ramsey, Cambridgeshire, PE26 1HH
• The Lounge
  The Lounge 14 The Broadway, St Ives, Cambridgeshire, PE27 5BN
• The Marsh Harrier
  2 Needingworth Road, St Ives, Cambridgeshire, PE27 4NB
• The Masonic Lodge
  2 Wellington Street, St Ives, Cambridgeshire, PE27 5AZ
• The Mermaid
  Public House The Mermaid High Street, Ellington, Cambridgeshire, PE28 0AB
• The Mini Bar
  21 Dandby Close, Little Paxton, Cambridgeshire, PE19 6FA
• The New Sun Inn
  Public House The New Sun Inn High Street, Kimbolton, Cambridgeshire, PE28 0HA
• The Old Ferry Boat Inn
  Old Ferry Boat Inn Old Ferry Boat Inn Holywell Front, Holywell, Cambridgeshire, PE27 4TG
• The Oliver Cromwell
  Public House Oliver Cromwell 13 Wellington Street, St Ives, Cambridgeshire, PE27 5AZ
• The Paper Mills
  Public House Paper Mill Inn London Road, Wansford, Cambridgeshire, PE8 6JB
• The Pheasant Keyston
  Pheasant Inn Loop Road, Keyston, Cambridgeshire, PE28 0RE
• The Pub At Grafham T/A The Grafham Trout
  The Grafham Trout Grafham Village Hall Brampton Road, Grafham, Cambridgeshire, PE28 0UR
• The Queens Head
  30 High Street, Needingworth, Cambridgeshire, PE27 4SA
• The River Mill
  Public House River Mill School Lane, Eaton Socon, Cambridgeshire, PE19 8GW
• The Royal British Legion & Ivy
  23 The Broadway, St Ives, Cambridgeshire, PE27 5BX
• The Royal Oak
  Public House Royal Oak 70 Mill Green, Warboys, Cambridgeshire, PE28 2SB
• The Royal Oak Public House
  Public House The Royal Oak 7 The Causeway, Godmanchester, Cambridgeshire, PE29 2HA
• The Snooty Tavern
  Fajara House The Green, Great Staughton, Cambridgeshire, PE19 5DG
• The Snug
  Unit 3 The Mill Free Church Passage, St Ives, Cambridgeshire, PE27 5AY
• The Swan
  Public House Swan Inn Main Street, Old Weston, Cambridgeshire, PE28 5LL
• The Swan And Angel
  8 Market Hill, St Ives, Cambridgeshire, PE27 5AL
• The Talbot Inn
  5 North Street, Stilton, Cambridgeshire, PE7 3RP
• The Three Horseshoes
  Public House Three Horseshoes Inn The Green, Houghton, Cambridgeshire, PE28 2BE
• The Three Horseshoes Yaxley
  Public House Three Horseshoes 179 Main Street, Yaxley, Cambridgeshire, PE7 3LD
• The Vine
  Public House The Vine 33 High Street, Buckden, Cambridgeshire, PE19 5XA
• The Vine Kitchen Ltd
  Public House The Vine 33 High Street, Buckden, Cambridgeshire, PE19 5XA
• The Weeping Ash
  15 New Street, St Neots, Cambridgeshire, PE19 1AE
• The Wheatsheaf
  Public House The Wheatsheaf West Perry, Perry, Cambridgeshire, PE28 0BX
• The White Hart
  2 Vinegar Hill, Alconbury Weston, Cambridgeshire, PE28 4JA
• The White Hart
  Public House The White Hart 56 The Highway, Great Staughton, Cambridgeshire, PE19 5DA
• The White Hart
  Public House White Hart Sheep Market, St Ives, Cambridgeshire, PE27 5AH
• The White Hart Also T/A Dont Panic Pizzeria & Grill, Mac Attack And Burger Club
  Public House White Hart 35 High Street, Warboys, Cambridgeshire, PE28 2TA
• The White Horse
  Public House The White Horse High Street, Tilbrook, Cambridgeshire, PE28 0JP
• The White Lion
  Public House White Lion Upwood Road, Bury, Cambridgeshire, PE26 2PA
• The Windmill
  The Windmill St Ives Road, Somersham, Cambridgeshire, PE28 3ET
• Three Horseshoes
  Public House Three Horse Shoes Mill Road, Wistow, Cambridgeshire, PE28 2QQ
• Three Jolly Butchers
  3 Huntingdon Road, Wyton, Cambridgeshire, PE28 2AD
• Waggon And Horses
  184 Great North Road, Eaton Socon, Cambridgeshire, PE19 8EF
• Wbit Property Ltd T/A The Three Horseshoes
  Public House Three Horseshoes 50 Little Whyte, Ramsey, Cambridgeshire, PE26 1DS
• White Horse Pub
  Public House The White Horse 103 Great North Road, Eaton Socon, Cambridgeshire, PE19 8EL
• White Swan
  White Swan 30 High Street, Bluntisham, Cambridgeshire, PE28 3LD
• Ye Olde Sun
  Public House Ye Old Sun 11 Huntingdon Street, St Neots, Cambridgeshire, PE19 1BL