@@ Line 1: / Line 1: @@
+[[Project:SPARQL/admin | Admin/batch tools queries]]
 ==SAL and RAI==
@@ Line 168: / Line 170: @@
 </sparql>
-===Women who are listed as Fellows of the Society of Antiquaries of London (FSAs) on our wikibase and who are on Wikidata, but are not listed as FSAs on Wikidata===
-<sparql tryit="1">
-# Women who are listed as Fellows of the Society of Antiquaries of London (FSAs) on our wikibase and who are on Wikidata, but are not listed as FSAs on Wikidata
-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
-WHERE {
-  ?person bnwdt:P3 bnwd:Q3 . #select women
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-  ?person bnwdt:P75 bnwd:Q8. # find only BN subjects having a FSA (h/t @Tagishsimon)
-  ?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> {
-        ?item wdt:P21 ?WD_gender. #get gender of person
-        FILTER NOT EXISTS {?item wdt:P166 wd:Q26196499 . } #not FSA on Wikidata
-      }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
-}
-ORDER BY ?personLabel
-</sparql>
 === Women's interactions with SAL (Q1 and Q8)===
 <sparql tryit="1">
+#title:Women's interactions with SAL (Q1 and Q8)
+# CAVEAT: this query may overlook a significant number of interactions and should probably not be reference/archived in its current state
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 213: / Line 184: @@
 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 distinct ?person ?personLabel  ?prop ?propLabel   ?pq_value  ?qual_propLabel  ?sal
+SELECT distinct ?person ?personLabel   ?propLabel   ?qual_value  ?qual_propLabel  ?bnwdLabel # ?s ?prop ?qual_prop ?bnwd
 WHERE {
@@ Line 223: / Line 192: @@
        ?prop wikibase:claim ?p;
-          wikibase:statementProperty ?ps;
+          wikibase:statementProperty ?ps.
-         wikibase:statementValue ?psv;
-         wikibase:propertyType ?prop_type.
        # union query to get both q8 and q1
        { ?s ?ps bnwd:Q8 . }  union { ?s ?ps bnwd:Q1 . }
-        ?s ?ps ?sal.
+        ?s ?ps ?bnwd. #which type
-       optional {
+      optional {
-          ?s ?pq ?pq_value .
+          ?s ?pq ?qual_value .
           ?qual_prop wikibase:qualifier ?pq .
-         #?qual_prop rdfs:label ?qual_prop_label. filter(lang(?qual_prop_label)="en-gb") .
-         #?qual_prop wikibase:propertyType ?qual_prop_type
         } # /qualifiers
@@ Line 248: / Line 213: @@
 <sparql tryit="1">
+#title:Women's interactions with RAI (Q35 and Q29)
+# CAVEAT: this query may overlook a significant number of interactions and should probably not be reference/archived in its current state
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 255: / Line 222: @@
 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 distinct ?person ?personLabel  ?prop ?propLabel ?prop_type  ?pq_value ?pq_valueLabel ?qual_propLabel ?qual_prop_type ?rai ?s
+SELECT distinct ?person ?personLabel  ?propLabel  ?qual_value ?qual_propLabel ?bnwdLabel # ?s ?prop ?qual_prop
 WHERE {
@@ Line 265: / Line 230: @@
        ?prop wikibase:claim ?p;
-          wikibase:statementProperty ?ps;
+          wikibase:statementProperty ?ps.
-         wikibase:statementValue ?psv;
-         wikibase:propertyType ?prop_type.
        # to get both q35 and q29
        { ?s ?ps bnwd:Q35 . }  union { ?s ?ps bnwd:Q29 . }
-        ?s ?ps ?rai.
+        ?s ?ps ?bnwd.
         # qualifiers.
         optional {
-          ?s ?pq ?pq_value .
+          ?s ?pq ?qual_value .
           ?qual_prop wikibase:qualifier ?pq .
-         #?qual_prop rdfs:label ?qual_prop_label. filter(lang(?qual_prop_label)="en-gb") .
-         ?qual_prop wikibase:propertyType ?qual_prop_type .
         } # /qualifiers
@@ Line 294: / Line 255: @@
 #title: FSAs with no record of interacting with SAL in Q1 / Q8
 # only active engagements like spoke at, corresponded with, etc, and excluding P75 "was fellow of" and P5 "archives at".
-# WIP: to update with other SAL records as I work through queries for them. Plus caveat that there may be other sources of interaction not recorded in the database!
+# CAVEATS: I think this is not working as intended and it shouldn't be referenced or archived
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 342: / Line 303: @@
 #title: RAIs with no record of interacting with RAI in Q29/Q35
 # only active engagements like spoke at, corresponded with, etc, and excluding P67 "was member of"
-# WIP: to update with other RAI records as I work through queries for them. Plus caveat that there may be other sources of interaction not recorded in the database.
+# CAVEATS: I think this may not be working as intended and it shouldn't be referenced or archived in its current state
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 552: / Line 513: @@
 </sparql>
+=== Lecturers ===
-== Professional Activities and Organisations ==
+<sparql tryit="1">
+#title:lecturers
+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 bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
+PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
+SELECT distinct ?person ?personLabel  ?positionLabel
+?organisedLabel ?ofLabel
+?qual_propLabel ?qualLabel
+#?position ?of  ?work ?organised  ?date_precision ?qual_prop ?date ?qual ?workLabel
+?s
+WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . # women
+  # work activities: held position / held position (free text) /  employed as
+  #?person ( bnp:P17|bnp:P48|bnp:P105 ) ?s .
+  ?person ?work_p ?s . # for activity type label
+    ?work wikibase:claim ?work_p .
+    ?s ?bnps ?position .
+    # freelance and extension lecturing (q701 and q3021)
+    { ?s ?bnps bnwd:Q701  . } union { ?s ?bnps bnwd:Q3021 .  }
+    # employer / organised by / of (incl free text).
+    OPTIONAL { ?s bnpq:P109 ?organised .}
+    OPTIONAL { ?s ( bnpq:P78 | bnpq:P66 ) ?of .}
+   # optional { ?s bnpq:P2 ?location . } # do locations separately.
+  # dates with precision
+ #   optional {
+ #     ?s (bnpqv:P1 | bnpqv:P27 | bnpqv:P28  ) ?pqv.
+ #     ?s ?pqq ?pqv . # just gets the uri but doesnt seem to cause dups
+ #        ?pqv wikibase:timeValue ?date .
+ #        ?pqv wikibase:timePrecision ?date_precision .
+ #     }
+    # qualifiers
+    optional {
+      ?s ?pq ?qual .
+         ?qual_prop wikibase:qualifier ?pq .
+      } # /dates
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+} # /where
-=== Women's service on committees etc (P102) ===
+ORDER BY ?person ?s
+</sparql>
+=== Excavations ===
 <sparql tryit="1">
+#title:BN excavations
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 567: / Line 587: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+SELECT ?excavationLabel ?excavation ?locationLabel ?start ?end ?pit
+?partLabel ?funderLabel ?organisedLabel ?facilitatedLabel ?directorLabel ?memberLabel
+# ?member ?director  ?location ?part ?funder ?facilitated ?organised
-SELECT distinct ?personLabel ?serviceLabel ?qual_propLabel  ?qualLabel   ?qual ?person ?s # ?service
 WHERE {
-  ?person bnwdt:P3 bnwd:Q3 . # select women
+   # instance of excavation  128
-   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+   ?excavation bnwdt:P12 bnwd:Q38 .
-  ?person bnp:P102 ?s .   # served on P102
+    optional { ?excavation bnwdt:P2 ?location .}
-  ?person ?p ?s .    # for claim
-   ?claim wikibase:claim ?p;
+    optional { ?excavation bnwdt:P27 ?start . }
-         wikibase:statementProperty ?ps;
-         wikibase:propertyType ?prop_type.
+    optional { ?excavation bnwdt:P28 ?end . }
-      ?s ?ps ?service . # service on what
+    optional { ?excavation bnwdt:P1 ?pit. }
+    optional { ?excavation bnwdt:P4 ?part . }
+    optional { ?excavation bnwdt:P36 ?director . }
+    optional { ?excavation bnwdt:P37 ?member . }
+    optional { ?excavation bnwdt:P109 ?organised .}
+    optional { ?excavation bnwdt:P121 ?facilitated . }
+    optional { ?excavation bnwdt:P145 ?funder . }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+}
+ORDER BY ?excavationLabel
+</sparql>
+== Professional Activities and Organisations ==
+=== Women's service on committees etc (P102) ===
+<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/>
+SELECT distinct ?personLabel ?serviceLabel ?qual_propLabel  ?qualLabel   ?qual ?person ?s # ?service
+WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . # select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?person bnp:P102 ?s .   # served on P102
+      ?s bnps:P102 ?service .
     optional {  #qualifiers, if any
@@ Line 757: / Line 819: @@
 <sparql tryit="1">
 #title:ppa buckets (revised February 2024)
+# broad PPA grouping categories to use for overviews and analysis within categories
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 773: / Line 837: @@
        ?ppa wikibase:claim ?p;
           wikibase:statementProperty ?ps.
+      # note: i think you need rdfs:label (*Label won't work) for the bind()
        SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb".
-                        ?ppa rdfs:label ?ppa_label.       # what kind of thing
+                        ?ppa rdfs:label ?ppa_label.
                  } # /label service
@@ Line 784: / Line 850: @@
        ?s ?ps ?ppa_value.
+    # note: it would be possible to write this to use ppa rather than ppa_label. there's a slight risk that property names might change.
+    # BUT then it would be much more opaque and difficult to edit if (when!) we make any changes to the buckets.
      bind(
        if( str(?ppa_label) in ("attended", "exhibited at", "organiser of", "performed at", "spoke at", "was delegate at (free text)", "was delegate at (item)" ), "events",
@@ Line 806: / Line 873: @@
 </sparql>
-==Place==
+=== Suffrage-related activities ===
-===People not in London linked as a graph by a NUTS region or country (excluding England) at which they were once resident in the UK===
 <sparql tryit="1">
-# People not in London linked as a graph by a NUTS region or country (excluding England) at which they were once resident in the UK
+#title:initial query for suffrage activities
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 821: / Line 886: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Graph
+SELECT distinct ?person ?personLabel ?mainLabel ?sub_Label ?qualLabel ?locationLabel ?date
-SELECT ?resident ?residentLabel ?region ?regionLabel
+# ?pq ?sub_ ?qual ?main
+?s
 WHERE {
-  ?resident bnwdt:P29 ?residence .
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2035 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2036 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2037 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2038 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2039 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2040 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2041 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2042 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q39.}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2534.}
-  ?residence bnwdt:P33 ?district .
-  ?district bnwdt:P33 ?county .
-  ?county bnwdt:P33 ?region .
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-</sparql>
-===People whose residence was at one time in the east or south east of England, excluding London===
+    ?person bnwdt:P3 bnwd:Q3 . #select women
+    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+    ?person ?p ?s .
+      ?s ?sub ?sub_ .
+        ?main wikibase:claim ?p.
+        ?main wikibase:statementProperty ?sub.
+  # sub_ i/o - some do have suffrage activity
+  #  optional { ?sub_ bnwdt:P12 ?sub_io . ?sub_ bnwdt:P12 bnwd:Q1166 . }
+  # union
+   {
+    # a qualifier (anywhere) has i/o suffrage activity
+       ?s bnpq:P12 bnwd:Q1166.
+    }
-<sparql tryit="1">
+# what about a main rather than qualifier having i/o suffrage activity? i don't think there are any atm but could be.
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+# union
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+ #   { # this might find extra linked i/o suffrage but i'm not sure it works.
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
+ #     ?sub_ bnwdt:P12 bnwd:Q1166 .
-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/>
+  union
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+    {
+     # does *not* have i/o suffrage activity in any qualifiers  ... slows things right down and doesn't seem to make any difference to results?
+     #filter not exists { ?s bnpq:P12 bnwd:Q1166. }
+     # ... but a qualifier *does* have i/o suffrage activity. i think!
+      ?s ?pq ?qual .
+        ?qual bnwdt:P12 bnwd:Q1166 .
+      } # /union
+  optional {
+    # date qualifiers. [assumes no edtf in quals. ] all seem to be p.i.t.
+        ?s ?dpq ?date .
+          ?qual_date wikibase:qualifier ?dpq .
+          ?qual_date wikibase:propertyType wikibase:Time.
+  }
+  optional { ?s bnpq:P78 ?of. }  # outside the union seems much speedier
+  optional { ?s bnpq:P2 ?location . }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-SELECT ?resident ?residentLabel ?residenceLabel ?districtLabel ?countyLabel ?regionLabel
-WHERE {
-  ?resident bnwdt:P29 ?residence .
-  ?residence bnwdt:P33 ?district .
-  ?district bnwdt:P33 ?county .
-  ?county bnwdt:P33 ?region .
-    {?county bnwdt:P33 bnwd:Q67 .}
-    UNION
-    {?county bnwdt:P33 bnwd:Q85 .}
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residenceLabel
+order by ?personLabel ?mainLabel
 </sparql>
-===People whose residence was at one time in North East England or Yorkshire and the Humber===
+==Place==
+=== All the things in BN that can be mapped ===
 <sparql tryit="1">
-# People whose residence was at one time in North East England or Yorkshire and the Humber
+#title:map of BN locations using wikidata P625
+#defaultView:Map
+#this will take a little while to run...
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 880: / Line 960: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?resident ?residentLabel ?residenceLabel ?districtLabel ?countyLabel ?regionLabel
+SELECT distinct ?locationLabel ?location ?wikidata ?wd_geo
 WHERE {
-   ?resident bnwdt:P29 ?residence .
-  ?residence bnwdt:P33 ?district .
+       ?location bnwdt:P117 ?ws .  # wikidata id
-  ?district bnwdt:P33 ?county .
-  ?county bnwdt:P33 ?region .
+         bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
-    {?county bnwdt:P33 bnwd:Q72 .}
+         SERVICE <https://query.wikidata.org/sparql> {
-    UNION
+             ?wikidata wdt:P625 ?wd_geo .  # does the wikidata page have geocoords?
-    {?county bnwdt:P33 bnwd:Q200 .}
+         } # /wikidata service
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
-ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residenceLabel
+ORDER BY ?wikidata ?locationLabel
 </sparql>
-===People not in London with the district, county, and region at which they were once resident (in the UK) listed===
+===People not in London linked as a graph by a NUTS region or country (excluding England) at which they were once resident in the UK===
 <sparql tryit="1">
-# People not in London with the district, county, and region at which they were once resident (in the UK) listed
+# People not in London linked as a graph by a NUTS region or country (excluding England) at which they were once resident in the UK
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 907: / Line 989: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?resident ?residentLabel ?district ?districtLabel ?county ?countyLabel ?region ?regionLabel
+#defaultView:Graph
+SELECT ?resident ?residentLabel ?region ?regionLabel
 WHERE {
    ?resident bnwdt:P29 ?residence .
@@ Line 925: / Line 1,008: @@
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residentLabel
 </sparql>
-===People sorted by the number of places they lived, including the number of cites/towns/villages they lived in===
+===People whose residence was at one time in the east or south east of England, excluding London===
 <sparql tryit="1">
@@ Line 939: / Line 1,021: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?person ?personLabel (count(?resided) as ?residence_count) (count(distinct ?resided) as ?residence_distinct) WHERE {
+SELECT ?resident ?residentLabel ?residenceLabel ?districtLabel ?countyLabel ?regionLabel
-   ?person bnwdt:P3 bnwd:Q3 ;
+WHERE {
-         wikibase:statements ?statements .
+  ?resident bnwdt:P29 ?residence .
-   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?residence bnwdt:P33 ?district .
-  ?person bnp:P29/bnps:P29 ?resided.
+  ?district bnwdt:P33 ?county .
-   SERVICE wikibase:label {
+   ?county bnwdt:P33 ?region .
-      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
+    {?county bnwdt:P33 bnwd:Q67 .}
-  }
+    UNION
-} group by ?person ?personLabel ?statements order by desc(?residence_count)
+    {?county bnwdt:P33 bnwd:Q85 .}
-# Credit to @Tagishsimon for helping me figure out the counting logic here
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residenceLabel
 </sparql>
-===Places at which women resided, sorted by how many residences all women had at a given village/town/city/London area===
+===People whose residence was at one time in North East England or Yorkshire and the Humber===
 <sparql tryit="1">
-# Places at which women resided, sorted by how many residences all women had at a given village/town/city/London area
+# People whose residence was at one time in North East England or Yorkshire and the Humber
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 964: / Line 1,048: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?residence ?residenceLabel (count(?residence) as ?residence_count) #count number of places at which women lived
+SELECT ?resident ?residentLabel ?residenceLabel ?districtLabel ?countyLabel ?regionLabel
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . # select women
+   ?resident bnwdt:P29 ?residence .
-   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?residence bnwdt:P33 ?district .
-  ?person bnwdt:P29 ?residence . # select residences
+   ?district bnwdt:P33 ?county .
+  ?county bnwdt:P33 ?region .
+    {?county bnwdt:P33 bnwd:Q72 .}
+    UNION
+    {?county bnwdt:P33 bnwd:Q200 .}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-GROUP BY ?residence ?residenceLabel
+ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residenceLabel
-ORDER BY DESC(?residence_count)
 </sparql>
-===Districts in which women resided, sorted by how many residences all women had in that district (or equivalent sub-level for non-UK residences)===
+===People not in London with the district, county, and region at which they were once resident (in the UK) listed===
 <sparql tryit="1">
-# Districts in which women resided, sorted by how many residences all women had in that district (or equivalent sub-level for non-UK residences)
+# People not in London with the district, county, and region at which they were once resident (in the UK) listed
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 988: / Line 1,075: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?district ?districtLabel (count(?district) as ?district_count) #count number of districts in which women lived
+SELECT ?resident ?residentLabel ?district ?districtLabel ?county ?countyLabel ?region ?regionLabel
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . # select women
+   ?resident bnwdt:P29 ?residence .
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2035 .}
-  ?person bnwdt:P29 ?residence . # select residences
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2036 .}
-   ?residence bnwdt:P33 ?district . #select districts
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2037 .}
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2038 .}
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2039 .}
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2040 .}
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2041 .}
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2042 .}
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q39.}
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2534.}
+   ?residence bnwdt:P33 ?district .
+  ?district bnwdt:P33 ?county .
+  ?county bnwdt:P33 ?region .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-GROUP BY ?district ?districtLabel
+ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residentLabel
-ORDER BY DESC(?district_count)
 </sparql>
-===Counties in which women resided, sorted by how many residences all women had in that county===
+===People sorted by the number of places they lived, including the number of cites/towns/villages they lived in===
 <sparql tryit="1">
-# Counties in which women resided, sorted by how many residences all women had in that county
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,013: / Line 1,107: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?county ?countyLabel (count(?county) as ?county_count) #count number of counties in which women lived
+SELECT ?person ?personLabel (count(?resided) as ?residence_count) (count(distinct ?resided) as ?residence_distinct) WHERE {
-WHERE {
+   ?person bnwdt:P3 bnwd:Q3 ;
-  ?person bnwdt:P3 bnwd:Q3 . # select women
+         wikibase:statements ?statements .
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-   ?person bnwdt:P29 ?residence . # select residences
+   ?person bnp:P29/bnps:P29 ?resided.
-  ?residence bnwdt:P33 ?district . #select districts
+   SERVICE wikibase:label {
-  ?district bnwdt:P33 ?county . #select counties
+      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+  }
-}
+} group by ?person ?personLabel ?statements order by desc(?residence_count)
-GROUP BY ?county ?countyLabel
+# Credit to @Tagishsimon for helping me figure out the counting logic here
-ORDER BY DESC(?county_count)
 </sparql>
-====Counties of residence for women recorded in CAS Indexes of Archaeological Papers, sorted by how many residences all women had in that county====
+===Places at which women resided, sorted by how many residences all women had at a given village/town/city/London area===
 <sparql tryit="1">
-# Counties of residence for women recorded in CAS Indexes of Archaeological Papers, sorted by how many residences all women had in that county
+# Places at which women resided, sorted by how many residences all women had at a given village/town/city/London area
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,039: / Line 1,132: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?county ?countyLabel (count(?county) as ?county_count) #count number of counties in which women lived
+SELECT ?residence ?residenceLabel (count(?residence) as ?residence_count) #count number of places at which women lived
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
-  ?person bnwdt:P76 bnwd:Q419 . #select women recorded in CAS Indexes of Archaeological Papers
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
    ?person bnwdt:P29 ?residence . # select residences
-  ?residence bnwdt:P33 ?district . #select districts
-  ?district bnwdt:P33 ?county . #select counties
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-GROUP BY ?county ?countyLabel
+GROUP BY ?residence ?residenceLabel
-ORDER BY DESC(?county_count)
+ORDER BY DESC(?residence_count)
 </sparql>
-====Counties of residence for women nominated as FSAs, sorted by how many residences all women had in that county====
+===Districts in which women resided, sorted by how many residences all women had in that district (or equivalent sub-level for non-UK residences)===
 <sparql tryit="1">
-# Counties of residence for women nominated as FSAs, sorted by how many residences all women had in that county
+# Districts in which women resided, sorted by how many residences all women had in that district (or equivalent sub-level for non-UK residences)
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,066: / Line 1,156: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?county ?countyLabel (count(?county) as ?county_count) #count number of counties in which women lived
+SELECT ?district ?districtLabel (count(?district) as ?district_count) #count number of districts in which women lived
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
-  ?person bnwdt:P16 ?signatory . #select women who were nominated for election to FSA
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
    ?person bnwdt:P29 ?residence . # select residences
    ?residence bnwdt:P33 ?district . #select districts
-  ?district bnwdt:P33 ?county . #select counties
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-GROUP BY ?county ?countyLabel
+GROUP BY ?district ?districtLabel
-ORDER BY DESC(?county_count)
+ORDER BY DESC(?district_count)
 </sparql>
-====Counties of residence for women nominated to RAI, sorted by how many residences all women had in that county====
+===Counties in which women resided, sorted by how many residences all women had in that county===
 <sparql tryit="1">
