@@ 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 ==
-=== Women's service on committees etc (P102) ===
 <sparql tryit="1">
+#title:lecturers
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 566: / Line 524: @@
 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
-SELECT distinct ?personLabel ?serviceLabel ?qual_propLabel  ?qualLabel   ?qual ?person ?s # ?service
+WHERE {
-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
+  ?person bnwdt:P3 bnwd:Q3 . # women
-     ?s ?pq ?qual .
-        ?qual_prop wikibase:qualifier ?pq.
+  # work activities: held position / held position (free text) /  employed as
-      } # /quals
+  #?person ( bnp:P17|bnp:P48|bnp:P105 ) ?s .
+  ?person ?work_p ?s . # for activity type label
+    ?work wikibase:claim ?work_p .
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". }
+    ?s ?bnps ?position .
-}
+    # freelance and extension lecturing (q701 and q3021)
+    { ?s ?bnps bnwd:Q701  . } union { ?s ?bnps bnwd:Q3021 .  }
-ORDER BY ?personLabel ?s
+    # 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
+ORDER BY ?person ?s
 </sparql>
-=== Women corresponding with individuals ===
+=== Excavations ===
 <sparql tryit="1">
-#title:women corresponding with individuals
+#title:BN excavations
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 601: / Line 587: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-select ?person ?personLabel ?correspondent ?correspondentLabel  ?qualifier_label
+SELECT ?excavationLabel ?excavation ?locationLabel ?start ?end ?pit
-?qualifier ?qualifierLabel
+?partLabel ?funderLabel ?organisedLabel ?facilitatedLabel ?directorLabel ?memberLabel
+# ?member ?director  ?location ?part ?funder ?facilitated ?organised
+WHERE {
+   # instance of excavation  128
+   ?excavation bnwdt:P12 bnwd:Q38 .
+    optional { ?excavation bnwdt:P2 ?location .}
+    optional { ?excavation bnwdt:P27 ?start . }
-where
+    optional { ?excavation bnwdt:P28 ?end . }
-{
-  ?person bnwdt:P3 bnwd:Q3 .
-   ?person bnp:P73 ?s .
+    optional { ?excavation bnwdt:P1 ?pit. }
-     ?s bnps:P73 ?correspondent . # corresponded with
-     ?correspondent bnwdt:P12 bnwd:Q2137 .  # correspondent is i/o human
+    optional { ?excavation bnwdt:P4 ?part . }
+     optional { ?excavation bnwdt:P36 ?director . }
+     optional { ?excavation bnwdt:P37 ?member . }
+    optional { ?excavation bnwdt:P109 ?organised .}
-     optional
+    optional { ?excavation bnwdt:P121 ?facilitated . }
-      { ?s ?qual_p ?qualifier .
-        ?qual_prop wikibase:qualifier ?qual_p.
+    optional { ?excavation bnwdt:P145 ?funder . }
-        ?qual_prop rdfs:label ?qualifier_label. filter(lang(?qualifier_label)='en') .
-       }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
-ORDER BY ?person
+ORDER BY ?excavationLabel
 </sparql>
-=== Women's service: information about "of" qualifier, including alternatives for locations===
+== Professional Activities and Organisations ==
+=== Women's service on committees etc (P102) ===
 <sparql tryit="1">
-#title: query for served on "of" info
-# where a women served on committee *of* organisation, need to link to info about the organisation, including location.
-# geo data for the location may be in its BN page but is more likely to need to be fetched from wikidata
-# todo: check whether there are orgs that don't have location info in BN but do have it in wikidata
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 640: / Line 635: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?personLabel ?serviceLabel ?of ?ofLabel ?of_location ?of_locationLabel ?of_geo ?of_long ?of_lat ?person #?s
+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 NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-   ?person  bnp:P102 ?s .
+   ?person bnp:P102 ?s .   # served on P102
-    ?s bnps:P102 ?service .
+     ?s bnps:P102 ?service .
-     ?s bnpq:P78 ?of .
+   optional {  #qualifiers, if any
-      #optional { ?of bnwdt:P117 ?of_wikidata.  }   #todo
+     ?s ?pq ?qual .
+        ?qual_prop wikibase:qualifier ?pq.
+      } # /quals
-      optional { ?of bnwdt:P2 ?of_location.
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". }
+}
-            optional { ?of_location bnwdt:P153 ?bn_of_geo . }
+ORDER BY ?personLabel ?s
-            optional { ?of_location bnwdt:P117 ?wd_of_loc .
-                             bind(iri(concat("http://www.wikidata.org/entity/", str(?wd_of_loc))) as ?wd_of_loc_url) .
-                        SERVICE <https://query.wikidata.org/sparql> {
-                        optional {?wd_of_loc_url wdt:P625 ?wd_of_geo .}   # wikidata geocoords
-                         } # /wikidata service
-                     } #/optional location wikidata
-               } #/optional P2 location.
-      BIND(COALESCE(?bn_of_geo, ?wd_of_geo) AS ?of_geo).  # if we have bn_geo use that, then try wd_geo
-      BIND(geof:longitude(?of_geo) AS ?of_long)
-      BIND(geof:latitude(?of_geo)  AS ?of_lat)
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". }
-}
-ORDER BY ?personLabel ?s
 </sparql>
+=== Women corresponding with individuals ===
-=== All activities for women that have instance of public and professional activities===
+<sparql tryit="1">
+#title:women corresponding with individuals
-<sparql tryit="1">
-#title:women and PPA
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 688: / Line 669: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?person ?personLabel ?ppa_label ?ppa ?ppa_valueLabel ?ppa_value ?s
+select ?person ?personLabel ?correspondent ?correspondentLabel  ?qualifier_label
-WHERE {
+?qualifier ?qualifierLabel
+where
+{
    ?person bnwdt:P3 bnwd:Q3 .
-   ?person ?p ?s .
+   ?person bnp:P73 ?s .
-       ?ppa wikibase:claim ?p;
+    ?s bnps:P73 ?correspondent . # corresponded with
-         wikibase:statementProperty ?ps.
+    ?correspondent bnwdt:P12 bnwd:Q2137 .  # correspondent is i/o human
-      SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb".
+     optional
-                ?ppa rdfs:label ?ppa_label.
+       { ?s ?qual_p ?qualifier .
-             } # /label service
+        ?qual_prop wikibase:qualifier ?qual_p.
+        ?qual_prop rdfs:label ?qualifier_label. filter(lang(?qualifier_label)='en') .
+       }
-      ?ppa bnwdt:P12 bnwd:Q151 . # instance of PPA
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-      # get a bit of detail about the ppa
-      ?s ?ps ?ppa_value.
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-order by ?personLabel ?ppa_label
+ORDER BY ?person
 </sparql>
+=== Women's service: information about "of" qualifier, including alternatives for locations===
-===Counts of PPAs for women===
 <sparql tryit="1">
-#title:counting women's instance of PPA
+#title: query for served on "of" info
+# where a women served on committee *of* organisation, need to link to info about the organisation, including location.
+# geo data for the location may be in its BN page but is more likely to need to be fetched from wikidata
+# todo: check whether there are orgs that don't have location info in BN but do have it in wikidata
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 723: / Line 708: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT  ?ppa_label ?ppa  (count(?ppa) as ?count)
+SELECT distinct ?personLabel ?serviceLabel ?of ?ofLabel ?of_location ?of_locationLabel ?of_geo ?of_long ?of_lat ?person #?s
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 .
+   ?person bnwdt:P3 bnwd:Q3 . # select women
-   ?person ?p ?s .
+   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}
-      ?ppa wikibase:claim ?p;
+  ?person  bnp:P102 ?s .
-         wikibase:statementProperty ?ps.
+    ?s bnps:P102 ?service .
+    ?s bnpq:P78 ?of .
-      SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb".
-                       ?ppa rdfs:label ?ppa_label.       # what kind of thing
-                } # /label service
-       ?ppa bnwdt:P12 bnwd:Q151 . # ahhhh at last
+       #optional { ?of bnwdt:P117 ?of_wikidata.  }   #todo
-       # get stuff about ?s
+       optional { ?of bnwdt:P2 ?of_location.
-      #?s ?ps ?ppa_value.
+            optional { ?of_location bnwdt:P153 ?bn_of_geo . }
+            optional { ?of_location bnwdt:P117 ?wd_of_loc .
+                             bind(iri(concat("http://www.wikidata.org/entity/", str(?wd_of_loc))) as ?wd_of_loc_url) .
+                        SERVICE <https://query.wikidata.org/sparql> {
+                        optional {?wd_of_loc_url wdt:P625 ?wd_of_geo .}   # wikidata geocoords
+                         } # /wikidata service
+                     } #/optional location wikidata
+               } #/optional P2 location.
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+      BIND(COALESCE(?bn_of_geo, ?wd_of_geo) AS ?of_geo).  # if we have bn_geo use that, then try wd_geo
+      BIND(geof:longitude(?of_geo) AS ?of_long)
+      BIND(geof:latitude(?of_geo)  AS ?of_lat)
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". }
 }
-group by ?ppa_label ?ppa
+ORDER BY ?personLabel ?s
+</sparql>
-order by desc(?count)
-</sparql>
-=== PPA Buckets for Women ===
+=== All activities for women that have instance of public and professional activities===
 <sparql tryit="1">
-#title:ppa buckets (revised February 2024)
+#title:women and PPA
-# 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 761: / Line 756: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?person ?personLabel ?ppa_label ?ppa ?bucket
+SELECT ?person ?personLabel ?ppa_label ?ppa ?ppa_valueLabel ?ppa_value ?s
-?ppa_value ?ppa_valueLabel
-?s
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 .
@@ Line 769: / Line 762: @@
        ?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.
+                ?ppa rdfs:label ?ppa_label.
-                } # /label service
+             } # /label service
-       ?ppa bnwdt:P12 bnwd:Q151 . # i/o ppa
+       ?ppa bnwdt:P12 bnwd:Q151 . # instance of PPA
-       # get stuff about ?s
+       # get a bit of detail about the ppa
        ?s ?ps ?ppa_value.
-    # note: it would be possible to write this to use ppa rather than ppa_label
-    # 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",
-        if( str(?ppa_label) in ("curated (item)", "donor to", "loaner to", "recovered (free text)", "seller to", "was collector of", "was donor of" ), "collections",
-          if( str(?ppa_label) in ("educated at"),  "education" ,
-            if( str(?ppa_label) in ("election to Council of CAS proposed by", "election to RAI proposed by", "election to SAL proposed by", "proposed election to RHS signed by (personal)"),  "elections" ,
-              if( str(?ppa_label) in ("Member of Committee for Archaeological Fieldwork", "President of Committee for Archaeological Fieldwork", "director of archaeological fieldwork", "director of expedition", "member of excavation during archaeological fieldwork", "member of expedition", "travelled overseas for"
-),   "fieldwork" ,
-                 if( str(?ppa_label) in ("acknowledged for role", "applicant to", "employed as", "held position", "held position (free text)", "served on"),   "positions" ,
-                   if( str(?ppa_label) in ("contributed to", "illustrated in", "work(s) published in"),  "publishing",
-                     if( str(?ppa_label) in ("corresponded with", "was fellow of", "was member of"),  "societies",
-                       if( str(?ppa_label) in ("benefactor to", "fundraiser for", "founded"),  "charitable" ,
-       "none")))))))))
-    as ?bucket).
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
@@ Line 806: / Line 780: @@
-=== Suffrage-related activities ===
+===Counts of PPAs for women===
 <sparql tryit="1">
-#title:initial query for suffrage activities
+#title:counting women's instance of PPA
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 818: / Line 791: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?person ?personLabel ?mainLabel ?sub_Label ?qualLabel ?locationLabel ?date
+SELECT  ?ppa_label ?ppa  (count(?ppa) as ?count)
-# ?pq ?sub_ ?qual ?main ?qual_dateLabel
+WHERE {
-?s
+  ?person bnwdt:P3 bnwd:Q3 .
+  ?person ?p ?s .
+      ?ppa wikibase:claim ?p;
+         wikibase:statementProperty ?ps.
+      SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb".
+                       ?ppa rdfs:label ?ppa_label.       # what kind of thing
+                } # /label service
+      ?ppa bnwdt:P12 bnwd:Q151 . # ahhhh at last
+      # get stuff about ?s
+      #?s ?ps ?ppa_value.
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+group by ?ppa_label ?ppa
+order by desc(?count)
+</sparql>
-WHERE {
+=== PPA Buckets for Women ===
-    ?person bnwdt:P3 bnwd:Q3 . #select women
+<sparql tryit="1">
-    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+#title:ppa buckets (revised February 2024)
+# broad PPA grouping categories to use for overviews and analysis within categories
-    ?person ?p ?s .
-      ?s ?sub ?sub_ .
-        ?main wikibase:claim ?p.
-        ?main wikibase:statementProperty ?sub.
-  # sub_ i/o and yes some do have suffrage activity
-  #  optional { ?sub_ bnwdt:P12 ?sub_io . ?sub_ bnwdt:P12 bnwd:Q1166 . }
-   {
-    # a qualifier (anywhere) has i/o suffrage activity
-       ?s bnpq:P12 bnwd:Q1166.
-       optional { ?s bnpq:P78 ?qual .}
-    }
-     # what about a main rather than qualifier having i/o suffrage activity? i don't think there are any atm but could be.
-# union
- #   { # this might find extra linked i/o suffrage but i'm not sure it works.
- #     ?sub_ bnwdt:P12 bnwd:Q1166 .
- #     }
-  union
-    {
-     # does *not* have i/o suffrage activity in any qualifiers  ...
-     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 .
-      }
-  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:P2 ?location . }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-order by ?personLabel ?mainLabel
-</sparql>
-==Place==
-===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
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 886: / Line 829: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Graph
+SELECT distinct ?person ?personLabel ?ppa_label ?ppa ?bucket
-SELECT ?resident ?residentLabel ?region ?regionLabel
+?ppa_value ?ppa_valueLabel
+?s
 WHERE {
-   ?resident bnwdt:P29 ?residence .
+   ?person bnwdt:P3 bnwd:Q3 .
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2035 .}
+  ?person ?p ?s .
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2036 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2037 .}
+      ?ppa wikibase:claim ?p;
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2038 .}
+         wikibase:statementProperty ?ps.
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2039 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2040 .}
+      # note: i think you need rdfs:label (*Label won't work) for the bind()
-    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===
+      SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb".
+                       ?ppa rdfs:label ?ppa_label.
-<sparql tryit="1">
+                } # /label service
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+      ?ppa bnwdt:P12 bnwd:Q151 . # i/o ppa
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+      # get stuff about ?s
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
+      ?s ?ps ?ppa_value.
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+    # 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",
+        if( str(?ppa_label) in ("curated (item)", "donor to", "loaner to", "recovered (free text)", "seller to", "was collector of", "was donor of" ), "collections",
+          if( str(?ppa_label) in ("educated at"),  "education" ,
+            if( str(?ppa_label) in ("election to Council of CAS proposed by", "election to RAI proposed by", "election to SAL proposed by", "proposed election to RHS signed by (personal)"),  "elections" ,
+              if( str(?ppa_label) in ("Member of Committee for Archaeological Fieldwork", "President of Committee for Archaeological Fieldwork", "director of archaeological fieldwork", "director of expedition", "member of excavation during archaeological fieldwork", "member of expedition", "travelled overseas for"
+),   "fieldwork" ,
+                 if( str(?ppa_label) in ("acknowledged for role", "applicant to", "employed as", "held position", "held position (free text)", "served on"),   "positions" ,
+                   if( str(?ppa_label) in ("contributed to", "illustrated in", "work(s) published in"),  "publishing",
+                     if( str(?ppa_label) in ("corresponded with", "was fellow of", "was member of"),  "societies",
+                       if( str(?ppa_label) in ("benefactor to", "fundraiser for", "founded"),  "charitable" ,
+       "none")))))))))
+    as ?bucket).
-SELECT ?resident ?residentLabel ?residenceLabel ?districtLabel ?countyLabel ?regionLabel
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-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 ?ppa_label
 </sparql>
-===People whose residence was at one time in North East England or Yorkshire and the Humber===
+=== Suffrage-related activities ===
 <sparql tryit="1">
