Open Pubs - Flintshire

1. Home
2. Open Pubs

Description

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

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

Download

Download

Filename: open_pubs_flintshire.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 Flintshire:

• Anchor Hotel
  Anchor Hotel, The Anchor Hotel, High Street Saltney, Flintshire, CH4 8SE
• Argoed Sports And Social Club
  Argoed Sports And Social Club, The Pavilion, Snowdon Avenue Bryn-y-baal, Flintshire, CH7 6SZ
• Beachcomber Inn
  Beachcomber Inn, Shore Road, Gronant, Flintshire, LL19 9SS
• Bells Of St Marys
  Bells Of St Marys, Bells Of St Marys, Mostyn Road Gronant, Flintshire, LL19 9TB
• Blue Anchor Inn
  Blue Anchor Inn, 153 Mold Road, Buckley, Flintshire, CH7 2NH
• Blue Bell
  Blue Bell, The Blue Bell, 7 Chester Road, Flintshire, CH7 3AE
• Blue Bell Inn
  Blue Bell Inn, Halkyn, Holywell, Flintshire, CH8 8DL
• Boar's Head
  Boars Head, The Boars Head, 21 High Street, Flintshire, CH8 7TE
• Boathouse Sports Bar
  Boathouse Sports Bar, Connahs Quay Precinct, High Street Connahs Quay, Flintshire, CH5 4DD
• Boot And Ship Inn
  Boot And Ship Inn, Boot & Ship Hotel, High Street Bagillt, Flintshire, CH6 6HE
• Bridge Inn
  Bridge Inn, Chester Road, Sandycroft, Flintshire, CH5 2QN
• Bryn Griffiths Workingmen's Cl
  Bryn Griffiths Workingmens Club, 85 High Street, Mold, Flintshire, CH7 1BQ
• Buckley Conservative Club
  Buckley Conservative Club, Liverpool Road, Buckley, Flintshire, CH7 3ND
• Buckley Cricket Club
  Buckley Cricket Club, Chester Road, Buckley, Flintshire, CH7 3AQ
• Buckley Workingmen's Club
  Buckley Workingmens Club, Buckley Working Mens Social Club, Brook Street, Flintshire, CH7 3AL
• Butchers Arms
  Butchers Arms, Nercwys, Mold, Flintshire, CH7 4EW
• Caergwrle Masonic Hall
  Caergwrle Masonic Hall, High Street, Caergwrle, Flintshire, LL12 9ET
• Caergwrle Social Club
  Caergwrle Social Club, Astoria Hall 40a, High Street Caergwrle, Flintshire, LL12 9ET
• Castle Inn
  Castle Inn, Castle Inn Brookside, Brook Road Shotton, Flintshire, CH5 1HL
• Clwyd Hotel
  Clwyd Hotel, The Clwyd, 28 Chester Road West Shotton, Flintshire, CH5 1BY
• Clwyd Theatr Cymru
  Clwyd Theatr Cymru, Theatr Clwyd, Mold, Flintshire, CH7 1YA
• Colomendy Arms
  Colomendy Arms, Village Road, Cadole, Flintshire, CH7 5LL
• Connah's Quay Cricket Club
  Connahs Quay Cricket Club, Cable Street, Connahs Quay, Flintshire, CH5 4DZ
• Connah's Quay Labour Club
  Connahs Quay Labour Club, Connah S Quay Labour Club, Fron Road Connahs Quay, Flintshire, CH5 4PJ
• Corner Pin
  Corner Pin, 186 High Street, Saltney, Flintshire, CH4 8SQ
• Crofts Club
  Crofts Club, Shore Road, Gronant, Flintshire, LL19 9SS
• Crooked Horn
  The Crooked Horn Inn, Bryn-sannan, Brynford, Flintshire, CH8 8AX
• Cross Keys
  Cross Keys, Black Brook, Soughton, Flintshire, CH7 6LT
