Wikidata:WikiCite/Researchers in Switzerland/Queries

Monitoring of progress

#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 } .
}

List of researchers with affiliation to institutions in Switzerland or Liechtenstein

#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)
}

List of researchers with fundamental data and affiliation to institutions in Switzerland or Liechtenstein

#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)
}

List of researchers with fewer fundamental data and affiliation to institutions in Switzerland or Liechtenstein

#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

Number of researchers with affiliation to institutions in Switzerland or Liechtenstein by gender

#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

Number of researchers with fundamental data and affiliation to institutions in Switzerland or Liechtenstein by gender

#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

Number of researchers with fewer fundamental data and affiliation to institutions in Switzerland or Liechtenstein by gender

Display for institutions

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 } } .
}

List of researchers employed by and/or affiliated to and/or educated with wdt:P69 at EPFL or parts of EPFL