Open Pubs - City of London

1. Home
2. Open Pubs

Description

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

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

Download

Download

Filename: open_pubs_city-of-london.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 City of London:

• 37 Jewry
  Centurion House, 37 Jewry Street, London, EC3N 2ER
• 47 Ludgate
  47 Ludgate Hill, London, EC4M 7JZ
• All Bar One
  Public House, 16 Byward Street, London, EC3R 5BA
• All Bar One
  Retail Unit, 103 Cannon Street, London, EC4N 5AG
• All Bar One
  Retail Unit, 107 Houndsditch, London, EC3A 7BD
• Astronomer
  125-129 Middlesex Street, London, E1 7JF
• Back To Mine
  10 Exchange Square, London, EC2A 2BR
• Balfour St Bart's
  66 West Smithfield, London, EC1A 9DY
• Balls Brothers - Minster Court
  1 Minster Pavement, London, EC3R 7PP
• Balls Brothers Austin Friars
  10-11 Austin Friars, London, EC2N 2HG
• Barbican Bars
  Barbican Arts And Conference Centre, Silk Street, London, EC2Y 8DS
• Be At One
  28 King William Street, London, EC4R 9AT
• Be At One
  45 Old Broad Street, London, EC2N 1HT
• Bedales Wine Bar
  Retail Unit, 55 Leadenhall Market, London, EC3V 1LT
• Bishops Finger
  The Bishops Finger Public House, 9-10 West Smithfield, London, EC1A 9JR
• Brewdog
  1 Plough Place, London, EC4A 1DE
• Brokers Wine Bar
  First Floor Retail Unit, 6-9 Leadenhall Market, London, EC3V 1LR
• Browns
  Retail Unit, 8-10 Old Jewry, London, EC2R 8DN
• Bunch Of Grapes
  14 Lime Street, London, EC3M 7AN
• Candlemaker
  The Walbrook Building, 25 Walbrook, London, EC4N 8AF
• Cannick Tapps
  109 Cannon Street, London, EC4N 5AD
• Cheshire Cheese
  The Cheshire Cheese Public House, 48 Crutched Friars, London, EC3N 2AP
• City Bar And Kitchen
  9 Stoney Lane, London, E1 7BH
• City Of London Distillery
  Basement Retail Unit, 24 Bride Lane, London, EC4Y 8DT
• Club Gascon
  57 West Smithfield, London, EC1A 9DS
• Cococure
  Retail Unit, 5 Minories, London, EC3N 1BJ
• Core
  Aldermary House, 15 Queen Street, London, EC4N 1TX
• Crosse Keys Ph
  7 Gracechurch Street, London, EC3V 0DR
• Davys, 1 Plantation Place
  Unit 8 Plantation Place, 20 Mincing Lane, London, EC3M 3BD
• Devonshire Terrace
  9 Devonshire Square, London, EC2M 4YF
• Dirty Dicks Public House
  202 Bishopsgate, London, EC2M 4NR
• Dirty Martini
  158 Bishopsgate, London, EC2M 4LX
• Dirty Martini
  Retail Unit Three Keys House, 130 Wood Street, London, EC2V 6DL
• Dirty Martini Monument
  1 Lovat Lane, London, EC3R 8DT
• East India Arms
  East India Arms Public House, 67 Fenchurch Street, London, EC3M 4BR
• Eastcheap Records
  Peek House, 20 Eastcheap, London, EC3M 1EB
• Editors Tap
  Ground Floor Retail Unit, 5-11 Fetter Lane, London, EC4A 1BR
• Eight Club (1 Change Alley)
  Basement Members Club, 24 Cornhill, London, EC3V 9AZ
• El Vino Co Ltd
  30 New Bridge Street, London, EC4V 6BJ
• El Vino Co Ltd
  47 Fleet Street, London, EC4Y 1BJ
• Enoteca Da Luca
  10 Basinghall Street, London, EC2V 5BQ
• Enoteca Da Luca
  20-21 Watling Street, London, EC4M 9BR
• Enoteca Da Luca
  Retail Unit 7, Western Courtyard, Devonshire Square, London, EC2M 4AE
• Feeneys
  Retail Unit, 48 Mark Lane, London, EC3R 7QH
• Forge
  24 Cornhill, London, EC3V 3ND
• Fox Fine Wines
  118 London Wall, London, EC2Y 5JA
• Goodman City Ltd
  Retail Unit, 11 Old Jewry, London, EC2R 8DU
• Hamilton Hall
  Retail Unit 32 Upper Concourse, Liverpool Street Station, Liverpool Street, London, EC2M 7PY
