query-be6f93ba35aeb3b8f0a65bdf367accb5

rq turtle/ttl

Propertiesmain subject (P921)quantity (P1114)point in time (P585)

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/>
# Horizontal axis: dates when Wikidata reached some milestone in item numbers
# Vertical axis: number of items for publications about the Zika virus
# adapted from https://www.wikidata.org/w/index.php?oldid=957875282#Query_for_approximate_creation_dates_of_a_series_of_items

#defaultView:AreaChart
SELECT ?date ?cumulativecount 
{

    {   SELECT ?milestonep (COUNT(?item) as ?cumulativecount)
        WHERE
        {
          { SELECT ?item { ?item wdt:P921 wd:Q202864 .}  LIMIT 100000 }
          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:Q202864"]):::iri f0[["?milestone > ?qid"]] f0 --> v1 f0 --> v4 v3 --"p:direct/P921"--> 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