Help

Difference between revisions of "SPARQL"

Line 75: Line 75:
 
<!--
 
<!--
 
== Speaker Qid → Speaker data → speaker languages ==
 
== Speaker Qid → Speaker data → speaker languages ==
== Speaker Qid + language → list of audios in target language ==
+
== Speaker Qid + language → list of all associated audios ==
 +
== Is Language ([[Q3]]) → list all languages with number of unique words and speakers ==
 
== Isolang → Language LL Qid ==
 
== Isolang → Language LL Qid ==
 
== Isolang → Language WD Qid ==
 
== Isolang → Language WD Qid ==

Revision as of 16:52, 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

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

... Loading ...