query-5ea0e580ec49b3ead0eac8eff633e24a

rq turtle/ttl

21:10, 11 June 2017 (UTC)) talk (Oravrattas entries. --(P1365)replaces I've added all the missing constituency, party, and gender info, and am slowly working through the missing 21:45, 11 June 2017 (UTC)) talk (Oravrattas who returned after an absence. I've cleaned up his history now, which should take care of that --(Q479188)Chris Ruane Looks like it's 21:24, 11 June 2017 (UTC)) talk (Andrew Gray. I wonder who the extra one is? apparently 87 new MPs this yearNice! I'll keep plugging away at getting valid P39s for the returning 2017 members. One thing that strikes me is that you have 88 names in that report - there were being set to something that isn't a UK constituency: (P768)electoral district Another useful one to catch the Invalid Constituencies: (Q27971968)constituency of the House of Commons set to something that isn't a (P768)electoral district A simple query to find MPs in the new Parliament who have their

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?constituencyLabel ?cisaLabel ?cisa {
  ?item p:P39 [ ps:P39 wd:Q16707842; pq:P2937 wd:Q29974940 ; pq:P768 ?constituency  ] .
  ?constituency wdt:P31 ?cisa FILTER NOT EXISTS { ?constituency wdt:P31 wd:Q27971968 } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?cisa"):::projected v1("?constituency") v2("?item"):::projected a1((" ")) c10(["bd:serviceParam"]):::iri c4(["wd:Q16707842"]):::iri c2(["wd:Q27971968"]):::iri c12(["en"]):::literal c6(["wd:Q29974940"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"p:direct/P31"--> e0c2 e0v1("?constituency"):::projected e0c2(["wd:Q27971968"]):::iri end f0--EXISTS--> f0e0 f0 --> v1 f0 --> c1 f0 --> c2 v1 --"p:direct/P31"--> c2 a1 --"p:statement/P39"--> c4 a1 --"p:qualifier/P2937"--> c6 a1 --"p:qualifier/P768"--> v1 v2 --"p:P39"--> a1 v1 --"p:direct/P31"--> v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c10 --"wikibase:language"--> c12 end