query-844ad07146a15f776dfa4dbe8a411b85
Unknown Members of Parliament. Wikidata:EveryPolitician/Report:National Legislatures/membership itemsThere are more and more elements where citizenship is not filled in, and only the general element Q486839 is given for the position, even though parliamentarians of quite a few countries also have a specific element: I created a query that shows these elements, but also the place of birth and the time of birth, so that it would be easier to search for those persons for whom the citizenship and the country-specific member of parliament element could be indicated. In addition to the English names, there are remarkably many German and Czech/Slovak names in the list.
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?place ?placeLabel ?born WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
?item wdt:P39 wd:Q486839.
MINUS { ?item wdt:P27 _:b1. }
OPTIONAL { ?item wdt:P19 ?place. }
OPTIONAL { ?item wdt:P569 ?born. }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?born"):::projected
v1("?item"):::projected
v2("?place"):::projected
a1((" "))
c2(["bd:serviceParam"]):::iri
c4(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c6(["wd:Q486839"]):::iri
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c2 --"wikibase:language"--> c4
end
v1 --"wdt:P39"--> c6
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P27"--> a1
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P19".-> v2
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P569".-> v3
end