Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

Revision as of 07:59, 7 September 2022

2,024 bytes added , 1 year ago

no edit summary

Jwbaker

6,317

edits

@@ Line 292: / Line 292: @@
 } group by ?person ?personLabel ?statements order by desc(?residence_count)
 # Credit to @Tagishsimon for helping me figure out the counting logic here
+</sparql>
+===People with IDs on wikidata, their date of birth on wikidata, and the source of that information===
+<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/>
+PREFIX p: <http://www.wikidata.org/prop/>
+PREFIX pr: <http://www.wikidata.org/prop/reference/>
+PREFIX prov: <http://www.w3.org/ns/prov#>
+SELECT ?woman ?womanLabel ?WDitem ?WDdateOfBirth (GROUP_CONCAT(?BirthStatedInEnglish;separator=" | ") AS ?sources)
+WHERE {
+  #Select all women
+  ?woman bnwdt:P3 bnwd:Q3 .
+  #select all women that have a Wikidata link
+  ?woman bnwdt:P117 ?Qnumber .
+  #create reference to Wikibase entity
+  BIND(IRI(concat("http://www.wikidata.org/entity/", ?Qnumber)) as ?WDitem )
+  #on Wikibase do
+  SERVICE <https://query.wikidata.org/sparql> {
+        #get the date of birth
+        ?WDitem wdt:P569 ?WDdateOfBirth .
+        #get the statement of birth
+        ?WDitem p:P569 ?Birthstatement .
+        #get its node
+        ?Birthstatement prov:wasDerivedFrom ?BirthRefnode.
+        #get the value of 'Stated in'
+        ?BirthRefnode   pr:P248 ?BirthStatedIn.
+        #get the english label of the referece 'stated in'
+        OPTIONAL {?BirthStatedIn rdfs:label ?BirthStatedInEnglish
+                  FILTER (LANG(?BirthStatedInEnglish) = "en")}.
+      }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+GROUP BY ?woman ?womanLabel ?WDitem ?WDdateOfBirth
+ORDER BY ?womanLabel
+# Credit to Maarten Zeinstra for developing this query
 </sparql>