query-2a52d801aeafdaf0e86672be57659f9a
Number of persons by QID using P735 TODO
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#defaultView:LineChart
# number of persons per QID (using P735=Q4925477)
# by Jura1, 2017-08-27
SELECT ?n (COUNT(?item)*72 as ?ct)
{
?item wdt:P735 wd:Q4925477 ; wdt:P31 wd:Q5 .
BIND(ROUND(xsd:integer(strafter(str(?item),"y/Q"))/1000000) as ?n)
}
GROUP BY ?n
Query found at
- https://www.wikidata.org/wiki/User:Charles_Matthews/Queries
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Names/lists
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?_anon_42b5416610844a34809f33a099ae9de132976"):::projected
v4("?ct")
v1("?item")
v2("?n"):::projected
c2(["wd:Q4925477"]):::iri
c4(["wd:Q5"]):::iri
v1 --"wdt:P735"--> c2
v1 --"wdt:P31"--> c4
bind0[/"numeric-round(http://www.w3.org/2001/XMLSchema#integer(substring-after(str(?item),'y/Q')) / '1000000^^xsd:integer')"/]
v1 --o bind0
bind0 --as--o v2
bind2[/"count(?item)"/]
v1 --o bind2
bind2 --as--o v3
bind3[/" * '72^^xsd:integer'"/]
null --o bind3
bind3 --as--o v4