Open Pubs - Aberdeenshire

1. Home
2. Open Pubs

Description

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

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

Download

Download

Filename: open_pubs_aberdeenshire.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 Aberdeenshire:

• 443 Club
  Masonic Temple, Mount Street, Banchory, AB31 5UB
• 65 Club
  65 Club Masonic Hall, 16 Mary Street, Stonehaven, AB39 2AT
• Aberchirder Bowling Club
  Main Street, Aberchirder, Aberdeenshire, AB54 7TD
• Aberdeen & Stonehaven Yacht Club
  Shorehead, Stonehaven, Aberdeenshire, AB39 2JY
• Aberdeen Arms Hotel
  31 The Square, Tarland, Aberdeenshire, AB34 4TX
• Aboyne Golf Club
  Golf Road, Aboyne, Aberdeenshire, AB34 5HP
• Alford Golf Club
  Montgarrie Road, Alford, Aberdeenshire, AB33 8AE
• Auchenblae Public Hall
  Monboddo Street, Auchenblae, Aberdeenshire, AB30 1XQ
• Ban Car Hotel
  Lonmay, Fraserburgh, Aberdeenshire, AB43 8RL
• Banff Town & County Club
  11 Boyndie Street, Banff, Aberdeenshire, AB45 1DY
• Beekie's Neuk
  28 Oldmeldrum Road, Newmachar, Aberdeenshire, AB21 0PJ
• Bellslea Bar
  24 Seaforth Street, Fraserburgh, Aberdeenshire, AB43 9BB
• Bettridge Centre
  Greystone Place, Newtonhill, Aberdeenshire, AB39 3UL
• Brewdog Inverurie
  22 Market Place, Inverurie, Aberdeenshire, AB51 3XN
• Bridge Bar
  12 Bridge Street, Ellon, Aberdeenshire, AB41 9AA
• Brucklay Arms
  72 Main Street, New Deer, Aberdeenshire, AB53 6SY
• Caley Bar And Cube Disco
  4 Chapel Street, Peterhead, Aberdeenshire, AB42 1TL
• Carlton Club
  Carlton Bingo Hall, Mid Street, Fraserburgh, AB43 9AJ
• Cheers Cafe Bar & Tavern
  10a, Broad Street, Fraserburgh, AB43 9AH
• Cock & Bull
  Blairton, Balmedie, Aberdeenshire, AB23 8XY
• Coilacreich Inn
  Coilacreich Inn, Bridge Of Gairn, Ballater, AB35 5UH
• Crown Hotel
  Crown Hotel, 128 High Street, Laurencekirk, AB30 1BL
• Crown Inn
  1 Crown Street, Turriff, Aberdeenshire, AB53 4DN
• David Bennett Catering
  Turriff Golf Club, Rosehall, Turriff, AB53 4HD
• Dee Jays Nightclub
  Denmark Street, Fraserburgh, Aberdeenshire, AB43 9EY
• Deeside Gliding Club
  Aboyne Airfield, Dinnet, Aboyne, AB34 5LB
• Deveron Community Social Club
  3 Duncan Street, Banff, Aberdeenshire, AB45 1EQ
• Deveronvale Football Club Ltd
  Princess Royal Park, 56 Airlie Gardens, Banff, AB45 1AZ
• Drumoak, Durris And Crathes Bowling Club
  Drumoak Durris Crathes Bowling Club, Sunnyside Avenue, Drumoak, AB31 5EF
• Duff House Royal Golf Club Franchise
  Duff House Royal Golf Club, Barnyards, Banff, AB45 3SX
• Ellon Bowling Club
  Bowling Green, 6-10 Union Street, Ellon, AB41 9BA
• Ellon United Football Club
  Meadows Way, Ellon, Aberdeenshire, AB41 9QJ
• Fishie Pub
  1 The Square, Fetterangus, Aberdeenshire, AB42 4EN
