Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

Revision as of 14:56, 1 September 2023

1,561 bytes added , 8 months ago

→‎Admin

Sharon

579

edits

@@ Line 1,253: / Line 1,253: @@
          ?item wdt:P21 ?WD_gender. #get gender of person
          ?item wdt:P570 ?wd_dod .  #date of death on Wikidata P570
+      }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+ORDER BY ?personLabel
+</sparql>
+=== Women with no date of birth in our wikibase who have a date of birth in Wikidata===
+# Women who have no date of birth in our wikibase and have a date of birth on Wikidata
+<sparql tryit="1">
+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 wdt: <http://www.wikidata.org/prop/direct/>
+PREFIX wd:  <http://www.wikidata.org/entity/>
+SELECT ?person ?personLabel  ?wd_dob
+WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . #select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  filter not exists {?person bnwdt:P26 ?bn_dob . } # *don't* have P15 date of death
+  ?person bnp:P117 ?wikidata_ID . #look for wikidata ID on person page
+  ?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> {
+        ?item wdt:P21 ?WD_gender. #get gender of person
+        ?item wdt:P569 ?wd_dob .  #date of birth on Wikidata P569
        }