We organise UK open data by location and signpost the source.

Open Pubs

Description

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

Download

Download

Filename: open_pubs.csv.zip

Version

Last update: July 2020.

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 City200
Aberdeenshire79
Adur44
Allerdale116
Amber Valley179
Angus138
Argyll and Bute72
Arun109
Ashfield95
Ashford84
Aylesbury Vale194
Babergh93
Barking and Dagenham35
Barnet123
Barnsley265
Barrow-in-Furness103
Basildon74
Basingstoke and Deane107
Bassetlaw120
Bath and North East Somerset164
Bedford139
Bexley122
Birmingham475
Blaby59
Blackburn with Darwen122
Blackpool51
Blaenau Gwent108
Bolsover86
Bolton189
Boston66
Bournemouth, Christchurch and Poole201
Bracknell Forest62
Bradford463
Braintree123
Breckland108
Brent88
Brentwood103
Bridgend157
Brighton and Hove359
Bristol, City of392
Broadland75
Bromley182
Bromsgrove99
Broxbourne49
Broxtowe81
Burnley100
Bury60
Caerphilly225
Calderdale341
Cambridge91
Camden280
Cannock Chase89
Canterbury162
Cardiff211
Carlisle94
Carmarthenshire263
Castle Point37
Central Bedfordshire156
Ceredigion100
Charnwood177
Chelmsford129
Cheltenham94
Cherwell102
Cheshire East284
Cheshire West and Chester202
Chesterfield141
Chichester146
Chiltern70
Chorley108
City of Edinburgh507
City of London228
Clackmannanshire49
Colchester105
Conwy179
Copeland109
Corby41
Cornwall548
Cotswold128
County Durham649
Coventry189
Craven88
Crawley54
Croydon43
Dacorum126
Darlington105
Dartford63
Daventry89
Denbighshire57
Derby200
Derbyshire Dales166
Doncaster302
Dorset417
Dover153
Dudley290
Dumfries and Galloway146
Dundee City186
Ealing147
East Ayrshire43
East Cambridgeshire66
East Devon159
East Dunbartonshire47
East Hampshire125
East Hertfordshire179
East Lindsey287
East Lothian96
East Northamptonshire103
East Renfrewshire11
East Riding of Yorkshire436
East Staffordshire117
East Suffolk225
Eastbourne57
Eastleigh78
Eden125
Elmbridge128
Enfield160
Epping Forest155
Epsom and Ewell25
Erewash119
Exeter118
Falkirk114
Fareham57
Fenland90
Fife402
Flintshire160
Folkestone and Hythe140
Forest of Dean35
Fylde70
Gateshead184
Gedling46
Glasgow City362
Gloucester24
Gosport54
Gravesham87
Great Yarmouth98
Greenwich102
Guildford101
Gwynedd141
Hackney173
Halton96
Hambleton121
Hammersmith and Fulham122
Harborough69
Haringey92
Harlow64
Harrogate193
Harrow84
Hart55
Hartlepool111
Hastings86
Havant49
Havering90
Herefordshire, County of232
Hertsmere45
Highland46
Hillingdon146
Hinckley and Bosworth113
Horsham104
Hounslow129
Huntingdonshire130
Hyndburn103
Inverclyde69
Ipswich67
Isle of Anglesey86
Isle of Wight204
Isles of Scilly10
Islington174
Kensington and Chelsea103
Kettering79
King's Lynn and West Norfolk182
Kingston upon Hull, City of184
Kingston upon Thames110
Kirklees528
Knowsley61
Lambeth177
Lancaster130
Leeds594
Leicester174
Lewes101
Lewisham92
Lichfield129
Lincoln88
Liverpool406
Luton54
Maidstone126
Maldon64
Malvern Hills110
Manchester342
Mansfield90
Medway113
Melton61
Mendip165
Merthyr Tydfil77
Merton63
Mid Devon87
Mid Suffolk82
Mid Sussex106
Middlesbrough111
Midlothian49
Milton Keynes128
Mole Valley64
Monmouthshire119
Moray81
Na h-Eileanan Siar15
Neath Port Talbot170
New Forest178
Newark and Sherwood135
Newcastle-under-Lyme127
Newcastle upon Tyne253
Newham61
Newport113
North Ayrshire157
North Devon128
North East Derbyshire119
North East Lincolnshire144
North Hertfordshire128
North Kesteven106
North Lanarkshire216
North Lincolnshire132
North Norfolk150
North Somerset203
North Tyneside136
North Warwickshire99
North West Leicestershire96
Northampton132
Northumberland445
Norwich162
Nottingham246
Nuneaton and Bedworth104
Oadby and Wigston29
Oldham245
Orkney Islands14
Oxford141
Pembrokeshire162
Pendle80
Perth and Kinross57
Peterborough87
Plymouth149
Portsmouth182
Powys284
Preston130
Reading117
Redbridge80
Redcar and Cleveland137
Redditch51
Reigate and Banstead69
Renfrewshire152
Rhondda Cynon Taf305
Ribble Valley109
Richmond upon Thames148
Richmondshire54
Rochdale194
Rochford45
Rossendale78
Rother111
Rotherham206
Rugby119
Runnymede63
Rushcliffe70
Rushmoor51
Rutland49
Ryedale85
Salford183
Sandwell231
Scarborough179
Scottish Borders151
Sedgemoor164
Sefton237
Selby63
Sevenoaks103
Sheffield319
Shetland Islands27
Shropshire406
Slough26
Solihull127
Somerset West and Taunton152
South Ayrshire143
South Bucks62
South Cambridgeshire106
South Derbyshire109
South Gloucestershire197
South Hams133
South Holland72
South Kesteven138
South Lakeland174
South Lanarkshire243
South Norfolk106
South Northamptonshire115
South Oxfordshire75
South Ribble46
South Somerset199
South Staffordshire123
South Tyneside140
Southampton147
Southend-on-Sea86
Southwark197
Spelthorne58
St Albans120
St. Helens153
Stafford159
Stevenage40
Stockport154
Stockton-on-Tees168
Stoke-on-Trent254
Stratford-on-Avon188
Stroud102
Sunderland223
Surrey Heath45
Sutton44
Swale137
Swansea202
Swindon118
Tameside224
Tamworth64
Tandridge93
Teignbridge157
Telford and Wrekin135
Tendring99
Test Valley124
Tewkesbury65
Thanet152
Three Rivers41
Thurrock57
Tonbridge and Malling101
Torbay78
Torfaen101
Torridge98
Tower Hamlets162
Trafford145
Tunbridge Wells86
Uttlesford93
Vale of Glamorgan128
Vale of White Horse122
Wakefield315
Walsall194
Waltham Forest89
Wandsworth170
Warrington194
Warwick121
Watford45
Waverley89
Wealden155
Wellingborough77
Welwyn Hatfield53
West Berkshire151
West Devon77
West Dunbartonshire45
West Lancashire105
West Lindsey91
West Lothian44
West Oxfordshire109
West Suffolk128
Westminster350
Wigan207
Wiltshire538
Winchester107
Windsor and Maidenhead94
Wirral217
Woking60
Wokingham89
Wolverhampton183
Worcester100
Worthing77
Wrexham86
Wychavon153
Wycombe153
Wyre97
Wyre Forest111
York218

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