Speakers
✅ Speakers → Username containing reserved sign `-
`
- See also T297635 : Lingualibre filename separator should be mass migrated from
-
to —
, without breaking usernames nor words.
#defaultEndpoint:Lingualibre
SELECT *
WHERE {
?id prop:P2 entity:Q3 .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
?id rdfs:label ?name .
}
BIND (regex(STR(?name),"-") AS ?has_fields_separator_in_username)
}
ORDER BY DESC (?has_fields_separator_in_username)
|
|
#defaultEndpoint:Lingualibre
SELECT ?has_fields_separator_in_username (COUNT(?has_fields_separator_in_username) AS ?found)
WHERE {
?id prop:P2 entity:Q3 .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
?id rdfs:label ?name .
}
BIND (regex(STR(?name),"-") AS ?has_fields_separator_in_username)
# filter( regex(?name, "-" ))
}
#ORDER BY DESC (?has_fields_separator_in_username)
GROUP BY (?has_fields_separator_in_username)
|
|
✅ Recordings → Gascon `Q930` recordings containing reserved sign `-
`
- See also T297635 : Lingualibre filename separator should be mass migrated from
-
to —
, without breaking usernames nor words.
#defaultEndpoint:Lingualibre
SELECT *
WHERE {
?id prop:P2 entity:Q2 .
?id prop:P4 entity:Q930 .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
?id rdfs:label ?name .
}
BIND (regex(STR(?name),"-") AS ?has_fields_separator_in_written_word)
}
ORDER BY DESC (?has_fields_separator_in_written_word)
|
|
#defaultEndpoint:Lingualibre
SELECT ?has_fields_separator_in_username (COUNT(?has_fields_separator_in_username) AS ?found)
WHERE {
?id prop:P2 entity:Q2 .
?id prop:P4 entity:Q930 .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
?id rdfs:label ?name .
}
BIND (regex(STR(?name),"-") AS ?has_fields_separator_in_written_word)
# filter( regex(?name, "-" ))
}
#ORDER BY DESC (?has_fields_separator_in_written_word)
GROUP BY (?has_fields_separator_in_written_word)
|
|
✅ Speakers → Speakers of obsolete languages
- Should be maintained to 0.
#defaultEndpoint:Lingualibre
SELECT ?speaker ?speakerLabel
WHERE {
# Obsolete languages items (duplicata and redirects)
# Chinese Q130 → Q113
# Mossi Q170137 → Q359
# Duala Q52071 → Q73
VALUES ?i18nQid { entity:Q130 entity:Q170137 entity:Q52071 }
?speaker prop:P2 entity:Q3 . # Filter: audios
?speaker prop:P4 ?i18nQid . # Filter: P4 language is Q130/Q170137/Q52071 ;
# Add Labels
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
|
|
✅ Speakers → Undefined place of residence
- The following may need precision. If stale, it mean none was found.
#defaultEndpoint:Lingualibre
SELECT ?item ?itemLabel
WHERE {
?item prop:P2 entity:Q3 . # Filter: is Q3 `speaker`
FILTER NOT EXISTS {
?item prop:P14 [].
}
# Add labels to each variable used.
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en". }
}
|
|
✅ Speakers → Non-documented genders values
- This query returns speakers who may have willfully declined to document a gender. See also list of genders.
#defaultEndpoint:Lingualibre
SELECT ?item ?itemLabel ?filledGenderLabel
WHERE {
?item prop:P2 entity:Q3 .
{ ?item prop:P8 entity:Q710460 . } # Filter: 'gender' is 'not documented'
?item prop:P8 ?filledGender .
# Add labels to each variable used.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
}
}
|
|
✅ Speakers → missing gender value
- This query returns speakers who have missing gender value. See also list of genders.
#defaultEndpoint:Lingualibre
SELECT ?speaker ?speakerLabel ?gender ?languageLabel (COUNT(?audio) AS ?audio)
WHERE {
?speaker prop:P2 entity:Q3 .
FILTER NOT EXISTS { ?speaker prop:P8 ?gender }
?audio prop:P5 ?speaker . # Filter: P5 'speaker' is Q445757 'SangeetaRH'
?audio prop:P4 ?language . # Filter: P4 'language' is Q34 'Marathi'
# Add labels
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"}
}
GROUP BY ?speaker ?speakerLabel ?genderLabel ?languageLabel # Sorting first groups per language and speaker
ORDER BY DESC (?audio)
|
|
Recordings
✅ Recordings → With language `P4` as Chinese writing
`Q130` to change to cmn
`Q113`
- ✅ Users linguistic profile has been corrected into Q359. Erroneous recordings language (P4) on Lingualibre, while Commons use correct Wikidata language Qid.
#defaultEndpoint:Lingualibre
SELECT ?langLabel ?isoLabel ?speaker ?speakerLabel ?audio ?audioLabel
WHERE {
?audio prop:P4 entity:Q130 . # Filter: P4 language is Q130 zho ;
?audio prop:P2 entity:Q2 . # Filter: audios
?audio prop:P4 ?lang .
?audio prop:P5 ?speaker .
?lang prop:P13 ?iso .
# Add Labels
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
} ORDER BY ASC(?isoLabel)
# Helper: Chinese writing zho:Q130/wd:Q7850 ; Chinese mandarin cmn:Q113/wd:Q9192 .
|
|
#defaultEndpoint:Lingualibre
SELECT ?isoLabel (COUNT(?iso) AS ?found)
WHERE {
?audio prop:P4 entity:Q130 . # Filter: P4 language is Q130 zho ;
?audio prop:P2 entity:Q2 . # Filter: audios
?audio prop:P4 ?lang .
?lang prop:P13 ?iso .
# Add Labels
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
} GROUP BY ?isoLabel
# Helper: Chinese writing zho:Q130/wd:Q7850 ; Chinese mandarin cmn:Q113/wd:Q9192
|
|
[?] Recordings → With with corrupted information
- ✅ Users linguistic profile has been corrected.
#defaultEndpoint:Lingualibre
SELECT ?lang
(SUBSTR(STR(?speaker),32) AS ?SpeakerQid) ?speakerLabel
?audio ?audioLabel
?url (SUBSTR(STR(?urlLabel),52) AS ?filename)
WHERE {
# Obsolete languages items (duplicata and redirects)
# Chinese Q130 → Q113
# Mossi Q170137 → Q359
# Duala Q52071 → Q73
VALUES ?i18nQid { entity:Q130 entity:Q170137 entity:Q52071 }
{ ?audio prop:P4 ?i18nQid . } # Filter: P4 language is Q130/Q170137/Q52071 ;
# ?audio prop:P4 entity:Q170137 . # Filter: P4 language is Q170137 (redirect) ;
?audio prop:P2 entity:Q2 . # Filter: audios
?audio prop:P4 ?lang .
?audio prop:P5 ?speaker .
?audio prop:P3 ?url .
# Add Labels
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
# ORDER BY ASC(?audio)
# GROUP BY ?lang ?SpeakerQid ?speakerLabel
|
|
Counts
#defaultEndpoint:Lingualibre
SELECT ?lang ?langLabel ?iso
?speaker ?speakerLabel
(COUNT(?audio) AS ?found)
WHERE {
# Obsolete languages items (duplicata and redirects)
# Chinese Q130 → Q113
# Mossi Q170137 → Q359
# Duala Q52071 → Q73
VALUES ?i18nQid { entity:Q130 entity:Q170137 entity:Q52071 }
{ ?audio prop:P4 ?i18nQid . } # Filter: P4 language is Q130/Q170137/Q52071 ;
?audio prop:P2 entity:Q2 . # Filter: audios
?audio prop:P4 ?lang .
OPTIONAL { ?lang prop:P13 ?iso . }
?audio prop:P5 ?speaker .
?audio prop:P3 ?url .
# Add Labels
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
GROUP BY ?lang ?langLabel ?iso ?speaker ?speakerLabel
ORDER BY ?lang
|
|
Languages
✅ Languages → duplicata by Wikidata ID
- Duplicated languages can be merged. If stale, it mean none was found.
#defaultEndpoint:Lingualibre
SELECT ?idWD (COUNT(?item) AS ?count) (GROUP_CONCAT(?item) AS ?items)
WHERE {
?item prop:P2 entity:Q4 ;
prop:P12 ?idWD .
}
GROUP BY ?idWD
HAVING ( ?count > 1 )
|
|
✅ Languages → list of values used including redirects
- If some languageLabels display full uri, there is duplicata. Erroneous data should be corrected or deleted on both Commons and Lingualibre. User:Yug has Dragons Bot for that.
#defaultEndpoint:Lingualibre
SELECT
?language
?languageLabel
(COUNT(DISTINCT ?record) AS ?records)
(COUNT(DISTINCT ?speaker) AS ?speakers)
WHERE {
?record prop:P2 entity:Q2 .
# If all speakers P5 corrected, recordings still accounted for
OPTIONAL { ?record prop:P5 ?speaker . }
?record prop:P4 ?language .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?language ?languageLabel
ORDER BY ?languageLabel
|
|
See also
Sections above : #Recordings for corrupt data to fix.
✅ Languages → languages by type (if it exists)
- Note: query to improve.
#defaultEndpoint:Lingualibre
SELECT ?language ?languageLabel ?code ?type ?typeLabel
WHERE {
?language prop:P2 entity:Q4 .
OPTIONAL { ?language prop:P13 ?code } .
OPTIONAL {
?language rdfs:label ?languageLabel .
FILTER( lang(?languageLabel) = "en" ) } .
OPTIONAL { ?language prop:P24 ?type } .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
}
}
ORDER BY DESC (?typeLabel)
|
|
✅ Languages → média types
#defaultEndpoint:Lingualibre
SELECT ?id ?idLabel
WHERE {
?id prop:P2 entity:Q88888 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en". }
}
|
|
✅ Languages → language with media type (P24) is video (Q88890)
#defaultEndpoint:Lingualibre
SELECT ?id ?idLabel WHERE {
?id prop:P2 entity:Q4 .
?id prop:P24 entity:Q88890 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en". }
}
|
|
✅ Languages → language with media type (P24) is missing
- Empty if displaying rotating animation too long.
#defaultEndpoint:Lingualibre
SELECT ?id ?idLabel ?type ?typeLabel
WHERE {
?id prop:P2 entity:Q4 .
FILTER NOT EXISTS {
?id prop:P24 [].
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en". }
}
|
|
✅ Languages with media type video → written word (P7), url (P3) speakers (P5)
#defaultEndpoint:Lingualibre
SELECT ?word ?filename ?speaker WHERE {
?record prop:P4 entity:Q99628 .
?record prop:P2 entity:Q2 .
?record prop:P7 ?word .
?record prop:P3 ?filename .
?record prop:P5 ?speakerItem .
?speakerItem rdfs:label
?speaker filter ( lang( ?speaker ) = "en" ) .
}
|
|
✅ Languages iso from SignIt → relevant data
- See Translatewiki:Translating:Lingua_Libre_SignIt.
# List from https://translatewiki.net/wiki/Translating:Lingua_Libre_SignIt#sortable:3=desc
# 2023.07.26
#defaultEndpoint:Wikidata
SELECT ?wdQid ?wikimediaCode ?i18nCode ?labelEN
(SAMPLE(?nativeLabel) as ?labelNative)
WHERE {
# languages & scripts
VALUES ?i18nCode {
"anp" "ar" "bn" "br" "de" "en" "es" "fa" "fi" "fr"
"he" "hi" "ia" "id" "it" "ja" "kk-cyrl" "ko" "krc" "lmo"
"mk" "ms" "nb" "pnb" "pt" "pt-br" "qqq" "ru" "scn" "sl"
"sv" "sw" "tl" "tr" "uk" "zh-hans" "zh-hant" "mnw" "hu"
"kk" "zh"
}
# Scripts, not languages
VALUES ?i18nScript { "kk-cyrl" "zh-hans" "zh-hant" }
{ ?langId wdt:P218 ?i18nCode. } # has for iso 639-1 code
UNION {?langId wdt:P219 ?i18nCode. } # has for iso 639-2 code
UNION {?langId wdt:P220 ?i18nCode. } # has for iso 639-3 code
UNION {?langId wdt:P305 ?i18nCode. } # has for isoIETF code
# UNION {?langId wdt:P31 wd:Q1149626 ; # has for instance written language
# wdt:P424 ?i18nScript ; # has for wikimedia code
# rdfs:label ?labelEN . }
# UNION { ?langId wdt:P424 ?i18nCode. } # has for wikimedia code
OPTIONAL { ?langId wdt:P424 ?wikimediaCode. }
OPTIONAL { ?langId wdt:P1705 ?native. }
# wdt:P10369 ?lingualibreQid ;
?langId rdfs:label ?labelEN .
FILTER ( lang(?labelEN) = "en" )
BIND(REPLACE(STR(?langId), ".*/Q", "Q") AS ?wdQid)
BIND(CONCAT(UCASE(SUBSTR(?native, 1 , 1 )), SUBSTR(?native, 2 )) AS ?nativeLabel)
}
GROUP BY ?wdQid ?wikimediaCode ?i18nCode ?labelEN
ORDER BY ASC(?i18nCode)
|
|
✅ Languages : corpora documented on Wikidata
#defaultEndpoint:Wikidata
SELECT ?text_corpus ?languageLabel ?website ?date ?size
WHERE {
?text_corpus wdt:P31 wd:Q461183.
OPTIONAL { ?text_corpus wdt:P407 ?language. }
OPTIONAL { ?text_corpus wdt:P856 ?website. }
OPTIONAL { ?text_corpus wdt:P577 ?date. }
OPTIONAL { ?text_corpus wdt:P2043 ?size. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC (?languageLabel)
|
|
Other
All properties with their Wikidata equivalent (if it exists)
- See also Special:ListProperties.
#defaultEndpoint:Lingualibre
SELECT
(SUBSTR(STR(?propLili),38) AS ?QidNum)
?propLiliClaimLabel ?propLili ?propWD
WHERE {
# { ?propLili rdf:type owl:ObjectProperty }
# UNION
# { ?propLili rdf:type owl:DatatypeProperty }
OPTIONAL { ?propLiliClaim <http://wikiba.se/ontology#directClaim> ?propLili ; prop:P12 ?propWD }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY xsd:integer(?QidNum)
|
|
See also