• Crown Inn
  Crown Inn, London Road, Trelawnyd, Flintshire, LL18 6DN
• Crown Inn
  Crown Inn, 35 High Street, Caergwrle, Flintshire, LL12 9LG
• Crown Inn
  Crown Inn, Crown Inn, B5121 Ffordd Walwen To Berthen Lane Lixw, Flintshire, CH8 8NQ
• Crown Inn
  Crown Inn, Cilcain Road, Pantymwyn, Flintshire, CH7 5EH
• Dee Inn
  Dee Inn, 1 Chester Street, Flint, Flintshire, CH6 5NR
• Deeside Naval Club Ltd
  Deeside Naval Club Ltd, Chapel Street, Connahs Quay, Flintshire, CH5 4SA
• Eagle & Child Inn
  Eagle & Child Inn, Lon Capel, Gwaenysgor, Flintshire, LL18 6EJ
• Ewloe Social Club
  Ewloe Social Club, Old Mold Road, Ewloe, Flintshire, CH5 3AU
• Farmers Arms
  Farmers Arms, Main Road, Ffynnongroyw, Flintshire, CH8 9SW
• Feathers Inn
  Feathers Inn, Whitford Street, Holywell, Flintshire, CH8 7NL
• Ffrwd Inn
  Ffrwd Inn, The Ffrwd, Minera Road Cymau, Flintshire, LL12 9TR
• Flint Golf Club
  Flint Golf Club, Cornist Lane, Flint, Flintshire, CH6 5RA
• Flint Town United F.c
  Flint Town United F.c, Flint Town F.c, Castle Dyke Street, Flintshire, CH6 5PE
• Fox & Grapes
  Fox & Grapes, Fox And Grapes, 6 The Highway Hawarden, Flintshire, CH5 3DH
• Glan Yr Afon Inn
  Glan Yr Afon Inn, Milwr, Holywell, Flintshire, CH8 8HE
• Glasfryn
  Glasfryn, Raikes Lane, Mold, Flintshire, CH7 6LR
• Griffin Inn
  Griffin Inn, 102 Mold Road, Mynydd Isa, Flintshire, CH7 6TF
• Halfway House
  Halfway House, Church Street, Connahs Quay, Flintshire, CH5 4AS
• Hawarden Park Cricket Club
  Hawarden Park Cricket Club, Moor Lane, Hawarden, Flintshire, CH5 3PQ
• Holywell Golf Club
  Holywell Golf Club, Brynford, Holywell, Flintshire, CH8 8LQ
• Horse & Jockey
  Horse & Jockey, 66 Church Road, Buckley, Flintshire, CH7 3JQ
• Lady Augusta Masonic Hall
  Lady Augusta Masonic Hall, Mostyn, Nr. Holywell, Flintshire, CH8 9HW
• Lighthouse Inn
  Lighthouse Inn, Lighthouse Inn, Station Road Talacre, Flintshire, CH8 9RD
• Lletty Hotel
  Lletty Hotel, Coast Road, Mostyn, Flintshire, CH8 9HF
• Masonic Hall (Mold) Company Ltd
  Masonic Hall (Mold) Company Ltd, Masonic Hall, Earl Road, Flintshire, CH7 1AX
• Masons Arms
  Masons Arms, The Masons Arms, Gwespyr, Flintshire, CH8 9LT
• Mcleans Pub
  Mcleans Pub, Chemistry Lane, Sandycroft, Flintshire, CH5 2DA
• Mechanics Arms
  Mechanics Arms, 12 Chester Road East, Pentre, Flintshire, CH5 2AA
• Melrose Inn
  Melrose Inn, The Melrose, Central Drive Shotton, Flintshire, CH5 1LR
• Mill House
  Mill House, Mill House Inn, Chester Road Broughton, Flintshire, CH4 0DP
• Mold Alehouse
  Mold Alehouse, Unit 2 Earl Chambers, Earl Road, Flintshire, CH7 1AL
