579
edits
Project:SPARQL/examples: Difference between revisions
→Women with ODNB IDs in Wikidata
| Line 1,538: | Line 1,538: | ||
order by ?personLabel ?id | order by ?personLabel ?id | ||
</sparql> | |||
=== Women with National Portrait Gallery links via Wikidata === | |||
<sparql tryit="1"> | |||
# Query to fetch National Portrait Gallery IDs on Wikidata for BN women, with links | |||
# NB this may be a bit slow... | |||
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 ?id_no ?npg_url | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . #select women | |||
?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> { | |||
?wikidata ?p ?s . | |||
?prop wikibase:claim ?p; | |||
wikibase:statementProperty ?ps; | |||
wikibase:propertyType wikibase:ExternalId. | |||
?s ps:P1816 ?id_no . # id value | |||
# npg link | |||
BIND(IRI(concat("https://www.npg.org.uk/collections/search/person/", ?id_no)) as ?npg_url ) . | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | |||
} | |||
order by ?personLabel ?id_no | |||
</sparql> | </sparql> | ||