Queries

Main Page

Data Structure

Queries

Help

Chat

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

SNARC Queries

• Check for items with no CY label
• Places outside of Wales

Federated query with Wikidata

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:P7 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". }
}