query-1e9204445f2201b04bcf9020c4cac1ab

rq turtle/ttl

Institutions around the globe where people who have/ had a doctoral advisor have been educated

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:Map
SELECT ?academics ?academicsLabel ?geoloc ?institution ?institutionLabel ?image WHERE {
  ?academics wdt:P31 wd:Q5 . # instances (P31) of humans (Q5)
  ?academics wdt:P184 ?advisor . # PhD supervisor (P184)
  # possible other route to identify people with PhD: Property:P512 (academic degree): Q752297
  ?academics wdt:P69 ?institution . # educated at
  ?academics wdt:P18 ?image . #image
  #?institution wdt:P17 wd:Q16 . # institution is in Canada
  ?institution wdt:P625 ?geoloc . #gets the geolocation of the institution
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 100

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?academics"):::projected v2("?advisor") v5("?geoloc"):::projected v4("?image"):::projected v3("?institution"):::projected c8(["bd:serviceParam"]):::iri c2(["wd:Q5"]):::iri c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal v1 --"wdt:P31"--> c2 v1 --"wdt:P184"--> v2 v1 --"wdt:P69"--> v3 v1 --"wdt:P18"--> v4 v3 --"wdt:P625"--> v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end