-# Counties of residence for women nominated to RAI, sorted by how many residences all women had in that county
+# Counties in which women resided, sorted by how many residences all women had in that county
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,096: / Line 1,184: @@
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
-  ?person bnwdt:P7 ?signatory . #select women who were nominated for election to RAI
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
    ?person bnwdt:P29 ?residence . # select residences
@@ Line 1,107: / Line 1,194: @@
 </sparql>
-====Counties of residence for women who spoke at RAI meetings, sorted by how many residences all women had in that county====
+====Counties of residence for women recorded in CAS Indexes of Archaeological Papers, sorted by how many residences all women had in that county====
 <sparql tryit="1">
-# Counties of residence for women who spoke at RAI meetings, sorted by how many residences all women had in that county
+# Counties of residence for women recorded in CAS Indexes of Archaeological Papers, sorted by how many residences all women had in that county
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,123: / Line 1,210: @@
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
-   ?person bnwdt:P23 bnwd:Q29 . #select women who spoke at RAI Meeting
+   ?person bnwdt:P76 bnwd:Q419 . #select women recorded in CAS Indexes of Archaeological Papers
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
    ?person bnwdt:P29 ?residence . # select residences
@@ Line 1,134: / Line 1,221: @@
 </sparql>
-====Counties of residence for women who exhibited at RAI meetings, sorted by how many residences all women had in that county====
+====Counties of residence for women nominated as FSAs, sorted by how many residences all women had in that county====
 <sparql tryit="1">
-# Counties of residence for women who exhibited at RAI meetings, sorted by how many residences all women had in that county
+# Counties of residence for women nominated as FSAs, sorted by how many residences all women had in that county
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,150: / Line 1,237: @@
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
-   ?person bnwdt:P13 bnwd:Q29 . #select women who exhibited at RAI Meeting
+   ?person bnwdt:P16 ?signatory . #select women who were nominated for election to FSA
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
    ?person bnwdt:P29 ?residence . # select residences
@@ Line 1,161: / Line 1,248: @@
 </sparql>
-====Counties of residence for women recorded in CAS Indexes of Archaeological Papers, on a map====
+====Counties of residence for women nominated to RAI, sorted by how many residences all women had in that county====
 <sparql tryit="1">
+# Counties of residence for women nominated to RAI, sorted by how many residences all women had in that county
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,173: / Line 1,261: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Map{"hide":["?geo", "?wikidata"]}
+SELECT ?county ?countyLabel (count(?county) as ?county_count) #count number of counties in which women lived
-#title:Counties of residence for women recorded in CAS Indexes of Archaeological Papers
-SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
-   ?person bnwdt:P76 bnwd:Q419 . #select women recorded in CAS Indexes of Archaeological Papers
+   ?person bnwdt:P7 ?signatory . #select women who were nominated for election to RAI
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
    ?person bnwdt:P29 ?residence . # select residences
    ?residence bnwdt:P33 ?district . #select districts
    ?district bnwdt:P33 ?county . #select counties
-      optional { ?county bnwdt:P153 ?geo2 .  } # for geocoords added to BN
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
-      optional {
+GROUP BY ?county ?countyLabel
-       ?county bnp:P117 ?ws .  # wikidata id P117
+ORDER BY DESC(?county_count)
-         ?ws bnpq:P14 ?wikidata_url .
+</sparql>
-         BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata )
-      SERVICE <https://query.wikidata.org/sparql> {
-         optional {
-           ?wikidata wdt:P625 ?geo1 .
-                  BIND(geof:longitude(?geo1) AS ?long)
-                  BIND(geof:latitude(?geo1)  AS ?lat)
-                } # geocoords if available
-       } # /wikidata service
-       } #/wikidata optional
-    BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
+====Counties of residence for women who spoke at RAI meetings, sorted by how many residences all women had in that county====
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-</sparql>
-====Counties of residence for women nominated as FSAs, on a map====
 <sparql tryit="1">
+# Counties of residence for women who spoke at RAI meetings, sorted by how many residences all women had in that county
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,219: / Line 1,288: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Map{"hide":["?geo", "?wikidata"]}
+SELECT ?county ?countyLabel (count(?county) as ?county_count) #count number of counties in which women lived
-#title:Counties of residence for women nominated as FSAs
-SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
-   ?person bnwdt:P16 ?signatory . #select women who were nominated for election to FSA
+   ?person bnwdt:P23 bnwd:Q29 . #select women who spoke at RAI Meeting
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
    ?person bnwdt:P29 ?residence . # select residences
    ?residence bnwdt:P33 ?district . #select districts
    ?district bnwdt:P33 ?county . #select counties
-      optional { ?county bnwdt:P153 ?geo2 .  } # for geocoords added to BN
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
-      optional {
+GROUP BY ?county ?countyLabel
-       ?county bnp:P117 ?ws .  # wikidata id P117
+ORDER BY DESC(?county_count)
-         ?ws bnpq:P14 ?wikidata_url .
+</sparql>
-         BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata )
+====Counties of residence for women who exhibited at RAI meetings, sorted by how many residences all women had in that county====
-      SERVICE <https://query.wikidata.org/sparql> {
+<sparql tryit="1">
-         optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available
+# Counties of residence for women who exhibited at RAI meetings, sorted by how many residences all women had in that county
-       } # /wikidata service
-       } #/wikidata optional
+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/>
-    BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
+SELECT ?county ?countyLabel (count(?county) as ?county_count) #count number of counties in which women lived
+WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . # select women
+  ?person bnwdt:P13 bnwd:Q29 . #select women who exhibited at RAI Meeting
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?person bnwdt:P29 ?residence . # select residences
+  ?residence bnwdt:P33 ?district . #select districts
+   ?district bnwdt:P33 ?county . #select counties
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
+GROUP BY ?county ?countyLabel
+ORDER BY DESC(?county_count)
 </sparql>
+====Counties of residence for women recorded in CAS Indexes of Archaeological Papers, on a map====
-==== Counties of residence for women nominated to RAI, on a map ====
+<sparql tryit="1">
-<sparql tryit="1">
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,263: / Line 1,342: @@
 #defaultView:Map{"hide":["?geo", "?wikidata"]}
-#title:Counties of residence for women nominated to RAI
+#title:Counties of residence for women recorded in CAS Indexes of Archaeological Papers
-SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
+SELECT distinct ?person ?personLabel ?residence ?residenceLabel ?county ?countyLabel ?wikidata ?geo
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
+  ?person bnwdt:P76 bnwd:Q419 . #select women recorded in CAS Indexes of Archaeological Papers
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-   ?person bnwdt:P7 ?signatory . #select women who were nominated for election to RAI
+   ?person bnwdt:P29 ?residence . # select residences
-  ?person bnwdt:P29 ?residence . # select residences
+   ?residence bnwdt:P33 ?district . #select p33 of residence
-   ?residence bnwdt:P33 ?district . #select districts
+   ?district bnwdt:P33 ?next . #select p33 of district, mostly counties but a few region/outside uk
-   ?district bnwdt:P33 ?county . #select counties
-      optional { ?county bnwdt:P153 ?geo2 .  } # for geocoords added to BN
-       optional {
+  optional {
+    # is ?next a uk region?
+    ?next bnwdt:P12 bnwd:Q4207 .
+    BIND(BOUND(?next) AS ?region).
+    }
+  optional {
+    # is ?next in the UK?
+    ?next bnwdt:P33* bnwd:Q1741 .
+    BIND(BOUND(?next) AS ?uk).
+    }
+  # if next=q4207 uk region, then use ?district for county, ifelse in uk use ?next, else not in uk use ?district.
+  bind(
+       if( bound(?region), ?district, # region first (because also uk)
+        if( bound(?uk), ?next, # then rest of uk
+       ?district)) # then anything not in uk.
+    as ?county).
+    optional { ?county bnwdt:P153 ?geo2 .  } # for geocoords added to BN
+    optional {
         ?county bnp:P117 ?ws .  # wikidata id P117
           ?ws bnpq:P14 ?wikidata_url .
@@ Line 1,283: / Line 1,381: @@
        SERVICE <https://query.wikidata.org/sparql> {
-          optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available
+          optional {
+           ?wikidata wdt:P625 ?geo1 .
+                  BIND(geof:longitude(?geo1) AS ?long)
+                  BIND(geof:latitude(?geo1)  AS ?lat)
+                } # geocoords if available
         } # /wikidata service
         } #/wikidata optional
@@ Line 1,293: / Line 1,395: @@
 </sparql>
-==== Counties of residence for women who spoke at RAI meetings, on a map====
+====Counties of residence for women nominated as FSAs, on a map====
 <sparql tryit="1">
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,305: / Line 1,408: @@
 #defaultView:Map{"hide":["?geo", "?wikidata"]}
-#title:Counties of residence for women who spoke at RAI meetings
+#title:Counties of residence for women nominated as FSAs
 SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
+  ?person bnwdt:P16 ?signatory . #select women who were nominated for election to FSA
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-   ?person bnwdt:P23 bnwd:Q29 . #select women who spoke at RAI Meeting
    ?person bnwdt:P29 ?residence . # select residences
@@ Line 1,333: / Line 1,436: @@
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
+</sparql>
-</sparql>
-==== Counties of residence for women who exhibited at RAI meetings, on a map ====
+==== Counties of residence for women nominated to RAI, on a map ====
 <sparql tryit="1">
-#title:Counties of residence for women who exhibited at RAI meetings
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,350: / Line 1,451: @@
 #defaultView:Map{"hide":["?geo", "?wikidata"]}
+#title:Counties of residence for women nominated to RAI
 SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
@@ Line 1,355: / Line 1,457: @@
    ?person bnwdt:P3 bnwd:Q3 . # select women
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-   ?person bnwdt:P13 bnwd:Q29 . #select women who exhibited at RAI Meeting
+   ?person bnwdt:P7 ?signatory . #select women who were nominated for election to RAI
    ?person bnwdt:P29 ?residence . # select residences
@@ Line 1,379: / Line 1,481: @@
 </sparql>
-==== Counties of residence for women in any of the above five categories, mapped====
+==== Counties of residence for women who spoke at RAI meetings, on a map====
 <sparql tryit="1">
-## IMPORTANT: LIMITATIONS OF THE MAP
-## Only the top category of activity (layer) can be seen when all are selected (the default)
-## To see each layer, you need to deselect all in the layers menu (diamond shaped icon, top right corner of the map) and view one layer at a time. Unfortunately this is the only way to compare them at the moment.
-## (But I'll look into how I might be able to improve on this)
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,396: / Line 1,492: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#title:Counties of residence for women who were nominated for election or had publications recorded or spoke/exhibited at RAI
 #defaultView:Map{"hide":["?geo", "?wikidata"]}
+#title:Counties of residence for women who spoke at RAI meetings
-SELECT distinct  ?county ?countyLabel ?wikidata ?geo  ?layer  #?person ?personLabel
+SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+   ?person bnwdt:P23 bnwd:Q29 . #select women who spoke at RAI Meeting
-  {
-    #women who were nominated for election to FSA | RAI
-    ?person ( bnp:P16 | bnp:P7 ) ?stmt .
-  }
-  union
-  {
-    # women with publications recorded in indexes of archaeological papers
-    ?person bnp:P76 ?stmt .
-        ?stmt bnps:P76 bnwd:Q419 .
-  }
-  union
-  {
-    # women who spoke|exhibited at RAI Meeting
-    ?person (bnp:P23 | bnp:P13) ?stmt .
-       ?stmt (bnps:P23 | bnps:P13) bnwd:Q29 .
-  }
-  # get the p labels for layers
-  ?person ?p ?stmt .
-  ?claim wikibase:claim ?p;
-        rdfs:label ?layer. filter(lang(?layer)="en-gb").
-  # get geo stuff
    ?person bnwdt:P29 ?residence . # select residences
    ?residence bnwdt:P33 ?district . #select districts
@@ Line 1,438: / Line 1,512: @@
        SERVICE <https://query.wikidata.org/sparql> {
           optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available
         } # /wikidata service
         } #/wikidata optional
-     BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use it, if not try geo2
+     BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-order by ?layer
 </sparql>
-===Regions in which women resided, sorted by how many residences all women had in that region===
+==== Counties of residence for women who exhibited at RAI meetings, on a map ====
 <sparql tryit="1">
-# Regions in which women resided, sorted by how many residences all women had in that region
+#title:Counties of residence for women who exhibited at RAI meetings
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,461: / Line 1,537: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?region ?regionLabel (count(?region) as ?region_count) #count number of regions in which women lived
+#defaultView:Map{"hide":["?geo", "?wikidata"]}
+SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?person bnwdt:P13 bnwd:Q29 . #select women who exhibited at RAI Meeting
    ?person bnwdt:P29 ?residence . # select residences
    ?residence bnwdt:P33 ?district . #select districts
    ?district bnwdt:P33 ?county . #select counties
-  ?county bnwdt:P33 ?region . #select region
+      optional { ?county bnwdt:P153 ?geo2 .  } # for geocoords added to BN
-   FILTER NOT EXISTS {?region bnwdt:P117 "Q145" .} #filter out UK (where UK is sub-region of NI)
+      optional {
+       ?county bnp:P117 ?ws .  # wikidata id P117
+         ?ws bnpq:P14 ?wikidata_url .
+         BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata )
+      SERVICE <https://query.wikidata.org/sparql> {
+         optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available
+       } # /wikidata service
+       } #/wikidata optional
+    BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-GROUP BY ?region ?regionLabel
-ORDER BY DESC(?region_count)
 </sparql>
+==== Counties of residence for women in any of the above five categories, mapped====
+<sparql tryit="1">
-=== Women living in London during the 1890s ===
+## IMPORTANT: LIMITATIONS OF THE MAP
+## Only the top category of activity (layer) can be seen when all are selected (the default)
+## To see each layer, you need to deselect all in the layers menu (diamond shaped icon, top right corner of the map) and view one layer at a time. Unfortunately this is the only way to compare them at the moment.
+## (But I'll look into how I might be able to improve on this)
-<sparql tryit="1">
-#title:Women living in 1890s London
-# Query for women living in (greater) london in the 1890s
-# 1 row per person per address per date, could be reduced to 1 row per person if preferred.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,491: / Line 1,584: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?personLabel ?date_label ?date ?person ?address ?address_item ?londonLabel ?geo ?long ?lat
+#title:Counties of residence for women who were nominated for election or had publications recorded or spoke/exhibited at RAI
+#defaultView:Map{"hide":["?geo", "?wikidata"]}
+SELECT distinct  ?county ?countyLabel ?wikidata ?geo  ?layer  #?person ?personLabel
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . # women
+   ?person bnwdt:P3 bnwd:Q3 . # select women
-   ?person bnp:P29 ?s .   # resided at
+   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-    ?s bnps:P29 ?london .
-      ?london bnwdt:P33+ bnwd:Q322 .  # in Q322 greater london.
+  {
+     #women who were nominated for election to FSA | RAI
-     # optional street address (text)
+     ?person ( bnp:P16 | bnp:P7 ) ?stmt .
-  optional {
+  }
-     ?s bnpq:P31 ?address .
+   union
-    }
+   {
-   # optional street address (item)
+    # women with publications recorded in indexes of archaeological papers
-   optional {
+     ?person bnp:P76 ?stmt .
-     ?s bnpq:P100 ?address_item .
+        ?stmt bnps:P76 bnwd:Q419 .
-    }
+  }
+  union
-   # dates. About 30? not dated.
+   {
-     #optional {
+     # women who spoke|exhibited at RAI Meeting
-     ?s ?pq ?date .
+     ?person (bnp:P23 | bnp:P13) ?stmt .
-     # ?date wikibase:timeValue ?date_value. # if you don't want date label this should work instead
+       ?stmt (bnps:P23 | bnps:P13) bnwd:Q29 .
+  }
-      ?qual_prop wikibase:qualifier ?pq;
-              wikibase:propertyType wikibase:Time ; # nb excludes edtf dates
+  # get the p labels for layers
-              rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # what kind of date is it.
+  ?person ?p ?stmt .
-    #  } # /dates
+  ?claim wikibase:claim ?p;
+        rdfs:label ?layer. filter(lang(?layer)="en-gb").
-    # filter 1890-1899
+  # get geo stuff
-   FILTER("1890-01-01"^^xsd:dateTime <= ?date && ?date < "1899-12-31"^^xsd:dateTime).
+  ?person bnwdt:P29 ?residence . # select residences
+  ?residence bnwdt:P33 ?district . #select districts
+   ?district bnwdt:P33 ?county . #select counties
+      optional { ?county bnwdt:P153 ?geo2 .  } # for geocoords added to BN
+      optional {
+       ?county bnp:P117 ?ws .  # wikidata id P117
+         ?ws bnpq:P14 ?wikidata_url .
+         BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata )
-  # address geocoordinates
+      SERVICE <https://query.wikidata.org/sparql> {
-   optional {
+         optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available
-     ?s ?pqq ?geo .
+       } # /wikidata service
-        ?qual_geo wikibase:qualifier ?pqq;
+       } #/wikidata optional
-                  wikibase:propertyType wikibase:GlobeCoordinate.
-         BIND(geof:longitude(?geo) AS ?long)
-         BIND(geof:latitude(?geo)  AS ?lat)
-             }
-  # todo booth codes
+    BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use it, if not try geo2
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-ORDER BY ?person ?date
+order by ?layer
 </sparql>
-==== Map of Women living in 1890s London ====
+===Regions in which women resided, sorted by how many residences all women had in that region===
 <sparql tryit="1">
-#title:Women living in 1890s London
+# Regions in which women resided, sorted by how many residences all women had in that region
-# Query for women living in (greater) london in the 1890s
-# 1 row per person per address per date, could be reduced to 1 row per person if preferred.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,553: / Line 1,649: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Map
+SELECT ?region ?regionLabel (count(?region) as ?region_count) #count number of regions in which women lived
-SELECT distinct ?personLabel ?date_label ?date ?person ?address ?address_item ?londonLabel ?geo ?long ?lat
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . # women
+  ?person bnwdt:P3 bnwd:Q3 . # select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?person bnwdt:P29 ?residence . # select residences
+  ?residence bnwdt:P33 ?district . #select districts
+  ?district bnwdt:P33 ?county . #select counties
+  ?county bnwdt:P33 ?region . #select region
+  FILTER NOT EXISTS {?region bnwdt:P117 "Q145" .} #filter out UK (where UK is sub-region of NI)
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+GROUP BY ?region ?regionLabel
+ORDER BY DESC(?region_count)
+</sparql>
+=== Women living in London during the 1890s ===
+<sparql tryit="1">
+#title:Women living in 1890s London
+# Query for women living in (greater) london in the 1890s
+# 1 row per person per address per date, could be reduced to 1 row per person if preferred.
+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/>
+SELECT distinct ?personLabel ?date_label ?date ?person ?address ?address_item ?londonLabel ?geo ?long ?lat
+WHERE {
+   ?person bnwdt:P3 bnwd:Q3 . # women
    ?person bnp:P29 ?s .   # resided at
      ?s bnps:P29 ?london .
@@ Line 1,599: / Line 1,724: @@
 }
 ORDER BY ?person ?date
 </sparql>
-=== Where did women who published in Folklore/Folk-lore Record live? ===
+==== Map of Women living in 1890s London ====
 <sparql tryit="1">
-# Map of all places of residence for women who had publications in Folklore/Folk-lore Record
+#title:Women living in 1890s London
+# Query for women living in (greater) london in the 1890s
+# 1 row per person per address per date, could be reduced to 1 row per person if preferred.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,613: / Line 1,741: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Map{"hide":["?geo", "?count"]}
+#defaultView:Map
+SELECT distinct ?personLabel ?date_label ?date ?person ?address ?address_item ?londonLabel ?geo ?long ?lat
-SELECT  ?person ?personLabel ?residenceLabel ?residence ?geo (count( ?person) as ?count)  #(concat(str(?count), " publication") as ?count_lbl)
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . # select women
+   ?person bnwdt:P3 bnwd:Q3 . # women
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+   ?person bnp:P29 ?s .   # resided at
-  ?person bnwdt:P76 bnwd:Q419 . # people with publications listed in indexes of archaeological papers. [262]
+    ?s bnps:P29 ?london .
-   ?person bnp:P76 ?s .
+       ?london bnwdt:P33+ bnwd:Q322 .  # in Q322 greater london.
-   ## works published in P101. folklore / folk-lore record q487 q490
-      ?s bnpq:P101 ?in .
-       {?s bnpq:P101 bnwd:Q487 } union { ?s bnpq:P101 bnwd:Q490 . }
-      # why does above pick up these two journals as well?
-      FILTER ( ?in not in ( bnwd:Q665 , bnwd:Q636 ) ) .
-  ?person bnwdt:P29  ?residence .
-      optional { ?residence bnwdt:P153 ?geo2 .  } # for geocoords added to BN
-   optional {
+    # optional street address (text)
+  optional {
-       ?residence bnp:P117 ?ws .  # wikidata id P117
+    ?s bnpq:P31 ?address .
+    }
-         ?ws bnpq:P14 ?wikidata_url .
+  # optional street address (item)
-         BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata )
+  optional {
+    ?s bnpq:P100 ?address_item .
-       SERVICE <https://query.wikidata.org/sparql> {
+    }
-       optional {?wikidata wdt:P625 ?geo1 .  } # geocoords if available
+  # dates. About 30? not dated.
+    #optional {
-      } # /wikidata service
+    ?s ?pq ?date .
-    } #/wikidata optional
+     # ?date wikibase:timeValue ?date_value. # if you don't want date label this should work instead
+      ?qual_prop wikibase:qualifier ?pq;
+              wikibase:propertyType wikibase:Time ; # nb excludes edtf dates
+              rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # what kind of date is it.
+    #  } # /dates
+    # filter 1890-1899
+  FILTER("1890-01-01"^^xsd:dateTime <= ?date && ?date < "1899-12-31"^^xsd:dateTime).
+  # address geocoordinates
+   optional {
+     ?s ?pqq ?geo .
+        ?qual_geo wikibase:qualifier ?pqq;
+                  wikibase:propertyType wikibase:GlobeCoordinate.
+         BIND(geof:longitude(?geo) AS ?long)
+         BIND(geof:latitude(?geo)  AS ?lat)
+             }
+   # todo booth codes
-    BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-group by ?person ?personLabel ?residenceLabel ?residence ?geo
+ORDER BY ?person ?date
-ORDER BY ?geo
 </sparql>
