Help
SPARQL
Useful lists
Locutor list
select ?locutor ?locutorLabel
where {
?locutor prop:P2 entity:Q3 .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
}
}
Example:
Recording of Link (Q262) having a link to a Wikidata item (P12)
select ?record ?recordLabel ?languageLabel ?wid
where {
?record prop:P2 entity:Q2 .
?record prop:P5 entity:Q262 .
?record prop:P4 ?language .
?record prop:P12 ?wid .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
}
}
All recordings sorted by language et by level skill
select ?record ?recordLabel ?locutorLabel ?languageLabel ?languageLevelLabel
where {
?record prop:P2 entity:Q2 .
?record prop:P5 ?locutor .
?record prop:P4 ?language .
?locutor llp:P4 ?languageStatement .
?languageStatement llv:P4 ?language .
?languageStatement llq:P16 ?languageLevel .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
}
} ORDER BY ?languageLabel ?languageLevelLabel
All recordings link with a Wikidata item, getting coordinate location over there
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX ll: <https://lingualibre.org/entity/>
PREFIX llt: <https://lingualibre.org/prop/direct/>
PREFIX lltn: <https://lingualibre.org/prop/direct-normalized/>
select distinct ?record ?transcription ?languageLabel ?wikidataLabel ?coord
where {
?record llt:P2 ll:Q2 .
?record llt:P4 ?language .
?record llt:P7 ?transcription .
?record lltn:P12 ?wikidataItem .
SERVICE <https://query.wikidata.org/sparql> {
OPTIONAL { ?wikidataItem wdt:P625 ?coord . }
OPTIONAL {
?wikidataItem rdfs:label ?wikidataLabel .
FILTER (LANG(?wikidataLabel) = "[AUTO_LANGUAGE],en") .
}
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
}
}