• Mold Cricket Club
  Mold Cricket Club, Chester Road, Mold, Flintshire, CH7 1UF
• Mold Ex-service Mens Club
  Mold Ex-service Mens Club, 77 Wrexham Street, Mold, Flintshire, CH7 1HQ
• Mold Golf Club
  Mold Golf Club, Cilcain Road, Pantymwyn, Flintshire, CH7 5EH
• Mold Rugby Football Club
  Mold Rugby Football Club, The Clubhouse, Chester Road, Flintshire, CH7 1UF
• Northop Country Park Golf Club
  Northop Country Park Golf Club, Northop Country Park Golf Club Northop C, Northop, Flintshire, CH7 6WA
• Northop Cricket Club
  Northop Cricket Club, Northop Road, Northop, Flintshire, CH7 6BR
• Northop Hall Cricket & Hockey
  Northop Hall Cricket & Hockey, Northop Hall Cricket & Hockey Club, Smithy Lane Northop Hall, Flintshire, CH7 6DE
• Offas Dyke Hotel
  Offas Dyke Hotel, Offas Dyke, Broughton Hall Road Broughton, Flintshire, CH4 0QN
• Old Padeswood Golf Club (Clubhouse)
  Old Padeswood Golf Club (Clubhouse), Padeswood & Buckley Golf Club, Station Lane Padeswood, Flintshire, CH7 4JD
• Owain Glyndwr Inn
  Owain Glyndwr Inn, Glyndwr Road, Gwernymynydd, Flintshire, CH7 5LP
• Padeswood & Buckley Golf Club
  Padeswood & Buckley Golf Club, The Caia Station Road, Padeswood Lake Road Padeswood, Flintshire, CH7 4JD
• Parrot Inn
  Parrot Inn, Drury Lane, Drury, Flintshire, CH7 3DX
• Pen Y Bont Farm
  Pen Y Bont Farm, Chester Road, Mold, Flintshire, CH7 1UJ
• Pennant Resort Ltd
  Pennant Resort Ltd, Llwyn Ifor Lane, Whitford, Flintshire, CH8 9ER
• Poachers Cottage Inn
  Poachers Cottage Inn, Cymau Road, Ffrith, Flintshire, LL11 5LH
• Pontblyddyn Cricket Club
  Pontblyddyn Cricket Club, Pontblyddyn, Mold, Flintshire, CH7 4HW
• Presthaven Sands Carousel Bar
  Presthaven Sands Carousel Bar, Presthaven Sands Holiday Park, Gronant, Flintshire, LL19 9TT
• Presthaven Sands Live Lounge
  Presthaven Sands Live Lounge, Presthaven Sands Holiday Park, Gronant, Flintshire, LL19 9TT
• Presthaven Sands Mash N Barrel
  Presthaven Sands Mash N Barrel, Presthaven Sands Holiday Park, Gronant, Flintshire, LL19 9TT
• Queens Head Inn
  Queens Head Inn, Queens Head, 134 Chester Road, Flintshire, CH7 1UQ
• Railway Inn
  Railway Inn, Corwen Road, Coed Talon, Flintshire, CH7 4TP
• Railway Inn
  Railway Inn, Main Road, Ffynnongroyw, Flintshire, CH8 9SN
• Red Hall Hotel
  Red Hall Hotel, Englefield Avenue, Connahs Quay, Flintshire, CH5 4SX
• Red Lion
  Red Lion, Red Lion Inn, Rhosesmor, Flintshire, CH7 6PF
• Red Lion Inn & Restaurant
  Red Lion Inn & Restaurant, Red Lion, Rhos Road Penyffordd, Flintshire, CH4 0JR
• Rhydymwyn Football Club
  Rhydymwyn Football Club, Vicarage Road, Rhydymwyn, Flintshire, CH7 5HL
• Royal British Legion Club (Flint) Ltd
  Royal British Legion Club (Flint) Ltd, British Leigion Club, Allt Goch, Flintshire, CH6 5NF
