NHacker Next
  • new
  • past
  • show
  • ask
  • show
  • jobs
  • submit
Nearest Pint (knowwhereconsulting.co.uk)
stevenfeldman 22 hours ago [-]
Hi I built the pub density map.

I think the data from FHRS is more comprehensive than on OSM as it covers bars, clubs etc. If you have an alcohol license you appear in the FHRS data

I know there have been some access issues today, I think it is down to Cloudflare changing its bot protection.

The app is to compare pub density in your area, it doesn't have a search facility - there are loads of alternatives to search for a pub.

Syzygies 21 hours ago [-]
Pub tourism is one of my favorite ways to spend a day in London. The pub "density" isn't all it's cracked up to be. To be able to make it to the next pub for a bathroom (and to preserve my ability to walk) I've found half pints to be ideal. Ideally, accompanied here and there by pub food.

Bar staff don't universally view half pint orders with respect.

luxpir 5 hours ago [-]
Apparently not all 8 year old daughters view half pint orders with respect either. It didn't help it was served in one of those mini pint glasses but she ripped me for getting a "tiny lager" while my partner enjoyed a pint. I wasn't aware we'd passed on anything about drinking culture to her yet, but it seems to start early!
northernsausage 1 days ago [-]
Its only 9am in the UK and the demand means its has already serving a 520.
rob74 24 hours ago [-]
> UK Pub Density by Parliamentary Constituency

Technically, this is only the pub density in Great Britain - the UK is "The United Kingdom of Great Britain and Northern Ireland", and Northern Ireland is not covered, so...

wrboyce 1 days ago [-]
Hmm, this dataset is pretty poor. There are at least 3 pubs near me that are missing.
NoboruWataya 1 days ago [-]
Why use FHRS as the source rather than OSM? OSM isn't perfect either but for my area at least it seems a lot more comprehensive.
bean469 21 hours ago [-]
Northern Ireland is not covered despite being part of the UK
jrflo 1 days ago [-]
Really surprising that Inverness and Skye have only 16 pubs considering how much tourism the area has. I felt like it wasn't lacking for pubs but maybe I saw all 16...
wetbaby 1 days ago [-]
A good third of the pubs are missing in my town tbh and they're definitely still open.
CiaranMcNulty 1 days ago [-]
It looks like the data is from OpenStreetMap so maybe you could add them if they’re missing there?
n4r9 1 days ago [-]
If you click the question mark it has:

> Pub data is sourced from the Food Hygiene Rating Service (FHRS) via GetTheData Open Pubs

https://www.getthedata.com/open-pubs

MrDOS 1 days ago [-]
Ah, interesting. Searching the dataset for my local area, this seems to include some restaurants, but omits hotels entirely. That's skewing the numbers downward tremendously.
1 days ago [-]
2b3a51 1 days ago [-]
Which explains why Spearmint Rhino is listed in Birmingham (hint: you might get a surprise popping in that establishment for a quick pint).

So nice interface and all but some data curation will be needed - perhaps on a crowd sourced basis? Click and add comment &c.

flir 1 days ago [-]
I thought about doing something similar pre-Covid. There are commercial datasets that are more complete (Local Data Company was the one I targeted when I was researching), but... well... £000's a quarter.

The project would have had to cover its costs, so the idea went to the great backlog in the sky.

mojo74 1 days ago [-]
I would argue it's your civic duty :)
BoxOfRain 1 days ago [-]
Yeah I'm dogsitting at my childhood home right now and it's missing the rural pubs on the dog route.
pelagicAustral 1 days ago [-]
I was in Inverness a few weeks ago, seems like the tourist season is on, and it was fairly hard to find a pub other than downtown. The other interesting thing is that a lot of them don't seem to not go by the advertised opening times, which later on made total sense based on what an old man told me about the Highlands having their own time.
lostlogin 1 days ago [-]
There were about as many golf courses as pubs when I went through there - but that was a while back.
toolslive 1 days ago [-]
OK, I think this will be close to an all time record: Leopoldsburg (Belgium, 14k inhabitants) had more than 150 pubs in the 1980s.
flir 1 days ago [-]
I make that 933:1? Portsmouth (Navy/dockyard town) had 115:1 in the 1860s. (822 pubs and beerhouses against a population of 95k). There was a row of five pubs right outside the dockyard gate.

I see Leopoldsburg had a large military camp nearby. Same story?

falcor84 1 days ago [-]
You're off by a factor of 10: 14k/150 is ~93 residents per pub.
flir 21 hours ago [-]
Thanks. Early morning posting. Bet I read "140k".
kaelyx 1 days ago [-]
Im surprised Newcastle upon Tyne isn't higher on this map. I guess its Density of housing near the center dilutes the ratio
toolslive 1 days ago [-]
yup. soldiers in dire need of a drink
martinclayton 24 hours ago [-]
Dataset does seem sketchy. My village has two pubs, neither appear. Two non-pub licensed locations (social club, stately home) do appear. The dot for the pub in the next village is off by about 100m.
wodenokoto 1 days ago [-]
I can't find a single pub using this page, let alone the nearest to me.
purplemoonx 21 hours ago [-]
"Checking your browser..." See ya!
spidermonkey23 21 hours ago [-]
seems like Edinburgh beats Glasgow for the no 5 spot,I guess they have the Fringe to thank
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact
Rendered at 10:54:06 GMT+0000 (Coordinated Universal Time) with Vercel.