Project:SPARQL/examples: Difference between revisions

From Beyond Notability

Project:SPARQL/examples (view source)

Revision as of 08:21, 13 November 2023

1,982 bytes added ,  1 year ago
→‎BN Men in Wikidata: men who proposed elections to SAL/RAI
Line 2,442: Line 2,442:


<sparql tryit="1">
<sparql tryit="1">
#title:Men who proposed elections of women to SAL or RAI and are in Wikidata
#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 2,478: Line 2,478:
         }   
         }   
        
        
        # 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 2,484: Line 2,485:
        
        
   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
</sparql>
=== BN Men in Wikidata: Spouses ===
<sparql tryit="1">
#title: BN spouses who are in Wikidata
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 ?spouse ?spouseLabel  ?wikidata ?odnb_url ?wikipedia ?wd_dob ?wd_dod
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
ORDER BY  ?proposerLabel
Sharon
3,427

edits

Retrieved from "https://beyond-notability.wikibase.cloud/wiki/Special:MobileDiff/49782"