+=== Where did women who published in Folklore/Folk-lore Record live? ===
-=== BN people and other things located near Devizes ===
 <sparql tryit="1">
-## testing use of geof:distance
+# Map of all places of residence for women who had publications in Folklore/Folk-lore Record
-#title:BN items located within 30 km of Devizes, Wiltshire
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,666: / Line 1,800: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Map
-SELECT distinct ?item ?itemLabel ?locationLabel ?location ?wikidata ?wd_geo ?wd_long ?wd_lat
+#defaultView:Map{"hide":["?geo", "?count"]}
+SELECT  ?person ?personLabel ?residenceLabel ?residence ?geo (count( ?person) as ?count)  #(concat(str(?count), " publication") as ?count_lbl)
 WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . # select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?person bnwdt:P76 bnwd:Q419 . # people with publications listed in indexes of archaeological papers. [262]
+  ?person bnp:P76 ?s .
-   {?item bnwdt:P29  ?location . } # resided at location
+   ## works published in P101. folklore / folk-lore record q487 q490
-  #union
+      ?s bnpq:P101 ?in .
-  #{?location bnwdt:P12 bnwd:Q2147 .} # OR location has instance of locality. is there a way to get this in the same structure?
+      {?s bnpq:P101 bnwd:Q487 } union { ?s bnpq:P101 bnwd:Q490 . }
-  union
+      # why does above pick up these two journals as well?
-  {?item bnwdt:P2  ?location . } # item has property P2 location
+      FILTER ( ?in not in ( bnwd:Q665 , bnwd:Q636 ) ) .
-  # any other possibles ?
-   ## limit to places in admin territory p33 england q617. (keep numbers down to avoid wikidata timing out)
+   ?person bnwdt:P29  ?residence .
-  ?location bnwdt:P33+ bnwd:Q617.
+      optional { ?residence bnwdt:P153 ?geo2 .  } # for geocoords added to BN
-  ?location bnwdt:P117 ?ws .  # wikidata id
+   optional {
+       ?residence bnp:P117 ?ws .  # wikidata id P117
+         ?ws bnpq:P14 ?wikidata_url .
+         BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata )
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
+       SERVICE <https://query.wikidata.org/sparql> {
-         SERVICE <https://query.wikidata.org/sparql> {
-             wd:Q1026699 wdt:P625 ?start. # devizes coordinates
+       optional {?wikidata wdt:P625 ?geo1 .  } # geocoords if available
-             ?wikidata wdt:P625 ?wd_geo .
-                      #BIND(geof:longitude(?wd_geo) AS ?wd_long) .
+      } # /wikidata service
-                      #BIND(geof:latitude(?wd_geo)  AS ?wd_lat) .
+    } #/wikidata optional
-              FILTER(geof:distance(?wd_geo, ?start) < 30). # < 30 km from ?start.
-         } # /wikidata service
+    BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+group by ?person ?personLabel ?residenceLabel ?residence ?geo
+ORDER BY ?geo
+</sparql>
+=== BN people and other things located near Devizes ===
+<sparql tryit="1">
+## testing use of geof:distance
+#title:BN items located within 30 km of Devizes, Wiltshire
+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/>
+#defaultView:Map
+SELECT distinct ?item ?itemLabel ?locationLabel ?location ?wikidata ?wd_geo ?wd_long ?wd_lat
+WHERE {
+  {?item bnwdt:P29  ?location . } # resided at location
+  #union
+  #{?location bnwdt:P12 bnwd:Q2147 .} # OR location has instance of locality. is there a way to get this in the same structure?
+  union
+  {?item bnwdt:P2  ?location . } # item has property P2 location
+  # any other possibles ?
+  ## limit to places in admin territory p33 england q617. (keep numbers down to avoid wikidata timing out)
+  ?location bnwdt:P33+ bnwd:Q617.
+  ?location bnwdt:P117 ?ws .  # wikidata id
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
+         SERVICE <https://query.wikidata.org/sparql> {
+             wd:Q1026699 wdt:P625 ?start. # devizes coordinates
+             ?wikidata wdt:P625 ?wd_geo .
+                      #BIND(geof:longitude(?wd_geo) AS ?wd_long) .
+                      #BIND(geof:latitude(?wd_geo)  AS ?wd_lat) .
+              FILTER(geof:distance(?wd_geo, ?start) < 30). # < 30 km from ?start.
+         } # /wikidata service
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
 ORDER BY ?locationLabel
@@ Line 1,969: / Line 2,157: @@
 </sparql>
-==People==
+=== IWD 2024 Map of five women's places ===
-===Women with their family name at birth and family name after marriage===
 <sparql tryit="1">
-# Women with their family name at birth and family name after marriage
+## how many places for the five women can I get on a map? a slightly ridiculous query.
+#title:Four stories, five women, many places for #IWD2024
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,984: / Line 2,171: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+#defaultView:Map{"hide":["?geo"],"layer":"?person", "markercluster":true }
+SELECT distinct ?person ?personLabel  ?propLabel ?placeLabel  ?geo  ?loc2Label (year(?date) as ?year)
-SELECT ?person ?personLabel ?birthname ?marriedname
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . #select women
-   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+   VALUES (?person) {(bnwd:Q894) (bnwd:Q462) (bnwd:Q549) (bnwd:Q921) (bnwd:Q1053) }  #
-   OPTIONAL {?person bnwdt:P140 ?birthname .} #look for birth name
+   ?person ( bnp:P29 | bnp:P94  | bnp:P23 | bnp:P13 | bnp:P120   ) ?s .
-   OPTIONAL {?person bnwdt:P141 ?marriedname .} #look for married name
+   ?s  ( bnps:P29 | bnps:P94  | bnps:P23 | bnps:P13 | bnps:P120   )  ?place .
+   ?person ?p ?s .
+      ?prop wikibase:claim ?p;
+         wikibase:statementProperty ?ps.
+      optional { ?s ( bnpq:P1 | bnpq:P27 ) ?date . }
+      #optional { ?s bnpq:P31 ?street . }
+  # LOLplaces
+  #1 geocoords in quals for place itself - should be detailed geo added manually, cf London district geocoords which =main P153
+  #2 wikdiata geocoords for place
+  #3 geocoords in quals for linked place
+  #4 wikidata geocoords for linked place
+  #5 wikidata geocoords in place P2 qual
+  #6 `of` qual geocoords
+  #7 `of` P2 wikidata geocoords
+  #8 `of` wikidata geocoords
+  #9 place main geocoords - likely to be broad london postal districts so should be last resort
+  #10 linked place main geocoords
+      optional { ?s bnpq:P153 ?geo1 . } # place has geocoords directly *in qualifier*
+      optional { ?place bnwdt:P2 ?linked_p1 . # linked place has geocoords *in qualifier* (this is primarily for SAL?)
+                     ?linked_p1 bnp:P2 ?llp_s .
+                        ?llp_s bnps:P2 ?llp_p1.
+                        ?llp_s bnpq:P153 ?geo2 .
+                }
+      optional { ?place bnwdt:P117 ?pws .  # place has wikidata page that has geoocords (main P625, not anywhere else)
+                   bind(iri(concat("http://www.wikidata.org/entity/", str(?pws))) as ?pwikidata) .
+                   SERVICE <https://query.wikidata.org/sparql> {
+                     ?pwikidata wdt:P625 ?geo3 .
+                  }
+                }
+      optional { ?place bnwdt:P2 ?linked_p2 .  # linked place has wikidata geocoords
+                    ?linked_p2 bnwdt:P117 ?lws .  # wikidata id P117
+                     bind(iri(concat("http://www.wikidata.org/entity/", str(?lws))) as ?lwikidata) .
+                     SERVICE <https://query.wikidata.org/sparql> {
+                      ?lwikidata wdt:P625 ?geo4 .
+                     }
+                }
+      optional { ?s bnpq:P2 ?qp1 . # P2 qualifier location has wikidata geocoords
+                     ?qp1 bnwdt:P117 ?qws .
+                     bind(iri(concat("http://www.wikidata.org/entity/", str(?qws))) as ?qwikidata) .
+                     SERVICE <https://query.wikidata.org/sparql> {
+                      ?qwikidata wdt:P625 ?geo5 .
+                     }
+                 }
+      optional { ?s bnpq:P78 ?ofp1 . # 'of' (organisation) has geocoords in P2 qualifier
+                    ?ofp1 bnp:P2 ?ofp1_s .
+                     ?ofp1_s bnps:P2 ?ofp1_p .
+                     ?ofp1_s bnpq:P153 ?geo6 . }
+      optional { ?s bnpq:P78 ?ofp2 . # 'of' (organisation) P2 location has wikidata geocoords
+                    ?ofp2 bnwdt:P2 ?ofp2_p .
+                       ?ofp2_p bnwdt:P117 ?ofl2ws .
+                       bind(iri(concat("http://www.wikidata.org/entity/", str(?ofl2ws))) as ?ofl2wikidata) .
+                       SERVICE <https://query.wikidata.org/sparql> {
+                      ?ofl2wikidata wdt:P625 ?geo7 .  }
+              }
+      optional { ?s bnpq:P78 ?ofp3 .   # 'of' (organisation) has wikidata geocoords
+                    ?ofp3 bnwdt:P117 ?ofpws .  # wikidata id P117
+                     bind(iri(concat("http://www.wikidata.org/entity/", str(?ofpws))) as ?ofpwikidata) .
+                     SERVICE <https://query.wikidata.org/sparql> {
+                      ?ofpwikidata wdt:P625 ?geo8 .  }
+                }
+      optional { ?place bnwdt:P153 ?geo9 .  } # main geocoords  (mainly london postal districts - should be last resort as v broad.)
+      optional { ?place bnwdt:P2 ?linked_p10 . # linked place main geocoords
+                     ?linked_p10 bnwdt:P153 ?geo10 .
+                }
+  BIND(COALESCE(?geo1, ?geo2, ?geo3, ?geo4, ?geo5, ?geo6, ?geo7, ?geo8, ?geo9, ?geo10) AS ?geo).  # if geo1 available use that, then geo2, etc, in order of preference
+  bind(coalesce(?linked_p1, ?linked_p2, ?qp1, ?ofp1, ?ofp2, ?ofp3 ) as ?loc2). # hopefully get extra context where place is just sthg like "meeting". though exactly what will be variable!
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
 }
-ORDER BY ?personLabel
+order by ?personLabel ?date ?placeLabel
 </sparql>
-=== Women with family name at birth, married name and count of married names===
+=== Wikidata categories for BN instance of locality in the UK ===
 <sparql tryit="1">
