# Pubs in London

Discover London's best pubs effortlessly — automated insights for unmatched nightlife experiences

Archived sample configuration. Sample data is illustrative, not live data.

Build this in Jsonify: https://factory.jsonify.com/setup?q=Pubs+in+London

## Goal

Pubs in London

## Sources

- yelp.co.uk

- tripadvisor.co.uk

- designmynight.com

- pubs.com

- timeouts.com

- camra.org.uk

- londonpubs.co.uk

- beeradvocate.com

- just-eat.co.uk

- deliveroo.co.uk

- google.com

## Sample data

id | Source | Pub Name | Address | Rating | Reviews | Beer Selection | Price Range | Last Updated | Status Badge

1 | yelp.co.uk | The Crown & Two Dogs | 17 St John St, Clerkenwell, London EC1M 4NX | 4.4 | 312 | 12 real ales, 6 craft taps | ££ | 2026-01-06 | Open now

2 | tripadvisor.co.uk | The Old Red Cow | 71-72 Great Eastern St, Shoreditch, London EC2A 3HN | 4.0 | 489 |  |  | 2026-01-07 | Popular

3 | designmynight.com | The Fox & Anchor | 115 Charterhouse St, Farringdon, London EC1M 6AP |  |  |  |  | 2026-01-05 | Booking recommended

4 | pubs.com | The George Inn | 77 Borough High St, Southwark, London SE1 1NH | 4.6 | 1,204 |  |  | 2026-01-04 | Historic

5 | timeouts.com | The Spaniards Inn | Spaniards Rd, Hampstead, London NW3 7JJ | 4.5 | 2,130 |  |  | 2026-01-07 | Top pick

6 | camra.org.uk | The Hop Poles | 22 Clapton Common, Hackney, London E5 0PD |  |  |  |  | 2026-01-06 | Real Ale

7 | londonpubs.co.uk | The Mayflower | 117 Rotherhithe St, Rotherhithe, London SE16 4NF |  |  |  |  | 2026-01-08 | Open now

8 | beeradvocate.com | The Barrel Vaults | 44-48 Bermondsey St, Bermondsey, London SE1 3UD |  |  |  |  | 2026-01-06 | New taps added

9 | just-eat.co.uk |  | 58 Newington Green Rd, Stoke Newington, London N1 4QH |  |  |  |  | 2026-01-07 | Delivery

10 | deliveroo.co.uk |  | 16 Brecon Rd, Southwark, London SE17 1BU |  |  |  |  | 2026-01-08 | Promoted

11 | google.com | The Churchill Arms | 119 Kensington Church St, Kensington, London W8 7LN | 4.3 | 8,920 |  |  | 2026-01-07 | Very popular

12 | yelp.co.uk | The Southampton Arms | 139 Highgate Rd, Kentish Town, London NW5 1NR | 4.7 | 876 |  |  | 2026-01-05 | CAMRA favourite

13 | tripadvisor.co.uk | The Nelson | 38 Cavendish Rd, Tulse Hill, London SW2 2EU | 4.2 | 154 |  |  | 2026-01-06 | Good value

14 | designmynight.com | The Latchmere | 455 Battersea Park Rd, Battersea, London SW11 4NJ |  |  |  |  | 2026-01-07 | Late licence

15 | pubs.com | The Flask | 14 Flask Walk, Hampstead, London NW3 1HH | 4.5 | 1,001 |  |  | 2026-01-08 | Reservations advised

16 | timeouts.com | The Lamb & Flag | 3 Rose St, Covent Garden, London WC2E 9ET | 4.1 | 2,045 |  |  | 2026-01-06 | Central

17 | camra.org.uk | The Magpie & Stump | Greenwich High Rd, Greenwich, London SE10 8JA |  |  |  |  | 2026-01-05 | Community pub

18 | londonpubs.co.uk | The Maypole Tavern | Morris Pl, Hoxton, London N1 5NF |  |  |  |  | 2026-01-07 | Happy hour

19 | beeradvocate.com | The Craft Beer Co. Clerkenwell | 10 St John's Square, Farringdon, London EC1M 4LR |  |  |  |  | 2026-01-08 | Taproom

20 | just-eat.co.uk |  | 10 Hillside, East Sheen, London SW14 8NP |  |  |  |  | 2026-01-06 | Collection only

21 | deliveroo.co.uk |  | Scotland Row, Hammersmith, London W6 9QQ |  |  |  |  | 2026-01-07 | Available