-# People whose residence was at one time in North East England or Yorkshire and the Humber
+#title:initial query for suffrage activities
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 945: / Line 886: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?resident ?residentLabel ?residenceLabel ?districtLabel ?countyLabel ?regionLabel
+SELECT distinct ?person ?personLabel ?mainLabel ?sub_Label ?qualLabel ?locationLabel ?date
+# ?pq ?sub_ ?qual ?main
+?s
 WHERE {
-  ?resident bnwdt:P29 ?residence .
-  ?residence bnwdt:P33 ?district .
-  ?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". }
-}
-ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residenceLabel
-</sparql>
-===People not in London with the district, county, and region at which they were once resident (in the UK) listed===
+    ?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.
-# People not in London with the district, county, and region at which they were once resident (in the UK) listed
+# union
+ #   { # this might find extra linked i/o suffrage but i'm not sure it works.
+ #     ?sub_ bnwdt:P12 bnwd:Q1166 .
+ #     }
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+  union
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+    {
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
+     # does *not* have i/o suffrage activity in any qualifiers  ... slows things right down and doesn't seem to make any difference to results?
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+     #filter not exists { ?s bnpq:P12 bnwd:Q1166. }
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
+     # ... but a qualifier *does* have i/o suffrage activity. i think!
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+      ?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 ?district ?districtLabel ?county ?countyLabel ?region ?regionLabel
-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". }
 }
-ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residentLabel
+order by ?personLabel ?mainLabel
 </sparql>
-===People sorted by the number of places they lived, including the number of cites/towns/villages they lived in===
+==Place==
+=== All the things in BN that can be mapped ===
 <sparql tryit="1">
+#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 1,004: / Line 960: @@
 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 distinct ?locationLabel ?location ?wikidata ?wd_geo
-   ?person bnwdt:P3 bnwd:Q3 ;
-         wikibase:statements ?statements .
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-  ?person bnp:P29/bnps:P29 ?resided.
-  SERVICE wikibase:label {
-      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
-  }
-} group by ?person ?personLabel ?statements order by desc(?residence_count)
-# Credit to @Tagishsimon for helping me figure out the counting logic here
-</sparql>
-===Places at which women resided, sorted by how many residences all women had at a given village/town/city/London area===
+WHERE {
+       ?location bnwdt:P117 ?ws .  # wikidata id
+         bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
+         SERVICE <https://query.wikidata.org/sparql> {
+             ?wikidata wdt:P625 ?wd_geo .  # does the wikidata page have geocoords?
+         } # /wikidata service
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+}
+ORDER BY ?wikidata ?locationLabel
+</sparql>
+===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">
-# Places at which women resided, sorted by how many residences all women had at a given village/town/city/London area
+# 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 1,029: / Line 989: @@
 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
+#defaultView:Graph
+SELECT ?resident ?residentLabel ?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 .}
+    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 ?residence ?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 whose residence was at one time in the east or south east of England, excluding London===
 <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)
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,053: / Line 1,021: @@
 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 ?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 .
-  ?residence bnwdt:P33 ?district . #select districts
+   ?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". }
 }
-GROUP BY ?district ?districtLabel
+ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residenceLabel
-ORDER BY DESC(?district_count)
 </sparql>
-===Counties in which women resided, sorted by how many residences all women had in that county===
+===People whose residence was at one time in North East England or Yorkshire and the Humber===
 <sparql tryit="1">
-# Counties in which women resided, sorted by how many residences all women had in that county
+# 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 1,078: / Line 1,048: @@
 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 ?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 .
-   ?residence bnwdt:P33 ?district . #select districts
+   ?county bnwdt:P33 ?region .
-  ?district bnwdt:P33 ?county . #select counties
+    {?county bnwdt:P33 bnwd:Q72 .}
+    UNION
+    {?county bnwdt:P33 bnwd:Q200 .}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-GROUP BY ?county ?countyLabel
+ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residenceLabel
-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====
+===People not in London with the district, county, and region at which they were once resident (in the UK) listed===
 <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
+# 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 1,104: / Line 1,075: @@
 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 ?resident ?residentLabel ?district ?districtLabel ?county ?countyLabel ?region ?regionLabel
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . # select women
+   ?resident bnwdt:P29 ?residence .
-  ?person bnwdt:P76 bnwd:Q419 . #select women recorded in CAS Indexes of Archaeological Papers
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2035 .}
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2036 .}
-  ?person bnwdt:P29 ?residence . # select residences
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2037 .}
-   ?residence bnwdt:P33 ?district . #select districts
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2038 .}
-   ?district bnwdt:P33 ?county . #select counties
+    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 ?county ?countyLabel
+ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residentLabel
-ORDER BY DESC(?county_count)
 </sparql>
-====Counties of residence for women nominated as FSAs, 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 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/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,131: / 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 .
-  ?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
+   ?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 nominated to RAI, 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 nominated to RAI, 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,158: / 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: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
    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 who spoke at RAI meetings, 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 who spoke at RAI meetings, 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,185: / 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: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
    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 who exhibited at RAI meetings, 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 who exhibited at RAI meetings, 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,215: / Line 1,184: @@
 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
@@ Line 1,226: / Line 1,194: @@
 </sparql>
-====Counties of residence for women recorded in CAS Indexes of Archaeological Papers, on a map====
+====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 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,238: / Line 1,207: @@
 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
@@ Line 1,249: / Line 1,215: @@
    ?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 .
-         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
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
 </sparql>
-====Counties of residence for women nominated as FSAs, on a map====
+====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 nominated as FSAs, sorted by how many residences all women had in that county
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,284: / Line 1,234: @@
 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
    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 nominated to RAI, 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 nominated to RAI, 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: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
    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 who spoke at RAI meetings, sorted by how many residences all women had in that county====
-==== Counties of residence for women nominated to RAI, 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
-<sparql tryit="1">
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,327: / 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 to RAI
-SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
+  ?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:P7 ?signatory . #select women who were nominated for election to RAI
    ?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 {
-       ?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 ?county ?countyLabel
+ORDER BY DESC(?county_count)
 </sparql>
-==== Counties of residence for women who spoke at RAI meetings, on a map====
+====Counties of residence for women who exhibited at RAI meetings, 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
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,369: / Line 1,315: @@
 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 who spoke at RAI meetings
-SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 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:P23 bnwd:Q29 . #select women who spoke at RAI Meeting
    ?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 recorded in CAS Indexes of Archaeological Papers, on a map====
-      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". }
-}
-</sparql>
-==== Counties of residence for women who exhibited at RAI meetings, 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/>
@@ Line 1,415: / Line 1,342: @@
 #defaultView:Map{"hide":["?geo", "?wikidata"]}
+#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:P13 bnwd:Q29 . #select women who exhibited at RAI Meeting
+   ?person bnwdt:P29 ?residence . # select residences
+  ?residence bnwdt:P33 ?district . #select p33 of residence
+  ?district bnwdt:P33 ?next . #select p33 of district, mostly counties but a few region/outside uk
+  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).
+    }
-   ?person bnwdt:P29 ?residence . # select residences
+   # if next=q4207 uk region, then use ?district for county, ifelse in uk use ?next, else not in uk use ?district.
-   ?residence bnwdt:P33 ?district . #select districts
+   bind(
-  ?district bnwdt:P33 ?county . #select counties
+      if( bound(?region), ?district, # region first (because also uk)
-      optional { ?county bnwdt:P153 ?geo2 .  } # for geocoords added to BN
+        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 {
+    optional {
         ?county bnp:P117 ?ws .  # wikidata id P117
           ?ws bnpq:P14 ?wikidata_url .
@@ Line 1,434: / 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,444: / Line 1,395: @@
 </sparql>
-==== Counties of residence for women in any of the above five categories, mapped====
+====Counties of residence for women nominated as FSAs, on a map====
 <sparql tryit="1">
-## IMPORTANT: LIMITATIONS OF THE MAP
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-## 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/>
 PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
@@ Line 1,461: / Line 1,407: @@
 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 nominated as FSAs
-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
+  ?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
-  {
-    #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,503: / Line 1,427: @@
        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 nominated to RAI, on a map ====
 <sparql tryit="1">
-# Regions in which women resided, sorted by how many residences all women had in that region
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,526: / Line 1,450: @@
 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"]}
+#title:Counties of residence for women nominated to RAI
+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:P7 ?signatory . #select women who were nominated for election to RAI
    ?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 who spoke at RAI meetings, on a map====
-=== 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/>
@@ Line 1,556: / Line 1,492: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?personLabel ?date_label ?date ?person ?address ?address_item ?londonLabel ?geo ?long ?lat
+#defaultView:Map{"hide":["?geo", "?wikidata"]}
+#title:Counties of residence for women who spoke at RAI meetings
+SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 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 .
+   ?person bnwdt:P23 bnwd:Q29 . #select women who spoke at RAI Meeting
-      ?london bnwdt:P33+ bnwd:Q322 .  # in Q322 greater london.
-    # optional street address (text)
+  ?person bnwdt:P29 ?residence . # select residences
-   optional {
+  ?residence bnwdt:P33 ?district . #select districts
-    ?s bnpq:P31 ?address .
+  ?district bnwdt:P33 ?county . #select counties
-    }
+      optional { ?county bnwdt:P153 ?geo2 .  } # for geocoords added to BN
-  # optional street address (item)
-   optional {
+      optional {
-     ?s bnpq:P100 ?address_item .
+       ?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
-  # dates. About 30? not dated.
+     BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
-     #optional {
-    ?s ?pq ?date .
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-     # ?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
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-ORDER BY ?person ?date
 </sparql>
-==== Map of Women living in 1890s London ====
+==== Counties of residence for women who exhibited at RAI meetings, on a map ====
 <sparql tryit="1">
-#title:Women living in 1890s London
+#title:Counties of residence for women who exhibited at RAI meetings
-# 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,618: / Line 1,537: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Map
+#defaultView:Map{"hide":["?geo", "?wikidata"]}
-SELECT distinct ?personLabel ?date_label ?date ?person ?address ?address_item ?londonLabel ?geo ?long ?lat
+SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 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 .
+  ?person bnwdt:P13 bnwd:Q29 . #select women who exhibited at RAI Meeting
-      ?london bnwdt:P33+ bnwd:Q322 .  # in Q322 greater london.
-    # optional street address (text)
+  ?person bnwdt:P29 ?residence . # select residences
-   optional {
+   ?residence bnwdt:P33 ?district . #select districts
-    ?s bnpq:P31 ?address .
+   ?district bnwdt:P33 ?county . #select counties
-    }
+      optional { ?county bnwdt:P153 ?geo2 .  } # for geocoords added to BN
-   # optional street address (item)
-  optional {
+      optional {
-    ?s bnpq:P100 ?address_item .
+       ?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 )
-   # dates. About 30? not dated.
-    #optional {
+      SERVICE <https://query.wikidata.org/sparql> {
-     ?s ?pq ?date .
-     # ?date wikibase:timeValue ?date_value. # if you don't want date label this should work instead
+         optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available
+       } # /wikidata service
-      ?qual_prop wikibase:qualifier ?pq;
+       } #/wikidata optional
-              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).
+    BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
-  # 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
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-ORDER BY ?person ?date
 </sparql>
-=== Where did women who published in Folklore/Folk-lore Record live? ===
+==== Counties of residence for women in any of the above five categories, mapped====
 <sparql tryit="1">
-# Map of all places of residence for women who had publications in Folklore/Folk-lore Record
+## 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,678: / Line 1,584: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Map{"hide":["?geo", "?count"]}
+#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  ?person ?personLabel ?residenceLabel ?residence ?geo (count( ?person) as ?count)  #(concat(str(?count), " publication") as ?count_lbl)
+SELECT distinct  ?county ?countyLabel ?wikidata ?geo  ?layer  #?person ?personLabel
 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 .
+   {
+    #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 .
+  }
-   ## works published in P101. folklore / folk-lore record q487 q490
+   # get the p labels for layers
-      ?s bnpq:P101 ?in .
+  ?person ?p ?stmt .
-      {?s bnpq:P101 bnwd:Q487 } union { ?s bnpq:P101 bnwd:Q490 . }
+  ?claim wikibase:claim ?p;
-      # why does above pick up these two journals as well?
+        rdfs:label ?layer. filter(lang(?layer)="en-gb").
-       FILTER ( ?in not in ( bnwd:Q665 , bnwd:Q636 ) ) .
+  # get geo stuff
+  ?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
-  ?person bnwdt:P29  ?residence .
+       optional {
-       optional { ?residence bnwdt:P153 ?geo2 .  } # for geocoords added to BN
+        ?county bnp:P117 ?ws .  # wikidata id P117
-   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 )
-       SERVICE <https://query.wikidata.org/sparql> {
+      SERVICE <https://query.wikidata.org/sparql> {
+         optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available
-       optional {?wikidata wdt:P625 ?geo1 .  } # geocoords if available
+        } # /wikidata service
+       } #/wikidata optional
-      } # /wikidata service
-    } #/wikidata optional
-     BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
+     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". }
 }
-group by ?person ?personLabel ?residenceLabel ?residence ?geo
+order by ?layer
-ORDER BY ?geo
 </sparql>
+===Regions in which women resided, sorted by how many residences all women had in that region===
-=== BN people and other things located near Devizes ===
+<sparql tryit="1">
+# Regions in which women resided, sorted by how many residences all women had in that region
-<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/>
@@ Line 1,731: / Line 1,648: @@
 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
+SELECT ?region ?regionLabel (count(?region) as ?region_count) #count number of regions in which women lived
 WHERE {
+   ?person bnwdt:P3 bnwd:Q3 . # select women
-  {?item bnwdt:P29  ?location . } # resided at location
+   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-   #union
+   ?person bnwdt:P29 ?residence . # select residences
-  #{?location bnwdt:P12 bnwd:Q2147 .} # OR location has instance of locality. is there a way to get this in the same structure?
+   ?residence bnwdt:P33 ?district . #select districts
-  union
+   ?district bnwdt:P33 ?county . #select counties
-   {?item bnwdt:P2  ?location . } # item has property P2 location
+   ?county bnwdt:P33 ?region . #select region
-   # any other possibles ?
+  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". }
-  ## 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
+GROUP BY ?region ?regionLabel
+ORDER BY DESC(?region_count)
 </sparql>
-=== BN items near a chosen location ===
+=== Women living in London during the 1890s ===
 <sparql tryit="1">
+#title:Women living in 1890s London
-#title:a map of BN items near a chosen starting point in the UK
+# Query for women living in (greater) london in the 1890s
-#defaultView:Map
+# 1 row per person per address per date, could be reduced to 1 row per person if preferred.
-## create a thingy for the start point change the Qxxx ID in the following PREFIX var_start line to chosen location.
-## **MUST** a) be in UK and b) have a wikidata item that has coordinate location!
-PREFIX var_start: <https://beyond-notability.wikibase.cloud/entity/Q5>  # (Q5=sheffield)
-## to change the distance you can edit the filter(?distance < xx) line near the end of the query.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,782: / Line 1,679: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-## TODO is there a way to get the location itemLabel and use it in the map title...
+SELECT distinct ?personLabel ?date_label ?date ?person ?address ?address_item ?londonLabel ?geo ?long ?lat
-SELECT distinct  ?item ?itemLabel ?locationLabel ?location ?wikidata ?wd_geo  ?distance #?wd_long ?wd_lat
 WHERE {
-   var_start: bnwdt:P117 ?start_wd_id .
+   ?person bnwdt:P3 bnwd:Q3 . # women
-  bind(iri(concat("http://www.wikidata.org/entity/", str(?start_wd_id))) as ?start_wd) .
+   ?person bnp:P29 ?s .   # resided at
+    ?s bnps:P29 ?london .
-  {?item bnwdt:P29  ?location . } # resided at location
+      ?london bnwdt:P33+ bnwd:Q322 .  # in Q322 greater london.
-  union
-  {?item bnwdt:P2  ?location . } # item has property P2 location
-  # other possibles ?
-  ## limit to places in admin territory p33 uk q1741 seems ok. put it back to england q617 if there are any timeout problems. (keep numbers down to avoid wikidata timing out)
-  ?location bnwdt:P33+ bnwd:Q1741.
-  ?location bnwdt:P117 ?ws .  # wikidata id
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
-         SERVICE <https://query.wikidata.org/sparql> {
-             ?start_wd wdt:P625 ?start. # start_wd coordinates.
-             ?wikidata wdt:P625 ?wd_geo .
-         } # /wikidata service
-     #BIND(geof:longitude(?wd_geo) AS ?wd_long) .
-     #BIND(geof:latitude(?wd_geo)  AS ?wd_lat) .
-     bind(geof:distance(?wd_geo, ?start) as ?distance).
-     FILTER(?distance < 40). # < xx km from start_wd
+    # optional street address (text)
+  optional {
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+    ?s bnpq:P31 ?address .
-}
+    }
-ORDER BY ?locationLabel
+   # optional street address (item)
+   optional {
+    ?s bnpq:P100 ?address_item .
+    }
-</sparql>
+  # dates. About 30? not dated.
+    #optional {
+    ?s ?pq ?date .
+     # ?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).
-=== Locations of BN excavations ===
+  # 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
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+ORDER BY ?person ?date
+</sparql>
+==== Map of Women living in 1890s London ====
 <sparql tryit="1">
