Open Pubs

Description

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

Download

Download

Filename: open_pubs.csv.zip

Version

Last update: August 2018.

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 City204
Aberdeenshire69
Adur44
Allerdale118
Amber Valley178
Angus140
Argyll and Bute70
Arun105
Ashfield98
Ashford85
Aylesbury Vale198
Babergh96
Barking and Dagenham38
Barnet127
Barnsley252
Barrow-in-Furness103
Basildon74
Basingstoke and Deane108
Bassetlaw119
Bath and North East Somerset173
Bedford140
Bexley122
Birmingham413
Blaby64
Blackburn with Darwen133
Blackpool53
Blaenau Gwent105
Bolsover88
Bolton229
Boston75
Bournemouth107
Bracknell Forest67
Bradford476
Braintree132
Breckland114
Brent96
Brentwood109
Bridgend164
Brighton and Hove340
Bristol, City of393
Broadland78
Bromley182
Bromsgrove96
Broxbourne47
Broxtowe82
Burnley102
Bury64
Caerphilly221
Calderdale353
Cambridge99
Camden259
Cannock Chase88
Canterbury169
Cardiff224
Carlisle94
Carmarthenshire268
Castle Point39
Central Bedfordshire178
Ceredigion109
Charnwood173
Chelmsford135
Cheltenham91
Cherwell113
Cheshire East274
Cheshire West and Chester209
Chesterfield135
Chichester158
Chiltern71
Chorley114
Christchurch35
City of Edinburgh493
City of London238
Clackmannanshire51
Colchester118
Conwy174
Copeland109
Cornwall561
Cotswold125
County Durham668
Coventry191
Craven117
Crawley54
Croydon45
Dacorum128
Darlington105
Dartford70
Daventry92
Denbighshire42
Derby201
Derbyshire Dales167
Doncaster296
Dover150
Dudley305
Dumfries and Galloway146
Dundee City193
Ealing148
East Ayrshire52
East Cambridgeshire68
East Devon155
East Dorset60
East Dunbartonshire52
East Hampshire130
East Hertfordshire181
East Lindsey199
East Lothian97
East Northamptonshire104
East Renfrewshire11
East Riding of Yorkshire422
East Staffordshire121
Eastbourne64
Eastleigh78
Eden124
Elmbridge132
Enfield166
Epping Forest163
Epsom and Ewell25
Erewash121
Exeter118
Falkirk118
Fareham56
Fenland86
Fife408
Flintshire150
Forest Heath54
Forest of Dean36
Fylde72
Gateshead199
Gedling47
Glasgow City372
Gloucester20
Gosport55
Gravesham91
Great Yarmouth117
Greenwich113
Guildford96
Gwynedd147
Hackney199
Halton103
Hambleton121
Hammersmith and Fulham123
Harborough77
Haringey94
Harlow68
Harrogate191
Harrow87
Hart58
Hartlepool110
Hastings89
Havant42
Havering94
Herefordshire, County of228
Hertsmere49
High Peak145
Highland42
Hillingdon152
Hinckley and Bosworth115
Horsham104
Hounslow122
Huntingdonshire137
Hyndburn108
Inverclyde68
Ipswich63
Isle of Anglesey81
Isle of Wight200
Isles of Scilly8
Islington156
Kensington and Chelsea105
Kettering80
King's Lynn and West Norfolk181
Kingston upon Hull, City of185
Kingston upon Thames119
Kirklees550
Knowsley52
Lambeth196
Lancaster165
Leeds593
Leicester178
Lewes103
Lewisham77
Lichfield134
Lincoln93
Liverpool477
Luton58
Maidstone124
Maldon66
Malvern Hills109
Manchester326
Mansfield89
Medway119
Melton55
Mendip154
Merthyr Tydfil80
Merton80
Mid Devon89
Mid Suffolk83
Mid Sussex107
Middlesbrough121
Midlothian51
Milton Keynes136
Mole Valley63
Monmouthshire122
Moray81
Na h-Eileanan Siar16
Neath Port Talbot168
New Forest166
Newark and Sherwood136
Newcastle-under-Lyme123
Newcastle upon Tyne266
Newham47
Newport115
North Ayrshire164
North Devon139
North Dorset79
North East Derbyshire126
North East Lincolnshire140
North Hertfordshire136
North Kesteven109
North Lanarkshire232
North Lincolnshire139
North Norfolk148
North Somerset117
North Tyneside30
North Warwickshire97
North West Leicestershire98
Northampton133
Northumberland463
Norwich155
Nottingham259
Nuneaton and Bedworth104
Oadby and Wigston33
Oldham248
Orkney Islands11
Oxford144
Pembrokeshire154
Pendle88
Perth and Kinross53
Peterborough90
Plymouth129
Poole57
Portsmouth163
Powys291
Preston136
Purbeck57
Reading112
Redbridge83
Redcar and Cleveland130
Redditch49
Reigate and Banstead70
Renfrewshire151
Rhondda Cynon Taf312
Ribble Valley112
Richmond upon Thames157
Richmondshire53
Rochdale188
Rochford1
Rossendale78
Rother111
Rotherham211
Rugby119
Runnymede62
Rushcliffe74
Rushmoor52
Rutland50
Ryedale89
Salford185
Sandwell235
Scarborough211
Scottish Borders161
Sedgemoor161
Sefton246
Selby66
Sevenoaks102
Sheffield273
Shepway132
Shetland Islands27
Shropshire369
Slough29
Solihull129
South Ayrshire150
South Bucks63
South Cambridgeshire73
South Derbyshire113
South Gloucestershire209
South Hams117
South Holland76
South Kesteven137
South Lakeland180
South Lanarkshire244
South Norfolk111
South Northamptonshire120
South Oxfordshire77
South Ribble38
South Somerset199
South Staffordshire111
South Tyneside146
Southampton152
Southend-on-Sea84
Southwark186
Spelthorne58
St Albans119
St Edmundsbury88
St. Helens159
Stafford152
Staffordshire Moorlands123
Stevenage40
Stockport141
Stockton-on-Tees169
Stoke-on-Trent246
Stratford-on-Avon196
Stroud111
Suffolk Coastal132
Sunderland236
Surrey Heath50
Sutton40
Swale133
Swansea191
Swindon112
Tameside218
Tamworth62
Tandridge96
Taunton Deane88
Teignbridge163
Telford and Wrekin144
Tendring105
Test Valley118
Tewkesbury65
Thanet151
Three Rivers37
Thurrock61
Tonbridge and Malling105
Torbay82
Torfaen104
Torridge94
Tower Hamlets163
Trafford143
Tunbridge Wells82
Uttlesford92
Vale of Glamorgan133
Vale of White Horse135
Wakefield306
Walsall201
Waltham Forest87
Wandsworth172
Warrington196
Warwick115
Watford36
Waveney105
Waverley90
Wealden166
Wellingborough82
Welwyn Hatfield56
West Berkshire148
West Devon69
West Dorset149
West Dunbartonshire52
West Lancashire110
West Lindsey98
West Lothian59
West Oxfordshire108
West Somerset66
Westminster368
Weymouth and Portland75
Wigan177
Wiltshire580
Winchester118
Windsor and Maidenhead106
Wirral208
Woking61
Wokingham86
Wolverhampton182
Worcester100
Worthing74
Wrexham90
Wychavon158
Wycombe156
Wyre88
Wyre Forest104
York223

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