@@ Line 1: / Line 1: @@
+[[Project:SPARQL/admin | Admin/batch tools queries]]
 ==SAL and RAI==
@@ Line 552: / Line 554: @@
 </sparql>
+=== Lecturers ===
+<sparql tryit="1">
+#title:lecturers
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
+PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
+PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
+PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
+PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
+SELECT distinct ?person ?personLabel  ?positionLabel
+?organisedLabel ?ofLabel
+?qual_propLabel ?qualLabel
+#?position ?of  ?work ?organised  ?date_precision ?qual_prop ?date ?qual ?workLabel
+?s
+WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . # women
+  # work activities: held position / held position (free text) /  employed as
+  #?person ( bnp:P17|bnp:P48|bnp:P105 ) ?s .
+  ?person ?work_p ?s . # for activity type label
+    ?work wikibase:claim ?work_p .
+    ?s ?bnps ?position .
+    # freelance and extension lecturing (q701 and q3021)
+    { ?s ?bnps bnwd:Q701  . } union { ?s ?bnps bnwd:Q3021 .  }
+    # employer / organised by / of (incl free text).
+    OPTIONAL { ?s bnpq:P109 ?organised .}
+    OPTIONAL { ?s ( bnpq:P78 | bnpq:P66 ) ?of .}
+   # optional { ?s bnpq:P2 ?location . } # do locations separately.
+  # dates with precision
+ #   optional {
+ #     ?s (bnpqv:P1 | bnpqv:P27 | bnpqv:P28  ) ?pqv.
+ #     ?s ?pqq ?pqv . # just gets the uri but doesnt seem to cause dups
+ #        ?pqv wikibase:timeValue ?date .
+ #        ?pqv wikibase:timePrecision ?date_precision .
+ #     }
+    # qualifiers
+    optional {
+      ?s ?pq ?qual .
+         ?qual_prop wikibase:qualifier ?pq .
+      } # /dates
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+} # /where
+ORDER BY ?person ?s
+</sparql>
 == Professional Activities and Organisations ==
@@ Line 567: / Line 630: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?personLabel ?serviceLabel ?qual_propLabel  ?qualLabel   ?service ?qual ?person #?s
+SELECT distinct ?personLabel ?serviceLabel ?qual_propLabel  ?qualLabel   ?qual ?person ?s # ?service
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
@@ Line 573: / Line 637: @@
    ?person bnp:P102 ?s .   # served on P102
-  ?person ?p ?s .    # for claim
+     ?s bnps:P102 ?service .
-  ?claim wikibase:claim ?p;
-         wikibase:statementProperty ?ps;
-         wikibase:propertyType ?prop_type.
-     ?s ?ps ?service . # service on what
     optional {  #qualifiers, if any
       ?s ?pq ?qual .
          ?qual_prop wikibase:qualifier ?pq.
-        SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".
-        ?qual_prop rdfs:label ?qual_propLabel .  # what kind of thing
-        } # /label service
        } # /quals
@@ Line 593: / Line 648: @@
 ORDER BY ?personLabel ?s
 </sparql>
@@ Line 758: / Line 814: @@
 <sparql tryit="1">
 #title:ppa buckets (revised February 2024)
+# broad PPA grouping categories to use for overviews and analysis within categories
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 774: / Line 832: @@
        ?ppa wikibase:claim ?p;
           wikibase:statementProperty ?ps.
+      # note: i think you need rdfs:label (*Label won't work) for the bind()
        SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb".
-                        ?ppa rdfs:label ?ppa_label.       # what kind of thing
+                        ?ppa rdfs:label ?ppa_label.
                  } # /label service
@@ Line 785: / Line 845: @@
        ?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",
@@ Line 807: / Line 868: @@
 </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===
+=== Suffrage-related activities ===
 <sparql tryit="1">
-# People not in London linked as a graph by a NUTS region or country (excluding England) at which they were once resident in the UK
+#title:initial query for suffrage activities
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 822: / Line 882: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Graph
+SELECT distinct ?person ?personLabel ?mainLabel ?sub_Label ?qualLabel ?locationLabel ?date
-SELECT ?resident ?residentLabel ?region ?regionLabel
+# ?pq ?sub_ ?qual ?main
+?s
 WHERE {
-  ?resident bnwdt:P29 ?residence .
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2035 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2036 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2037 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2038 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2039 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2040 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2041 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2042 .}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q39.}
-    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2534.}
-  ?residence bnwdt:P33 ?district .
-  ?district bnwdt:P33 ?county .
-  ?county bnwdt:P33 ?region .
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-</sparql>
-===People whose residence was at one time in the east or south east of England, excluding London===
+    ?person bnwdt:P3 bnwd:Q3 . #select women
+    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+    ?person ?p ?s .
+      ?s ?sub ?sub_ .
+        ?main wikibase:claim ?p.
+        ?main wikibase:statementProperty ?sub.
+  # sub_ i/o - some do have suffrage activity
+  #  optional { ?sub_ bnwdt:P12 ?sub_io . ?sub_ bnwdt:P12 bnwd:Q1166 . }
+  # union
+   {
+    # a qualifier (anywhere) has i/o suffrage activity
+       ?s bnpq:P12 bnwd:Q1166.
+    }
-<sparql tryit="1">
+# what about a main rather than qualifier having i/o suffrage activity? i don't think there are any atm but could be.
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+# union
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+ #   { # this might find extra linked i/o suffrage but i'm not sure it works.
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
+ #     ?sub_ bnwdt:P12 bnwd:Q1166 .
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+ #     }
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
+  union
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+    {
+     # does *not* have i/o suffrage activity in any qualifiers  ... slows things right down and doesn't seem to make any difference to results?
+     #filter not exists { ?s bnpq:P12 bnwd:Q1166. }
+     # ... but a qualifier *does* have i/o suffrage activity. i think!
+      ?s ?pq ?qual .
+        ?qual bnwdt:P12 bnwd:Q1166 .
+      } # /union
+  optional {
+    # date qualifiers. [assumes no edtf in quals. ] all seem to be p.i.t.
+        ?s ?dpq ?date .
+          ?qual_date wikibase:qualifier ?dpq .
+          ?qual_date wikibase:propertyType wikibase:Time.
+  }
+  optional { ?s bnpq:P78 ?of. }  # outside the union seems much speedier
+  optional { ?s bnpq:P2 ?location . }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-SELECT ?resident ?residentLabel ?residenceLabel ?districtLabel ?countyLabel ?regionLabel
-WHERE {
-  ?resident bnwdt:P29 ?residence .
-  ?residence bnwdt:P33 ?district .
-  ?district bnwdt:P33 ?county .
-  ?county bnwdt:P33 ?region .
-    {?county bnwdt:P33 bnwd:Q67 .}
-    UNION
-    {?county bnwdt:P33 bnwd:Q85 .}
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residenceLabel
+order by ?personLabel ?mainLabel
 </sparql>
-===People whose residence was at one time in North East England or Yorkshire and the Humber===
+==Place==
+===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 whose residence was at one time in North East England or Yorkshire and the Humber
+# 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 881: / Line 955: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?resident ?residentLabel ?residenceLabel ?districtLabel ?countyLabel ?regionLabel
+#defaultView:Graph
+SELECT ?resident ?residentLabel ?region ?regionLabel
 WHERE {
    ?resident bnwdt:P29 ?residence .
-  ?residence bnwdt:P33 ?district .
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2035 .}
-  ?district bnwdt:P33 ?county .
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2036 .}
-  ?county bnwdt:P33 ?region .
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2037 .}
-     {?county bnwdt:P33 bnwd:Q72 .}
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2038 .}
-     UNION
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2039 .}
-     {?county bnwdt:P33 bnwd:Q200 .}
+    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 ?residenceLabel
 </sparql>
