727
edits
(9 intermediate revisions by the same user not shown) | |||
Line 170: | 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 215: | 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 225: | 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 250: | 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 257: | 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 267: | 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 296: | 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 344: | 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 455: | 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 471: | 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 477: | 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 | ||
edits