Wikidata:WikiProject UConn/Faculty start and end date

#Current UConn faculty with start and end date information
SELECT DISTINCT ?faculty ?fullName ?roleLabel ?employerLabel ?start ?end WHERE {
  ?faculty wdt:P5008 wd:Q109854824.
  ?faculty rdfs:label ?fullName.
  ?faculty wdt:P106 ?role.
  VALUES (?role) {
     (wd:Q3400985)
  }
  ?faculty p:P108 ?employerStmnt.
  ?employerStmnt ps:P108 ?employer.
  OPTIONAL { ?employerStmnt pq:P580 ?start. }
  OPTIONAL { ?employerStmnt pq:P582 ?end. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  FILTER(LANGMATCHES(LANG(?fullName), "en"))
  FILTER(NOT EXISTS { FILTER(LANGMATCHES(LANG(?fullName), "en-ca")) })
  FILTER(NOT EXISTS { FILTER(LANGMATCHES(LANG(?fullName), "en-gb")) })
}
ORDER BY ?fullName
LIMIT 10

Try it! (https://w.wiki/5W6u)