query-fa7a8640dc7640a3eebd9b99241c0ec8

rq turtle/ttl

PropertiesEarly Modern Letters Online person ID (P1802)member of (P463)sex or gender (P21)image (P18)occupation (P106)date of birth (P569)date of death (P570)

Use at

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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?birthDate ?birthPrecision ?deathDate ?deathPrecision ?pic ?occupation (URI(CONCAT("http://emlo.bodleian.ox.ac.uk/profile/person/", SAMPLE(?emlo))) AS ?emlolink) ?gender
WHERE
{ ?item wdt:P1802 ?emlo;
    wdt:P463 wd:Q188771;
 wdt:P21 ?genderItem .
OPTIONAL { ?item wdt:P18 ?pic }
OPTIONAL {?item wdt:P106 ?occupationItem }
?item p:P569/psv:P569 ?birthDateNode .
?birthDateNode wikibase:timeValue ?birthDate .
?birthDateNode wikibase:timePrecision ?birthPrecision .
OPTIONAL {?item p:P570/psv:P570 ?deathDateNode .
?deathDateNode wikibase:timeValue ?deathDate .
?deathDateNode wikibase:timePrecision ?deathPrecision }

SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
    ?item rdfs:label ?itemLabel .
?occupationItem rdfs:label ?occupation .
    ?genderItem rdfs:label ?gender 
  }
}  GROUP BY ?item ?itemLabel ?birthDate ?birthPrecision ?deathDate ?deathPrecision ?pic ?occupation ?gender

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v15("?_anon_42b5416610844a34809f33a099ae9de168254"):::projected v7("?birthDate"):::projected v6("?birthDateNode") v8("?birthPrecision"):::projected v10("?deathDate"):::projected v9("?deathDateNode") v11("?deathPrecision"):::projected v2("?emlo") v16("?emlolink") v14("?gender"):::projected v3("?genderItem") v1("?item"):::projected v12("?itemLabel"):::projected v13("?occupation"):::projected v5("?occupationItem") v4("?pic"):::projected a1((" ")) a2((" ")) c14(["bd:serviceParam"]):::iri c3(["wd:Q188771"]):::iri c16(["#91;AUTO_LANGUAGE#93;,en"]):::literal v1 --"p:direct/P1802"--> v2 v1 --"p:direct/P463"--> c3 v1 --"p:direct/P21"--> v3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v1 -."p:direct/P18".-> v4 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v1 -."p:direct/P106".-> v5 end v1 --"p:P569"--> a1 a1 --"p:statement/value/P569"--> v6 v6 --"wikibase:timeValue"--> v7 v6 --"wikibase:timePrecision"--> v8 subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v1 -."p:P570".-> a2 a2 --"p:statement/value/P570"--> v9 v9 --"wikibase:timeValue"--> v10 v9 --"wikibase:timePrecision"--> v11 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c14 --"wikibase:language"--> c16 v1 --"rdfs:label"--> v12 v5 --"rdfs:label"--> v13 v3 --"rdfs:label"--> v14 end bind1[/"sample(?emlo)"/] v2 --o bind1 bind1 --as--o v15 bind2[/"concat('http://emlo.bodleian.ox.ac.uk/profile/person/',)"/] null --o bind2 bind2 --as--o v16