query-eed7b30eafe24710f2a9d5fdddbdf4b1

Propertiespart of (P361)location (P276)number of cases (P1603)

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#>
#defaultView:BarChart
SELECT (MAX(?cases) AS ?casenow) ?cityLabel WHERE {
  ?cd wdt:P361 wd:Q87343682.
  ?cd wdt:P276 ?city.
  ?city rdfs:label ?cityLabel.
  FILTER(LANG(?cityLabel)="en")
  ?cd wdt:P1603 ?cases.
  }
GROUP BY ?cityLabel

Query found at

https://www.wikidata.org/wiki/Wikidata:WikiProject_COVID-19/Queries/SPARQL_Study

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?casenow") v4("?cases"):::projected v2("?cd") v3("?city") v1("?cityLabel"):::projected c3(["wd:Q87343682"]):::iri f0[["?cityLabel = 'en'"]] f0 --> v1 v2 --"wdt:P361"--> c3 v2 --"wdt:P276"--> v3 v3 --"rdfs:label"--> v1 v2 --"wdt:P1603"--> v4 bind2[/"max(?cases)"/] v4 --o bind2 bind2 --as--o v5