query-6a3f6b74e136874ef0e18325008cce64

rq turtle/ttl

Graph of the number of MPs who died in office by year

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 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#>
# How many MPs died in office, each year 1832-date?
# Data pre-WW2 is still a bit flaky on exact death dates,
# probably a bit more reliable after that

SELECT ?year ?diedcount
#defaultView:BarChart

WHERE {
   {
  # count of MPs who died in office in each parliament
  SELECT ?year (COUNT(DISTINCT ?mp) AS ?died) 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 .
    BIND(STR(YEAR(?died)) AS ?year)
  }
  GROUP BY ?year
}  BIND(?died AS ?diedcount)
  # add labels
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?year

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_British_Politicians/Sample_Queries