-# Women with their family name at birth, family name after marriage and count of married names
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,009: / Line 2,281: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
+#title: counts of WD instance of (P31) for BN localities (instance of Q2147) in the UK
-SELECT ?person ?personLabel ?birthname
+select ?wd_io ?wd_io_label  (count(*) as ?count)
-        (GROUP_CONCAT(DISTINCT ?marriedname; SEPARATOR=", ") AS ?marriednames)
-        (COUNT(?marriedname) AS ?marriedcount)
+where {
-WHERE {
+   ?item bnwdt:P12 bnwd:Q2147 . # BN io locality
-   ?person bnwdt:P3 bnwd:Q3 . #select women
+   ?item bnwdt:P33* bnwd:Q1741 . # in UK
-   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-   OPTIONAL {?person bnwdt:P140 ?birthname .} #look for birth name
+   ?item bnwdt:P117 ?wd.
-  OPTIONAL {?person bnwdt:P141 ?marriedname .} #look for married name
+      bind(iri(concat("http://www.wikidata.org/entity/", str(?wd))) as ?wikidata) .
+      SERVICE <https://query.wikidata.org/sparql> {
+          ?wikidata wdt:P31 ?wd_io.
+              ## p31 Q48091 region of england.
+            SERVICE wikibase:label { bd:serviceParam wikibase:language "en".
+                                    ?wikidata rdfs:label ?wd_label .
+                                    ?wd_io rdfs:label ?wd_io_label .
+                                   }
+        }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
-group by ?person ?personLabel ?birthname
+group by ?wd_io ?wd_io_label
-ORDER BY ?personLabel
+order by ?wd_io_label
 </sparql>
-===Where women in our data are in wikidata, their spouses, fathers, and mothers according to wikidata===
+=== Localities not in the UK ===
 <sparql tryit="1">
+##admin_paths lists the linked P33 for the item. Unfortunately, they aren't reliably returned in ascending order.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,037: / Line 2,320: @@
 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/>
+#title:localities not in the UK
-PREFIX wd:  <http://www.wikidata.org/entity/>
-SELECT ?person ?personLabel ?item ?WD_spouse ?WD_father ?WD_mother
+select  ?item ?itemLabel (group_concat(distinct ?admin_label; separator=", " ) as ?admin_path)
-WHERE {
+where {
-   ?person bnwdt:P3 bnwd:Q3 . #select women
+   ?item bnwdt:P12 bnwd:Q2147 . # i/o locality
-   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+   ?item bnwdt:P33* ?admin.
-  ?person bnp:P117 ?wikidata_ID . #look for wikidata ID on person page
+    ?admin rdfs:label ?admin_label. filter(lang(?admin_label)="en") .
-  ?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> {
+   filter not exists { ?item bnwdt:P33* bnwd:Q1741.  } # filter out anything in the UK
-        ?item wdt:P21 ?WD_gender. #get gender of person
+  filter (?item not in (bnwd:Q619, bnwd:Q2961, bnwd:Q4207, bnwd:Q86) ). # and a few things that are not specific places
-        OPTIONAL {?item wdt:P22 ?WD_father . } #recall father
-        OPTIONAL {?item wdt:P25 ?WD_mother . } #recall mother
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-        OPTIONAL {?item wdt:P26 ?WD_spouse . } #recall spouse
-      }
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-ORDER BY ?personLabel
+group by ?item ?itemLabel
-# with thanks to @tagishsimon for writing this one initially!
+order by ?itemLabel
 </sparql>
-===Women in our data alongside counts of their public and professional activities, sorted by total===
+==People==
+===Women with their family name at birth and family name after marriage===
 <sparql tryit="1">
-## Women in our data alongside counts of their public and professional activities (https://beyond-notability.wikibase.cloud/wiki/Item:Q151)
+# Women with their family name at birth and family name after marriage
-## Sorted by total PPAs
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 2,075: / Line 2,352: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-select ?person ?personLabel
-(count(distinct ?exhibitor) as ?exhibitions)
-(count(distinct ?position) as ?positions)
-(count(distinct ?speaker) as ?spoke)
-(count(distinct ?attended) as ?attendance)
-(count(distinct ?donorof) as ?donated)
-(count(distinct ?wasdelegate) as ?delegate)
-(count(distinct ?correspondent) as ?correspondents)
-(count(distinct ?fellow) as ?fellowships)
-(count(distinct ?collab) as ?collaborations)
-(count(distinct ?found) as ?founded)
-(count(distinct ?loaned) as ?loans)
-(count(distinct ?illustrated) as ?illustrations)
-(count(distinct ?sold) as ?sales)
-(count(distinct ?served) as ?service)
-(count(distinct ?job) as ?employed)
-(count(distinct ?fundraiser) as ?fundraisers)
-(count(distinct ?publish) as ?published)
-(count(distinct ?benefact) as ?benefactor)
-(count(distinct ?donor) as ?donor_to)
-(count(distinct ?collect) as ?collected)
-(count(distinct ?performance) as ?performances)
-((?exhibitions + ?positions + ?spoke + ?attendance + ?donated + ?delegate + ?correspondents + ?fellowships + ?collaborations + ?founded + ?loans + ?illustrations + ?sales
- + ?service + ?employed + ?fundraisers + ?published + ?benefactor + ?donor_to + ?collected + ?performances) AS ?PPA_total)
-where
-{
-  ?person bnwdt:P3 bnwd:Q3 .
-  optional { ?person bnp:P13 ?exhibitor }
-  optional { ?person bnp:P17 ?position }
-  optional { ?person bnp:P23 ?speaker }
-  optional { ?person bnp:P24 ?attended }
-  optional { ?person bnp:P65 ?donorof }
-  optional { ?person bnp:P71 ?wasdelegate }
-  optional { ?person bnp:P73 ?correspondent }
-  optional { ?person bnp:P75 ?fellow }
-  optional { ?person bnp:P83 ?collab }
-  optional { ?person bnp:P85 ?found }
-  optional { ?person bnp:P87 ?loaned }
-  optional { ?person bnp:P89 ?illustrated }
-  optional { ?person bnp:P99 ?sold }
-  optional { ?person bnp:P102 ?served }
-  optional { ?person bnp:P105 ?job }
-  optional { ?person bnp:P106 ?fundraiser }
-  optional { ?person bnp:P107 ?publish }
-  optional { ?person bnp:P110 ?benefact }
-  optional { ?person bnp:P111 ?donor }
-  optional { ?person bnp:P114 ?collect }
-  optional { ?person bnp:P120 ?performance }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-group by ?person ?personLabel
-ORDER BY DESC (?PPA_total)
-</sparql>
-===Women in our data arranged as a network graph by the organisations they were members of===
-<sparql tryit="1">
-## Women in our data arranged as a network graph by the organisations they were members of
-#defaultView:Graph
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-SELECT  ?org ?orgLabel ?rgb ?linkTo ?linkToLabel
-WHERE {
-  ?linkTo bnwdt:P3 bnwd:Q3 .                                #select women
-  FILTER NOT EXISTS {?linkTo bnwdt:P4 bnwd:Q12 .}          #filter out project team
-  ?linkTo bnwdt:P67 ?org
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
-  BIND( "7C4DCD" AS ?rgb ) .
+SELECT ?person ?personLabel ?birthname ?marriedname
+WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . #select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  OPTIONAL {?person bnwdt:P140 ?birthname .} #look for birth name
+  OPTIONAL {?person bnwdt:P141 ?marriedname .} #look for married name
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
 ORDER BY ?personLabel
 </sparql>
-===Membership of organisations by women, sorted by how many women were members of a given organisation===
+=== Women with family name at birth, married name and count of married names===
 <sparql tryit="1">
-# Membership of organisations by women, sorted by how many women were members of a given organisation
+# Women with their family name at birth, family name after marriage and count of married names
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 2,162: / Line 2,378: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?organisation ?organisationLabel (count(?organisation) as ?organisation_count) #count number of organisations that women were members of
+SELECT ?person ?personLabel ?birthname
+        (GROUP_CONCAT(DISTINCT ?marriedname; SEPARATOR=", ") AS ?marriednames)
+        (COUNT(?marriedname) AS ?marriedcount)
 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
-   ?person bnwdt:P67 ?organisation . # selection people who were members of organisations and what those organisations were
-   FILTER NOT EXISTS {?person bnwdt:P67 bnwd:Q35 .} # filter out Royal Archaeological Institute
+  OPTIONAL {?person bnwdt:P140 ?birthname .} #look for birth name
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+   OPTIONAL {?person bnwdt:P141 ?marriedname .} #look for married name
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
-GROUP BY ?organisation ?organisationLabel
+group by ?person ?personLabel ?birthname
-ORDER BY DESC(?organisation_count)
+ORDER BY ?personLabel
 </sparql>
+===Where women in our data are in wikidata, their spouses, fathers, and mothers according to wikidata===
-==Education==
-===Women educated at a tertiary educational institution located in Oxford or Cambridge===
 <sparql tryit="1">
-# Women educated at a tertiary educational institution located in Oxford or Cambridge
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,190: / Line 2,405: @@
 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 ?woman ?womanLabel ?educationalinstitution ?educationalinstitutionLabel ?location ?locationLabel
+SELECT ?person ?personLabel ?item ?WD_spouse ?WD_father ?WD_mother
 WHERE {
-   {?woman bnwdt:P3 bnwd:Q3 . #filter women
+   ?person bnwdt:P3 bnwd:Q3 . #select women
-   ?woman bnwdt:P94 ?educationalinstitution . #find 'educated at' statement
+   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-  ?educationalinstitution bnwdt:P12 bnwd:Q2914 . #filter to tertiary educational institutions
+   ?person bnp:P117 ?wikidata_ID . #look for wikidata ID on person page
-   ?educationalinstitution bnwdt:P2 ?location . #find location of educational institution
+   ?wikidata_ID bnpq:P14 ?wikidata_url .
-   ?location rdfs:label ?locationLabel .
+   BIND(IRI(REPLACE(?wikidata_url,"https://www.wikidata.org/wiki/","http://www.wikidata.org/entity/")) as ?item )
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-   FILTER(LANG(?locationLabel) = "en") .
+   SERVICE <https://query.wikidata.org/sparql> {
-  FILTER(regex(?locationLabel, "oxford", "i")) .}
+        ?item wdt:P21 ?WD_gender. #get gender of person
-   UNION
+        OPTIONAL {?item wdt:P22 ?WD_father . } #recall father
-   {?woman bnwdt:P3 bnwd:Q3 . #filter women
+        OPTIONAL {?item wdt:P25 ?WD_mother . } #recall mother
-  ?woman bnwdt:P94 ?educationalinstitution . #find 'educated at' statement
+        OPTIONAL {?item wdt:P26 ?WD_spouse . } #recall spouse
-  ?educationalinstitution bnwdt:P12 bnwd:Q2914 . #filter to tertiary educational institutions
+      }
-  ?educationalinstitution bnwdt:P2 ?location . #find location of educational institution
-  ?location rdfs:label ?locationLabel .
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-   FILTER(LANG(?locationLabel) = "en") .
-  FILTER(regex(?locationLabel, "Cambridge$", "i")) .}
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
-ORDER BY ?womanLabel
+ORDER BY ?personLabel
+# with thanks to @tagishsimon for writing this one initially!
 </sparql>
+===Women in our data alongside counts of their public and professional activities, sorted by total===
-=== Women who were FSAs who went to Oxford or Cambridge colleges ===
 <sparql tryit="1">
-#how many women who were FSAs went to Oxford or Cambridge colleges?
+## Women in our data alongside counts of their public and professional activities (https://beyond-notability.wikibase.cloud/wiki/Item:Q151)
+## Sorted by total PPAs
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 2,228: / Line 2,442: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-SELECT ?person ?personLabel ?college ?collegeLabel ?universityLabel
+select ?person ?personLabel
-WHERE {
+(count(distinct ?exhibitor) as ?exhibitions)
-  ?person bnwdt:P3 bnwd:Q3 . #select women
+(count(distinct ?position) as ?positions)
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+(count(distinct ?speaker) as ?spoke)
+(count(distinct ?attended) as ?attendance)
-  ?person bnwdt:P75 bnwd:Q8. # only BN subjects having a FSA
+(count(distinct ?donorof) as ?donated)
+(count(distinct ?wasdelegate) as ?delegate)
-  # educated at (P94) part of (P4) cambridge (Q1181) oxford (Q364)
+(count(distinct ?correspondent) as ?correspondents)
+(count(distinct ?fellow) as ?fellowships)
+(count(distinct ?collab) as ?collaborations)
+(count(distinct ?found) as ?founded)
+(count(distinct ?loaned) as ?loans)
+(count(distinct ?illustrated) as ?illustrations)
+(count(distinct ?sold) as ?sales)
+(count(distinct ?served) as ?service)
+(count(distinct ?job) as ?employed)
+(count(distinct ?fundraiser) as ?fundraisers)
+(count(distinct ?publish) as ?published)
+(count(distinct ?benefact) as ?benefactor)
+(count(distinct ?donor) as ?donor_to)
+(count(distinct ?collect) as ?collected)
+(count(distinct ?performance) as ?performances)
+((?exhibitions + ?positions + ?spoke + ?attendance + ?donated + ?delegate + ?correspondents + ?fellowships + ?collaborations + ?founded + ?loans + ?illustrations + ?sales
+ + ?service + ?employed + ?fundraisers + ?published + ?benefactor + ?donor_to + ?collected + ?performances) AS ?PPA_total)
-   ?person bnwdt:P94 ?college .
+where
-   ?college bnwdt:P4 ?university .
+{
+   ?person bnwdt:P3 bnwd:Q3 .
-   FILTER ( ?university in ( bnwd:Q1181 , bnwd:Q364 ) )
+  optional { ?person bnp:P13 ?exhibitor }
+  optional { ?person bnp:P17 ?position }
-   SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".}
+  optional { ?person bnp:P23 ?speaker }
-}
+  optional { ?person bnp:P24 ?attended }
-order by ?personLabel ?collegeLabel
+  optional { ?person bnp:P65 ?donorof }
-</sparql>
+  optional { ?person bnp:P71 ?wasdelegate }
+  optional { ?person bnp:P73 ?correspondent }
-=== All women who went to tertiary education institutions and dates where available ===
+  optional { ?person bnp:P75 ?fellow }
+  optional { ?person bnp:P83 ?collab }
+  optional { ?person bnp:P85 ?found }
+  optional { ?person bnp:P87 ?loaned }
+  optional { ?person bnp:P89 ?illustrated }
+  optional { ?person bnp:P99 ?sold }
+  optional { ?person bnp:P102 ?served }
+  optional { ?person bnp:P105 ?job }
+  optional { ?person bnp:P106 ?fundraiser }
+  optional { ?person bnp:P107 ?publish }
+  optional { ?person bnp:P110 ?benefact }
+  optional { ?person bnp:P111 ?donor }
+  optional { ?person bnp:P114 ?collect }
+  optional { ?person bnp:P120 ?performance }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+}
+group by ?person ?personLabel
+ORDER BY DESC (?PPA_total)
+</sparql>
+===Women in our data arranged as a network graph by the organisations they were members of===
+<sparql tryit="1">
+## Women in our data arranged as a network graph by the organisations they were members of
+#defaultView:Graph
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+SELECT  ?org ?orgLabel ?rgb ?linkTo ?linkToLabel
+WHERE {
+   ?linkTo bnwdt:P3 bnwd:Q3 .                                #select women
+   FILTER NOT EXISTS {?linkTo bnwdt:P4 bnwd:Q12 .}          #filter out project team
+   ?linkTo bnwdt:P67 ?org
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
+  BIND( "7C4DCD" AS ?rgb ) .
+}
+ORDER BY ?personLabel
+</sparql>
+===Membership of organisations by women, sorted by how many women were members of a given organisation===
 <sparql tryit="1">
+# Membership of organisations by women, sorted by how many women were members of a given organisation
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,259: / Line 2,529: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
+SELECT ?organisation ?organisationLabel (count(?organisation) as ?organisation_count) #count number of organisations that women were members of
-SELECT ?person ?personLabel ?college ?collegeLabel ?university ?universityLabel ?date ?date_label
 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
+   ?person bnwdt:P67 ?organisation . # selection people who were members of organisations and what those organisations were
-  # note: academic degree is P59. possible extra info?
+  FILTER NOT EXISTS {?person bnwdt:P67 bnwd:Q35 .} # filter out Royal Archaeological Institute
-   ?person bnp:P94 ?s .  # educated at
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-    ?s bnps:P94 ?college .
-    optional {?college bnwdt:P4 ?university . } # a few ?college aren't part of (P4) a ?university
-   ?college bnwdt:P12 bnwd:Q2914 .   # tertiary ed inst
-  # dates.
-    optional {
-    ?s ?pq ?date .
-      ?qual_prop wikibase:qualifier ?pq;
-              wikibase:propertyType wikibase:Time ; # nb excludes edtf dates
-              rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # what kind of date is it.
-      } # /dates
-   SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".}
 }
-order by ?personLabel ?collegeLabel ?date
+GROUP BY ?organisation ?organisationLabel
+ORDER BY DESC(?organisation_count)
+</sparql>
-</sparql>
+==Education==
-=== Academic degrees ===
+===Women educated at a tertiary educational institution located in Oxford or Cambridge===
 <sparql tryit="1">
-# Fetch academic degrees for women, with date and conferring institution where available
+# Women educated at a tertiary educational institution located in Oxford or Cambridge
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,301: / Line 2,558: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT distinct ?person ?personLabel ?degree ?degreeLabel ?by ?byLabel ?date ?date_label
+SELECT ?woman ?womanLabel ?educationalinstitution ?educationalinstitutionLabel ?location ?locationLabel
+WHERE {
+  {?woman bnwdt:P3 bnwd:Q3 . #filter women
+  ?woman bnwdt:P94 ?educationalinstitution . #find 'educated at' statement
+  ?educationalinstitution bnwdt:P12 bnwd:Q2914 . #filter to tertiary educational institutions
+  ?educationalinstitution bnwdt:P2 ?location . #find location of educational institution
+  ?location rdfs:label ?locationLabel .
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+  FILTER(LANG(?locationLabel) = "en") .
+  FILTER(regex(?locationLabel, "oxford", "i")) .}
+  UNION
+  {?woman bnwdt:P3 bnwd:Q3 . #filter women
+  ?woman bnwdt:P94 ?educationalinstitution . #find 'educated at' statement
+  ?educationalinstitution bnwdt:P12 bnwd:Q2914 . #filter to tertiary educational institutions
+  ?educationalinstitution bnwdt:P2 ?location . #find location of educational institution
+  ?location rdfs:label ?locationLabel .
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+  FILTER(LANG(?locationLabel) = "en") .
+  FILTER(regex(?locationLabel, "Cambridge$", "i")) .}
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+}
+ORDER BY ?womanLabel
+</sparql>
+=== Women who were FSAs who went to Oxford or Cambridge colleges ===
+<sparql tryit="1">
+#how many women who were FSAs went to Oxford or Cambridge colleges?
+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 bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
+SELECT ?person ?personLabel ?college ?collegeLabel ?universityLabel
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . #select women
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-  # academic degree = P59.
+   ?person bnwdt:P75 bnwd:Q8. # only BN subjects having a FSA
-   ?person bnp:P59 ?s .
-    ?s bnps:P59 ?degree . # type of degree
-   # optional qualifiers for degree
+   # educated at (P94) part of (P4) cambridge (Q1181) oxford (Q364)
+  ?person bnwdt:P94 ?college .
+  ?college bnwdt:P4 ?university .
+  FILTER ( ?university in ( bnwd:Q1181 , bnwd:Q364 ) )
-  # P61 conferred by
-    optional { ?s bnpq:P61 ?by . }
-  # date with type
-    optional {
-    ?s ?pq ?date .
-      ?qual_prop wikibase:qualifier ?pq;
-              wikibase:propertyType wikibase:Time ; # nb excludes edtf dates
-              rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # kind of date
-      } # /dates
    SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".}
 }
-order by ?personLabel ?date ?degreeLabel
+order by ?personLabel ?collegeLabel
 </sparql>
-==IDs==
+=== All women who went to tertiary education institutions and dates where available ===
-===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===
 <sparql tryit="1">
@@ Line 2,344: / Line 2,627: @@
 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 bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX wd:  <http://www.wikidata.org/entity/>
+PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
+SELECT ?person ?personLabel ?college ?collegeLabel ?university ?universityLabel ?date ?date_label
-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:P117 ?wikidata_ID .}             #return wikidata ID
-     OPTIONAL {?person bnwdt:P119 ?viaf_ID .}                 #return VIAF ID
+  # note: academic degree is P59. possible extra info?
-    OPTIONAL {?person bnwdt:P34 ?ads_ID .}                   #return Archaeological Data Service ID
+  ?person bnp:P94 ?s .  # educated at
-     OPTIONAL {?person bnwdt:P118 ?worldcat_ID .}             #return WorldCat Identities ID
+     ?s bnps:P94 ?college .
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+    optional {?college bnwdt:P4 ?university . } # a few ?college aren't part of (P4) a ?university
+   ?college bnwdt:P12 bnwd:Q2914 .   # tertiary ed inst
+  # dates.
+     optional {
+    ?s ?pq ?date .
+      ?qual_prop wikibase:qualifier ?pq;
+              wikibase:propertyType wikibase:Time ; # nb excludes edtf dates
+              rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # what kind of date is it.
+      } # /dates
+   SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".}
 }
-ORDER BY ?personLabel
+order by ?personLabel ?collegeLabel ?date
 </sparql>
-===FSAs in the wiki (excluding the project team) and their corresponding IDs - where they exist - on wikidata, viaf, WorldCat Identities, and the Archaeology Data Service===
+=== Academic degrees ===
 <sparql tryit="1">
+# Fetch academic degrees for women, with date and conferring institution where available
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,370: / Line 2,669: @@
 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 bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX wd:  <http://www.wikidata.org/entity/>
+PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
+SELECT distinct ?person ?personLabel ?degree ?degreeLabel ?by ?byLabel ?date ?date_label
-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
-  ?person bnwdt:P16 ?FSA .                                   #select FSA
+   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:P117 ?wikidata_ID .}             #return wikidata ID
+  # academic degree = P59.
-     OPTIONAL {?person bnwdt:P119 ?viaf_ID .}                 #return VIAF ID
+  ?person bnp:P59 ?s .
-     OPTIONAL {?person bnwdt:P34 ?ads_ID .}                   #return Archaeological Data Service ID
+     ?s bnps:P59 ?degree . # type of degree
-     OPTIONAL {?person bnwdt:P118 ?worldcat_ID .}             #return WorldCat Identities ID
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+  # optional qualifiers for degree
+  # P61 conferred by
+     optional { ?s bnpq:P61 ?by . }
+  # date with type
+     optional {
+    ?s ?pq ?date .
+      ?qual_prop wikibase:qualifier ?pq;
+              wikibase:propertyType wikibase:Time ; # nb excludes edtf dates
+              rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # kind of date
+      } # /dates
+   SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".}
 }
-ORDER BY ?personLabel
+order by ?personLabel ?date ?degreeLabel
 </sparql>
-===People with IDs on wikidata, their date of birth on wikidata, and the source(s) of that information===
+==IDs==
+===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===
 <sparql tryit="1">
@@ Line 2,399: / Line 2,714: @@
 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)
+SELECT ?person ?personLabel ?wikidata_ID ?viaf_ID ?ads_ID ?worldcat_ID
 WHERE {
-  #Select all women
+   ?person bnwdt:P3 bnwd:Q3 .                                 #select women
-   ?woman bnwdt:P3 bnwd:Q3 .
+   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}            #filter out project team
-  #select all women that have a Wikidata link
+    OPTIONAL {?person bnwdt:P117 ?wikidata_ID .}             #return wikidata ID
-   ?woman bnwdt:P117 ?Qnumber .
+    OPTIONAL {?person bnwdt:P119 ?viaf_ID .}                 #return VIAF ID
+    OPTIONAL {?person bnwdt:P34 ?ads_ID .}                   #return Archaeological Data Service ID
-  #create reference to Wikibase entity
+    OPTIONAL {?person bnwdt:P118 ?worldcat_ID .}             #return WorldCat Identities ID
-  BIND(IRI(concat("http://www.wikidata.org/entity/", ?Qnumber)) as ?WDitem )
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-  #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 ?personLabel
-ORDER BY ?womanLabel
-# Credit to Maarten Zeinstra for developing this query
 </sparql>
-=== Which women in the wikibase have Wikipedia articles, according to Wikidata?===
+===FSAs in the wiki (excluding the project team) and their corresponding IDs - where they exist - on wikidata, viaf, WorldCat Identities, and the Archaeology Data Service===
 <sparql tryit="1">
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,448: / Line 2,741: @@
 PREFIX wd:  <http://www.wikidata.org/entity/>
-SELECT ?person ?personLabel ?wikidata ?wikipedia
+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
+  ?person bnwdt:P16 ?FSA .                                   #select FSA
+   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}            #filter out project team
+    OPTIONAL {?person bnwdt:P117 ?wikidata_ID .}             #return wikidata ID
+    OPTIONAL {?person bnwdt:P119 ?viaf_ID .}                 #return VIAF ID
+    OPTIONAL {?person bnwdt:P34 ?ads_ID .}                   #return Archaeological Data Service ID
+    OPTIONAL {?person bnwdt:P118 ?worldcat_ID .}             #return WorldCat Identities ID
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+ORDER BY ?personLabel
+</sparql>
-  ?person bnwdt:P117 ?wikidata_ID . #look for wikidata ID on person page
+===People with IDs on wikidata, their date of birth on wikidata, and the source(s) of that information===
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-  SERVICE <https://query.wikidata.org/sparql> {
-      # get English language wikipedia articles in wikidata entries, where listed
-        OPTIONAL {
-          ?wikipedia schema:about ?wikidata .
-          ?wikipedia schema:inLanguage 'en' .
-          FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/')
-        }
-      }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-ORDER BY ?personLabel
-</sparql>
-=== Women with no date of death in our wikibase who have a date of death on Wikidata===
 <sparql tryit="1">
-# Women who have no date of death in our wikibase and have a date of death on Wikidata
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,486: / Line 2,767: @@
 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 ?person ?personLabel  ?wd_dod
+SELECT ?woman ?womanLabel ?WDitem ?WDdateOfBirth (GROUP_CONCAT(?BirthStatedInEnglish;separator=" | ") AS ?sources)
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . #select women
+   #Select all women
-   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+   ?woman bnwdt:P3 bnwd:Q3 .
+   #select all women that have a Wikidata link
-   filter not exists {?person bnwdt:P15 ?bn_dod . } # *don't* have P15 date of death
+   ?woman bnwdt:P117 ?Qnumber .
-   ?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) .
+  #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> {
-         ?item wdt:P21 ?WD_gender. #get gender of person
+        #get the date of birth
-         ?item wdt:P570 ?wd_dod .  #date of death on Wikidata P570
+         ?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". }
 }
-ORDER BY ?personLabel
+GROUP BY ?woman ?womanLabel ?WDitem ?WDdateOfBirth
+ORDER BY ?womanLabel
+# Credit to Maarten Zeinstra for developing this query
 </sparql>
-=== Women with no date of birth in our wikibase who have a date of birth in Wikidata===
+=== Which women in the wikibase have Wikipedia articles, according to Wikidata?===
 <sparql tryit="1">
-# Women who have no date of birth in our wikibase and have a date of birth on Wikidata
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 2,523: / Line 2,816: @@
 PREFIX wd:  <http://www.wikidata.org/entity/>
-SELECT ?person ?personLabel  ?wd_dob
+SELECT ?person ?personLabel ?wikidata ?wikipedia
 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 bnwdt:P117 ?wikidata_ID . #look for wikidata ID on person page
-     bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?item) .
+     bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
    SERVICE <https://query.wikidata.org/sparql> {
-         ?item wdt:P21 ?WD_gender. #get gender of person
+      # get English language wikipedia articles in wikidata entries, where listed
-        ?item wdt:P569 ?wd_dob .  #date of birth on Wikidata P569
+         OPTIONAL {
-       }
+          ?wikipedia schema:about ?wikidata .
+          ?wikipedia schema:inLanguage 'en' .
+          FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/')
+        }
+       }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
 ORDER BY ?personLabel
 </sparql>
-=== All external IDs on Wikidata for Women ===
+=== Women with no date of death in our wikibase who have a date of death on Wikidata===
 <sparql tryit="1">
-# Query to fetch all available External IDs on Wikidata for FSAs
+# Women who have no date of death in our wikibase and have a date of death on Wikidata
-# NB this will take a while, but it should finish.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,555: / Line 2,852: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
+PREFIX wdt: <http://www.wikidata.org/prop/direct/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
+PREFIX wd:  <http://www.wikidata.org/entity/>
+SELECT ?person ?personLabel  ?wd_dod
+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:P15 ?bn_dod . } # *don't* have P15 date of death
+  ?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) .
-SELECT distinct ?person ?personLabel ?wikidata ?p ?id_no ?id_label
+  SERVICE <https://query.wikidata.org/sparql> {
+        ?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>
-WHERE {
+=== Women with no date of birth in our wikibase who have a date of birth in Wikidata===
-    ?person bnwdt:P3 bnwd:Q3 . #select women
-    #?person bnwdt:P75 bnwd:Q8. # limit to FSAs if the full set times out.
-    ?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> {
+<sparql tryit="1">
+# Women who have no date of birth in our wikibase and have a date of birth on Wikidata
-    ?wikidata ?p ?s .
-       ?prop wikibase:claim ?p;
-             wikibase:statementProperty ?ps; # NB rather than statementValue
-             wikibase:propertyType wikibase:ExternalId. # quicker than filter.
-       ?prop rdfs:label ?id_label. filter(lang(?id_label)="en") . # ident name
-          ?s ?ps ?id_no . # id value
-       # filter by property type
-       #filter(?prop_type in (wikibase:ExternalId ) ) .
-     }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
-}
-order by ?personLabel ?id_label ?id_no
-</sparql>
-=== What external IDs are available in Wikidata for women in the BN database? ===
-<sparql tryit="1">
-# All the external IDs on BN women's Wikidata pages, with counts and descriptions
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,603: / Line 2,891: @@
 PREFIX wd:  <http://www.wikidata.org/entity/>
-SELECT ?p ?id_label ?id_description  (count(?p) as ?count)
+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 bnwdt:P117 ?wikidata_ID . #look for wikidata ID on person page
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?item) .
-   ?person bnwdt:P117 ?wikidata_ID . # wikidata ID
+   SERVICE <https://query.wikidata.org/sparql> {
-     bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
+        ?item wdt:P21 ?WD_gender. #get gender of person
+        ?item wdt:P569 ?wd_dob .  #date of birth on Wikidata P569
+      }
-     SERVICE <https://query.wikidata.org/sparql> {
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-     ?wikidata ?p ?s .
+}
-          ?prop wikibase:claim ?p;
+ORDER BY ?personLabel
-               wikibase:propertyType wikibase:ExternalId;
-               rdfs:label ?id_label. filter(lang(?id_label)="en") .
-       ?prop schema:description ?id_description .
-       filter(lang(?id_description) = "en") .
-       }
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en, en-gb". }
-}
-group by ?p ?id_label ?id_description
-ORDER BY desc(?count)
 </sparql>
-=== Women with ODNB IDs in Wikidata ===
+=== All external IDs on Wikidata for Women ===
 <sparql tryit="1">
-# BN women with ODNB biography IDs on Wikidata, with links to the bios
+# Query to fetch all available External IDs on Wikidata for FSAs
+# NB this will take a while, but it should finish.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,643: / Line 2,926: @@
 PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT distinct ?person ?personLabel ?wikidata ?url
+SELECT distinct ?person ?personLabel ?wikidata ?p ?id_no ?id_label
 WHERE {
      ?person bnwdt:P3 bnwd:Q3 . #select women
+     #?person bnwdt:P75 bnwd:Q8. # limit to FSAs if the full set times out.
      ?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> {
-     # P1415	Oxford Dictionary of National Biography ID | P6829	Dictionary of Irish Biography ID | P1648	Dictionary of Welsh Biography ID
+     ?wikidata ?p ?s .
-    ?wikidata wdt:P1415 ?id .
+       ?prop wikibase:claim ?p;
+             wikibase:statementProperty ?ps; # NB rather than statementValue
+             wikibase:propertyType wikibase:ExternalId. # quicker than filter.
+       ?prop rdfs:label ?id_label. filter(lang(?id_label)="en") . # ident name
+          ?s ?ps ?id_no . # id value
-    # odnb link
+       # filter by property type
-    BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?id)) as ?url ) .
+       #filter(?prop_type in (wikibase:ExternalId ) ) .
       }
@@ Line 2,664: / Line 2,953: @@
 }
-order by ?personLabel ?id
+order by ?personLabel ?id_label ?id_no
 </sparql>
-=== Women with National Portrait Gallery links via Wikidata ===
+=== What external IDs are available in Wikidata for women in the BN database? ===
 <sparql tryit="1">
