Open Pubs - Aberdeen City

1. Home
2. Open Pubs

Description

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

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

Download

Download

Filename: open_pubs_aberdeen-city.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 Aberdeen City:

• 1ds
  1 Diamond Street, Aberdeen, AB10 1QU
• 22 Club
  55 Rose Street, Aberdeen, AB10 1UB
• 524 Bar & Lounge
  524 George Street, Aberdeen, AB25 3XJ
• 612 Club
  615a Great Northern Road, Aberdeen, AB24 2DB
• Aberdeen Grammar School Former Pupils Club
  86 Queens Road, Aberdeen, AB15 4YQ
• Aberdeen Indoor Bowling Club
  Summerhill Road, Aberdeen, AB15 6EE
• Aberdeen Masonic Temple Club
  85 Crown Street, Aberdeen, AB11 6EX
• Aberdeen Transport Club
  4 Canal Road, Aberdeen, AB25 3TL
• Aberdeenshire Cricket Club
  Morningside Road, Mannofield, Aberdeen, AB10 7FB
• Abergeldie Bar
  504-506 Holburn Street, Aberdeen, AB10 7LY
• Abergeldie Bowling Club
  1 Abergeldie Terrace, Aberdeen, AB10 6EE
• Aitchies Ale House
  10 Trinity Street, Aberdeen, AB11 5LY
• All Bar One
  Unit B, Marischal Square, Broad Street, Aberdeen, AB10 1BL
• Archibald Simpson
  5 Castle Street, Aberdeen, AB11 5BQ
• Auchmill Golf Club
  Bonnyview Road, West Heatheryfold, Aberdeen, AB16 7FQ
• Babylon
  9 Alford Place, Aberdeen, AB10 1YD
• Balgownie Bowling Club
  Scotstown Gardens, Bridge Of Don, Aberdeen, AB23 8HX
• Balmoral Bar
  451 Union Street, Aberdeen, AB11 6DB
• Bankhead Inn
  Bankhead Inn, 161-165 Bankhead Road, Bucksburn, Aberdeen, AB21 9HQ
• Blackdog Bar
  North Donside Road, Bridge Of Don, Aberdeen, AB23 8PA
• Bon Accord Golf Club
  19 Golf Road, Aberdeen, AB24 5QB
• Brewdog
  17 Gallowgate, Aberdeen, AB25 1EB
• Brewdog / Underdog
  The Athenaeum, 5-9 Union Street, Aberdeen, AB11 5BU
• Brewdog Union Square
  Unit Fs15 Upper Mall Union Square, Guild Street, Aberdeen, AB11 5RG
• Bridge Bar
  6 Bridge Street, Aberdeen, AB11 6JJ
• Bridge Street Social Club
  18 Bridge Street, Aberdeen, AB11 6JJ
• Brig Inn / Shish Tandoori
  9 Ellon Road, Bridge Of Don, Aberdeen, AB23 8EB
• Brig O'don
  739 King Street, Aberdeen, AB24 1XZ
• Brig-o-dee Bar
  651 Holburn Street, Aberdeen, AB10 7JN
• Broomhill Activity Centre
  197 Broomhill Road, Aberdeen, AB10 7LN
• Bugsy Browns
  1-7 Windmill Brae, Aberdeen, AB11 6HU
• Cafe Drummond
  1 Belmont Street, Aberdeen, AB10 1JR
• Carlton Bar
  32 Castle Street, Aberdeen, AB11 5BB
• Casc
  7 Stirling Street, Aberdeen, AB11 6ND
• Castle Bar
  19 Castle Street, Aberdeen, AB11 5BQ
• Character's Cafe Bar
  43 Regent Quay, Aberdeen, AB11 5BE
• Cheerz Bar And Teazers Nightclub
  Rabbie's Bar, 2-8 Exchange Street, Aberdeen, AB11 6PH
• Coopers Bar
  43-49 John Street, Aberdeen, AB25 1LN
• Cove Rangers Social Club
  Loirston Road, Cove, Aberdeen, AB12 3NR
• Croft And Cairns
  5 Stockethill Crescent Aberdeen, AB16 5TT
• Crown Bar
  571 Great Northern Road, Aberdeen, AB24 2DB
• Culter Mills Sports & Social Club
  Cairn Road, Peterculter, Aberdeen, AB14 0QD
• Cults Bowling Club
  293 North Deeside Road, Cults, Aberdeen, AB15 9PA
• Cutter's Wharf
  65 Regent Quay, Aberdeen, AB11 5AR
• Dee Swimming Club
  50 Gerrard Street, Aberdeen, AB25 1HA