-===People not in London with the district, county, and region at which they were once resident (in the UK) listed===
+===People whose residence was at one time in the east or south east of England, excluding London===
 <sparql tryit="1">
-# 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/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 908: / Line 987: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?resident ?residentLabel ?district ?districtLabel ?county ?countyLabel ?region ?regionLabel
+SELECT ?resident ?residentLabel ?residenceLabel ?districtLabel ?countyLabel ?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 .
+    {?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 ?residentLabel
+ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residenceLabel
 </sparql>
-===People sorted by the number of places they lived, including the number of cites/towns/villages they lived in===
+===People whose residence was at one time in North East England or Yorkshire and the Humber===
 <sparql tryit="1">
+# People whose residence was at one time in North East England or Yorkshire and the Humber
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 940: / Line 1,014: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?person ?personLabel (count(?resided) as ?residence_count) (count(distinct ?resided) as ?residence_distinct) WHERE {
+SELECT ?resident ?residentLabel ?residenceLabel ?districtLabel ?countyLabel ?regionLabel
-   ?person bnwdt:P3 bnwd:Q3 ;
+WHERE {
-         wikibase:statements ?statements .
+  ?resident bnwdt:P29 ?residence .
-   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?residence bnwdt:P33 ?district .
-  ?person bnp:P29/bnps:P29 ?resided.
+  ?district bnwdt:P33 ?county .
-   SERVICE wikibase:label {
+   ?county bnwdt:P33 ?region .
-      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
+    {?county bnwdt:P33 bnwd:Q72 .}
-  }
+    UNION
-} group by ?person ?personLabel ?statements order by desc(?residence_count)
+    {?county bnwdt:P33 bnwd:Q200 .}
-# Credit to @Tagishsimon for helping me figure out the counting logic here
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residenceLabel
 </sparql>
-===Places at which women resided, sorted by how many residences all women had at a given village/town/city/London area===
+===People not in London with the district, county, and region at which they were once resident (in the UK) listed===
 <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 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 965: / Line 1,041: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?residence ?residenceLabel (count(?residence) as ?residence_count) #count number of places at which women lived
+SELECT ?resident ?residentLabel ?district ?districtLabel ?county ?countyLabel ?region ?regionLabel
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . # select women
+   ?resident bnwdt:P29 ?residence .
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2035 .}
-  ?person bnwdt:P29 ?residence . # select residences
+    FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2036 .}
+    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 ?regionLabel ?countyLabel ?districtLabel ?residentLabel
-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 sorted by the number of places they lived, including the number of cites/towns/villages they lived in===
 <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 989: / Line 1,073: @@
 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 ?person ?personLabel (count(?resided) as ?residence_count) (count(distinct ?resided) as ?residence_distinct) WHERE {
-WHERE {
+   ?person bnwdt:P3 bnwd:Q3 ;
-  ?person bnwdt:P3 bnwd:Q3 . # select women
+         wikibase:statements ?statements .
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-   ?person bnwdt:P29 ?residence . # select residences
+   ?person bnp:P29/bnps:P29 ?resided.
-  ?residence bnwdt:P33 ?district . #select districts
+   SERVICE wikibase:label {
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
-}
+  }
-GROUP BY ?district ?districtLabel
+} group by ?person ?personLabel ?statements order by desc(?residence_count)
-ORDER BY DESC(?district_count)
+# Credit to @Tagishsimon for helping me figure out the counting logic here
 </sparql>
-===Counties in which women resided, 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 in which women resided, 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,014: / Line 1,098: @@
 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
    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 recorded in CAS Indexes of Archaeological Papers, 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 recorded in CAS Indexes of Archaeological Papers, 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,040: / Line 1,122: @@
 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:P76 bnwd:Q419 . #select women recorded in CAS Indexes of Archaeological Papers
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
    ?person bnwdt:P29 ?residence . # select residences
    ?residence bnwdt:P33 ?district . #select districts
-  ?district bnwdt:P33 ?county . #select counties
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-GROUP BY ?county ?countyLabel
+GROUP BY ?district ?districtLabel
-ORDER BY DESC(?county_count)
+ORDER BY DESC(?district_count)
 </sparql>
-====Counties of residence for women nominated as FSAs, sorted by how many residences all women had in that county====
+===Counties in which women resided, sorted by how many residences all women had in that county===
 <sparql tryit="1">
-# Counties of residence for women nominated as FSAs, 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,070: / Line 1,150: @@
 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
@@ Line 1,081: / Line 1,160: @@
 </sparql>
-====Counties of residence for women nominated to RAI, sorted by how many residences all women had in that county====
+====Counties of residence for women recorded in CAS Indexes of Archaeological Papers, sorted by how many residences all women had in that county====
 <sparql tryit="1">
-# Counties of residence for women nominated to RAI, sorted by how many residences all women had in that county
+# Counties of residence for women recorded in CAS Indexes of Archaeological Papers, sorted by how many residences all women had in that county
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,097: / Line 1,176: @@
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
-   ?person bnwdt:P7 ?signatory . #select women who were nominated for election to RAI
+   ?person bnwdt:P76 bnwd:Q419 . #select women recorded in CAS Indexes of Archaeological Papers
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
    ?person bnwdt:P29 ?residence . # select residences
@@ Line 1,108: / Line 1,187: @@
 </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 as FSAs, sorted by how many residences all women had in that county====
 <sparql tryit="1">
-# Counties of residence for women who spoke at RAI meetings, sorted by how many residences all women had in that county
+# Counties of residence for women nominated as FSAs, sorted by how many residences all women had in that county
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,124: / Line 1,203: @@
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
-   ?person bnwdt:P23 bnwd:Q29 . #select women who spoke at RAI Meeting
+   ?person bnwdt:P16 ?signatory . #select women who were nominated for election to FSA
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
    ?person bnwdt:P29 ?residence . # select residences
@@ Line 1,135: / Line 1,214: @@
 </sparql>
-====Counties of residence for women who exhibited at RAI meetings, sorted by how many residences all women had in that county====
+====Counties of residence for women nominated to RAI, sorted by how many residences all women had in that county====
 <sparql tryit="1">
-# Counties of residence for women who exhibited at RAI meetings, sorted by how many residences all women had in that county
+# Counties of residence for women nominated to RAI, sorted by how many residences all women had in that county
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,151: / Line 1,230: @@
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
-   ?person bnwdt:P13 bnwd:Q29 . #select women who exhibited at RAI Meeting
+   ?person bnwdt:P7 ?signatory . #select women who were nominated for election to RAI
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
    ?person bnwdt:P29 ?residence . # select residences
@@ Line 1,162: / Line 1,241: @@
 </sparql>
-====Counties of residence for women recorded in CAS Indexes of Archaeological Papers, on a map====
+====Counties of residence for women who spoke at RAI meetings, sorted by how many residences all women had in that county====
 <sparql tryit="1">
+# Counties of residence for women who spoke at RAI meetings, sorted by how many residences all women had in that county
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,174: / Line 1,254: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Map{"hide":["?geo", "?wikidata"]}
+SELECT ?county ?countyLabel (count(?county) as ?county_count) #count number of counties in which women lived
-#title:Counties of residence for women recorded in CAS Indexes of Archaeological Papers
-SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
-   ?person bnwdt:P76 bnwd:Q419 . #select women recorded in CAS Indexes of Archaeological Papers
+   ?person bnwdt:P23 bnwd:Q29 . #select women who spoke at RAI Meeting
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
    ?person bnwdt:P29 ?residence . # select residences
    ?residence bnwdt:P33 ?district . #select districts
    ?district bnwdt:P33 ?county . #select counties
-      optional { ?county bnwdt:P153 ?geo2 .  } # for geocoords added to BN
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-      optional {
-       ?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 .
-                  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". }
 }
+GROUP BY ?county ?countyLabel
+ORDER BY DESC(?county_count)
 </sparql>
