query-cab1fcd619bda69e7e8b4565ba0f219e

rq turtle/ttl

  1. citation statistic for authors

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#defaultView:LineChart
SELECT ?year ?number_of_citations ?author_label WHERE {
  {
    SELECT ?year ?number_of_citations ?author ?author_label_
    WHERE {
      {
        SELECT ?author ?year (COUNT(?citing_work) AS ?number_of_citations) WHERE {

          VALUES ?author {   wd:Q4484888  wd:Q63809637  wd:Q63808847  wd:Q63759170    }
          ?work wdt:P50 ?author .
          ?work wdt:P577 ?publication_date .
          ?citing_work wdt:P2860 ?work
          BIND(STR(YEAR(?publication_date)) AS ?year)
        }
        GROUP BY ?author ?year 
      } 
      ?author rdfs:label ?author_label_ .
      FILTER (LANG(?author_label_) = 'en')
    }
  }
  # Represent the author by name and Q identifier
  BIND (CONCAT(?author_label_, " (", SUBSTR(STR(?author), 32), ")") AS ?author_label)
}
ORDER BY ?year

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?author") v8("?author_label"):::projected v2("?author_label_") v6("?citing_work") v7("?number_of_citations"):::projected v5("?publication_date") v4("?work") v7("?year"):::projected f0[["?author_label_ = 'en'"]] f0 --> v2 bind1[/VALUES ?author/] bind1-->v3 bind10(["wd:Q4484888"]) bind10 --> bind1 bind11(["wd:Q63809637"]) bind11 --> bind1 bind12(["wd:Q63808847"]) bind12 --> bind1 bind13(["wd:Q63759170"]) bind13 --> bind1 v4 --"wdt:P50"--> v3 v4 --"wdt:P577"--> v5 v6 --"wdt:P2860"--> v4 bind2[/"str(year-from-dateTime(?publication_date))"/] v5 --o bind2 bind2 --as--o v7 bind4[/"count(?citing_work)"/] v6 --o bind4 bind4 --as--o v7 v3 --"rdfs:label"--> v2 bind5[/"concat(?author_label_,' (',substring(str(?author),'32^^xsd:integer'),')')"/] v2 --o bind5 v3 --o bind5 bind5 --as--o v8