-# Query to fetch National Portrait Gallery IDs on Wikidata for BN women, with links
+# All the external IDs on BN women's Wikidata pages, with counts and descriptions
-# NB this may be a bit slow...
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,679: / Line 2,968: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
+PREFIX wdt: <http://www.wikidata.org/prop/direct/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
+PREFIX wd:  <http://www.wikidata.org/entity/>
+SELECT ?p ?id_label ?id_description  (count(?p) as ?count)
-SELECT distinct ?person ?personLabel ?wikidata ?id_no ?npg_url
+WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . #select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-WHERE {
+  ?person bnwdt:P117 ?wikidata_ID . # wikidata ID
-    ?person bnwdt:P3 bnwd:Q3 . #select women
+     bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-    ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID
+     SERVICE <https://query.wikidata.org/sparql> {
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
+     ?wikidata ?p ?s .
+          ?prop wikibase:claim ?p;
-    SERVICE <https://query.wikidata.org/sparql> {
+               wikibase:propertyType wikibase:ExternalId;
+               rdfs:label ?id_label. filter(lang(?id_label)="en") .
-    ?wikidata ?p ?s .
+       ?prop schema:description ?id_description .
-       ?prop wikibase:claim ?p;
+       filter(lang(?id_description) = "en") .
-             wikibase:statementProperty ?ps;
+       }
-             wikibase:propertyType wikibase:ExternalId.
-          ?s ps:P1816 ?id_no . # id value
-      # npg link
-          BIND(IRI(concat("https://www.npg.org.uk/collections/search/person/", ?id_no)) as ?npg_url ) .
-     }
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en, en-gb". }
 }
+group by ?p ?id_label ?id_description
-order by ?personLabel ?id_no
+ORDER BY desc(?count)
 </sparql>
-=== Which BN properties map on to Wikidata properties? ===
+=== Women with ODNB IDs in Wikidata ===
 <sparql tryit="1">
+# BN women with ODNB biography IDs on Wikidata, with links to the bios
-## **NOTES**
-## a few properties have a linked wikidata "Q" rather than "P" ID. These will unfortunately not link correctly to Wikidata so wd_label/wd_description won't be present.
-## a few other properties may have wikidata=yes but no wd_label and/or wd_description. This could be because the property on Wikidata has been deleted (eg performed at).
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 2,723: / Line 3,008: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
+PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT DISTINCT ?property (if(bound(?wikidata_id), "yes", "no") as ?has_wikidata)  ?bn_label ?wd_label ?bn_description
+SELECT distinct ?person ?personLabel ?wikidata ?url
-  ?wd_description ?wikidata ?bn_propertyType
 WHERE {
-  ?property a wikibase:Property ;
+    ?person bnwdt:P3 bnwd:Q3 . #select women
-              wikibase:propertyType ?bn_propertyType . # datatype
+     ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID
-   service wikibase:label {
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
-            ?property rdfs:label ?bn_label .
+    SERVICE <https://query.wikidata.org/sparql> {
-            ?property schema:description ?bn_description .
-                             }
+    # P1415	Oxford Dictionary of National Biography ID | P6829	Dictionary of Irish Biography ID | P1648	Dictionary of Welsh Biography ID
-     # wikidata P117
+    ?wikidata wdt:P1415 ?id .
-     optional {
-            ?property bnwdt:P117 ?wikidata_id .
-                bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
-             SERVICE <https://query.wikidata.org/sparql> {
+    # odnb link
-                    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
+    BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?id)) as ?url ) .
-                            ?wikidata schema:description ?wd_description .
-                            ?wikidata rdfs:label ?wd_label .
+     }
-                     } # / label service
-               } # /wikidata service
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
-           } #/wikidata optional
 }
-order by ?bn_label
+order by ?personLabel ?id
 </sparql>
-==== Of these, which are properties for public and professional activities? ====
+=== Women with National Portrait Gallery links via Wikidata ===
 <sparql tryit="1">
-# which properties have corresponding wikidata IDs, restricted to instance of PPA (P12 / Q151)
+# Query to fetch National Portrait Gallery IDs on Wikidata for BN women, with links
+# NB this may be a bit slow...
-## **NOTES**
-## a few properties have a linked wikidata "Q" rather than "P" ID. These will unfortunately not link correctly to Wikidata so wd_label/wd_description won't be present.
-## a few other properties may have wikidata=yes but no wd_label and/or wd_description. This could be because the property on Wikidata has been deleted (eg performed at).
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,768: / Line 3,047: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
+PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT DISTINCT ?property (if(bound(?wikidata_id), "yes", "no") as ?has_wikidata)  ?bn_label ?wd_label ?bn_description
+SELECT distinct ?person ?personLabel ?wikidata ?id_no ?npg_url
-  ?wd_description ?wikidata ?bn_propertyType
 WHERE {
-  ?property a wikibase:Property ;
+    ?person bnwdt:P3 bnwd:Q3 . #select women
-              wikibase:propertyType ?bn_propertyType . # datatype
+    ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID
-    service wikibase:label {
+     bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
-            ?property rdfs:label ?bn_label .
+    SERVICE <https://query.wikidata.org/sparql> {
-            ?property schema:description ?bn_description .
-                             }
+    ?wikidata ?p ?s .
-    # wikidata P117
+       ?prop wikibase:claim ?p;
-     optional { ?property bnwdt:P117 ?wikidata_id .
+             wikibase:statementProperty ?ps;
-                 bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
+             wikibase:propertyType wikibase:ExternalId.
-             SERVICE <https://query.wikidata.org/sparql> {
+          ?s ps:P1816 ?id_no . # id value
-                    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
+      # npg link
-                            ?wikidata schema:description ?wd_description .
+          BIND(IRI(concat("https://www.npg.org.uk/collections/search/person/", ?id_no)) as ?npg_url ) .
-                            ?wikidata rdfs:label ?wd_label .
+     }
-                     } # / label service
-               } # /wikidata service
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
-           } #/wikidata optional
-    ?property bnwdt:P12 bnwd:Q151. # instance of PPA
 }
-order by ?bn_label
+order by ?personLabel ?id_no
 </sparql>
+=== Which BN properties map on to Wikidata properties? ===
+<sparql tryit="1">
-=== Archaeological sites/Historic houses and their owners/operators in Wikidata ===
+## **NOTES**
+## a few properties have a linked wikidata "Q" rather than "P" ID. These will unfortunately not link correctly to Wikidata so wd_label/wd_description won't be present.
-<sparql tryit="1">
+## a few other properties may have wikidata=yes but no wd_label and/or wd_description. This could be because the property on Wikidata has been deleted (eg performed at).
-#title:archaeological sites/historic houses in wikidata
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 2,813: / Line 3,092: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?item ?itemLabel ?instanceLabel ?wikidata ?wd_owner_label ?wd_operator_label ?wd_member_label  #?wd_owner ?wd_operator
+SELECT DISTINCT ?property (if(bound(?wikidata_id), "yes", "no") as ?has_wikidata)  ?bn_label ?wd_label ?bn_description
+   ?wd_description ?wikidata ?bn_propertyType
-WHERE {
-  { ?item bnwdt:P12 bnwd:Q86 . } # instance of archaeological site
-  union
-  { ?item bnwdt:P12 bnwd:Q2961 . } # instance of historic house
-   ?item bnwdt:P12 ?instance .   # which instance of is it
-   filter ( ?instance in (bnwd:Q86, bnwd:Q2961) ) . # (need filter as a few have multiple instance of)
-    ?item bnwdt:P117 ?wikidata_id .
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
-     SERVICE <https://query.wikidata.org/sparql> {
-      optional { ?wikidata wdt:P127 ?wd_owner  .} # can be individuals and multiple.
-      optional { ?wikidata wdt:P137 ?wd_operator . }
-       optional { ?wikidata wdt:P463 ?wd_member . }
-       ## at least some had *both* owned by *and* operator, but not always the case.
-       ## owned by P127 / operator P137
-       ## English Heritage Q936287  National Trust (Q333515)
-       ## member of P463   Historic Houses Association (Q5773523)
-       # automatic *Label doesn't work with a federated query; rdfs:label instead.
-         SERVICE wikibase:label {
-              bd:serviceParam wikibase:language "en".
-              ?wd_owner rdfs:label ?wd_owner_label.
-              ?wd_operator rdfs:label ?wd_operator_label.
-              ?wd_member rdfs:label ?wd_member_label.
-              }
-       }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-order by ?itemLabel
+WHERE {
+  ?property a wikibase:Property ;
+              wikibase:propertyType ?bn_propertyType . # datatype
+   service wikibase:label {
+            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
+            ?property rdfs:label ?bn_label .
+            ?property schema:description ?bn_description .
+                             }
+    # wikidata P117
+    optional {
+            ?property bnwdt:P117 ?wikidata_id .
+                bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
+             SERVICE <https://query.wikidata.org/sparql> {
+                    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
+                            ?wikidata schema:description ?wd_description .
+                            ?wikidata rdfs:label ?wd_label .
+                     } # / label service
+               } # /wikidata service
+           } #/wikidata optional
+}
+order by ?bn_label
 </sparql>
-==== And which are owned/operated by English Heritage/National Trust or belong to Historic Houses Association ====
+==== Of these, which are properties for public and professional activities? ====
 <sparql tryit="1">
+# which properties have corresponding wikidata IDs, restricted to instance of PPA (P12 / Q151)
-# archaeological site or historic house.
+## **NOTES**
-# pull together via Wikidata which ones are owned/operated by 1) English Heritage 2) National Trust  or 3) affiliated to Historic Houses association
+## a few properties have a linked wikidata "Q" rather than "P" ID. These will unfortunately not link correctly to Wikidata so wd_label/wd_description won't be present.
+## a few other properties may have wikidata=yes but no wd_label and/or wd_description. This could be because the property on Wikidata has been deleted (eg performed at).
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 2,868: / Line 3,137: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?item ?itemLabel ?instanceLabel ?wikidata ?wd_owner_label ?wd_operator_label ?wd_member_label  #?wd_owner ?wd_operator
+SELECT DISTINCT ?property (if(bound(?wikidata_id), "yes", "no") as ?has_wikidata)  ?bn_label ?wd_label ?bn_description
+  ?wd_description ?wikidata ?bn_propertyType
 WHERE {
+   ?property a wikibase:Property ;
-  { ?item bnwdt:P12 bnwd:Q86 . }
+              wikibase:propertyType ?bn_propertyType . # datatype
-  union
-  { ?item bnwdt:P12 bnwd:Q2961 . }
-   ?item bnwdt:P12 ?instance .
-   filter ( ?instance in (bnwd:Q86, bnwd:Q2961) ) .
-    ?item bnwdt:P117 ?wikidata_id .
+    service wikibase:label {
-     bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
+            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
+            ?property rdfs:label ?bn_label .
-     SERVICE <https://query.wikidata.org/sparql> {
+            ?property schema:description ?bn_description .
+                             }
+    # wikidata P117
+    optional { ?property bnwdt:P117 ?wikidata_id .
+                 bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
-      optional { ?wikidata wdt:P127 ?wd_owner .}
+             SERVICE <https://query.wikidata.org/sparql> {
-      optional { ?wikidata wdt:P137 ?wd_operator . }
+                    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
-      optional { ?wikidata wdt:P463 ?wd_member . }
+                            ?wikidata schema:description ?wd_description .
+                            ?wikidata rdfs:label ?wd_label .
-      # filter: owner or operator = EH/NT / member of HHA
+                     } # / label service
-        filter ( ?wd_owner in (wd:Q936287, wd:Q333515) ||
+               } # /wikidata service
-                 ?wd_operator in (wd:Q936287, wd:Q333515) ||
+           } #/wikidata optional
-                 ?wd_member = wd:Q5773523 ) .
-       ## owned by P127 / operator P137
-       ## ENglish Heritage Q936287  National Trust (Q333515)
-       ## member of P463   Historic Houses Association (Q5773523)
-       SERVICE wikibase:label {
-              bd:serviceParam wikibase:language "en".
-              ?wd_owner rdfs:label ?wd_owner_label.
-              ?wd_operator rdfs:label ?wd_operator_label.
-              ?wd_member rdfs:label ?wd_member_label.
-              }
-       }
-   #} # /optional for wikidata ID
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+    ?property bnwdt:P12 bnwd:Q151. # instance of PPA
 }
+order by ?bn_label
+</sparql>
-order by ?itemLabel
-</sparql>
+=== Archaeological sites/Historic houses and their owners/operators in Wikidata ===
-== Men ==
-=== BN Men in Wikidata ===
 <sparql tryit="1">
+#title:archaeological sites/historic houses in wikidata
-#title: BN men in Wikidata
-# a starting point to get the basic query set up; can easily add more variables...
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 2,933: / Line 3,180: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT distinct ?person ?personLabel ?wikidata ?whos_who ?odnb_url ?wikipedia ?wd_dob ?wd_dod ?wd_stmts
+SELECT distinct ?item ?itemLabel ?instanceLabel ?wikidata ?wd_owner_label ?wd_operator_label ?wd_member_label  #?wd_owner ?wd_operator
 WHERE {
-    ?person bnwdt:P3 bnwd:Q10 . #select men
+  { ?item bnwdt:P12 bnwd:Q86 . } # instance of archaeological site
+   union
+  { ?item bnwdt:P12 bnwd:Q2961 . } # instance of historic house
-    ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID
+   ?item bnwdt:P12 ?instance .   # which instance of is it
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
+   filter ( ?instance in (bnwd:Q86, bnwd:Q2961) ) . # (need filter as a few have multiple instance of)
-     SERVICE <https://query.wikidata.org/sparql> {
+     ?item bnwdt:P117 ?wikidata_id .
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
-      ?wikidata   wikibase:statements ?wd_stmts .
+     SERVICE <https://query.wikidata.org/sparql> {
-       optional {
-         # P1415	Oxford Dictionary of National Biography ID | couls also add  P6829	Dictionary of Irish Biography ID | P1648	Dictionary of Welsh Biography ID
+      optional { ?wikidata wdt:P127 ?wd_owner  .} # can be individuals and multiple.
-        ?wikidata wdt:P1415 ?odnb_id .
+      optional { ?wikidata wdt:P137 ?wd_operator . }
-        # odnb link
+       optional { ?wikidata wdt:P463 ?wd_member . }
-        BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?odnb_id)) as ?odnb_url ) .
-        } #/ odnb
+       ## at least some had *both* owned by *and* operator, but not always the case.
+       ## owned by P127 / operator P137
-        # English language wikipedia articles in wikidata entries, where listed
+       ## English Heritage Q936287  National Trust (Q333515)
-        OPTIONAL {
+       ## member of P463   Historic Houses Association (Q5773523)
-          ?wikipedia schema:about ?wikidata .
-          ?wikipedia schema:inLanguage 'en' .
-          FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/')
-        }
-       optional { ?wikidata wdt:P4789 ?whos .
-                  bind(iri(concat("https://www.ukwhoswho.com/view/article/oupww/whoswho/", ?whos)) as ?whos_who) .
-                 } # P4789 Who's Who
-        optional { ?wikidata wdt:P569 ?wd_dob . } #date of birth on Wikidata P569
-        optional { ?wikidata wdt:P570 ?wd_dod . }  #date of death on Wikidata P570
-     }  #/ wikidata
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
+       # automatic *Label doesn't work with a federated query; rdfs:label instead.
+         SERVICE wikibase:label {
+              bd:serviceParam wikibase:language "en".
+              ?wd_owner rdfs:label ?wd_owner_label.
+              ?wd_operator rdfs:label ?wd_operator_label.
+              ?wd_member rdfs:label ?wd_member_label.
+              }
+       }
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
+order by ?itemLabel
-order by ?personLabel
 </sparql>
-=== What sort of info Wikidata has about BN men ===
+==== And which are owned/operated by English Heritage/National Trust or belong to Historic Houses Association ====
 <sparql tryit="1">
-#title: what info is there for BN men in Wikidata
+# archaeological site or historic house.
-#counts of properties (excluding external IDs, of which there are gazillions) (Counts are overall and some people might have more than one.)
+# pull together via Wikidata which ones are owned/operated by 1) English Heritage 2) National Trust  or 3) affiliated to Historic Houses association
-#at time of writing there are 198 linked men.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 2,994: / Line 3,235: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT ?prop_label ?prop (count(?prop) as ?count)
+SELECT distinct ?item ?itemLabel ?instanceLabel ?wikidata ?wd_owner_label ?wd_operator_label ?wd_member_label  #?wd_owner ?wd_operator
 WHERE {
-    ?person bnwdt:P3 bnwd:Q10 . #select men 211.
+  { ?item bnwdt:P12 bnwd:Q86 . }
-    ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID
+  union
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
+  { ?item bnwdt:P12 bnwd:Q2961 . }
-    SERVICE <https://query.wikidata.org/sparql> {
+   ?item bnwdt:P12 ?instance .
-        ?wikidata ?p ?s .
+   filter ( ?instance in (bnwd:Q86, bnwd:Q2961) ) .
-            ?prop wikibase:claim ?p;
-                 wikibase:propertyType ?prop_type ;
+   ?item bnwdt:P117 ?wikidata_id .
-                  wikibase:statementProperty ?ps.
+     bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
-            ?prop rdfs:label ?prop_label. filter(lang(?prop_label)="en") .
-        filter(?prop_type in (wikibase:Time, wikibase:WikibaseItem ) ) .
+     SERVICE <https://query.wikidata.org/sparql> {
-      # also a few quantity, string, monolingualtext
+      optional { ?wikidata wdt:P127 ?wd_owner .}
-     }  #/ wikidata
+      optional { ?wikidata wdt:P137 ?wd_operator . }
+      optional { ?wikidata wdt:P463 ?wd_member . }
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
-}
+      # filter: owner or operator = EH/NT / member of HHA
-group by ?prop_label  ?prop
+        filter ( ?wd_owner in (wd:Q936287, wd:Q333515) ||
-order by ?prop_label
+                  ?wd_operator in (wd:Q936287, wd:Q333515) ||
+                 ?wd_member = wd:Q5773523 ) .
+       ## owned by P127 / operator P137
+       ## ENglish Heritage Q936287  National Trust (Q333515)
+       ## member of P463   Historic Houses Association (Q5773523)
+       SERVICE wikibase:label {
+              bd:serviceParam wikibase:language "en".
+              ?wd_owner rdfs:label ?wd_owner_label.
+              ?wd_operator rdfs:label ?wd_operator_label.
+              ?wd_member rdfs:label ?wd_member_label.
+              }
+       }
+   #} # /optional for wikidata ID
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+}
+order by ?itemLabel
 </sparql>
-=== BN Men in Wikidata: men who proposed elections to SAL/RAI ===
+== Men ==
+=== BN Men in Wikidata ===
 <sparql tryit="1">
-#title:Men who proposed for SAL/RAI elections who are in Wikidata
+#title: BN men in Wikidata
+# a starting point to get the basic query set up; can easily add more variables...
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 3,035: / Line 3,301: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
+PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
+SELECT distinct ?person ?personLabel ?wikidata ?whos_who ?odnb_url ?wikipedia ?wd_dob ?wd_dod ?wd_stmts
-SELECT distinct ?proposerLabel ?proposer ?wikidata ?odnb_url ?wikipedia ?wd_dob ?wd_dod
 WHERE {
-  ?person (bnp:P16 | bnp:P7) ?s . # proposed to either SAL or RAI
+    ?person bnwdt:P3 bnwd:Q10 . #select men
-  ?s (bnps:P16 | bnps:P7) ?proposer .
-    ?proposer bnwdt:P3 bnwd:Q10 .
+     ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID
+     bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-     ?proposer 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> {
+      ?wikidata   wikibase:statements ?wd_stmts .
         optional {
-          # P1415	Oxford Dictionary of National Biography ID
+          # P1415	Oxford Dictionary of National Biography ID | couls also add  P6829	Dictionary of Irish Biography ID | P1648	Dictionary of Welsh Biography ID
-         ?wikidata wdt:P1415 ?odnb_id .
+        ?wikidata wdt:P1415 ?odnb_id .
-         BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?odnb_id)) as ?odnb_url ) . # make odnb link
-         } #/ odnb
+        # odnb link
+        BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?odnb_id)) as ?odnb_url ) .
-         # could also add:     P6829	Dictionary of Irish Biography ID | P1648	Dictionary of Welsh Biography ID
+        } #/ odnb
          # English language wikipedia articles in wikidata entries, where listed
@@ Line 3,061: / Line 3,330: @@
            FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/')
          }
-        # there will be a few duplicates here...
+       optional { ?wikidata wdt:P4789 ?whos .
+                  bind(iri(concat("https://www.ukwhoswho.com/view/article/oupww/whoswho/", ?whos)) as ?whos_who) .
+                 } # P4789 Who's Who
          optional { ?wikidata wdt:P569 ?wd_dob . } #date of birth on Wikidata P569
          optional { ?wikidata wdt:P570 ?wd_dod . }  #date of death on Wikidata P570
-      }  #/ wikidata service
+      }  #/ wikidata
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
 }
-ORDER BY  ?proposerLabel
+order by ?personLabel
 </sparql>
-==== Male proposers who have occupations data in Wikidata====
+=== What sort of info Wikidata has about BN men ===
 <sparql tryit="1">