• Hand & Shears Public House
  Hand And Shears Public House, 1 Middle Street, London, EC1A 7JA
• Harrild And Sons
  26 Farringdon Street, London, EC4A 4AB
• Harry's Bar
  5 Abchurch Yard, London, EC4N 7BA
• Humble Grape
  Retail Unit, 8 Devonshire Row, London, EC2M 4RH
• Jamaica Wine House
  St Michael's Alley, London, EC3V 9DS
• Jin Bo Law, 14th Flr, Dorsett City H
  9 Aldgate High Street, London, EC3N 1AH
• Karaoke Box
  Jarvis House, 12 Smithfield Street, London, EC1A 9LA
• Kings Stores Public House
  14 Widegate Street, London, E1 7HP
• K-town & Chik Box; Locked And Loaded; Duke Of Somerset
  Duke Of Somerset Public House, 15 Little Somerset Street, London, E1 8AH
• Lady Abercorn, Andaz Hotel
  Andaz Hotel, 40 Liverpool Street, London, EC2M 7QN
• Liberty Bounds
  Retail Unit, 15 Trinity Square, London, EC3N 4AA
• Little Fable
  Retail Unit 2, 3 Fleet Place, London, EC4M 7RA
• London Cocktail Club
  2 Eastcheap, London, EC3M 1AE
• London Cocktail Club
  York House, 74-82 Queen Victoria Street, London, EC4N 4SJ
• Magpie & Stump
  18 Old Bailey, London, EC4M 7EP
• Merchant House
  13 Well Court, London, EC4M 9DN
• Mr Tipsy's Down The Hatch
  Retail Unit, 1 America Square, London, EC3N 2LS
• Munich Cricket Club
  9a-9b Crutched Friars, London, EC3N 2AU
• Old Red Cow
  The Old Red Cow Public House, 71-72 Long Lane, London, EC1A 9EJ
• Oyster Shed
  1 Angel Lane, London, EC4R 3AB
• Patch Bar
  58-62 Carter Lane, London, EC4V 5EA
• Patch East
  Basement Retail Unit, 80 Leadenhall Street, London, EC3A 3DH
• Pavilion End
  The Pavilion End Public House, 23 Watling Street, London, EC4M 9BR
• Pegasus Bar
  Inner Temple Treasury, The Terrace, London, EC4Y 7HL
• Pelt Trader, Arch 3
  23 Dowgate Hill, London, EC4R 2SU
• Piano Smithfield
  14 Long Lane, London, EC1A 9PN
• Pitch
  62 Bishopsgate, London, EC2N 4AW
• Pitch Golf Studio
  Hasilwood House, 60-64 Bishopsgate, London, EC2N 4AW
• Pitcher & Piano
  28 Cornhill, London, EC3V 3ND
• Planet Of The Grapes
  9-10 Bulls Head Passage, London, EC3V 1LU
• Popworld
  17 Watling Street, London, EC4M 9BB
• Punch Tavern
  The Punch Tavern Public House, 99 Fleet Street, London, EC4Y 1DE
• Puttshack, Ground Floor Reception
  1 The Concourse, 1 Poultry, London, EC2R 8EJ
• Revolution
  Retail Unit, 140-144 Leadenhall Street, London, EC3V 4QT
• Rudds
  Retail Unit, 148 Queen Victoria Street, London, EC4V 4BY
• Salotto 31
  Retail Unit, 31 Lovat Lane, London, EC3R 8EB
• Samuel Peyps
  Samuel Pepys Public House, Stew Lane, London, EC4V 3PT
• Seething Lane Tap
  14 Seething Lane, London, EC3N 4AX
• Shaws Booksellers
  Shaws Booksellers Public House, 31-34 St Andrew's Hill, London, EC4V 5DE
• Simmons, Unit 5
  35 Eastcheap, London, EC3M 1DT
• Simon's Bar Bank
  Offices, 33-35 Cornhill, London, EC3V 3ND
• Sir John Hawkshaw
  Retail Unit 4-5, Cannon Street Station, Cannon Street, London, EC4N 6AP
• Slug & Lettuce/Chik Box/Locked N Loaded/K Town
  St Clare House, 30-33 Minories, London, EC3N 1DD
• Slug And Lettuce
  2 Love Lane, London, EC2V 7JQ
• Slug And Lettuce
  29 St Mary Axe, London, EC3A 8AA
• Spirit Of Man
  London Metal Exchange, 56 Leadenhall Street, London, EC3A 2BJ
• St Bride Foundation
  Bridewell Theatre, 14 Bride Lane, London, EC4Y 8EQ
• Steam Wine Bar
  1 St George's Lane, London, EC3R 8DJ
