Wikidata:WikiCite/Researchers in Switzerland/Queries
Monitoring of progress edit
#title:List of researchers with affiliation to institutions in Switzerland or Liechtenstein
SELECT DISTINCT ?person
WHERE {
?person wdt:P108 [ wdt:P17 ?country ] .
VALUES ?country { wd:Q39 wd:Q347 } .
}
#title:List of researchers with fundamental data and affiliation to institutions in Switzerland or Liechtenstein
SELECT DISTINCT ?person
WHERE {
?person wdt:P21 [ ] .
?person wdt:P735 [ ] .
?person wdt:P734 [ ] .
?person wdt:P108 [ wdt:P17 ?country ] . VALUES ?country { wd:Q39 wd:Q347 } .
?person wikibase:identifiers ?n . FILTER(?n > 0)
}
#title:List of researchers with fewer fundamental data and affiliation to institutions in Switzerland or Liechtenstein
SELECT DISTINCT ?person
WHERE {
?person wdt:P21 [ ] .
?person wdt:P108 [ wdt:P17 ?country ] . VALUES ?country { wd:Q39 wd:Q347 } .
?person wikibase:identifiers ?n . FILTER(?n > 1)
}
#title:Number of researchers with affiliation to institutions in Switzerland or Liechtenstein by gender
SELECT ?gender ?genderLabel (COUNT(DISTINCT ?person) AS ?number)
WHERE {
?person wdt:P108 [ wdt:P17 ?country ] .
?person wdt:P21 ?gender .
VALUES ?country { wd:Q39 wd:Q347 } .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?gender ?genderLabel ?number
#title:Number of researchers with fundamental data and affiliation to institutions in Switzerland or Liechtenstein by gender
SELECT ?gender ?genderLabel (COUNT(DISTINCT ?person) AS ?number)
WHERE {
?person wdt:P21 ?gender .
?person wdt:P735 [ ] .
?person wdt:P734 [ ] .
?person wdt:P108 [ wdt:P17 ?country ] . VALUES ?country { wd:Q39 wd:Q347 } .
?person wikibase:identifiers ?n . FILTER(?n > 0)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?gender ?genderLabel ?number
#title:Number of researchers with fewer fundamental data and affiliation to institutions in Switzerland or Liechtenstein by gender
SELECT ?gender ?genderLabel (COUNT(DISTINCT ?person) AS ?number)
WHERE {
?person wdt:P21 ?gender .
?person wdt:P108 [ wdt:P17 ?country ] . VALUES ?country { wd:Q39 wd:Q347 } .
?person wikibase:identifiers ?n . FILTER(?n > 1)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?gender ?genderLabel ?number
Monitoring quality edit
Display for institutions edit
Example with EPFL
#title:List of researchers employed by and/or affiliated to and/or educated with wdt:P69 at EPFL or parts of EPFL
SELECT DISTINCT ?person
WHERE {
?person ?prop ?v . VALUES ?prop { wdt:P108 wdt:P1416} .
?person wikibase:identifiers ?n . FILTER(?n > 1)
{ VALUES ?v { wd:Q262760 } } UNION { ?v ?prop2 wd:Q262760 . VALUES ?prop2 { wdt:P361 wdt:P749 } } .
}