Help

Difference between revisions of "SPARQL"

(→‎✅ Is Sex or Gender(Q7) → list all possible values: inutile ici (il n'y a pas de sous-classes du genre))
Line 6: Line 6:
 
* [[DataViz:Records]]
 
* [[DataViz:Records]]
  
 +
== Fetch data using SPARQL ==
 +
Data can be queried via various languages such as Javascript, Python, R and others.
 +
On the [Wikidata Query Service page]] > Click : "Code" > a pop up window appears with various implementations.
 +
 +
'''Javascript:'''<br>
 +
At least 3 methods exists ([https://jsfiddle.net/hugolpz/tsg9ewa7/4/ code snippet]).
 +
<syntaxhighlight lang="javascript">
 +
var endpoint = 'https://lingualibre.org/sparql';
 +
var sparql = 'SELECT ?item WHERE { ?item wdt:P2 wd:Q5 } LIMIT 10';
 +
$.getJSON(endpoint,
 +
{ query: sparql, format: 'json' },
 +
function(data){ console.log('JQuery: ',data)}
 +
);
 +
</syntaxhighlight>
 
== ✅ Is Sex or Gender([[Q7]]) → list all possible values ==
 
== ✅ Is Sex or Gender([[Q7]]) → list all possible values ==
 
{|  
 
{|  

Revision as of 12:21, 6 December 2021

Base

Fetch data using SPARQL

Data can be queried via various languages such as Javascript, Python, R and others. On the [Wikidata Query Service page]] > Click : "Code" > a pop up window appears with various implementations.

Javascript:
At least 3 methods exists (code snippet). 

var endpoint = 'https://lingualibre.org/sparql';
var sparql = 'SELECT ?item WHERE { ?item wdt:P2 wd:Q5 } LIMIT 10';
$.getJSON(endpoint,
	{ query: sparql, format: 'json' },
	function(data){ console.log('JQuery: ',data)}
);

✅ Is Sex or Gender(sex or gender (Q7)) → list all possible values

SELECT ?item ?itemLabel
WHERE {
  # P2: instance of; P9: subclass of; Q7: gender or sex.
  ?item prop:P2 entity:Q7
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
  } 
}
... Loading ...

✅ Is Speaker (speaker (Q3)) → list all speakers

select ?speaker ?speakerLabel
where {
  #P2: instance of; Q3: speaker.
  ?speaker prop:P2 entity:Q3 .
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
  } 
}
... Loading ...

✅ Speaker name → Speaker Qid

select ?speakerName ?speakerId
where {
  VALUES ?speakerName { "Yug" "VIGNERON" } # One or multiple values
  BIND ( STRLANG(?speakerName, "en") AS ?speakerLabel )
  # P2: instance of; Q3: speaker.
  ?speakerId prop:P2 entity:Q3 ; rdfs:label ?speakerLabel .
}
... Loading ...

Speaker Qid (0x010C (Q42)) → Speaker data

SELECT ?predicate ?object
WHERE {
  entity:Q42 ?predicate ?object .
}
... Loading ...

Speaker Qid → Speaker data → speaker languages

SELECT ?languages
WHERE {
  entity:Q42 prop:P4 ?languages .
}
... Loading ...

Speaker Qid + language → list of all associated audios

SELECT ?audio WHERE {
  ?audio prop:P5 entity:Q42 .
  ?audio prop:P4 entity:Q21 .
}
... Loading ...

Is Language (speaker (Q3)) → list all languages with number of unique words and speakers

SELECT ?language (COUNT(?audio) AS ?nbAudio) (COUNT(?speaker) AS ?nbSpeaker) WHERE {
  ?language prop:P2 entity:Q4 .
  ?audio prop:P4 ?language .
  ?speaker prop:P4 ?language .
}
GROUP BY ?language

Too large to work :(

Isolang → Language LL Qid

SELECT * WHERE {
  ?lang prop:P13 ?code .
}
... Loading ...

Isolang → Language WD Qid

SELECT * WHERE {
  ?lang prop:P12 ?idWikidata .
}
... Loading ...

Language WD Qid → Language data

SELECT * WHERE {
  ?lang prop:P12 "Q12107" .
  ?lang ?predicate ?object .
}
... Loading ...

Language LL Qid → Language data

SELECT * WHERE {
  entity:Q209 ?predicate ?object .
}
... Loading ...

Langue + speaker + word → Audio's Qid

SELECT ?audio WHERE {
  ?audio prop:P4 entity:Q209 . #language
  ?audio prop:P5 entity:Q584098 . #speaker
  ?audio rdfs:label ?word . #word
  FILTER ( STR(?word) = "ni" )
}
... Loading ...

Audio Qid → Audio data

✅ Langue + speaker + word → Audio's Commons url

Tools

  • Special:ApiSandbox – API queries generator for Lingualibre wikipage and wikibase contents.
Retrieved from "https://lingualibre.org/index.php?title=Help:SPARQL&oldid=686977"