7,354
edits
Project:SPARQL/examples: Difference between revisions
→People not in London linked as a graph by a NUTS region or country (excluding England) at which they were once resident in the UK
| Line 230: | Line 230: | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# People not in London linked as a graph by a NUTS region or country (excluding England) at which they were once resident in the UK | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
| Line 242: | Line 244: | ||
WHERE { | WHERE { | ||
?resident bnwdt:P29 ?residence . | ?resident bnwdt:P29 ?residence . | ||
FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q39 .} | FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2035 .} | ||
FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2036 .} | |||
FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2037 .} | |||
FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2038 .} | |||
FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2039 .} | |||
FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2040 .} | |||
FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2041 .} | |||
FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2042 .} | |||
FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q39.} | |||
FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2534.} | |||
?residence bnwdt:P33 ?district . | ?residence bnwdt:P33 ?district . | ||
?district bnwdt:P33 ?county . | ?district bnwdt:P33 ?county . | ||