-#title:Men who proposed for SAL/RAI elections who have occupation(s) in wikidata
-# with occupation labels, which was slightly trickier than expected
+#title: what info is there for BN men in Wikidata
+#counts of properties (excluding external IDs, of which there are gazillions) (Counts are overall and some people might have more than one.)
+#at time of writing there are 198 linked men.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 3,086: / Line 3,362: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
+PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
+SELECT ?prop_label ?prop (count(?prop) as ?count)
-SELECT distinct ?personLabel ?proposerLabel
-(group_concat(distinct ?wd_label; SEPARATOR="; ") as ?proposer_occupations)
-?wikidata ?person ?proposer
 WHERE {
-  ?person (bnp:P16 | bnp:P7) ?s . # proposed to either SAL or RAI
+    ?person bnwdt:P3 bnwd:Q10 . #select men 211.
-  ?s (bnps:P16 | bnps:P7) ?proposer .
-     ?proposer bnwdt:P3 bnwd:Q10 .
+    ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID
+     bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-    ?proposer bnwdt:P117 ?wikidata_ID . #get wikidata ID
+     SERVICE <https://query.wikidata.org/sparql> {
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
+        ?wikidata ?p ?s .
+            ?prop wikibase:claim ?p;
-     SERVICE <https://query.wikidata.org/sparql> {
+                 wikibase:propertyType ?prop_type ;
-         ?wikidata wdt:P106 ?wd_occupation .
+                 wikibase:statementProperty ?ps.
-        # automatic *Label doesn't work with a federated query; this works instead.
+            ?prop rdfs:label ?prop_label. filter(lang(?prop_label)="en") .
-         SERVICE wikibase:label {
+        filter(?prop_type in (wikibase:Time, wikibase:WikibaseItem ) ) .
-              bd:serviceParam wikibase:language "en".
+      # also a few quantity, string, monolingualtext
-              ?wd_occupation rdfs:label ?wd_label.
-              }
+      }  #/ wikidata
-      }  #/ wikidata service
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
+}
+group by ?prop_label  ?prop
+order by ?prop_label
-}
-group by ?personLabel ?proposerLabel ?wikidata ?person ?proposer
-ORDER BY  ?proposerLabel ?person
 </sparql>
-=== BN Men in Wikidata: Spouses ===
+=== BN Men in Wikidata: men who proposed elections to SAL/RAI ===
 <sparql tryit="1">
-#title: BN spouses who are in Wikidata
+#title:Men who proposed for SAL/RAI elections who are in Wikidata
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 3,127: / Line 3,404: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?spouse ?spouseLabel  ?wikidata ?odnb_url ?wikipedia ?wd_dob ?wd_dod
+SELECT distinct ?proposerLabel ?proposer ?wikidata ?odnb_url ?wikipedia ?wd_dob ?wd_dod
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3.
+   ?person (bnp:P16 | bnp:P7) ?s . # proposed to either SAL or RAI
-   ?person bnwdt:P41 ?spouse .
+   ?s (bnps:P16 | bnps:P7) ?proposer .
+    ?proposer bnwdt:P3 bnwd:Q10 .
-     ?spouse bnwdt:P117 ?wikidata_ID . #get wikidata ID
+     ?proposer bnwdt:P117 ?wikidata_ID . #get wikidata ID
      bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
@@ Line 3,139: / Line 3,417: @@
         optional {
           # P1415	Oxford Dictionary of National Biography ID
           ?wikidata wdt:P1415 ?odnb_id .
           BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?odnb_id)) as ?odnb_url ) . # make odnb link
           } #/ odnb
-          # couls also add:     P6829	Dictionary of Irish Biography ID | P1648	Dictionary of Welsh Biography ID
+          # could also add:     P6829	Dictionary of Irish Biography ID | P1648	Dictionary of Welsh Biography ID
          # English language wikipedia articles in wikidata entries, where listed
@@ Line 3,153: / Line 3,430: @@
          }
+        # there will be a few duplicates here...
          optional { ?wikidata wdt:P569 ?wd_dob . } #date of birth on Wikidata P569
          optional { ?wikidata wdt:P570 ?wd_dod . }  #date of death on Wikidata P570
@@ Line 3,159: / Line 3,437: @@
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
 }
 ORDER BY  ?proposerLabel
 </sparql>
+==== Male proposers who have occupations data in Wikidata====
-=== BN Men who proposed, seconded or signed for Women in SAL/RAI/RHS elections, with counts and wikidata IDs ===
 <sparql tryit="1">
-#title:Men who supported women (at least twice) for SAL/RAI/RHS election with Wikidata IDs
+#title:Men who proposed for SAL/RAI elections who have occupation(s) in wikidata
+# with occupation labels, which was slightly trickier than expected
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 3,178: / Line 3,455: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-# p155, p156 - signed rhs
+SELECT distinct ?personLabel ?proposerLabel
-# p32, p82  - signed sal|
+(group_concat(distinct ?wd_label; SEPARATOR="; ") as ?proposer_occupations)
-# p8 rai seconded
+?wikidata ?person ?proposer
-SELECT  ?supporterLabel ?supporter  ?wikidata (count(?supporter) as ?supported)
 WHERE {
+  ?person (bnp:P16 | bnp:P7) ?s . # proposed to either SAL or RAI
-   ?person bnwdt:P3 bnwd:Q3 .
+   ?s (bnps:P16 | bnps:P7) ?proposer .
+    ?proposer bnwdt:P3 bnwd:Q10 .
-  {
+     ?proposer bnwdt:P117 ?wikidata_ID . #get wikidata ID
-     ?person (  bnp:P155 | bnp:P156 | bnp:P16 | bnp:P7 ) ?s .  #
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-      ?s ( bnps:P155 | bnps:P156 | bnps:P16 | bnps:P7 ) ?supporter  . # proposed SAL/RAI / signed RHS
-      #?s ?prop ?supporter .
-    }
-  #  union for qualifiers
-  union
-  {
-  ?person ?p ?s .
-     ?s (  bnpq:P156 | bnpq:P155 | bnpq:P32 | bnpq:P82 | bnpq:P8 ) ?supporter .
-     #?s ?prop ?supporter .
-  }
-     ?supporter bnwdt:P3 bnwd:Q10 .  # male
+     SERVICE <https://query.wikidata.org/sparql> {
+         ?wikidata wdt:P106 ?wd_occupation .
-    optional {
+        # automatic *Label doesn't work with a federated query; this works instead.
-      ?supporter bnwdt:P117 ?wikidata_ID . #get wikidata ID
+         SERVICE wikibase:label {
-      bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
+              bd:serviceParam wikibase:language "en".
-      }
+              ?wd_occupation rdfs:label ?wd_label.
+              }
+     }  #/ wikidata service
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
 }
-group by ?supporterLabel ?supporter ?wikidata
+group by ?personLabel ?proposerLabel ?wikidata ?person ?proposer
-having (?supported>2)
+ORDER BY  ?proposerLabel ?person
-ORDER BY desc(?supported) desc(?wikidata)
 </sparql>
-==Fishing Expeditions==
+=== BN Men in Wikidata: Spouses ===
-===All properties in use in the wikibase with property type, label and description (if present)===
 <sparql tryit="1">
-# query for information about properties that are being used in the wikibase
+#title: BN spouses who are in Wikidata
-## fyi: not actually necessary to declare these properties
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
+PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
+PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
+PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX wikibase: <http://wikiba.se/ontology#>
+PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX schema: <http://schema.org/>
+PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
+PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT DISTINCT
-  ?property
-  ?propertyType
-  ?propertyLabel
-  (group_concat(?propertyAltLabel; separator=" | ") as ?propertyAltLabels)
-  ?propertyDescription
+SELECT distinct ?spouse ?spouseLabel  ?wikidata ?odnb_url ?wikipedia ?wd_dob ?wd_dod
 WHERE {
-   ?property a wikibase:Property ;
+   ?person bnwdt:P3 bnwd:Q3.
-              rdfs:label ?propertyLabel ; # label
+  ?person bnwdt:P41 ?spouse .
-              wikibase:propertyType ?propertyType . # datatype
-  # add alternative labels if present (can be multiple)
+    ?spouse bnwdt:P117 ?wikidata_ID . #get wikidata ID
-  OPTIONAL { ?property skos:altLabel ?propertyAltLabel . }
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-  # add description if present
-  OPTIONAL {
-        SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
-          ?property schema:description ?propertyDescription .
-        }
-   }
-   FILTER(LANG(?propertyLabel) = 'en-gb')
+    SERVICE <https://query.wikidata.org/sparql> {
-  # fix label language dups; but Q why doesn't SERVICE work?
-  # A: https://en.wikibooks.org/wiki/SPARQL/FILTER#FILTER_on_values_in_Labels
+       optional {
-   # nb a few objects found with en-gb label missing
+         # P1415	Oxford Dictionary of National Biography ID
+         ?wikidata wdt:P1415 ?odnb_id .
+         BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?odnb_id)) as ?odnb_url ) . # make odnb link
+         } #/ odnb
+         # couls also add:     P6829	Dictionary of Irish Biography ID | P1648	Dictionary of Welsh Biography ID
+        # English language wikipedia articles in wikidata entries, where listed
+        OPTIONAL {
+          ?wikipedia schema:about ?wikidata .
+          ?wikipedia schema:inLanguage 'en' .
+          FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/')
+        }
+        optional { ?wikidata wdt:P569 ?wd_dob . } #date of birth on Wikidata P569
+        optional { ?wikidata wdt:P570 ?wd_dod . }  #date of death on Wikidata P570
+     }  #/ wikidata service
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
 }
-group by ?property ?propertyLabel ?propertyType ?propertyDescription
+ORDER BY  ?proposerLabel
-order by ?propertyLabel
 </sparql>
-=== All the Things for Organisations ===
+=== BN Men who proposed, seconded or signed for Women in SAL/RAI/RHS elections, with counts and wikidata IDs ===
 <sparql tryit="1">
