Join GitHub today
GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.
Sign upHave professions in the University perspective #908
Projects
Comments
This comment has been minimized.
This comment has been minimized.
|
Here is a SPARQL query that surfaces the occupation of folks affiliated/ employed/ educated at a given institution. SELECT ?count ?occupation ?occupationLabel ?list
WITH {
SELECT (COUNT(?researcher) AS ?count) ?occupation (GROUP_CONCAT(?researcher_label; separator=", ") AS ?list) WHERE {
hint:Query hint:optimizer "None" .
{
SELECT DISTINCT ?researcher WHERE {
?researcher ( wdt:P108 | wdt:P463 | wdt:P1416 ) / wdt:P361* wd:Q213439 .
}
}
?researcher wdt:P106 ?occupation .
?researcher rdfs:label ?researcher_label . FILTER (LANG(?researcher_label) = 'en')
}
GROUP BY ?occupation
} AS %result
WHERE {
INCLUDE %result
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,da,de,es,fr,jp,nl,no,ru,sv,zh" . }
}
ORDER BY DESC(?count)
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
When there is a sum of the professions for a university, it is not only informative, it also helps projects like women in red to choose candidate for new articles.