Queries

Enghreifftiau o queries a ddefnyddiwyd i dynnu data o'r gronfa / Examples of queries used to extract data from the database

Federated query with Wikidata

1. Occupations from SNARC with additional information on Subclass from Wikidata (Library of congress ID from both)

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX snarcp: <https://snarc-llgc.wikibase.cloud/prop/direct/>
PREFIX snarcq: <https://snarc-llgc.wikibase.cloud/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>


SELECT DISTINCT ?item ?itemLabel ?wikidataid ?libcongid  ?subclas ?subclaslabel ?libcongwikidata WHERE {
     
   ?item snarcp:P45 snarcq:Q63 . 
  ?item snarcp:P62 ?wikidataid .                               
  ?item snarcp:P11 ?libcongid
  
SERVICE <https://query.wikidata.org/sparql>{
  ?wikidataid wdt:P279 ?subclas.
  ?subclas rdfs:label ?subclaslabel .
 FILTER(LANG(?subclaslabel) = "en").  
  ?subclas wdt:P244 ?libcongwikidata .
}     
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}