Open Pubs - Welwyn Hatfield

1. Home
2. Open Pubs

Description

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

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

Download

Download

Filename: open_pubs_welwyn-hatfield.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 Welwyn Hatfield:

• Attimore Hall
  Ridgeway, Welwyn Garden City, Hertfordshire, AL7 2AD
• Builders Arms
  47 Heath Road, Potters Bar, Hertfordshire, EN6 1LR
• Coach & Horses
  61 Newgate Street Village, Hertford, Hertfordshire, SG13 8RA
• Eight Bells
  2 Park Street, Hatfield, Hertfordshire, AL9 5AX
• Franks Pool Club
  Culpitt House, 74-78 Town Centre, Hatfield, Hertfordshire, AL10 0JW
• Hatfield Social Club
  76 Great North Road, Hatfield, Hertfordshire, AL9 5ER
• Hatfield Tap
  91 Bishops Rise, Hatfield, Hertfordshire, AL10 9BZ
• Horse And Groom
  21 Park Street, Hatfield, Hertfordshire, AL9 5AT
• Judges
  Judge's Hill, Potters Bar, Hertfordshire, EN6 4NL
• Miller & Carter
  Great North Road, Brookmans Park, Hertfordshire, AL9 6NA
• Pear Tree Inn
  Hollybush Lane, Welwyn Garden City, Hertfordshire, AL7 4JJ
• Rose And Crown
  22 High Road, Hatfield, Hertfordshire, AL9 6HW
• Shamrock Club
  Ridgeway, Welwyn Garden City, Hertfordshire, AL7 2AD
• Sibthorpe Arms
  19 Station Road, Hatfield, Hertfordshire, AL9 7PL
• Stanborough Beefeater & Premier Inn
  The Stanborough, Stanborough Road, Welwyn Garden City, Hertfordshire, AL8 6DQ
• The Airfield
  Comet Way, Hatfield, Hertfordshire, AL10 0DA
• The Bakehouse
  Bessemer Road, Welwyn Garden City, Hertfordshire, AL7 1HH
• The Brocket Arms
  Hill Farm Lane, Ayot St Lawrence, Hertfordshire, AL6 9BT
• The Candlestick
  West End Lane, Hatfield, Hertfordshire, AL9 6BA
• The Cavendish Arms
  19 Bishops Rise, Hatfield, Hertfordshire, AL10 9HF
• The Chequers
  16 London Road, Woolmer Green, Hertfordshire, SG3 6JP
• The Chieftain
  Cole Green Lane, Welwyn Garden City, Hertfordshire, AL7 3JF
• The Cock O The North
  Great North Road, Brookmans Park, Hertfordshire, AL9 6NA
• The Cowper Arms
  31 Station Road, Welwyn, Hertfordshire, AL6 0EA
• The Crooked Chimney
  Cromer Hyde Lane, Welwyn Garden City, Hertfordshire, AL8 7XE
• The Crown
  45 Newgate Street Village, Hertford, Hertfordshire, SG13 8RA
• The Doctors Tonic
  Church Road, Welwyn Garden City, Hertfordshire, AL8 6PR
• The Great Northern
  54 Great North Road, Hatfield, Hertfordshire, AL9 5AE
• The Grove
  Hall Grove, Welwyn Garden City, Hertfordshire, AL7 4PH
• The Hedgehog
  Shoplands, Welwyn Garden City, Hertfordshire, AL8 7RH
• The Hollybush
  Hollybush Lane, Welwyn Garden City, Hertfordshire, AL7 4JU
• The Hopfields
  Homestead Road, Hatfield, Hertfordshire, AL10 0QW
• The North Star
  82 Great North Road, Welwyn, Hertfordshire, AL6 0TA
• The Plough
  43 Plough Hill, Potters Bar, Hertfordshire, EN6 4DW
• The Red Lion
  11 Digswell Hill, Welwyn, Hertfordshire, AL6 9AJ
• The Red Lion
  26 London Road, Woolmer Green, Hertfordshire, SG3 6JP
• The Red Lion
  88 Great North Road, Hatfield, Hertfordshire, AL9 5EU
• The Rose And Crown
  14 Church Street, Welwyn, Hertfordshire, AL6 9LX
• The Sheldan Inn
  Sloansway, Welwyn Garden City, Hertfordshire, AL7 1NB
• The Steamer
  22 London Road, Welwyn, Hertfordshire, AL6 9DP
• The Sun Inn
  31 Lemsford Village, Welwyn Garden City, Hertfordshire, AL8 7TN
• The Two Brewers
  1 Northaw Road West, Potters Bar, Hertfordshire, EN6 4NW
• The Two Willows
  9 Howardsgate, Welwyn Garden City, Hertfordshire, AL8 6AL
• The Waggoners
  Brickwall Close, Welwyn, Hertfordshire, AL6 9AA
• The Wellington
  1 High Street, Welwyn, Hertfordshire, AL6 9LZ
• The White Hart
  2 Prospect Place, Welwyn, Hertfordshire, AL6 9EN
• The White Hart
  Queensway, Hatfield, Hertfordshire, AL10 0LW
• The White Horse
  30 Mill Lane, Welwyn, Hertfordshire, AL6 9ET
• The Woodman
  45 Wild Hill, Hatfield, Hertfordshire, AL9 6EA
• The Woodman Inn
  21 Warrengate Road, Hatfield, Hertfordshire, AL9 7TT
• The Wrestlers
  89 Great North Road, Hatfield, Hertfordshire, AL9 5LP
• Welwyn Sports & Social Club
  The Pavilion, Ottway Walk, Welwyn, Hertfordshire, AL6 9AS
• Wetherspoon
  Harpsfield Hall, 13a Parkhouse Court, Hatfield, Hertfordshire, AL10 9RQ