query-1e648e89f3bbc5f8c8e28f425fa6f23a

rq turtle/ttl

Scientific authors known to Wikidata, who do not have an ORCID iD listed there SELECT ?author ?authorLabel ?instit ?institLabel ?count WHERE { { SELECT ?author (COUNT(DISTINCT ?publication) AS ?count) WHERE { ?publication wdt:P31 wd:Q13442814 . ?publication wdt:P50 ?author . MINUS { ?author wdt:P496 [] } . MINUS { ?author wdt:P570 ?dod . FILTER((YEAR(?dod)) < 2012) } . } GROUP BY ?author } . MINUS { ?author p:P108/ps:P108 ?instit1; p:P108/ps:P108 ?instit2 . FILTER(!SAMETERM(?instit1, ?instit2)) } . ?author wdt:P108 ?instit . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } . } ORDER BY DESC(?count)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Scientific authors known to Wikidata, who do not have an ORCID iD listed there
SELECT ?author ?authorLabel ?instit ?institLabel ?count WHERE {
  {
    SELECT ?author (COUNT(DISTINCT ?publication) AS ?count) WHERE {
      ?publication wdt:P31 wd:Q13442814 .
      ?publication wdt:P50 ?author .
      MINUS { ?author wdt:P496 [] } .
      MINUS {
        ?author wdt:P570 ?dod .
        FILTER((YEAR(?dod)) < 2012)
      } .
    } GROUP BY ?author
  } .
  MINUS {
    ?author p:P108/ps:P108 ?instit1;
            p:P108/ps:P108 ?instit2 .
    FILTER(!SAMETERM(?instit1, ?instit2))
  } .
  ?author wdt:P108 ?instit .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}
ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?author"):::projected v5("?count"):::projected v4("?dod") v7("?instit"):::projected v5("?instit1") v6("?instit2") v2("?publication") a1((" ")) a2((" ")) a3((" ")) c13(["en"]):::literal c2(["wd:Q13442814"]):::iri c11(["bd:serviceParam"]):::iri v2 --"p:direct/P31"--> c2 v2 --"p:direct/P50"--> v3 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v3 --"p:direct/P496"--> a1 end subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; f2[["year-from-dateTime(?dod) < '2012^^xsd:integer'"]] f2 --> v4 v3 --"p:direct/P570"--> v4 end bind4[/"count(?publication)"/] v2 --o bind4 bind4 --as--o v5 subgraph minus5["MINUS"] style minus5 stroke-width:6px,fill:pink,stroke:red; f6[["not sameterm(?instit1,?instit2)"]] f6 --> v5 f6 --> v6 v3 --"p:P108"--> a2 a2 --"p:statement/P108"--> v5 v3 --"p:P108"--> a3 a3 --"p:statement/P108"--> v6 end v3 --"p:direct/P108"--> v7 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end