query-69d5d891d21cc7c4dae971db6782b5cc

rq turtle/ttl

Number of dead people by month since 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Počet zemřelých podle měsíců od roku 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Nombre mensuel de décès de personnes par mois depuis 2000 מספר האנשים שמתו לפי חודש מאז שנת 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Numero di morti per mese dal 2000 2000年以降の月別の死亡者した人物の数 Number of dead people by month since 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Aantal doden per maand sinds 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Antalet döda efter månad sedan 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 Number of dead people by month since 2000 2000年以来按月划分的死亡人数

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?yearmonth (COUNT(?person) as ?count)
WHERE
{
  ?person wdt:P31 wd:Q5;
          p:P570/psv:P570 [
                wikibase:timePrecision ?precision ;
                wikibase:timeValue ?date ;
              ] .
  BIND(CONCAT(STR(YEAR(?date)),"-",STR(MONTH(?date))) as ?yearmonth).
  FILTER( ?date >= "2000-01-01T00:00:00"^^xsd:dateTime )
  FILTER( ?precision >= "10"^^xsd:integer ) # precision of at least month
}
GROUP BY ?yearmonth

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?count") v2("?date") v3("?person"):::projected v1("?precision") v4("?yearmonth"):::projected a2((" ")) a1((" ")) c4(["wd:Q5"]):::iri f0[["?precision >= '10^^xsd:integer'"]] f0 --> v1 f1[["?date >= '2000-01-01T00:00:00^^xsd:dateTime'"]] f1 --> v2 v3 --"p:direct/P31"--> c4 a1 --"wikibase:timePrecision"--> v1 a1 --"wikibase:timeValue"--> v2 v3 --"p:P570"--> a2 a2 --"p:statement/value/P570"--> a1 bind2[/"concat(str(year-from-dateTime(?date)),'-',str(month-from-dateTime(?date)))"/] v2 --o bind2 bind2 --as--o v4 bind4[/"count(?person)"/] v3 --o bind4 bind4 --as--o v5