579
edits
Project:SPARQL/examples: Difference between revisions
→Which BN properties map on to Wikidata properties?
| Line 2,194: | Line 2,194: | ||
} | } | ||
order by ?bn_label | order by ?bn_label | ||
</sparql> | |||
=== BN Men in Wikidata === | |||
<sparql tryit="1"> | |||
#title: BN men in Wikidata | |||
# a starting point to get the basic query set up; can easily add more variables... | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | |||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | |||
PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/> | |||
PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> | |||
PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/> | |||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | |||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | |||
PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> | |||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | |||
SELECT distinct ?person ?personLabel ?wikidata ?wd_dob ?wd_dod ?odnb_url ?wikipedia | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q10 . #select men | |||
?person bnp:P117 ?wikidata_ID . #get wikidata ID | |||
?wikidata_ID bnpq:P14 ?wikidata_url . | |||
BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata ) | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
optional { | |||
# P1415 Oxford Dictionary of National Biography ID | couls also add P6829 Dictionary of Irish Biography ID | P1648 Dictionary of Welsh Biography ID | |||
?wikidata wdt:P1415 ?odnb_id . | |||
# odnb link | |||
BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?odnb_id)) as ?odnb_url ) . | |||
} #/ odnb | |||
# English language wikipedia articles in wikidata entries, where listed | |||
OPTIONAL { | |||
?wikipedia schema:about ?wikidata . | |||
?wikipedia schema:inLanguage 'en' . | |||
FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/') | |||
} | |||
optional { ?wikidata wdt:P569 ?wd_dob . } #date of birth on Wikidata P569 | |||
optional { ?wikidata wdt:P570 ?wd_dod . } #date of death on Wikidata P570 | |||
} #/ wikidata | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | |||
} | |||
order by ?personLabel | |||
</sparql> | </sparql> | ||