query-b8188415ea45d40e7bca2068c68416ca
Propertiespart of (P361)location (P276)case fatality rate (P3457)number of cases (P1603)point in time (P585)
Use at
- https://query.wikidata.org/sparql
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#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#defaultView:BarChart
SELECT ?cases ?mortality_rate ?country WHERE {
{
SELECT ?x (MAX(?d) AS ?date) WHERE {
?x p:P3457 [ps:P3457 ?m; pq:P585 ?d].
?x wdt:P361 wd:Q83741704.
}
GROUP BY ?x
}
?x p:P1603 [ps:P1603 ?cases; pq:P585 ?date].
?x p:P3457 [ps:P3457 ?mortality_rate; pq:P585 ?date].
FILTER(?cases < 50000)
FILTER(?mortality_rate < 1)
?x wdt:P276 ?c.
?c rdfs:label ?country.
FILTER(LANG(?country)="en")
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v8("?c")
v3("?cases"):::projected
v1("?country"):::projected
v5("?d")
v7("?date")
v4("?m")
v2("?mortality_rate"):::projected
v6("?x")
a1((" "))
a2((" "))
a3((" "))
c8(["wd:Q83741704"]):::iri
f0[["?country = 'en'"]]
f0 --> v1
f1[["?mortality_rate < '1^^xsd:integer'"]]
f1 --> v2
f2[["?cases < '50000^^xsd:integer'"]]
f2 --> v3
a1 --"p:statement/P3457"--> v4
a1 --"p:qualifier/P585"--> v5
v6 --"p:P3457"--> a1
v6 --"p:direct/P361"--> c8
bind4[/"max(?d)"/]
v5 --o bind4
bind4 --as--o v7
a2 --"p:statement/P1603"--> v3
a2 --"p:qualifier/P585"--> v7
v6 --"p:P1603"--> a2
a3 --"p:statement/P3457"--> v2
a3 --"p:qualifier/P585"--> v7
v6 --"p:P3457"--> a3
v6 --"p:direct/P276"--> v8
v8 --"rdfs:label"--> v1