• Fraserburgh Golf Club
  Philorth Links, Fraserburgh, Aberdeenshire, AB43 8TL
• Fyvie Community Kitchen
  Cuminestown Road, Fyvie, Aberdeenshire, AB53 8RD
• Gamrie Public Hall
  Craigen Terrace, Gardenstown, Aberdeenshire, AB45 3ZH
• Garlogie Inn
  Garlogie, Westhill, Aberdeenshire, AB32 6RX
• Grange Inn
  West Road, Peterhead, Aberdeenshire, AB42 2AQ
• Harbour Lights (Phd) Ltd
  122 Longate, Peterhead, Aberdeenshire, AB42 1JU
• Inverallochy Golf Club
  Allochy Road, Inverallochy, Aberdeenshire, AB43 8TA
• Inverurie Golf Club
  Golf Course And Clubhouse, Blackhall Road, Inverurie, AB51 5JB
• Keithhall Public Hall
  Leggat, Keith Hall, Inverurie, AB51 0LX
• Kemnay Bowling & Social Club
  49 Victoria Terrace, Kemnay, Aberdeenshire, AB51 5RL
• Kenyan Bar
  2 Gallowhill Road, Fraserburgh, Aberdeenshire, AB43 9JS
• Kildrummy Inn
  Kildrummy Inn, Kildrummy, Alford, AB33 8QS
• Kincardine O'neil Bowling Club
  Pavilion, North Deeside Road, Kincardine O'neil, AB34 5AA
• Kintore Public Hall
  School Road, Kintore, Aberdeenshire, AB51 0UX
• Lumphanan Golf Club
  Main Road, Lumphanan, Aberdeenshire, AB31 4PW
• Lumsden Community Association
  The Square, Lumsden, Aberdeenshire, AB54 4GQ
• Market Bar
  Market Buildings, Allardice Street, Stonehaven, AB39 2BY
• Masonic Hall
  The Square, Rosehearty, Aberdeenshire, AB43 7JB
• Masonic Lodge St Anthony
  22 High Street, Inverurie, Aberdeenshire, AB51 3XQ
• Mcdonald Golf Club
  Hospital Road, Ellon, Aberdeenshire, AB41 9AW
• Methlick Bowling Club
  King George V Park, Churchyard Road, Methlick, AB41 7DT
• Mintlaw Boys Club
  The Firs, Howe Of Pitfour, Mintlaw Peterhead, AB42 4EX
• New Deer Bowling Club
  Bowling Green, Turfhill Road, New Deer, AB53 6SB
• Newburgh On Ythan Golf Club
  Beach Road, Newburgh, Aberdeenshire, AB41 6BY
• Newmachar Bowling Club
  School Road, Newmachar, Aberdeenshire, AB21 0WB
• Newmachar Golf Club
  Swailend, Newmachar, Aberdeenshire, AB21 7UU
• Newmachar Scouts & Guides
  Hall, Hillbrae Way, Newmachar, AB21 0UR
• Newton Arms
  Newton Arms, 10 Old Mill Road, Newtonhill, AB39 3TZ
• Oldmeldrum Golf Club
  Kirk Brae, Oldmeldrum, Aberdeenshire, AB51 0DJ
• Peterhead O.a.p. Social Club
  21 Windmill Street, Peterhead, Aberdeenshire, AB42 1LH
• Pitmedden Bowling Club
  Bowling Green, Bothwell Terrace, Pitmedden, AB41 7NX
• Portlethen Bowling Club
  Berrymuir Road, Portlethen, Aberdeenshire, AB12 4UN
• R.a.f.a. Penguin Club
  Jubilee Hall, 20 Love Lane, Fraserburgh, AB43 9AT
• Rocksley Inn
  Stirling Village, Boddam, Aberdeenshire, AB42 3AP
• Royal British Legion
  42 School Street, Fraserburgh, Aberdeenshire, AB43 9HT
