Project:SPARQL/examples: Difference between revisions

SELECT distinct ?person ?personLabel  ?prop ?propLabel  ?pq_value  ?qual_prop_label ?sal  

         ?qual_prop rdfs:label ?qual_prop_label. filter(lang(?qual_prop_label)="en-gb") .  

         ?qual_prop wikibase:propertyType ?qual_prop_type

   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }  

SELECT distinct ?person ?personLabel  ?prop ?propLabel ?prop_type  ?pq_value ?pq_valueLabel ?qual_prop_label ?qual_prop_type ?rai ?s

         ?qual_prop rdfs:label ?qual_prop_label. filter(lang(?qual_prop_label)="en-gb") .  

   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }  

SELECT distinct ?personLabel ?work_label ?positionLabel ?date_label ?date  

?employerLabel ?organisedLabel ?ofLabel  

?s ?person ?work ?position ?employer ?organised ?of

   ?work wikibase:claim ?work_p;     

        rdfs:label ?work_label. filter(lang(?work_label)="en-gb") .   

       ?qual_prop wikibase:qualifier ?pq;       

               wikibase:propertyType wikibase:Time ; # nb *does not* include edtf dates but AFAICT there are none in qualifiers.

               rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # what kind of date is it.

   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }  

 

== Professional Activities and Organisations ==

 

=== Women's service on committees etc (P102) ===

 

SELECT distinct ?personLabel ?serviceLabel ?qual_propLabel ?qualLabel  ?service ?qual ?person #?s

  ?person bnwdt:P3 bnwd:Q3 . # select women

  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team

  ?claim wikibase:claim ?p;     

        wikibase:statementProperty ?ps;

        wikibase:propertyType ?prop_type.  

    ?s ?ps ?service . # service on what

      

  optional { #qualifiers, if any

    ?s ?pq ?qual .    

        ?qual_prop wikibase:qualifier ?pq.    

        SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".  

        ?qual_prop rdfs:label ?qual_propLabel . # what kind of thing

        } # /label service

       } # /quals

=== PPA Buckets ===

#title:first draft of ppa buckets January 2024

         wikibase:statementProperty ?ps.    

                       ?ppa rdfs:label ?ppa_label.       # what kind of thing

  bind(

      if( str(?ppa_label) in ("attended", "exhibited at", "organiser of", "performed at", "spoke at", "was delegate at (free text)", "was delegate at (item)" ), "events",

          if( str(?ppa_label) in ("curated (item)", "donor to", "loaner to", "recovered (free text)", "seller to", "was collector of", "was donor of" ), "collections",

            if( str(?ppa_label) in ("educated at"),  "education" ,

                if( str(?ppa_label) in ("election to Council of CAS proposed by", "election to RAI proposed by", "election to SAL proposed by", "proposed election to RHS signed by (personal)"),  "elections" ,

                      if( str(?ppa_label) in ("Member of Committee for Archaeological Fieldwork", "President of Committee for Archaeological Fieldwork", "director of archaeological fieldwork", "director of expedition", "member of excavation during archaeological fieldwork", "member of expedition", "travelled overseas for"

                        if( str(?ppa_label) in ("applicant to", "employed as", "held position", "held position (free text)"),  "positions" ,

                            if( str(?ppa_label) in ("contributed to", "editor", "illustrated in", "published with", "work(s) published in"),   "publishing" ,

                              if( str(?ppa_label) in ("served on", "was fellow of", "was member of"),   "societies",

                                  if( str(?ppa_label) in ("benefactor to", "fundraiser for"),  "charity" ,

       "tbd")))))))))

==Place==

==People==

 

<sparql tryit="1">

# Women with their family name at birth and family name after marriage

   ?person bnwdt:P3 bnwd:Q3 . #select women

   FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team

   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

=== Women with family name at birth, married name and count of married names===

# Women with their family name at birth, family name after marriage and count of married names

SELECT distinct ?person ?personLabel ?wikidata ?wd_dob ?wd_dod ?odnb_url ?wikipedia ?wd_statements

       ?wikidata  wikibase:statements ?wd_statements .

===Working with property paths: organisations and locations===

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

 

===Women about whom we have recorded fewer than 3 pieces of information===

SELECT ?person ?personLabel ?statements WHERE {

  ?person bnwdt:P3 bnwd:Q3 ;

        wikibase:statements ?statements .

  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .}

      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb".

  }

</sparql>

WHERE {

===All triples in the wiki, limited to 1000===

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!

===All triples in the wiki, represented as a crude graph===

#defaultView:Graph

SELECT ?a ?aLabel ?c ?cLabel WHERE {

    ?a ?b ?c

     SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }

 

 

 

 

 

 

 

 

 

 

 

 

 

order by ?qual_label ?prop_label ?itemLabel

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

SELECT distinct ?person ?personLabel  (count(?date_value) as ?count)