+#title:Men who supported women (at least twice) for SAL/RAI/RHS election with Wikidata IDs
-# Exploratory query to get all info on an item page including qualifiers (but not references) for each organisation (Q2316) in the wikibase
-# Initially this *only* fetched organisations that specifically have the instance of Q2316: I didn't realise for a while how many organisations don't directly reference Q2316.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,278: / Line 3,546: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-select distinct ?item ?itemLabel
+# p155, p156 - signed rhs
-?prop ?propLabel ?prop_type
+# p32, p82  - signed sal|
-?stmt_value ?stmt_valueLabel
+# p8 rai seconded
-?qual_prop  ?qual_value ?qual_label ?qual_prop_type
-?statement
-where {
+SELECT  ?supporterLabel ?supporter  ?wikidata (count(?supporter) as ?supported)
-?item bnwdt:P12+ bnwd:Q2316  . # instance of organisation or descendants of (excluding instance of organisation itself)
+WHERE {
-   # get all the things about ?item
+   ?person bnwdt:P3 bnwd:Q3 .
-    ?item ?p ?statement .
-   # to get item Label without using service. couple of missing en-gb labels somewhere
+  {
-   # ?item rdfs:label ?item_label . filter(lang(?item_label)="en-gb") .
+    ?person (  bnp:P155 | bnp:P156 | bnp:P16 | bnp:P7 ) ?s .  #
+      ?s ( bnps:P155 | bnps:P156 | bnps:P16 | bnps:P7 ) ?supporter  . # proposed SAL/RAI / signed RHS
+      #?s ?prop ?supporter .
-  # get stuff about ?p
-    ?prop wikibase:claim ?p;
-            wikibase:statementProperty ?ps;  # "Links property entity to statement simple value predicate"
- 	        #wikibase:statementValue ?psv; # "Links property entity to statement full value predicate"
-            wikibase:propertyType ?prop_type.
-   # get stuff about ?statement
-     ?statement ?ps ?stmt_value.
-  # get any qualifiers
-   optional {
-     ?statement ?qual_p ?qual_value .
-     ?qual_prop wikibase:qualifier ?qual_p;
-           wikibase:propertyType ?qual_prop_type ;
-           rdfs:label ?qual_label. filter(lang(?qual_label)='en-gb') .
      }
+  #  union for qualifiers
+  union
+  {
+  ?person ?p ?s .
+     ?s (  bnpq:P156 | bnpq:P155 | bnpq:P32 | bnpq:P82 | bnpq:P8 ) ?supporter .
+     #?s ?prop ?supporter .
+  }
- #  OPTIONAL { ?item skos:altLabel ?alt_label . }
+    ?supporter bnwdt:P3 bnwd:Q10 .  # male
-    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+    optional {
+      ?supporter bnwdt:P117 ?wikidata_ID . #get wikidata ID
+      bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
+      }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
 }
+group by ?supporterLabel ?supporter ?wikidata
-order by ?item_label ?prop_label
+having (?supported>2)
+ORDER BY desc(?supported) desc(?wikidata)
 </sparql>
+==Fishing Expeditions==
-===Working with property paths: organisations and locations===
+===All properties in use in the wikibase with property type, label and description (if present)===
 <sparql tryit="1">
-## problem: sometimes you need to follow property paths using */+ for (eg) locations. BUT this can lead to several results to choose between and they aren't necessarily returned in the "right" order.
+# query for information about properties that are being used in the wikibase
-## how to determine the "distance" along the path of each result?
-## https://stackoverflow.com/questions/61984052/wikidata-get-the-full-subhierachy-of-one-class-as-well-as-all-nodes
-## > you can get the distance of a class with SELECT ?cls (count(?tmp) as ?distance) WHERE {   ?cls wdt:P279* ?tmp .   ?tmp wdt:P279+ wd:Q2095 . } group by ?cls order by asc(?distance) - though there might be corner cases like cycles in the hierarchy resp. multiple paths
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+## fyi: not actually necessary to declare these properties
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
+PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
+PREFIX wikibase: <http://wikiba.se/ontology#>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
+PREFIX schema: <http://schema.org/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
-SELECT  ?item ?itemLabel ?location ?locationLabel (count(?item) as ?distance)
+SELECT DISTINCT
-WHERE {
+  ?property
-   ?item bnwdt:P12 bnwd:Q2316 .  # instance of organisation.
+  ?propertyType
-   ?item bnwdt:P2* ?tmp .
+  ?propertyLabel
-   ?tmp bnwdt:P2+ ?location . # P2=30. P2+=34
+  (group_concat(?propertyAltLabel; separator=" | ") as ?propertyAltLabels)
+  ?propertyDescription
+WHERE {
+   ?property a wikibase:Property ;
+              rdfs:label ?propertyLabel ; # label
+              wikibase:propertyType ?propertyType . # datatype
+  # add alternative labels if present (can be multiple)
+   OPTIONAL { ?property skos:altLabel ?propertyAltLabel . }
+  # add description if present
+   OPTIONAL {
+        SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
+          ?property schema:description ?propertyDescription .
+        }
+   }
+  FILTER(LANG(?propertyLabel) = 'en')
+  # fix label language dups; but Q why doesn't SERVICE work?
+  # A: https://en.wikibooks.org/wiki/SPARQL/FILTER#FILTER_on_values_in_Labels
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". }
 }
-group by ?item ?itemLabel  ?location ?locationLabel
+group by ?property ?propertyLabel ?propertyType ?propertyDescription
-ORDER BY ?item ?distance
+order by ?propertyLabel
 </sparql>
-=== Working with property paths: instance of [CAVEAT: experimental, probably wrong]===
+=== All the Things for Organisations ===
 <sparql tryit="1">
-# an attempt to adapt the query above following paths for locations of organisations for (more complex) instance of
-# ref https://stackoverflow.com/questions/61984052/wikidata-get-the-full-subhierachy-of-one-class-as-well-as-all-nodes
-# distance is in the right *order* so it should be usable for some purposes, but the starting number = number of levels rather than 1. also jumps if there are siblings somewhere along the path.
+# Exploratory query to get all info on an item page including qualifiers (but not references) for each organisation (Q2316) in the wikibase
+# Initially this *only* fetched organisations that specifically have the instance of Q2316: I didn't realise for a while how many organisations don't directly reference Q2316.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,366: / Line 3,644: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?item ?itemLabel ?instance_of ?instance_ofLabel  (count(?item) as ?distance)
+select distinct ?item ?itemLabel
-WHERE {
+?prop ?propLabel ?prop_type
-  ?item bnwdt:P12* ?tmp .  # instance of anything.
+?stmt_value ?stmt_valueLabel
-  ?tmp bnwdt:P12+ ?instance_of . # P2=30. P2+=34
+?qual_prop  ?qual_value ?qual_label ?qual_prop_type
+?statement
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". }
+where {
+?item bnwdt:P12+ bnwd:Q2316  . # instance of organisation or descendants of (excluding instance of organisation itself)
+  # get all the things about ?item
+    ?item ?p ?statement .
+   # to get item Label without using service. couple of missing en-gb labels somewhere
+   # ?item rdfs:label ?item_label . filter(lang(?item_label)="en-gb") .
+  # get stuff about ?p
+    ?prop wikibase:claim ?p;
+            wikibase:statementProperty ?ps;  # "Links property entity to statement simple value predicate"
+ 	        #wikibase:statementValue ?psv; # "Links property entity to statement full value predicate"
+            wikibase:propertyType ?prop_type.
+   # get stuff about ?statement
+     ?statement ?ps ?stmt_value.
+  # get any qualifiers
+   optional {
+     ?statement ?qual_p ?qual_value .
+     ?qual_prop wikibase:qualifier ?qual_p;
+           wikibase:propertyType ?qual_prop_type ;
+           rdfs:label ?qual_label. filter(lang(?qual_label)='en-gb') .
+    }
+ #  OPTIONAL { ?item skos:altLabel ?alt_label . }
+    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-group by ?item ?itemLabel  ?instance_of ?instance_ofLabel
-ORDER BY ?item ?distance
+order by ?item_label ?prop_label
 </sparql>
-==Dates==
-===All the Dates for Women FSAs===
+=== One woman ===
 <sparql tryit="1">
-#title:fishing for dates for FSAs
-# union query to get [hopefully] every date associated with women FSAs including main dates and qualifier dates
+#title:All About a Woman
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,396: / Line 3,704: @@
 PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT distinct ?person ?personLabel ?prop_label ?qualLabel ?qual_dateLabel ?date_value  ?s
+SELECT distinct ?propLabel ?spsLabel ?qual_propLabel ?pqsLabel ?link ?s
-#?prop ?qual
+# ?main_date ?main_precision ?qual_date ?qual_precision
+# ?prop ?sps ?pqs ?pq
-WHERE {
+WHERE
+{
+   VALUES (?person) {(bnwd:Q569)}  # add (bnwd:Qxxx) if you want more than one person.
+   ?person ?p ?s .
+     ?prop wikibase:claim ?p;
+         wikibase:statementProperty ?ps;  #  simple value
+         wikibase:statementValue ?psv. #  full value
-    ?person bnwdt:P3 bnwd:Q3 . #select women
+    # exclude external IDs
-    ?person bnwdt:P75 bnwd:Q8. # find only BN subjects having a FSA
+    # filter not exists { ?prop wikibase:propertyType wikibase:ExternalId . }
-   # get stuff about ?person
+      ?s ?ps ?sps.
-   ?person ?p ?s .
-      # get stuff about ?p .
-      ?prop wikibase:claim ?p;
-         wikibase:statementProperty ?ps ;
-         wikibase:statementValue ?psv .
-      ?prop wikibase:propertyType ?date_prop_type .
-      ?prop rdfs:label ?prop_label. filter(lang(?prop_label)="en-gb") .
+    # full date via ?psv
+      OPTIONAL {
+           ?s ?psv ?spsv .
+               ?spsv wikibase:timeValue ?main_date .
+               ?spsv wikibase:timePrecision ?main_precision .
+       }
- {  # main dates
+    # qualifiers.
-  # get dates detail via ?s and psv
+      optional {
-  # gets edtf dates in simplified std wiki date format?
+         ?s ?pq ?pqs .
-  # https://github.com/ProfessionalWiki/WikibaseEdtf
+           ?qual_prop wikibase:qualifier ?pq .
-      ?s ?psv ?wdv .
+           ?qual_prop wikibase:qualifierValue ?pqp .
-        ?wdv wikibase:timeValue ?date_value .
+          optional {
-  } # /main dates
+            # full date via ?pqp
+            ?s ?pqp ?qv .
-  UNION
+            ?qv wikibase:timeValue ?qual_date.
+            ?qv wikibase:timePrecision ?qual_precision.
-  { # qualifier dates
+           }
+     }
-   # direct value (usually item) for the property
-        ?s ?ps ?qual.
-  # date qualifiers. [assumes no edtf in quals. ]
-        ?s ?pq ?date_value .
-          ?qual_date wikibase:qualifier ?pq .
-          ?qual_date wikibase:propertyType wikibase:Time.
-           ?qual_date rdfs:label ?date_qual_label . filter(lang(?date_qual_label)="en") .
-  }  # /qual dates
+  # direct link to property
+         BIND (REPLACE(STR(?prop), "^.*/([^/]*)$", "$1") as ?pid).
+         bind(iri(concat(str(?person), "#", ?pid)) as ?link ) .
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-} # /where
+}
+order by ?propLabel ?s
-ORDER BY ?person ?prop_label ?date_value
 </sparql>
-===Fetch any of multiple kinds of EDTF date for a woman===
+===Working with property paths: organisations and locations===
 <sparql tryit="1">
-# a union query to fetch stuff for multiple properties, in this case dates recorded in EDTF which need slightly different handling from PIT dates
+## problem: sometimes you need to follow property paths using */+ for (eg) locations. BUT this can lead to several results to choose between and they aren't necessarily returned in the "right" order.
-# main dates only; pretty sure there are no EDTF in qualifiers.
+## how to determine the "distance" along the path of each result?
-# updated to get date property labels
+## https://stackoverflow.com/questions/61984052/wikidata-get-the-full-subhierachy-of-one-class-as-well-as-all-nodes
+## > you can get the distance of a class with SELECT ?cls (count(?tmp) as ?distance) WHERE {   ?cls wdt:P279* ?tmp .   ?tmp wdt:P279+ wd:Q2095 . } group by ?cls order by asc(?distance) - though there might be corner cases like cycles in the hierarchy resp. multiple paths
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 3,463: / Line 3,771: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT  ?person ?personLabel ?date_edtf ?date_prop ?date_label ?s
+SELECT  ?item ?itemLabel ?location ?locationLabel (count(?item) as ?distance)
+WHERE {
+  ?item bnwdt:P12 bnwd:Q2316 .  # instance of organisation.
+  ?item bnwdt:P2* ?tmp .
+  ?tmp bnwdt:P2+ ?location . # P2=30. P2+=34
-WHERE { ?person bnwdt:P3 bnwd:Q3 .
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". }
-       FILTER NOT EXISTS { ?person bnwdt:P4 bnwd:Q12 . }
+}
+group by ?item ?itemLabel  ?location ?locationLabel
-       ## can do this union first but makes no difference to results except possibly a bit slower.
+ORDER BY ?item ?distance
-       #?person ( bnp:P131 | bnp:P132 | bnp:P133  ) ?s .
+</sparql>
-       #   ?s ( bnps:P131 | bnps:P132 | bnps:P133  ) ?date_edtf .
-       ?person ?p ?s . # so you can get the statement id and date prop label
+=== Traversing instance of with GAS ===
-           ?claim wikibase:claim ?p;
-                 rdfs:label ?date_label. filter(lang(?date_label)="en") .
-           ?s ?date_prop ?date_edtf .
+<sparql tryit="1">
+#title:GAS
-    ## filter for edtf dates
+# The Gather, Apply, and Scatter (GAS) service provides graph traversal, graph mining, and similar classes of algorithms for SPARQL.
-    ## docs: https://github.com/ProfessionalWiki/WikibaseEdtf
+# In practical terms, it enables a series of relations to be followed through the graph; for instance the chain of father, grandfather, great-grandfather &c - tracing the father (P22) line - of a subject item
+# https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/query_optimization#GAS_Service
+# https://github.com/blazegraph/database/wiki/RDF_GAS_API
-    FILTER ( datatype(?date_edtf) = xsd:edtf  ) .
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
-     }
-ORDER BY ?personLabel
-</sparql>
-===Full values: dates ===
-<sparql tryit="1">
-# query for full values to access the timeValue and timePrecision of a date, in this case a date of birth.
-## why is a more complex query needed?
-## simple value for a date doesn't differentiate between (eg) "1880" and "1 January 1880"; both are returned as 1 January 1880 (and SELECT DISTINCT will collapse them into a single result)
-## there are 14 codes for precision from billion years to second. 7: century, 8: decade, 9: year, 10: month, 11: day
-## NB additional bnpsv: prefix
-## https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format#Value_representation
-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/>
@@ Line 3,509: / Line 3,799: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-SELECT DISTINCT ?item ?itemLabel ?date ?precision
+SELECT ?depth  ?ioLabel ?itemLabel ?io ?item
 WHERE {
-  ?item bnp:P26  ?statement. # date of birth (precision of these varies quite a bit)
+      SERVICE gas:service {
-  ?statement bnpsv:P26 ?valueNode.
+           gas:program gas:gasClass "com.bigdata.rdf.graph.analytics.BFS" ;
-  ?valueNode wikibase:timeValue ?date.
+                       gas:in bnwd:Q3099 ;
-  ?valueNode wikibase:timePrecision ?precision.
+                       gas:linkType bnwdt:P12 ;
+                       gas:traversalDirection "Reverse";
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
+                       gas:out ?item ;
-}
+                       gas:out1 ?depth ;
-ORDER BY ?date
+                       gas:out2 ?io .
+      }
+    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
+    }
+order by ?depth ?ioLabel ?itemLabel
+</sparql>
-</sparql>
-=== Any main level date for women ===
+=== Working with property paths: instance of [CAVEAT: experimental, probably wrong]===
 <sparql tryit="1">
-# a query to get all types of main date for women
+# an attempt to adapt the query above following paths for locations of organisations for (more complex) instance of
+# ref https://stackoverflow.com/questions/61984052/wikidata-get-the-full-subhierachy-of-one-class-as-well-as-all-nodes
+# distance is in the right *order* so it should be usable for some purposes, but the starting number = number of levels rather than 1. also jumps if there are siblings somewhere along the path.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 3,536: / Line 3,831: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-SELECT DISTINCT ?person ?personLabel ?date_label  ?date ?date_prop_type ?date_prop ?link_prop
+SELECT ?item ?itemLabel ?instance_of ?instance_ofLabel  (count(?item) as ?distance)
+WHERE {
+  ?item bnwdt:P12* ?tmp .  # instance of anything.
+  ?tmp bnwdt:P12+ ?instance_of . # P2=30. P2+=34
-WHERE {
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". }
-  ?person bnwdt:P3 bnwd:Q3 . # women
-   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}
-   ?person ?p ?s .
-      ?date_prop wikibase:claim ?p;
-         wikibase:statementValue ?psv ;
-         wikibase:propertyType ?date_prop_type; # property type = wikibase:Time OR wikibase:Edtf
-         rdfs:label ?date_label. filter(lang(?date_label)="en-gb") . # what kind of date it is
-         # direct link to relevant section of page
-         BIND (REPLACE(STR(?date_prop), "^.*/([^/]*)$", "$1") as ?pid).
-         bind(iri(concat(str(?person), "#", ?pid)) as ?link_prop ) .
-      ?s ?psv ?wdv . # for the date value
-        ?wdv wikibase:timeValue ?date .  #timeValue gets pit and edtf
-     #  ?wdv wikibase:timePrecision ?date_precision .  # optional
-  # nb also possible to filter either/or time/edtf by property type
-  # filter(?date_prop_type in (wikibase:Edtf, wikibase:Time ) ) .
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
 }
-ORDER BY ?personLabel ?date
+group by ?item ?itemLabel  ?instance_of ?instance_ofLabel
+ORDER BY ?item ?distance
 </sparql>
-=== Counting Dates===
+==Dates==
+===All the Dates for Women FSAs===
 <sparql tryit="1">
-# count distinct dates for women (who have at least one)
+#title:fishing for dates for FSAs
-# uncomment HAVING line for women with only one
+# union query to get [hopefully] every date associated with women FSAs including main dates and qualifier dates
-# CAVEAT: there may be some discrepancies between dates shown on wiki pages and dates returned by sparql
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,585: / Line 3,862: @@
 PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT ?person ?personLabel (COUNT(DISTINCT ?date_value) as ?count)
+SELECT distinct ?person ?personLabel ?prop_label ?qualLabel ?qual_dateLabel ?date_value  ?s
+#?prop ?qual
 WHERE {
+   ?person bnwdt:P3 bnwd:Q3 . #select women
+   ?person bnwdt:P75 bnwd:Q8. # find only BN subjects having a FSA
+   # get stuff about ?person
+   ?person ?p ?s .
+      # get stuff about ?p .
+      ?prop wikibase:claim ?p;
+         wikibase:statementProperty ?ps ;
+         wikibase:statementValue ?psv .
+      ?prop wikibase:propertyType ?date_prop_type .
+      ?prop rdfs:label ?prop_label. filter(lang(?prop_label)="en-gb") .
   {  # main dates
-   ?person bnwdt:P3 bnwd:Q3 . # women
+  # get dates detail via ?s and psv
-   ?person ?p ?s .
+  # gets edtf dates in simplified std wiki date format?
-       ?s ?date_prop ?wdv .
+  # https://github.com/ProfessionalWiki/WikibaseEdtf
+       ?s ?psv ?wdv .
          ?wdv wikibase:timeValue ?date_value .
-   } # /main dates
+  } # /main dates
    UNION
    { # qualifier dates
-    ?person bnwdt:P3 bnwd:Q3 .
+   # direct value (usually item) for the property
-    ?person ?p ?s .
+        ?s ?ps ?qual.
-      ?s ?date_prop ?pqv .
-         ?pqv wikibase:timeValue ?date_value.
+   # date qualifiers. [assumes no edtf in quals. ]
-    }  # /qual dates
+        ?s ?pq ?date_value .
+          ?qual_date wikibase:qualifier ?pq .
+          ?qual_date wikibase:propertyType wikibase:Time.
+          ?qual_date rdfs:label ?date_qual_label . filter(lang(?date_qual_label)="en") .
+  }  # /qual dates
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 } # /where
-GROUP BY ?person ?personLabel
-# HAVING(?count=1)
-ORDER BY ?count ?person
+ORDER BY ?person ?prop_label ?date_value
 </sparql>
-=== Start dates that might not have accompanying end dates ===
+===Fetch any of multiple kinds of EDTF date for a woman===
 <sparql tryit="1">
-#title:Women with start dates that might not have accompanying end dates
+# a union query to fetch stuff for multiple properties, in this case dates recorded in EDTF which need slightly different handling from PIT dates
+# main dates only; pretty sure there are no EDTF in qualifiers.
+# updated to get date property labels
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,627: / Line 3,928: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT distinct ?personLabel ?prop_label ?start_date  (if(bound(?end_date), "yes", "no") as ?has_end_date) ?person ?s
+SELECT  ?person ?personLabel ?date_edtf ?date_prop ?date_label ?s
-#(group_concat(?other_date_label; SEPARATOR=" | ") as ?other_dates)
+WHERE { ?person bnwdt:P3 bnwd:Q3 .
+       FILTER NOT EXISTS { ?person bnwdt:P4 bnwd:Q12 . }
+       ## can do this union first but makes no difference to results except possibly a bit slower.
+       #?person ( bnp:P131 | bnp:P132 | bnp:P133  ) ?s .
+       #   ?s ( bnps:P131 | bnps:P132 | bnps:P133  ) ?date_edtf .
-WHERE {
+       ?person ?p ?s . # so you can get the statement id and date prop label
-  ?person bnwdt:P3 bnwd:Q3 .
+           ?claim wikibase:claim ?p;
+                 rdfs:label ?date_label. filter(lang(?date_label)="en") .
-  # need to find start times anywhere and get prop label so use claim.
-  ?person ?p ?s .
+           ?s ?date_prop ?date_edtf .
-  ?claim wikibase:claim ?p;
-         rdfs:label ?prop_label. filter(lang(?prop_label)="en") .
+    ## filter for edtf dates
+    ## docs: https://github.com/ProfessionalWiki/WikibaseEdtf
-# pretty sure start time is qualifier only...
- # get start dates
+    FILTER ( datatype(?date_edtf) = xsd:edtf  ) .
- # then optional end dates
- # can only see end time/pit associated, and the only pit with start time is not relevant, but can't be sure that'll always be true.
+     SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
- # optional other that excludes both start/end but lists any other date types
+     }
-     ?s bnpq:P27 ?start_date . # get start dates
-     optional {?s bnpq:P28 ?end_date .} # check for end dates
- #   optional {
+ORDER BY ?personLabel
- #       ?s ?pq ?other_date . # could there be any other associated dates?
- #       ?qual_prop wikibase:qualifier ?pq;
- #             wikibase:propertyType wikibase:Time ; # nb *does not* include edtf dates but AFAICT there are none in qualifiers.
- #             rdfs:label ?other_date_label . filter(lang(?other_date_label)="en-gb") . # what kind of date is it.
-        # drop both start and end this time. idk if there could be a faster way to do this?
- #       filter not exists { ?s (bnpq:P27 | bnpq:P28) ?other_date .  }
- #  } # / optional other dates
-  # filter(!bound(?end_date)). # to filter out rows with an end date
- SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
-}
-ORDER BY ?personLabel ?prop_label ?start_date
 </sparql>
+===Full values: dates ===
-=== End dates that might not accompanying start dates ===
+<sparql tryit="1">
+# query for full values to access the timeValue and timePrecision of a date, in this case a date of birth.
+## why is a more complex query needed?
+## simple value for a date doesn't differentiate between (eg) "1880" and "1 January 1880"; both are returned as 1 January 1880 (and SELECT DISTINCT will collapse them into a single result)
+## there are 14 codes for precision from billion years to second. 7: century, 8: decade, 9: year, 10: month, 11: day
+## NB additional bnpsv: prefix
+## https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format#Value_representation
-<sparql tryit="1">
-#title:Women with end dates that might not have accompanying start dates
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,685: / Line 3,976: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
 PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT distinct ?personLabel ?prop_label ?end_date
-(if(bound(?start_date), "yes", "no") as ?has_start_date)
-(group_concat(?other_date_label; SEPARATOR=" | ") as ?other_dates)
-?person ?s
+SELECT DISTINCT ?item ?itemLabel ?date ?precision
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 .
+   ?item bnp:P26  ?statement. # date of birth (precision of these varies quite a bit)
-   ?person ?p ?s .
+   ?statement bnpsv:P26 ?valueNode.
-   ?claim wikibase:claim ?p;
+   ?valueNode wikibase:timeValue ?date.
-         rdfs:label ?prop_label. filter(lang(?prop_label)="en") .
+  ?valueNode wikibase:timePrecision ?precision.
- # get end dates
- # then optional start dates
- # can only see start time/pit associated, and in fact the only pit with start time is not relevant, but can't be sure that'll always be true.
- # so an optional other that excludes both start/end but lists any other date types with group_concat
-     ?s bnpq:P28 ?end_date . # get end dates
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
+}
-    optional {?s bnpq:P27 ?start_date .} # check for start dates
+ORDER BY ?date
+</sparql>
+=== Any main level date for women ===
-    optional {
+<sparql tryit="1">
-        ?s ?pq ?other_date . # could there be any other associated dates?
+# a query to get all types of main date for women
-        ?qual_prop wikibase:qualifier ?pq;
-              wikibase:propertyType wikibase:Time ; # nb *does not* include edtf dates but AFAICT there are none in qualifiers.
-              rdfs:label ?other_date_label . filter(lang(?other_date_label)="en-gb") . # what kind of date
-        # drop both start and end. idk if there could be a faster way to do this?
-        filter not exists { ?s (bnpq:P27 | bnpq:P28) ?other_date .  }
-   } # / optional other dates
- #  filter(!bound(?start_date)). # to filter out rows with a start date (77 atm)
- SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
-}
-group by  ?personLabel ?prop_label ?end_date ?start_date ?has_start_date ?person ?s
-ORDER BY ?personLabel ?prop_label ?end_date
-</sparql>
-==Admin==
-===Women about whom we have recorded fewer than 3 pieces of information===
-<sparql tryit="1">
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,740: / Line 4,002: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-SELECT ?person ?personLabel ?statements WHERE {
+SELECT DISTINCT ?person ?personLabel ?date_label  ?date ?date_prop_type ?date_prop ?link_prop
-   ?person bnwdt:P3 bnwd:Q3 ;
-         wikibase:statements ?statements .
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}
-  FILTER (?statements <3)
-  SERVICE wikibase:label {
-      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
-  }
-}
-</sparql>
-===People for whom their item records is given as 'Mrs'===
+WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . # women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}
+   ?person ?p ?s .
+      ?date_prop wikibase:claim ?p;
+         wikibase:statementValue ?psv ;
+         wikibase:propertyType ?date_prop_type; # property type = wikibase:Time OR wikibase:Edtf
+         rdfs:label ?date_label. filter(lang(?date_label)="en-gb") . # what kind of date it is
-<sparql tryit="1">
+         # direct link to relevant section of page
-SELECT ?id ?name
+         BIND (REPLACE(STR(?date_prop), "^.*/([^/]*)$", "$1") as ?pid).
-WHERE {
+         bind(iri(concat(str(?person), "#", ?pid)) as ?link_prop ) .
-  ?id rdfs:label ?name .
-   FILTER regex(?name, "mrs *", "i") #this line uses regular expression syntax, described at https://regexper.com/#mrs%5Cs*
+      ?s ?psv ?wdv . # for the date value
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+        ?wdv wikibase:timeValue ?date .  #timeValue gets pit and edtf
+     #  ?wdv wikibase:timePrecision ?date_precision .  # optional
+  # nb also possible to filter either/or time/edtf by property type
+   # filter(?date_prop_type in (wikibase:Edtf, wikibase:Time ) ) .
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
 }
