Nearest Pint
A new interactive map, 'Nearest Pint', visualizes UK pub density by parliamentary constituency, offering a fascinating look at where the pints flow most freely. Developed by KnowWhere Consulting, this tool leverages public data to provide a detailed geographical analysis of pub availability. It appeals to Hacker News' love for data visualization, practical applications of open data, and perhaps a good old-fashioned pub crawl planning tool.
The Lowdown
The 'Nearest Pint' project presents an interactive map illustrating the density of pubs across Great Britain's Westminster Parliamentary Constituencies. This tool allows users to explore which areas are pub-rich and which are not, expressed as the number of pubs per 10,000 residents, providing a unique geographical insight into the UK's pub landscape.
- Data Sources: Pub information is drawn from the Food Hygiene Rating Service (FHRS) via GetTheData Open Pubs. Constituency boundaries are from the ONS Open Geography Portal, reflecting the July 2024 general election boundaries. Population data comes from the 2021 Census (England/Wales) and mid-2021 estimates (Scotland).
- Methodology: Pub counts were determined using a spatial join in QGIS, mapping pub locations to constituency boundaries. Approximately 6% of pub records without valid coordinates were excluded from the analysis.
- Exclusions: Northern Ireland is not included due to different food hygiene rating schemes and lack of comparable data.
- Density Metric: Pub density is standardized as pubs per 10,000 resident population, allowing for fair comparison between constituencies.
- Interactive Features: The map displays individual pub locations when zoomed in sufficiently and includes a 'Rankings table' that allows users to view constituencies by highest or lowest pub density, navigate results in groups, and directly jump to any constituency on the map.
This project serves as an excellent example of how public datasets can be combined and visualized to offer interesting and accessible insights into local demographics and amenities. It's a testament to practical data analysis applied to a culturally significant aspect of British life.