query-4018d7f99f24c7df55c434e341d4cb14

rq turtle/ttl

Propertiesnumber of deaths (P1120)number of cases (P1603)point in time (P585)

Use at

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/>
#defaultView:LineChart
SELECT ?date ((?mort / ?cases) AS ?mortrate) WHERE {
  wd:Q87343682 wdt:P1120 ?mort.
  wd:Q87343682 p:P1120 ?stmort.
  ?stmort pq:P585 ?date.
  ?stmort ps:P1120 ?mort.
  wd:Q87343682 wdt:P1603 ?cases.
  wd:Q87343682 p:P1603 ?st.
  ?st pq:P585 ?date.
  ?st ps:P1603 ?cases.
  }
ORDER BY ?date

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?cases"):::projected v1("?date"):::projected v2("?mort"):::projected v6("?mortrate") v5("?st") v3("?stmort") c1(["wd:Q87343682"]):::iri c1 --"p:direct/P1120"--> v2 c1 --"p:P1120"--> v3 v3 --"p:qualifier/P585"--> v1 v3 --"p:statement/P1120"--> v2 c1 --"p:direct/P1603"--> v4 c1 --"p:P1603"--> v5 v5 --"p:qualifier/P585"--> v1 v5 --"p:statement/P1603"--> v4 bind0[/"?mort / ?cases"/] v2 --o bind0 v4 --o bind0 bind0 --as--o v6