Project:SPARQL/examples: Difference between revisions

Line 755: Line 755:
</sparql>
</sparql>


=== PPA Buckets ===
=== PPA Buckets for Women ===


<sparql tryit="1">
<sparql tryit="1">
#title:first draft of ppa buckets January 2024
#title:ppa buckets (revised February 2024)
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 786: Line 786:
       ?s ?ps ?ppa_value.
       ?s ?ps ?ppa_value.
    
    
   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",
    bind(
          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 ("attended", "exhibited at", "organiser of", "performed at", "spoke at", "was delegate at (free text)", "was delegate at (item)" ), "events",
            if( str(?ppa_label) in ("educated at"),  "education" ,
        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 ("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 ("educated at"),  "education" ,
                      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 ("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"
),  "fieldwork" ,
),  "fieldwork" ,
                        if( str(?ppa_label) in ("applicant to", "employed as", "held position", "held position (free text)"),  "positions" ,
                if( str(?ppa_label) in ("acknowledged for role", "applicant to", "employed as", "held position", "held position (free text)", "served on"),  "positions" ,
                            if( str(?ppa_label) in ("contributed to", "editor", "illustrated in", "published with", "work(s) published in"),   "publishing" ,
                  if( str(?ppa_label) in ("contributed to", "illustrated in", "work(s) published in"), "publishing",
                              if( str(?ppa_label) in ("served on", "was fellow of", "was member of"),   "societies",
                    if( str(?ppa_label) in ("corresponded with", "was fellow of", "was member of"), "societies",
                                  if( str(?ppa_label) in ("benefactor to", "fundraiser for"),  "charity" ,
                      if( str(?ppa_label) in ("benefactor to", "fundraiser for", "founded"),  "charitable" ,
       "tbd")))))))))
       "none")))))))))
     as ?bucket).
     as ?bucket).
          
          
579

edits