-</sparql>
+ORDER BY ?personLabel ?date
-===All triples in the wiki, limited to 1000===
-<sparql tryit="1">
-SELECT ?a ?aLabel ?b ?c WHERE {
-    ?a ?b ?c
-    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-LIMIT 1000 #please don't make this number too big as it will slow down the site!
 </sparql>
-===All triples in the wiki, represented as a crude graph===
+=== Counting Dates===
-<sparql tryit="1">
-#defaultView:Graph
-SELECT ?a ?aLabel ?c ?cLabel WHERE {
-    ?a ?b ?c
-    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-#note query returns every connection in the wikibase so it may fall over!
-</sparql>
-===People whose assigned gender we have been unable to determine and/or confirm===
 <sparql tryit="1">
+# count distinct dates for women (who have at least one)
+# uncomment HAVING line for women with only one
+# CAVEAT: there may be some discrepancies between dates shown on wiki pages and dates returned by sparql
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,794: / Line 4,048: @@
 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 bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX wd:  <http://www.wikidata.org/entity/>
+PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT ?person ?personLabel
+SELECT ?person ?personLabel (COUNT(DISTINCT ?date_value) as ?count)
-WHERE {
-  ?person bnwdt:P3 ?gender .
-  FILTER NOT EXISTS {?person bnwdt:P3 bnwd:Q3 .}          #filter out people identified as women
-  FILTER NOT EXISTS {?person bnwdt:P3 bnwd:Q10 .}          #filter out people identified as men
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-ORDER BY ?personLabel
-</sparql>
-===People who have a spouse statement and - optionally - marriage date statements for checking if there is any misalignment with 'Spouse not in wikibase' statements===
+WHERE {
+ {  # main dates
+   ?person bnwdt:P3 bnwd:Q3 . # women
+   ?person ?p ?s .
+      ?s ?date_prop ?wdv .
+        ?wdv wikibase:timeValue ?date_value .
+   } # /main dates
+  UNION
+  { # FIXME? qualifier dates. hmm... how is this different from above? I think something is missing.
+    ?person bnwdt:P3 bnwd:Q3 .
+    ?person ?p ?s .
+      ?s ?date_prop ?pqv .
+         ?pqv wikibase:timeValue ?date_value.
+    }  # /qual dates
+ SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
+} # /where
+GROUP BY ?person ?personLabel
+# HAVING(?count=1)
-<sparql tryit="1">
+ORDER BY ?count ?person
-# people who have a spouse statement and - optionally - marriage date statements for checking if there is any misalignment with 'Spouse not in wikibase' statements
-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/>
-SELECT ?person ?personLabel ?spouse ?spouseLabel ?edtfmarriagespouse ?edtfmarriagespouseLabel ?PITmarriagespouse ?PITmarriagespouseLabel WHERE {
-  ?person bnwdt:P41 ?spouse .
-  OPTIONAL {?person bnp:P132 ?edtfmarriagestatement .
-  ?edtfmarriagestatement bnps:P132 ?edtfmarriagedate .
-  ?edtfmarriagestatement bnpq:P41 ?edtfmarriagespouse .}
-  OPTIONAL {?person bnp:P130 ?PITmarriagestatement .
-  ?PITmarriagestatement bnps:P130 ?PITmarriagedate .
-  ?PITmarriagestatement bnpq:P41 ?PITmarriagespouse .}
-    SERVICE wikibase:label {
-      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
-    }
-}
-ORDER BY DESC(?edtfmarriagespouseLabel) DESC(?PITmarriagespouseLabel)
 </sparql>
-=== Compare uses of item v free text ===
+=== Start dates that might not have accompanying end dates ===
 <sparql tryit="1">
-# A number of properties have "item" and "free text" versions; a query to fetches both versions in each case to facilitate comparison of their uses.
+#title:Women with start dates that might not have accompanying end dates
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,850: / Line 4,096: @@
 PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT distinct ?itemLabel ?prop_label ?qual_label ?qual_value ?qual_valueLabel ?item ?qual_prop
+SELECT distinct ?personLabel ?prop_label ?start_date  (if(bound(?end_date), "yes", "no") as ?has_end_date) ?person ?s
+#(group_concat(?other_date_label; SEPARATOR=" | ") as ?other_dates)
-# most of these are used in qualifiers - only P72, P71 and P88 found in main (and only a handful of uses of free text?)
+WHERE {
-#?item (  bnp:P88|bnp:P91 | bnp:P72|bnp:P71) ?s .
+  ?person bnwdt:P3 bnwd:Q3 .
+  # need to find start times anywhere and get prop label so use claim.
+  ?person ?p ?s .
+  ?claim wikibase:claim ?p;
+         rdfs:label ?prop_label. filter(lang(?prop_label)="en") .
+# pretty sure start time is qualifier only...
+ # get start dates
+ # then optional end dates
+ # can only see end time/pit associated, and the only pit with start time is not relevant, but can't be sure that'll always be true.
+ # optional other that excludes both start/end but lists any other date types
+     ?s bnpq:P27 ?start_date . # get start dates
+    optional {?s bnpq:P28 ?end_date .} # check for end dates
-## the pairs
+ #   optional {
-#P21 evidence (free text) / P20 evidence (item)
+ #       ?s ?pq ?other_date . # could there be any other associated dates?
-#P79 item exhibited / P80 item exhibited (free text)
-#P78 of / P66 of (free text)
+ #       ?qual_prop wikibase:qualifier ?pq;
-#P91 specific reference information / P88 specific reference information (free text)
+ #             wikibase:propertyType wikibase:Time ; # nb *does not* include edtf dates but AFAICT there are none in qualifiers.
-#P31 street address (free text) / P100 street address (item)
+ #             rdfs:label ?other_date_label . filter(lang(?other_date_label)="en-gb") . # what kind of date is it.
-#P72 was delegate at (free text) / P71 was delegate at (item)
+        # drop both start and end this time. idk if there could be a faster way to do this?
-WHERE {
+ #       filter not exists { ?s (bnpq:P27 | bnpq:P28) ?other_date .  }
-  ?item ?p ?s .
+ #  } # / optional other dates
-   ?prop wikibase:claim ?p;
+   # filter(!bound(?end_date)). # to filter out rows with an end date
-         rdfs:label ?prop_label. filter(lang(?prop_label)="en-gb") .
-  ?s ( bnpq:P21|bnpq:P20 | bnpq:P80|bnpq:P79	| bnpq:P66|bnpq:P78 | bnpq:P88|bnpq:P91	| bnpq:P31|bnpq:P100 | bnpq:P72|bnpq:P71	 ) ?qual_value .
-  ?s ?qual_p ?qual_value .
+ SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
-     ?qual_prop wikibase:qualifier ?qual_p;
-           wikibase:propertyType ?qual_prop_type ;
-           rdfs:label ?qual_label. filter(lang(?qual_label)='en-gb') .
- SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
-}
-order by ?qual_label ?prop_label ?itemLabel
+ORDER BY ?personLabel ?prop_label ?start_date
 </sparql>
-=== Missing language labels ===
+=== End dates that might not accompanying start dates ===
 <sparql tryit="1">
+#title:Women with end dates that might not have accompanying start dates
-# query to check for any items/properties which don't have "en" labels. [currently not an issue but retained for reference.]
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,899: / Line 4,153: @@
 PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT
+SELECT distinct ?personLabel ?prop_label ?end_date
-  ?item  ?itemLabel
+(if(bound(?start_date), "yes", "no") as ?has_start_date)
-  (group_concat(distinct ?language) as ?languages)
+(group_concat(?other_date_label; SEPARATOR=" | ") as ?other_dates)
-  (count(distinct ?rdfs_label) as ?count) # TIL: where you put distinct matters!
+?person ?s
 WHERE {
+  ?person bnwdt:P3 bnwd:Q3 .
+  ?person ?p ?s .
+  ?claim wikibase:claim ?p;
+         rdfs:label ?prop_label. filter(lang(?prop_label)="en") .
+ # get end dates
+ # then optional start dates
+ # can only see start time/pit associated, and in fact the only pit with start time is not relevant, but can't be sure that'll always be true.
+ # so an optional other that excludes both start/end but lists any other date types with group_concat
+     ?s bnpq:P28 ?end_date . # get end dates
+    optional {?s bnpq:P27 ?start_date .} # check for start dates
-  ?item ?p ?s.
+    optional {
-  ?item rdfs:label ?rdfs_label .  # rdfs item label (1 per language).
+        ?s ?pq ?other_date . # could there be any other associated dates?
+        ?qual_prop wikibase:qualifier ?pq;
+              wikibase:propertyType wikibase:Time ; # nb *does not* include edtf dates but AFAICT there are none in qualifiers.
+              rdfs:label ?other_date_label . filter(lang(?other_date_label)="en-gb") . # what kind of date
+        # drop both start and end. idk if there could be a faster way to do this?
+        filter not exists { ?s (bnpq:P27 | bnpq:P28) ?other_date .  }
-   BIND(LANG(?rdfs_label) as ?language) .  # get 2 letter language codes
+   } # / optional other dates
+ #  filter(!bound(?start_date)). # to filter out rows with a start date (77 atm)
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
+}
-  #optional { ?item rdfs:label ?engb . filter(lang(?engb)="en-gb").  }
+group by  ?personLabel ?prop_label ?end_date ?start_date ?has_start_date ?person ?s
-  #optional { ?item rdfs:label ?en . filter(lang(?en)="en").  }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en-gb, en". }
-}
-group by ?item  ?itemLabel
-HAVING (?count<2)
-order by ?item
+ORDER BY ?personLabel ?prop_label ?end_date
 </sparql>
-=== Statements that contain both a date *and* an unknown value date===
+=== Women having children ===
 <sparql tryit="1">
-# A query to look for statements containing an <unknown value> date *and* a date
+#title:women having children
-# caveat: not yet completely sure if it will work in all cases for main dates
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,936: / Line 4,206: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT  ?item ?itemLabel ?main_label ?qualLabel ?subLabel
+# lol defaultView:Timeline{"hide":["?s", "?date_prec", ""]}
-(group_concat(distinct ?date_prop) as ?dates)
-(count (distinct(isBLANK(?t))) as ?tcount)
-?s
-# using isBlank() in select creates true/false, then count distinct finds any in a group having >1.
+# P131 had child in / P45 child
+# a handful of P45 named children don't have dob though probably have dob in wikidata
-WHERE
+SELECT distinct ?person ?personLabel ?childLabel ?date_value ?date_prec ?had_child_edtf ?note
-{
+?s
-   {
-   # qualifiers. [qualifiers need to include ?s in the group by]
+where {
-   ?item ?p ?s.
+   ?person bnwdt:P3 bnwd:Q3 . # select women
+   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-   # labels
+{
-   ?s ?subp ?sub .
+   # had child in (unnamed children)
-   ?qual wikibase:claim ?p;
+   ?person bnp:P131 ?s .
-         wikibase:statementProperty ?subp.
+      ?s bnps:P131 ?had_child_edtf . # keep the edtf date for reference, though i think you can just use the time value/prec with these.
-    ?s ?pq ?t .
+   # get dates detail via ?s and psv
+  # gets edtf dates in std wiki date format
+  # https://github.com/ProfessionalWiki/WikibaseEdtf
+      ?s ?psv ?wdv .
+        ?wdv wikibase:timeValue ?date_value .
+         ?wdv wikibase:timePrecision ?date_prec .
+  # filter edtf date.
+  FILTER ( datatype(?had_child_edtf) = xsd:edtf ) . #shows only the raw EDTF string from the query results
+  # interesting, when you put this after wikibase:timeValue it seems to get every timey-wimey statement for women who have had child in ? (but only one)
+  #?person bnwdt:P131 ?had_child .
+    # not much added in quals for had child. only maybe note P47. some have sourcing circumstances.
+   optional { ?s bnpq:P47 ?note .  } #
-    ?date_prop wikibase:qualifier ?pq ;
+   }
-             wikibase:propertyType ?date_prop_type .
+   union
-    filter(?date_prop_type in (wikibase:Time, wikibase:Edtf) ).
-   }
-   UNION
    {
-   # main [excluding ?s from group by this time]
+  # named children (are any in both sections??? from dates looks possible a couple might be [wherry / hodgson])
-  ?item ?p ?sm.
+   ?person bnp:P45 ?s.
-  ?sm ?ps ?t .
+        ?s bnps:P45 ?child .
+      optional { ?child bnp:P26 ?ss .
-  ?date_prop wikibase:claim ?p.
+                    ?ss bnps:P26 ?dob .
-  ?date_prop wikibase:statementProperty ?ps.
+                     ?ss ?psv ?wdv .
-  ?date_prop wikibase:propertyType ?date_prop_type .
+                        ?wdv wikibase:timeValue ?date_value .
-  ?date_prop rdfs:label ?main_label .  filter(lang(?main_label)="en-gb") .
+                        ?wdv wikibase:timePrecision ?date_prec .
+               }
-  filter(?date_prop_type in (wikibase:Time, wikibase:Edtf) ).
    }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en_gb" }
+    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
-group by ?item ?itemLabel ?s ?qualLabel ?subLabel  ?main_label
+order by ?person ?date_value
-having (?tcount >1 )  # comment out to get everything
-ORDER BY ?itemLabel ?main_label ?qualLabel ?subLabel ?date_prop
 </sparql>
+=== Women who were adults in 1911 ===
-=== Women with no dates===
 <sparql tryit="1">
+#title:Women who were adults in 1911 and their calculated ages
-# Query for women with no dates
-# WIP: at present this includes <unknown value> dates as well as no dates at all [eg Miss Keyser Q2622]
-# CAVEAT: the WQS bug means there are likely to be some women in results who do, in fact, have at least one date.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 4,000: / Line 4,271: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT distinct ?person ?personLabel  (count(?date_value) as ?count)
+SELECT distinct ?person ?personLabel ?statements ?dob ?dod ?age1911
 WHERE {
+   ?person bnwdt:P3 bnwd:Q3 ;
+         wikibase:statements ?statements .
+   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}
- {  # main dates
+    ?person bnwdt:P26 ?dob .
-    ?person bnwdt:P3 bnwd:Q3 . # women
+   #optional {
-  optional {
+      ?person bnwdt:P15 ?dod .
-    ?person ?p ?s .
+    #}
-      ?s ?date_prop ?wdv .
-        ?wdv wikibase:timeValue ?date_value . }
- } # /main dates
-   UNION
+   filter(year(?dod) > 1911 && year(?dob) <=1893 ) .
-  { # qualifier dates
+   #if dod is made optional a more complex filter to include some women who were likely to still be alive in 1911. but doesnt add very many.
+   #filter( ( year(?dob) <= 1893  && year(?dod) > 1911 ) || ( year(?dob) <= 1893 && year(?dob) >1870 ) ) .
-    ?person bnwdt:P3 bnwd:Q3 .
-   optional {
-     ?person ?p ?s .
-      ?s ?date_prop ?pqv .
-        ?pqv wikibase:timeValue ?date_value. }
-  }  # /qual dates
- SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
-} # /where
-group by ?person ?personLabel
-having (?count=0)
-ORDER BY ?person
-</sparql>
-=== Women with more than X statements but no date of birth/death===
-<sparql tryit="1">
-#title:women with n>X statements but no date of birth/death
-# CAVEAT this currently finds some women who do in fact have dates, because of WQS bug
-# updated to add extra info
-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/>
-SELECT distinct ?person ?personLabel ?statements ?dob ?dod
-(if(bound(?SALproposed), "yes", "") as ?FSA)
-(if(bound(?RAIproposed), "yes", "") as ?RAI)
-(if(bound(?resided), "yes", "") as ?residence)
-(if(bound(?main_date), "yes", "") as ?other_maindate)
-(if(bound(?qual_d), "yes", "") as ?qual_date)
-WHERE {
-   ?person bnwdt:P3 bnwd:Q3 ;
-         wikibase:statements ?statements .
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}
-  optional { ?person bnwdt:P15 ?dod .   }
-  optional { ?person bnwdt:P26 ?dob .   }
-   optional { # was elected FSA. comment out optional lines to get FSAs only...
-     ?person bnp:P16 ?s .
-        ?s bnps:P16 ?SALproposed .
-        ?s bnpq:P22 bnwd:Q36 .   # successful Q36. will you end up with 2 rows if there's a successful and unsuccessful?
-  } #/optional fsa
-  optional { # was elected RAI. only one unsuccessful, so just ignore that bit.
-    ?person bnwdt:P7 ?RAIproposed .
-  }
-  optional { ?person bnwdt:P29 ?resided . } # place of residence
-  optional {
-    # main dates, apart from birth and death: P133 (widowed) P132 (married edtf) P131 (had child) P130 (married pit)
-     ?person ( bnwdt:P130 | bnwdt:P131 | bnwdt:P132 | bnwdt:P133 ) ?main_date .
-    } # /optional main dates
-  optional {
-     # qualifier dates
-    ?person ?p ?s .
-      ?s ?date_prop ?pqv .
-         ?pqv wikibase:timeValue ?qual_d.
-    } #/ optional qual dates
-  FILTER (?statements >10) . # can adjust n statements here...
-  FILTER (NOT EXISTS { ?person bnwdt:P15 ?dod .} || NOT EXISTS { ?person bnwdt:P26 ?dob .  } ) . # EITHER no date of birth OR no date of death. or swap with following line...
-  #FILTER (NOT EXISTS { ?person bnwdt:P15 ?dod .} && NOT EXISTS { ?person bnwdt:P26 ?dob .  } ) . # no date of birth AND no date of death
-  SERVICE wikibase:label {
-      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
-  }
-}
-order by ?personLabel
-</sparql>
-=== Places of residence that lack instance of locality===
-<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/>
-SELECT distinct ?residence ?residenceLabel ?inst ?instLabel
-WHERE {
-  ?resident bnwdt:P29 ?residence . # resided at
-   filter not exists { ?residence bnwdt:P12 bnwd:Q2147 . } # that doesn't have instance of locality
-   optional {?residence bnwdt:P12 ?inst .} # does it have instance of anything?
-      ## Note: some have Q618 territory of the British Empire, which also lacks any instance of at present
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-ORDER BY ?residenceLabel
-</sparql>
-=== Locations that don't have Wikidata links or their Wikidata pages lack geocoordinates===
-<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/>
-SELECT distinct ?locationLabel ?location ?wikidata ?wd_geo ?instanceLabel ?bn_geo
-WHERE {
-  {?item bnwdt:P29  ?location . } # resided at
-  union
-  {?location bnwdt:P12 bnwd:Q2147 .} # OR has instance of locality
-  union
-  {?item bnwdt:P2  ?location . } # OR location P2
-  # any other possibles ?
-  optional { ?location bnwdt:P12 ?instance .  } # check instance of
-   optional {
-       ?location bnwdt:P117 ?ws .  # wikidata id
-         bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
-         SERVICE <https://query.wikidata.org/sparql> {
-           optional {?wikidata wdt:P625 ?wd_geo .}   # does the wikidata page have geocoords?
-         } # /wikidata service
-    } #/wikidata optional
-  filter (!bound(?wd_geo) ). # no geocoords in wikidata. some may have coords in BN...
-  optional { ?location bnwdt:P153 ?bn_geo .  } # so check for coords in BN
-  ##filter (!bound(?bn_geo)) . # uncomment to filter those out as well
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-ORDER BY ?wikidata ?locationLabel
-</sparql>
-=== Archaeological sites that don't have National Heritage England list numbers ===
-<sparql tryit="1">
-#title:archaeological sites without National Heritage numbers
-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/>
-SELECT ?item ?itemLabel ?location ?locationLabel
-(if(bound(?locEngland), "yes", "") as ?inEngland)
-WHERE {
-  ?item bnwdt:P12 bnwd:Q86 . # item instance of archaeological site
-  filter not exists {?item bnwdt:P129 ?thing .  } # without NH list number
-  optional { ?item bnwdt:P2 ?location .  } # location if it has one
-  optional { ?item bnwdt:P2 ?locEngland .
-               ?locEngland bnwdt:P33+ bnwd:Q617.
-           } # is the location in England
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-order by ?itemLabel
-</sparql>
-=== Date of latest edit for every item, according to WQS ===
-<sparql tryit="1">
-#title:latest edits dates for wikibase items
-## because of WQS disappearing data bugs this may not always match the latest edit in the page history
-SELECT ?item ?date ?dateLabel
-WHERE {
-   ?item wikibase:timestamp ?date .
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-order by ?date
-</sparql>
-=== Wikidata ID is a URL ===
-<sparql tryit="1">
-#title:check for accidental use of URL instead of wikidata ID
-## all checked and fixed at 18/12/23 but adding the query in case it recurs
-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/>
-SELECT distinct ?item ?itemLabel ?wd_http
-WHERE {
-  ?item bnwdt:P117 ?wd_http .  # wikidata id
-  filter(strstarts(str(?wd_http), "http")).
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-ORDER BY ?itemLabel
-</sparql>
-=== Wikidata URL is not a URL ===
-<sparql tryit="1">
-#title:check for wikidata URLs that don't start with http. could still be other problems!
-## all checked and fixed at 18/12/23 but adding the query in case of any recurring issues
-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/>
-SELECT distinct ?item ?itemLabel ?wd_url
-WHERE {
-   ?item bnp:P117 ?ws .  # wikidata id
-     ?ws bnpq:P14 ?wd_url .
-  filter(!strstarts(str(?wd_url), "http")).
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-ORDER BY ?itemLabel
-</sparql>
-=== Oxford and Cambridge academic degrees potential date problems ===
-<sparql tryit="1">
-#title:academic degree Oxford/Cambridge date issues
-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 bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT distinct ?personLabel ?degreeLabel ?byLabel ?subjectLabel
-?date ?date_label  ?s ?person #?subject ?degree ?by ?university
-WHERE {
-  ?person bnwdt:P3 bnwd:Q3 . #select women
-  # academic degree = P59.
-  ?person bnp:P59 ?s .
-    ?s bnps:P59 ?degree . # type of degree
-  # optional qualifiers for degree
-  # P60 subject
-    optional { ?s bnpq:P60 ?subject}
-  # P61 conferred by
-    ?s bnpq:P61 ?by .
-  # date with type
-    ?s ?pq ?date .
-      ?qual_prop wikibase:qualifier ?pq;
-              wikibase:propertyType wikibase:Time ; # nb excludes edtf dates
-              rdfs:label ?date_label . filter(lang(?date_label)="en") . # what kind of date is it.
- # filter: (cambridge (Q1181) and before 1948) OR (oxford (Q364) and before 1920)
-  filter( ( year(?date)<1920 && ?by=bnwd:Q364 ) || ( year(?date)<1948 && ?by=bnwd:Q1181 ) )
-  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".}
-}
-order by ?byLabel ?personLabel ?date ?degreeLabel
-</sparql>
-=== Position held: item v free text ===
-<sparql tryit="1">
-# held position job titles item v held position free text
-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 bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT
-?work_label  ?positionLabel ?position (count(*) as ?count)
-WHERE {
-  ?person bnwdt:P3 bnwd:Q3 . # women
-  # get work activities: held position / held position (free text) /  employed as
-  ?person ( bnp:P17|bnp:P48 ) ?s .
-  ?person ?work_p ?s . # for work type label
-  ?work wikibase:claim ?work_p;
-         rdfs:label ?work_label. filter(lang(?work_label)="en") .
-    # more about the position
-    ?s ( bnps:P17|bnps:P48 ) ?position .
-  FILTER( !isBLANK(?position)  ) . # filter out <unknown value>
- SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-group by ?work_label  ?positionLabel ?position
-order by lcase(str(?positionLabel))
-</sparql>
-==== Women with position held free text ====
-<sparql tryit="1">
-# held position free text job titles
-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 bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT ?person ?personLabel ?positionLabel
-WHERE {
-  ?person bnwdt:P3 bnwd:Q3 . # women
-  # held position (free text)
-  ?person bnwdt:P48  ?position .
- SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-order by ?personLabel ?positionLabel
-</sparql>
-==Tools for batch processing and quality assurance work==
-===All people (by assigned gender), filtering out those already listed as instance of human===
-<sparql tryit="1">
-# All people (by assigned gender), filtering out those already listed as instance of human
-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 ?assigned_genderLabel
-WHERE {
-  ?person bnwdt:P3 ?assigned_gender .                        #select person
-  FILTER NOT EXISTS {?person bnwdt:P12 bnwd:Q2137 .}         #filter out people already listed as instance of human
-  FILTER NOT EXISTS {?person bnwdt:P12 bnwd:Q12 .}            #filter out project team
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-ORDER BY ?personLabel
-</sparql>
-===All places (by coordinate location on wikidata), filtering out places already listed as instance of locality===
-<sparql tryit="1">
-# All places (by coordinate location on wikidata), filtering out places already listed as instance of locality
-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 ?place ?placeLabel ?WDitem ?WDcoordinate_location
-WHERE {
-  ?place bnwdt:P33 ?admin_area .  #select items with 'located in the administrative territorial entity' statements
-  ?place bnwdt:P117 ?Qnumber .    #get wikidata ID
-  FILTER NOT EXISTS {?place bnwdt:P12 bnwd:Q2147 .}       #filter out places already listed as instance of locality
-  #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> {
-        ?WDitem wdt:P625 ?WDcoordinate_location . #get coordinate location on wikidata
-      }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-GROUP BY ?place ?placeLabel ?WDitem ?WDcoordinate_location
-ORDER BY ?placeLabel
-</sparql>
-===All items without a P12 (instance of) triple===
-<sparql tryit="1">
-#title:nearly all items without P12 (instance of)
-#NB: the query will only find items that have at least one statement; this excludes a small number of Qs and a larger number (~35) of Ps.
-#see separate query to find items without any statements
-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/>
-SELECT distinct ?item ?itemLabel
-WHERE {
-   ?item ?b ?c .
-       ?prop wikibase:claim ?b;
-             wikibase:statementProperty ?ps.
-      # ?prop wikibase:propertyType wikibase:WikibaseItem. # limit to P & Q Items. not necessary; only the claim is needed.
-      # weirdness: it still causes some things that are definitely WikibaseItem to be dropped and idk why.
-  FILTER NOT EXISTS {?item bnwdt:P12 ?instance .}
-## FILTER(STRSTARTS(STR(?item), "https://beyond-notability.wikibase.cloud/entity/P")) . # uncomment to limit to P Properties
-## FILTER(STRSTARTS(STR(?item), "https://beyond-notability.wikibase.cloud/entity/Q")) .  # or limit to Q items
-  SERVICE wikibase:label {
-      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb".
-  }
-}
-</sparql>
-===Counts of items for each value of the property "instance of" (P12)===
-<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/>
-SELECT  ?value ?valueLabel  (count(*) as ?count)
-WHERE {
-  VALUES (?p) { (bnwdt:P12) }
-   ?s ?p ?value.
+   #Date literals can be written by adding ^^xsd:dateTime to an ISO 8601 date string: "2012-10-29"^^xsd:dateTime
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-GROUP BY ?value ?valueLabel
-ORDER BY lcase(?valueLabel) # order by is case sensitive
-# or to order by count
-# order by ?count
-</sparql>
-===Get all items (with 'instance of' statement) for duplicate checking in OpenRefine===
-<sparql tryit="1">
-# Get all items (with 'instance of' statement) for duplicate checking in OpenRefine
-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/>
-SELECT ?item ?itemLabel WHERE {
-  ?item bnwdt:P12 ?anything .
-  SERVICE wikibase:label {
-      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
-  }
-}
-ORDER BY ?itemLabel
-</sparql>
-===All uses of <unknown value>===
-<sparql tryit="1">
-# Query to look for uses of <unknown value> (now including qualifiers)
-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/>
-SELECT distinct  ?item ?itemLabel  ?mainLabel ?sub_Label ?unknown_value_forLabel  ?unknown_value_for ?t
-WHERE
-{
- {
-   # qualifiers
-  ?item ?p ?s.
-  ?s ?sub ?sub_ .
-  ?main wikibase:claim ?p.
-  ?main wikibase:statementProperty ?sub.
-  ?s ?pq ?t .
-  ?unknown_value_for wikibase:qualifier ?pq .
-  FILTER( isBLANK(?t)  ) . # filter for <unknown value>
-  }
-  UNION
-  {
-   # top level
-  ?item ?p ?s.
-  ?s ?ps ?t .
-  ?unknown_value_for wikibase:claim ?p.
-  ?unknown_value_for wikibase:statementProperty ?ps.
-  FILTER( isBLANK(?t) ) .
-  }
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
+   bind(year("1911-07-01"^^xsd:dateTime) - year(?dob) as ?age1911 ).
+    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
-ORDER BY ?itemLabel ?unknown_value_forLabel
-</sparql>
-=== Items without any statements ===
-<sparql tryit="1">
-#title:items with 0 statements
-# NB: because of the WQS disappearing data bugs, a few of the items might in reality have n>0 statements. Some may be intentionally empty.
-SELECT distinct ?item  ?itemLabel
+ORDER BY ?personLabel
-WHERE {
-   ?item wikibase:statements 0 .
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-order by ?item
 </sparql>

Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

Revision as of 09:49, 29 June 2024