• Deeside Golf Club
  Golf Road, Bieldside, Aberdeen, AB15 9DL
• Denmore Sports And Social Club
  Lochside Road, Bridge Of Don, Aberdeen, AB23 8NL
• Dusk
  45 Langstane Place, Aberdeen, AB11 6EN
• Dyce Bowling Club
  Skene Place, Dyce, Aberdeen, AB21 7AY
• East End Social Club
  Golf Road, Aberdeen, AB24 1RG
• Espionage
  120 Union Street, Aberdeen, AB10 1JJ
• Events At P&j Live
  East Burn Road, Stoneywood, Aberdeen, AB21 9FX
• Fierce Bar Aberdeen (Fierce Beer)
  4-6 Exchequer Row, Aberdeen, AB11 5BW
• Fittie Bar
  Fittie Bar, 18 Wellington Street, Queen's Links, Aberdeen, AB11 5BT
• Fountain Bar / The Embassy Rooms
  368 Great Northern Road, Aberdeen, AB24 2AX
• Four Mile House
  Old Skene Road, Kingswells, Aberdeen, AB15 8QA
• Four Mile Inn
  Four Mile Inn, Inverurie Road, Bucksburn, Aberdeen, AB21 9BB
• G Casino
  5 Exchequer Row, Aberdeen, AB11 5BW
• Ghillies Lair Harvester
  Great Southern Road, Bridge Of Dee, Aberdeen, AB12 5XA
• Gilcomston Bar
  5 Gilcomston Steps, Aberdeen, AB25 1UW
• Glentanar Bar
  Glentanar Bar & Lounge, 39 Holburn Street, Aberdeen, AB10 6BS
• Globe Inn
  The Globe, 13 North Silver Street, Aberdeen, AB10 1RJ
• Golden Tee
  244 North Balnagask Road, Torry, Aberdeen, AB11 8LH
• Gordonians F.p. Club
  12 Seafield Road, Aberdeen, AB15 7YT
• Grampian Bar
  Grampian Bar, 25-27 Victoria Road, Torry, Aberdeen, AB11 9LS
• Granite City [landside]
  Aberdeen Airport, Brent Road, Dyce, Aberdeen, AB21 7DU
• Grape And Grain
  31 Thistle Street, Aberdeen, AB10 1UY
• Gray's Inn
  Gray's Inn, Greenfern Road, Aberdeen, AB16 5PY
• Hazlehead Golf Club [bar Only]
  Hazlehead, Aberdeen, AB15 8BD
• Holburn Bar
  225 Holburn Street, Aberdeen, AB10 6BL
• Jam Jar
  Unit 10 The Galleria, Bon Accord Street, Aberdeen, AB11 6FB
• Jimmy Wilsons Bar
  19 Market Street, Aberdeen, AB11 5PY
• Justice Mill / Lloyds No 1 Bar
  425 Union Street, Aberdeen, AB11 6DA
• Karma
  44-56 Justice Mill Lane, Aberdeen, AB11 6EP
• Kings Bar
  97 King Street, Aberdeen, AB24 5AB
• Kirkgate Bar
  18 Upperkirkgate, Aberdeen, AB10 1BA
• Kittybrewster & Woodside Bowling Club
  Lilybank Place, Aberdeen, AB24 4PX
• Kittybrewster Bar/Ashgrove Lounge
  69 Powis Terrace, Aberdeen, AB25 3PY
• Krakatoa
  2 Trinity Quay, Aberdeen, AB11 5AA
• Lane 7
  1 Shiprow, Aberdeen, AB11 5BY
• Legends Sports Bar Limited
  23 Crown Terrace, Aberdeen, AB11 6HD
• Ma Camerons
  6 Little Belmont Street, Aberdeen, AB10 1JG
• Malone's
  90 Shiprow, Aberdeen, AB11 5BZ
• Malones Irish Bar
  62 Shiprow, Aberdeen, AB11 5BY
• Market Arms
  13 Hadden Street, Aberdeen, AB11 6ND
• Mcgintys
  504 Union Street, Aberdeen, AB10 1TT
• Mcnastys
  37 Summer Street, Aberdeen, AB10 1SB
• Molly Malones
  224 Union Street, Aberdeen City, AB10 1TL
• Motif
  50 Langstane Place, Aberdeen, Aberdeen City, AB11 6EN
• Mounthooly Sports Bar
  70 Hutcheon Street, Aberdeen, AB25 3TB
• Murcar Links Golf Club
  Murcar, Bridge Of Don, Aberdeen, AB23 8BD
• Murdo's Bar
  Cairncry Road, Aberdeen, AB16 5UR
