6,317
edits
Project:SPARQL/examples: Difference between revisions
→Where women in our data are in wikidata, their spouses, fathers, and mothers according to wikidata
| Line 200: | Line 200: | ||
PREFIX wd: <http://www.wikidata.org/entity/> | PREFIX wd: <http://www.wikidata.org/entity/> | ||
SELECT ?person ?personLabel ?item | SELECT ?person ?personLabel ?item ?WD_spouse ?WD_father ?WD_mother | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . #select women | ?person bnwdt:P3 bnwd:Q3 . #select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person | ?person bnp:P117 ?wikidata_ID . #look for wikidata ID on person page | ||
BIND(IRI(REPLACE(? | ?wikidata_ID bnpq:P14 ?wikidata_url . | ||
BIND(IRI(REPLACE(?wikidata_url,"https://www.wikidata.org/wiki/","http://www.wikidata.org/entity/")) as ?item ) | |||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
| Line 216: | Line 217: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
# with thanks to @tagishsimon for writing this one! | # with thanks to @tagishsimon for writing this one initially! | ||
</sparql> | </sparql> | ||