-====Counties of residence for women nominated as FSAs, 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/>
@@ Line 1,220: / Line 1,281: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Map{"hide":["?geo", "?wikidata"]}
+SELECT ?county ?countyLabel (count(?county) as ?county_count) #count number of counties in which women lived
-#title:Counties of residence for women nominated as FSAs
-SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
-   ?person bnwdt:P16 ?signatory . #select women who were nominated for election to FSA
+   ?person bnwdt:P13 bnwd:Q29 . #select women who exhibited at RAI Meeting
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
    ?person bnwdt:P29 ?residence . # select residences
    ?residence bnwdt:P33 ?district . #select districts
    ?district bnwdt:P33 ?county . #select counties
-      optional { ?county bnwdt:P153 ?geo2 .  } # for geocoords added to BN
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
-      optional {
+GROUP BY ?county ?countyLabel
-       ?county bnp:P117 ?ws .  # wikidata id P117
+ORDER BY DESC(?county_count)
-         ?ws bnpq:P14 ?wikidata_url .
+</sparql>
-         BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata )
-      SERVICE <https://query.wikidata.org/sparql> {
-         optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available
-       } # /wikidata service
-       } #/wikidata optional
-    BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
+====Counties of residence for women recorded in CAS Indexes of Archaeological Papers, on a map====
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-</sparql>
+<sparql tryit="1">
-==== Counties of residence for women nominated to RAI, on a map ====
-<sparql tryit="1">
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,264: / Line 1,308: @@
 #defaultView:Map{"hide":["?geo", "?wikidata"]}
-#title:Counties of residence for women nominated to RAI
+#title:Counties of residence for women recorded in CAS Indexes of Archaeological Papers
 SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
+  ?person bnwdt:P76 bnwd:Q419 . #select women recorded in CAS Indexes of Archaeological Papers
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-  ?person bnwdt:P7 ?signatory . #select women who were nominated for election to RAI
    ?person bnwdt:P29 ?residence . # select residences
    ?residence bnwdt:P33 ?district . #select districts
@@ Line 1,284: / Line 1,327: @@
        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,294: / Line 1,341: @@
 </sparql>
-==== Counties of residence for women who spoke at RAI meetings, on a map====
+====Counties of residence for women nominated as FSAs, on a map====
 <sparql tryit="1">
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,306: / Line 1,354: @@
 #defaultView:Map{"hide":["?geo", "?wikidata"]}
-#title:Counties of residence for women who spoke at RAI meetings
+#title:Counties of residence for women nominated as FSAs
 SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
+  ?person bnwdt:P16 ?signatory . #select women who were nominated for election to FSA
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-   ?person bnwdt:P23 bnwd:Q29 . #select women who spoke at RAI Meeting
    ?person bnwdt:P29 ?residence . # select residences
@@ Line 1,334: / Line 1,382: @@
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
+</sparql>
-</sparql>
-==== Counties of residence for women who exhibited at RAI meetings, on a map ====
+==== Counties of residence for women nominated to RAI, on a map ====
 <sparql tryit="1">
-#title:Counties of residence for women who exhibited at RAI meetings
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,351: / Line 1,397: @@
 #defaultView:Map{"hide":["?geo", "?wikidata"]}
+#title:Counties of residence for women nominated to RAI
 SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
@@ Line 1,356: / Line 1,403: @@
    ?person bnwdt:P3 bnwd:Q3 . # select women
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-   ?person bnwdt:P13 bnwd:Q29 . #select women who exhibited at RAI Meeting
+   ?person bnwdt:P7 ?signatory . #select women who were nominated for election to RAI
    ?person bnwdt:P29 ?residence . # select residences
@@ Line 1,380: / Line 1,427: @@
 </sparql>
-==== Counties of residence for women in any of the above five categories, mapped====
+==== Counties of residence for women who spoke at RAI meetings, on a map====
 <sparql tryit="1">
-## IMPORTANT: LIMITATIONS OF THE MAP
-## Only the top category of activity (layer) can be seen when all are selected (the default)
-## To see each layer, you need to deselect all in the layers menu (diamond shaped icon, top right corner of the map) and view one layer at a time. Unfortunately this is the only way to compare them at the moment.
-## (But I'll look into how I might be able to improve on this)
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,397: / Line 1,438: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#title:Counties of residence for women who were nominated for election or had publications recorded or spoke/exhibited at RAI
 #defaultView:Map{"hide":["?geo", "?wikidata"]}
+#title:Counties of residence for women who spoke at RAI meetings
-SELECT distinct  ?county ?countyLabel ?wikidata ?geo  ?layer  #?person ?personLabel
+SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+   ?person bnwdt:P23 bnwd:Q29 . #select women who spoke at RAI Meeting
-  {
-    #women who were nominated for election to FSA | RAI
-    ?person ( bnp:P16 | bnp:P7 ) ?stmt .
-  }
-  union
-  {
-    # women with publications recorded in indexes of archaeological papers
-    ?person bnp:P76 ?stmt .
-        ?stmt bnps:P76 bnwd:Q419 .
-  }
-  union
-  {
-    # women who spoke|exhibited at RAI Meeting
-    ?person (bnp:P23 | bnp:P13) ?stmt .
-       ?stmt (bnps:P23 | bnps:P13) bnwd:Q29 .
-  }
-  # get the p labels for layers
-  ?person ?p ?stmt .
-  ?claim wikibase:claim ?p;
-        rdfs:label ?layer. filter(lang(?layer)="en-gb").
-  # get geo stuff
    ?person bnwdt:P29 ?residence . # select residences
    ?residence bnwdt:P33 ?district . #select districts
@@ Line 1,439: / Line 1,458: @@
        SERVICE <https://query.wikidata.org/sparql> {
           optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available
         } # /wikidata service
         } #/wikidata optional
-     BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use it, if not try geo2
+     BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-order by ?layer
 </sparql>
-===Regions in which women resided, sorted by how many residences all women had in that region===
+==== Counties of residence for women who exhibited at RAI meetings, on a map ====
 <sparql tryit="1">
-# Regions in which women resided, sorted by how many residences all women had in that region
+#title:Counties of residence for women who exhibited at RAI meetings
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 1,462: / Line 1,483: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?region ?regionLabel (count(?region) as ?region_count) #count number of regions in which women lived
+#defaultView:Map{"hide":["?geo", "?wikidata"]}
+SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo
 WHERE {
    ?person bnwdt:P3 bnwd:Q3 . # select women
    FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?person bnwdt:P13 bnwd:Q29 . #select women who exhibited at RAI Meeting
    ?person bnwdt:P29 ?residence . # select residences
    ?residence bnwdt:P33 ?district . #select districts
    ?district bnwdt:P33 ?county . #select counties
-  ?county bnwdt:P33 ?region . #select region
+      optional { ?county bnwdt:P153 ?geo2 .  } # for geocoords added to BN
-   FILTER NOT EXISTS {?region bnwdt:P117 "Q145" .} #filter out UK (where UK is sub-region of NI)
+      optional {
+       ?county bnp:P117 ?ws .  # wikidata id P117
+         ?ws bnpq:P14 ?wikidata_url .
+         BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata )
+      SERVICE <https://query.wikidata.org/sparql> {
+         optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available
+       } # /wikidata service
+       } #/wikidata optional
+    BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-GROUP BY ?region ?regionLabel
-ORDER BY DESC(?region_count)
 </sparql>