-#title:Locations of BN excavations
+#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,827: / Line 1,740: @@
 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 ?adminterr ?wikidata ?wd_geo
+SELECT distinct ?personLabel ?date_label ?date ?person ?address ?address_item ?londonLabel ?geo ?long ?lat
 WHERE {
-   ?item bnwdt:P12 bnwd:Q38 .
+   ?person bnwdt:P3 bnwd:Q3 . # women
+   ?person bnp:P29 ?s .   # resided at
-  {
+    ?s bnps:P29 ?london .
-   ?item bnwdt:P2  ?location .  # item has property P2 location
+      ?london bnwdt:P33+ bnwd:Q322 .  # in Q322 greater london.
-  optional { ?location bnwdt:P33 ?adminterr .
+    # optional street address (text)
-               ?adminterr bnwdt:P117 ?wsa .  # and has wikidata id
-            bind(iri(concat("http://www.wikidata.org/entity/", str(?wsa))) as ?wikidataa) .
-               SERVICE <https://query.wikidata.org/sparql> {
-               ?wikidataa wdt:P625 ?wd_geo2 .
-             } # /wikidata service
-           }
    optional {
-  ?location bnwdt:P117 ?ws .  # and has wikidata id
+     ?s bnpq:P31 ?address .
-     bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
-         SERVICE <https://query.wikidata.org/sparql> {
-             ?wikidata wdt:P625 ?wd_geo1 .
-         } # /wikidata service
      }
-   }
+   # optional street address (item)
-  union
-  {
-  filter not exists {?item bnwdt:P2  ?location . } # item doesn't have property P2 location
    optional {
-  ?item bnwdt:P117 ?wikidata_id .  # but has wikidata id
+    ?s bnpq:P100 ?address_item .
-   bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
+    }
-  SERVICE <https://query.wikidata.org/sparql> {
+   # dates. About 30? not dated.
-               ?wikidata wdt:P625 ?wd_geo1 .
+    #optional {
-             } # /wikidata service
+    ?s ?pq ?date .
-    }
+     # ?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).
-   }
-  BIND(COALESCE(?wd_geo1, ?wd_geo2) AS ?wd_geo).  # if geo1 available use that, then try geo2
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+  # 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
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-ORDER BY ?locationLabel
+ORDER BY ?person ?date
 </sparql>
-=== Locations of archaeological sites ===
+=== Where did women who published in Folklore/Folk-lore Record live? ===
 <sparql tryit="1">
-#title:Locations of BN archaeological sites
+# Map of all places of residence for women who had publications in Folklore/Folk-lore Record
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,886: / 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 ?adminterrLabel ?adminterr ?wikidata ?wd_geo
+#defaultView:Map{"hide":["?geo", "?count"]}
+SELECT  ?person ?personLabel ?residenceLabel ?residence ?geo (count( ?person) as ?count)  #(concat(str(?count), " publication") as ?count_lbl)
 WHERE {
-   ?item bnwdt:P12 bnwd:Q86 .
+   ?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 .
-   {
+   ## works published in P101. folklore / folk-lore record q487 q490
-    ?item bnwdt:P2  ?location .  # item has property P2 location
+      ?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 ) ) .
-   optional { ?location bnwdt:P33 ?adminterr .
+   ?person bnwdt:P29  ?residence .
-               ?adminterr bnwdt:P117 ?wsa .  # and has wikidata id
+      optional { ?residence bnwdt:P153 ?geo2 .  } # for geocoords added to BN
+   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(?wsa))) as ?wikidataa) .
+       SERVICE <https://query.wikidata.org/sparql> {
-               SERVICE <https://query.wikidata.org/sparql> {
-               ?wikidataa wdt:P625 ?wd_geo2 .
-             } # /wikidata service
-           }
-  optional {
-  ?location bnwdt:P117 ?ws .  # and has wikidata id
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
-         SERVICE <https://query.wikidata.org/sparql> {
-             ?wikidata wdt:P625 ?wd_geo1 .
-         } # /wikidata service
-  }
-     }
+       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
-   union
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
-  {
+group by ?person ?personLabel ?residenceLabel ?residence ?geo
-      filter not exists {?item bnwdt:P2  ?location . } # item doesn't have property P2 location
+ORDER BY ?geo
+</sparql>
-  ?item bnwdt:P117 ?wikidata_id .  # but has wikidata id
+=== BN people and other things located near Devizes ===
-  bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
-  SERVICE <https://query.wikidata.org/sparql> {
-               ?wikidata wdt:P625 ?wd_geo1 .   # which has geo coords
-             } # /wikidata service
-   }
-  BIND(COALESCE(?wd_geo1, ?wd_geo2) AS ?wd_geo).  # if geo1 available use that, then try geo2
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-ORDER BY ?locationLabel
-</sparql>
-=== Locations of historic houses ===
 <sparql tryit="1">
-#title:locations of BN historic houses
+## 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/>
@@ Line 1,947: / Line 1,855: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
 #defaultView:Map
-SELECT distinct ?item ?itemLabel ?locationLabel ?location ?wikidata ?wd_geo
+SELECT distinct ?item ?itemLabel ?locationLabel ?location ?wikidata ?wd_geo ?wd_long ?wd_lat
 WHERE {
-  ?item bnwdt:P12 bnwd:Q2961 .
-  {
-  ?item bnwdt:P2  ?location .  # item has property P2 location
+  {?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 ?
-   optional { ?location bnwdt:P33 ?adminterr .
+   ## limit to places in admin territory p33 england q617. (keep numbers down to avoid wikidata timing out)
-               ?adminterr bnwdt:P117 ?wsa .  # and has wikidata id
+  ?location bnwdt:P33+ bnwd:Q617.
+  ?location bnwdt:P117 ?ws .  # wikidata id
-            bind(iri(concat("http://www.wikidata.org/entity/", str(?wsa))) as ?wikidataa) .
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
-               SERVICE <https://query.wikidata.org/sparql> {
+         SERVICE <https://query.wikidata.org/sparql> {
-               ?wikidataa wdt:P625 ?wd_geo2 .
+             wd:Q1026699 wdt:P625 ?start. # devizes coordinates
-              } # /wikidata service
+              ?wikidata wdt:P625 ?wd_geo .
-           }
+                      #BIND(geof:longitude(?wd_geo) AS ?wd_long) .
+                      #BIND(geof:latitude(?wd_geo)  AS ?wd_lat) .
-  optional {
+              FILTER(geof:distance(?wd_geo, ?start) < 30). # < 30 km from ?start.
-  ?location bnwdt:P117 ?ws .  # and has wikidata id
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
-         SERVICE <https://query.wikidata.org/sparql> {
-             ?wikidata wdt:P625 ?wd_geo1 .
           } # /wikidata service
-  }
-   }
-   union
-   {
-  filter not exists {?item bnwdt:P2  ?location . } # item doesn't have property P2 location
-  ?item bnwdt:P117 ?wikidata_id .  # but has wikidata id
-  bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
-  SERVICE <https://query.wikidata.org/sparql> {
-               ?wikidata wdt:P625 ?wd_geo1 .
-             } # /wikidata service
-   }
-  BIND(COALESCE(?wd_geo1, ?wd_geo2) AS ?wd_geo).  # if geo1 available use that, then try geo2
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
@@ Line 1,996: / Line 1,883: @@
 </sparql>
-=== Residences of women participants in Colchester excavations ===
+=== BN items near a chosen location ===
 <sparql tryit="1">
-#title:Excavations at Colchester: where women participants lived
-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 ?person ?personLabel ?resided ?residedLabel ?wd_geo
-WHERE {
-  values (?item) { (bnwd:Q90) }   # q90 colchester
-  ?item bnwdt:P12 bnwd:Q38 .
-  ?item bnwdt:P2  ?location .  # item has property P2 location
-  ?item (bnwdt:P36 | bnwdt:P37 ) ?person .
-  #optional { ?item bnwdt:P36 ?director . }
-  #optional { ?item bnwdt:P37 ?member . }
-  optional { ?person bnwdt:P29 ?resided .
-               ?resided bnwdt:P117 ?wsa .  # and has wikidata id
-            bind(iri(concat("http://www.wikidata.org/entity/", str(?wsa))) as ?wikidataa) .
-               SERVICE <https://query.wikidata.org/sparql> {
-               ?wikidataa wdt:P625 ?wd_geo .
-             } # /wikidata service
-           }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-ORDER BY ?locationLabel
-</sparql>
-=== IWD 2024 Map of five women's places ===
+#title:a map of BN items near a chosen starting point in the UK
+#defaultView:Map
+## create a thingy for the start point change the Qxxx ID in the following PREFIX var_start line to chosen location.
+## **MUST** a) be in UK and b) have a wikidata item that has coordinate location!
+PREFIX var_start: <https://beyond-notability.wikibase.cloud/entity/Q5>  # (Q5=sheffield)
-<sparql tryit="1">
+## to change the distance you can edit the filter(?distance < xx) line near the end of the query.
-## 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 2,048: / Line 1,905: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Map{"hide":["?geo"],"layer":"?person", "markercluster":true }
+## TODO is there a way to get the location itemLabel and use it in the map title...
-SELECT distinct ?person ?personLabel  ?propLabel ?placeLabel  ?geo  ?loc2Label (year(?date) as ?year)
+SELECT distinct  ?item ?itemLabel ?locationLabel ?location ?wikidata ?wd_geo  ?distance #?wd_long ?wd_lat
 WHERE {
+  var_start: bnwdt:P117 ?start_wd_id .
+  bind(iri(concat("http://www.wikidata.org/entity/", str(?start_wd_id))) as ?start_wd) .
+  {?item bnwdt:P29  ?location . } # resided at location
+  union
+  {?item bnwdt:P2  ?location . } # item has property P2 location
+  # other possibles ?
+  ## limit to places in admin territory p33 uk q1741 seems ok. put it back to england q617 if there are any timeout problems. (keep numbers down to avoid wikidata timing out)
+  ?location bnwdt:P33+ bnwd:Q1741.
+  ?location bnwdt:P117 ?ws .  # wikidata id
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
+         SERVICE <https://query.wikidata.org/sparql> {
+             ?start_wd wdt:P625 ?start. # start_wd coordinates.
+             ?wikidata wdt:P625 ?wd_geo .
+         } # /wikidata service
+     #BIND(geof:longitude(?wd_geo) AS ?wd_long) .
+     #BIND(geof:latitude(?wd_geo)  AS ?wd_lat) .
+     bind(geof:distance(?wd_geo, ?start) as ?distance).
-   VALUES (?person) {(bnwd:Q894) (bnwd:Q462) (bnwd:Q549) (bnwd:Q921) (bnwd:Q1053) }  #
+     FILTER(?distance < 40). # < xx km from start_wd
-   ?person ( bnp:P29 | bnp:P94  | bnp:P23 | bnp:P13 | bnp:P120   ) ?s .
-   ?s  ( bnps:P29 | bnps:P94  | bnps:P23 | bnps:P13 | bnps:P120   )  ?place .
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+}
+ORDER BY ?locationLabel
+</sparql>
-   ?person ?p ?s .
+=== Locations of BN excavations ===
-      ?prop wikibase:claim ?p;
-         wikibase:statementProperty ?ps.
-      optional { ?s ( bnpq:P1 | bnpq:P27 ) ?date . }
+<sparql tryit="1">
-      #optional { ?s bnpq:P31 ?street . }
+#title:Locations of BN excavations
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-  # LOLplaces
+PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-  #1 geocoords in quals for place itself - should be detailed geo added manually, cf London district geocoords which =main P153
+PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-  #2 wikdiata geocoords for place
+PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-  #3 geocoords in quals for linked place
+PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-  #4 wikidata geocoords for linked place
+PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-  #5 wikidata geocoords in place P2 qual
+PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-  #6 `of` qual geocoords
+#defaultView:Map
-   #7 `of` P2 wikidata geocoords
+SELECT distinct ?item ?itemLabel ?locationLabel ?location ?adminterr ?wikidata ?wd_geo
-  #8 `of` wikidata geocoords
+WHERE {
-   #9 place main geocoords - likely to be broad london postal districts so should be last resort
+   ?item bnwdt:P12 bnwd:Q38 .
-   #10 linked place main geocoords
+   {
+   ?item bnwdt:P2  ?location .  # item has property P2 location
+  optional { ?location bnwdt:P33 ?adminterr .
+               ?adminterr bnwdt:P117 ?wsa .  # and has wikidata id
-      optional { ?s bnpq:P153 ?geo1 . } # place has geocoords directly *in qualifier*
+            bind(iri(concat("http://www.wikidata.org/entity/", str(?wsa))) as ?wikidataa) .
+               SERVICE <https://query.wikidata.org/sparql> {
+               ?wikidataa wdt:P625 ?wd_geo2 .
+             } # /wikidata service
+           }
-      optional { ?place bnwdt:P2 ?linked_p1 . # linked place has geocoords *in qualifier* (this is primarily for SAL?)
+  optional {
-                     ?linked_p1 bnp:P2 ?llp_s .
+  ?location bnwdt:P117 ?ws .  # and has wikidata id
-                        ?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(?ws))) as ?wikidata) .
-                   bind(iri(concat("http://www.wikidata.org/entity/", str(?pws))) as ?pwikidata) .
+         SERVICE <https://query.wikidata.org/sparql> {
-                   SERVICE <https://query.wikidata.org/sparql> {
+             ?wikidata wdt:P625 ?wd_geo1 .
-                     ?pwikidata wdt:P625 ?geo3 .
+         } # /wikidata service
-                  }
+    }
-                }
+   }
+   union
-      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
+  filter not exists {?item bnwdt:P2  ?location . } # item doesn't have property P2 location
-                     ?qp1 bnwdt:P117 ?qws .
-                     bind(iri(concat("http://www.wikidata.org/entity/", str(?qws))) as ?qwikidata) .
+  optional {
-                     SERVICE <https://query.wikidata.org/sparql> {
+  ?item bnwdt:P117 ?wikidata_id .  # but has wikidata id
-                      ?qwikidata wdt:P625 ?geo5 .
+  bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
-                     }
-                 }
-      optional { ?s bnpq:P78 ?ofp1 . # 'of' (organisation) has geocoords in P2 qualifier
+  SERVICE <https://query.wikidata.org/sparql> {
-                    ?ofp1 bnp:P2 ?ofp1_s .
+               ?wikidata wdt:P625 ?wd_geo1 .
-                     ?ofp1_s bnps:P2 ?ofp1_p .
+             } # /wikidata service
-                     ?ofp1_s bnpq:P153 ?geo6 . }
+    }
+   }
+  BIND(COALESCE(?wd_geo1, ?wd_geo2) AS ?wd_geo).  # if geo1 available use that, then try geo2
-      optional { ?s bnpq:P78 ?ofp2 . # 'of' (organisation) P2 location has wikidata geocoords
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-                    ?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". }
 }
+ORDER BY ?locationLabel
-order by ?personLabel ?date ?placeLabel
 </sparql>
-==People==
+=== Locations of archaeological sites ===
-===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
+#title:Locations of BN archaeological sites
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,162: / Line 2,009: @@
 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 ?adminterrLabel ?adminterr ?wikidata ?wd_geo
