query-2f0073cbe5bda205c199d84589262b75
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
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#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
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?employer")
v4("?employerStmnt")
v7("?end"):::projected
v2("?faculty"):::projected
v1("?fullName"):::projected
v4("?role")
v6("?start"):::projected
c13(["bd:serviceParam"]):::iri
c15(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c5(["wd:Q109854824"]):::iri
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0f0[["langmatch(?fullName,'en-gb')"]]
e0f0 --> e0v1
e0v1("?fullName"):::projected
end
f0--EXISTS--> f0e0
f0 --> v1
f1[["langmatch(?fullName,'en-gb')"]]
f1 --> v1
f2[["not "]]
subgraph f2e1["Exists Clause"]
e1f0[["langmatch(?fullName,'en-ca')"]]
e1f0 --> e1v1
e1v1("?fullName"):::projected
end
f2--EXISTS--> f2e1
f2 --> v1
f3[["langmatch(?fullName,'en-ca')"]]
f3 --> v1
f4[["langmatch(?fullName,'en')"]]
f4 --> v1
v2 --"p:direct/P5008"--> c5
v2 --"rdfs:label"--> v1
v2 --"p:direct/P106"--> v4
bind5[/VALUES ?role/]
bind5-->v4
bind50(["wd:Q3400985"])
bind50 --> bind5
v2 --"p:P108"--> v4
v4 --"p:statement/P108"--> v5
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v4 -."p:qualifier/P580".-> v6
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v4 -."p:qualifier/P582".-> v7
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c13 --"wikibase:language"--> c15
end