User:TweetsFactsAndQueries/Queries/Nobel laureates by award type and gender
Originally posted on Twitter and on Mastodon.
#defaultView:BarChart
SELECT (REPLACE(REPLACE(?nobelPrizeLabel_, "^Nobel Prize in ", ""), "^Nobel (.*) Prize$", "$1") AS ?nobelPrizeLabel) (COUNT(DISTINCT ?winner) AS ?winners) (COALESCE(?genderLabel_, "N/A"@en) AS ?genderLabel) WHERE {
?nobelPrize wdt:P361 wd:Q7191.
?winner p:P166 [
ps:P166 ?nobelPrize;
pq:P585 ?date
].
OPTIONAL { ?winner wdt:P21 ?gender. } # optional because organizations can win the Peace Prize
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?nobelPrize rdfs:label ?nobelPrizeLabel_.
?gender rdfs:label ?genderLabel_.
}
}
GROUP BY ?nobelPrizeLabel_ ?genderLabel_