• Royal Oak
  Royal Oak, Kinnerton Lane, Higher Kinnerton, Flintshire, CH4 9BE
• Saltney Tavern
  Saltney Tavern, Saltney Social Club, High Street Saltney, Flintshire, CH4 8SQ
• Ship Inn
  Ship Inn, 275 High Street, Connahs Quay, Flintshire, CH5 4DJ
• Spinning Wheel Tavern
  Spinning Wheel Tavern, The Spinning Wheel Tavern, Old Warren Broughton, Flintshire, CH4 0EG
• Swan Hotel
  Swan Hotel, The Swan Hotel, 34 Chester Street, Flintshire, CH6 5DH
• Swan Inn
  Swan Inn, Swan Lane, Gwernymynydd, Flintshire, CH7 4AT
• Talacre Beach Club
  Talacre Beach Club, Station Road, Talacre, Flintshire, CH8 9RD
• Talbot Bar
  Talbot Bar, Point Of Ayr Caravan Camp, West Road Talacre, Flintshire, CH8 9SA
• The Beer Lab Ltd
  The Beer Lab Ltd, St Davids Building, Unit 4 Earl Road, Flintshire, CH7 1AX
• The Black Horse Hotel
  The Black Horse Hotel, Black Horse Hotel, Mold Road, Flintshire, CH7 2JB
• The Black Lion Hotel
  The Black Lion Hotel, Black Lion Inn, Mold Road, Flintshire, CH7 2JA
• The Boot Inn
  The Boot Inn, The Boot, High Street Northop, Flintshire, CH7 6BQ
• The Bridge Inn
  The Bridge Inn, Wrexham Road, Pontblyddyn, Flintshire, CH7 4HN
• The Broad Oak
  The Broad Oak, Maengwyn Avenue, Connahs Quay, Flintshire, CH5 4UQ
• The Burntwood
  The Burntwood, 26 Burntwood Road, Burntwood, Flintshire, CH7 3EN
• The Celtic Arms
  The Celtic Arms, The Celtic Arms Northop Country Park, Northop Country Park Estate Roads Northo, Flintshire, CH7 6WA
• The Central Hotel
  The Central Hotel, Wetherspoons, 2-4 Chester Road West Shotton, Flintshire, CH5 1BX
• The Coach & Horses Inn
  The Coach & Horses Inn, Coach & Horses Inn, Northop Road Flint Mountain, Flintshire, CH6 5QG
• The Cross Foxes Nannerch Ltd
  The Cross Foxes Nannerch Ltd, Cross Foxes Inn, Village Road Nannerch, Flintshire, CH7 5RD
• The Cross Keys Llanfynydd
  The Cross Keys, Cross Keys Inn, Ffordd Llanfynydd Llanfynydd, Flintshire, LL11 5HH
• The Crown And Liver
  The Crown And Liver, Crown & Liver Inn, The Highway Hawarden, Flintshire, CH5 3DN
• The Drover Arms
  The Drover Arms, Drovers Arms, Denbigh Road, Flintshire, CH7 1BP
• The Druid Inn
  The Druid Inn, Gorsedd, Holywell, Flintshire, CH8 8QZ
• The Fat Boar
  The Fat Boar, 17 Chester Street, Mold, Flintshire, CH7 1EG
• The Fox Inn
  The Fox Inn, Ysceifiog, Holywell, Flintshire, CH8 8NJ
• The George & Dragon
  The George & Dragon, 60 Church Street, Flint, Flintshire, CH6 5AE
• The Glynne Arms
  The Glynne Arms, The Glynne Arms, 3 Glynne Way Hawarden, Flintshire, CH5 3NS
• The Gold Cape
  The Gold Cape, 8 Wrexham Street, Mold, Flintshire, CH7 1ES
• The Griffin
  The Griffin, Griffin Inn, 41 High Street, Flintshire, CH7 1BQ
