Open main menu

Contents

SourceEdit

Dates are from Wikidata:News or edit history of item.

QueriesEdit

Query for milestone chart over timeEdit

#defaultView:LineChart
# by Jura1, 2017-08-28
SELECT ?date ?qid
{
  wd:Q38074555 p:P1114 [ ps:P1114 ?qid ; pq:P585 ?date ]
}

Try it!

Query for approximate creation dates of a series of itemsEdit

# by Jura1, 2019-06-08
# Number of items about Australia created at a given milestone
#defaultView:AreaChart
SELECT ?date ?cumulativecount 
{
    hint:Query hint:optimizer "None".
    {   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
}

Try it!

Neat idea! --Daniel Mietchen (talk) 03:55, 13 June 2019 (UTC)

DiscussionEdit

Return to "Q38074555" page.