+==== Counties of residence for women in any of the above five categories, mapped====
-=== Women living in London during the 1890s ===
+<sparql tryit="1">
+## IMPORTANT: LIMITATIONS OF THE MAP
+## Only the top category of activity (layer) can be seen when all are selected (the default)
+## To see each layer, you need to deselect all in the layers menu (diamond shaped icon, top right corner of the map) and view one layer at a time. Unfortunately this is the only way to compare them at the moment.
+## (But I'll look into how I might be able to improve on this)
-<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,492: / Line 1,530: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?personLabel ?date_label ?date ?person ?address ?address_item ?londonLabel ?geo ?long ?lat
+#title:Counties of residence for women who were nominated for election or had publications recorded or spoke/exhibited at RAI
+#defaultView:Map{"hide":["?geo", "?wikidata"]}
+SELECT distinct  ?county ?countyLabel ?wikidata ?geo  ?layer  #?person ?personLabel
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . # women
+   ?person bnwdt:P3 bnwd:Q3 . # select women
-   ?person bnp:P29 ?s .   # resided at
+   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-    ?s bnps:P29 ?london .
-      ?london bnwdt:P33+ bnwd:Q322 .  # in Q322 greater london.
+  {
+     #women who were nominated for election to FSA | RAI
-     # optional street address (text)
+     ?person ( bnp:P16 | bnp:P7 ) ?stmt .
-  optional {
+  }
-     ?s bnpq:P31 ?address .
+   union
-    }
+   {
-   # optional street address (item)
+    # women with publications recorded in indexes of archaeological papers
-   optional {
+     ?person bnp:P76 ?stmt .
-     ?s bnpq:P100 ?address_item .
+        ?stmt bnps:P76 bnwd:Q419 .
-    }
+  }
+  union
-   # dates. About 30? not dated.
+   {
-     #optional {
+     # women who spoke|exhibited at RAI Meeting
-     ?s ?pq ?date .
+     ?person (bnp:P23 | bnp:P13) ?stmt .
-     # ?date wikibase:timeValue ?date_value. # if you don't want date label this should work instead
+       ?stmt (bnps:P23 | bnps:P13) bnwd:Q29 .
+  }
-      ?qual_prop wikibase:qualifier ?pq;
-              wikibase:propertyType wikibase:Time ; # nb excludes edtf dates
+  # get the p labels for layers
-              rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # what kind of date is it.
+  ?person ?p ?stmt .
-    #  } # /dates
+  ?claim wikibase:claim ?p;
+        rdfs:label ?layer. filter(lang(?layer)="en-gb").
-    # filter 1890-1899
+  # get geo stuff
-   FILTER("1890-01-01"^^xsd:dateTime <= ?date && ?date < "1899-12-31"^^xsd:dateTime).
+  ?person bnwdt:P29 ?residence . # select residences
+  ?residence bnwdt:P33 ?district . #select districts
+   ?district bnwdt:P33 ?county . #select counties
+      optional { ?county bnwdt:P153 ?geo2 .  } # for geocoords added to BN
+      optional {
+       ?county bnp:P117 ?ws .  # wikidata id P117
+         ?ws bnpq:P14 ?wikidata_url .
+         BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata )
-  # address geocoordinates
+      SERVICE <https://query.wikidata.org/sparql> {
-   optional {
+         optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available
-     ?s ?pqq ?geo .
+       } # /wikidata service
-        ?qual_geo wikibase:qualifier ?pqq;
+       } #/wikidata optional
-                  wikibase:propertyType wikibase:GlobeCoordinate.
-         BIND(geof:longitude(?geo) AS ?long)
-         BIND(geof:latitude(?geo)  AS ?lat)
-             }
-  # todo booth codes
+    BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use it, if not try geo2
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-ORDER BY ?person ?date
+order by ?layer
+</sparql>
+===Regions in which women resided, sorted by how many residences all women had in that region===
+<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/>
+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 ?region ?regionLabel (count(?region) as ?region_count) #count number of regions in which women lived
+WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . # select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?person bnwdt:P29 ?residence . # select residences
+  ?residence bnwdt:P33 ?district . #select districts
+  ?district bnwdt:P33 ?county . #select counties
+  ?county bnwdt:P33 ?region . #select region
+  FILTER NOT EXISTS {?region bnwdt:P117 "Q145" .} #filter out UK (where UK is sub-region of NI)
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+GROUP BY ?region ?regionLabel
+ORDER BY DESC(?region_count)
 </sparql>
-==== Map of Women living in 1890s London ====
+=== Women living in London during the 1890s ===
 <sparql tryit="1">
@@ Line 1,554: / Line 1,625: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Map
 SELECT distinct ?personLabel ?date_label ?date ?person ?address ?address_item ?londonLabel ?geo ?long ?lat
@@ Line 1,600: / Line 1,670: @@
 }
 ORDER BY ?person ?date
 </sparql>
-=== Where did women who published in Folklore/Folk-lore Record live? ===
+==== Map of Women living in 1890s London ====
 <sparql tryit="1">
-# Map of all places of residence for women who had publications in Folklore/Folk-lore Record
+#title:Women living in 1890s London
+# Query for women living in (greater) london in the 1890s
+# 1 row per person per address per date, could be reduced to 1 row per person if preferred.
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,614: / Line 1,687: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Map{"hide":["?geo", "?count"]}
+#defaultView:Map
+SELECT distinct ?personLabel ?date_label ?date ?person ?address ?address_item ?londonLabel ?geo ?long ?lat
-SELECT  ?person ?personLabel ?residenceLabel ?residence ?geo (count( ?person) as ?count)  #(concat(str(?count), " publication") as ?count_lbl)
 WHERE {
-   ?person bnwdt:P3 bnwd:Q3 . # select women
+   ?person bnwdt:P3 bnwd:Q3 . # women
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+   ?person bnp:P29 ?s .   # resided at
-  ?person bnwdt:P76 bnwd:Q419 . # people with publications listed in indexes of archaeological papers. [262]
+    ?s bnps:P29 ?london .
-   ?person bnp:P76 ?s .
+       ?london bnwdt:P33+ bnwd:Q322 .  # in Q322 greater london.
-   ## works published in P101. folklore / folk-lore record q487 q490
-      ?s bnpq:P101 ?in .
-       {?s bnpq:P101 bnwd:Q487 } union { ?s bnpq:P101 bnwd:Q490 . }
-      # why does above pick up these two journals as well?
-      FILTER ( ?in not in ( bnwd:Q665 , bnwd:Q636 ) ) .
-  ?person bnwdt:P29  ?residence .
-      optional { ?residence bnwdt:P153 ?geo2 .  } # for geocoords added to BN
-   optional {
+    # optional street address (text)
+  optional {
-       ?residence bnp:P117 ?ws .  # wikidata id P117
+    ?s bnpq:P31 ?address .
+    }
-         ?ws bnpq:P14 ?wikidata_url .
+  # optional street address (item)
-         BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata )
+  optional {
+    ?s bnpq:P100 ?address_item .
-       SERVICE <https://query.wikidata.org/sparql> {
+    }
-       optional {?wikidata wdt:P625 ?geo1 .  } # geocoords if available
+  # dates. About 30? not dated.
+    #optional {
-      } # /wikidata service
+    ?s ?pq ?date .
-    } #/wikidata optional
+     # ?date wikibase:timeValue ?date_value. # if you don't want date label this should work instead
+      ?qual_prop wikibase:qualifier ?pq;
+              wikibase:propertyType wikibase:Time ; # nb excludes edtf dates
+              rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # what kind of date is it.
+    #  } # /dates
+    # filter 1890-1899
+  FILTER("1890-01-01"^^xsd:dateTime <= ?date && ?date < "1899-12-31"^^xsd:dateTime).
+  # address geocoordinates
+   optional {
+     ?s ?pqq ?geo .
+        ?qual_geo wikibase:qualifier ?pqq;
+                  wikibase:propertyType wikibase:GlobeCoordinate.
+         BIND(geof:longitude(?geo) AS ?long)
+         BIND(geof:latitude(?geo)  AS ?lat)
+             }
+   # todo booth codes
-    BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
 }
