Context:

Pubs, or public houses, are popular traditional British gathering places where alcohol and food is served.

Content:

This dataset includes information on 51,566 pubs. This dataset contains the following columns:

• fsa_id (int): Food Standard Agency's ID for this pub.
• name (string)L 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.

Acknowledgements:

The data was derived from the Food Standard Agency's Food Hygiene Ratings and the ONS Postcode Directory. The data is licensed under the Open Government Licence. (See the included .html file.)

Inspiration:

You could use this data as the basis for a real-life travelling salesman problem and plan the world’s longest pub crawl.

Comprehensive dataset containing 38,643 verified Pub businesses in United Kingdom with complete contact information, ratings, reviews, and location data.

Context

UK pubs as open data, including pub name, address, position and local authority.

Content

• fsa_id
• name
• address
• postcode
• easting
• northing
• latitude
• longitude
• local_authority

fsa_id is the FSA's ID for the premises and allows you to link the pub to their Food Hygiene Ratings.

Acknowledgements

For latest version and documentation see the Open Pubs homepage.

Derived from the Food Standard Agency Food Hygiene Ratings database and licensed under their terms and conditions.

Local Authority field derived from the ONS Postcode Directory licensed under the OGL.

• Contains OS data © Crown copyright and database right 2016
• Contains Royal Mail data © Royal Mail copyright and database right 2016
• Contains National Statistics data © Crown copyright and database right 2016

Published and maintained by GetTheData.

Inspiration

Create mashups with other geocoded open datasets: Pubs/Bus Stop Mashup

Optimise pubcrawls: World's longest pub crawl: Maths team plots route between 25,000 UK boozers

Geocoded Pubs in England with Food Hygiene Ratings

Establishments and their Location Information

By GetTheData [source]

About this dataset

This dataset - Geocoded Open Pubs in England, with Food Hygiene Ratings - contains data on open pubs located in England, such as their FSA ID, name, address and postcode, easting and northing coordinates for geographical mapping purposes, as well as latitude and longitude values. This information can be used to plot pubs onto a map or to create applications that allow you to locate the nearest pub. You can also mashup this data with other geocoded datasets for even more prospects of use. With this dataset you are able to link the pub with their corresponding data in the Food Standards Agency's Food Hygiene Ratings database and work out an efficient route should you want to embark upon an epic pub crawl around England!

The raw data used for this dataset comes from the Food Standard Agency's Food Hygiene Ratings database and is licensed under their terms & conditions. The local authority field is derived from the ONS Postcode Directory which is licenced under OGL (Open Government Licence). This open-data has been published by GetTheData (https://www.getthedata.com) thank you!

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

• To get started with this data set you'll need to have some basic understanding of GIS systems (GPS) as well as knowledge on finding FSA ID's. With that said let's go through a few simple steps on how best to utilise this dataset:

• Take at look at the columns provided in the data set as they will provide you useful insight into what kind of information is available for each pub. This will let you narrow down certain pubs if it matches your purpose or location better than others.

• Once you've determined which pubs may fit your criteria use either easting/northing or lat/long (depending what platform you are using) along with other columns such as postal code or local authority for reference points - making sure to double check accuracy when referencing certain areas.

  • Making sure your referenced locations are correct allow them act like floor plans - pinning parks and buses stops around these points can further help locate some great points of interest within a given area e.,g parks nearby or bus stops leading up closer getting there!

  • With this close eye over specific areas it makes easier going tracking down information related places whether they be small scale (pubs) or large scale (town centres). Additional data sourced from such sources like OS Maps make plotting additional layers easier ensuring accuracy when pinpointing locations but also keeping track route paths taking guesses out off tricky situations finding right direction any situation providing routes between multiple points easily

• Hitting two birds one stone make effort successful poking around featured area especially selecting best displayed locations putting all pieces together combining datasets creating mashups applications expanding knowledge individual topics make understanding clear meet first goal achieving aspirations goals prospects far simpler task making complete process lot enjoyable bringing desired results forefront far quicker rate providing quality end product everytime respecting boundaries regulations policies standards privacy all times highest level appreciation recognition pick one best suited everyone occasion last statement something think thoroughly research upon ensuring confident before building individual or company related projects using geocoded based datasets obtain full understanding