-SELECT ?person ?personLabel ?birthname ?marriedname
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . #select women
+   ?item bnwdt:P12 bnwd:Q86 .
-   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
+    ?item bnwdt:P2  ?location .  # item has property P2 location
+  optional { ?location bnwdt:P33 ?adminterr .
+               ?adminterr bnwdt:P117 ?wsa .  # and has wikidata id
+            bind(iri(concat("http://www.wikidata.org/entity/", str(?wsa))) as ?wikidataa) .
+               SERVICE <https://query.wikidata.org/sparql> {
+               ?wikidataa wdt:P625 ?wd_geo2 .
+             } # /wikidata service
+           }
+  optional {
+  ?location bnwdt:P117 ?ws .  # and has wikidata id
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
+         SERVICE <https://query.wikidata.org/sparql> {
+             ?wikidata wdt:P625 ?wd_geo1 .
+         } # /wikidata service
+  }
+    }
+  union
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+   {
-}
+      filter not exists {?item bnwdt:P2  ?location . } # item doesn't have property P2 location
-ORDER BY ?personLabel
-</sparql>
-=== Women with family name at birth, married name and count of married names===
-<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/>
+  ?item bnwdt:P117 ?wikidata_id .  # but has wikidata id
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+  bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
-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 ?birthname
-        (GROUP_CONCAT(DISTINCT ?marriedname; SEPARATOR=", ") AS ?marriednames)
-        (COUNT(?marriedname) AS ?marriedcount)
-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
+   SERVICE <https://query.wikidata.org/sparql> {
-   OPTIONAL {?person bnwdt:P141 ?marriedname .} #look for married name
+               ?wikidata wdt:P625 ?wd_geo1 .   # which has geo coords
+             } # /wikidata service
+   }
+   BIND(COALESCE(?wd_geo1, ?wd_geo2) AS ?wd_geo).  # if geo1 available use that, then try geo2
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
-group by ?person ?personLabel ?birthname
+ORDER BY ?locationLabel
-ORDER BY ?personLabel
 </sparql>
-===Where women in our data are in wikidata, their spouses, fathers, and mothers according to wikidata===
+=== Locations of historic houses ===
 <sparql tryit="1">
+#title:locations of BN historic houses
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,216: / Line 2,069: @@
 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/>
+#defaultView:Map
-PREFIX wd:  <http://www.wikidata.org/entity/>
+SELECT distinct ?item ?itemLabel ?locationLabel ?location ?wikidata ?wd_geo
-SELECT ?person ?personLabel ?item ?WD_spouse ?WD_father ?WD_mother
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . #select women
+   ?item bnwdt:P12 bnwd:Q2961 .
-   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+   {
-   ?person bnp:P117 ?wikidata_ID . #look for wikidata ID on person page
+   ?item bnwdt:P2  ?location .  # item has property P2 location
-   ?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> {
+   optional { ?location bnwdt:P33 ?adminterr .
-        ?item wdt:P21 ?WD_gender. #get gender of person
+               ?adminterr bnwdt:P117 ?wsa .  # and has wikidata id
-        OPTIONAL {?item wdt:P22 ?WD_father . } #recall father
-        OPTIONAL {?item wdt:P25 ?WD_mother . } #recall mother
+            bind(iri(concat("http://www.wikidata.org/entity/", str(?wsa))) as ?wikidataa) .
-        OPTIONAL {?item wdt:P26 ?WD_spouse . } #recall spouse
+               SERVICE <https://query.wikidata.org/sparql> {
-      }
+               ?wikidataa wdt:P625 ?wd_geo2 .
+             } # /wikidata service
+           }
+  optional {
+  ?location bnwdt:P117 ?ws .  # and has wikidata id
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
-}
+         SERVICE <https://query.wikidata.org/sparql> {
-ORDER BY ?personLabel
+             ?wikidata wdt:P625 ?wd_geo1 .
-# with thanks to @tagishsimon for writing this one initially!
+         } # /wikidata service
-</sparql>
+  }
-===Women in our data alongside counts of their public and professional activities, sorted by total===
+   }
+   union
+   {
+  filter not exists {?item bnwdt:P2  ?location . } # item doesn't have property P2 location
-<sparql tryit="1">
+  ?item bnwdt:P117 ?wikidata_id .  # but has wikidata id
-## Women in our data alongside counts of their public and professional activities (https://beyond-notability.wikibase.cloud/wiki/Item:Q151)
+  bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
-## Sorted by total PPAs
+  SERVICE <https://query.wikidata.org/sparql> {
+               ?wikidata wdt:P625 ?wd_geo1 .
+             } # /wikidata service
+   }
+  BIND(COALESCE(?wd_geo1, ?wd_geo2) AS ?wd_geo).  # if geo1 available use that, then try geo2
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+}
+ORDER BY ?locationLabel
+</sparql>
+=== Residences of women participants in Colchester excavations ===
+<sparql tryit="1">
+#title:Excavations at Colchester: where women participants lived
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,253: / Line 2,130: @@
 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 ?person ?personLabel ?resided ?residedLabel ?wd_geo
+WHERE {
+  values (?item) { (bnwd:Q90) }   # q90 colchester
+  ?item bnwdt:P12 bnwd:Q38 .
+  ?item bnwdt:P2  ?location .  # item has property P2 location
+  ?item (bnwdt:P36 | bnwdt:P37 ) ?person .
+  #optional { ?item bnwdt:P36 ?director . }
+  #optional { ?item bnwdt:P37 ?member . }
+  optional { ?person bnwdt:P29 ?resided .
+               ?resided bnwdt:P117 ?wsa .  # and has wikidata id
+            bind(iri(concat("http://www.wikidata.org/entity/", str(?wsa))) as ?wikidataa) .
+               SERVICE <https://query.wikidata.org/sparql> {
+               ?wikidataa wdt:P625 ?wd_geo .
+             } # /wikidata service
+           }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+}
+ORDER BY ?locationLabel
+</sparql>
-select ?person ?personLabel
+=== IWD 2024 Map of five women's places ===
-(count(distinct ?exhibitor) as ?exhibitions)
-(count(distinct ?position) as ?positions)
+<sparql tryit="1">
-(count(distinct ?speaker) as ?spoke)
+## how many places for the five women can I get on a map? a slightly ridiculous query.
-(count(distinct ?attended) as ?attendance)
-(count(distinct ?donorof) as ?donated)
+#title:Four stories, five women, many places for #IWD2024
-(count(distinct ?wasdelegate) as ?delegate)
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-(count(distinct ?correspondent) as ?correspondents)
+PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-(count(distinct ?fellow) as ?fellowships)
+PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-(count(distinct ?collab) as ?collaborations)
+PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-(count(distinct ?found) as ?founded)
+PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-(count(distinct ?loaned) as ?loans)
+PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-(count(distinct ?illustrated) as ?illustrations)
+PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-(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
+#defaultView:Map{"hide":["?geo"],"layer":"?person", "markercluster":true }
-{
-  ?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===
+SELECT distinct ?person ?personLabel  ?propLabel ?placeLabel  ?geo  ?loc2Label (year(?date) as ?year)
-<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 ) .
-}
+   VALUES (?person) {(bnwd:Q894) (bnwd:Q462) (bnwd:Q549) (bnwd:Q921) (bnwd:Q1053) }  #
-ORDER BY ?personLabel
+   ?person ( bnp:P29 | bnp:P94  | bnp:P23 | bnp:P13 | bnp:P120   ) ?s .
-</sparql>
+   ?s  ( bnps:P29 | bnps:P94  | bnps:P23 | bnps:P13 | bnps:P120   )  ?place .
-===Membership of organisations by women, sorted by how many women were members of a given organisation===
+   ?person ?p ?s .
+      ?prop wikibase:claim ?p;
+         wikibase:statementProperty ?ps.
-<sparql tryit="1">
+      optional { ?s ( bnpq:P1 | bnpq:P27 ) ?date . }
-# Membership of organisations by women, sorted by how many women were members of a given organisation
+      #optional { ?s bnpq:P31 ?street . }
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+  # LOLplaces
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+  #1 geocoords in quals for place itself - should be detailed geo added manually, cf London district geocoords which =main P153
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
+  #2 wikdiata geocoords for place
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+  #3 geocoords in quals for linked place
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
+  #4 wikidata geocoords for linked place
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
+  #5 wikidata geocoords in place P2 qual
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+  #6 `of` qual geocoords
+  #7 `of` P2 wikidata geocoords
-SELECT ?organisation ?organisationLabel (count(?organisation) as ?organisation_count) #count number of organisations that women were members of
+  #8 `of` wikidata geocoords
-WHERE {
+  #9 place main geocoords - likely to be broad london postal districts so should be last resort
-   ?person bnwdt:P3 bnwd:Q3 . # select women
+   #10 linked place main geocoords
-   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 { ?s bnpq:P153 ?geo1 . } # place has geocoords directly *in qualifier*
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
+      optional { ?place bnwdt:P2 ?linked_p1 . # linked place has geocoords *in qualifier* (this is primarily for SAL?)
-GROUP BY ?organisation ?organisationLabel
+                     ?linked_p1 bnp:P2 ?llp_s .
-ORDER BY DESC(?organisation_count)
+                        ?llp_s bnps:P2 ?llp_p1.
-</sparql>
+                        ?llp_s bnpq:P153 ?geo2 .
+                }
+      optional { ?place bnwdt:P117 ?pws .  # place has wikidata page that has geoocords (main P625, not anywhere else)
-==Education==
+                   bind(iri(concat("http://www.wikidata.org/entity/", str(?pws))) as ?pwikidata) .
+                   SERVICE <https://query.wikidata.org/sparql> {
-===Women educated at a tertiary educational institution located in Oxford or Cambridge===
+                     ?pwikidata wdt:P625 ?geo3 .
+                  }
-<sparql tryit="1">
+                }
-# Women educated at a tertiary educational institution located in Oxford or Cambridge
+      optional { ?place bnwdt:P2 ?linked_p2 .  # linked place has wikidata geocoords
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+                    ?linked_p2 bnwdt:P117 ?lws .  # wikidata id P117
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+                     bind(iri(concat("http://www.wikidata.org/entity/", str(?lws))) as ?lwikidata) .
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
+                     SERVICE <https://query.wikidata.org/sparql> {
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+                      ?lwikidata wdt:P625 ?geo4 .
-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/>
+      optional { ?s bnpq:P2 ?qp1 . # P2 qualifier location has wikidata geocoords
-SELECT ?woman ?womanLabel ?educationalinstitution ?educationalinstitutionLabel ?location ?locationLabel
+                     ?qp1 bnwdt:P117 ?qws .
-WHERE {
+                     bind(iri(concat("http://www.wikidata.org/entity/", str(?qws))) as ?qwikidata) .
-   {?woman bnwdt:P3 bnwd:Q3 . #filter women
+                     SERVICE <https://query.wikidata.org/sparql> {
-  ?woman bnwdt:P94 ?educationalinstitution . #find 'educated at' statement
+                      ?qwikidata wdt:P625 ?geo5 .
-  ?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". }
+      optional { ?s bnpq:P78 ?ofp1 . # 'of' (organisation) has geocoords in P2 qualifier
-  FILTER(LANG(?locationLabel) = "en") .
+                    ?ofp1 bnp:P2 ?ofp1_s .
-  FILTER(regex(?locationLabel, "oxford", "i")) .}
+                     ?ofp1_s bnps:P2 ?ofp1_p .
-  UNION
+                     ?ofp1_s bnpq:P153 ?geo6 . }
-  {?woman bnwdt:P3 bnwd:Q3 . #filter women
-   ?woman bnwdt:P94 ?educationalinstitution . #find 'educated at' statement
+      optional { ?s bnpq:P78 ?ofp2 . # 'of' (organisation) P2 location has wikidata geocoords
-  ?educationalinstitution bnwdt:P12 bnwd:Q2914 . #filter to tertiary educational institutions
+                    ?ofp2 bnwdt:P2 ?ofp2_p .
-  ?educationalinstitution bnwdt:P2 ?location . #find location of educational institution
+                       ?ofp2_p bnwdt:P117 ?ofl2ws .
-  ?location rdfs:label ?locationLabel .
+                       bind(iri(concat("http://www.wikidata.org/entity/", str(?ofl2ws))) as ?ofl2wikidata) .
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+                       SERVICE <https://query.wikidata.org/sparql> {
-  FILTER(LANG(?locationLabel) = "en") .
+                      ?ofl2wikidata wdt:P625 ?geo7 .  }
-  FILTER(regex(?locationLabel, "Cambridge$", "i")) .}
+              }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
+      optional { ?s bnpq:P78 ?ofp3 .   # 'of' (organisation) has wikidata geocoords
-ORDER BY ?womanLabel
+                    ?ofp3 bnwdt:P117 ?ofpws .  # wikidata id P117
-</sparql>
+                     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.)
-=== Women who were FSAs who went to Oxford or Cambridge colleges ===
+      optional { ?place bnwdt:P2 ?linked_p10 . # linked place main geocoords
+                     ?linked_p10 bnwdt:P153 ?geo10 .
+                }
-<sparql tryit="1">
+  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
-#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
-   ?person bnwdt:P75 bnwd:Q8. # only BN subjects having a FSA
+   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!
-   # educated at (P94) part of (P4) cambridge (Q1181) oxford (Q364)
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
+}
-  ?person bnwdt:P94 ?college .
+order by ?personLabel ?date ?placeLabel
-  ?college bnwdt:P4 ?university .
-  FILTER ( ?university in ( bnwd:Q1181 , bnwd:Q364 ) )
-  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".}
-}
-order by ?personLabel ?collegeLabel
 </sparql>
-=== All women who went to tertiary education institutions and dates where available ===
+=== Wikidata categories for BN instance of locality in the UK ===
 <sparql tryit="1">
@@ Line 2,438: / Line 2,281: @@
 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/>
