query-74d51321f03e299680339e7d1181511c
title:counts of century of birth for P9114 people select ?century (count(?item) as ?count) WHERE { ?item wdt:P9114 ?id . ?item wdt:P569 ?birth . bind(year(?birth)-1 as ?year) filter(bound(?year)) bind (floor(?year/100) as ?century) } group by ?century order by ?century
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
#title:counts of century of birth for P9114 people
select ?century (count(?item) as ?count) WHERE {
?item wdt:P9114 ?id .
?item wdt:P569 ?birth .
bind(year(?birth)-1 as ?year)
filter(bound(?year))
bind (floor(?year/100) as ?century)
} group by ?century order by ?century
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?birth")
v6("?century"):::projected
v6("?count")
v4("?id")
v3("?item"):::projected
v6("?year")
f0[["bound(?year)"]]
f0 --> v6
v3 --"wdt:P9114"--> v4
v3 --"wdt:P569"--> v5
bind1[/"year-from-dateTime(?birth) + '-1^^xsd:integer'"/]
v5 --o bind1
bind1 --as--o v6
bind2[/"numeric-floor(?year / '100^^xsd:integer')"/]
v6 --o bind2
bind2 --as--o v6
bind4[/"count(?item)"/]
v3 --o bind4
bind4 --as--o v6