-group by ?person ?personLabel ?residenceLabel ?residence ?geo
+ORDER BY ?person ?date
-ORDER BY ?geo
 </sparql>
+=== Where did women who published in Folklore/Folk-lore Record live? ===
-=== BN people and other things located near Devizes ===
 <sparql tryit="1">
-## testing use of geof:distance
+# Map of all places of residence for women who had publications in Folklore/Folk-lore Record
-#title:BN items located within 30 km of Devizes, Wiltshire
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 1,667: / Line 1,746: @@
 PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-#defaultView:Map
-SELECT distinct ?item ?itemLabel ?locationLabel ?location ?wikidata ?wd_geo ?wd_long ?wd_lat
+#defaultView:Map{"hide":["?geo", "?count"]}
+SELECT  ?person ?personLabel ?residenceLabel ?residence ?geo (count( ?person) as ?count)  #(concat(str(?count), " publication") as ?count_lbl)
 WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . # select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?person bnwdt:P76 bnwd:Q419 . # people with publications listed in indexes of archaeological papers. [262]
+  ?person bnp:P76 ?s .
-   {?item bnwdt:P29  ?location . } # resided at location
+   ## works published in P101. folklore / folk-lore record q487 q490
-  #union
+      ?s bnpq:P101 ?in .
-  #{?location bnwdt:P12 bnwd:Q2147 .} # OR location has instance of locality. is there a way to get this in the same structure?
+      {?s bnpq:P101 bnwd:Q487 } union { ?s bnpq:P101 bnwd:Q490 . }
-  union
+      # why does above pick up these two journals as well?
-  {?item bnwdt:P2  ?location . } # item has property P2 location
+      FILTER ( ?in not in ( bnwd:Q665 , bnwd:Q636 ) ) .
-  # any other possibles ?
-   ## limit to places in admin territory p33 england q617. (keep numbers down to avoid wikidata timing out)
+   ?person bnwdt:P29  ?residence .
-  ?location bnwdt:P33+ bnwd:Q617.
+      optional { ?residence bnwdt:P153 ?geo2 .  } # for geocoords added to BN
-  ?location bnwdt:P117 ?ws .  # wikidata id
+   optional {
+       ?residence bnp:P117 ?ws .  # wikidata id P117
+         ?ws bnpq:P14 ?wikidata_url .
+         BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata )
-    bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
+       SERVICE <https://query.wikidata.org/sparql> {
-         SERVICE <https://query.wikidata.org/sparql> {
-             wd:Q1026699 wdt:P625 ?start. # devizes coordinates
+       optional {?wikidata wdt:P625 ?geo1 .  } # geocoords if available
-             ?wikidata wdt:P625 ?wd_geo .
-                      #BIND(geof:longitude(?wd_geo) AS ?wd_long) .
+      } # /wikidata service
-                      #BIND(geof:latitude(?wd_geo)  AS ?wd_lat) .
+    } #/wikidata optional
-              FILTER(geof:distance(?wd_geo, ?start) < 30). # < 30 km from ?start.
-         } # /wikidata service
+    BIND(COALESCE(?geo1, ?geo2) AS ?geo).  # if geo1 available use that, then try geo2
-   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+group by ?person ?personLabel ?residenceLabel ?residence ?geo
+ORDER BY ?geo
+</sparql>
+=== BN people and other things located near Devizes ===
+<sparql tryit="1">
+## testing use of geof:distance
+#title:BN items located within 30 km of Devizes, Wiltshire
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
+PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
+PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
+PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+#defaultView:Map
+SELECT distinct ?item ?itemLabel ?locationLabel ?location ?wikidata ?wd_geo ?wd_long ?wd_lat
+WHERE {
+  {?item bnwdt:P29  ?location . } # resided at location
+  #union
+  #{?location bnwdt:P12 bnwd:Q2147 .} # OR location has instance of locality. is there a way to get this in the same structure?
+  union
+  {?item bnwdt:P2  ?location . } # item has property P2 location
+  # any other possibles ?
+  ## limit to places in admin territory p33 england q617. (keep numbers down to avoid wikidata timing out)
+  ?location bnwdt:P33+ bnwd:Q617.
+  ?location bnwdt:P117 ?ws .  # wikidata id
+    bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
+         SERVICE <https://query.wikidata.org/sparql> {
+             wd:Q1026699 wdt:P625 ?start. # devizes coordinates
+             ?wikidata wdt:P625 ?wd_geo .
+                      #BIND(geof:longitude(?wd_geo) AS ?wd_long) .
+                      #BIND(geof:latitude(?wd_geo)  AS ?wd_lat) .
+              FILTER(geof:distance(?wd_geo, ?start) < 30). # < 30 km from ?start.
+         } # /wikidata service
+   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
 }
 ORDER BY ?locationLabel
@@ Line 1,968: / Line 2,101: @@
 }
 ORDER BY ?locationLabel
+</sparql>
+=== IWD 2024 Map of five women's places ===
+<sparql tryit="1">
+## 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/>
+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{"hide":["?geo"],"layer":"?person", "markercluster":true }
+SELECT distinct ?person ?personLabel  ?propLabel ?placeLabel  ?geo  ?loc2Label (year(?date) as ?year)
+WHERE {
+   VALUES (?person) {(bnwd:Q894) (bnwd:Q462) (bnwd:Q549) (bnwd:Q921) (bnwd:Q1053) }  #
+   ?person ( bnp:P29 | bnp:P94  | bnp:P23 | bnp:P13 | bnp:P120   ) ?s .
+   ?s  ( bnps:P29 | bnps:P94  | bnps:P23 | bnps:P13 | bnps:P120   )  ?place .
+   ?person ?p ?s .
+      ?prop wikibase:claim ?p;
+         wikibase:statementProperty ?ps.
+      optional { ?s ( bnpq:P1 | bnpq:P27 ) ?date . }
+      #optional { ?s bnpq:P31 ?street . }
+  # LOLplaces
+  #1 geocoords in quals for place itself - should be detailed geo added manually, cf London district geocoords which =main P153
+  #2 wikdiata geocoords for place
+  #3 geocoords in quals for linked place
+  #4 wikidata geocoords for linked place
+  #5 wikidata geocoords in place P2 qual
+  #6 `of` qual geocoords
+  #7 `of` P2 wikidata geocoords
+  #8 `of` wikidata geocoords
+  #9 place main geocoords - likely to be broad london postal districts so should be last resort
+  #10 linked place main geocoords
+      optional { ?s bnpq:P153 ?geo1 . } # place has geocoords directly *in qualifier*
+      optional { ?place bnwdt:P2 ?linked_p1 . # linked place has geocoords *in qualifier* (this is primarily for SAL?)
+                     ?linked_p1 bnp:P2 ?llp_s .
+                        ?llp_s bnps:P2 ?llp_p1.
+                        ?llp_s bnpq:P153 ?geo2 .
+                }
+      optional { ?place bnwdt:P117 ?pws .  # place has wikidata page that has geoocords (main P625, not anywhere else)
+                   bind(iri(concat("http://www.wikidata.org/entity/", str(?pws))) as ?pwikidata) .
+                   SERVICE <https://query.wikidata.org/sparql> {
+                     ?pwikidata wdt:P625 ?geo3 .
+                  }
+                }
+      optional { ?place bnwdt:P2 ?linked_p2 .  # linked place has wikidata geocoords
+                    ?linked_p2 bnwdt:P117 ?lws .  # wikidata id P117
+                     bind(iri(concat("http://www.wikidata.org/entity/", str(?lws))) as ?lwikidata) .
+                     SERVICE <https://query.wikidata.org/sparql> {
+                      ?lwikidata wdt:P625 ?geo4 .
+                     }
+                }
+      optional { ?s bnpq:P2 ?qp1 . # P2 qualifier location has wikidata geocoords
+                     ?qp1 bnwdt:P117 ?qws .
+                     bind(iri(concat("http://www.wikidata.org/entity/", str(?qws))) as ?qwikidata) .
+                     SERVICE <https://query.wikidata.org/sparql> {
+                      ?qwikidata wdt:P625 ?geo5 .
+                     }
+                 }
+      optional { ?s bnpq:P78 ?ofp1 . # 'of' (organisation) has geocoords in P2 qualifier
+                    ?ofp1 bnp:P2 ?ofp1_s .
+                     ?ofp1_s bnps:P2 ?ofp1_p .
+                     ?ofp1_s bnpq:P153 ?geo6 . }
+      optional { ?s bnpq:P78 ?ofp2 . # 'of' (organisation) P2 location has wikidata geocoords
+                    ?ofp2 bnwdt:P2 ?ofp2_p .
+                       ?ofp2_p bnwdt:P117 ?ofl2ws .
+                       bind(iri(concat("http://www.wikidata.org/entity/", str(?ofl2ws))) as ?ofl2wikidata) .
+                       SERVICE <https://query.wikidata.org/sparql> {
+                      ?ofl2wikidata wdt:P625 ?geo7 .  }
+              }
+      optional { ?s bnpq:P78 ?ofp3 .   # 'of' (organisation) has wikidata geocoords
+                    ?ofp3 bnwdt:P117 ?ofpws .  # wikidata id P117
+                     bind(iri(concat("http://www.wikidata.org/entity/", str(?ofpws))) as ?ofpwikidata) .
+                     SERVICE <https://query.wikidata.org/sparql> {
+                      ?ofpwikidata wdt:P625 ?geo8 .  }
+                }
+      optional { ?place bnwdt:P153 ?geo9 .  } # main geocoords  (mainly london postal districts - should be last resort as v broad.)
+      optional { ?place bnwdt:P2 ?linked_p10 . # linked place main geocoords
+                     ?linked_p10 bnwdt:P153 ?geo10 .
+                }
+  BIND(COALESCE(?geo1, ?geo2, ?geo3, ?geo4, ?geo5, ?geo6, ?geo7, ?geo8, ?geo9, ?geo10) AS ?geo).  # if geo1 available use that, then geo2, etc, in order of preference
+  bind(coalesce(?linked_p1, ?linked_p2, ?qp1, ?ofp1, ?ofp2, ?ofp3 ) as ?loc2). # hopefully get extra context where place is just sthg like "meeting". though exactly what will be variable!
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". }
+}
+order by ?personLabel ?date ?placeLabel
 </sparql>