+#title: counts of WD instance of (P31) for BN localities (instance of Q2147) in the UK
-SELECT ?person ?personLabel ?college ?collegeLabel ?university ?universityLabel ?date ?date_label
+select ?wd_io ?wd_io_label  (count(*) as ?count)
-WHERE {
+where {
-   ?person bnwdt:P3 bnwd:Q3 . #select women
-   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+   ?item bnwdt:P12 bnwd:Q2147 . # BN io locality
+   ?item bnwdt:P33* bnwd:Q1741 . # in UK
-   # note: academic degree is P59. possible extra info?
+   ?item bnwdt:P117 ?wd.
-  ?person bnp:P94 ?s .  # educated at
+      bind(iri(concat("http://www.wikidata.org/entity/", str(?wd))) as ?wikidata) .
-    ?s bnps:P94 ?college .
+      SERVICE <https://query.wikidata.org/sparql> {
-    optional {?college bnwdt:P4 ?university . } # a few ?college aren't part of (P4) a ?university
+          ?wikidata wdt:P31 ?wd_io.
-   ?college bnwdt:P12 bnwd:Q2914 .   # tertiary ed inst
+              ## p31 Q48091 region of england.
+            SERVICE wikibase:label { bd:serviceParam wikibase:language "en".
-  # dates.
+                                    ?wikidata rdfs:label ?wd_label .
-    optional {
+                                    ?wd_io rdfs:label ?wd_io_label .
-    ?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".}
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
-order by ?personLabel ?collegeLabel ?date
+group by ?wd_io ?wd_io_label
+order by ?wd_io_label
 </sparql>
-=== Academic degrees ===
+=== Localities not in the UK ===
 <sparql tryit="1">
-# Fetch academic degrees for women, with date and conferring institution where available
+##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,480: / Line 2,320: @@
 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/>
+#title:localities not in the UK
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
+select  ?item ?itemLabel (group_concat(distinct ?admin_label; separator=", " ) as ?admin_path)
+where {
+  ?item bnwdt:P12 bnwd:Q2147 . # i/o locality
+  ?item bnwdt:P33* ?admin.
+    ?admin rdfs:label ?admin_label. filter(lang(?admin_label)="en") .
+  filter not exists { ?item bnwdt:P33* bnwd:Q1741.  } # filter out anything in the UK
+  filter (?item not in (bnwd:Q619, bnwd:Q2961, bnwd:Q4207, bnwd:Q86) ). # and a few things that are not specific places
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+}
+group by ?item ?itemLabel
+order by ?itemLabel
+</sparql>
-SELECT distinct ?person ?personLabel ?degree ?degreeLabel ?by ?byLabel ?date ?date_label
+==People==
-WHERE {
+===Women with their family name at birth and family name after marriage===
-  ?person bnwdt:P3 bnwd:Q3 . #select women
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-  # academic degree = P59.
-  ?person bnp:P59 ?s .
-    ?s bnps:P59 ?degree . # type of degree
-  # 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 ?date ?degreeLabel
-</sparql>
-==IDs==
+<sparql tryit="1">
+# Women with their family name at birth and family name after marriage
-===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">
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 2,523: / Line 2,351: @@
 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 ?wikidata_ID ?viaf_ID ?ads_ID ?worldcat_ID
+SELECT ?person ?personLabel ?birthname ?marriedname
 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:P140 ?birthname .} #look for birth name
-    OPTIONAL {?person bnwdt:P119 ?viaf_ID .}                 #return VIAF ID
+  OPTIONAL {?person bnwdt:P141 ?marriedname .} #look for married name
-    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,en-gb". }
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
 ORDER BY ?personLabel
 </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===
+=== Women with family name at birth, married name and count of married names===
 <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,549: / Line 2,377: @@
 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 ?wikidata_ID ?viaf_ID ?ads_ID ?worldcat_ID
+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
-  ?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
+  OPTIONAL {?person bnwdt:P140 ?birthname .} #look for birth name
-    OPTIONAL {?person bnwdt:P119 ?viaf_ID .}                 #return VIAF ID
+  OPTIONAL {?person bnwdt:P141 ?marriedname .} #look for married name
-    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,en-gb". }
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
+group by ?person ?personLabel ?birthname
 ORDER BY ?personLabel
 </sparql>
-===People with IDs on wikidata, their date of birth on wikidata, and the source(s) of that information===
+===Where women in our data are in wikidata, their spouses, fathers, and mothers according to wikidata===
 <sparql tryit="1">
@@ Line 2,578: / Line 2,407: @@
 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 ?item ?WD_spouse ?WD_father ?WD_mother
 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
+   ?person bnp:P117 ?wikidata_ID . #look for wikidata ID on person page
-   ?woman bnwdt:P117 ?Qnumber .
+   ?wikidata_ID bnpq:P14 ?wikidata_url .
+  BIND(IRI(REPLACE(?wikidata_url,"https://www.wikidata.org/wiki/","http://www.wikidata.org/entity/")) as ?item )
-  #create reference to Wikibase entity
+   SERVICE <https://query.wikidata.org/sparql> {
-  BIND(IRI(concat("http://www.wikidata.org/entity/", ?Qnumber)) as ?WDitem )
+         ?item wdt:P21 ?WD_gender. #get gender of person
-  #on Wikibase do
+         OPTIONAL {?item wdt:P22 ?WD_father . } #recall father
-   SERVICE <https://query.wikidata.org/sparql> {
+         OPTIONAL {?item wdt:P25 ?WD_mother . } #recall mother
-        #get the date of birth
+         OPTIONAL {?item wdt:P26 ?WD_spouse . } #recall spouse
-         ?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
+# with thanks to @tagishsimon for writing this one initially!
-# Credit to Maarten Zeinstra for developing this query
 </sparql>
-=== Which women in the wikibase have Wikipedia articles, according to Wikidata?===
+===Women in our data alongside counts of their public and professional activities, sorted by total===
 <sparql tryit="1">
+## 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,624: / Line 2,442: @@
 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 ?wikidata ?wikipedia
+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:P117 ?wikidata_ID . #look for wikidata ID on person page
+(count(distinct ?donorof) as ?donated)
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
+(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>
-  SERVICE <https://query.wikidata.org/sparql> {
+===Women in our data arranged as a network graph by the organisations they were members of===
-      # get English language wikipedia articles in wikidata entries, where listed
-        OPTIONAL {
+<sparql tryit="1">
-          ?wikipedia schema:about ?wikidata .
+## Women in our data arranged as a network graph by the organisations they were members of
-          ?wikipedia schema:inLanguage 'en' .
+#defaultView:Graph
-          FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/')
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-        }
+PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-      }
+SELECT  ?org ?orgLabel ?rgb ?linkTo ?linkToLabel
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+WHERE {
-}
+  ?linkTo bnwdt:P3 bnwd:Q3 .                                #select women
-ORDER BY ?personLabel
+  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===
-=== 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
+# Membership of organisations by women, sorted by how many women were members of a given organisation
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 2,663: / Line 2,529: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX wdt: <http://www.wikidata.org/prop/direct/>
-PREFIX wd:  <http://www.wikidata.org/entity/>
-SELECT ?person ?personLabel  ?wd_dod
+SELECT ?organisation ?organisationLabel (count(?organisation) as ?organisation_count) #count number of organisations that women were members of
 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:P15 ?bn_dod . } # *don't* have P15 date of death
+   FILTER NOT EXISTS {?person bnwdt:P67 bnwd:Q35 .} # filter out Royal Archaeological Institute
-   ?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
-        ?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
+GROUP BY ?organisation ?organisationLabel
+ORDER BY DESC(?organisation_count)
 </sparql>
-=== Women with no date of birth in our wikibase who have a date of birth in Wikidata===
+==Education==
+===Women educated at a tertiary educational institution located in Oxford or Cambridge===
 <sparql tryit="1">
-# Women who have no date of birth in our wikibase and have a date of birth on Wikidata
+# Women educated at a tertiary educational institution located in Oxford or Cambridge
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 2,699: / Line 2,558: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX wdt: <http://www.wikidata.org/prop/direct/>
-PREFIX wd:  <http://www.wikidata.org/entity/>
-SELECT ?person ?personLabel  ?wd_dob
+SELECT ?woman ?womanLabel ?educationalinstitution ?educationalinstitutionLabel ?location ?locationLabel
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . #select women
+   {?woman bnwdt:P3 bnwd:Q3 . #filter women
-   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+   ?woman bnwdt:P94 ?educationalinstitution . #find 'educated at' statement
+  ?educationalinstitution bnwdt:P12 bnwd:Q2914 . #filter to tertiary educational institutions
-   filter not exists {?person bnwdt:P26 ?bn_dob . } # *don't* have P15 date of death
+   ?educationalinstitution bnwdt:P2 ?location . #find location of educational institution
+   ?location rdfs:label ?locationLabel .
-   ?person bnwdt:P117 ?wikidata_ID . #look for wikidata ID on person page
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?item) .
+  FILTER(LANG(?locationLabel) = "en") .
+  FILTER(regex(?locationLabel, "oxford", "i")) .}
-   SERVICE <https://query.wikidata.org/sparql> {
+  UNION
-        ?item wdt:P21 ?WD_gender. #get gender of person
+  {?woman bnwdt:P3 bnwd:Q3 . #filter women
-        ?item wdt:P569 ?wd_dob .  #date of birth on Wikidata P569
+   ?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
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+  ?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 ?personLabel
+ORDER BY ?womanLabel
 </sparql>
-=== All external IDs on Wikidata for Women ===
+=== Women who were FSAs who went to Oxford or Cambridge colleges ===
 <sparql tryit="1">
-# Query to fetch all available External IDs on Wikidata for FSAs
+#how many women who were FSAs went to Oxford or Cambridge colleges?
-# 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,735: / Line 2,597: @@
 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 ?p ?id_no ?id_label
+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
+  ?person bnwdt:P75 bnwd:Q8. # only BN subjects having a FSA
+  # educated at (P94) part of (P4) cambridge (Q1181) oxford (Q364)
-WHERE {
+  ?person bnwdt:P94 ?college .
-    ?person bnwdt:P3 bnwd:Q3 . #select women
+  ?college bnwdt:P4 ?university .
-    #?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> {
+  FILTER ( ?university in ( bnwd:Q1181 , bnwd:Q364 ) )
-    ?wikidata ?p ?s .
+   SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".}
-       ?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 ?collegeLabel
-order by ?personLabel ?id_label ?id_no
 </sparql>
-=== What external IDs are available in Wikidata for women in the BN database? ===
+=== All women who went to tertiary education institutions and dates where available ===
 <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,779: / 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 ?p ?id_label ?id_description  (count(?p) as ?count)
+SELECT ?person ?personLabel ?college ?collegeLabel ?university ?universityLabel ?date ?date_label
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . #select women
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-  ?person bnwdt:P117 ?wikidata_ID . # wikidata ID
-     bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-     SERVICE <https://query.wikidata.org/sparql> {
+  # note: academic degree is P59. possible extra info?
-     ?wikidata ?p ?s .
+  ?person bnp:P94 ?s .  # educated at
-          ?prop wikibase:claim ?p;
+    ?s bnps:P94 ?college .
-               wikibase:propertyType wikibase:ExternalId;
+    optional {?college bnwdt:P4 ?university . } # a few ?college aren't part of (P4) a ?university
-               rdfs:label ?id_label. filter(lang(?id_label)="en") .
+   ?college bnwdt:P12 bnwd:Q2914 .   # tertiary ed inst
-       ?prop schema:description ?id_description .
-       filter(lang(?id_description) = "en") .
+  # dates.
-       }
+    optional {
+    ?s ?pq ?date .
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en, en-gb". }
+      ?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".}
 }
-group by ?p ?id_label ?id_description
+order by ?personLabel ?collegeLabel ?date
-ORDER BY desc(?count)
 </sparql>
-=== Women with ODNB IDs in Wikidata ===
+=== Academic degrees ===
 <sparql tryit="1">
-# BN women with ODNB biography IDs on Wikidata, with links to the bios
+# 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,822: / Line 2,672: @@
 PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT distinct ?person ?personLabel ?wikidata ?url
+SELECT distinct ?person ?personLabel ?degree ?degreeLabel ?by ?byLabel ?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: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> {
+  # academic degree = P59.
+  ?person bnp:P59 ?s .
-    # P1415	Oxford Dictionary of National Biography ID | P6829	Dictionary of Irish Biography ID | P1648	Dictionary of Welsh Biography ID
+     ?s bnps:P59 ?degree . # type of degree
-     ?wikidata wdt:P1415 ?id .
+  # optional qualifiers for degree
-     # odnb link
-    BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?id)) as ?url ) .
+  # P61 conferred by
+     optional { ?s bnpq:P61 ?by . }
-     }
+   # date with type
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
+    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 ?id
 </sparql>
-=== Women with National Portrait Gallery links via Wikidata ===
+==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">
-# Query to fetch National Portrait Gallery IDs on Wikidata for BN women, with links
-# 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,858: / Line 2,712: @@
 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 distinct ?person ?personLabel ?wikidata ?id_no ?npg_url
+SELECT ?person ?personLabel ?wikidata_ID ?viaf_ID ?ads_ID ?worldcat_ID
+WHERE {
-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
+     OPTIONAL {?person bnwdt:P117 ?wikidata_ID .}             #return wikidata ID
-     ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID
+     OPTIONAL {?person bnwdt:P119 ?viaf_ID .}                 #return VIAF ID
-     bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
+     OPTIONAL {?person bnwdt:P34 ?ads_ID .}                   #return Archaeological Data Service ID
+    OPTIONAL {?person bnwdt:P118 ?worldcat_ID .}             #return WorldCat Identities ID
-     SERVICE <https://query.wikidata.org/sparql> {
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-    ?wikidata ?p ?s .
-       ?prop wikibase:claim ?p;
-             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". }
 }
+ORDER BY ?personLabel
-order by ?personLabel ?id_no
 </sparql>
-=== Which BN properties map on to Wikidata properties? ===
+===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">
-## **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,902: / Line 2,738: @@
 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 ?property (if(bound(?wikidata_id), "yes", "no") as ?has_wikidata)  ?bn_label ?wd_label ?bn_description
+SELECT ?person ?personLabel ?wikidata_ID ?viaf_ID ?ads_ID ?worldcat_ID
-  ?wd_description ?wikidata ?bn_propertyType
+WHERE {
+   ?person bnwdt:P3 bnwd:Q3 .                                 #select women
-WHERE {
+  ?person bnwdt:P16 ?FSA .                                   #select FSA
-   ?property a wikibase:Property ;
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}            #filter out project team
-              wikibase:propertyType ?bn_propertyType . # datatype
+    OPTIONAL {?person bnwdt:P117 ?wikidata_ID .}             #return wikidata ID
+    OPTIONAL {?person bnwdt:P119 ?viaf_ID .}                 #return VIAF ID
-   service wikibase:label {
+     OPTIONAL {?person bnwdt:P34 ?ads_ID .}                   #return Archaeological Data Service ID
-            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
+    OPTIONAL {?person bnwdt:P118 ?worldcat_ID .}             #return WorldCat Identities ID
-            ?property rdfs:label ?bn_label .
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-            ?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
+ORDER BY ?personLabel
 </sparql>
-==== Of these, which are properties for public and professional activities? ====
+===People with IDs on wikidata, their date of birth on wikidata, and the source(s) of that information===
 <sparql tryit="1">
-# which properties have corresponding wikidata IDs, restricted to instance of PPA (P12 / Q151)
-## **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,947: / Line 2,765: @@
 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 DISTINCT ?property (if(bound(?wikidata_id), "yes", "no") as ?has_wikidata)  ?bn_label ?wd_label ?bn_description
+SELECT ?woman ?womanLabel ?WDitem ?WDdateOfBirth (GROUP_CONCAT(?BirthStatedInEnglish;separator=" | ") AS ?sources)
-  ?wd_description ?wikidata ?bn_propertyType
+WHERE {
+   #Select all women
-WHERE {
+  ?woman bnwdt:P3 bnwd:Q3 .
-   ?property a wikibase:Property ;
+  #select all women that have a Wikidata link
-              wikibase:propertyType ?bn_propertyType . # datatype
+  ?woman bnwdt:P117 ?Qnumber .
-   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
-    ?property bnwdt:P12 bnwd:Q151. # instance of PPA
+  #create reference to Wikibase entity
-}
+  BIND(IRI(concat("http://www.wikidata.org/entity/", ?Qnumber)) as ?WDitem )
-order by ?bn_label
+  #on Wikibase do
-</sparql>
+  SERVICE <https://query.wikidata.org/sparql> {
+        #get the date of birth
+        ?WDitem wdt:P569 ?WDdateOfBirth .
+        #get the statement of birth
+        ?WDitem p:P569 ?Birthstatement .
+        #get its node
+        ?Birthstatement prov:wasDerivedFrom ?BirthRefnode.
+        #get the value of 'Stated in'
+        ?BirthRefnode   pr:P248 ?BirthStatedIn.
+        #get the english label of the referece 'stated in'
+        OPTIONAL {?BirthStatedIn rdfs:label ?BirthStatedInEnglish
+                  FILTER (LANG(?BirthStatedInEnglish) = "en")}.
+      }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+GROUP BY ?woman ?womanLabel ?WDitem ?WDdateOfBirth
+ORDER BY ?womanLabel
+# Credit to Maarten Zeinstra for developing this query
+</sparql>
-=== Archaeological sites/Historic houses and their owners/operators in Wikidata ===
+=== Which women in the wikibase have Wikipedia articles, according to Wikidata?===
 <sparql tryit="1">
-#title:archaeological sites/historic houses in wikidata
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 2,991: / Line 2,813: @@
 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 ?wikidata ?wikipedia
+WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . #select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?person bnwdt:P117 ?wikidata_ID . #look for wikidata ID on person page
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-SELECT distinct ?item ?itemLabel ?instanceLabel ?wikidata ?wd_owner_label ?wd_operator_label ?wd_member_label  #?wd_owner ?wd_operator
-WHERE {
+   SERVICE <https://query.wikidata.org/sparql> {
+       # get English language wikipedia articles in wikidata entries, where listed
-  { ?item bnwdt:P12 bnwd:Q86 . } # instance of archaeological site
+        OPTIONAL {
-  union
+          ?wikipedia schema:about ?wikidata .
-  { ?item bnwdt:P12 bnwd:Q2961 . } # instance of historic house
+          ?wikipedia schema:inLanguage 'en' .
+          FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/')
-   ?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)
+      }
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-    ?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
+ORDER BY ?personLabel
 </sparql>
-==== And which are owned/operated by English Heritage/National Trust or belong to Historic Houses Association ====
+=== 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
-# archaeological site or historic house.
-# pull together via Wikidata which ones are owned/operated by 1) English Heritage 2) National Trust  or 3) affiliated to Historic Houses association
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 3,046: / Line 2,852: @@
 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 ?item ?itemLabel ?instanceLabel ?wikidata ?wd_owner_label ?wd_operator_label ?wd_member_label  #?wd_owner ?wd_operator
+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) .
-WHERE {
-   { ?item bnwdt:P12 bnwd:Q86 . }
+   SERVICE <https://query.wikidata.org/sparql> {
-  union
+        ?item wdt:P21 ?WD_gender. #get gender of person
-  { ?item bnwdt:P12 bnwd:Q2961 . }
+        ?item wdt:P570 ?wd_dod .  #date of death on Wikidata P570
+      }
-   ?item bnwdt:P12 ?instance .
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-   filter ( ?instance in (bnwd:Q86, bnwd:Q2961) ) .
+}
+ORDER BY ?personLabel
-   ?item bnwdt:P117 ?wikidata_id .
+</sparql>
-     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 .}
+=== Women with no date of birth in our wikibase who have a date of birth in Wikidata===
-      optional { ?wikidata wdt:P137 ?wd_operator . }
-      optional { ?wikidata wdt:P463 ?wd_member . }
-      # filter: owner or operator = EH/NT / member of HHA
+<sparql tryit="1">
-        filter ( ?wd_owner in (wd:Q936287, wd:Q333515) ||
+# Women who have no date of birth in our wikibase and have a date of birth on Wikidata
-                 ?wd_operator in (wd:Q936287, wd:Q333515) ||
-                 ?wd_member = wd:Q5773523 ) .
-       ## owned by P127 / operator P137
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-       ## ENglish Heritage Q936287  National Trust (Q333515)
+PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-       ## member of P463   Historic Houses Association (Q5773523)
+PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-       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>
-== Men ==
-=== BN Men in Wikidata ===
-<sparql tryit="1">
-#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/>
-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 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 distinct ?person ?personLabel ?wikidata ?whos_who ?odnb_url ?wikipedia ?wd_dob ?wd_dod ?wd_stmts
+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) .
+  SERVICE <https://query.wikidata.org/sparql> {
+        ?item wdt:P21 ?WD_gender. #get gender of person
+        ?item wdt:P569 ?wd_dob .  #date of birth on Wikidata P569
+      }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+ORDER BY ?personLabel
+</sparql>
+=== All external IDs on Wikidata for Women ===
+<sparql tryit="1">
+# 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/>
+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 ?wikidata ?p ?id_no ?id_label
 WHERE {
-     ?person bnwdt:P3 bnwd:Q10 . #select men
+     ?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> {
-      ?wikidata   wikibase:statements ?wd_stmts .
+    ?wikidata ?p ?s .
+        ?prop wikibase:claim ?p;
-        optional {
+             wikibase:statementProperty ?ps; # NB rather than statementValue
-         # P1415	Oxford Dictionary of National Biography ID | couls also add  P6829	Dictionary of Irish Biography ID | P1648	Dictionary of Welsh Biography ID
+             wikibase:propertyType wikibase:ExternalId. # quicker than filter.
-        ?wikidata wdt:P1415 ?odnb_id .
+       ?prop rdfs:label ?id_label. filter(lang(?id_label)="en") . # ident name
-        # odnb link
-        BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?odnb_id)) as ?odnb_url ) .
-        } #/ odnb
-        # English language wikipedia articles in wikidata entries, where listed
+           ?s ?ps ?id_no . # id value
-        OPTIONAL {
-           ?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
+       # filter by property type
-        optional { ?wikidata wdt:P570 ?wd_dod . }  #date of death on Wikidata P570
+       #filter(?prop_type in (wikibase:ExternalId ) ) .
+      }
-      }  #/ wikidata
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
 }
