George and Devonshire (Q15978995)

  • matcher place: London Borough of Hounslow (relation 51848), London (relation 65606)
  • view on Wikidata
  • Wikipedia: English, Portuguese
  • Wikimedia Commons
  • English Wikipedia categories: Buildings and structures in Chiswick, Grade II listed buildings in the London Borough of Hounslow, Grade II listed pubs in London, Pubs in the London Borough of Hounslow
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,51.48636,-0.25214)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.48636,-0.25214)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.48636,-0.25214)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.48636,-0.25214)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.48636,-0.25214)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.48636,-0.25214)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.48636,-0.25214)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.48636,-0.25214)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.48636,-0.25214)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.48636,-0.25214)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.48636,-0.25214)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.48636,-0.25214)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.48636,-0.25214)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.48636,-0.25214)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.48636,-0.25214)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.48636,-0.25214)[amenity=pub][name];
    way(around:1000,51.48636,-0.25214)[amenity=pub][name];
    rel(around:1000,51.48636,-0.25214)[amenity=pub][name];
    node(around:1000,51.48636,-0.25214)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.48636,-0.25214)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.48636,-0.25214)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.48636,-0.25214)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.48636,-0.25214)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.48636,-0.25214)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

The George and Devonshire is a Grade II listed public house at Burlington Lane, Chiswick, London. It was built in the 18th century, but the architect is not known. The pub claims that it dates back to 1650.

Wikidata location: 51.4864, -0.2521 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

node: George and Devonshire (house name: The George & Devonshire) (OSM), 15 metres from Wikidata [show tags]
name: George and Devonshire
brand: Fuller's
email: georgeanddevonshire@gmail.com
phone: +44 20 8742 7342
amenity: pub
toilets: yes
website: https://www.georgeanddevonshire.co.uk/
operator: Fuller's
real_ale: yes
wikidata: Q15978995
addr:city: London
addr:street: Burlington Lane
description: Dating back to 1650, the George & Devonshire in Chiswick serves up a slice of history alongside its fabulous food and drink
survey:date: 2023-04-06
currency:GBP: yes
currency:XBT: yes
addr:postcode: W4 2QE
addr:housename: The George & Devonshire
brand:wikidata: Q5253950
toilets:access: customers
internet_access: wlan
payment:onchain: yes
addr:housenumber: 8
payment:lightning: yes
internet_access:fee: no
check_date:currency:XBT: 2024-04-07
payment:lightning_contactless: yes

wikidata match: Q15978995

Search criteria from Wikidata

view with query.wikidata.org

Grade II listed building (Q15700834) listed_status=Grade_II
bar (Q187456) bar, amenity=bar
pub (Q212198) amenity=pub
shop (Q213441) shop, shop=yes
building (Q41176) building=yes, building
commercial building (Q655686) building=commercial

Search criteria from categories

Grade II listed pubs in London amenity=pub, amenity=bar, amenity=nightclub, amenity=restaurant, building=pub
Pubs in the London Borough of Hounslow amenity=pub, amenity=bar, amenity=nightclub, amenity=restaurant, building=pub