|
|
(10 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 552: |
Line 554: |
| </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> |
|
| |
|
| == Professional Activities and Organisations == | | == Professional Activities and Organisations == |
Line 810: |
Line 873: |
| <sparql tryit="1"> | | <sparql tryit="1"> |
| #title:initial query for suffrage activities | | #title:initial query for suffrage activities |
| | |
| 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 819: |
Line 883: |
|
| |
|
| SELECT distinct ?person ?personLabel ?mainLabel ?sub_Label ?qualLabel ?locationLabel ?date | | SELECT distinct ?person ?personLabel ?mainLabel ?sub_Label ?qualLabel ?locationLabel ?date |
| # ?pq ?sub_ ?qual ?main ?qual_dateLabel | | # ?pq ?sub_ ?qual ?main |
| ?s | | ?s |
|
| |
|
Line 833: |
Line 897: |
| ?main wikibase:statementProperty ?sub. | | ?main wikibase:statementProperty ?sub. |
| | | |
| # sub_ i/o and yes some do have suffrage activity | | # sub_ i/o - some do have suffrage activity |
| # optional { ?sub_ bnwdt:P12 ?sub_io . ?sub_ bnwdt:P12 bnwd:Q1166 . } | | # optional { ?sub_ bnwdt:P12 ?sub_io . ?sub_ bnwdt:P12 bnwd:Q1166 . } |
| | | |
| { | | # union |
| | { |
| # a qualifier (anywhere) has i/o suffrage activity | | # a qualifier (anywhere) has i/o suffrage activity |
| ?s bnpq:P12 bnwd:Q1166. | | ?s bnpq:P12 bnwd:Q1166. |
| optional { ?s bnpq:P78 ?qual .}
| |
| } | | } |
| # what about a main rather than qualifier having i/o suffrage activity? i don't think there are any atm but could be.
| | |
| | # what about a main rather than qualifier having i/o suffrage activity? i don't think there are any atm but could be. |
| # union | | # union |
| # { # this might find extra linked i/o suffrage but i'm not sure it works. | | # { # this might find extra linked i/o suffrage but i'm not sure it works. |
| # ?sub_ bnwdt:P12 bnwd:Q1166 . | | # ?sub_ bnwdt:P12 bnwd:Q1166 . |
| # } | | # } |
| | |
| union | | union |
| { | | { |
| # does *not* have i/o suffrage activity in any qualifiers ... | | # 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. } | | #filter not exists { ?s bnpq:P12 bnwd:Q1166. } |
| | | |
| # ... but a qualifier *does* have i/o suffrage activity. i think! | | # ... but a qualifier *does* have i/o suffrage activity. i think! |
| ?s ?pq ?qual . | | ?s ?pq ?qual . |
| ?qual bnwdt:P12 bnwd:Q1166 . | | ?qual bnwdt:P12 bnwd:Q1166 . |
| } | | |
| | } # /union |
| | | |
| optional { | | optional { |
| # date qualifiers. [assumes no edtf in quals. ] all seem to be p.i.t. ? | | # date qualifiers. [assumes no edtf in quals. ] all seem to be p.i.t. |
| ?s ?dpq ?date . | | ?s ?dpq ?date . |
| ?qual_date wikibase:qualifier ?dpq . | | ?qual_date wikibase:qualifier ?dpq . |
| ?qual_date wikibase:propertyType wikibase:Time. | | ?qual_date wikibase:propertyType wikibase:Time. |
| } | | } |
| | |
| | optional { ?s bnpq:P78 ?of. } # outside the union seems much speedier |
| | | |
| optional { ?s bnpq:P2 ?location . } | | optional { ?s bnpq:P2 ?location . } |
Line 3,501: |
Line 3,570: |
| </sparql> | | </sparql> |
|
| |
|
| | |
| | === One woman === |
| | |
| | <sparql tryit="1"> |
| | |
| | #title:All About a Woman |
| | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> |
| | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> |
| | PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/> |
| | PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> |
| | PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/> |
| | PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> |
| | PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> |
| | PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> |
| | PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> |
| | |
| | SELECT distinct ?propLabel ?spsLabel ?qual_propLabel ?pqsLabel ?link ?s |
| | # ?main_date ?main_precision ?qual_date ?qual_precision |
| | # ?prop ?sps ?pqs ?pq |
| | |
| | WHERE |
| | { |
| | VALUES (?person) {(bnwd:Q569)} # add (bnwd:Qxxx) if you want more than one person. |
| | ?person ?p ?s . |
| | |
| | ?prop wikibase:claim ?p; |
| | wikibase:statementProperty ?ps; # simple value |
| | wikibase:statementValue ?psv. # full value |
| | |
| | # exclude external IDs |
| | # filter not exists { ?prop wikibase:propertyType wikibase:ExternalId . } |
| | |
| | ?s ?ps ?sps. |
| | |
| | # full date via ?psv |
| | OPTIONAL { |
| | ?s ?psv ?spsv . |
| | ?spsv wikibase:timeValue ?main_date . |
| | ?spsv wikibase:timePrecision ?main_precision . |
| | } |
| | |
| | # qualifiers. |
| | |
| | optional { |
| | ?s ?pq ?pqs . |
| | ?qual_prop wikibase:qualifier ?pq . |
| | ?qual_prop wikibase:qualifierValue ?pqp . |
| | |
| | optional { |
| | # full date via ?pqp |
| | ?s ?pqp ?qv . |
| | ?qv wikibase:timeValue ?qual_date. |
| | ?qv wikibase:timePrecision ?qual_precision. |
| | } |
| | } |
| | |
| | # direct link to property |
| | BIND (REPLACE(STR(?prop), "^.*/([^/]*)$", "$1") as ?pid). |
| | bind(iri(concat(str(?person), "#", ?pid)) as ?link ) . |
| | |
| | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } |
| | |
| | } |
| | order by ?propLabel ?s |
| | |
| | </sparql> |
|
| |
|
| ===Working with property paths: organisations and locations=== | | ===Working with property paths: organisations and locations=== |
Line 3,971: |
Line 4,106: |
|
| |
|
| order by ?person ?date_value | | order by ?person ?date_value |
| </sparql>
| |
|
| |
| ==Admin==
| |
|
| |
| ===Women about whom we have recorded fewer than 3 pieces of information===
| |
|
| |
| <sparql tryit="1">
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
|
| |
| SELECT ?person ?personLabel ?statements WHERE {
| |
| ?person bnwdt:P3 bnwd:Q3 ;
| |
| wikibase:statements ?statements .
| |
| FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}
| |
| FILTER (?statements <3)
| |
| SERVICE wikibase:label {
| |
| bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
| |
| }
| |
| }
| |
| </sparql>
| |
|
| |
| ===People for whom their item records is given as 'Mrs'===
| |
|
| |
| <sparql tryit="1">
| |
| SELECT ?id ?name
| |
| WHERE {
| |
| ?id rdfs:label ?name .
| |
| FILTER regex(?name, "mrs *", "i") #this line uses regular expression syntax, described at https://regexper.com/#mrs%5Cs*
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
| |
| }
| |
| </sparql>
| |
|
| |
| ===All triples in the wiki, limited to 1000===
| |
|
| |
| <sparql tryit="1">
| |
| SELECT ?a ?aLabel ?b ?c WHERE {
| |
| ?a ?b ?c
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
| |
| }
| |
| LIMIT 1000 #please don't make this number too big as it will slow down the site!
| |
| </sparql>
| |
|
| |
| ===All triples in the wiki, represented as a crude graph===
| |
|
| |
| <sparql tryit="1">
| |
| #defaultView:Graph
| |
| SELECT ?a ?aLabel ?c ?cLabel WHERE {
| |
| ?a ?b ?c
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
| |
| }
| |
| #note query returns every connection in the wikibase so it may fall over!
| |
| </sparql>
| |
|
| |
| ===People whose assigned gender we have been unable to determine and/or confirm===
| |
|
| |
| <sparql tryit="1">
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
| PREFIX wdt: <http://www.wikidata.org/prop/direct/>
| |
| PREFIX wd: <http://www.wikidata.org/entity/>
| |
|
| |
| SELECT ?person ?personLabel
| |
| WHERE {
| |
| ?person bnwdt:P3 ?gender .
| |
| FILTER NOT EXISTS {?person bnwdt:P3 bnwd:Q3 .} #filter out people identified as women
| |
| FILTER NOT EXISTS {?person bnwdt:P3 bnwd:Q10 .} #filter out people identified as men
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
| |
| }
| |
| ORDER BY ?personLabel
| |
| </sparql>
| |
|
| |
| ===People who have a spouse statement and - optionally - marriage date statements for checking if there is any misalignment with 'Spouse not in wikibase' statements===
| |
|
| |
| <sparql tryit="1">
| |
| # people who have a spouse statement and - optionally - marriage date statements for checking if there is any misalignment with 'Spouse not in wikibase' statements
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
|
| |
| SELECT ?person ?personLabel ?spouse ?spouseLabel ?edtfmarriagespouse ?edtfmarriagespouseLabel ?PITmarriagespouse ?PITmarriagespouseLabel WHERE {
| |
| ?person bnwdt:P41 ?spouse .
| |
| OPTIONAL {?person bnp:P132 ?edtfmarriagestatement .
| |
| ?edtfmarriagestatement bnps:P132 ?edtfmarriagedate .
| |
| ?edtfmarriagestatement bnpq:P41 ?edtfmarriagespouse .}
| |
| OPTIONAL {?person bnp:P130 ?PITmarriagestatement .
| |
| ?PITmarriagestatement bnps:P130 ?PITmarriagedate .
| |
| ?PITmarriagestatement bnpq:P41 ?PITmarriagespouse .}
| |
| SERVICE wikibase:label {
| |
| bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
| |
| }
| |
| }
| |
| ORDER BY DESC(?edtfmarriagespouseLabel) DESC(?PITmarriagespouseLabel)
| |
| </sparql>
| |
|
| |
| === Compare uses of item v free text ===
| |
|
| |
| <sparql tryit="1">
| |
| # A number of properties have "item" and "free text" versions; a query to fetches both versions in each case to facilitate comparison of their uses.
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
| PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
| |
| PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
| |
|
| |
| SELECT distinct ?itemLabel ?prop_label ?qual_label ?qual_value ?qual_valueLabel ?item ?qual_prop
| |
|
| |
| # most of these are used in qualifiers - only P72, P71 and P88 found in main (and only a handful of uses of free text?)
| |
| #?item ( bnp:P88|bnp:P91 | bnp:P72|bnp:P71) ?s .
| |
|
| |
| ## the pairs
| |
| #P21 evidence (free text) / P20 evidence (item)
| |
| #P79 item exhibited / P80 item exhibited (free text)
| |
| #P78 of / P66 of (free text)
| |
| #P91 specific reference information / P88 specific reference information (free text)
| |
| #P31 street address (free text) / P100 street address (item)
| |
| #P72 was delegate at (free text) / P71 was delegate at (item)
| |
|
| |
| WHERE {
| |
|
| |
| ?item ?p ?s .
| |
|
| |
| ?prop wikibase:claim ?p;
| |
| rdfs:label ?prop_label. filter(lang(?prop_label)="en-gb") .
| |
|
| |
| ?s ( bnpq:P21|bnpq:P20 | bnpq:P80|bnpq:P79 | bnpq:P66|bnpq:P78 | bnpq:P88|bnpq:P91 | bnpq:P31|bnpq:P100 | bnpq:P72|bnpq:P71 ) ?qual_value .
| |
|
| |
| ?s ?qual_p ?qual_value .
| |
| ?qual_prop wikibase:qualifier ?qual_p;
| |
| wikibase:propertyType ?qual_prop_type ;
| |
| rdfs:label ?qual_label. filter(lang(?qual_label)='en-gb') .
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
| |
| }
| |
| order by ?qual_label ?prop_label ?itemLabel
| |
|
| |
| </sparql>
| |
|
| |
| === Missing language labels ===
| |
|
| |
| <sparql tryit="1">
| |
|
| |
| # query to check for any items/properties which don't have "en" labels. [currently not an issue but retained for reference.]
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
| PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
| |
| PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
| |
|
| |
| SELECT
| |
| ?item ?itemLabel
| |
| (group_concat(distinct ?language) as ?languages)
| |
| (count(distinct ?rdfs_label) as ?count) # TIL: where you put distinct matters!
| |
|
| |
| WHERE {
| |
|
| |
| ?item ?p ?s.
| |
| ?item rdfs:label ?rdfs_label . # rdfs item label (1 per language).
| |
|
| |
| BIND(LANG(?rdfs_label) as ?language) . # get 2 letter language codes
| |
|
| |
| #optional { ?item rdfs:label ?engb . filter(lang(?engb)="en-gb"). }
| |
| #optional { ?item rdfs:label ?en . filter(lang(?en)="en"). }
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en-gb, en". }
| |
| }
| |
| group by ?item ?itemLabel
| |
| HAVING (?count<2)
| |
| order by ?item
| |
|
| |
| </sparql>
| |
|
| |
| === Statements that contain both a date *and* an unknown value date===
| |
|
| |
| <sparql tryit="1">
| |
| # A query to look for statements containing an <unknown value> date *and* a date
| |
| # caveat: not yet completely sure if it will work in all cases for main dates
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
|
| |
| SELECT ?item ?itemLabel ?main_label ?qualLabel ?subLabel
| |
| (group_concat(distinct ?date_prop) as ?dates)
| |
| (count (distinct(isBLANK(?t))) as ?tcount)
| |
| ?s
| |
|
| |
| # using isBlank() in select creates true/false, then count distinct finds any in a group having >1.
| |
|
| |
| WHERE
| |
| {
| |
| {
| |
| # qualifiers. [qualifiers need to include ?s in the group by]
| |
| ?item ?p ?s.
| |
|
| |
| # labels
| |
| ?s ?subp ?sub .
| |
| ?qual wikibase:claim ?p;
| |
| wikibase:statementProperty ?subp.
| |
|
| |
| ?s ?pq ?t .
| |
|
| |
| ?date_prop wikibase:qualifier ?pq ;
| |
| wikibase:propertyType ?date_prop_type .
| |
| filter(?date_prop_type in (wikibase:Time, wikibase:Edtf) ).
| |
| }
| |
| UNION
| |
| {
| |
| # main [excluding ?s from group by this time]
| |
| ?item ?p ?sm.
| |
| ?sm ?ps ?t .
| |
|
| |
| ?date_prop wikibase:claim ?p.
| |
| ?date_prop wikibase:statementProperty ?ps.
| |
| ?date_prop wikibase:propertyType ?date_prop_type .
| |
| ?date_prop rdfs:label ?main_label . filter(lang(?main_label)="en-gb") .
| |
|
| |
| filter(?date_prop_type in (wikibase:Time, wikibase:Edtf) ).
| |
| }
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en_gb" }
| |
| }
| |
|
| |
| group by ?item ?itemLabel ?s ?qualLabel ?subLabel ?main_label
| |
| having (?tcount >1 ) # comment out to get everything
| |
|
| |
| ORDER BY ?itemLabel ?main_label ?qualLabel ?subLabel ?date_prop
| |
|
| |
| </sparql>
| |
|
| |
|
| |
| === Women with no dates===
| |
|
| |
| <sparql tryit="1">
| |
|
| |
| # Query for women with no dates
| |
| # WIP: at present this includes <unknown value> dates as well as no dates at all [eg Miss Keyser Q2622]
| |
| # CAVEAT: the WQS bug means there are likely to be some women in results who do, in fact, have at least one date.
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
| PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
| |
| PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
| |
|
| |
| SELECT distinct ?person ?personLabel (count(?date_value) as ?count)
| |
|
| |
| WHERE {
| |
|
| |
| { # main dates
| |
|
| |
| ?person bnwdt:P3 bnwd:Q3 . # women
| |
| optional {
| |
| ?person ?p ?s .
| |
| ?s ?date_prop ?wdv .
| |
| ?wdv wikibase:timeValue ?date_value . }
| |
|
| |
| } # /main dates
| |
|
| |
| UNION
| |
|
| |
| { # qualifier dates
| |
|
| |
| ?person bnwdt:P3 bnwd:Q3 .
| |
| optional {
| |
| ?person ?p ?s .
| |
| ?s ?date_prop ?pqv .
| |
| ?pqv wikibase:timeValue ?date_value. }
| |
|
| |
| } # /qual dates
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". }
| |
|
| |
| } # /where
| |
| group by ?person ?personLabel
| |
| having (?count=0)
| |
| ORDER BY ?person
| |
|
| |
| </sparql>
| |
|
| |
|
| |
| === Women with more than X statements but no date of birth/death===
| |
|
| |
| <sparql tryit="1">
| |
|
| |
| #title:women with n>X statements but no date of birth/death
| |
| # CAVEAT this currently finds some women who do in fact have dates, because of WQS bug
| |
| # updated to add extra info
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
|
| |
|
| |
| SELECT distinct ?person ?personLabel ?statements ?dob ?dod
| |
| (if(bound(?SALproposed), "yes", "") as ?FSA)
| |
| (if(bound(?RAIproposed), "yes", "") as ?RAI)
| |
| (if(bound(?resided), "yes", "") as ?residence)
| |
| (if(bound(?main_date), "yes", "") as ?other_maindate)
| |
| (if(bound(?qual_d), "yes", "") as ?qual_date)
| |
|
| |
| WHERE {
| |
| ?person bnwdt:P3 bnwd:Q3 ;
| |
| wikibase:statements ?statements .
| |
| FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}
| |
|
| |
| optional { ?person bnwdt:P15 ?dod . }
| |
| optional { ?person bnwdt:P26 ?dob . }
| |
|
| |
| optional { # was elected FSA. comment out optional lines to get FSAs only...
| |
| ?person bnp:P16 ?s .
| |
| ?s bnps:P16 ?SALproposed .
| |
| ?s bnpq:P22 bnwd:Q36 . # successful Q36. will you end up with 2 rows if there's a successful and unsuccessful?
| |
| } #/optional fsa
| |
|
| |
| optional { # was elected RAI. only one unsuccessful, so just ignore that bit.
| |
| ?person bnwdt:P7 ?RAIproposed .
| |
| }
| |
|
| |
| optional { ?person bnwdt:P29 ?resided . } # place of residence
| |
|
| |
| optional {
| |
| # main dates, apart from birth and death: P133 (widowed) P132 (married edtf) P131 (had child) P130 (married pit)
| |
| ?person ( bnwdt:P130 | bnwdt:P131 | bnwdt:P132 | bnwdt:P133 ) ?main_date .
| |
| } # /optional main dates
| |
|
| |
| optional {
| |
| # qualifier dates
| |
| ?person ?p ?s .
| |
| ?s ?date_prop ?pqv .
| |
| ?pqv wikibase:timeValue ?qual_d.
| |
| } #/ optional qual dates
| |
|
| |
| FILTER (?statements >10) . # can adjust n statements here...
| |
|
| |
| FILTER (NOT EXISTS { ?person bnwdt:P15 ?dod .} || NOT EXISTS { ?person bnwdt:P26 ?dob . } ) . # EITHER no date of birth OR no date of death. or swap with following line...
| |
| #FILTER (NOT EXISTS { ?person bnwdt:P15 ?dod .} && NOT EXISTS { ?person bnwdt:P26 ?dob . } ) . # no date of birth AND no date of death
| |
|
| |
| SERVICE wikibase:label {
| |
| bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
| |
| }
| |
| }
| |
| order by ?personLabel
| |
|
| |
| </sparql>
| |
|
| |
| === Places of residence that lack instance of locality===
| |
|
| |
| <sparql tryit="1">
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
|
| |
| SELECT distinct ?residence ?residenceLabel ?inst ?instLabel
| |
| WHERE {
| |
| ?resident bnwdt:P29 ?residence . # resided at
| |
| filter not exists { ?residence bnwdt:P12 bnwd:Q2147 . } # that doesn't have instance of locality
| |
|
| |
| optional {?residence bnwdt:P12 ?inst .} # does it have instance of anything?
| |
| ## Note: some have Q618 territory of the British Empire, which also lacks any instance of at present
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
| |
| }
| |
| ORDER BY ?residenceLabel
| |
| </sparql>
| |
|
| |
| === Locations that don't have Wikidata links or their Wikidata pages lack geocoordinates===
| |
|
| |
| <sparql tryit="1">
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
|
| |
|
| |
| SELECT distinct ?locationLabel ?location ?wikidata ?wd_geo ?instanceLabel ?bn_geo
| |
| WHERE {
| |
|
| |
| {?item bnwdt:P29 ?location . } # resided at
| |
| union
| |
| {?location bnwdt:P12 bnwd:Q2147 .} # OR has instance of locality
| |
| union
| |
| {?item bnwdt:P2 ?location . } # OR location P2
| |
| # any other possibles ?
| |
|
| |
| optional { ?location bnwdt:P12 ?instance . } # check instance of
| |
|
| |
| optional {
| |
| ?location bnwdt:P117 ?ws . # wikidata id
| |
|
| |
| bind(iri(concat("http://www.wikidata.org/entity/", str(?ws))) as ?wikidata) .
| |
|
| |
|
| |
| SERVICE <https://query.wikidata.org/sparql> {
| |
| optional {?wikidata wdt:P625 ?wd_geo .} # does the wikidata page have geocoords?
| |
| } # /wikidata service
| |
| } #/wikidata optional
| |
|
| |
| filter (!bound(?wd_geo) ). # no geocoords in wikidata. some may have coords in BN...
| |
|
| |
| optional { ?location bnwdt:P153 ?bn_geo . } # so check for coords in BN
| |
| ##filter (!bound(?bn_geo)) . # uncomment to filter those out as well
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
| |
| }
| |
| ORDER BY ?wikidata ?locationLabel
| |
|
| |
| </sparql>
| |
|
| |
| === Archaeological sites that don't have National Heritage England list numbers ===
| |
|
| |
| <sparql tryit="1">
| |
| #title:archaeological sites without National Heritage numbers
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
|
| |
| SELECT ?item ?itemLabel ?location ?locationLabel
| |
| (if(bound(?locEngland), "yes", "") as ?inEngland)
| |
|
| |
| WHERE {
| |
| ?item bnwdt:P12 bnwd:Q86 . # item instance of archaeological site
| |
|
| |
| filter not exists {?item bnwdt:P129 ?thing . } # without NH list number
| |
|
| |
| optional { ?item bnwdt:P2 ?location . } # location if it has one
| |
| optional { ?item bnwdt:P2 ?locEngland .
| |
| ?locEngland bnwdt:P33+ bnwd:Q617.
| |
| } # is the location in England
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
| |
| }
| |
|
| |
| order by ?itemLabel
| |
|
| |
| </sparql>
| |
|
| |
| === Date of latest edit for every item, according to WQS ===
| |
|
| |
| <sparql tryit="1">
| |
| #title:latest edits dates for wikibase items
| |
|
| |
| ## because of WQS disappearing data bugs this may not always match the latest edit in the page history
| |
|
| |
| SELECT ?item ?date ?dateLabel
| |
| WHERE {
| |
| ?item wikibase:timestamp ?date .
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
| |
| }
| |
| order by ?date
| |
|
| |
| </sparql>
| |
|
| |
| === Wikidata ID is a URL ===
| |
|
| |
| <sparql tryit="1">
| |
|
| |
| #title:check for accidental use of URL instead of wikidata ID
| |
| ## all checked and fixed at 18/12/23 but adding the query in case it recurs
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
|
| |
|
| |
| SELECT distinct ?item ?itemLabel ?wd_http
| |
| WHERE {
| |
|
| |
| ?item bnwdt:P117 ?wd_http . # wikidata id
| |
|
| |
| filter(strstarts(str(?wd_http), "http")).
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
| |
| }
| |
| ORDER BY ?itemLabel
| |
| </sparql>
| |
|
| |
| === Wikidata URL is not a URL ===
| |
|
| |
| <sparql tryit="1">
| |
| #title:check for wikidata URLs that don't start with http. could still be other problems!
| |
| ## all checked and fixed at 18/12/23 but adding the query in case of any recurring issues
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
|
| |
|
| |
| SELECT distinct ?item ?itemLabel ?wd_url
| |
| WHERE {
| |
|
| |
| ?item bnp:P117 ?ws . # wikidata id
| |
| ?ws bnpq:P14 ?wd_url .
| |
| filter(!strstarts(str(?wd_url), "http")).
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
| |
| }
| |
| ORDER BY ?itemLabel
| |
| </sparql>
| |
|
| |
| === Oxford and Cambridge academic degrees potential date problems ===
| |
|
| |
| <sparql tryit="1">
| |
| #title:academic degree Oxford/Cambridge date issues
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
| PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
| |
|
| |
| SELECT distinct ?personLabel ?degreeLabel ?byLabel ?subjectLabel
| |
| ?date ?date_label ?s ?person #?subject ?degree ?by ?university
| |
|
| |
| WHERE {
| |
| ?person bnwdt:P3 bnwd:Q3 . #select women
| |
|
| |
| # academic degree = P59.
| |
| ?person bnp:P59 ?s .
| |
| ?s bnps:P59 ?degree . # type of degree
| |
|
| |
| # optional qualifiers for degree
| |
|
| |
| # P60 subject
| |
| optional { ?s bnpq:P60 ?subject}
| |
|
| |
| # P61 conferred by
| |
| ?s bnpq:P61 ?by .
| |
|
| |
| # date with type
| |
| ?s ?pq ?date .
| |
| ?qual_prop wikibase:qualifier ?pq;
| |
| wikibase:propertyType wikibase:Time ; # nb excludes edtf dates
| |
| rdfs:label ?date_label . filter(lang(?date_label)="en") . # what kind of date is it.
| |
|
| |
| # filter: (cambridge (Q1181) and before 1948) OR (oxford (Q364) and before 1920)
| |
|
| |
| filter( ( year(?date)<1920 && ?by=bnwd:Q364 ) || ( year(?date)<1948 && ?by=bnwd:Q1181 ) )
| |
|
| |
|
| |
| SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".}
| |
| }
| |
| order by ?byLabel ?personLabel ?date ?degreeLabel
| |
| </sparql>
| |
|
| |
| === Position held: item v free text ===
| |
|
| |
| <sparql tryit="1">
| |
| # held position job titles item v held position free text
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
| PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
| |
| PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
| |
|
| |
| SELECT
| |
| ?work_label ?positionLabel ?position (count(*) as ?count)
| |
|
| |
| WHERE {
| |
|
| |
| ?person bnwdt:P3 bnwd:Q3 . # women
| |
|
| |
| # get work activities: held position / held position (free text) / employed as
| |
| ?person ( bnp:P17|bnp:P48 ) ?s .
| |
|
| |
| ?person ?work_p ?s . # for work type label
| |
| ?work wikibase:claim ?work_p;
| |
| rdfs:label ?work_label. filter(lang(?work_label)="en") .
| |
|
| |
| # more about the position
| |
| ?s ( bnps:P17|bnps:P48 ) ?position .
| |
|
| |
| FILTER( !isBLANK(?position) ) . # filter out <unknown value>
| |
|
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
| |
| }
| |
| group by ?work_label ?positionLabel ?position
| |
| order by lcase(str(?positionLabel))
| |
| </sparql>
| |
|
| |
| ==== Women with position held free text ====
| |
|
| |
| <sparql tryit="1">
| |
| # held position free text job titles
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
| PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
| |
| PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
| |
|
| |
| SELECT ?person ?personLabel ?positionLabel
| |
|
| |
| WHERE {
| |
|
| |
| ?person bnwdt:P3 bnwd:Q3 . # women
| |
|
| |
| # held position (free text)
| |
| ?person bnwdt:P48 ?position .
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
| |
| }
| |
| order by ?personLabel ?positionLabel
| |
| </sparql>
| |
|
| |
| === Questions ===
| |
|
| |
| <sparql tryit="1">
| |
|
| |
| #title:asking questions
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
| PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/>
| |
| PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
| |
|
| |
|
| |
| SELECT ?personLabel ?propLabel ?link ?question
| |
|
| |
| WHERE {
| |
| ?person bnwdt:P3 bnwd:Q3 .
| |
|
| |
| ?person ?p ?s .
| |
| ?prop wikibase:claim ?p;
| |
| wikibase:statementProperty ?ps.
| |
|
| |
| # direct link to relevant part of page
| |
| BIND (REPLACE(STR(?prop), "^.*/([^/]*)$", "$1") as ?pid).
| |
| bind(iri(concat(str(?person), "#", ?pid)) as ?link ) .
| |
|
| |
| # the question
| |
| ?s bnpq:P157 ?question .
| |
|
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
| |
| }
| |
|
| |
| order by ?personLabel
| |
| </sparql>
| |
|
| |
| ==Tools for batch processing and quality assurance work==
| |
|
| |
| ===All people (by assigned gender), filtering out those already listed as instance of human===
| |
|
| |
| <sparql tryit="1">
| |
| # All people (by assigned gender), filtering out those already listed as instance of human
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
| PREFIX wdt: <http://www.wikidata.org/prop/direct/>
| |
| PREFIX wd: <http://www.wikidata.org/entity/>
| |
|
| |
| SELECT ?person ?personLabel ?assigned_genderLabel
| |
| WHERE {
| |
| ?person bnwdt:P3 ?assigned_gender . #select person
| |
| FILTER NOT EXISTS {?person bnwdt:P12 bnwd:Q2137 .} #filter out people already listed as instance of human
| |
| FILTER NOT EXISTS {?person bnwdt:P12 bnwd:Q12 .} #filter out project team
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
| |
| }
| |
| ORDER BY ?personLabel
| |
| </sparql>
| |
|
| |
| ===All places (by coordinate location on wikidata), filtering out places already listed as instance of locality===
| |
|
| |
| <sparql tryit="1">
| |
| # All places (by coordinate location on wikidata), filtering out places already listed as instance of locality
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
| PREFIX wdt: <http://www.wikidata.org/prop/direct/>
| |
| PREFIX wd: <http://www.wikidata.org/entity/>
| |
| PREFIX p: <http://www.wikidata.org/prop/>
| |
| PREFIX pr: <http://www.wikidata.org/prop/reference/>
| |
| PREFIX prov: <http://www.w3.org/ns/prov#>
| |
|
| |
| SELECT ?place ?placeLabel ?WDitem ?WDcoordinate_location
| |
|
| |
| WHERE {
| |
| ?place bnwdt:P33 ?admin_area . #select items with 'located in the administrative territorial entity' statements
| |
| ?place bnwdt:P117 ?Qnumber . #get wikidata ID
| |
| FILTER NOT EXISTS {?place bnwdt:P12 bnwd:Q2147 .} #filter out places already listed as instance of locality
| |
|
| |
| #create reference to Wikibase entity
| |
| BIND(IRI(concat("http://www.wikidata.org/entity/", ?Qnumber)) as ?WDitem )
| |
| #on Wikibase do
| |
| SERVICE <https://query.wikidata.org/sparql> {
| |
| ?WDitem wdt:P625 ?WDcoordinate_location . #get coordinate location on wikidata
| |
| }
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
| |
| }
| |
| GROUP BY ?place ?placeLabel ?WDitem ?WDcoordinate_location
| |
| ORDER BY ?placeLabel
| |
| </sparql>
| |
|
| |
| ===All items without a P12 (instance of) triple===
| |
|
| |
| <sparql tryit="1">
| |
| #title:nearly all items without P12 (instance of)
| |
| #NB: the query will only find items that have at least one statement; this excludes a small number of Qs and a larger number (~35) of Ps.
| |
| #see separate query to find items without any statements
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
|
| |
| SELECT distinct ?item ?itemLabel
| |
| WHERE {
| |
| ?item ?b ?c .
| |
| ?prop wikibase:claim ?b;
| |
| wikibase:statementProperty ?ps.
| |
| # ?prop wikibase:propertyType wikibase:WikibaseItem. # limit to P & Q Items. not necessary; only the claim is needed.
| |
| # weirdness: it still causes some things that are definitely WikibaseItem to be dropped and idk why.
| |
|
| |
| FILTER NOT EXISTS {?item bnwdt:P12 ?instance .}
| |
|
| |
| ## FILTER(STRSTARTS(STR(?item), "https://beyond-notability.wikibase.cloud/entity/P")) . # uncomment to limit to P Properties
| |
| ## FILTER(STRSTARTS(STR(?item), "https://beyond-notability.wikibase.cloud/entity/Q")) . # or limit to Q items
| |
|
| |
| SERVICE wikibase:label {
| |
| bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb".
| |
| }
| |
| }
| |
| </sparql>
| |
|
| |
| ===Counts of items for each value of the property "instance of" (P12)===
| |
|
| |
| <sparql tryit="1">
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
|
| |
|
| |
| SELECT ?value ?valueLabel (count(*) as ?count)
| |
| WHERE {
| |
|
| |
| VALUES (?p) { (bnwdt:P12) }
| |
|
| |
| ?s ?p ?value.
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
| |
|
| |
| }
| |
| GROUP BY ?value ?valueLabel
| |
|
| |
| ORDER BY lcase(?valueLabel) # order by is case sensitive
| |
| # or to order by count
| |
| # order by ?count
| |
|
| |
| </sparql>
| |
|
| |
| ===Get all items (with 'instance of' statement) for duplicate checking in OpenRefine===
| |
|
| |
| <sparql tryit="1">
| |
| # Get all items (with 'instance of' statement) for duplicate checking in OpenRefine
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
|
| |
| SELECT ?item ?itemLabel WHERE {
| |
| ?item bnwdt:P12 ?anything .
| |
| SERVICE wikibase:label {
| |
| bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".
| |
| }
| |
| }
| |
|
| |
| ORDER BY ?itemLabel
| |
| </sparql>
| |
|
| |
| ===All uses of <unknown value>===
| |
|
| |
| <sparql tryit="1">
| |
| # Query to look for uses of <unknown value> (now including qualifiers)
| |
|
| |
| PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
| |
| PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
| |
| PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
| |
| PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
| |
| PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
| |
| PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
| |
| PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
| |
|
| |
| SELECT distinct ?item ?itemLabel ?mainLabel ?sub_Label ?unknown_value_forLabel ?unknown_value_for ?t
| |
| WHERE
| |
| {
| |
| {
| |
| # qualifiers
| |
| ?item ?p ?s.
| |
|
| |
| ?s ?sub ?sub_ .
| |
| ?main wikibase:claim ?p.
| |
| ?main wikibase:statementProperty ?sub.
| |
|
| |
| ?s ?pq ?t .
| |
|
| |
| ?unknown_value_for wikibase:qualifier ?pq .
| |
| FILTER( isBLANK(?t) ) . # filter for <unknown value>
| |
| }
| |
| UNION
| |
| {
| |
| # top level
| |
| ?item ?p ?s.
| |
| ?s ?ps ?t .
| |
|
| |
| ?unknown_value_for wikibase:claim ?p.
| |
| ?unknown_value_for wikibase:statementProperty ?ps.
| |
|
| |
| FILTER( isBLANK(?t) ) .
| |
| }
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
| |
|
| |
| }
| |
| ORDER BY ?itemLabel ?unknown_value_forLabel
| |
| </sparql>
| |
|
| |
|
| |
| === Items without any statements ===
| |
|
| |
| <sparql tryit="1">
| |
| #title:items with 0 statements
| |
| # NB: because of the WQS disappearing data bugs, a few of the items might in reality have n>0 statements. Some may be intentionally empty.
| |
|
| |
| SELECT distinct ?item ?itemLabel
| |
| WHERE {
| |
| ?item wikibase:statements 0 .
| |
|
| |
| SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
| |
|
| |
| }
| |
| order by ?item
| |
| </sparql> | | </sparql> |