query-e41f775bbf5733e8eda0364fe9a3fc4d

rq turtle/ttl

Most cited authors

PREFIX target: http://www.wikidata.org/entity/Q2779854

SELECT ?count ?author ?authorLabel ?orcid ?example_cited_work ?example_cited_workLabel ?example_citing_work ?example_citing_workLabel WITH { # Count the number of citations SELECT ?author (COUNT(?cited_work) AS ?count) (SAMPLE(?cited_work) AS ?example_cited_work) (SAMPLE(?citing_work) AS ?example_citing_work) WHERE { ?cited_work wdt:P1433 target: . ?citing_work wdt:P2860 ?cited_work . ?cited_work wdt:P50 ?author . } GROUP BY ?author } AS %result WHERE { INCLUDE %result

# Include optional ORCID iD OPTIONAL { ?author wdt:P496 ?orcid . }

# Label the results SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } } ORDER BY DESC(?count) LIMIT 50

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Most cited authors

PREFIX target: <http://www.wikidata.org/entity/Q2779854>

SELECT
  ?count
  ?author ?authorLabel
  ?orcid
  ?example_cited_work ?example_cited_workLabel
  ?example_citing_work ?example_citing_workLabel
WHERE {
   {
  # Count the number of citations
  SELECT
    ?author
    (COUNT(?cited_work) AS ?count)
    (SAMPLE(?cited_work) AS ?example_cited_work)
    (SAMPLE(?citing_work) AS ?example_citing_work)
  WHERE {
    ?cited_work wdt:P1433 target: .
    ?citing_work wdt:P2860 ?cited_work .
    ?cited_work wdt:P50 ?author .
  }
  GROUP BY ?author
}

  # Include optional ORCID iD
  OPTIONAL { ?author wdt:P496 ?orcid . }

  # Label the results
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } 
}
ORDER BY DESC(?count)
LIMIT 50

Query found at

• https://www.wikidata.org/wiki/User:Will_(Wiki_Ed)/APS_Project_Page/Queries