-order by ?personLabel
+order by ?personLabel ?id_label ?id_no
 </sparql>
-=== What sort of info Wikidata has about BN men ===
+=== 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
-#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/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,173: / 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 ?prop_label ?prop (count(?prop) as ?count)
+SELECT ?p ?id_label ?id_description  (count(?p) as ?count)
 WHERE {
-    ?person bnwdt:P3 bnwd:Q10 . #select men 211.
+  ?person bnwdt:P3 bnwd:Q3 . #select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-    ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID
+  ?person bnwdt:P117 ?wikidata_ID . # wikidata ID
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
+     bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-    SERVICE <https://query.wikidata.org/sparql> {
+     SERVICE <https://query.wikidata.org/sparql> {
-        ?wikidata ?p ?s .
+      ?wikidata ?p ?s .
-            ?prop wikibase:claim ?p;
+          ?prop wikibase:claim ?p;
-                 wikibase:propertyType ?prop_type ;
+               wikibase:propertyType wikibase:ExternalId;
-                 wikibase:statementProperty ?ps.
+               rdfs:label ?id_label. filter(lang(?id_label)="en") .
-            ?prop rdfs:label ?prop_label. filter(lang(?prop_label)="en") .
+       ?prop schema:description ?id_description .
-        filter(?prop_type in (wikibase:Time, wikibase:WikibaseItem ) ) .
+       filter(lang(?id_description) = "en") .
-      # also a few quantity, string, monolingualtext
+       }
-     }  #/ wikidata
-   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 ?prop_label  ?prop
+group by ?p ?id_label ?id_description
-order by ?prop_label
+ORDER BY desc(?count)
 </sparql>
-=== BN Men in Wikidata: men who proposed elections to SAL/RAI ===
+=== Women with ODNB IDs in Wikidata ===
 <sparql tryit="1">
-#title:Men who proposed for SAL/RAI elections who are in Wikidata
+# BN women with ODNB biography IDs on Wikidata, with links to the bios
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 3,214: / 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 ?person ?personLabel ?wikidata ?url
-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:Q3 . #select women
-   ?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> {
-       optional {
+    # P1415	Oxford Dictionary of National Biography ID | P6829	Dictionary of Irish Biography ID | P1648	Dictionary of Welsh Biography ID
-         # P1415	Oxford Dictionary of National Biography ID
+    ?wikidata wdt:P1415 ?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 link
-         } #/ odnb
+    BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?id)) as ?url ) .
-         # could 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/')
-        }
-        # 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
-      }  #/ wikidata service
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
 }
-ORDER BY  ?proposerLabel
+order by ?personLabel ?id
 </sparql>
-==== Male proposers who have occupations data in Wikidata====
+=== Women with National Portrait Gallery links via Wikidata ===
 <sparql tryit="1">
-#title:Men who proposed for SAL/RAI elections who have occupation(s) in wikidata
+# Query to fetch National Portrait Gallery IDs on Wikidata for BN women, with links
-# with occupation labels, which was slightly trickier than expected
+# 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 3,265: / 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 ?person ?personLabel ?wikidata ?id_no ?npg_url
-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:Q3 . #select women
-  ?s (bnps:P16 | bnps:P7) ?proposer .
-    ?proposer bnwdt:P3 bnwd:Q10 .
-     ?proposer bnwdt:P117 ?wikidata_ID . #get wikidata ID
+     ?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> {
-         ?wikidata wdt:P106 ?wd_occupation .
-        # automatic *Label doesn't work with a federated query; this works instead.
+    ?wikidata ?p ?s .
-         SERVICE wikibase:label {
+       ?prop wikibase:claim ?p;
-              bd:serviceParam wikibase:language "en".
+             wikibase:statementProperty ?ps;
-              ?wd_occupation rdfs:label ?wd_label.
+             wikibase:propertyType wikibase:ExternalId.
-              }
-      }  #/ wikidata service
+          ?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". }
 }
-group by ?personLabel ?proposerLabel ?wikidata ?person ?proposer
-ORDER BY  ?proposerLabel ?person
+order by ?personLabel ?id_no
 </sparql>
-=== BN Men in Wikidata: Spouses ===
+=== Which BN properties map on to Wikidata properties? ===
 <sparql tryit="1">