@@ Line 3,323: / Line 3,570: @@
 </sparql>
+=== 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/>
+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 ?propLabel ?spsLabel ?qual_propLabel ?pqsLabel ?link ?s
+# ?main_date ?main_precision ?qual_date ?qual_precision
+# ?prop ?sps ?pqs ?pq
+WHERE
+{
+   VALUES (?person) {(bnwd:Q569)}  # add (bnwd:Qxxx) if you want more than one person.
+   ?person ?p ?s .
+     ?prop wikibase:claim ?p;
+         wikibase:statementProperty ?ps;  #  simple value
+         wikibase:statementValue ?psv. #  full value
+   # 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 .
+       }
+    # qualifiers.
+      optional {
+         ?s ?pq ?pqs .
+           ?qual_prop wikibase:qualifier ?pq .
+           ?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". }
+}
+order by ?propLabel ?s
+</sparql>
 ===Working with property paths: organisations and locations===
@@ Line 3,729: / Line 4,042: @@
 </sparql>
-==Admin==
+=== Women having children ===
-===Women about whom we have recorded fewer than 3 pieces of information===
 <sparql tryit="1">
+#title:women having children
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
 PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
@@ Line 3,742: / Line 4,054: @@
 PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?person ?personLabel ?statements WHERE {
+# lol defaultView:Timeline{"hide":["?s", "?date_prec", ""]}
-   ?person bnwdt:P3 bnwd:Q3 ;
-         wikibase:statements ?statements .
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}
-  FILTER (?statements <3)
-  SERVICE wikibase:label {
-      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
-  }
-}
-</sparql>
-===People for whom their item records is given as 'Mrs'===
+# P131 had child in / P45 child
+# a handful of P45 named children don't have dob though probably have dob in wikidata
-<sparql tryit="1">
+SELECT distinct ?person ?personLabel ?childLabel ?date_value ?date_prec ?had_child_edtf ?note
-SELECT ?id ?name
+?s
-WHERE {
-  ?id rdfs:label ?name .
-  FILTER regex(?name, "mrs *", "i") #this line uses regular expression syntax, described at https://regexper.com/#mrs%5Cs*
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-</sparql>
-===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===
-<sparql tryit="1">
-#defaultView:Graph
-SELECT ?a ?aLabel ?c ?cLabel WHERE {
-    ?a ?b ?c
-    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-#note query returns every connection in the wikibase so it may fall over!
-</sparql>
-===People whose assigned gender we have been unable to determine and/or confirm===
-<sparql tryit="1">
-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 ?gender .
-  FILTER NOT EXISTS {?person bnwdt:P3 bnwd:Q3 .}          #filter out people identified as women
-  FILTER NOT EXISTS {?person bnwdt:P3 bnwd:Q10 .}          #filter out people identified as men
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-ORDER BY ?personLabel
-</sparql>
-===People who have a spouse statement and - optionally - marriage date statements for checking if there is any misalignment with 'Spouse not in wikibase' statements===
-<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
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?person ?personLabel ?spouse ?spouseLabel ?edtfmarriagespouse ?edtfmarriagespouseLabel ?PITmarriagespouse ?PITmarriagespouseLabel WHERE {
-  ?person bnwdt:P41 ?spouse .
-  OPTIONAL {?person bnp:P132 ?edtfmarriagestatement .
-  ?edtfmarriagestatement bnps:P132 ?edtfmarriagedate .
-  ?edtfmarriagestatement bnpq:P41 ?edtfmarriagespouse .}
-  OPTIONAL {?person bnp:P130 ?PITmarriagestatement .
-  ?PITmarriagestatement bnps:P130 ?PITmarriagedate .
-  ?PITmarriagestatement bnpq:P41 ?PITmarriagespouse .}
-    SERVICE wikibase:label {
-      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
-    }
-}
-ORDER BY DESC(?edtfmarriagespouseLabel) DESC(?PITmarriagespouseLabel)
-</sparql>
-=== Compare uses of item v free text ===
-<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.
-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 ?itemLabel ?prop_label ?qual_label ?qual_value ?qual_valueLabel ?item ?qual_prop
-# most of these are used in qualifiers - only P72, P71 and P88 found in main (and only a handful of uses of free text?)
-#?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
-</sparql>
-=== Missing language labels ===
-<sparql tryit="1">
-# query to check for any items/properties which don't have "en" labels. [currently not an issue but retained for reference.]
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-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
-  ?item  ?itemLabel
-  (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
-  #optional { ?item rdfs:label ?engb . filter(lang(?engb)="en-gb").  }
-  #optional { ?item rdfs:label ?en . filter(lang(?en)="en").  }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en-gb, en". }
-}
-group by ?item  ?itemLabel
-HAVING (?count<2)
-order by ?item
-</sparql>
-=== Statements that contain both a date *and* an unknown value date===
-<sparql tryit="1">
-# A query to look for statements containing an <unknown value> date *and* a date
-# caveat: not yet completely sure if it will work in all cases for main dates
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-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 ?main_label ?qualLabel ?subLabel
-(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
-{
-  {
-   # 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 ;
-             wikibase:propertyType ?date_prop_type .
-    filter(?date_prop_type in (wikibase:Time, wikibase:Edtf) ).
-  }
-  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
-having (?tcount >1 )  # comment out to get everything
-ORDER BY ?itemLabel ?main_label ?qualLabel ?subLabel ?date_prop
-</sparql>
-=== Women with no dates===
-<sparql tryit="1">
-# Query for women with no dates
-# WIP: at present this includes <unknown value> dates as well as no dates at all [eg Miss Keyser Q2622]
-# CAVEAT: the WQS bug means there are likely to be some women in results who do, in fact, have at least one date.
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-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  (count(?date_value) as ?count)
-WHERE {
- {  # main dates
-   ?person bnwdt:P3 bnwd:Q3 . # women
-  optional {
-    ?person ?p ?s .
-      ?s ?date_prop ?wdv .
-        ?wdv wikibase:timeValue ?date_value . }
- } # /main dates
-  UNION
-  { # qualifier dates
-    ?person bnwdt:P3 bnwd:Q3 .
-   optional {
-     ?person ?p ?s .
-      ?s ?date_prop ?pqv .
-        ?pqv wikibase:timeValue ?date_value. }
-  }  # /qual dates
- SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
-} # /where
-group by ?person ?personLabel
-having (?count=0)
-ORDER BY ?person
-</sparql>
-=== Women with more than X statements but no date of birth/death===
-<sparql tryit="1">
-#title:women with n>X statements but no date of birth/death
-# CAVEAT this currently finds some women who do in fact have dates, because of WQS bug
-# updated to add extra info
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?person ?personLabel ?statements ?dob ?dod
-(if(bound(?SALproposed), "yes", "") as ?FSA)
-(if(bound(?RAIproposed), "yes", "") as ?RAI)
-(if(bound(?resided), "yes", "") as ?residence)
-(if(bound(?main_date), "yes", "") as ?other_maindate)
-(if(bound(?qual_d), "yes", "") as ?qual_date)
-WHERE {
-   ?person bnwdt:P3 bnwd:Q3 ;
-         wikibase:statements ?statements .
-  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}
-  optional { ?person bnwdt:P15 ?dod .   }
-  optional { ?person bnwdt:P26 ?dob .   }
-   optional { # was elected FSA. comment out optional lines to get FSAs only...
-     ?person bnp:P16 ?s .
-        ?s bnps:P16 ?SALproposed .
-        ?s bnpq:P22 bnwd:Q36 .   # successful Q36. will you end up with 2 rows if there's a successful and unsuccessful?
-  } #/optional fsa
-  optional { # was elected RAI. only one unsuccessful, so just ignore that bit.
-    ?person bnwdt:P7 ?RAIproposed .
-  }
-  optional { ?person bnwdt:P29 ?resided . } # place of residence
-  optional {
-    # main dates, apart from birth and death: P133 (widowed) P132 (married edtf) P131 (had child) P130 (married pit)
-     ?person ( bnwdt:P130 | bnwdt:P131 | bnwdt:P132 | bnwdt:P133 ) ?main_date .
-    } # /optional main dates
-  optional {
-     # qualifier dates
-    ?person ?p ?s .
-      ?s ?date_prop ?pqv .
-         ?pqv wikibase:timeValue ?qual_d.
-    } #/ optional qual dates
-  FILTER (?statements >10) . # can adjust n statements here...
-  FILTER (NOT EXISTS { ?person bnwdt:P15 ?dod .} || NOT EXISTS { ?person bnwdt:P26 ?dob .  } ) . # EITHER no date of birth OR no date of death. or swap with following line...
-  #FILTER (NOT EXISTS { ?person bnwdt:P15 ?dod .} && NOT EXISTS { ?person bnwdt:P26 ?dob .  } ) . # no date of birth AND no date of death
-  SERVICE wikibase:label {
-      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
-  }
-}
-order by ?personLabel
-</sparql>
-=== Places of residence that lack instance of locality===
-<sparql tryit="1">
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?residence ?residenceLabel ?inst ?instLabel
-WHERE {
-  ?resident bnwdt:P29 ?residence . # resided at
-   filter not exists { ?residence bnwdt:P12 bnwd:Q2147 . } # that doesn't have instance of locality
-   optional {?residence bnwdt:P12 ?inst .} # does it have instance of anything?
-      ## Note: some have Q618 territory of the British Empire, which also lacks any instance of at present
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-ORDER BY ?residenceLabel
-</sparql>
-=== Locations that don't have Wikidata links or their Wikidata pages lack geocoordinates===
-<sparql tryit="1">
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?locationLabel ?location ?wikidata ?wd_geo ?instanceLabel ?bn_geo
-WHERE {
-  {?item bnwdt:P29  ?location . } # resided at
-  union
-  {?location bnwdt:P12 bnwd:Q2147 .} # OR has instance of locality
-  union
-  {?item bnwdt:P2  ?location . } # OR location P2
-  # any other possibles ?
-  optional { ?location bnwdt:P12 ?instance .  } # check instance of
-   optional {
-       ?location bnwdt:P117 ?ws .  # wikidata id
-         bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
-         SERVICE <https://query.wikidata.org/sparql> {
-           optional {?wikidata wdt:P625 ?wd_geo .}   # does the wikidata page have geocoords?
-         } # /wikidata service
-    } #/wikidata optional
-  filter (!bound(?wd_geo) ). # no geocoords in wikidata. some may have coords in BN...
-  optional { ?location bnwdt:P153 ?bn_geo .  } # so check for coords in BN
-  ##filter (!bound(?bn_geo)) . # uncomment to filter those out as well
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-ORDER BY ?wikidata ?locationLabel
-</sparql>
-=== Archaeological sites that don't have National Heritage England list numbers ===
-<sparql tryit="1">
-#title:archaeological sites without National Heritage numbers
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT ?item ?itemLabel ?location ?locationLabel
-(if(bound(?locEngland), "yes", "") as ?inEngland)
-WHERE {
-  ?item bnwdt:P12 bnwd:Q86 . # item instance of archaeological site
-  filter not exists {?item bnwdt:P129 ?thing .  } # without NH list number
-  optional { ?item bnwdt:P2 ?location .  } # location if it has one
-  optional { ?item bnwdt:P2 ?locEngland .
-               ?locEngland bnwdt:P33+ bnwd:Q617.
-           } # is the location in England
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-order by ?itemLabel
-</sparql>
-=== Date of latest edit for every item, according to WQS ===
-<sparql tryit="1">
-#title:latest edits dates for wikibase items
-## because of WQS disappearing data bugs this may not always match the latest edit in the page history
-SELECT ?item ?date ?dateLabel
-WHERE {
-   ?item wikibase:timestamp ?date .
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-order by ?date
-</sparql>
-=== Wikidata ID is a URL ===
-<sparql tryit="1">
-#title:check for accidental use of URL instead of wikidata ID
-## all checked and fixed at 18/12/23 but adding the query in case it recurs
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?item ?itemLabel ?wd_http
-WHERE {
-  ?item bnwdt:P117 ?wd_http .  # wikidata id
-  filter(strstarts(str(?wd_http), "http")).
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-ORDER BY ?itemLabel
-</sparql>
-=== Wikidata URL is not a URL ===
-<sparql tryit="1">
-#title:check for wikidata URLs that don't start with http. could still be other problems!
-## all checked and fixed at 18/12/23 but adding the query in case of any recurring issues
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?item ?itemLabel ?wd_url
-WHERE {
-  ?item bnp:P117 ?ws .  # wikidata id
-     ?ws bnpq:P14 ?wd_url .
-  filter(!strstarts(str(?wd_url), "http")).
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-ORDER BY ?itemLabel
-</sparql>
-=== Oxford and Cambridge academic degrees potential date problems ===
-<sparql tryit="1">
-#title:academic degree Oxford/Cambridge date issues
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT distinct ?personLabel ?degreeLabel ?byLabel ?subjectLabel
-?date ?date_label  ?s ?person #?subject ?degree ?by ?university
-WHERE {
-  ?person bnwdt:P3 bnwd:Q3 . #select women
-  # academic degree = P59.
-  ?person bnp:P59 ?s .
-    ?s bnps:P59 ?degree . # type of degree
-  # optional qualifiers for degree
-  # P60 subject
-    optional { ?s bnpq:P60 ?subject}
-  # P61 conferred by
-    ?s bnpq:P61 ?by .
-  # date with type
-    ?s ?pq ?date .
-      ?qual_prop wikibase:qualifier ?pq;
-              wikibase:propertyType wikibase:Time ; # nb excludes edtf dates
-              rdfs:label ?date_label . filter(lang(?date_label)="en") . # what kind of date is it.
- # filter: (cambridge (Q1181) and before 1948) OR (oxford (Q364) and before 1920)
-  filter( ( year(?date)<1920 && ?by=bnwd:Q364 ) || ( year(?date)<1948 && ?by=bnwd:Q1181 ) )
-  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".}
-}
-order by ?byLabel ?personLabel ?date ?degreeLabel
-</sparql>
-=== Position held: item v free text ===
-<sparql tryit="1">
-# held position job titles item v held position free text
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT
-?work_label  ?positionLabel ?position (count(*) as ?count)
-WHERE {
-  ?person bnwdt:P3 bnwd:Q3 . # women
-  # get work activities: held position / held position (free text) /  employed as
-  ?person ( bnp:P17|bnp:P48 ) ?s .
-  ?person ?work_p ?s . # for work type label
-  ?work wikibase:claim ?work_p;
-         rdfs:label ?work_label. filter(lang(?work_label)="en") .
-    # more about the position
-    ?s ( bnps:P17|bnps:P48 ) ?position .
-  FILTER( !isBLANK(?position)  ) . # filter out <unknown value>
- SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-group by ?work_label  ?positionLabel ?position
-order by lcase(str(?positionLabel))
-</sparql>
-==== Women with position held free text ====
-<sparql tryit="1">
-# held position free text job titles
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
-PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
-SELECT ?person ?personLabel ?positionLabel
-WHERE {
-  ?person bnwdt:P3 bnwd:Q3 . # women
-  # held position (free text)
-  ?person bnwdt:P48  ?position .
- SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
-order by ?personLabel ?positionLabel
-</sparql>
-==Tools for batch processing and quality assurance work==
-===All people (by assigned gender), filtering out those already listed as instance of human===
-<sparql tryit="1">
-# All people (by assigned gender), filtering out those already listed as instance of human
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX wdt: <http://www.wikidata.org/prop/direct/>
-PREFIX wd:  <http://www.wikidata.org/entity/>
-SELECT ?person ?personLabel ?assigned_genderLabel
-WHERE {
-  ?person bnwdt:P3 ?assigned_gender .                        #select person
-  FILTER NOT EXISTS {?person bnwdt:P12 bnwd:Q2137 .}         #filter out people already listed as instance of human
-  FILTER NOT EXISTS {?person bnwdt:P12 bnwd:Q12 .}            #filter out project team
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-ORDER BY ?personLabel
-</sparql>
-===All places (by coordinate location on wikidata), filtering out places already listed as instance of locality===
-<sparql tryit="1">
-# All places (by coordinate location on wikidata), filtering out places already listed as instance of locality
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-PREFIX wdt: <http://www.wikidata.org/prop/direct/>
-PREFIX wd:  <http://www.wikidata.org/entity/>
-PREFIX p: <http://www.wikidata.org/prop/>
-PREFIX pr: <http://www.wikidata.org/prop/reference/>
-PREFIX prov: <http://www.w3.org/ns/prov#>
-SELECT ?place ?placeLabel ?WDitem ?WDcoordinate_location
-WHERE {
-  ?place bnwdt:P33 ?admin_area .  #select items with 'located in the administrative territorial entity' statements
-  ?place bnwdt:P117 ?Qnumber .    #get wikidata ID
-  FILTER NOT EXISTS {?place bnwdt:P12 bnwd:Q2147 .}       #filter out places already listed as instance of locality
-  #create reference to Wikibase entity
-  BIND(IRI(concat("http://www.wikidata.org/entity/", ?Qnumber)) as ?WDitem )
-  #on Wikibase do
-  SERVICE <https://query.wikidata.org/sparql> {
-        ?WDitem wdt:P625 ?WDcoordinate_location . #get coordinate location on wikidata
-      }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
-}
-GROUP BY ?place ?placeLabel ?WDitem ?WDcoordinate_location
-ORDER BY ?placeLabel
-</sparql>
-===All items without a P12 (instance of) triple===
-<sparql tryit="1">
-#title:nearly all items without P12 (instance of)
-#NB: the query will only find items that have at least one statement; this excludes a small number of Qs and a larger number (~35) of Ps.
-#see separate query to find items without any statements
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
-PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
-PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
-PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
-PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
-PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
-SELECT distinct ?item ?itemLabel
-WHERE {
-   ?item ?b ?c .
-       ?prop wikibase:claim ?b;
-             wikibase:statementProperty ?ps.
-      # ?prop wikibase:propertyType wikibase:WikibaseItem. # limit to P & Q Items. not necessary; only the claim is needed.
-      # weirdness: it still causes some things that are definitely WikibaseItem to be dropped and idk why.
-  FILTER NOT EXISTS {?item bnwdt:P12 ?instance .}
-## FILTER(STRSTARTS(STR(?item), "https://beyond-notability.wikibase.cloud/entity/P")) . # uncomment to limit to P Properties
+where {
-## FILTER(STRSTARTS(STR(?item), "https://beyond-notability.wikibase.cloud/entity/Q")) .  # or limit to Q items
-   SERVICE wikibase:label {
+   ?person bnwdt:P3 bnwd:Q3 . # select women
-      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb".
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
-   }
-}
+{
-</sparql>
+  # 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.
-===Counts of items for each value of the property "instance of" (P12)===
+  # get dates detail via ?s and psv
+  # gets edtf dates in std wiki date format
-<sparql tryit="1">
+  # https://github.com/ProfessionalWiki/WikibaseEdtf
+      ?s ?psv ?wdv .
-PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+        ?wdv wikibase:timeValue ?date_value .
-PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+        ?wdv wikibase:timePrecision ?date_prec .
-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.
+   # filter edtf date.
+   FILTER ( datatype(?had_child_edtf) = xsd:edtf ) . #shows only the raw EDTF string from the query results
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
-}
+  # 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)
-GROUP BY ?value ?valueLabel
+  #?person bnwdt:P131 ?had_child .
+   # not much added in quals for had child. only maybe note P47. some have sourcing circumstances.
+   optional { ?s bnpq:P47 ?note .  } #
-ORDER BY lcase(?valueLabel) # order by is case sensitive
+   }
-# or to order by count
+   union
-# 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
+  # named children (are any in both sections??? from dates looks possible a couple might be [wherry / hodgson])
-  ?item ?p ?s.
+   ?person bnp:P45 ?s.
-  ?s ?ps ?t .
+        ?s bnps:P45 ?child .
+      optional { ?child bnp:P26 ?ss .
-  ?unknown_value_for wikibase:claim ?p.
+                    ?ss bnps:P26 ?dob .
-  ?unknown_value_for wikibase:statementProperty ?ps.
+                     ?ss ?psv ?wdv .
+                        ?wdv wikibase:timeValue ?date_value .
-  FILTER( isBLANK(?t) ) .
+                        ?wdv wikibase:timePrecision ?date_prec .
+               }
    }
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
+    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
-WHERE {
-   ?item wikibase:statements 0 .
-  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+order by ?person ?date_value
-}
-order by ?item
 </sparql>

Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

Revision as of 14:30, 9 April 2024