Holek
Joined 21 April 2013
Babel user information | ||||
---|---|---|---|---|
| ||||
Users by language |
A Wikipedian, contributing mostly to Polish Wikipedia
Example queries
editNumber of dead people by month since 2000
edit#defaultView:LineChart
SELECT ?yearmonth (COUNT(?person) as ?count)
WHERE
{
?person wdt:P31 wd:Q5;
p:P570/psv:P570 [
wikibase:timePrecision "10"^^xsd:integer ; # precision of at least month
wikibase:timeValue ?date ;
] .
BIND(CONCAT(STR(YEAR(?date)),"-",STR(MONTH(?date))) as ?yearmonth).
FILTER( ?date >= "2000-01-01T00:00:00"^^xsd:dateTime )
}
GROUP BY ?yearmonth