query-374d19b470995f03ae612f3b95cc4f4b

rq turtle/ttl

what on earth happened to MPs who died in office? Here, 1854... SELECT ?mp ?mpLabel ?died ?mannerLabel ?causeLabel ?casualtyLabel ?placeLabel WHERE { ?membership wdt:P279 wd:Q16707842 . # all UK MPs ?mp p:P39 ?positionStatement . ?positionStatement ps:P39 ?membership . ?positionStatement pq:P1534 wd:Q5247364 . # ie only those coded as end cause: death in office ?mp wdt:P570 ?died . optional { ?mp wdt:P509 ?cause . } optional { ?mp wdt:P1196 ?manner . } optional { ?mp wdt:P1347 ?casualty . } # military deaths are coded strangely optional { ?mp wdt:P20 ?place . } FILTER (?died >= "1854-01-01T00:00:00Z"^^xsd:dateTime) . FILTER (?died <= "1854-12-31T00:00:00Z"^^xsd:dateTime) . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
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#>
# what on earth happened to MPs who died in office? Here, 1854...
SELECT ?mp ?mpLabel ?died ?mannerLabel ?causeLabel ?casualtyLabel ?placeLabel
WHERE {
    ?membership wdt:P279 wd:Q16707842 . # all UK MPs
    ?mp p:P39 ?positionStatement .  ?positionStatement ps:P39 ?membership . 
    ?positionStatement pq:P1534 wd:Q5247364 .  # ie only those coded as end cause: death in office
    ?mp wdt:P570 ?died .
    optional { ?mp wdt:P509 ?cause . }
    optional { ?mp wdt:P1196 ?manner . }
    optional { ?mp wdt:P1347 ?casualty . } # military deaths are coded strangely
    optional { ?mp wdt:P20 ?place . }
  FILTER (?died >= "1854-01-01T00:00:00Z"^^xsd:dateTime) . 
  FILTER (?died <= "1854-12-31T00:00:00Z"^^xsd:dateTime) .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?casualty") v5("?cause") v1("?died"):::projected v6("?manner") v2("?membership") v3("?mp"):::projected v8("?place") v4("?positionStatement") c4(["wd:Q16707842"]):::iri c8(["wd:Q5247364"]):::iri c15(["bd:serviceParam"]):::iri c17(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["?died <= '1854-12-31T00:00:00Z^^xsd:dateTime'"]] f0 --> v1 f1[["?died >= '1854-01-01T00:00:00Z^^xsd:dateTime'"]] f1 --> v1 v2 --"p:direct/P279"--> c4 v3 --"p:P39"--> v4 v4 --"p:statement/P39"--> v2 v4 --"p:qualifier/P1534"--> c8 v3 --"p:direct/P570"--> v1 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P509".-> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P1196".-> v6 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P1347".-> v7 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P20".-> v8 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c15 --"wikibase:language"--> c17 end