• New Albyn
  11 Albyn Place, Aberdeen, AB10 1YE
• New Greentrees
  183 Victoria Street, Dyce, Aberdeen, AB21 7AA
• Newhills Bowling Club
  Waterton Road, Bucksburn, Aberdeen, AB21 9HS
• Nigg Bay Golf Club (Bar)
  Nigg Bay Golf Club, St Fittick's Road, Aberdeen, AB11 9QT
• Ninety Nine Bar & Kitchen
  1 Back Wynd, Aberdeen, AB10 1JN
• No 10 Winebar
  10 Queens Terrace, Aberdeen, AB10 1XL
• Noose And Monkey
  The Noose And Monkey, 31-36 Rosemount Viaduct, Aberdeen, AB25 1NQ
• Northern Bar
  325 George Street, Aberdeen, AB25 1EE
• Northern Bowling Club
  Orchard Road, Aberdeen, AB24 3DP
• Northern Golf Club
  22 Golf Road, Aberdeen, AB24 5QB
• Northern Lights [airside]
  Aberdeen Airport, Brent Road, Dyce, Aberdeen, AB21 7DU
• O Neill`s
  9 Back Wynd, Aberdeen, AB10 1JN
• O'donoghues
  56 Justice Mill Lane, Aberdeen, AB11 6EP
• Old Bank Bar
  220 North Deeside Road, Peterculter, Aberdeen, AB14 0UQ
• Old Blackfriars
  52 Castle Street, Aberdeen, AB11 5BB
• Old Frigate Bar
  57-59 Netherkirkgate, Aberdeen, AB10 1AU
• Old Kings Highway
  61 The Green, Aberdeen, AB11 6NY
• Old School House
  Little Belmont Street, Aberdeen, AB10 1JG
• Origin
  40-42 Windmill Brae, Aberdeen, AB11 6HU
• Paramount
  23-25 Bon Accord Street, Aberdeen, AB11 6EA
• Paramount
  21-25 Bon Accord Street, Aberdeen, AB11 6EA
• Parkvale Fc Social Club
  16 King Street, Aberdeen, AB24 5AX
• Pearl Lounge
  16 Dee Street, Aberdeen, AB11 6DR
• Pittodrie Bar
  337-339 King Street, Aberdeen, AB24 5AP
• Polmuir Bowling Club
  Polmuir Road, Aberdeen, AB11 7RS
• Portals Bar
  17 Castle Street, Aberdeen, AB11 5BQ
• Portland Club
  6 St Paul Street, Aberdeen, AB25 1GA
• Prince Of Wales
  7 St Nicholas Lane, Aberdeen, AB10 1HF
• Private Dancer Ltd
  30 Bridge Street, Aberdeen, AB11 6HZ
• Private Eyes / Club Tropicana
  74-78 Chapel Street, Aberdeen, AB10 1SN
• Prohibition
  31 Langstane Place, Aberdeen, AB11 6DX
• Queen Vic
  126-128 Rosemount Place, Aberdeen, AB25 2YU
• R U A Social Club
  5-7 West Craibstone Street, Aberdeen, AB11 6DL
• Rainbow Casino
  61 Summer Street, Aberdeen, AB10 1SJ
• Red Lion
  Red Lion, 130 Spital, Old Aberdeen, Aberdeen, AB24 3JU
• Redemption
  33 Belmont Street, Aberdeen, AB10 1JS
• Regent Bridge Bar
  30 Regent Quay, Aberdeen, AB11 5AH
• Resident X
  Unit 1-5 Marischal Square Broad Street, AB10 1BL
• Revolution
  25 Belmont Street, Aberdeen, AB10 1JS
• Richmond Arms
  325 North Deeside Road, Peterculter, Aberdeen, AB14 0UL
• Royal British Legion
  23 Balgownie Road, Bridge Of Don, Aberdeen, AB23 8JN
• Royal Northern And University Club
  9 Albyn Place, Aberdeen, AB10 1YE
• Saltoun Arms
  69 Frederick Street, Aberdeen, AB24 5HY
• Scotia Bar
  Scotia Bar, 7-11 Summerfield Terrace, Aberdeen, AB24 5JB
• Scottish Embassy
  4 Trinity Street, Aberdeen, AB11 5LY
• Scott's Bar
  Summerhill Court, Summerhill, Aberdeen, AB15 6TW
• Seafield Bowling Club
  Cromwell Gardens, Aberdeen, AB15 4UF
• Shotz
  13 The Arches, South College Street, Aberdeen, AB11 6JX
• Siberia Bar
  9 Belmont Street, Aberdeen, AB10 1JR
• Silhouettes
  48 & 52 Bridge Street, Aberdeen, AB11 6JN
• Sing City
  70 Chapel Street, Aberdeen, AB10 1SN
• Slains Castle
  14-18 Belmont Street, Aberdeen, AB10 1JH
• Snuggery
  13-15 Market Street, Aberdeen, AB11 5PY
• Soul
  Langstane Kirk, 333 Union Street, Aberdeen, AB10 6BS
• Soul Casino
  Langstane Kirk, 333 Union Street, Aberdeen, AB10 6BS
• Spirit Level
  24 Exchange Street, Aberdeen, AB11 6PH
• Sportsmans Club
  11 Queens Road, Aberdeen, AB15 4YL
• St Machar Bar
  97a High Street, Aberdeen, AB24 3EN
• Steinhaus
  17 Windmill Brae, Aberdeen, AB11 6HU
• Sugarbird In The Gardens
  Burns Pavillion Union Terrace Aberdeen, AB10 1DF
• Sunnybank Football Club
  Heathryfold Park, Aberdeen, AB16 7DS
• The 1224 Club [masonic Lodge]
  156 North Deeside Road, Peterculter, Aberdeen, AB14 0UD
• The Abercrombie Bar
  224 Union Street, Aberdeen, AB10 1TL
• The Adams
  145 Holburn Street, Aberdeen, AB10 6BN
• The Assembly
  The Forum, 3 Skene Terrace, Aberdeen, AB10 1RN
• The Blue Lamp
  121 Gallowgate, AB25 1BU
• The Bobbin
  500 King Street, Aberdeen, AB24 5ST
• The Cotton Club / Cafe Bardots
  491-493, 491 Union Street, Aberdeen, AB11 6DB
• The Foundry
  41/43 Holburn Street, Aberdeen, AB10 6BR
• The Gas Lamp/Tipsy Pig
  The Old Bank Bar, 42-44 Market Street, Aberdeen, Aberdeen City, AB11 5PL
• The Grill
  213 Union Street, Aberdeen, AB11 6BA
• The Hayloft
  9-11 Portland Street, Aberdeen, AB11 6LN
• The Howff
  365 Union Street, Aberdeen, AB11 6BT
• The Lodge Of Old Aberdeen
  9 Dunbar Street, Old Aberdeen, Aberdeen, AB22 8YG
• The Lord Byron
  Byron Square, Northfield, Aberdeen, AB16 7LL
• The Mask And Magma
  52 Bridge Street, Aberdeen, AB11 6JN
• The Mither Tap
  28-32 John Street, Aberdeen, AB25 1BT
• The Office
  7 Crown Street Aberdeen, AB11 6HA
• The Rowan Tree
  654 King Street, Aberdeen, AB24 1SL
• The Stag
  6 Crown Street, Aberdeen, Aberdeen City, AB11 6HB
• The Staging Post
  The Staging Post, 18 Oldmeldrum Road, Bucksburn, Aberdeen, AB21 9DU
• The Tippling House
  4 Belmont Street, Aberdeen, AB10 1JE
• The Tunnels
  Carnegie's Brae, Aberdeen, AB10 1BF
• The Wig
  55-56 Castle Street, Aberdeen, AB11 5BA
• Three Lums
  Lewis Road, Sheddocksley, Aberdeen, AB16 6TG
• Trinity Hall
  Trinity Hall, Holburn Street, Aberdeen, AB10 6DA
• Triple Kirks/Exodus
  Schoolhill, Aberdeen, AB10 1JS
• Under The Hammer
  11 North Silver Street, Aberdeen, AB10 1RJ
• Underground Klub
  10 Bridge Street, Aberdeen, AB11 6JJ
• Union Kirk
  333 Union Street, Aberdeen, AB11 6BS
• Unit 51
  Carnegies Brae, Aberdeen, AB10 1BF
• Victoria Bar
  1-5 Menzies Road, Torry, Aberdeen, AB11 9DS
• Wagleys Bar
  35 Exchange Street, Aberdeen, AB11 6PH
• White Cockade
  2 Oscar Road, Torry, Aberdeen, AB11 8ER
• Whitehall Bowling Club
  71 Hamilton Place, Aberdeen, AB15 5BW
• Wild Boar
  19 Belmont Street, Aberdeen, AB10 1JR
• Woodend Bar
  225 Stoneywood Road, Bucksburn, Aberdeen, AB21 9JD
• Woodend Bowling Club
  285 King's Gate, Aberdeen, AB15 6AJ
• Woodside Sports Complex
  Woodside Sports Complex, Station Road, Woodside, Aberdeen, AB24 2UL