• Swan Tavern
  The Swan Public House, 12 Ship Tavern Passage, London, EC3V 1LY
• Swingers
  8 Brown's Buildings, London, EC3A 8AL
• Ten Trinity Square Private Club
  10 Trinity Square, London, EC3N 4AJ
• The Albion
  The Albion Public House, 2-3 New Bridge Street, London, EC4V 6AA
• The Alchemist
  6 Bevis Marks, London, EC3A 7BA
• The Alice
  Five Acre Square, 133-137 Houndsditch, London, EC3A 7BX
• The Anthologist
  58 Gresham Street, London, EC2V 7BB
• The Arbitrager
  27a Throgmorton Street, London, EC2N 2AN
• The Banker
  The Banker Public House, Cousin Lane, London, EC4R 3TE
• The Bell
  The Bell Public House, 29 Bush Lane, London, EC4R 0AN
• The Blackfriar
  Blackfriars Tavern, 174 Queen Victoria Street, London, EC4V 4EG
• The Bolthole
  2a Suffolk Lane, London, EC4R 0AT
• The Bootlegger's Club Ltd
  Basement Retail Unit, 25-26 Lime Street, London, EC3M 7HR
• The Botanist
  35 Broadgate Circle, London, EC2M 2QS
• The Breakfast Club
  12-16 Artillery Lane, London, E1 7LS
• The Britannia
  The Britannia Public House, 20 Monument Street, London, EC3R 8AJ
• The Bull
  The Bull Public House, 4-5 Devonshire Row, London, EC2M 4RH
• The Butcher's Hook And Cleaver
  The Butcher's Hook And Cleaver Public House, 61 West Smithfield, London, EC1A 9DY
• The Cock & Woolpack
  The Cock And Woolpack Public House, 6 Finch Lane, London, EC3V 3NA
• The Cockpit
  The Cockpit Public House, 7 St Andrew's Hill, London, EC4V 5BY
• The Corn Exchange
  2 Minster Court, London, EC3R 7BB
• The Counting House
  The Counting House Public House, 50 Cornhill, London, EC3V 3PD
• The Craft Beer Company
  29-31 Mitre Street, London, EC3A 5BU
• The Crown And Sugar Loaf
  Crown And Sugarloaf Public House, 26 Bride Lane, London, EC4Y 8DT
• The Crutched Friar
  The Crutched Friar Public House, 39-41 Crutched Friars, London, EC3N 2AE
• The Drift
  110 Bishopsgate, London, EC2N 4AY
• The English Wine And Spirit Co Ltd
  Retail Unit, 8 Devonshire Row, London, EC2M 4RH
• The Fable
  60 Holborn Viaduct, London, EC1A 2FD
• The Folly
  41 Gracechurch Street, London, EC3V 0BT
• The Globe
  The Globe Public House, 83 Moorgate, London, EC2M 6SA
• The Gobpsy, Basement Bar
  Basement Retail Unit, 141 Fenchurch Street, London, EC3M 6BL
• The Golden Fleece
  Golden Fleece Public House, 8-9 Queen Street, London, EC4N 1SP
• The Golden Goose
  Ground Floor Retail Unit, 13-15 Leadenhall Market, London, EC3V 1LR
• The Hoop & Grapes
  47 Aldgate High Street, London, EC3N 1AL
• The Hung Drawn & Quartered
  The Hung Drawn And Quartered Public House, 27 Great Tower Street, London, EC3R 5AQ
• The Hydrant, Equitable House
  1 Monument Street, London, EC3R 8BG
• The Jugged Hare
  49 Chiswell Street, London, EC1Y 4SA
• The Kings Arms
  The Kings Arms Public House, 27 Wormwood Street, London, EC2M 1RP
• The Lamb And Trotter
  6 Little Britain, London, EC1A 7BX
• The Lamb Tavern
  Lamb Tavern Public House, 10-12 Leadenhall Market, London, EC3V 1LR
• The Leaf And Cane At Hyatt Regency London Blackfriars
  Blackfriars House, 19 New Bridge Street, London, EC4V 6DB
• The Lion
  31 Houndsditch, London, EC3A 7DB
• The Long Lane (Bar)
  Retail Unit, 50-52 Long Lane, London, EC1A 9EJ
• The Lord Aberconway
  Lord Aberconway Public House, 73 Old Broad Street, London, EC2M 1QT
• The Lord Raglan
  61 St Martin's-le-grand, London, EC1A 4ER
• The Magpie
  The Magpie Public House, 12 New Street, London, EC2M 4TP
