Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

Revision as of 15:54, 5 September 2022

373 bytes removed , 1 year ago

→‎Women in the wiki (excluding the project team) and their corresponding IDs - where they exist - on wikidata, viaf, WorldCat Identities, and the Archaeology Data Service

Jwbaker

6,317

edits

@@ Line 14: / Line 14: @@
 PREFIX wd:  <http://www.wikidata.org/entity/>
-SELECT ?person ?personLabel ?wikiurl ?viafurl ?worldcatIDurl ?ADSid ?ADSurl
+SELECT ?person ?personLabel ?wikidata_ID ?viaf_ID ?ads_ID ?worldcat_ID
 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
-     OPTIONAL {?person bnwdt:P14 ?wikiurl .
+     OPTIONAL {?person bnwdt:P117 ?wikidata_ID .}             #return wikidata ID
-      FILTER regex(?wikiurl, "wikidata", "i")}             #look for wikidata URL on person page
+     OPTIONAL {?person bnwdt:P119 ?viaf_ID .}                 #return VIAF ID
-     OPTIONAL {?person bnwdt:P14 ?viafurl .
+     OPTIONAL {?person bnwdt:P34 ?ads_ID .}                   #return Archaeological Data Service ID
-      FILTER regex(?viafurl, "viaf", "i")}                 #look for viaf URL on person page
+     OPTIONAL {?person bnwdt:P118 ?worldcat_ID .}             #return WorldCat Identities ID
-     OPTIONAL {?person bnwdt:P14 ?worldcatIDurl .
-      FILTER regex(?worldcatIDurl, "worldcat", "i")}       #look for ?worldcatIDurl URL on person page
-     OPTIONAL {?person bnp:P34 ?ADSstatement .              #look for Archaeology Data Service ID on person page
-              ?ADSstatement bnps:P34 ?ADSid .              #return ADS id
-              ?ADSstatement bnpq:P14 ?ADSurl .}            #return ADS url
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }