query-5d02aeb8dbae1b053b54dced1f06d8c2

rq turtle/ttl

Area chart - distribution vs years Area chart - distribution vs years of programming languages

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#defaultView:AreaChart
SELECT ?cid (str(SAMPLE(?year)) AS ?year )  (COUNT(*) AS ?count)  ?cause WHERE {
  ?pid wdt:P31/wdt:P279* wd:Q7397.
  ?pid wdt:P277 ?cid.

  OPTIONAL {
    ?cid rdfs:label ?cause.
    FILTER((LANG(?cause)) = "en")
  }

  ?pid wdt:P571 ?_date_of_death.
  BIND ( YEAR(?_date_of_death) AS ?year )
  FILTER( BOUND(?cause)  )
  FILTER( BOUND(?year)  )
  FILTER( ?year > 1900 )
}
GROUP BY ?cid ?cause ?year

Query found at