query-0ec603058aa778c402e4be2ebb10f77e

rq turtle/ttl

00:45, 7 June 2019 (UTC)) talk (99of9Thanks.--11:06, 10 June 2019 (UTC)) talk (99of9: Thanks for the link. Subscribed. Disappointingly long wait time! --Matěj Suchánek@ 07:13, 7 June 2019 (UTC)) talk (Matěj Suchánek. --this proposalNo, there's just 08:56, 7 June 2019 (UTC) Jura. --- [3]You could try to calculate approximate dates with

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#defaultView:AreaChart
SELECT ?date ?cumulativecount 
{

    {   SELECT ?milestonep (COUNT(?item) as ?cumulativecount)
        WHERE
        {
          { SELECT ?item { ?item wdt:P17 wd:Q408 }  LIMIT 190000 }
          BIND( xsd:integer( substr(str(?item), 33)) as ?qid)
          wd:Q38074555 p:P1114 ?milestonep .
          ?milestonep ps:P1114 ?milestone .
          FILTER( ?milestone > ?qid ) 
        }
        GROUP BY ?milestonep
    }          
    ?milestonep pq:P585 ?date
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?cumulativecount"):::projected v6("?date"):::projected v3("?item") v1("?milestone") v4("?milestonep") v4("?qid") c3(["wd:Q38074555"]):::iri c2(["wd:Q408"]):::iri f0[["?milestone > ?qid"]] f0 --> v1 f0 --> v4 v3 --"p:direct/P17"--> c2 bind1[/"http://www.w3.org/2001/XMLSchema#integer(substring(str(?item),'33^^xsd:integer'))"/] v3 --o bind1 bind1 --as--o v4 c3 --"p:P1114"--> v4 v4 --"p:statement/P1114"--> v1 bind3[/"count(?item)"/] v3 --o bind3 bind3 --as--o v5 v4 --"p:qualifier/P585"--> v6