22 | google.com | The Grenadier | 18 Wilton Row, Belgravia, London SW1X 7NR | 4.2 | 4,321 |  |  | 2026-01-05 | Historic

23 | yelp.co.uk | The Wenlock Arms | 26 Wenlock Rd, Hoxton, London N1 7ST | 4.0 | 678 |  |  | 2026-01-06 | Local favourite

24 | tripadvisor.co.uk | The Spaniard's Retreat | Green Lanes, Stoke Newington, London N16 0JW | 3.9 | 98 |  |  | 2026-01-07 | Casual

25 | designmynight.com | The Pembury Tavern | 361A Hackney Rd, Shoreditch, London E2 8PP |  |  |  |  | 2026-01-08 | Family friendly

26 | pubs.com | The Victoria Tavern | 6-9 Bloomsbury St, Bloomsbury, London WC1B 3QE | 4.0 | 223 |  |  | 2026-01-06 | Brunch spot

27 | timeouts.com | Gordon's Wine Bar | 47 Villiers St, Charing Cross, London WC2N 6NE | 4.4 | 9,012 |  |  | 2026-01-07 | Iconic

28 | camra.org.uk | The Grapes | Clerkenwell Close, Farringdon, London EC1R 0HA |  |  |  |  | 2026-01-08 | Traditional ales

29 | londonpubs.co.uk | The Plough & Harrow | 1 Old Church St, Chelsea, London SW3 5BS |  |  |  |  | 2026-01-05 | Upscale pub

30 | beeradvocate.com | BrewDog Camden | 5 Jamestown Rd, Camden Town, London NW1 7BY |  |  |  |  | 2026-01-06 | Busy weekends

## Additional fields

## Dashboard widgets

- {"id": "1635165a", "size": "small", "type": "metric", "title": "Total Pubs Listed"}

- {"id": "a46bd6c0", "size": "small", "type": "metric", "title": "Average Rating Across Pubs"}

- {"id": "bc6106d9", "size": "medium", "type": "donut", "title": "Pub Types Distribution"}

- {"id": "ba1fd0ad", "size": "medium", "type": "bar", "title": "Top 10 Pubs by Rating"}

- {"id": "31e6713f", "size": "medium", "type": "horizontal_bar", "title": "Most Popular Pubs by Visits"}

- {"id": "32140c73", "size": "large", "type": "line", "title": "Monthly Rating Trend"}

- {"id": "745b913e", "size": "large", "type": "area", "title": "Total Reviews Over Time"}

- {"id": "a8899702", "size": "large", "type": "table", "title": "Recent Reviews of Pubs"}

- {"id": "bfdb9665", "size": "large", "type": "table", "title": "Pub Details and Locations"}

- {"id": "6f379ff9", "size": "medium", "type": "insights", "title": "Key Observations on Pub Trends"}

- {"id": "01c9d1d8", "size": "medium", "type": "pie", "title": "Customer Feedback Sources"}

- {"id": "0bcafe32", "size": "small", "type": "metric", "title": "Total Deliveries Available"}

## Alerts

- {"id": "new_listing", "icon": "bi-plus-circle-fill", "item": "The Crafty Fox", "title": "New Pub Detected", "source": "yelp.co.uk", "enabled": true, "send_to": "email", "severity": "success", "subtitle": "now listed on Yelp"}

- {"id": "menu_updated", "icon": "bi-tag-fill", "item": "The Old Red Lion", "title": "Menu Updated", "source": "designmynight.com", "enabled": false, "send_to": "slack", "severity": "info", "subtitle": "new beers added to the menu"}

- {"id": "price_change", "icon": "bi-tag-fill", "item": "Pint of Lager", "title": "Price Change Detected", "source": "just-eat.co.uk", "enabled": false, "send_to": "teams", "severity": "warning", "subtitle": "now £5.50 (+£0.50)"}

- {"id": "availability_change", "icon": "bi-exclamation-circle-fill", "item": "IPA Selection", "title": "Beer Selection Availability", "source": "deliveroo.co.uk", "enabled": false, "send_to": "webhook", "severity": "danger", "subtitle": "is currently unavailable"}

- {"id": "coverage_gap", "icon": "bi-shield-fill", "item": "Popular Pubs in North London", "title": "Coverage Gap Found", "source": "tripadvisor.co.uk", "enabled": false, "send_to": "email", "severity": "info", "subtitle": "missing from TripAdvisor"}

## Integrations

- api

- google-sheets

- email

- zapier