• The Groves Community Sports & Social Club
  The Groves Community Sports & Social Clu, The Groves, Bridge Street Shotton, Flintshire, CH5 1ED
• The Kitchen
  The Kitchen, Crown Inn, Cilcain Road Pantymwyn, Flintshire, CH7 5EH
• The Market Cross
  The Market Cross, 9-11 High Street, Holywell, Flintshire, CH8 7LA
• The Mill Tavern
  The Mill Tavern, Mill Tavern, 80 Northop Road, Flintshire, CH6 5LQ
• The Millstone
  The Millstone, Millstone Inn, Hawarden Road Penyffordd, Flintshire, CH4 0JE
• The New Glynne Arms
  The New Glynne Arms, Chester Road, Broughton, Flintshire, CH4 0DH
• The Old Wine Vaults
  The Old Wine Vaults, The Old Wine Vaults, 3 Cross Street, Flintshire, CH8 7LP
• The Packet House
  The Packet House, Mostyn Road, Greenfield, Flintshire, CH8 7EJ
• The Piccadilly Inn
  The Piccadilly Inn, Piccadilly Inn, North Street Caerwys, Flintshire, CH7 5AW
• The Plough Inn
  The Plough Inn, Plough Inn, Aston Road Queensferry, Flintshire, CH5 1TJ
• The Point
  The Point, Station Road, Talacre, Flintshire, CH8 9RD
• The Red Lion
  The Red Lion, Red Lion Inn, 15 Wrexham Street, Flintshire, CH7 1ET
• The Royal British Legion
  The Royal British Legion, Chester Road, Penyffordd, Flintshire, CH4 0JZ
• The Royal Oak
  The Royal Oak, Greenfield Road, Greenfield, Flintshire, CH8 7QB
• The Running Hare
  The Running Hare, Clos Dewi Sant, Ewloe, Flintshire, CH5 3YB
• The Shamrock
  The Shamrock, Chester Road, Buckley, Flintshire, CH7 3AE
• The Ship Hotel
  The Ship Hotel, Ship Hotel, Market Square, Flintshire, CH6 5NW
• The Stag Inn
  The Stag Inn, High Street, Bagillt, Flintshire, CH6 6ED
• The Tivoli
  The Tivoli, Tivoli Night Club, Brunswick Road, Flintshire, CH7 2EF
• The Top Monkey
  The Top Monkey, The Top Monkey, B5125 Village Road From Wepre Lane Junct, Flintshire, CH7 6HS
• The Trap Bar @ Hope & Anchor Inn
  The Trap Bar @ Hope & Anchor Inn, Hope & Anchor Inn, Ewloe Place, Flintshire, CH7 3NL
• The Welsh Harp
  The Welsh Harp, Welsh Harp Inn, Prince Of Wales Avenue, Flintshire, CH6 5JU
• The Wepre Bar & Grill
  The Wepre Bar & Grill, Palomino Bar & Restaurant, Wepre Lane Connahs Quay, Flintshire, CH5 4JR
• The White Bear
  The White Bear, White Bear Inn, Mancot Lane Mancot, Flintshire, CH5 2AH
• The White Horse Inn
  The White Horse Inn, White Horse Inn, The Square Cilcain, Flintshire, CH7 5NN
• The Yacht Inn
  The Yacht Inn, Yacht Inn, 291 Chester Road Oakenholt, Flintshire, CH6 5SE
• White Lion
  White Lion, White Lion Hotel, Mold Road Buckley, Flintshire, CH7 2NH
• White Lion
  White Lion, White Lion Inn, Hawarden Road Hope, Flintshire, LL12 9NF
• Y Delyn Wine Bar
  Y Delyn Wine Bar, 3 King Street, Mold, Flintshire, CH7 1LA
• Y Pentan
  Y Pentan, 3 New Street, Mold, Flintshire, CH7 1NY
• Ye Olde Castle Inn
  Ye Olde Castle Inn, High Street, Caergwrle, Flintshire, LL12 9EU