query-e5de9ae22a9ca0d8e868203f9393e83b

rq turtle/ttl

People at Janelia Research Campus (Q1319362), along with their identifiers on the Janelia webpage

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?qid_person ?janelia_person ?orcid
WHERE 
{
  ?item wdt:P1416 wd:Q1319362.
  OPTIONAL {?item wdt:P496 ?orcid.}
  ?item p:P1416 [prov:wasDerivedFrom [pr:P854 ?biourl]].
  BIND (STRAFTER(STR(?biourl), "/people/") AS ?janelia_person).
  BIND (STRAFTER(STR(?item), "/entity/") AS ?qid_person).
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?biourl") v1("?item") v4("?janelia_person"):::projected v2("?orcid"):::projected v5("?qid_person"):::projected a2((" ")) a1((" ")) c2(["wd:Q1319362"]):::iri v1 --"p:direct/P1416"--> c2 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v1 -."p:direct/P496".-> v2 end a1 --"p:reference/P854"--> v3 a2 --"prov:wasDerivedFrom"--> a1 v1 --"p:P1416"--> a2 bind0[/"substring-after(str(?biourl),'/people/')"/] v3 --o bind0 bind0 --as--o v4 bind1[/"substring-after(str(?item),'/entity/')"/] v1 --o bind1 bind1 --as--o v5