• Royal British Legion Scotland
  26 Market Square, Stonehaven, Aberdeenshire, AB39 2BA
• Royal Oak Bar
  Royal Oak Bar, Duke Street, Huntly, AB54 8DL
• Royal Tarlair Golf Club
  Buchan Street, Macduff, Aberdeenshire, AB44 1TA
• Seafield Nightclub
  Seafield Hotel, 3 Sandyhill Road, Banff, AB45 1GB
• Stonehaven Indoor Bowling Club Bar
  Cowie, Stonehaven, Aberdeenshire, AB39 2RD
• Strathdeveron Bar
  Strathdeveron Hotel, 21 Deveron Street, Huntly, AB54 8BY
• Super Cuisine
  2 Barclay Street, Stonehaven, Aberdeenshire, AB39 2BJ
• Tarland Golf Club
  Aberdeen Road, Tarland, Aberdeenshire, AB34 4TB
• Teenie & Stams Bar Ltd
  12 Main Street, Turriff, Aberdeenshire, AB53 4AD
• The 19th Tea
  Duff House Royal Golf Club, Barnyards, Banff, AB45 3SX
• The Black Bull Inn
  52 North Street, Inverurie, Aberdeenshire, AB51 4RS
• The Boat Inn
  Charlestown Road, Aboyne, Aberdeenshire, AB34 5EL
• The Butchers Arms
  14 West High Street, Inverurie, Aberdeenshire, AB51 3SA
• The Clansman
  Lodge Solomon 197 Social Club, 80 Commerce Street, Fraserburgh, AB43 9LP
• The Commercial Inn
  60 North Street, Inverurie, Aberdeenshire, AB51 4RS
• The Coyles Restaurant
  Ballater Golf Club, Victoria Road, Ballater, AB35 5LX
• The Croft Inn
  The Croft Inn, New Aberdour, Fraserburgh, AB43 7LS
• The Crown Bar
  4 Gordon Street, Huntly, Aberdeenshire, AB54 8AJ
• The Drouthy Laird
  Victoria Buildings, Blackhall Road, Inverurie, AB51 3QT
• The Fairway
  Aulton Road, Cruden Bay, Aberdeenshire, AB42 0NJ
• The Leathan
  Leathan Arms, Cookston Road, Portlethen, AB12 4PT
• The Market Arms
  5 High Shore, Banff, Aberdeenshire, AB45 1DB
• The Mayfair Bar & Lounge
  74 King Street, Peterhead, Aberdeenshire, AB42 1QH
• The Old Moray
  29 Shore Street, Macduff, Aberdeenshire, AB44 1TS
• The Paddock
  The Green, Portlethen, Aberdeenshire, AB12 4UF
• The Plough Inn
  13 Skene Street, Macduff, Aberdeenshire, AB44 1RL
• The Royal British Legion
  Main Street, Fyvie, Aberdeenshire, AB53 8QB
• The Smiddy Bar
  Daviot, Inverurie, Aberdeenshire, AB51 0HZ
• The Stag Hotel
  Stag Hotel, 40 High Street, Banchory, AB31 5SR
• Tolbooth Lounge Bar
  23 Station Road, Ellon, Aberdeenshire, AB41 9AE
• Top Break Snooker Club
  73 King Street, Peterhead, Aberdeenshire, AB42 1UQ
• Trinity Church
  Westhill Drive, Westhill, Aberdeenshire, AB32 6FY
• Troupers
  10 Barclay Street, Stonehaven, Aberdeenshire, AB39 2BJ
• Unionist Club
  3 Market Buildings, Allardice Street, Stonehaven, AB39 2BY
• Vale Of Alford Bowling Club
  Greystone Road, Alford, Aberdeenshire, AB33 8TY
• Woodend Arts Association
  Woodend Barn, Banchory, Aberdeenshire, AB31 5QA
• Wyness Hall
  Jackson Street, Inverurie, Aberdeenshire, AB51 3QB