Research Ideas

• Combining pubs and their respective food hygiene ratings to create an app that helps users select and rate pubs based on their last inspection rating.
• Creating an automated pub-crawling route planner to help guide pub crawls more efficiently, based on geographical locations of pubs in the dataset.
• Creating a web application that displays all Open Pubs at once with their addresses and contact details for customers to find easily, either by simply typing in the postcode or zooming in into an area on a map

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

See the dataset description for more information.

Columns

File: open_pubs.csv | Column name | Description | |:-----------------------------------------------...

Comprehensive statistical dataset containing detailed information about Pubs located in Ireland and the UK. This dataset includes business listings, ratings, reviews, geographical distribution, and performance metrics. The data is regularly updated and provides valuable insights for market research, location-based services, and business analysis.

BWA and STAR format reference files for GRCm39 used by XenoCP

FASTA file from EBI GRCm39 (https://ftp.ebi.ac.uk/pub/databases/gencode/Gencode_mouse/release_M33/GRCm39.genome.fa.gz)

STAR reference uses Gencode release M33 (https://ftp.ebi.ac.uk/pub/databases/gencode/Gencode_mouse/release_M33/gencode.vM33.annotation.gtf.gz).

United Kingdom Export: sa: BoP: 2005p: Non EU: Mfg: PU: Pub: Sound Recordings data was reported at 6.000 GBP mn in Mar 2010. This records a decrease from the previous number of 7.000 GBP mn for Dec 2009. United Kingdom Export: sa: BoP: 2005p: Non EU: Mfg: PU: Pub: Sound Recordings data is updated quarterly, averaging 20.000 GBP mn from Mar 1998 (Median) to Mar 2010, with 49 observations. The data reached an all-time high of 58.000 GBP mn in Dec 2005 and a record low of 5.000 GBP mn in Dec 2008. United Kingdom Export: sa: BoP: 2005p: Non EU: Mfg: PU: Pub: Sound Recordings data remains active status in CEIC and is reported by Office for National Statistics. The data is categorized under Global Database’s UK – Table UK.JA063: Exports: BPM5 Basis: SIC 2003: 2005 Price: Seasonally Adjusted: By Industry: Non EU Countries.

United Kingdom Export: sa: BoP: 2005p: Non EU: Mfg: PU: Pub: Newspaper data was reported at 3.000 GBP mn in Mar 2010. This records an increase from the previous number of 2.000 GBP mn for Dec 2009. United Kingdom Export: sa: BoP: 2005p: Non EU: Mfg: PU: Pub: Newspaper data is updated quarterly, averaging 1.000 GBP mn from Mar 1998 (Median) to Mar 2010, with 49 observations. The data reached an all-time high of 9.000 GBP mn in Dec 2008 and a record low of 0.000 GBP mn in Sep 2007. United Kingdom Export: sa: BoP: 2005p: Non EU: Mfg: PU: Pub: Newspaper data remains active status in CEIC and is reported by Office for National Statistics. The data is categorized under Global Database’s UK – Table UK.JA063: Exports: BPM5 Basis: SIC 2003: 2005 Price: Seasonally Adjusted: By Industry: Non EU Countries.

United Kingdom Import: sa: BoP: 2003p: EU: Mfg: PU: Pub: Journals data was reported at 17.000 GBP mn in Mar 2009. This records a decrease from the previous number of 24.000 GBP mn for Dec 2008. United Kingdom Import: sa: BoP: 2003p: EU: Mfg: PU: Pub: Journals data is updated quarterly, averaging 34.000 GBP mn from Mar 1998 (Median) to Mar 2009, with 45 observations. The data reached an all-time high of 51.000 GBP mn in Dec 1998 and a record low of 17.000 GBP mn in Mar 2009. United Kingdom Import: sa: BoP: 2003p: EU: Mfg: PU: Pub: Journals data remains active status in CEIC and is reported by Office for National Statistics. The data is categorized under Global Database’s UK – Table UK.JA052: Imports: BPM5 Basis: SIC 2003: 2003 Price: Seasonally Adjusted: By Industry: EU Countries.