query-f6b412461f8e6f40d80140dd5d88b4be
Latest additions of specific properties to a set of itemsIn the context of getting an idea of how up to date the data behind a Scholia page is, I would like to identify items within that context where statements involving specific properties have been recently added or edited. I got as far as getting the list of recently changed items within a corpus:
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?item ?title ?date_modified 
WHERE
{
    ?item wdt:P921 wd:Q202864 ; wdt:P1476 ?title ;
          schema:dateModified ?date_modified .
    BIND (now() - ?date_modified as ?date_range)
    FILTER (?date_range < 14)
}
ORDER BY ASC(?date_range)
LIMIT 200
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v4("?date_modified"):::projected 
  v5("?date_range")
  v2("?item"):::projected 
  v3("?title"):::projected 
  c3(["wd:Q202864"]):::iri 
  f0[["?date_range < '14^^xsd:integer'"]]
  f0 --> v5
  v2 --"wdt:P921"-->  c3
  v2 --"wdt:P1476"-->  v3
  v2 --"schema:dateModified"-->  v4
  bind1[/"NOW() - ?date_modified"/]
  v4 --o bind1
  bind1 --as--o v5