3,427
edits
Project:SPARQL/examples: Difference between revisions
From Beyond Notability
→IDs
(→IDs) |
|||
| Line 1,988: | Line 1,988: | ||
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 bnwdt:P117 ?wikidata_ID . #look for wikidata ID on person page | ||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
# get English language wikipedia articles in wikidata entries, where listed | # get English language wikipedia articles in wikidata entries, where listed | ||
| Line 2,029: | Line 2,029: | ||
filter not exists {?person bnwdt:P15 ?bn_dod . } # *don't* have P15 date of death | filter not exists {?person bnwdt:P15 ?bn_dod . } # *don't* have P15 date of death | ||
?person | ?person bnwdt:P117 ?wikidata_ID . #look for wikidata ID on person page | ||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?item) . | |||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
| Line 2,065: | Line 2,065: | ||
filter not exists {?person bnwdt:P26 ?bn_dob . } # *don't* have P15 date of death | filter not exists {?person bnwdt:P26 ?bn_dob . } # *don't* have P15 date of death | ||
?person | ?person bnwdt:P117 ?wikidata_ID . #look for wikidata ID on person page | ||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
?item wdt:P21 ?WD_gender. #get gender of person | ?item wdt:P21 ?WD_gender. #get gender of person | ||
| Line 2,100: | Line 2,099: | ||
#?person bnwdt:P75 bnwd:Q8. # limit to FSAs if the full set times out. | #?person bnwdt:P75 bnwd:Q8. # limit to FSAs if the full set times out. | ||
?person | ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID | ||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