• The Minories Public House
  Minories Public House, 64-73 Minories, London, EC3N 1JL
• The Moniker
  25 Fenchurch Avenue, London, EC3M 5AD
• The Monument Public House
  18 Fish Street Hill, London, EC3R 6DB
• The New Moon Public House
  New Moon Public House, 88 Gracechurch Street, London, EC3V 0DN
• The Old Bell Tavern
  The Old Bell Public House, 95 Fleet Street, London, EC4Y 1DH
• The Old Doctor Butler's Head
  The Old Doctor Butlers Head Public House, 2 Mason's Avenue, London, EC2V 5BT
• The Old Tea Warehouse
  The Old Tea Warehouse Public House, 4-8 Creechurch Lane, London, EC3A 5AY
• The Olde Wine Shades
  The Olde Wine Shades Public House, 6 Martin Lane, London, EC4R 0DJ
• The Paternoster
  2 Queen's Head Passage, London, EC4M 7DZ
• The Phoenix
  Retail Unit, 26 Throgmorton Street, London, EC2N 2AN
• The Pregnant Man
  40 Chancery Lane, London, WC2A 1JA
• The Rack & Tenter
  Rack And Tenter Public House Tenter House, 45 Moorfields, London, EC2Y 9AE
• The Railway Tavern
  The Railway Tavern Public House, 15 Liverpool Street, London, EC2M 7NX
• The Red Lion
  The Red Lion Public House, 1 Eldon Street, London, EC2M 7LS
• The Rising Sun
  Rising Sun Public House, 61 Carter Lane, London, EC4V 5DY
• The Rising Sun Public House
  38 Cloth Fair, London, EC1A 7JQ
• The Saint
  1 Bow Churchyard, London, EC4M 9DQ
• The Sea Horse
  Sea Horse Public House, 64 Queen Victoria Street, London, EC4N 4SJ
• The Shakespeare
  The Shakespeare Public House, 2 Goswell Road, London, EC1M 7AA
• The Ship
  The Ship Public House, 3 Hart Street, London, EC3R 7NB
• The Ship Public House
  11 Talbot Court, London, EC3V 0BP
• The Steel Yard
  13-16 Allhallows Lane, London, EC4R 3UL
• The Sugarloaf
  Retail Unit, 65 Cannon Street, London, EC4N 5AA
• The Swan Ph
  Retail Unit, 77-80 Gracechurch Street, London, EC3V 0AS
• The Telegraph
  The Telegraph Public House, 11 Telegraph Street, London, EC2R 7AR
• The Tipperary
  The Tipperary Public House, 66 Fleet Street, London, EC4Y 1HT
• The Trinity Bell
  Cree House, 20 Creechurch Lane, London, EC3A 5AY
• The Walrus & The Carpenter Ph
  The Walrus & The Carpenter Public House, 45 Monument Street, London, EC3R 8BU
• The Windsor
  The Windsor Public House, 2 New London Street, London, EC3R 7NA
• The Woodins Shades
  Woodins Shades Public House, 212 Bishopsgate, London, EC2M 4PT
• Three Cranes
  28 Garlick Hill, London, EC4V 2BA
• Three Tuns
  The Three Tuns Public House, 36 Jewry Street, London, EC3N 2ET
• Tokenhouse
  Retail Unit, 4 Moorgate, London, EC2R 6DA
• Traitors Gate
  14 Trinity Square, London, EC3N 4AA
• Vagabond Wines
  51 Gracechurch Street, London, EC3V 0EH
• Vagabond Wines
  52 - 54 Gracechurch Street, London, EC3V 0EH
• Viaduct Tavern Public House
  126 Newgate Street, London, EC1A 7AA
• White Haus
  17 Farringdon Street, London, EC4A 4AB
• Williams Ale And Cider House
  22-24 Artillery Lane, London, E1 7LS
• Williamsons Tavern
  Williamson's Tavern Public House, 1 Groveland Court, London, EC4M 9EH
• Willys Wine Bar
  Basement Retail Unit, 107 Fenchurch Street, London, EC3M 5JF
• Wood Street Bar And Restaurant
  53 Fore Street, London, EC2Y 5EJ
• Ye Olde Cheshire Cheese
  Ye Olde Cheshire Cheese Public House, 145 Fleet Street, London, EC4A 2BU
• Ye Olde Cock Tavern
  Ye Olde Cock Tavern Public House, 22 Fleet Street, London, EC4Y 1AA
• Ye Olde London
  Ye Olde London Public House, 42 Ludgate Hill, London, EC4M 7DE
• Ye Olde Watling
  Ye Olde Watling Public House, 29 Watling Street, London, EC4M 9BR