Open Pubs

Description

UK pub names, addresses, positions, and local authority as open data.

Download

Download

Filename: open_pubs.csv.zip

Version

Last update: February 2022.

Archive

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.

Open Pubs by Local Authority

Subsets of the Open Pubs dataset are available for each local authority here.

Open Pubs - London

Pubs falling under each London Borough as one dataset is available here.

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.

Applications

This table combines Open Pubs with the ONS Postcode Database to show the number of pubs by local authority. Click the local authority to see all the pubs in that local authority area. Click a pub to see a mashup of pubs and bus stops using Open Pubs and bus stop data from NaPTAN.

Local Authority Number of Pubs
Aberdeen City209
Aberdeenshire76
Adur52
Allerdale107
Amber Valley181
Angus137
Arun105
Ashfield94
Ashford80
Babergh93
Barking and Dagenham33
Barnet120
Barnsley279
Barrow-in-Furness104
Basildon72
Basingstoke and Deane110
Bassetlaw122
Bath and North East Somerset165
Bedford136
Bexley125
Birmingham499
Blaby62
Blackburn with Darwen115
Blackpool50
Blaenau Gwent106
Bolsover80
Bolton195
Boston65
Bournemouth, Christchurch and Poole219
Bracknell Forest67
Bradford478
Braintree135
Breckland104
Brent91
Brentwood91
Bridgend151
Brighton and Hove348
Bristol, City of409
Broadland73
Bromley186
Bromsgrove101
Broxbourne46
Broxtowe78
Buckinghamshire487
Burnley101
Bury72
Caerphilly219
Calderdale340
Cambridge91
Camden262
Cannock Chase94
Canterbury163
Cardiff219
Carlisle102
Carmarthenshire262
Castle Point38
Central Bedfordshire165
Ceredigion93
Charnwood174
Chelmsford127
Cheltenham97
Cherwell111
Cheshire East281
Cheshire West and Chester176
Chesterfield140
Chichester143
Chorley108
City of Edinburgh511
City of London215
Clackmannanshire49
Colchester105
Conwy183
Copeland113
Cornwall564
Cotswold132
County Durham686
Coventry189
Craven97
Crawley54
Croydon50
Dacorum128
Darlington99
Dartford64
Denbighshire54
Derby206
Derbyshire Dales164
Doncaster299
Dorset409
Dover158
Dudley295
Dundee City188
Ealing155
East Ayrshire41
East Cambridgeshire63
East Devon156
East Dunbartonshire47
East Hampshire132
East Hertfordshire181
East Lindsey295
East Lothian92
East Renfrewshire12
East Riding of Yorkshire432
East Staffordshire114
East Suffolk227
Eastbourne56
Eastleigh74
Eden126
Elmbridge132
Enfield146
Epping Forest152
Epsom and Ewell27
Erewash118
Exeter114
Falkirk113
Fareham60
Fenland72
Fife404
Flintshire159
Folkestone and Hythe139
Forest of Dean35
Fylde68
Gateshead184
Gedling49
Glasgow City357
Gloucester27
Gosport55
Gravesham76
Great Yarmouth100
Greenwich108
Guildford105
Gwynedd150
Hackney174
Halton90
Hambleton115
Hammersmith and Fulham122
Harborough72
Haringey97
Harlow62
Harrogate124
Harrow83
Hart52
Hartlepool116
Hastings91
Havant48
Havering90
Herefordshire, County of229
Hertsmere46
High Peak105
Highland48
Hillingdon143
Hinckley and Bosworth115
Horsham108
Hounslow131
Huntingdonshire133
Hyndburn103
Inverclyde67
Ipswich69
Isle of Anglesey85
Isle of Wight206
Isles of Scilly10
Islington165
Kensington and Chelsea97
King's Lynn and West Norfolk179
Kingston upon Hull, City of186
Kingston upon Thames104
Kirklees525
Knowsley59
Lambeth167
Lancaster134
Leeds611
Leicester176
Lewes98
Lewisham86
Lichfield124
Lincoln85
Liverpool370
Luton55
Maidstone120
Maldon63
Malvern Hills104
Manchester366
Mansfield91
Medway119
Melton63
Mendip163
Merthyr Tydfil79
Merton63
Mid Devon81
Mid Suffolk80
Mid Sussex106
Middlesbrough115
Midlothian43
Milton Keynes126
Mole Valley60
Monmouthshire110
Moray68
Na h-Eileanan Siar11
Neath Port Talbot169
New Forest185
Newark and Sherwood134
Newcastle-under-Lyme121
Newcastle upon Tyne283
Newham64
Newport113
North Ayrshire150
North Devon133
North East Derbyshire112
North East Lincolnshire149
North Hertfordshire129
North Kesteven109
North Lanarkshire223
North Lincolnshire131
North Norfolk145
North Northamptonshire299
North Somerset201
North Tyneside146
North Warwickshire102
North West Leicestershire99
Northumberland446
Norwich172
Nottingham252
Nuneaton and Bedworth102
Oadby and Wigston31
Oldham240
Orkney Islands15
Oxford139
Pembrokeshire191
Pendle82
Perth and Kinross60
Peterborough92
Plymouth154
Portsmouth185
Powys289
Preston130
Reading113
Redbridge75
Redcar and Cleveland136
Redditch48
Reigate and Banstead100
Renfrewshire148
Rhondda Cynon Taf307
Ribble Valley118
Richmond upon Thames150
Richmondshire52
Rochdale194
Rochford45
Rossendale71
Rother107
Rotherham205
Rugby120
Runnymede63
Rushcliffe63
Rushmoor49
Rutland48
Ryedale84
Salford166
Sandwell220
Scarborough178
Scottish Borders149
Sedgemoor163
Sefton246
Selby62
Sevenoaks103
Sheffield349
Shetland Islands26
Shropshire416
Slough28
Solihull131
Somerset West and Taunton147
South Ayrshire128
South Cambridgeshire107
South Derbyshire112
South Gloucestershire186
South Hams118
South Holland63
South Kesteven135
South Lakeland185
South Lanarkshire248
South Norfolk109
South Oxfordshire83
South Ribble80
South Somerset178
South Staffordshire129
South Tyneside129
Southampton151
Southend-on-Sea83
Southwark201
Spelthorne59
St Albans122
St. Helens154
Stafford162
Staffordshire Moorlands101
Stevenage39
Stockport172
Stockton-on-Tees162
Stoke-on-Trent246
Stratford-on-Avon171
Stroud93
Sunderland229
Surrey Heath47
Sutton43
Swale140
Swansea213
Swindon126
Tameside242
Tamworth61
Tandridge93
Teignbridge155
Telford and Wrekin142
Tendring102
Test Valley118
Tewkesbury59
Thanet153
Three Rivers41
Thurrock55
Tonbridge and Malling102
Torbay77
Torfaen101
Torridge95
Tower Hamlets169
Trafford157
Tunbridge Wells90
Uttlesford87
Vale of Glamorgan124
Vale of White Horse117
Wakefield327
Walsall189
Waltham Forest90
Wandsworth174
Warrington189
Warwick121
Watford47
Waverley88
Wealden146
Welwyn Hatfield55
West Berkshire157
West Devon71
West Dunbartonshire54
West Lancashire108
West Lindsey93
West Lothian49
West Northamptonshire325
West Oxfordshire114
West Suffolk128
Westminster354
Wigan211
Wiltshire549
Winchester109
Windsor and Maidenhead92
Wirral229
Woking62
Wokingham88
Wolverhampton178
Worcester99
Worthing86
Wrexham76
Wychavon161
Wyre101
Wyre Forest126
York219

Related dataset: Open Units

The number of units of alcohol in branded drinks in a variety of standard servings:

Ten random drinks from Open Units

GetTheData
Source: Open Pubs
Licence: FSA terms & conditions

X