The Crown, Bristol (Q7728222)

  • matcher place: City of Bristol (relation 57539), Cabot Ward (relation 1517923), Bristol (relation 5746665), Bristol (relation 6103050)
  • view on Wikidata
  • Wikipedia: English
  • Wikimedia Commons
  • English Wikipedia categories: 1606 establishments in England, Bristol building and structure stubs, Buildings and structures completed in 1606, Grade II listed pubs in Bristol, Music venues in Bristol, Pub stubs
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,51.45660,-2.59265)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45660,-2.59265)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45660,-2.59265)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.45660,-2.59265)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45660,-2.59265)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45660,-2.59265)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.45660,-2.59265)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45660,-2.59265)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45660,-2.59265)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.45660,-2.59265)["amenity"="concert_hall"][name];
    way(around:1000,51.45660,-2.59265)["amenity"="concert_hall"][name];
    rel(around:1000,51.45660,-2.59265)["amenity"="concert_hall"][name];
    node(around:1000,51.45660,-2.59265)["amenity"="music_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45660,-2.59265)["amenity"="music_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45660,-2.59265)["amenity"="music_venue"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.45660,-2.59265)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45660,-2.59265)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45660,-2.59265)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.45660,-2.59265)[amenity=pub][name];
    way(around:1000,51.45660,-2.59265)[amenity=pub][name];
    rel(around:1000,51.45660,-2.59265)[amenity=pub][name];
    node(around:1000,51.45660,-2.59265)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45660,-2.59265)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45660,-2.59265)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,51.45660,-2.59265)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,51.45660,-2.59265)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,51.45660,-2.59265)["listed_status"="Grade_II"][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

The Crown is a historic pub in Bristol, England, near to St Nicholas Market, an area known as "the Old City". The Crown was built in the 18th century and is a Grade II listed building.

Wikidata location: 51.4566, -2.5926 view on OSM or edit on OSM

matches

login to upload wikidata tags

no matches found

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
building (Q41176) building=yes, building
commercial building (Q655686) building=commercial

Search criteria from categories

Grade II listed pubs in Bristol amenity=bar, amenity=restaurant, building=pub, amenity=nightclub, amenity=pub
Music venues in Bristol amenity=concert_hall, amenity=nightclub, amenity=pub, amenity=restaurant, amenity=music_venue