UK pub names, addresses, positions, and local authority as open data.
Filename: open_pubs.csv.zip
Last update: February 2022.
Derived from the Food Standard Agency's Food Hygiene Ratings and the ONS Postcode Directory.
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.
Subsets of the Open Pubs dataset are available for each local authority here.
Pubs falling under each London Borough as one dataset is available here.
| 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. |
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.
The number of units of alcohol in branded drinks in a variety of standard servings:
GetTheData
Source: Open Pubs
Licence: FSA terms & conditions
GetTheData.com is owned and operated by GetTheData Publishing Limited.
Company Number: 11075184 · Registered in England and Wales.
Registered Office: 21 Horseshoe Park, Pangbourne, Reading, United Kingdom, RG8 7JW
By accessing our site you agree to us using cookies, and sharing information about your use of our site, in accordance with our privacy policy.
Company Records Privacy Notice
Execution time: 30ms
Inc: static.open-pubs