-#title: BN spouses who are 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.
+## 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 3,306: / Line 3,092: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?spouse ?spouseLabel  ?wikidata ?odnb_url ?wikipedia ?wd_dob ?wd_dod
+SELECT DISTINCT ?property (if(bound(?wikidata_id), "yes", "no") as ?has_wikidata)  ?bn_label ?wd_label ?bn_description
+  ?wd_description ?wikidata ?bn_propertyType
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3.
+   ?property a wikibase:Property ;
-  ?person bnwdt:P41 ?spouse .
+              wikibase:propertyType ?bn_propertyType . # datatype
-    ?spouse 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 .
+                             }
-       optional {
+     # wikidata P117
-         # P1415	Oxford Dictionary of National Biography ID
+     optional {
+            ?property bnwdt:P117 ?wikidata_id .
-         ?wikidata wdt:P1415 ?odnb_id .
+                bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
-         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". }
+             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  ?proposerLabel
+order by ?bn_label
 </sparql>
+==== Of these, which are properties for public and professional activities? ====
-=== BN Men who proposed, seconded or signed for Women in SAL/RAI/RHS elections, with counts and wikidata IDs ===
+<sparql tryit="1">
+# which properties have corresponding wikidata IDs, restricted to instance of PPA (P12 / Q151)
-<sparql tryit="1">
+## **NOTES**
-#title:Men who supported women (at least twice) for SAL/RAI/RHS election with Wikidata IDs
+## 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 3,357: / Line 3,137: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-# p155, p156 - signed rhs
+SELECT DISTINCT ?property (if(bound(?wikidata_id), "yes", "no") as ?has_wikidata)  ?bn_label ?wd_label ?bn_description
-# p32, p82  - signed sal|
+  ?wd_description ?wikidata ?bn_propertyType
-# p8 rai seconded
-SELECT  ?supporterLabel ?supporter  ?wikidata (count(?supporter) as ?supported)
 WHERE {
+   ?property a wikibase:Property ;
-   ?person bnwdt:P3 bnwd:Q3 .
+              wikibase:propertyType ?bn_propertyType . # datatype
-  {
+   service wikibase:label {
-    ?person (  bnp:P155 | bnp:P156 | bnp:P16 | bnp:P7 ) ?s .  #
+            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
-      ?s ( bnps:P155 | bnps:P156 | bnps:P16 | bnps:P7 ) ?supporter  . # proposed SAL/RAI / signed RHS
+            ?property rdfs:label ?bn_label .
-      #?s ?prop ?supporter .
+            ?property schema:description ?bn_description .
-    }
+                             }
-  #  union for qualifiers
+    # wikidata P117
-  union
+    optional { ?property bnwdt:P117 ?wikidata_id .
-  {
+                 bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
-  ?person ?p ?s .
-     ?s (  bnpq:P156 | bnpq:P155 | bnpq:P32 | bnpq:P82 | bnpq:P8 ) ?supporter .
+             SERVICE <https://query.wikidata.org/sparql> {
-     #?s ?prop ?supporter .
+                    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
-     ?supporter bnwdt:P3 bnwd:Q10 .  # male
+     ?property bnwdt:P12 bnwd:Q151. # instance of PPA
-    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 ?bn_label
-having (?supported>2)
-ORDER BY desc(?supported) desc(?wikidata)
 </sparql>
-==Fishing Expeditions==
-===All properties in use in the wikibase with property type, label and description (if present)===
+=== Archaeological sites/Historic houses and their owners/operators in Wikidata ===
 <sparql tryit="1">
-# query for information about properties that are being used in the wikibase
+#title:archaeological sites/historic houses 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
+SELECT distinct ?item ?itemLabel ?instanceLabel ?wikidata ?wd_owner_label ?wd_operator_label ?wd_member_label  #?wd_owner ?wd_operator
-  ?property
-  ?propertyType
-  ?propertyLabel
-  (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-gb')
+   { ?item bnwdt:P12 bnwd:Q86 . } # instance of archaeological site
-   # fix label language dups; but Q why doesn't SERVICE work?
+  union
-  # A: https://en.wikibooks.org/wiki/SPARQL/FILTER#FILTER_on_values_in_Labels
+  { ?item bnwdt:P12 bnwd:Q2961 . } # instance of historic house
-   # nb a few objects found with en-gb label missing
+   ?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". }
 }
-group by ?property ?propertyLabel ?propertyType ?propertyDescription
+order by ?itemLabel
-order by ?propertyLabel
 </sparql>
+==== And which are owned/operated by English Heritage/National Trust or belong to Historic Houses Association ====
-=== All the Things for Organisations ===
+<sparql tryit="1">
-<sparql tryit="1">
+# archaeological site or historic house.
+# pull together via Wikidata which ones are owned/operated by 1) English Heritage 2) National Trust  or 3) affiliated to Historic Houses association
-# 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,457: / Line 3,236: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-select distinct ?item ?itemLabel
+SELECT distinct ?item ?itemLabel ?instanceLabel ?wikidata ?wd_owner_label ?wd_operator_label ?wd_member_label  #?wd_owner ?wd_operator
-?prop ?propLabel ?prop_type
-?stmt_value ?stmt_valueLabel
+WHERE {
-?qual_prop  ?qual_value ?qual_label ?qual_prop_type
-?statement
+  { ?item bnwdt:P12 bnwd:Q86 . }
+  union
+  { ?item bnwdt:P12 bnwd:Q2961 . }
+   ?item bnwdt:P12 ?instance .
+   filter ( ?instance in (bnwd:Q86, bnwd:Q2961) ) .
+   ?item bnwdt:P117 ?wikidata_id .
+     bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) .
+     SERVICE <https://query.wikidata.org/sparql> {
-where {
+      optional { ?wikidata wdt:P127 ?wd_owner .}
+      optional { ?wikidata wdt:P137 ?wd_operator . }
+      optional { ?wikidata wdt:P463 ?wd_member . }
-?item bnwdt:P12+ bnwd:Q2316  . # instance of organisation or descendants of (excluding instance of organisation itself)
+      # filter: owner or operator = EH/NT / member of HHA
+        filter ( ?wd_owner in (wd:Q936287, wd:Q333515) ||
+                 ?wd_operator in (wd:Q936287, wd:Q333515) ||
+                 ?wd_member = wd:Q5773523 ) .
-  # get all the things about ?item
+       ## owned by P127 / operator P137
-    ?item ?p ?statement .
+       ## ENglish Heritage Q936287  National Trust (Q333515)
+       ## member of P463   Historic Houses Association (Q5773523)
-   # 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") .
+       SERVICE wikibase:label {
+              bd:serviceParam wikibase:language "en".
+              ?wd_owner rdfs:label ?wd_owner_label.
-  # get stuff about ?p
+              ?wd_operator rdfs:label ?wd_operator_label.
-    ?prop wikibase:claim ?p;
+              ?wd_member rdfs:label ?wd_member_label.
-            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.
+   #} # /optional for wikidata ID
-   # 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". }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
-order by ?item_label ?prop_label
+order by ?itemLabel
 </sparql>
-===Working with property paths: organisations and locations===
+== Men ==
+=== BN Men in Wikidata ===
 <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.
-## how to determine the "distance" along the path of each result?
+#title: BN men in Wikidata
-## https://stackoverflow.com/questions/61984052/wikidata-get-the-full-subhierachy-of-one-class-as-well-as-all-nodes
+# a starting point to get the basic query set up; can easily add more variables...
-## > 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,517: / 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  ?item ?itemLabel ?location ?locationLabel (count(?item) as ?distance)
+SELECT distinct ?person ?personLabel ?wikidata ?whos_who ?odnb_url ?wikipedia ?wd_dob ?wd_dod ?wd_stmts
-WHERE {
-  ?item bnwdt:P12 bnwd:Q2316 .  # instance of organisation.
-  ?item bnwdt:P2* ?tmp .
-  ?tmp bnwdt:P2+ ?location . # P2=30. P2+=34
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". }
+WHERE {
-}
+    ?person bnwdt:P3 bnwd:Q10 . #select men
-group by ?item ?itemLabel  ?location ?locationLabel
-ORDER BY ?item ?distance
+    ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID
-</sparql>
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
+    SERVICE <https://query.wikidata.org/sparql> {
-=== Working with property paths: instance of [CAVEAT: experimental, probably wrong]===
+      ?wikidata   wikibase:statements ?wd_stmts .
-<sparql tryit="1">
+       optional {
-# an attempt to adapt the query above following paths for locations of organisations for (more complex) instance of
+         # P1415	Oxford Dictionary of National Biography ID | couls also add  P6829	Dictionary of Irish Biography ID | P1648	Dictionary of Welsh Biography ID
-# ref https://stackoverflow.com/questions/61984052/wikidata-get-the-full-subhierachy-of-one-class-as-well-as-all-nodes
+        ?wikidata wdt:P1415 ?odnb_id .
-# 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/>
+        # odnb link
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+        BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?odnb_id)) as ?odnb_url ) .
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
+        } #/ odnb
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
+        # English language wikipedia articles in wikidata entries, where listed
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
+        OPTIONAL {
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+          ?wikipedia schema:about ?wikidata .
+          ?wikipedia schema:inLanguage 'en' .
-SELECT ?item ?itemLabel ?instance_of ?instance_ofLabel  (count(?item) as ?distance)
+          FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/')
-WHERE {
+        }
-  ?item bnwdt:P12* ?tmp .  # instance of anything.
-  ?tmp bnwdt:P12+ ?instance_of . # P2=30. P2+=34
+       optional { ?wikidata wdt:P4789 ?whos .
+                  bind(iri(concat("https://www.ukwhoswho.com/view/article/oupww/whoswho/", ?whos)) as ?whos_who) .
+                 } # P4789 Who's Who
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". }
+        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". }
 }
-group by ?item ?itemLabel  ?instance_of ?instance_ofLabel
-ORDER BY ?item ?distance
+order by ?personLabel
 </sparql>
-==Dates==
+=== What sort of info Wikidata has about BN men ===
-===All the Dates for Women FSAs===
+<sparql tryit="1">
-<sparql tryit="1">
+#title: what info is there for BN men in Wikidata
-#title:fishing for dates for FSAs
+#counts of properties (excluding external IDs, of which there are gazillions) (Counts are overall and some people might have more than one.)
-# union query to get [hopefully] every date associated with women FSAs including main dates and qualifier dates
+#at time of writing there are 198 linked men.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 3,575: / Line 3,365: @@
 PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT distinct ?person ?personLabel ?prop_label ?qualLabel ?qual_dateLabel ?date_value  ?s
+SELECT ?prop_label ?prop (count(?prop) as ?count)
-#?prop ?qual
 WHERE {
+    ?person bnwdt:P3 bnwd:Q10 . #select men 211.
+    ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-   ?person bnwdt:P3 bnwd:Q3 . #select women
+    SERVICE <https://query.wikidata.org/sparql> {
-   ?person bnwdt:P75 bnwd:Q8. # find only BN subjects having a FSA
+        ?wikidata ?p ?s .
+            ?prop wikibase:claim ?p;
-   # get stuff about ?person
+                 wikibase:propertyType ?prop_type ;
-   ?person ?p ?s .
+                 wikibase:statementProperty ?ps.
+            ?prop rdfs:label ?prop_label. filter(lang(?prop_label)="en") .
-      # get stuff about ?p .
+        filter(?prop_type in (wikibase:Time, wikibase:WikibaseItem ) ) .
-      ?prop wikibase:claim ?p;
+      # also a few quantity, string, monolingualtext
-         wikibase:statementProperty ?ps ;
-         wikibase:statementValue ?psv .
+     }  #/ wikidata
-      ?prop wikibase:propertyType ?date_prop_type .
-      ?prop rdfs:label ?prop_label. filter(lang(?prop_label)="en-gb") .
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
+}
+group by ?prop_label  ?prop
+order by ?prop_label
+</sparql>
+=== BN Men in Wikidata: men who proposed elections to SAL/RAI ===
+<sparql tryit="1">
+#title:Men who proposed for SAL/RAI elections who are in Wikidata
- {  # main dates
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-  # get dates detail via ?s and psv
-  # gets edtf dates in simplified std wiki date format?
-  # https://github.com/ProfessionalWiki/WikibaseEdtf
-      ?s ?psv ?wdv .
-        ?wdv wikibase:timeValue ?date_value .
-  } # /main dates
-  UNION
-  { # 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
- SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-} # /where
-ORDER BY ?person ?prop_label ?date_value
-</sparql>
-===Fetch any of multiple kinds of EDTF date for a woman===
-<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
-# 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/>
 PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
@@ Line 3,642: / Line 3,404: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT  ?person ?personLabel ?date_edtf ?date_prop ?date_label ?s
+SELECT distinct ?proposerLabel ?proposer ?wikidata ?odnb_url ?wikipedia ?wd_dob ?wd_dod
+WHERE {
-WHERE { ?person bnwdt:P3 bnwd:Q3 .
+  ?person (bnp:P16 | bnp:P7) ?s . # proposed to either SAL or RAI
-        FILTER NOT EXISTS { ?person bnwdt:P4 bnwd:Q12 . }
+  ?s (bnps:P16 | bnps:P7) ?proposer .
+    ?proposer bnwdt:P3 bnwd:Q10 .
-       ## can do this union first but makes no difference to results except possibly a bit slower.
-       #?person ( bnp:P131 | bnp:P132 | bnp:P133  ) ?s .
+    ?proposer bnwdt:P117 ?wikidata_ID . #get wikidata ID
-        #   ?s ( bnps:P131 | bnps:P132 | bnps:P133  ) ?date_edtf .
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
+    SERVICE <https://query.wikidata.org/sparql> {
+        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
+         # could 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/')
+        }
+        # 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
+     }  #/ wikidata service
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
+}
+ORDER BY  ?proposerLabel
+</sparql>
-       ?person ?p ?s . # so you can get the statement id and date prop label
+==== Male proposers who have occupations data in Wikidata====
-           ?claim wikibase:claim ?p;
-                 rdfs:label ?date_label. filter(lang(?date_label)="en") .
-           ?s ?date_prop ?date_edtf .
+<sparql tryit="1">
+#title:Men who proposed for SAL/RAI elections who have occupation(s) in wikidata
-    ## filter for edtf dates
+# with occupation labels, which was slightly trickier than expected
-    ## docs: https://github.com/ProfessionalWiki/WikibaseEdtf
-    FILTER ( datatype(?date_edtf) = xsd:edtf  ) .
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-    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/>
@@ Line 3,688: / Line 3,454: @@
 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 distinct ?personLabel ?proposerLabel
+(group_concat(distinct ?wd_label; SEPARATOR="; ") as ?proposer_occupations)
+?wikidata ?person ?proposer
 WHERE {
-   ?item bnp:P26  ?statement. # date of birth (precision of these varies quite a bit)
+   ?person (bnp:P16 | bnp:P7) ?s . # proposed to either SAL or RAI
-  ?statement bnpsv:P26 ?valueNode.
+  ?s (bnps:P16 | bnps:P7) ?proposer .
-   ?valueNode wikibase:timeValue ?date.
+    ?proposer bnwdt:P3 bnwd:Q10 .
-  ?valueNode wikibase:timePrecision ?precision.
+    ?proposer 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 "en". }
+    SERVICE <https://query.wikidata.org/sparql> {
-}
+         ?wikidata wdt:P106 ?wd_occupation .
-ORDER BY ?date
+        # automatic *Label doesn't work with a federated query; this works instead.
+         SERVICE wikibase:label {
-</sparql>
+              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 ?personLabel ?proposerLabel ?wikidata ?person ?proposer
+ORDER BY  ?proposerLabel ?person
+</sparql>
-=== Any main level date for women ===
+=== BN Men in Wikidata: Spouses ===
 <sparql tryit="1">
-# a query to get all types of main date for women
+#title: BN spouses who are in Wikidata
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 3,715: / Line 3,494: @@
 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 distinct ?spouse ?spouseLabel  ?wikidata ?odnb_url ?wikipedia ?wd_dob ?wd_dod
 WHERE {
+   ?person bnwdt:P3 bnwd:Q3.
-   ?person bnwdt:P3 bnwd:Q3 . # women
+   ?person bnwdt:P41 ?spouse .
-   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
+    ?spouse bnwdt:P117 ?wikidata_ID . #get wikidata ID
-         BIND (REPLACE(STR(?date_prop), "^.*/([^/]*)$", "$1") as ?pid).
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-         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
+    SERVICE <https://query.wikidata.org/sparql> {
-   # filter(?date_prop_type in (wikibase:Edtf, wikibase:Time ) ) .
+       optional {
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
+         # 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". }
 }
-ORDER BY ?personLabel ?date
+ORDER BY  ?proposerLabel
+</sparql>
-</sparql>
-=== Counting Dates===
+=== BN Men who proposed, seconded or signed for Women in SAL/RAI/RHS elections, with counts and wikidata IDs ===
 <sparql tryit="1">
-# count distinct dates for women (who have at least one)
+#title:Men who supported women (at least twice) for SAL/RAI/RHS election with Wikidata IDs
-# 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,761: / Line 3,545: @@
 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 (COUNT(DISTINCT ?date_value) as ?count)
+# p155, p156 - signed rhs
+# p32, p82  - signed sal|
+# p8 rai seconded
+SELECT  ?supporterLabel ?supporter  ?wikidata (count(?supporter) as ?supported)
 WHERE {
- {  # main dates
+  ?person bnwdt:P3 bnwd:Q3 .
-   ?person bnwdt:P3 bnwd:Q3 . # women
-   ?person ?p ?s .
-      ?s ?date_prop ?wdv .
-        ?wdv wikibase:timeValue ?date_value .
-   } # /main dates
-   UNION
+   {
+    ?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 .
+    }
+  #  union for qualifiers
+  union
+  {
+  ?person ?p ?s .
+     ?s (  bnpq:P156 | bnpq:P155 | bnpq:P32 | bnpq:P82 | bnpq:P8 ) ?supporter .
+     #?s ?prop ?supporter .
+  }
-  { # qualifier dates
+     ?supporter bnwdt:P3 bnwd:Q10 .  # male
-     ?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". }
+    optional {
+      ?supporter bnwdt:P117 ?wikidata_ID . #get wikidata ID
-} # /where
+      bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) .
-GROUP BY ?person ?personLabel
+      }
-# HAVING(?count=1)
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
+}
+group by ?supporterLabel ?supporter ?wikidata
+having (?supported>2)
+ORDER BY desc(?supported) desc(?wikidata)
+</sparql>
-ORDER BY ?count ?person
+==Fishing Expeditions==
-</sparql>
-=== Start dates that might not have accompanying end dates ===
+===All properties in use in the wikibase with property type, label and description (if present)===
 <sparql tryit="1">
-#title:Women with start dates that might not have accompanying end dates
+# query for information about properties that are being used in the wikibase
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+## fyi: not actually necessary to declare these properties
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
+PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
+PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
+PREFIX wikibase: <http://wikiba.se/ontology#>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+PREFIX schema: <http://schema.org/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
+PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
-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 DISTINCT
-#(group_concat(?other_date_label; SEPARATOR=" | ") as ?other_dates)
+  ?property
+  ?propertyType
+  ?propertyLabel
+  (group_concat(?propertyAltLabel; separator=" | ") as ?propertyAltLabels)
+  ?propertyDescription
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 .
+   ?property a wikibase:Property ;
+              rdfs:label ?propertyLabel ; # label
-  # need to find start times anywhere and get prop label so use claim.
+              wikibase:propertyType ?propertyType . # datatype
-  ?person ?p ?s .
-  ?claim wikibase:claim ?p;
+  # add alternative labels if present (can be multiple)
-         rdfs:label ?prop_label. filter(lang(?prop_label)="en") .
+   OPTIONAL { ?property skos:altLabel ?propertyAltLabel . }
-# 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
- #   optional {
+  # add description if present
- #       ?s ?pq ?other_date . # could there be any other associated dates?
+   OPTIONAL {
+        SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
- #       ?qual_prop wikibase:qualifier ?pq;
+          ?property schema:description ?propertyDescription .
- #             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(LANG(?propertyLabel) = 'en')
- #       filter not exists { ?s (bnpq:P27 | bnpq:P28) ?other_date .  }
+  # 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 other dates
+}
-   # filter(!bound(?end_date)). # to filter out rows with an end date
+group by ?property ?propertyLabel ?propertyType ?propertyDescription
+order by ?propertyLabel
- SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
-}
-ORDER BY ?personLabel ?prop_label ?start_date
 </sparql>
+=== All the Things for Organisations ===
-=== End dates that might not accompanying start dates ===
+<sparql tryit="1">
-<sparql tryit="1">
+# Exploratory query to get all info on an item page including qualifiers (but not references) for each organisation (Q2316) in the wikibase
-#title:Women with end dates that might not have accompanying start dates
+# 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,863: / Line 3,643: @@
 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 ?end_date
+select distinct ?item ?itemLabel
-(if(bound(?start_date), "yes", "no") as ?has_start_date)
+?prop ?propLabel ?prop_type
-(group_concat(?other_date_label; SEPARATOR=" | ") as ?other_dates)
+?stmt_value ?stmt_valueLabel
-?person ?s
+?qual_prop  ?qual_value ?qual_label ?qual_prop_type
+?statement
+where {
+?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 .
-  ?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
+   # 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") .
-     optional {?s bnpq:P27 ?start_date .} # check for start dates
+  # 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.
-    optional {
+   # get stuff about ?statement
-        ?s ?pq ?other_date . # could there be any other associated dates?
+     ?statement ?ps ?stmt_value.
-        ?qual_prop wikibase:qualifier ?pq;
-              wikibase:propertyType wikibase:Time ; # nb *does not* include edtf dates but AFAICT there are none in qualifiers.
+  # get any qualifiers
-              rdfs:label ?other_date_label . filter(lang(?other_date_label)="en-gb") . # what kind of date
+   optional {
-        # drop both start and end. idk if there could be a faster way to do this?
+     ?statement ?qual_p ?qual_value .
-        filter not exists { ?s (bnpq:P27 | bnpq:P28) ?other_date .  }
+     ?qual_prop wikibase:qualifier ?qual_p;
+           wikibase:propertyType ?qual_prop_type ;
+           rdfs:label ?qual_label. filter(lang(?qual_label)='en-gb') .
+    }
-   } # / optional other dates
+ #  OPTIONAL { ?item skos:altLabel ?alt_label . }
- #  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". }
- 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 ?item_label ?prop_label
-ORDER BY ?personLabel ?prop_label ?end_date
 </sparql>
-==Admin==
-===Women about whom we have recorded fewer than 3 pieces of information===
+=== One woman ===
 <sparql tryit="1">
+#title:All About a Woman
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,919: / Line 3,701: @@
 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 ?propLabel ?spsLabel ?qual_propLabel ?pqsLabel ?link ?s
+# ?main_date ?main_precision ?qual_date ?qual_precision
+# ?prop ?sps ?pqs ?pq
-SELECT ?person ?personLabel ?statements WHERE {
+WHERE
-    ?person bnwdt:P3 bnwd:Q3 ;
+{
-         wikibase:statements ?statements .
+    VALUES (?person) {(bnwd:Q569)}  # add (bnwd:Qxxx) if you want more than one person.
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}
+   ?person ?p ?s .
-  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'===
+     ?prop wikibase:claim ?p;
+         wikibase:statementProperty ?ps;  #  simple value
+         wikibase:statementValue ?psv. #  full value
+   # exclude external IDs
+   # filter not exists { ?prop wikibase:propertyType wikibase:ExternalId . }
+      ?s ?ps ?sps.
+    # full date via ?psv
+      OPTIONAL {
+           ?s ?psv ?spsv .
+               ?spsv wikibase:timeValue ?main_date .
+               ?spsv wikibase:timePrecision ?main_precision .
+       }
-<sparql tryit="1">
+    # qualifiers.
-SELECT ?id ?name
-WHERE {
+      optional {
-  ?id rdfs:label ?name .
+         ?s ?pq ?pqs .
-   FILTER regex(?name, "mrs *", "i") #this line uses regular expression syntax, described at https://regexper.com/#mrs%5Cs*
+           ?qual_prop wikibase:qualifier ?pq .
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+           ?qual_prop wikibase:qualifierValue ?pqp .
+          optional {
+            # full date via ?pqp
+            ?s ?pqp ?qv .
+            ?qv wikibase:timeValue ?qual_date.
+            ?qv wikibase:timePrecision ?qual_precision.
+          }
+     }
+   # 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". }
 }
-</sparql>
+order by ?propLabel ?s
-===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===
+===Working with property paths: organisations and locations===
 <sparql tryit="1">
-#defaultView:Graph
+## 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.
-SELECT ?a ?aLabel ?c ?cLabel WHERE {
+## how to determine the "distance" along the path of each result?
-    ?a ?b ?c
+## https://stackoverflow.com/questions/61984052/wikidata-get-the-full-subhierachy-of-one-class-as-well-as-all-nodes
-    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+## > 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
-}
-#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">
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,973: / Line 3,770: @@
 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
+SELECT  ?item ?itemLabel ?location ?locationLabel (count(?item) as ?distance)
 WHERE {
-   ?person bnwdt:P3 ?gender .
+   ?item bnwdt:P12 bnwd:Q2316 .  # instance of organisation.
-   FILTER NOT EXISTS {?person bnwdt:P3 bnwd:Q3 .}          #filter out people identified as women
+   ?item bnwdt:P2* ?tmp .
-   FILTER NOT EXISTS {?person bnwdt:P3 bnwd:Q10 .}          #filter out people identified as men
+   ?tmp bnwdt:P2+ ?location . # P2=30. P2+=34
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". }
 }
-ORDER BY ?personLabel
+group by ?item ?itemLabel  ?location ?locationLabel
+ORDER BY ?item ?distance
 </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===
+=== Traversing instance of with GAS ===
 <sparql tryit="1">
-# people who have a spouse statement and - optionally - marriage date statements for checking if there is any misalignment with 'Spouse not in wikibase' statements
+#title:GAS
+# The Gather, Apply, and Scatter (GAS) service provides graph traversal, graph mining, and similar classes of algorithms for SPARQL.
+# 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
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 3,999: / Line 3,800: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?person ?personLabel ?spouse ?spouseLabel ?edtfmarriagespouse ?edtfmarriagespouseLabel ?PITmarriagespouse ?PITmarriagespouseLabel WHERE {
+SELECT ?depth  ?ioLabel ?itemLabel ?io ?item
-  ?person bnwdt:P41 ?spouse .
+WHERE {
-  OPTIONAL {?person bnp:P132 ?edtfmarriagestatement .
+      SERVICE gas:service {
-  ?edtfmarriagestatement bnps:P132 ?edtfmarriagedate .
+           gas:program gas:gasClass "com.bigdata.rdf.graph.analytics.BFS" ;
-  ?edtfmarriagestatement bnpq:P41 ?edtfmarriagespouse .}
+                       gas:in bnwd:Q3099 ;
-  OPTIONAL {?person bnp:P130 ?PITmarriagestatement .
+                       gas:linkType bnwdt:P12 ;
-  ?PITmarriagestatement bnps:P130 ?PITmarriagedate .
+                       gas:traversalDirection "Reverse";
-  ?PITmarriagestatement bnpq:P41 ?PITmarriagespouse .}
+                       gas:out ?item ;
-     SERVICE wikibase:label {
+                       gas:out1 ?depth ;
-      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
+                       gas:out2 ?io .
-     }
+      }
-}
+     SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
-ORDER BY DESC(?edtfmarriagespouseLabel) DESC(?PITmarriagespouseLabel)
+     }
+order by ?depth ?ioLabel ?itemLabel
 </sparql>
-=== Compare uses of item v free text ===
+=== Working with property paths: instance of [CAVEAT: experimental, probably wrong]===
 <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.
+# 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 4,026: / 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/>
-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 ?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
-# most of these are used in qualifiers - only P72, P71 and P88 found in main (and only a handful of uses of free text?)
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". }
-#?item (  bnp:P88|bnp:P91 | bnp:P72|bnp:P71) ?s .
-## the pairs
-#P21 evidence (free text) / P20 evidence (item)
-#P79 item exhibited / P80 item exhibited (free text)
-#P78 of / P66 of (free text)
-#P91 specific reference information / P88 specific reference information (free text)
-#P31 street address (free text) / P100 street address (item)
-#P72 was delegate at (free text) / P71 was delegate at (item)
-WHERE {
-  ?item ?p ?s .
-  ?prop wikibase:claim ?p;
-         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 .
-     ?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
+group by ?item ?itemLabel  ?instance_of ?instance_ofLabel
+ORDER BY ?item ?distance
 </sparql>
-=== Missing language labels ===
+==Dates==
+===All the Dates for Women FSAs===
 <sparql tryit="1">
+#title:fishing for dates for FSAs
-# query to check for any items/properties which don't have "en" labels. [currently not an issue but retained for reference.]
+# union query to get [hopefully] every date associated with women FSAs including main dates and qualifier dates
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 4,078: / Line 3,862: @@
 PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT
+SELECT distinct ?person ?personLabel ?prop_label ?qualLabel ?qual_dateLabel ?date_value  ?s
-  ?item  ?itemLabel
+#?prop ?qual
-   (group_concat(distinct ?language) as ?languages)
-  (count(distinct ?rdfs_label) as ?count) # TIL: where you put distinct matters!
 WHERE {
-  ?item ?p ?s.
-  ?item rdfs:label ?rdfs_label .  # rdfs item label (1 per language).
-   BIND(LANG(?rdfs_label) as ?language) .  # get 2 letter language codes
+   ?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") .
-   #optional { ?item rdfs:label ?engb . filter(lang(?engb)="en-gb").  }
+ {  # main dates
-  #optional { ?item rdfs:label ?en . filter(lang(?en)="en").  }
+  # get dates detail via ?s and psv
+   # gets edtf dates in simplified std wiki date format?
+  # https://github.com/ProfessionalWiki/WikibaseEdtf
+      ?s ?psv ?wdv .
+        ?wdv wikibase:timeValue ?date_value .
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en-gb, en". }
+   } # /main dates
-}
-group by ?item  ?itemLabel
+  UNION
-HAVING (?count<2)
-order by ?item
+  { # 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
+ SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+} # /where
+ORDER BY ?person ?prop_label ?date_value
 </sparql>
-=== Statements that contain both a date *and* an unknown value date===
+===Fetch any of multiple kinds of EDTF date for a woman===
 <sparql tryit="1">
-# A query to look for statements containing an <unknown value> date *and* a date
+# a union query to fetch stuff for multiple properties, in this case dates recorded in EDTF which need slightly different handling from PIT dates
-# caveat: not yet completely sure if it will work in all cases for main 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/>
@@ Line 4,115: / Line 3,929: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT  ?item ?itemLabel ?main_label ?qualLabel ?subLabel
+SELECT  ?person ?personLabel ?date_edtf ?date_prop ?date_label ?s
-(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.
+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
-{
+           ?claim wikibase:claim ?p;
-  {
+                 rdfs:label ?date_label. filter(lang(?date_label)="en") .
-   # qualifiers. [qualifiers need to include ?s in the group by]
-  ?item ?p ?s.
-  # labels
-  ?s ?subp ?sub .
-  ?qual wikibase:claim ?p;
-        wikibase:statementProperty ?subp.
-    ?s ?pq ?t .
-    ?date_prop wikibase:qualifier ?pq ;
+           ?s ?date_prop ?date_edtf .
-             wikibase:propertyType ?date_prop_type .
-    filter(?date_prop_type in (wikibase:Time, wikibase:Edtf) ).
+     ## filter for edtf dates
-  }
+     ## docs: https://github.com/ProfessionalWiki/WikibaseEdtf
-  UNION
-  {
-   # main [excluding ?s from group by this time]
-  ?item ?p ?sm.
-  ?sm ?ps ?t .
-  ?date_prop wikibase:claim ?p.
-  ?date_prop wikibase:statementProperty ?ps.
-  ?date_prop wikibase:propertyType ?date_prop_type .
-  ?date_prop rdfs:label ?main_label .  filter(lang(?main_label)="en-gb") .
-  filter(?date_prop_type in (wikibase:Time, wikibase:Edtf) ).
-  }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en_gb" }
-}
-group by ?item ?itemLabel ?s ?qualLabel ?subLabel  ?main_label
+    FILTER ( datatype(?date_edtf) = xsd:edtf  ) .
-having (?tcount >1 )  # comment out to get everything
+    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
+     }
-ORDER BY ?itemLabel ?main_label ?qualLabel ?subLabel ?date_prop
+ORDER BY ?personLabel
 </sparql>
+===Full values: dates ===
-=== Women with no dates===
 <sparql tryit="1">
-# Query for women with no dates
+# query for full values to access the timeValue and timePrecision of a date, in this case a date of birth.
-# 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/>
+## why is a more complex query needed?
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+## 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 4,180: / 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 ?person ?personLabel  (count(?date_value) as ?count)
+SELECT DISTINCT ?item ?itemLabel ?date ?precision
 WHERE {
+  ?item bnp:P26  ?statement. # date of birth (precision of these varies quite a bit)
- {  # main dates
+   ?statement bnpsv:P26 ?valueNode.
+  ?valueNode wikibase:timeValue ?date.
-   ?person bnwdt:P3 bnwd:Q3 . # women
+  ?valueNode wikibase:timePrecision ?precision.
-   optional {
-    ?person ?p ?s .
-      ?s ?date_prop ?wdv .
-        ?wdv wikibase:timeValue ?date_value . }
- } # /main dates
-  UNION
+    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
+}
-  { # qualifier dates
+ORDER BY ?date
-    ?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>
+=== Any main level date for women ===
-=== Women with more than X statements but no date of birth/death===
 <sparql tryit="1">
+# a query to get all types of main date for women
-#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/>
@@ Line 4,233: / 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 DISTINCT ?person ?personLabel ?date_label  ?date ?date_prop_type ?date_prop ?link_prop
-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 .   }
+   ?person bnwdt:P3 bnwd:Q3 . # women
-   optional { ?person bnwdt:P26 ?dob .   }
+   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}
-    optional { # was elected FSA. comment out optional lines to get FSAs only...
+    ?person ?p ?s .
-     ?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
+      ?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
-   optional {
+   # nb also possible to filter either/or time/edtf by property type
-    # main dates, apart from birth and death: P133 (widowed) P132 (married edtf) P131 (had child) P130 (married pit)
+  # filter(?date_prop_type in (wikibase:Edtf, wikibase:Time ) ) .
-     ?person ( bnwdt:P130 | bnwdt:P131 | bnwdt:P132 | bnwdt:P133 ) ?main_date .
-    } # /optional main dates
-  optional {
+    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
-     # 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
+ORDER BY ?personLabel ?date
 </sparql>
-=== Places of residence that lack instance of locality===
+=== Counting Dates===
 <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 4,297: / Line 4,048: @@
 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 ?residence ?residenceLabel ?inst ?instLabel
+SELECT ?person ?personLabel (COUNT(DISTINCT ?date_value) as ?count)
-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?
+WHERE {
-       ## Note: some have Q618 territory of the British Empire, which also lacks any instance of at present
+ {  # 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)
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+ORDER BY ?count ?person
-}
-ORDER BY ?residenceLabel
 </sparql>
-=== Locations that don't have Wikidata links or their Wikidata pages lack geocoordinates===
+=== Start dates that might not have accompanying end dates ===
 <sparql tryit="1">
+#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 4,321: / Line 4,093: @@
 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
+#(group_concat(?other_date_label; SEPARATOR=" | ") as ?other_dates)
-SELECT distinct ?locationLabel ?location ?wikidata ?wd_geo ?instanceLabel ?bn_geo
+WHERE {
-WHERE {
+   ?person bnwdt:P3 bnwd:Q3 .
-   {?item bnwdt:P29  ?location . } # resided at
+  # need to find start times anywhere and get prop label so use claim.
-   union
+   ?person ?p ?s .
-   {?location bnwdt:P12 bnwd:Q2147 .} # OR has instance of locality
+   ?claim wikibase:claim ?p;
-  union
+         rdfs:label ?prop_label. filter(lang(?prop_label)="en") .
-  {?item bnwdt:P2  ?location . } # OR location P2
-  # any other possibles ?
+# 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
-  optional { ?location bnwdt:P12 ?instance .  } # check instance of
+     ?s bnpq:P27 ?start_date . # get start dates
-   optional {
+    optional {?s bnpq:P28 ?end_date .} # check for end dates
-       ?location bnwdt:P117 ?ws .  # wikidata id
-         bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
+ #   optional {
-         SERVICE <https://query.wikidata.org/sparql> {
+ #       ?s ?pq ?other_date . # could there be any other associated dates?
-           optional {?wikidata wdt:P625 ?wd_geo .}   # does the wikidata page have geocoords?
-         } # /wikidata service
+ #       ?qual_prop wikibase:qualifier ?pq;
-    } #/wikidata optional
+ #             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 .  }
-  filter (!bound(?wd_geo) ). # no geocoords in wikidata. some may have coords in BN...
+ #  } # / optional other dates
-   optional { ?location bnwdt:P153 ?bn_geo .  } # so check for coords in BN
+   # filter(!bound(?end_date)). # to filter out rows with an end date
-  ##filter (!bound(?bn_geo)) . # uncomment to filter those out as well
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+ SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
-}
-ORDER BY ?wikidata ?locationLabel
+}
+ORDER BY ?personLabel ?prop_label ?start_date
 </sparql>
-=== Archaeological sites that don't have National Heritage England list numbers ===
+=== End dates that might not accompanying start dates ===
 <sparql tryit="1">
-#title:archaeological sites without National Heritage numbers
+#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 4,368: / Line 4,150: @@
 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 ?item ?itemLabel ?location ?locationLabel
+SELECT distinct ?personLabel ?prop_label ?end_date
-(if(bound(?locEngland), "yes", "") as ?inEngland)
+(if(bound(?start_date), "yes", "no") as ?has_start_date)
+(group_concat(?other_date_label; SEPARATOR=" | ") as ?other_dates)
-WHERE {
+?person ?s
-   ?item bnwdt:P12 bnwd:Q86 . # item instance of archaeological site
+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
-  filter not exists {?item bnwdt:P129 ?thing .  } # without NH list number
+     ?s bnpq:P28 ?end_date . # get end dates
-  optional { ?item bnwdt:P2 ?location .  } # location if it has one
+    optional {?s bnpq:P27 ?start_date .} # check for start dates
-  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". }
+    optional {
-}
+        ?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 .  }
+   } # / 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". }
+}
-order by ?itemLabel
+group by  ?personLabel ?prop_label ?end_date ?start_date ?has_start_date ?person ?s
+ORDER BY ?personLabel ?prop_label ?end_date
 </sparql>
-=== Date of latest edit for every item, according to WQS ===
+=== Women having children ===
 <sparql tryit="1">
-#title:latest edits dates for wikibase items
+#title:women having children
+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/>
-## because of WQS disappearing data bugs this may not always match the latest edit in the page history
+# lol defaultView:Timeline{"hide":["?s", "?date_prec", ""]}
-SELECT ?item ?date ?dateLabel
+# P131 had child in / P45 child
-WHERE {
+# a handful of P45 named children don't have dob though probably have dob in wikidata
-   ?item wikibase:timestamp ?date .
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-order by ?date
-</sparql>
+SELECT distinct ?person ?personLabel ?childLabel ?date_value ?date_prec ?had_child_edtf ?note
+?s
-=== Wikidata ID is a URL ===
+where {
-<sparql tryit="1">
+  ?person bnwdt:P3 bnwd:Q3 . # select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+{
+  # had child in (unnamed children)
+  ?person bnp:P131 ?s .
+      ?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.
-#title:check for accidental use of URL instead of wikidata ID
+  # get dates detail via ?s and psv
-## all checked and fixed at 18/12/23 but adding the query in case it recurs
+  # 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
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+  # 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)
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+  #?person bnwdt:P131 ?had_child .
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+   # not much added in quals for had child. only maybe note P47. some have sourcing circumstances.
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
+   optional { ?s bnpq:P47 ?note .  } #
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+  }
-SELECT distinct ?item ?itemLabel ?wd_http
+  union
-WHERE {
+  {
+  # named children (are any in both sections??? from dates looks possible a couple might be [wherry / hodgson])
+   ?person bnp:P45 ?s.
+        ?s bnps:P45 ?child .
+      optional { ?child bnp:P26 ?ss .
+                    ?ss bnps:P26 ?dob .
+                     ?ss ?psv ?wdv .
+                        ?wdv wikibase:timeValue ?date_value .
+                        ?wdv wikibase:timePrecision ?date_prec .
+               }
+  }
-  ?item bnwdt:P117 ?wd_http .  # wikidata id
+    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-  filter(strstarts(str(?wd_http), "http")).
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
-ORDER BY ?itemLabel
+order by ?person ?date_value
 </sparql>
-=== Wikidata URL is not a URL ===
+=== Women who were adults in 1911 ===
 <sparql tryit="1">
-#title:check for wikidata URLs that don't start with http. could still be other problems!
+#title:Women who were adults in 1911 and their calculated ages
-## 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/>
@@ Line 4,447: / Line 4,272: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+SELECT distinct ?person ?personLabel ?statements ?dob ?dod ?age1911
-SELECT distinct ?item ?itemLabel ?wd_url
+WHERE {
-WHERE {
+   ?person bnwdt:P3 bnwd:Q3 ;
+         wikibase:statements ?statements .
+   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}
+   ?person bnwdt:P26 ?dob .
+   #optional {
+      ?person bnwdt:P15 ?dod .
+   #}
-  ?item bnp:P117 ?ws .  # wikidata id
+   filter(year(?dod) > 1911 && year(?dob) <=1893 ) .
-     ?ws bnpq:P14 ?wd_url .
-   filter(!strstarts(str(?wd_url), "http")).
+   #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 ) ) .
-  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>
-=== Questions ===
-<sparql tryit="1">
-#title:asking questions
-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 ?personLabel ?propLabel ?link ?question
-WHERE {
-  ?person bnwdt:P3 bnwd:Q3 .
-  ?person ?p ?s .
-      ?prop wikibase:claim ?p;
-         wikibase:statementProperty ?ps.
-   # direct link to relevant part of page
-         BIND (REPLACE(STR(?prop), "^.*/([^/]*)$", "$1") as ?pid).
-         bind(iri(concat(str(?person), "#", ?pid)) as ?link ) .
-  # the question
-     ?s bnpq:P157 ?question .
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-order by ?personLabel
-</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