query-832a6a2814dc31eff112da3a7e7b9c22

rq turtle/ttl

Average number of children per year Average number of children per year Average number of children per year Average number of children per year Average number of children per year Nombre moyen d'enfants par année Average number of children per year Average number of children per year Average number of children per year 年ごとの子供の平均数 Gemiddeld aantal kinderen per jaar Average number of children per year Genomsnittliga antalet barn varje år Average number of children per year Average number of children per year Average number of children per year

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/>
#defaultView:LineChart
SELECT ?yearstr (AVG( ?_number_of_children ) AS ?count) WHERE {
  ?item wdt:P31 wd:Q5.
  ?item wdt:P1971 ?_number_of_children.
  ?item p:P569/psv:P569 [
                wikibase:timePrecision ?precision ;
                wikibase:timeValue ?_date_of_birth ;
              ] .
  FILTER( ?_number_of_children >= 0 )
  FILTER( ?precision >= "10"^^xsd:integer ) # precision of at least year
  FILTER( ?year > 1900 )
  BIND( year(?_date_of_birth) as ?year ).
  BIND( str(?year) AS ?yearstr ).
} GROUP BY ?yearstr

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?_date_of_birth") v3("?_number_of_children"):::projected v7("?count") v4("?item") v2("?precision") v6("?year") v6("?yearstr"):::projected a2((" ")) a1((" ")) c5(["wd:Q5"]):::iri f0[["?year > '1900^^xsd:integer'"]] f0 --> v6 f1[["?precision >= '10^^xsd:integer'"]] f1 --> v2 f2[["?_number_of_children >= '0^^xsd:integer'"]] f2 --> v3 v4 --"p:direct/P31"--> c5 v4 --"p:direct/P1971"--> v3 a1 --"wikibase:timePrecision"--> v2 a1 --"wikibase:timeValue"--> v5 v4 --"p:P569"--> a2 a2 --"p:statement/value/P569"--> a1 bind3[/"year-from-dateTime(?_date_of_birth)"/] v5 --o bind3 bind3 --as--o v6 bind4[/"str(?year)"/] v6 --o bind4 bind4 --as--o v6 bind6[/"average(?_number_of_children)"/] v3 --o bind6 bind6 --as--o v7