query-0ec603058aa778c402e4be2ebb10f77e
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
- 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/>
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