Open Pubs

Description

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

Download

Download

Filename: open_pubs.csv.zip

Version

Last update: May 2017.

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 City193
Aberdeenshire86
Adur39
Allerdale111
Amber Valley179
Angus127
Argyll and Bute73
Arun112
Ashfield100
Ashford88
Aylesbury Vale191
Babergh97
Barking and Dagenham41
Barnet139
Barnsley270
Barrow-in-Furness101
Basildon78
Basingstoke and Deane113
Bassetlaw115
Bath and North East Somerset172
Bedford134
Bexley125
Birmingham438
Blaby57
Blackburn with Darwen131
Blackpool60
Bolsover87
Bolton241
Boston80
Bournemouth110
Bracknell Forest67
Bradford475
Braintree138
Breckland117
Brent105
Brentwood111
Bridgend167
Brighton and Hove334
Bristol, City of444
Broadland83
Bromley184
Bromsgrove98
Broxbourne50
Broxtowe32
Burnley104
Bury56
Caerphilly205
Calderdale350
Cambridge82
Camden278
Cannock Chase103
Canterbury166
Cardiff206
Carlisle90
Carmarthenshire265
Castle Point39
Central Bedfordshire185
Ceredigion124
Charnwood180
Chelmsford137
Cheltenham97
Cherwell119
Cheshire East268
Cheshire West and Chester229
Chesterfield130
Chichester154
Chiltern34
Chorley118
Christchurch33
City of Edinburgh486
City of London245
Clackmannanshire53
Colchester122
Conwy167
Copeland115
Cornwall586
Cotswold131
County Durham679
Coventry196
Craven119
Crawley12
Croydon145
Dacorum132
Darlington113
Dartford70
Daventry92
Denbighshire35
Derby200
Derbyshire Dales159
Doncaster306
Dover159
Dudley313
Dumfries and Galloway16
Dundee City199
Ealing151
East Ayrshire51
East Cambridgeshire52
East Devon161
East Dorset52
East Dunbartonshire51
East Hampshire138
East Hertfordshire181
East Lindsey178
East Lothian104
East Northamptonshire111
East Renfrewshire12
East Riding of Yorkshire421
East Staffordshire111
Eastbourne64
Eastleigh72
Eden123
Elmbridge131
Enfield175
Epping Forest153
Epsom and Ewell20
Erewash119
Exeter116
Falkirk122
Fareham46
Fenland87
Fife420
Flintshire146
Forest Heath54
Forest of Dean51
Fylde73
Gateshead195
Gedling49
Glasgow City378
Gloucester22
Gosport51
Gravesham92
Great Yarmouth108
Greenwich122
Guildford86
Gwynedd160
Hackney197
Halton105
Hambleton127
Hammersmith and Fulham135
Harborough83
Haringey98
Harlow70
Harrogate214
Harrow85
Hart52
Hartlepool108
Hastings90
Havant54
Havering95
Herefordshire, County of236
Hertsmere44
High Peak134
Highland37
Hillingdon152
Hinckley and Bosworth115
Horsham108
Hounslow128
Huntingdonshire137
Hyndburn84
Inverclyde73
Ipswich60
Isle of Anglesey80
Isle of Wight189
Isles of Scilly8
Islington183
Kensington and Chelsea110
Kettering79
King's Lynn and West Norfolk192
Kingston upon Hull, City of193
Kingston upon Thames133
Kirklees562
Knowsley56
Lambeth167
Lancaster169
Leeds624
Leicester185
Lewes102
Lewisham72
Lichfield143
Lincoln90
Liverpool494
Luton50
Maidstone114
Maldon66
Malvern Hills107
Manchester409
Mansfield99
Medway127
Melton57
Mendip171
Merthyr Tydfil54
Merton74
Mid Devon89
Mid Suffolk87
Mid Sussex111
Middlesbrough111
Midlothian57
Milton Keynes136
Mole Valley65
Monmouthshire116
Moray79
Na h-Eileanan Siar18
Neath Port Talbot164
New Forest167
Newark and Sherwood154
Newcastle-under-Lyme123
Newcastle upon Tyne271
Newham47
Newport110
North Ayrshire130
North Devon146
North Dorset81
North East Derbyshire128
North East Lincolnshire141
North Hertfordshire145
North Kesteven116
North Lanarkshire237
North Lincolnshire146
North Norfolk152
North Somerset138
North Tyneside21
North Warwickshire102
North West Leicestershire100
Northampton135
Northumberland455
Norwich152
Nottingham260
Nuneaton and Bedworth111
Oadby and Wigston32
Oldham267
Orkney Islands11
Oxford138
Pembrokeshire231
Pendle103
Perth and Kinross92
Peterborough94
Plymouth128
Poole55
Portsmouth181
Powys306
Preston130
Purbeck58
Reading112
Redbridge87
Redcar and Cleveland127
Redditch53
Reigate and Banstead77
Renfrewshire162
Rhondda Cynon Taf314
Ribble Valley108
Richmond upon Thames156
Richmondshire48
Rochdale190
Rochford41
Rossendale79
Rother113
Rotherham215
Rugby123
Runnymede59
Rushcliffe76
Rushmoor57
Rutland53
Ryedale84
Salford182
Sandwell221
Scarborough205
Scottish Borders165
Sedgemoor162
Sefton239
Selby54
Sevenoaks103
Sheffield206
Shepway127
Shropshire382
Slough28
Solihull133
South Ayrshire147
South Bucks6
South Cambridgeshire73
South Derbyshire105
South Gloucestershire226
South Hams128
South Holland78
South Kesteven140
South Lakeland176
South Lanarkshire244
South Norfolk119
South Northamptonshire118
South Oxfordshire46
South Ribble31
South Somerset208
South Staffordshire106
South Tyneside146
Southampton172
Southend-on-Sea89
Southwark203
Spelthorne55
St Albans114
St Edmundsbury85
St. Helens141
Stafford146
Staffordshire Moorlands121
Stevenage38
Stockport68
Stockton-on-Tees156
Stoke-on-Trent239
Stratford-on-Avon203
Stroud120
Suffolk Coastal129
Sunderland246
Surrey Heath33
Sutton44
Swale123
Swansea188
Swindon111
Tameside177
Tamworth63
Tandridge84
Taunton Deane93
Teignbridge156
Telford and Wrekin119
Tendring87
Test Valley121
Tewkesbury41
Thanet152
Three Rivers49
Thurrock65
Tonbridge and Malling104
Torbay90
Torfaen108
Torridge99
Tower Hamlets1
Trafford142
Tunbridge Wells90
Uttlesford88
Vale of Glamorgan132
Vale of White Horse133
Wakefield242
Walsall194
Waltham Forest91
Wandsworth172
Warrington199
Warwick109
Watford35
Waveney107
Waverley95
Wealden172
Wellingborough83
Welwyn Hatfield55
West Berkshire127
West Devon65
West Dorset132
West Dunbartonshire54
West Lancashire117
West Lindsey106
West Lothian85
West Oxfordshire111
West Somerset55
Westminster385
Weymouth and Portland43
Wigan191
Wiltshire626
Winchester120
Windsor and Maidenhead109
Wirral217
Woking54
Wokingham91
Wolverhampton177
Worcester100
Worthing79
Wrexham92
Wychavon153
Wycombe149
Wyre78
Wyre Forest99
York230

GetTheData
Source: Open Pubs
Licence: FSA terms & conditions