727
edits
(42 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
[[Project:SPARQL/admin | Admin/batch tools queries]] | |||
==SAL and RAI== | ==SAL and RAI== | ||
Line 168: | Line 170: | ||
</sparql> | </sparql> | ||
=== Women's interactions with SAL (Q1 and Q8)=== | === Women's interactions with SAL (Q1 and Q8)=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title:Women's interactions with SAL (Q1 and Q8) | |||
# CAVEAT: this query may overlook a significant number of interactions and should probably not be reference/archived in its current state | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 213: | Line 184: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT distinct ?person ?personLabel | SELECT distinct ?person ?personLabel ?propLabel ?qual_value ?qual_propLabel ?bnwdLabel # ?s ?prop ?qual_prop ?bnwd | ||
WHERE { | WHERE { | ||
Line 223: | Line 192: | ||
?prop wikibase:claim ?p; | ?prop wikibase:claim ?p; | ||
wikibase:statementProperty ?ps | wikibase:statementProperty ?ps. | ||
# union query to get both q8 and q1 | # union query to get both q8 and q1 | ||
{ ?s ?ps bnwd:Q8 . } union { ?s ?ps bnwd:Q1 . } | { ?s ?ps bnwd:Q8 . } union { ?s ?ps bnwd:Q1 . } | ||
?s ?ps ? | ?s ?ps ?bnwd. #which type | ||
optional { | |||
?s ?pq ? | ?s ?pq ?qual_value . | ||
?qual_prop wikibase:qualifier ?pq . | ?qual_prop wikibase:qualifier ?pq . | ||
} # /qualifiers | } # /qualifiers | ||
Line 248: | Line 213: | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title:Women's interactions with RAI (Q35 and Q29) | |||
# CAVEAT: this query may overlook a significant number of interactions and should probably not be reference/archived in its current state | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 255: | Line 222: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT distinct ?person ?personLabel | SELECT distinct ?person ?personLabel ?propLabel ?qual_value ?qual_propLabel ?bnwdLabel # ?s ?prop ?qual_prop | ||
WHERE { | WHERE { | ||
Line 265: | Line 230: | ||
?prop wikibase:claim ?p; | ?prop wikibase:claim ?p; | ||
wikibase:statementProperty ?ps | wikibase:statementProperty ?ps. | ||
# to get both q35 and q29 | # to get both q35 and q29 | ||
{ ?s ?ps bnwd:Q35 . } union { ?s ?ps bnwd:Q29 . } | { ?s ?ps bnwd:Q35 . } union { ?s ?ps bnwd:Q29 . } | ||
?s ?ps ? | ?s ?ps ?bnwd. | ||
# qualifiers. | # qualifiers. | ||
optional { | optional { | ||
?s ?pq ? | ?s ?pq ?qual_value . | ||
?qual_prop wikibase:qualifier ?pq . | ?qual_prop wikibase:qualifier ?pq . | ||
} # /qualifiers | } # /qualifiers | ||
Line 294: | Line 255: | ||
#title: FSAs with no record of interacting with SAL in Q1 / Q8 | #title: FSAs with no record of interacting with SAL in Q1 / Q8 | ||
# only active engagements like spoke at, corresponded with, etc, and excluding P75 "was fellow of" and P5 "archives at". | # only active engagements like spoke at, corresponded with, etc, and excluding P75 "was fellow of" and P5 "archives at". | ||
# | # CAVEATS: I think this is not working as intended and it shouldn't be referenced or archived | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 342: | Line 303: | ||
#title: RAIs with no record of interacting with RAI in Q29/Q35 | #title: RAIs with no record of interacting with RAI in Q29/Q35 | ||
# only active engagements like spoke at, corresponded with, etc, and excluding P67 "was member of" | # only active engagements like spoke at, corresponded with, etc, and excluding P67 "was member of" | ||
# | # CAVEATS: I think this may not be working as intended and it shouldn't be referenced or archived in its current state | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 453: | Line 414: | ||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | ||
SELECT distinct ?personLabel ?workLabel ?positionLabel ? | SELECT distinct ?personLabel ?workLabel ?positionLabel ?date_propLabel ?date | ||
?employerLabel ?organisedLabel ?ofLabel ?person | ?employerLabel ?organisedLabel ?ofLabel ?locationLabel ?person | ||
#?s ?position ?of ?work ?employer ?organised | #?s ?position ?of ?work ?employer ?organised ?location ?date_prop | ||
WHERE { | WHERE { | ||
Line 469: | Line 430: | ||
# more about the position | # more about the position | ||
?s ( bnps:P17|bnps:P48|bnps:P105 ) ?position . | ?s ( bnps:P17|bnps:P48|bnps:P105 ) ?position . | ||
# employer / organised by / of (incl free text) | # employer / organised by / of (incl free text). | ||
# for position held, employer>of [ontology day discussion 13/9/23] | # for position held, employer>of [ontology day discussion 13/9/23] | ||
OPTIONAL { ?s bnpq:P18 ?employer .} | OPTIONAL { ?s bnpq:P18 ?employer .} | ||
Line 475: | Line 436: | ||
OPTIONAL { ?s ( bnpq:P78 | bnpq:P66 ) ?of .} | OPTIONAL { ?s ( bnpq:P78 | bnpq:P66 ) ?of .} | ||
optional { ?s bnpq:P2 ?location . } | |||
# dates | # dates with property labels. | ||
optional { | optional { | ||
?s ?pq ?date . | ?s ?pq ?date . | ||
?date_prop wikibase:qualifier ?pq; | |||
? | wikibase:propertyType wikibase:Time . | ||
wikibase:propertyType wikibase:Time | |||
} # /dates | } # /dates | ||
Line 552: | Line 510: | ||
</sparql> | </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> | |||
=== | === Excavations === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title:BN excavations | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 567: | Line 584: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ?excavationLabel ?excavation ?locationLabel ?start ?end ?pit | |||
?partLabel ?funderLabel ?organisedLabel ?facilitatedLabel ?directorLabel ?memberLabel | |||
# ?member ?director ?location ?part ?funder ?facilitated ?organised | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | # instance of excavation 128 | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ?excavation bnwdt:P12 bnwd:Q38 . | ||
optional { ?excavation bnwdt:P2 ?location .} | |||
optional { ?excavation bnwdt:P27 ?start . } | |||
optional { ?excavation bnwdt:P28 ?end . } | |||
optional { ?excavation bnwdt:P1 ?pit. } | |||
optional { ?excavation bnwdt:P4 ?part . } | |||
optional { ?excavation bnwdt:P36 ?director . } | |||
optional { ?excavation bnwdt:P37 ?member . } | |||
optional { ?excavation bnwdt:P109 ?organised .} | |||
optional { ?excavation bnwdt:P121 ?facilitated . } | |||
optional { ?excavation bnwdt:P145 ?funder . } | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | |||
ORDER BY ?excavationLabel | |||
</sparql> | |||
== Professional Activities and Organisations == | |||
=== Women's service on committees etc (P102) === | |||
<sparql tryit="1"> | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | |||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | |||
PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/> | |||
PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> | |||
PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/> | |||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | |||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | |||
SELECT distinct ?personLabel ?serviceLabel ?qual_propLabel ?qualLabel ?qual ?person ?s # ?service | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . # select women | |||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | |||
?person bnp:P102 ?s . # served on P102 | ?person bnp:P102 ?s . # served on P102 | ||
?s bnps:P102 ?service . | |||
optional { #qualifiers, if any | optional { #qualifiers, if any | ||
Line 757: | Line 816: | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title:ppa buckets (revised February 2024) | #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 bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 773: | Line 834: | ||
?ppa wikibase:claim ?p; | ?ppa wikibase:claim ?p; | ||
wikibase:statementProperty ?ps. | 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". | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". | ||
?ppa rdfs:label ?ppa_label. | ?ppa rdfs:label ?ppa_label. | ||
} # /label service | } # /label service | ||
Line 784: | Line 847: | ||
?s ?ps ?ppa_value. | ?s ?ps ?ppa_value. | ||
# note: it would be possible to write this to use ppa rather than ppa_label. there's a slight risk that property names might change. | |||
# BUT then it would be much more opaque and difficult to edit if (when!) we make any changes to the buckets. | |||
bind( | bind( | ||
if( str(?ppa_label) in ("attended", "exhibited at", "organiser of", "performed at", "spoke at", "was delegate at (free text)", "was delegate at (item)" ), "events", | if( str(?ppa_label) in ("attended", "exhibited at", "organiser of", "performed at", "spoke at", "was delegate at (free text)", "was delegate at (item)" ), "events", | ||
Line 806: | Line 870: | ||
</sparql> | </sparql> | ||
== | === Suffrage-related activities === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | #title:initial query for suffrage activities | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 821: | Line 883: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
# | SELECT distinct ?person ?personLabel ?mainLabel ?sub_Label ?qualLabel ?locationLabel ?date | ||
# ?pq ?sub_ ?qual ?main | |||
?s | |||
WHERE { | WHERE { | ||
?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. | |||
} | |||
# what about a main rather than qualifier having i/o suffrage activity? i don't think there are any atm but could be. | |||
# union | |||
# { # this might find extra linked i/o suffrage but i'm not sure it works. | |||
# ?sub_ bnwdt:P12 bnwd:Q1166 . | |||
# } | |||
union | |||
{ | |||
# does *not* have i/o suffrage activity in any qualifiers ... 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". } | |||
} | } | ||
order by ?personLabel ?mainLabel | |||
</sparql> | </sparql> | ||
=== | ==Place== | ||
=== All the things in BN that can be mapped === | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | #title:map of BN locations using wikidata P625 | ||
#defaultView:Map | |||
#this will take a little while to run... | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 880: | Line 957: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ? | SELECT distinct ?locationLabel ?location ?wikidata ?wd_geo | ||
WHERE { | WHERE { | ||
? | |||
?location bnwdt:P117 ?ws . # wikidata id | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?wikidata wdt:P625 ?wd_geo . # does the wikidata page have geocoords? | |||
} # /wikidata service | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | } | ||
ORDER BY ? | ORDER BY ?wikidata ?locationLabel | ||
</sparql> | </sparql> | ||
===People not in London | ===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"> | <sparql tryit="1"> | ||
# People not in London | # 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/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 907: | Line 986: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ?resident ?residentLabel | #defaultView:Graph | ||
SELECT ?resident ?residentLabel ?region ?regionLabel | |||
WHERE { | WHERE { | ||
?resident bnwdt:P29 ?residence . | ?resident bnwdt:P29 ?residence . | ||
Line 925: | Line 1,005: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
</sparql> | </sparql> | ||
===People | ===People whose residence was at one time in the east or south east of England, excluding London=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
Line 939: | Line 1,018: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ? | SELECT ?resident ?residentLabel ?residenceLabel ?districtLabel ?countyLabel ?regionLabel | ||
WHERE { | |||
?resident bnwdt:P29 ?residence . | |||
?residence bnwdt:P33 ?district . | |||
?district bnwdt:P33 ?county . | |||
SERVICE wikibase:label { | ?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 | |||
</sparql> | </sparql> | ||
=== | ===People whose residence was at one time in North East England or Yorkshire and the Humber=== | ||
<sparql tryit="1"> | <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 bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 964: | Line 1,045: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ? | SELECT ?resident ?residentLabel ?residenceLabel ?districtLabel ?countyLabel ?regionLabel | ||
WHERE { | WHERE { | ||
? | ?resident bnwdt:P29 ?residence . | ||
?residence bnwdt:P33 ?district . | |||
?district bnwdt:P33 ?county . | |||
?county bnwdt:P33 ?region . | |||
{?county bnwdt:P33 bnwd:Q72 .} | |||
UNION | |||
{?county bnwdt:P33 bnwd:Q200 .} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residenceLabel | |||
</sparql> | </sparql> | ||
=== | ===People not in London with the district, county, and region at which they were once resident (in the UK) listed=== | ||
<sparql tryit="1"> | <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 bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 988: | Line 1,072: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ?district ?districtLabel | SELECT ?resident ?residentLabel ?district ?districtLabel ?county ?countyLabel ?region ?regionLabel | ||
WHERE { | WHERE { | ||
? | ?resident bnwdt:P29 ?residence . | ||
FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2035 .} | |||
FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q2036 .} | |||
?residence bnwdt:P33 ?district . | 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". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residentLabel | |||
</sparql> | </sparql> | ||
=== | ===People sorted by the number of places they lived, including the number of cites/towns/villages they lived in=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 1,013: | Line 1,104: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ? | SELECT ?person ?personLabel (count(?resided) as ?residence_count) (count(distinct ?resided) as ?residence_distinct) WHERE { | ||
WHERE { | ?person bnwdt:P3 bnwd:Q3 ; | ||
wikibase:statements ?statements . | |||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person | ?person bnp:P29/bnps:P29 ?resided. | ||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | } | ||
} | } group by ?person ?personLabel ?statements order by desc(?residence_count) | ||
# Credit to @Tagishsimon for helping me figure out the counting logic here | |||
</sparql> | </sparql> | ||
=== | ===Places at which women resided, sorted by how many residences all women had at a given village/town/city/London area=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | # 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/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 1,039: | Line 1,129: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ? | SELECT ?residence ?residenceLabel (count(?residence) as ?residence_count) #count number of places at which women lived | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt:P29 ?residence . # select residences | ?person bnwdt:P29 ?residence . # select residences | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
GROUP BY ? | GROUP BY ?residence ?residenceLabel | ||
ORDER BY DESC(? | ORDER BY DESC(?residence_count) | ||
</sparql> | </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)=== | ||
<sparql tryit="1"> | <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 bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 1,066: | Line 1,153: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ? | SELECT ?district ?districtLabel (count(?district) as ?district_count) #count number of districts in which women lived | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt:P29 ?residence . # select residences | ?person bnwdt:P29 ?residence . # select residences | ||
?residence bnwdt:P33 ?district . #select districts | ?residence bnwdt:P33 ?district . #select districts | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
GROUP BY ? | GROUP BY ?district ?districtLabel | ||
ORDER BY DESC(? | ORDER BY DESC(?district_count) | ||
</sparql> | </sparql> | ||
===Counties in which women resided, sorted by how many residences all women had in that county=== | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# Counties | # Counties in which women resided, sorted by how many residences all women had in that county | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 1,096: | Line 1,181: | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt:P29 ?residence . # select residences | ?person bnwdt:P29 ?residence . # select residences | ||
Line 1,107: | Line 1,191: | ||
</sparql> | </sparql> | ||
====Counties of residence for women | ====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"> | <sparql tryit="1"> | ||
# Counties of residence for women | # 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/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 1,123: | Line 1,207: | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
?person bnwdt: | ?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 | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt:P29 ?residence . # select residences | ?person bnwdt:P29 ?residence . # select residences | ||
Line 1,134: | Line 1,218: | ||
</sparql> | </sparql> | ||
====Counties of residence for women | ====Counties of residence for women nominated as FSAs, sorted by how many residences all women had in that county==== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# Counties of residence for women | # Counties of residence for women nominated as FSAs, sorted by how many residences all women had in that county | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 1,150: | Line 1,234: | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
?person bnwdt: | ?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 | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt:P29 ?residence . # select residences | ?person bnwdt:P29 ?residence . # select residences | ||
Line 1,161: | Line 1,245: | ||
</sparql> | </sparql> | ||
====Counties of residence for women | ====Counties of residence for women nominated to RAI, sorted by how many residences all women had in that county==== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# Counties of residence for women nominated to RAI, sorted by how many residences all women had in that county | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 1,173: | Line 1,258: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | 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 | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
?person bnwdt: | ?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 | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt:P29 ?residence . # select residences | ?person bnwdt:P29 ?residence . # select residences | ||
?residence bnwdt:P33 ?district . #select districts | ?residence bnwdt:P33 ?district . #select districts | ||
?district bnwdt:P33 ?county . #select counties | ?district bnwdt:P33 ?county . #select counties | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
GROUP BY ?county ?countyLabel | |||
ORDER BY DESC(?county_count) | |||
</sparql> | |||
====Counties of residence for women who spoke at RAI meetings, sorted by how many residences all women had in that county==== | |||
====Counties of residence for women | |||
<sparql tryit="1"> | <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/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 1,219: | Line 1,285: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | 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 | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
?person bnwdt: | ?person bnwdt:P23 bnwd:Q29 . #select women who spoke at RAI Meeting | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt:P29 ?residence . # select residences | ?person bnwdt:P29 ?residence . # select residences | ||
?residence bnwdt:P33 ?district . #select districts | ?residence bnwdt:P33 ?district . #select districts | ||
?district bnwdt:P33 ?county . #select counties | ?district bnwdt:P33 ?county . #select counties | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
GROUP BY ?county ?countyLabel | |||
ORDER BY DESC(?county_count) | |||
</sparql> | |||
====Counties of residence for women who exhibited at RAI meetings, sorted by how many residences all women had in that county==== | |||
<sparql tryit="1"> | |||
# Counties of residence for women who exhibited at RAI meetings, sorted by how many residences all women had in that county | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | |||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | |||
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 ?county ?countyLabel (count(?county) as ?county_count) #count number of counties in which women lived | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . # select women | |||
?person bnwdt:P13 bnwd:Q29 . #select women who exhibited at RAI Meeting | |||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | |||
?person bnwdt:P29 ?residence . # select residences | |||
?residence bnwdt:P33 ?district . #select districts | |||
?district bnwdt:P33 ?county . #select counties | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
GROUP BY ?county ?countyLabel | |||
ORDER BY DESC(?county_count) | |||
</sparql> | </sparql> | ||
====Counties of residence for women recorded in CAS Indexes of Archaeological Papers, on a map==== | |||
= | <sparql tryit="1"> | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 1,263: | Line 1,339: | ||
#defaultView:Map{"hide":["?geo", "?wikidata"]} | #defaultView:Map{"hide":["?geo", "?wikidata"]} | ||
#title:Counties of residence for women | #title:Counties of residence for women recorded in CAS Indexes of Archaeological Papers | ||
SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo | SELECT distinct ?person ?personLabel ?residence ?residenceLabel ?county ?countyLabel ?wikidata ?geo | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?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 | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt: | ?person bnwdt:P29 ?residence . # select residences | ||
?residence bnwdt:P33 ?district . #select p33 of residence | |||
?residence bnwdt:P33 ?district . #select | ?district bnwdt:P33 ?next . #select p33 of district, mostly counties but a few region/outside uk | ||
?district bnwdt:P33 ? | |||
optional { | optional { | ||
# is ?next a uk region? | |||
?next bnwdt:P12 bnwd:Q4207 . | |||
BIND(BOUND(?next) AS ?region). | |||
} | |||
optional { | |||
# is ?next in the UK? | |||
?next bnwdt:P33* bnwd:Q1741 . | |||
BIND(BOUND(?next) AS ?uk). | |||
} | |||
# if next=q4207 uk region, then use ?district for county, ifelse in uk use ?next, else not in uk use ?district. | |||
bind( | |||
if( bound(?region), ?district, # region first (because also uk) | |||
if( bound(?uk), ?next, # then rest of uk | |||
?district)) # then anything not in uk. | |||
as ?county). | |||
optional { ?county bnwdt:P153 ?geo2 . } # for geocoords added to BN | |||
optional { | |||
?county bnp:P117 ?ws . # wikidata id P117 | ?county bnp:P117 ?ws . # wikidata id P117 | ||
?ws bnpq:P14 ?wikidata_url . | ?ws bnpq:P14 ?wikidata_url . | ||
Line 1,283: | Line 1,378: | ||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available | optional { | ||
?wikidata wdt:P625 ?geo1 . | |||
BIND(geof:longitude(?geo1) AS ?long) | |||
BIND(geof:latitude(?geo1) AS ?lat) | |||
} # geocoords if available | |||
} # /wikidata service | } # /wikidata service | ||
} #/wikidata optional | } #/wikidata optional | ||
Line 1,293: | Line 1,392: | ||
</sparql> | </sparql> | ||
==== Counties of residence for women | ====Counties of residence for women nominated as FSAs, on a map==== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 1,305: | Line 1,405: | ||
#defaultView:Map{"hide":["?geo", "?wikidata"]} | #defaultView:Map{"hide":["?geo", "?wikidata"]} | ||
#title:Counties of residence for women | #title:Counties of residence for women nominated as FSAs | ||
SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo | SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?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 | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt:P29 ?residence . # select residences | ?person bnwdt:P29 ?residence . # select residences | ||
Line 1,333: | Line 1,433: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
</sparql> | |||
==== Counties of residence for women | ==== Counties of residence for women nominated to RAI, on a map ==== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 1,350: | Line 1,448: | ||
#defaultView:Map{"hide":["?geo", "?wikidata"]} | #defaultView:Map{"hide":["?geo", "?wikidata"]} | ||
#title:Counties of residence for women nominated to RAI | |||
SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo | SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo | ||
Line 1,355: | Line 1,454: | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt: | ?person bnwdt:P7 ?signatory . #select women who were nominated for election to RAI | ||
?person bnwdt:P29 ?residence . # select residences | ?person bnwdt:P29 ?residence . # select residences | ||
Line 1,379: | Line 1,478: | ||
</sparql> | </sparql> | ||
==== Counties of residence for women | ==== Counties of residence for women who spoke at RAI meetings, on a map==== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 1,396: | Line 1,489: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
#defaultView:Map{"hide":["?geo", "?wikidata"]} | #defaultView:Map{"hide":["?geo", "?wikidata"]} | ||
#title:Counties of residence for women who spoke at RAI meetings | |||
SELECT distinct | SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | 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 | ?person bnwdt:P29 ?residence . # select residences | ||
?residence bnwdt:P33 ?district . #select districts | ?residence bnwdt:P33 ?district . #select districts | ||
Line 1,438: | Line 1,509: | ||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available | optional { ?wikidata wdt:P625 ?geo1 . } # geocoords if available | ||
} # /wikidata service | } # /wikidata service | ||
} #/wikidata optional | } #/wikidata optional | ||
BIND(COALESCE(?geo1, ?geo2) AS ?geo). # if geo1 available use | 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". } | 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 ==== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | #title:Counties of residence for women who exhibited at RAI meetings | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 1,461: | Line 1,534: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ? | #defaultView:Map{"hide":["?geo", "?wikidata"]} | ||
SELECT distinct ?person ?personLabel ?county ?countyLabel ?wikidata ?geo | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | 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 | ?person bnwdt:P29 ?residence . # select residences | ||
?residence bnwdt:P33 ?district . #select districts | ?residence bnwdt:P33 ?district . #select districts | ||
?district bnwdt:P33 ?county . #select counties | ?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 ) | |||
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". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
</sparql> | </sparql> | ||
==== Counties of residence for women in any of the above five categories, mapped==== | |||
<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 bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 1,491: | Line 1,581: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | 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"]} | |||
SELECT distinct ?county ?countyLabel ?wikidata ?geo ?layer #?person ?personLabel | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
?person | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
{ | |||
#women who were nominated for election to FSA | RAI | |||
# | ?person ( bnp:P16 | bnp:P7 ) ?stmt . | ||
} | |||
? | union | ||
{ | |||
# women with publications recorded in indexes of archaeological papers | |||
?person bnp:P76 ?stmt . | |||
? | ?stmt bnps:P76 bnwd:Q419 . | ||
} | |||
union | |||
{ | |||
# | # women who spoke|exhibited at RAI Meeting | ||
? | ?person (bnp:P23 | bnp:P13) ?stmt . | ||
?stmt (bnps:P23 | bnps:P13) bnwd:Q29 . | |||
} | |||
# get the p labels for layers | |||
?person ?p ?stmt . | |||
?claim wikibase:claim ?p; | |||
rdfs:label ?layer. filter(lang(?layer)="en-gb"). | |||
# get geo stuff | |||
?person bnwdt:P29 ?residence . # select residences | |||
?residence bnwdt:P33 ?district . #select districts | |||
?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 ) | |||
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 | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
order by ?layer | |||
</sparql> | </sparql> | ||
=== | ===Regions in which women resided, sorted by how many residences all women had in that region=== | ||
<sparql tryit="1"> | <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 bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 1,553: | Line 1,646: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | 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 | |||
SELECT | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | |||
?person bnwdt:P29 ?residence . # select residences | |||
?residence bnwdt:P33 ?district . #select districts | |||
?district bnwdt:P33 ?county . #select counties | |||
?county bnwdt:P33 ?region . #select region | |||
FILTER NOT EXISTS {?region bnwdt:P117 "Q145" .} #filter out UK (where UK is sub-region of NI) | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
GROUP BY ?region ?regionLabel | |||
ORDER BY DESC(?region_count) | |||
</sparql> | |||
=== Women living in London during the 1890s === | |||
<sparql tryit="1"> | |||
#title:Women living in 1890s London | |||
# Query for women living in (greater) london in the 1890s | |||
# 1 row per person per address per date, could be reduced to 1 row per person if preferred. | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | |||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | |||
PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/> | |||
PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> | |||
PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/> | |||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | |||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | |||
SELECT distinct ?personLabel ?date_label ?date ?person ?address ?address_item ?londonLabel ?geo ?long ?lat | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . # women | |||
?person bnp:P29 ?s . # resided at | ?person bnp:P29 ?s . # resided at | ||
?s bnps:P29 ?london . | ?s bnps:P29 ?london . | ||
Line 1,599: | Line 1,721: | ||
} | } | ||
ORDER BY ?person ?date | ORDER BY ?person ?date | ||
</sparql> | </sparql> | ||
=== | ==== Map of Women living in 1890s London ==== | ||
<sparql tryit="1"> | <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 bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 1,613: | Line 1,738: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
#defaultView:Map | #defaultView:Map | ||
SELECT distinct ?personLabel ?date_label ?date ?person ?address ?address_item ?londonLabel ?geo ?long ?lat | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # | ?person bnwdt:P3 bnwd:Q3 . # women | ||
?person bnp:P29 ?s . # resided at | |||
?s bnps:P29 ?london . | |||
?person bnp: | ?london bnwdt:P33+ bnwd:Q322 . # in Q322 greater london. | ||
# | |||
# optional street address (text) | |||
optional { | |||
?s bnpq:P31 ?address . | |||
} | |||
# optional street address (item) | |||
optional { | |||
?s bnpq:P100 ?address_item . | |||
} | |||
# dates. About 30? not dated. | |||
#optional { | |||
?s ?pq ?date . | |||
# ?date wikibase:timeValue ?date_value. # if you don't want date label this should work instead | |||
?qual_prop wikibase:qualifier ?pq; | |||
wikibase:propertyType wikibase:Time ; # nb excludes edtf dates | |||
rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # what kind of date is it. | |||
# } # /dates | |||
# filter 1890-1899 | |||
FILTER("1890-01-01"^^xsd:dateTime <= ?date && ?date < "1899-12-31"^^xsd:dateTime). | |||
# address geocoordinates | |||
optional { | |||
?s ?pqq ?geo . | |||
?qual_geo wikibase:qualifier ?pqq; | |||
wikibase:propertyType wikibase:GlobeCoordinate. | |||
BIND(geof:longitude(?geo) AS ?long) | |||
BIND(geof:latitude(?geo) AS ?lat) | |||
} | |||
# todo booth codes | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
ORDER BY ?person ?date | |||
</sparql> | </sparql> | ||
=== Where did women who published in Folklore/Folk-lore Record live? === | |||
=== | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | # Map of all places of residence for women who had publications in Folklore/Folk-lore Record | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 1,666: | Line 1,797: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
#defaultView:Map | |||
SELECT | #defaultView:Map{"hide":["?geo", "?count"]} | ||
SELECT ?person ?personLabel ?residenceLabel ?residence ?geo (count( ?person) as ?count) #(concat(str(?count), " publication") as ?count_lbl) | |||
WHERE { | 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 . | |||
## 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 { | |||
?residence bnp:P117 ?ws . # wikidata id P117 | |||
?ws bnpq:P14 ?wikidata_url . | |||
BIND(IRI(REPLACE(?wikidata_url, "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) as ?wikidata ) | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
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,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 | ORDER BY ?locationLabel | ||
Line 1,969: | Line 2,154: | ||
</sparql> | </sparql> | ||
== | === IWD 2024 Map of five women's places === | ||
<sparql tryit="1"> | <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 bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 1,984: | Line 2,168: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | 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 { | WHERE { | ||
?person bnwdt: | |||
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". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | ||
} | } | ||
order by ?personLabel ?date ?placeLabel | |||
</sparql> | </sparql> | ||
=== | === Wikidata categories for BN instance of locality in the UK === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 2,009: | Line 2,278: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | |||
#title: counts of WD instance of (P31) for BN localities (instance of Q2147) in the UK | |||
select ?wd_io ?wd_io_label (count(*) as ?count) | |||
where { | |||
?item bnwdt:P12 bnwd:Q2147 . # BN io locality | |||
? | ?item bnwdt:P33* bnwd:Q1741 . # in UK | ||
?item bnwdt:P117 ?wd. | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wd))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?wikidata wdt:P31 ?wd_io. | |||
## p31 Q48091 region of england. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". | |||
?wikidata rdfs:label ?wd_label . | |||
?wd_io rdfs:label ?wd_io_label . | |||
} | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | ||
} | } | ||
group by ? | group by ?wd_io ?wd_io_label | ||
order by ?wd_io_label | |||
</sparql> | </sparql> | ||
=== | |||
=== Localities not in the UK === | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
##admin_paths lists the linked P33 for the item. Unfortunately, they aren't reliably returned in ascending order. | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 2,037: | Line 2,317: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
#title:localities not in the UK | |||
select ?item ?itemLabel (group_concat(distinct ?admin_label; separator=", " ) as ?admin_path) | |||
where { | |||
? | ?item bnwdt:P12 bnwd:Q2147 . # i/o locality | ||
?item bnwdt:P33* ?admin. | |||
?admin rdfs:label ?admin_label. filter(lang(?admin_label)="en") . | |||
filter not exists { ?item bnwdt:P33* bnwd:Q1741. } # filter out anything in the UK | |||
filter (?item not in (bnwd:Q619, bnwd:Q2961, bnwd:Q4207, bnwd:Q86) ). # and a few things that are not specific places | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | } | ||
group by ?item ?itemLabel | |||
order by ?itemLabel | |||
</sparql> | </sparql> | ||
===Women | ==People== | ||
===Women with their family name at birth and family name after marriage=== | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# Women with their family name at birth and family name after marriage | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 2,075: | Line 2,349: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ?person ?personLabel ?birthname ?marriedname | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . #select women | |||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | |||
OPTIONAL {?person bnwdt:P140 ?birthname .} #look for birth name | |||
OPTIONAL {?person bnwdt:P141 ?marriedname .} #look for married name | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | } | ||
ORDER BY ?personLabel | ORDER BY ?personLabel | ||
</sparql> | </sparql> | ||
=== | === Women with family name at birth, married name and count of married names=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | # Women with their family name at birth, family name after marriage and count of married names | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 2,162: | Line 2,375: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ? | SELECT ?person ?personLabel ?birthname | ||
(GROUP_CONCAT(DISTINCT ?marriedname; SEPARATOR=", ") AS ?marriednames) | |||
(COUNT(?marriedname) AS ?marriedcount) | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # select women | ?person bnwdt:P3 bnwd:Q3 . #select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt: | |||
OPTIONAL {?person bnwdt:P140 ?birthname .} #look for birth name | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | OPTIONAL {?person bnwdt:P141 ?marriedname .} #look for married name | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | } | ||
group by ?person ?personLabel ?birthname | |||
ORDER BY | ORDER BY ?personLabel | ||
</sparql> | </sparql> | ||
===Where women in our data are in wikidata, their spouses, fathers, and mothers according to wikidata=== | |||
== | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 2,190: | Line 2,402: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | 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 ? | SELECT ?person ?personLabel ?item ?WD_spouse ?WD_father ?WD_mother | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . #select women | |||
? | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnp:P117 ?wikidata_ID . #look for wikidata ID on person page | |||
? | ?wikidata_ID bnpq:P14 ?wikidata_url . | ||
? | BIND(IRI(REPLACE(?wikidata_url,"https://www.wikidata.org/wiki/","http://www.wikidata.org/entity/")) as ?item ) | ||
SERVICE <https://query.wikidata.org/sparql> { | |||
?item wdt:P21 ?WD_gender. #get gender of person | |||
OPTIONAL {?item wdt:P22 ?WD_father . } #recall father | |||
OPTIONAL {?item wdt:P25 ?WD_mother . } #recall mother | |||
OPTIONAL {?item wdt:P26 ?WD_spouse . } #recall spouse | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE] | |||
} | } | ||
ORDER BY ? | ORDER BY ?personLabel | ||
# with thanks to @tagishsimon for writing this one initially! | |||
</sparql> | </sparql> | ||
===Women in our data alongside counts of their public and professional activities, sorted by total=== | |||
=== Women | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | ## Women in our data alongside counts of their public and professional activities (https://beyond-notability.wikibase.cloud/wiki/Item:Q151) | ||
## Sorted by total PPAs | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 2,228: | Line 2,439: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
select ?person ?personLabel | |||
(count(distinct ?exhibitor) as ?exhibitions) | |||
(count(distinct ?position) as ?positions) | |||
(count(distinct ?speaker) as ?spoke) | |||
(count(distinct ?attended) as ?attendance) | |||
(count(distinct ?donorof) as ?donated) | |||
(count(distinct ?wasdelegate) as ?delegate) | |||
(count(distinct ?correspondent) as ?correspondents) | |||
(count(distinct ?fellow) as ?fellowships) | |||
(count(distinct ?collab) as ?collaborations) | |||
(count(distinct ?found) as ?founded) | |||
(count(distinct ?loaned) as ?loans) | |||
(count(distinct ?illustrated) as ?illustrations) | |||
(count(distinct ?sold) as ?sales) | |||
(count(distinct ?served) as ?service) | |||
(count(distinct ?job) as ?employed) | |||
(count(distinct ?fundraiser) as ?fundraisers) | |||
(count(distinct ?publish) as ?published) | |||
(count(distinct ?benefact) as ?benefactor) | |||
(count(distinct ?donor) as ?donor_to) | |||
(count(distinct ?collect) as ?collected) | |||
(count(distinct ?performance) as ?performances) | |||
((?exhibitions + ?positions + ?spoke + ?attendance + ?donated + ?delegate + ?correspondents + ?fellowships + ?collaborations + ?founded + ?loans + ?illustrations + ?sales | |||
+ ?service + ?employed + ?fundraisers + ?published + ?benefactor + ?donor_to + ?collected + ?performances) AS ?PPA_total) | |||
?person bnwdt: | where | ||
? | { | ||
?person bnwdt:P3 bnwd:Q3 . | |||
FILTER | optional { ?person bnp:P13 ?exhibitor } | ||
optional { ?person bnp:P17 ?position } | |||
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".} | optional { ?person bnp:P23 ?speaker } | ||
} | optional { ?person bnp:P24 ?attended } | ||
optional { ?person bnp:P65 ?donorof } | |||
</sparql> | optional { ?person bnp:P71 ?wasdelegate } | ||
optional { ?person bnp:P73 ?correspondent } | |||
=== | optional { ?person bnp:P75 ?fellow } | ||
optional { ?person bnp:P83 ?collab } | |||
optional { ?person bnp:P85 ?found } | |||
optional { ?person bnp:P87 ?loaned } | |||
optional { ?person bnp:P89 ?illustrated } | |||
optional { ?person bnp:P99 ?sold } | |||
optional { ?person bnp:P102 ?served } | |||
optional { ?person bnp:P105 ?job } | |||
optional { ?person bnp:P106 ?fundraiser } | |||
optional { ?person bnp:P107 ?publish } | |||
optional { ?person bnp:P110 ?benefact } | |||
optional { ?person bnp:P111 ?donor } | |||
optional { ?person bnp:P114 ?collect } | |||
optional { ?person bnp:P120 ?performance } | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | |||
group by ?person ?personLabel | |||
ORDER BY DESC (?PPA_total) | |||
</sparql> | |||
===Women in our data arranged as a network graph by the organisations they were members of=== | |||
<sparql tryit="1"> | |||
## Women in our data arranged as a network graph by the organisations they were members of | |||
#defaultView:Graph | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | |||
PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> | |||
SELECT ?org ?orgLabel ?rgb ?linkTo ?linkToLabel | |||
WHERE { | |||
?linkTo bnwdt:P3 bnwd:Q3 . #select women | |||
FILTER NOT EXISTS {?linkTo bnwdt:P4 bnwd:Q12 .} #filter out project team | |||
?linkTo bnwdt:P67 ?org | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". } | |||
BIND( "7C4DCD" AS ?rgb ) . | |||
} | |||
ORDER BY ?personLabel | |||
</sparql> | |||
===Membership of organisations by women, sorted by how many women were members of a given organisation=== | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# Membership of organisations by women, sorted by how many women were members of a given organisation | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 2,259: | Line 2,526: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ?organisation ?organisationLabel (count(?organisation) as ?organisation_count) #count number of organisations that women were members of | |||
SELECT ? | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . #select women | ?person bnwdt:P3 bnwd:Q3 . # select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt:P67 ?organisation . # selection people who were members of organisations and what those organisations were | |||
FILTER NOT EXISTS {?person bnwdt:P67 bnwd:Q35 .} # filter out Royal Archaeological Institute | |||
?person | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb | |||
} | } | ||
GROUP BY ?organisation ?organisationLabel | |||
ORDER BY DESC(?organisation_count) | |||
</sparql> | |||
==Education== | |||
=== | ===Women educated at a tertiary educational institution located in Oxford or Cambridge=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | # Women educated at a tertiary educational institution located in Oxford or Cambridge | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 2,301: | Line 2,555: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT | SELECT ?woman ?womanLabel ?educationalinstitution ?educationalinstitutionLabel ?location ?locationLabel | ||
WHERE { | |||
{?woman bnwdt:P3 bnwd:Q3 . #filter women | |||
?woman bnwdt:P94 ?educationalinstitution . #find 'educated at' statement | |||
?educationalinstitution bnwdt:P12 bnwd:Q2914 . #filter to tertiary educational institutions | |||
?educationalinstitution bnwdt:P2 ?location . #find location of educational institution | |||
?location rdfs:label ?locationLabel . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
FILTER(LANG(?locationLabel) = "en") . | |||
FILTER(regex(?locationLabel, "oxford", "i")) .} | |||
UNION | |||
{?woman bnwdt:P3 bnwd:Q3 . #filter women | |||
?woman bnwdt:P94 ?educationalinstitution . #find 'educated at' statement | |||
?educationalinstitution bnwdt:P12 bnwd:Q2914 . #filter to tertiary educational institutions | |||
?educationalinstitution bnwdt:P2 ?location . #find location of educational institution | |||
?location rdfs:label ?locationLabel . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
FILTER(LANG(?locationLabel) = "en") . | |||
FILTER(regex(?locationLabel, "Cambridge$", "i")) .} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | |||
ORDER BY ?womanLabel | |||
</sparql> | |||
=== Women who were FSAs who went to Oxford or Cambridge colleges === | |||
<sparql tryit="1"> | |||
#how many women who were FSAs went to Oxford or Cambridge colleges? | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | |||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | |||
PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/> | |||
PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> | |||
PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/> | |||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | |||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | |||
PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> | |||
SELECT ?person ?personLabel ?college ?collegeLabel ?universityLabel | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . #select women | ?person bnwdt:P3 bnwd:Q3 . #select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt:P75 bnwd:Q8. # only BN subjects having a FSA | |||
?person | |||
# | # educated at (P94) part of (P4) cambridge (Q1181) oxford (Q364) | ||
?person bnwdt:P94 ?college . | |||
?college bnwdt:P4 ?university . | |||
FILTER ( ?university in ( bnwd:Q1181 , bnwd:Q364 ) ) | |||
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".} | SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".} | ||
} | } | ||
order by ?personLabel ? | order by ?personLabel ?collegeLabel | ||
</sparql> | </sparql> | ||
== | === All women who went to tertiary education institutions and dates where available === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
Line 2,344: | Line 2,624: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
PREFIX | PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> | ||
PREFIX | PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | ||
SELECT ?person ?personLabel ?college ?collegeLabel ?university ?universityLabel ?date ?date_label | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . | ?person bnwdt:P3 bnwd:Q3 . #select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
# note: academic degree is P59. possible extra info? | |||
?person bnp:P94 ?s . # educated at | |||
?s bnps:P94 ?college . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | optional {?college bnwdt:P4 ?university . } # a few ?college aren't part of (P4) a ?university | ||
?college bnwdt:P12 bnwd:Q2914 . # tertiary ed inst | |||
# dates. | |||
optional { | |||
?s ?pq ?date . | |||
?qual_prop wikibase:qualifier ?pq; | |||
wikibase:propertyType wikibase:Time ; # nb excludes edtf dates | |||
rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # what kind of date is it. | |||
} # /dates | |||
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".} | |||
} | } | ||
order by ?personLabel ?collegeLabel ?date | |||
</sparql> | </sparql> | ||
=== | |||
=== Academic degrees === | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# Fetch academic degrees for women, with date and conferring institution where available | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 2,370: | Line 2,666: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
PREFIX | PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> | ||
PREFIX | PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | ||
SELECT distinct ?person ?personLabel ?degree ?degreeLabel ?by ?byLabel ?date ?date_label | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . | ?person bnwdt:P3 bnwd:Q3 . #select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | |||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} | |||
# academic degree = P59. | |||
?person bnp:P59 ?s . | |||
?s bnps:P59 ?degree . # type of degree | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | # optional qualifiers for degree | ||
# P61 conferred by | |||
optional { ?s bnpq:P61 ?by . } | |||
# date with type | |||
optional { | |||
?s ?pq ?date . | |||
?qual_prop wikibase:qualifier ?pq; | |||
wikibase:propertyType wikibase:Time ; # nb excludes edtf dates | |||
rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # kind of date | |||
} # /dates | |||
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".} | |||
} | } | ||
order by ?personLabel ?date ?degreeLabel | |||
</sparql> | </sparql> | ||
=== | ==IDs== | ||
===Women in the wiki (excluding the project team) and their corresponding IDs - where they exist - on wikidata, viaf, WorldCat Identities, and the Archaeology Data Service=== | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
Line 2,399: | Line 2,711: | ||
PREFIX wdt: <http://www.wikidata.org/prop/direct/> | PREFIX wdt: <http://www.wikidata.org/prop/direct/> | ||
PREFIX wd: <http://www.wikidata.org/entity/> | PREFIX wd: <http://www.wikidata.org/entity/> | ||
SELECT ? | SELECT ?person ?personLabel ?wikidata_ID ?viaf_ID ?ads_ID ?worldcat_ID | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . #select women | |||
? | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
OPTIONAL {?person bnwdt:P117 ?wikidata_ID .} #return wikidata ID | |||
? | OPTIONAL {?person bnwdt:P119 ?viaf_ID .} #return VIAF ID | ||
OPTIONAL {?person bnwdt:P34 ?ads_ID .} #return Archaeological Data Service ID | |||
OPTIONAL {?person bnwdt:P118 ?worldcat_ID .} #return WorldCat Identities ID | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | } | ||
ORDER BY ?personLabel | |||
ORDER BY ? | |||
</sparql> | </sparql> | ||
=== | ===FSAs in the wiki (excluding the project team) and their corresponding IDs - where they exist - on wikidata, viaf, WorldCat Identities, and the Archaeology Data Service=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 2,448: | Line 2,738: | ||
PREFIX wd: <http://www.wikidata.org/entity/> | PREFIX wd: <http://www.wikidata.org/entity/> | ||
SELECT ?person ?personLabel ? | SELECT ?person ?personLabel ?wikidata_ID ?viaf_ID ?ads_ID ?worldcat_ID | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . #select women | ?person bnwdt:P3 bnwd:Q3 . #select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ?person bnwdt:P16 ?FSA . #select FSA | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | |||
OPTIONAL {?person bnwdt:P117 ?wikidata_ID .} #return wikidata ID | |||
OPTIONAL {?person bnwdt:P119 ?viaf_ID .} #return VIAF ID | |||
OPTIONAL {?person bnwdt:P34 ?ads_ID .} #return Archaeological Data Service ID | |||
OPTIONAL {?person bnwdt:P118 ?worldcat_ID .} #return WorldCat Identities ID | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
ORDER BY ?personLabel | |||
</sparql> | |||
===People with IDs on wikidata, their date of birth on wikidata, and the source(s) of that information=== | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 2,486: | Line 2,764: | ||
PREFIX wdt: <http://www.wikidata.org/prop/direct/> | PREFIX wdt: <http://www.wikidata.org/prop/direct/> | ||
PREFIX wd: <http://www.wikidata.org/entity/> | 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 ? | SELECT ?woman ?womanLabel ?WDitem ?WDdateOfBirth (GROUP_CONCAT(?BirthStatedInEnglish;separator=" | ") AS ?sources) | ||
WHERE { | WHERE { | ||
#Select all women | |||
?woman bnwdt:P3 bnwd:Q3 . | |||
#select all women that have a Wikidata link | |||
?woman bnwdt:P117 ?Qnumber . | |||
? | |||
#create reference to Wikibase entity | |||
BIND(IRI(concat("http://www.wikidata.org/entity/", ?Qnumber)) as ?WDitem ) | |||
#on Wikibase do | |||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
? | #get the date of birth | ||
? | ?WDitem wdt:P569 ?WDdateOfBirth . | ||
} | #get the statement of birth | ||
?WDitem p:P569 ?Birthstatement . | |||
#get its node | |||
?Birthstatement prov:wasDerivedFrom ?BirthRefnode. | |||
#get the value of 'Stated in' | |||
?BirthRefnode pr:P248 ?BirthStatedIn. | |||
#get the english label of the referece 'stated in' | |||
OPTIONAL {?BirthStatedIn rdfs:label ?BirthStatedInEnglish | |||
FILTER (LANG(?BirthStatedInEnglish) = "en")}. | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
ORDER BY ? | GROUP BY ?woman ?womanLabel ?WDitem ?WDdateOfBirth | ||
ORDER BY ?womanLabel | |||
# Credit to Maarten Zeinstra for developing this query | |||
</sparql> | </sparql> | ||
=== | === Which women in the wikibase have Wikipedia articles, according to Wikidata?=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 2,523: | Line 2,813: | ||
PREFIX wd: <http://www.wikidata.org/entity/> | PREFIX wd: <http://www.wikidata.org/entity/> | ||
SELECT ?person ?personLabel | SELECT ?person ?personLabel ?wikidata ?wikipedia | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . #select women | ?person bnwdt:P3 bnwd:Q3 . #select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
?person bnwdt:P117 ?wikidata_ID . #look for wikidata ID on person page | ?person bnwdt:P117 ?wikidata_ID . #look for wikidata ID on person page | ||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ? | bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | ||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
? | # get English language wikipedia articles in wikidata entries, where listed | ||
OPTIONAL { | |||
} | ?wikipedia schema:about ?wikidata . | ||
?wikipedia schema:inLanguage 'en' . | |||
FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/') | |||
} | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
ORDER BY ?personLabel | ORDER BY ?personLabel | ||
</sparql> | </sparql> | ||
=== | |||
=== Women with no date of death in our wikibase who have a date of death on Wikidata=== | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | # Women who have no date of death in our wikibase and have a date of death on Wikidata | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 2,555: | Line 2,849: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
PREFIX | PREFIX wdt: <http://www.wikidata.org/prop/direct/> | ||
PREFIX | PREFIX wd: <http://www.wikidata.org/entity/> | ||
SELECT ?person ?personLabel ?wd_dod | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . #select women | |||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | |||
filter not exists {?person bnwdt:P15 ?bn_dod . } # *don't* have P15 date of death | |||
?person bnwdt:P117 ?wikidata_ID . #look for wikidata ID on person page | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?item) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?item wdt:P21 ?WD_gender. #get gender of person | |||
?item wdt:P570 ?wd_dod . #date of death on Wikidata P570 | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
ORDER BY ?personLabel | |||
</sparql> | |||
=== Women with no date of birth in our wikibase who have a date of birth in Wikidata=== | |||
<sparql tryit="1"> | |||
# Women who have no date of birth in our wikibase and have a date of birth on Wikidata | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 2,603: | Line 2,888: | ||
PREFIX wd: <http://www.wikidata.org/entity/> | PREFIX wd: <http://www.wikidata.org/entity/> | ||
SELECT ? | SELECT ?person ?personLabel ?wd_dob | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . #select women | ?person bnwdt:P3 bnwd:Q3 . #select women | ||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | ||
filter not exists {?person bnwdt:P26 ?bn_dob . } # *don't* have P15 date of death | |||
?person bnwdt:P117 ?wikidata_ID . #look for wikidata ID on person page | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?item) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?item wdt:P21 ?WD_gender. #get gender of person | |||
?item wdt:P569 ?wd_dob . #date of birth on Wikidata P569 | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
ORDER BY ?personLabel | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE] | |||
} | |||
ORDER BY | |||
</sparql> | </sparql> | ||
=== | === All external IDs on Wikidata for Women === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | # Query to fetch all available External IDs on Wikidata for FSAs | ||
# NB this will take a while, but it should finish. | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 2,643: | Line 2,923: | ||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | ||
SELECT distinct ?person ?personLabel ?wikidata ? | SELECT distinct ?person ?personLabel ?wikidata ?p ?id_no ?id_label | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . #select women | ?person bnwdt:P3 bnwd:Q3 . #select women | ||
#?person bnwdt:P75 bnwd:Q8. # limit to FSAs if the full set times out. | |||
?person bnwdt:P117 ?wikidata_ID . #get wikidata ID | ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID | ||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | ||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
# | ?wikidata ?p ?s . | ||
?prop wikibase:claim ?p; | |||
wikibase:statementProperty ?ps; # NB rather than statementValue | |||
wikibase:propertyType wikibase:ExternalId. # quicker than filter. | |||
?prop rdfs:label ?id_label. filter(lang(?id_label)="en") . # ident name | |||
?s ?ps ?id_no . # id value | |||
# filter by property type | |||
#filter(?prop_type in (wikibase:ExternalId ) ) . | |||
} | } | ||
Line 2,664: | Line 2,950: | ||
} | } | ||
order by ?personLabel ? | order by ?personLabel ?id_label ?id_no | ||
</sparql> | </sparql> | ||
=== | === What external IDs are available in Wikidata for women in the BN database? === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | # All the external IDs on BN women's Wikidata pages, with counts and descriptions | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 2,679: | Line 2,965: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
PREFIX | PREFIX wdt: <http://www.wikidata.org/prop/direct/> | ||
PREFIX | PREFIX wd: <http://www.wikidata.org/entity/> | ||
SELECT ?p ?id_label ?id_description (count(?p) as ?count) | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . #select women | |||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | |||
?person bnwdt:P117 ?wikidata_ID . # wikidata ID | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?wikidata ?p ?s . | |||
?prop wikibase:claim ?p; | |||
wikibase:propertyType wikibase:ExternalId; | |||
rdfs:label ?id_label. filter(lang(?id_label)="en") . | |||
?prop schema:description ?id_description . | |||
filter(lang(?id_description) = "en") . | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en, en-gb". } | ||
} | } | ||
group by ?p ?id_label ?id_description | |||
ORDER BY desc(?count) | |||
</sparql> | </sparql> | ||
=== | === Women with ODNB IDs in Wikidata === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# BN women with ODNB biography IDs on Wikidata, with links to the bios | |||
# | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 2,723: | Line 3,005: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | 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 | SELECT distinct ?person ?personLabel ?wikidata ?url | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . #select women | |||
?person bnwdt:P117 ?wikidata_ID . #get wikidata ID | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
# P1415 Oxford Dictionary of National Biography ID | P6829 Dictionary of Irish Biography ID | P1648 Dictionary of Welsh Biography ID | |||
?wikidata wdt:P1415 ?id . | |||
# odnb link | |||
BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?id)) as ?url ) . | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | |||
} | } | ||
order by ? | |||
order by ?personLabel ?id | |||
</sparql> | </sparql> | ||
=== | === Women with National Portrait Gallery links via Wikidata === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | # Query to fetch National Portrait Gallery IDs on Wikidata for BN women, with links | ||
# NB this may be a bit slow... | |||
# | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 2,768: | Line 3,044: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | 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 | SELECT distinct ?person ?personLabel ?wikidata ?id_no ?npg_url | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . #select women | |||
?person bnwdt:P117 ?wikidata_ID . #get wikidata ID | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?wikidata ?p ?s . | |||
?prop wikibase:claim ?p; | |||
wikibase:statementProperty ?ps; | |||
wikibase:propertyType wikibase:ExternalId. | |||
?s ps:P1816 ?id_no . # id value | |||
# npg link | |||
BIND(IRI(concat("https://www.npg.org.uk/collections/search/person/", ?id_no)) as ?npg_url ) . | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | |||
} | } | ||
order by ? | |||
order by ?personLabel ?id_no | |||
</sparql> | </sparql> | ||
=== Which BN properties map on to Wikidata properties? === | |||
<sparql tryit="1"> | |||
## **NOTES** | |||
## a few properties have a linked wikidata "Q" rather than "P" ID. These will unfortunately not link correctly to Wikidata so wd_label/wd_description won't be present. | |||
## a few other properties may have wikidata=yes but no wd_label and/or wd_description. This could be because the property on Wikidata has been deleted (eg performed at). | |||
# | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 2,813: | Line 3,089: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT | SELECT DISTINCT ?property (if(bound(?wikidata_id), "yes", "no") as ?has_wikidata) ?bn_label ?wd_label ?bn_description | ||
?wd_description ?wikidata ?bn_propertyType | |||
WHERE { | |||
?property a wikibase:Property ; | |||
wikibase:propertyType ?bn_propertyType . # datatype | |||
service wikibase:label { | |||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". | |||
?property rdfs:label ?bn_label . | |||
?property schema:description ?bn_description . | |||
} | |||
# wikidata P117 | |||
optional { | |||
?property bnwdt:P117 ?wikidata_id . | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". | |||
?wikidata schema:description ?wd_description . | |||
?wikidata rdfs:label ?wd_label . | |||
} # / label service | |||
} # /wikidata service | |||
} #/wikidata optional | |||
} | |||
order by ?bn_label | |||
</sparql> | </sparql> | ||
==== | ==== Of these, which are properties for public and professional activities? ==== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# which properties have corresponding wikidata IDs, restricted to instance of PPA (P12 / Q151) | |||
# | ## **NOTES** | ||
# | ## a few properties have a linked wikidata "Q" rather than "P" ID. These will unfortunately not link correctly to Wikidata so wd_label/wd_description won't be present. | ||
## a few other properties may have wikidata=yes but no wd_label and/or wd_description. This could be because the property on Wikidata has been deleted (eg performed at). | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 2,868: | Line 3,134: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT | SELECT DISTINCT ?property (if(bound(?wikidata_id), "yes", "no") as ?has_wikidata) ?bn_label ?wd_label ?bn_description | ||
?wd_description ?wikidata ?bn_propertyType | |||
WHERE { | WHERE { | ||
?property a wikibase:Property ; | |||
wikibase:propertyType ?bn_propertyType . # datatype | |||
? | service wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". | |||
?property rdfs:label ?bn_label . | |||
?property schema:description ?bn_description . | |||
} | |||
# wikidata P117 | |||
optional { ?property bnwdt:P117 ?wikidata_id . | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". | |||
?wikidata schema:description ?wd_description . | |||
?wikidata rdfs:label ?wd_label . | |||
} # / label service | |||
} # /wikidata service | |||
} #/wikidata optional | |||
?property bnwdt:P12 bnwd:Q151. # instance of PPA | |||
} | } | ||
order by ?bn_label | |||
</sparql> | |||
=== Archaeological sites/Historic houses and their owners/operators in Wikidata === | |||
== | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title:archaeological sites/historic houses in wikidata | |||
#title: | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 2,933: | Line 3,177: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT distinct ? | SELECT distinct ?item ?itemLabel ?instanceLabel ?wikidata ?wd_owner_label ?wd_operator_label ?wd_member_label #?wd_owner ?wd_operator | ||
WHERE { | WHERE { | ||
{ ?item bnwdt:P12 bnwd:Q86 . } # instance of archaeological site | |||
union | |||
{ ?item bnwdt:P12 bnwd:Q2961 . } # instance of historic house | |||
?item bnwdt:P12 ?instance . # which instance of is it | |||
filter ( ?instance in (bnwd:Q86, bnwd:Q2961) ) . # (need filter as a few have multiple instance of) | |||
?item bnwdt:P117 ?wikidata_id . | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
optional { ?wikidata wdt:P127 ?wd_owner .} # can be individuals and multiple. | |||
optional { ?wikidata wdt:P137 ?wd_operator . } | |||
optional { ?wikidata wdt:P463 ?wd_member . } | |||
## at least some had *both* owned by *and* operator, but not always the case. | |||
## owned by P127 / operator P137 | |||
## English Heritage Q936287 National Trust (Q333515) | |||
## member of P463 Historic Houses Association (Q5773523) | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | # automatic *Label doesn't work with a federated query; rdfs:label instead. | ||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "en". | |||
?wd_owner rdfs:label ?wd_owner_label. | |||
?wd_operator rdfs:label ?wd_operator_label. | |||
?wd_member rdfs:label ?wd_member_label. | |||
} | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | } | ||
order by ?itemLabel | |||
order by ? | |||
</sparql> | </sparql> | ||
=== | ==== And which are owned/operated by English Heritage/National Trust or belong to Historic Houses Association ==== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | # archaeological site or historic house. | ||
# | # pull together via Wikidata which ones are owned/operated by 1) English Heritage 2) National Trust or 3) affiliated to Historic Houses association | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 2,994: | Line 3,232: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ? | SELECT distinct ?item ?itemLabel ?instanceLabel ?wikidata ?wd_owner_label ?wd_operator_label ?wd_member_label #?wd_owner ?wd_operator | ||
WHERE { | WHERE { | ||
{ ?item bnwdt:P12 bnwd:Q86 . } | |||
union | |||
{ ?item bnwdt:P12 bnwd:Q2961 . } | |||
?item bnwdt:P12 ?instance . | |||
filter ( ?instance in (bnwd:Q86, bnwd:Q2961) ) . | |||
?item bnwdt:P117 ?wikidata_id . | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
optional { ?wikidata wdt:P127 ?wd_owner .} | |||
optional { ?wikidata wdt:P137 ?wd_operator . } | |||
optional { ?wikidata wdt:P463 ?wd_member . } | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | |||
} | # filter: owner or operator = EH/NT / member of HHA | ||
filter ( ?wd_owner in (wd:Q936287, wd:Q333515) || | |||
order by ? | ?wd_operator in (wd:Q936287, wd:Q333515) || | ||
?wd_member = wd:Q5773523 ) . | |||
## owned by P127 / operator P137 | |||
## ENglish Heritage Q936287 National Trust (Q333515) | |||
## member of P463 Historic Houses Association (Q5773523) | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "en". | |||
?wd_owner rdfs:label ?wd_owner_label. | |||
?wd_operator rdfs:label ?wd_operator_label. | |||
?wd_member rdfs:label ?wd_member_label. | |||
} | |||
} | |||
#} # /optional for wikidata ID | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | |||
order by ?itemLabel | |||
</sparql> | </sparql> | ||
=== BN Men in Wikidata | |||
== Men == | |||
=== BN Men in Wikidata === | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title: | |||
#title: BN men in Wikidata | |||
# a starting point to get the basic query set up; can easily add more variables... | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 3,035: | Line 3,298: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> | |||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | |||
SELECT distinct ?person ?personLabel ?wikidata ?whos_who ?odnb_url ?wikipedia ?wd_dob ?wd_dod ?wd_stmts | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q10 . #select men | |||
?person bnwdt:P117 ?wikidata_ID . #get wikidata ID | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | |||
? | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
?wikidata wikibase:statements ?wd_stmts . | |||
optional { | optional { | ||
# P1415 Oxford Dictionary of National Biography ID | # P1415 Oxford Dictionary of National Biography ID | couls also add P6829 Dictionary of Irish Biography ID | P1648 Dictionary of Welsh Biography ID | ||
?wikidata wdt:P1415 ?odnb_id . | |||
# odnb link | |||
BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?odnb_id)) as ?odnb_url ) . | |||
} #/ odnb | |||
# English language wikipedia articles in wikidata entries, where listed | # English language wikipedia articles in wikidata entries, where listed | ||
Line 3,061: | Line 3,327: | ||
FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/') | FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/') | ||
} | } | ||
optional { ?wikidata wdt:P4789 ?whos . | |||
bind(iri(concat("https://www.ukwhoswho.com/view/article/oupww/whoswho/", ?whos)) as ?whos_who) . | |||
} # P4789 Who's Who | |||
optional { ?wikidata wdt:P569 ?wd_dob . } #date of birth on Wikidata P569 | optional { ?wikidata wdt:P569 ?wd_dob . } #date of birth on Wikidata P569 | ||
optional { ?wikidata wdt:P570 ?wd_dod . } #date of death on Wikidata P570 | optional { ?wikidata wdt:P570 ?wd_dod . } #date of death on Wikidata P570 | ||
} #/ wikidata | } #/ wikidata | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | ||
} | } | ||
order by ?personLabel | |||
</sparql> | </sparql> | ||
=== | === What sort of info Wikidata has about BN men === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title: | |||
# | #title: what info is there for BN men in Wikidata | ||
#counts of properties (excluding external IDs, of which there are gazillions) (Counts are overall and some people might have more than one.) | |||
#at time of writing there are 198 linked men. | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 3,086: | Line 3,359: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> | |||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | |||
SELECT ?prop_label ?prop (count(?prop) as ?count) | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q10 . #select men 211. | |||
? | ?person bnwdt:P117 ?wikidata_ID . #get wikidata ID | ||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?wikidata ?p ?s . | |||
?prop wikibase:claim ?p; | |||
SERVICE <https://query.wikidata.org/sparql> { | wikibase:propertyType ?prop_type ; | ||
wikibase:statementProperty ?ps. | |||
?prop rdfs:label ?prop_label. filter(lang(?prop_label)="en") . | |||
filter(?prop_type in (wikibase:Time, wikibase:WikibaseItem ) ) . | |||
# also a few quantity, string, monolingualtext | |||
} #/ wikidata | |||
} #/ wikidata | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | ||
} | |||
group by ?prop_label ?prop | |||
order by ?prop_label | |||
</sparql> | </sparql> | ||
=== BN Men in Wikidata: | === BN Men in Wikidata: men who proposed elections to SAL/RAI === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title: | #title:Men who proposed for SAL/RAI elections who are in Wikidata | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 3,127: | Line 3,401: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT distinct ? | SELECT distinct ?proposerLabel ?proposer ?wikidata ?odnb_url ?wikipedia ?wd_dob ?wd_dod | ||
WHERE { | WHERE { | ||
?person | ?person (bnp:P16 | bnp:P7) ?s . # proposed to either SAL or RAI | ||
? | ?s (bnps:P16 | bnps:P7) ?proposer . | ||
?proposer bnwdt:P3 bnwd:Q10 . | |||
? | |||
?proposer bnwdt:P117 ?wikidata_ID . #get wikidata ID | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | ||
Line 3,139: | Line 3,414: | ||
optional { | optional { | ||
# P1415 Oxford Dictionary of National Biography ID | # P1415 Oxford Dictionary of National Biography ID | ||
?wikidata wdt:P1415 ?odnb_id . | ?wikidata wdt:P1415 ?odnb_id . | ||
BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?odnb_id)) as ?odnb_url ) . # make odnb link | BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?odnb_id)) as ?odnb_url ) . # make odnb link | ||
} #/ odnb | } #/ odnb | ||
# | # could also add: P6829 Dictionary of Irish Biography ID | P1648 Dictionary of Welsh Biography ID | ||
# English language wikipedia articles in wikidata entries, where listed | # English language wikipedia articles in wikidata entries, where listed | ||
Line 3,153: | Line 3,427: | ||
} | } | ||
# there will be a few duplicates here... | |||
optional { ?wikidata wdt:P569 ?wd_dob . } #date of birth on Wikidata P569 | optional { ?wikidata wdt:P569 ?wd_dob . } #date of birth on Wikidata P569 | ||
optional { ?wikidata wdt:P570 ?wd_dod . } #date of death on Wikidata P570 | optional { ?wikidata wdt:P570 ?wd_dod . } #date of death on Wikidata P570 | ||
Line 3,159: | Line 3,434: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | ||
} | } | ||
ORDER BY ?proposerLabel | ORDER BY ?proposerLabel | ||
</sparql> | </sparql> | ||
==== Male proposers who have occupations data in Wikidata==== | |||
=== | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title:Men who | #title:Men who proposed for SAL/RAI elections who have occupation(s) in wikidata | ||
# with occupation labels, which was slightly trickier than expected | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 3,178: | Line 3,452: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT distinct ?personLabel ?proposerLabel | |||
(group_concat(distinct ?wd_label; SEPARATOR="; ") as ?proposer_occupations) | |||
?wikidata ?person ?proposer | |||
SELECT | |||
WHERE { | WHERE { | ||
?person (bnp:P16 | bnp:P7) ?s . # proposed to either SAL or RAI | |||
? | ?s (bnps:P16 | bnps:P7) ?proposer . | ||
?proposer bnwdt:P3 bnwd:Q10 . | |||
?proposer bnwdt:P117 ?wikidata_ID . #get wikidata ID | |||
? | bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | ||
SERVICE <https://query.wikidata.org/sparql> { | |||
?wikidata wdt:P106 ?wd_occupation . | |||
# automatic *Label doesn't work with a federated query; this works instead. | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "en". | |||
?wd_occupation rdfs:label ?wd_label. | |||
} | |||
} #/ wikidata service | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | ||
} | } | ||
group by ? | group by ?personLabel ?proposerLabel ?wikidata ?person ?proposer | ||
ORDER BY ?proposerLabel ?person | |||
ORDER BY | |||
</sparql> | </sparql> | ||
== | === BN Men in Wikidata: Spouses === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | #title: BN spouses who are in Wikidata | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | |||
PREFIX | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
PREFIX | PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/> | ||
PREFIX | PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> | ||
PREFIX | PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/> | ||
PREFIX | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT distinct ?spouse ?spouseLabel ?wikidata ?odnb_url ?wikipedia ?wd_dob ?wd_dod | |||
WHERE { | WHERE { | ||
? | ?person bnwdt:P3 bnwd:Q3. | ||
?person bnwdt:P41 ?spouse . | |||
?spouse bnwdt:P117 ?wikidata_ID . #get wikidata ID | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
optional { | |||
# P1415 Oxford Dictionary of National Biography ID | |||
?wikidata wdt:P1415 ?odnb_id . | |||
BIND(IRI(concat("https://doi.org/10.1093/ref:odnb/", ?odnb_id)) as ?odnb_url ) . # make odnb link | |||
} #/ odnb | |||
# couls also add: P6829 Dictionary of Irish Biography ID | P1648 Dictionary of Welsh Biography ID | |||
# English language wikipedia articles in wikidata entries, where listed | |||
OPTIONAL { | |||
?wikipedia schema:about ?wikidata . | |||
?wikipedia schema:inLanguage 'en' . | |||
FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/') | |||
} | |||
optional { ?wikidata wdt:P569 ?wd_dob . } #date of birth on Wikidata P569 | |||
optional { ?wikidata wdt:P570 ?wd_dod . } #date of death on Wikidata P570 | |||
} #/ wikidata service | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | |||
} | } | ||
ORDER BY ?proposerLabel | |||
</sparql> | </sparql> | ||
=== | === BN Men who proposed, seconded or signed for Women in SAL/RAI/RHS elections, with counts and wikidata IDs === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title:Men who supported women (at least twice) for SAL/RAI/RHS election with Wikidata IDs | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 3,278: | Line 3,543: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
# p155, p156 - signed rhs | |||
# p32, p82 - signed sal| | |||
# p8 rai seconded | |||
SELECT ?supporterLabel ?supporter ?wikidata (count(?supporter) as ?supported) | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . | |||
{ | |||
?person ( bnp:P155 | bnp:P156 | bnp:P16 | bnp:P7 ) ?s . # | |||
?s ( bnps:P155 | bnps:P156 | bnps:P16 | bnps:P7 ) ?supporter . # proposed SAL/RAI / signed RHS | |||
#?s ?prop ?supporter . | |||
} | } | ||
# union for qualifiers | |||
union | |||
{ | |||
?person ?p ?s . | |||
?s ( bnpq:P156 | bnpq:P155 | bnpq:P32 | bnpq:P82 | bnpq:P8 ) ?supporter . | |||
#?s ?prop ?supporter . | |||
} | |||
?supporter bnwdt:P3 bnwd:Q10 . # male | |||
optional { | |||
?supporter bnwdt:P117 ?wikidata_ID . #get wikidata ID | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_ID))) as ?wikidata) . | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | |||
} | } | ||
group by ?supporterLabel ?supporter ?wikidata | |||
having (?supported>2) | |||
ORDER BY desc(?supported) desc(?wikidata) | |||
</sparql> | </sparql> | ||
==Fishing Expeditions== | |||
=== | ===All properties in use in the wikibase with property type, label and description (if present)=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | # query for information about properties that are being used in the wikibase | ||
## fyi: not actually necessary to declare these properties | |||
PREFIX | PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> | ||
PREFIX | PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | ||
PREFIX | PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> | ||
PREFIX | PREFIX wikibase: <http://wikiba.se/ontology#> | ||
PREFIX | PREFIX schema: <http://schema.org/> | ||
PREFIX | PREFIX skos: <http://www.w3.org/2004/02/skos/core#> | ||
SELECT | SELECT DISTINCT | ||
WHERE { | ?property | ||
? | ?propertyType | ||
? | ?propertyLabel | ||
? | (group_concat(?propertyAltLabel; separator=" | ") as ?propertyAltLabels) | ||
?propertyDescription | |||
WHERE { | |||
?property a wikibase:Property ; | |||
rdfs:label ?propertyLabel ; # label | |||
wikibase:propertyType ?propertyType . # datatype | |||
# add alternative labels if present (can be multiple) | |||
OPTIONAL { ?property skos:altLabel ?propertyAltLabel . } | |||
# add description if present | |||
OPTIONAL { | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". | |||
?property schema:description ?propertyDescription . | |||
} | |||
} | |||
FILTER(LANG(?propertyLabel) = 'en') | |||
# fix label language dups; but Q why doesn't SERVICE work? | |||
# A: https://en.wikibooks.org/wiki/SPARQL/FILTER#FILTER_on_values_in_Labels | |||
} | } | ||
group by ? | group by ?property ?propertyLabel ?propertyType ?propertyDescription | ||
order by ?propertyLabel | |||
</sparql> | </sparql> | ||
=== | === All the Things for Organisations === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# Exploratory query to get all info on an item page including qualifiers (but not references) for each organisation (Q2316) in the wikibase | |||
# Initially this *only* fetched organisations that specifically have the instance of Q2316: I didn't realise for a while how many organisations don't directly reference Q2316. | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 3,366: | Line 3,641: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
select distinct ?item ?itemLabel | |||
?prop ?propLabel ?prop_type | |||
?stmt_value ?stmt_valueLabel | |||
?qual_prop ?qual_value ?qual_label ?qual_prop_type | |||
?statement | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb | where { | ||
?item bnwdt:P12+ bnwd:Q2316 . # instance of organisation or descendants of (excluding instance of organisation itself) | |||
# get all the things about ?item | |||
?item ?p ?statement . | |||
# to get item Label without using service. couple of missing en-gb labels somewhere | |||
# ?item rdfs:label ?item_label . filter(lang(?item_label)="en-gb") . | |||
# get stuff about ?p | |||
?prop wikibase:claim ?p; | |||
wikibase:statementProperty ?ps; # "Links property entity to statement simple value predicate" | |||
#wikibase:statementValue ?psv; # "Links property entity to statement full value predicate" | |||
wikibase:propertyType ?prop_type. | |||
# get stuff about ?statement | |||
?statement ?ps ?stmt_value. | |||
# get any qualifiers | |||
optional { | |||
?statement ?qual_p ?qual_value . | |||
?qual_prop wikibase:qualifier ?qual_p; | |||
wikibase:propertyType ?qual_prop_type ; | |||
rdfs:label ?qual_label. filter(lang(?qual_label)='en-gb') . | |||
} | |||
# OPTIONAL { ?item skos:altLabel ?alt_label . } | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | } | ||
order by ?item_label ?prop_label | |||
</sparql> | </sparql> | ||
=== | === One woman === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title:All About a Woman | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 3,396: | Line 3,701: | ||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | ||
SELECT distinct ? | SELECT distinct ?propLabel ?spsLabel ?qual_propLabel ?pqsLabel ?link ?s | ||
#?prop ? | # ?main_date ?main_precision ?qual_date ?qual_precision | ||
# ?prop ?sps ?pqs ?pq | |||
WHERE { | WHERE | ||
{ | |||
VALUES (?person) {(bnwd:Q569)} # add (bnwd:Qxxx) if you want more than one person. | |||
?person ?p ?s . | |||
?prop wikibase:claim ?p; | |||
wikibase:statementProperty ?ps; # simple value | |||
wikibase:statementValue ?psv. # full value | |||
# 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". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | ||
} | } | ||
order by ?propLabel ?s | |||
</sparql> | </sparql> | ||
=== | ===Working with property paths: organisations and locations=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | ## problem: sometimes you need to follow property paths using */+ for (eg) locations. BUT this can lead to several results to choose between and they aren't necessarily returned in the "right" order. | ||
# | ## how to determine the "distance" along the path of each result? | ||
# | ## https://stackoverflow.com/questions/61984052/wikidata-get-the-full-subhierachy-of-one-class-as-well-as-all-nodes | ||
## > you can get the distance of a class with SELECT ?cls (count(?tmp) as ?distance) WHERE { ?cls wdt:P279* ?tmp . ?tmp wdt:P279+ wd:Q2095 . } group by ?cls order by asc(?distance) - though there might be corner cases like cycles in the hierarchy resp. multiple paths | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 3,463: | Line 3,768: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT ? | SELECT ?item ?itemLabel ?location ?locationLabel (count(?item) as ?distance) | ||
WHERE { | |||
?item bnwdt:P12 bnwd:Q2316 . # instance of organisation. | |||
?item bnwdt:P2* ?tmp . | |||
?tmp bnwdt:P2+ ?location . # P2=30. P2+=34 | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". } | |||
} | |||
group by ?item ?itemLabel ?location ?locationLabel | |||
ORDER BY ?item ?distance | |||
</sparql> | |||
=== Traversing instance of with GAS === | |||
<sparql tryit="1"> | |||
#title:GAS | |||
# The Gather, Apply, and Scatter (GAS) service provides graph traversal, graph mining, and similar classes of algorithms for SPARQL. | |||
# In practical terms, it enables a series of relations to be followed through the graph; for instance the chain of father, grandfather, great-grandfather &c - tracing the father (P22) line - of a subject item | |||
# https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/query_optimization#GAS_Service | |||
# https://github.com/blazegraph/database/wiki/RDF_GAS_API | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | |||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | |||
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 bnwdv: <https://beyond-notability.wikibase.cloud/value/> | ||
PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> | PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> | ||
Line 3,509: | Line 3,796: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT | SELECT ?depth ?ioLabel ?itemLabel ?io ?item | ||
WHERE { | WHERE { | ||
SERVICE gas:service { | |||
gas:program gas:gasClass "com.bigdata.rdf.graph.analytics.BFS" ; | |||
gas:in bnwd:Q3099 ; | |||
gas:linkType bnwdt:P12 ; | |||
gas:traversalDirection "Reverse"; | |||
gas:out ?item ; | |||
} | gas:out1 ?depth ; | ||
gas:out2 ?io . | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } | |||
} | |||
order by ?depth ?ioLabel ?itemLabel | |||
</sparql> | |||
=== | === Working with property paths: instance of [CAVEAT: experimental, probably wrong]=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | # an attempt to adapt the query above following paths for locations of organisations for (more complex) instance of | ||
# ref https://stackoverflow.com/questions/61984052/wikidata-get-the-full-subhierachy-of-one-class-as-well-as-all-nodes | |||
# distance is in the right *order* so it should be usable for some purposes, but the starting number = number of levels rather than 1. also jumps if there are siblings somewhere along the path. | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
Line 3,536: | Line 3,828: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT | SELECT ?item ?itemLabel ?instance_of ?instance_ofLabel (count(?item) as ?distance) | ||
WHERE { | |||
?item bnwdt:P12* ?tmp . # instance of anything. | |||
?tmp bnwdt:P12+ ?instance_of . # P2=30. P2+=34 | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". } | |||
} | } | ||
ORDER BY ? | group by ?item ?itemLabel ?instance_of ?instance_ofLabel | ||
ORDER BY ?item ?distance | |||
</sparql> | </sparql> | ||
=== | ==Dates== | ||
===All the Dates for Women FSAs=== | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | #title:fishing for dates for FSAs | ||
# | # union query to get [hopefully] every date associated with women FSAs including main dates and qualifier dates | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 3,585: | Line 3,859: | ||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | ||
SELECT ?person ?personLabel | SELECT distinct ?person ?personLabel ?prop_label ?qualLabel ?qual_dateLabel ?date_value ?s | ||
#?prop ?qual | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . #select women | |||
?person bnwdt:P75 bnwd:Q8. # find only BN subjects having a FSA | |||
# get stuff about ?person | |||
?person ?p ?s . | |||
# get stuff about ?p . | |||
?prop wikibase:claim ?p; | |||
wikibase:statementProperty ?ps ; | |||
wikibase:statementValue ?psv . | |||
?prop wikibase:propertyType ?date_prop_type . | |||
?prop rdfs:label ?prop_label. filter(lang(?prop_label)="en-gb") . | |||
{ # main dates | { # main dates | ||
# get dates detail via ?s and psv | |||
# gets edtf dates in simplified std wiki date format? | |||
?s ? | # https://github.com/ProfessionalWiki/WikibaseEdtf | ||
?s ?psv ?wdv . | |||
?wdv wikibase:timeValue ?date_value . | ?wdv wikibase:timeValue ?date_value . | ||
} # /main dates | |||
UNION | UNION | ||
{ # qualifier dates | { # qualifier dates | ||
# direct value (usually item) for the property | |||
?s ?ps ?qual. | |||
# date qualifiers. [assumes no edtf in quals. ] | |||
?s ?pq ?date_value . | |||
?qual_date wikibase:qualifier ?pq . | |||
?qual_date wikibase:propertyType wikibase:Time. | |||
?qual_date rdfs:label ?date_qual_label . filter(lang(?date_qual_label)="en") . | |||
} # /qual dates | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | ||
} # /where | } # /where | ||
ORDER BY ? | ORDER BY ?person ?prop_label ?date_value | ||
</sparql> | </sparql> | ||
=== | ===Fetch any of multiple kinds of EDTF date for a woman=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | # a union query to fetch stuff for multiple properties, in this case dates recorded in EDTF which need slightly different handling from PIT dates | ||
# main dates only; pretty sure there are no EDTF in qualifiers. | |||
# updated to get date property labels | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 3,627: | Line 3,925: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT | SELECT ?person ?personLabel ?date_edtf ?date_prop ?date_label ?s | ||
#( | |||
WHERE { ?person bnwdt:P3 bnwd:Q3 . | |||
FILTER NOT EXISTS { ?person bnwdt:P4 bnwd:Q12 . } | |||
## can do this union first but makes no difference to results except possibly a bit slower. | |||
#?person ( bnp:P131 | bnp:P132 | bnp:P133 ) ?s . | |||
# ?s ( bnps:P131 | bnps:P132 | bnps:P133 ) ?date_edtf . | |||
?person ?p ?s . # so you can get the statement id and date prop label | |||
?claim wikibase:claim ?p; | |||
rdfs:label ?date_label. filter(lang(?date_label)="en") . | |||
?s ?date_prop ?date_edtf . | |||
## filter for edtf dates | |||
## docs: https://github.com/ProfessionalWiki/WikibaseEdtf | |||
FILTER ( datatype(?date_edtf) = xsd:edtf ) . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en, en-gb". } | |||
} | |||
ORDER BY ?personLabel | |||
</sparql> | </sparql> | ||
===Full values: dates === | |||
= | <sparql tryit="1"> | ||
# query for full values to access the timeValue and timePrecision of a date, in this case a date of birth. | |||
## why is a more complex query needed? | |||
## simple value for a date doesn't differentiate between (eg) "1880" and "1 January 1880"; both are returned as 1 January 1880 (and SELECT DISTINCT will collapse them into a single result) | |||
## there are 14 codes for precision from billion years to second. 7: century, 8: decade, 9: year, 10: month, 11: day | |||
## NB additional bnpsv: prefix | |||
## https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format#Value_representation | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 3,685: | Line 3,973: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> | PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> | ||
SELECT DISTINCT ?item ?itemLabel ?date ?precision | |||
WHERE { | WHERE { | ||
? | ?item bnp:P26 ?statement. # date of birth (precision of these varies quite a bit) | ||
? | ?statement bnpsv:P26 ?valueNode. | ||
? | ?valueNode wikibase:timeValue ?date. | ||
?valueNode wikibase:timePrecision ?precision. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } | |||
} | |||
ORDER BY ?date | |||
</sparql> | |||
=== Any main level date for women === | |||
<sparql tryit="1"> | |||
# a query to get all types of main date for women | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 3,740: | Line 3,999: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> | |||
SELECT ?person ?personLabel ? | SELECT DISTINCT ?person ?personLabel ?date_label ?date ?date_prop_type ?date_prop ?link_prop | ||
== | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . # women | |||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} | |||
?person ?p ?s . | |||
?date_prop wikibase:claim ?p; | |||
wikibase:statementValue ?psv ; | |||
wikibase:propertyType ?date_prop_type; # property type = wikibase:Time OR wikibase:Edtf | |||
rdfs:label ?date_label. filter(lang(?date_label)="en-gb") . # what kind of date it is | |||
# direct link to relevant section of page | |||
BIND (REPLACE(STR(?date_prop), "^.*/([^/]*)$", "$1") as ?pid). | |||
bind(iri(concat(str(?person), "#", ?pid)) as ?link_prop ) . | |||
?s ?psv ?wdv . # for the date value | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language " | ?wdv wikibase:timeValue ?date . #timeValue gets pit and edtf | ||
# ?wdv wikibase:timePrecision ?date_precision . # optional | |||
# nb also possible to filter either/or time/edtf by property type | |||
# filter(?date_prop_type in (wikibase:Edtf, wikibase:Time ) ) . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } | |||
} | } | ||
ORDER BY ?personLabel ?date | |||
</sparql> | </sparql> | ||
=== | === Counting Dates=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# count distinct dates for women (who have at least one) | |||
# uncomment HAVING line for women with only one | |||
# CAVEAT: there may be some discrepancies between dates shown on wiki pages and dates returned by sparql | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 3,794: | Line 4,045: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
PREFIX | PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> | ||
PREFIX | PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | ||
SELECT ?person ?personLabel | SELECT ?person ?personLabel (COUNT(DISTINCT ?date_value) as ?count) | ||
WHERE { | |||
{ # main dates | |||
?person bnwdt:P3 bnwd:Q3 . # women | |||
?person ?p ?s . | |||
?s ?date_prop ?wdv . | |||
?wdv wikibase:timeValue ?date_value . | |||
} # /main dates | |||
UNION | |||
{ # FIXME? qualifier dates. hmm... how is this different from above? I think something is missing. | |||
?person bnwdt:P3 bnwd:Q3 . | |||
?person ?p ?s . | |||
?s ?date_prop ?pqv . | |||
?pqv wikibase:timeValue ?date_value. | |||
} # /qual dates | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". } | |||
} # /where | |||
GROUP BY ?person ?personLabel | |||
# HAVING(?count=1) | |||
ORDER BY ?count ?person | |||
ORDER BY | |||
</sparql> | </sparql> | ||
=== | === Start dates that might not have accompanying end dates === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | #title:Women with start dates that might not have accompanying end dates | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 3,850: | Line 4,093: | ||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | ||
SELECT distinct ? | SELECT distinct ?personLabel ?prop_label ?start_date (if(bound(?end_date), "yes", "no") as ?has_end_date) ?person ?s | ||
#(group_concat(?other_date_label; SEPARATOR=" | ") as ?other_dates) | |||
# | WHERE { | ||
#? | ?person bnwdt:P3 bnwd:Q3 . | ||
# need to find start times anywhere and get prop label so use claim. | |||
?person ?p ?s . | |||
?claim wikibase:claim ?p; | |||
rdfs:label ?prop_label. filter(lang(?prop_label)="en") . | |||
# pretty sure start time is qualifier only... | |||
# get start dates | |||
# then optional end dates | |||
# can only see end time/pit associated, and the only pit with start time is not relevant, but can't be sure that'll always be true. | |||
# optional other that excludes both start/end but lists any other date types | |||
?s bnpq:P27 ?start_date . # get start dates | |||
optional {?s bnpq:P28 ?end_date .} # check for end dates | |||
## | # optional { | ||
# | # ?s ?pq ?other_date . # could there be any other associated dates? | ||
# | # ?qual_prop wikibase:qualifier ?pq; | ||
# wikibase:propertyType wikibase:Time ; # nb *does not* include edtf dates but AFAICT there are none in qualifiers. | |||
# | # rdfs:label ?other_date_label . filter(lang(?other_date_label)="en-gb") . # what kind of date is it. | ||
# | |||
# drop both start and end this time. idk if there could be a faster way to do this? | |||
# filter not exists { ?s (bnpq:P27 | bnpq:P28) ?other_date . } | |||
# } # / optional other dates | |||
# filter(!bound(?end_date)). # to filter out rows with an end date | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". } | |||
} | |||
ORDER BY ?personLabel ?prop_label ?start_date | |||
</sparql> | </sparql> | ||
=== | |||
=== End dates that might not accompanying start dates === | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title:Women with end dates that might not have accompanying start dates | |||
# | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 3,899: | Line 4,150: | ||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | ||
SELECT | SELECT distinct ?personLabel ?prop_label ?end_date | ||
(if(bound(?start_date), "yes", "no") as ?has_start_date) | |||
(group_concat(?other_date_label; SEPARATOR=" | ") as ?other_dates) | |||
?person ?s | |||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 . | |||
?person ?p ?s . | |||
?claim wikibase:claim ?p; | |||
rdfs:label ?prop_label. filter(lang(?prop_label)="en") . | |||
# get end dates | |||
# then optional start dates | |||
# can only see start time/pit associated, and in fact the only pit with start time is not relevant, but can't be sure that'll always be true. | |||
# so an optional other that excludes both start/end but lists any other date types with group_concat | |||
?s bnpq:P28 ?end_date . # get end dates | |||
optional {?s bnpq:P27 ?start_date .} # check for start dates | |||
optional { | |||
?s ?pq ?other_date . # could there be any other associated dates? | |||
?qual_prop wikibase:qualifier ?pq; | |||
wikibase:propertyType wikibase:Time ; # nb *does not* include edtf dates but AFAICT there are none in qualifiers. | |||
rdfs:label ?other_date_label . filter(lang(?other_date_label)="en-gb") . # what kind of date | |||
# drop both start and end. idk if there could be a faster way to do this? | |||
filter not exists { ?s (bnpq:P27 | bnpq:P28) ?other_date . } | |||
} # / optional other dates | |||
# filter(!bound(?start_date)). # to filter out rows with a start date (77 atm) | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". } | |||
} | |||
group by ?personLabel ?prop_label ?end_date ?start_date ?has_start_date ?person ?s | |||
ORDER BY ?personLabel ?prop_label ?end_date | |||
</sparql> | </sparql> | ||
=== | === Women having children === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# | #title:women having children | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 3,936: | Line 4,203: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
# lol defaultView:Timeline{"hide":["?s", "?date_prec", ""]} | |||
# | # P131 had child in / P45 child | ||
# a handful of P45 named children don't have dob though probably have dob in wikidata | |||
SELECT distinct ?person ?personLabel ?childLabel ?date_value ?date_prec ?had_child_edtf ?note | |||
{ | ?s | ||
where { | |||
? | |||
?person bnwdt:P3 bnwd:Q3 . # select women | |||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | |||
# | { | ||
?s ? | # had child in (unnamed children) | ||
? | ?person bnp:P131 ?s . | ||
wikibase: | ?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. | ||
# get dates detail via ?s and psv | |||
# gets edtf dates in std wiki date format | |||
# https://github.com/ProfessionalWiki/WikibaseEdtf | |||
?s ?psv ?wdv . | |||
?wdv wikibase:timeValue ?date_value . | |||
?wdv wikibase:timePrecision ?date_prec . | |||
# filter edtf date. | |||
FILTER ( datatype(?had_child_edtf) = xsd:edtf ) . #shows only the raw EDTF string from the query results | |||
# interesting, when you put this after wikibase:timeValue it seems to get every timey-wimey statement for women who have had child in ? (but only one) | |||
#?person bnwdt:P131 ?had_child . | |||
# not much added in quals for had child. only maybe note P47. some have sourcing circumstances. | |||
optional { ?s bnpq:P47 ?note . } # | |||
} | |||
union | |||
} | |||
{ | { | ||
# named children (are any in both sections??? from dates looks possible a couple might be [wherry / hodgson]) | |||
?person bnp:P45 ?s. | |||
?s bnps:P45 ?child . | |||
optional { ?child bnp:P26 ?ss . | |||
?ss bnps:P26 ?dob . | |||
?ss ?psv ?wdv . | |||
?wdv wikibase:timeValue ?date_value . | |||
?wdv wikibase:timePrecision ?date_prec . | |||
} | |||
} | } | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | } | ||
order by ?person ?date_value | |||
</sparql> | </sparql> | ||
=== Women who were adults in 1911 === | |||
=== Women | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title:Women who were adults in 1911 and their calculated ages | |||
# | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 4,000: | Line 4,268: | ||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | ||
SELECT distinct ?person ?personLabel | SELECT distinct ?person ?personLabel ?statements ?dob ?dod ?age1911 | ||
WHERE { | WHERE { | ||
?person bnwdt:P3 bnwd:Q3 ; | |||
wikibase:statements ?statements . | |||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} | |||
?person bnwdt:P26 ?dob . | |||
?person bnwdt: | #optional { | ||
?person bnwdt:P15 ?dod . | |||
#} | |||
filter(year(?dod) > 1911 && year(?dob) <=1893 ) . | |||
#if dod is made optional a more complex filter to include some women who were likely to still be alive in 1911. but doesnt add very many. | |||
#filter( ( year(?dob) <= 1893 && year(?dod) > 1911 ) || ( year(?dob) <= 1893 && year(?dob) >1870 ) ) . | |||
< | |||
# | |||
< | |||
#Date literals can be written by adding ^^xsd:dateTime to an ISO 8601 date string: "2012-10-29"^^xsd:dateTime | |||
bind(year("1911-07-01"^^xsd:dateTime) - year(?dob) as ?age1911 ). | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | } | ||
ORDER BY ?personLabel | |||
</sparql> | </sparql> |
edits