query-3fab4fa330016ecb18f1d281be10ef1d

rq turtle/ttl

  1. Get citation statistic by years for the authors

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:BarChart
SELECT  ?year (count(?citing_work) as ?count)
WHERE {
   {
  SELECT DISTINCT ?work WHERE {
    VALUES ?authors { wd:Q63809637 wd:Q4484888 wd:Q63759170 wd:Q63808847 }
    ?work wdt:P50 ?authors.
  }
}  ?citing_work wdt:P2860 ?work.
  ?citing_work wdt:P577 ?date.
  BIND(str(YEAR(?date)) AS ?year)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?year 
ORDER BY DESC(?year)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?authors") v4("?citing_work"):::projected v6("?count") v5("?date") v3("?work") v6("?year"):::projected c5(["bd:serviceParam"]):::iri c7(["#91;AUTO_LANGUAGE#93;,en"]):::literal bind0[/VALUES ?authors/] bind0-->v2 bind00(["wd:Q63809637"]) bind00 --> bind0 bind01(["wd:Q4484888"]) bind01 --> bind0 bind02(["wd:Q63759170"]) bind02 --> bind0 bind03(["wd:Q63808847"]) bind03 --> bind0 v3 --"wdt:P50"--> v2 v4 --"wdt:P2860"--> v3 v4 --"wdt:P577"--> v5 bind1[/"str(year-from-dateTime(?date))"/] v5 --o bind1 bind1 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c5 --"wikibase:language"--> c7 end bind3[/"count(?citing_work)"/] v4 --o bind3 bind3 --as--o v6