Help

Difference between revisions of "SPARQL"

Line 121: Line 121:
  
 
== Speaker Qid + language → list of all associated audios ==
 
== Speaker Qid + language → list of all associated audios ==
 +
 +
 +
{|
 +
|- style="vertical-align:top;"
 +
|style="padding: 0 3em;width:60%"|
 +
<syntaxhighlight lang="sparql">
 +
SELECT ?audio WHERE {
 +
  ?audio prop:P5 entity:Q42 .
 +
  ?audio prop:P4 entity:Q21 .
 +
}
 +
</syntaxhighlight>
 +
||
 +
<query _pagination="5" >
 +
SELECT ?audio WHERE {
 +
  ?audio prop:P5 entity:Q42 . #speakerId
 +
  ?audio prop:P4 entity:Q21 . #languageId
 +
}
 +
</query>
 +
|}
 +
 
== Is Language ([[Q3]]) → list all languages with number of unique words and speakers ==
 
== Is Language ([[Q3]]) → list all languages with number of unique words and speakers ==
 
== Isolang → Language LL Qid ==
 
== Isolang → Language LL Qid ==

Revision as of 18:53, 5 December 2021

Base

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

SELECT ?item ?itemLabel
WHERE {
  ?item prop:P2/prop:P9 * entity:Q7
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
  } 
}
... Loading ...

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

select ?speaker ?speakerLabel
where {
  ?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 are acceptable here
  BIND ( STRLANG(?speakerName, "en") AS ?speakerLabel )
  ?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

Isolang → Language LL Qid

Isolang → Language WD Qid

Language WD Qid → Language data

Language LL Qid → Language data

Langue + speaker + word → Audio's Qid

Audio Qid → Audio data

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

Tools