LinguaLibre
Difference between revisions of "Stats/oc"
Lingua Libre alpha foguèt anonciada en agost de 2018. Lo primièr d'abrial de 2019, pas mens de 100 000 enregistraments avián estat realizats dins 46 lengas, mercé a 128 locutors diferents. En genièr de 2020,sèm a mai de 200 000 enregistraments dins 82 lengas, mercé a 268 locutors.
(Updating to match new version of source page) |
(Updating to match new version of source page) |
||
| Line 9: | Line 9: | ||
== Global stats == | == Global stats == | ||
| − | |||
<query records="Records" speakers="Speakers" languages="Languages"> | <query records="Records" speakers="Speakers" languages="Languages"> | ||
SELECT | SELECT | ||
| Line 21: | Line 20: | ||
} | } | ||
</query> | </query> | ||
| − | |||
<div class="mw-translate-fuzzy"> | <div class="mw-translate-fuzzy"> | ||
== Estatisticas mensuella == | == Estatisticas mensuella == | ||
| Line 42: | Line 40: | ||
ORDER BY ?yearmonth | ORDER BY ?yearmonth | ||
</query> | </query> | ||
| − | |||
== Number of records per languages == | == Number of records per languages == | ||
| + | <!-- NEEDED IMPROVEMENT FOR READABILITY : --> | ||
| + | <!-- * add column with language name in English, ex: French, Cantonese --> | ||
| + | <!-- * add column with iso3 code, ex: fra, yue --> | ||
<div class="mw-translate-fuzzy"> | <div class="mw-translate-fuzzy"> | ||
<query _pagination="10" language="Item (Language Qid)" languageLabel="Language" nb="Number of records"> | <query _pagination="10" language="Item (Language Qid)" languageLabel="Language" nb="Number of records"> | ||
| Line 60: | Line 60: | ||
</query> | </query> | ||
</div> | </div> | ||
| + | select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb) | ||
| + | where { | ||
| + | ?record prop:P2 entity:Q2 . | ||
| + | ?record prop:P4 ?language . | ||
| + | OPTIONAL { ?language prop:P13 ?code } | ||
| + | OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "fr"). } | ||
| + | } | ||
| + | GROUP BY ?language ?languageLabel ?code | ||
| + | ORDER BY DESC(?nb) | ||
| + | </query> | ||
| + | == Locutors los mai prolifics == | ||
| − | |||
| + | <div class="mw-translate-fuzzy"> | ||
<query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages"> | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages"> | ||
| + | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | ||
| + | where { | ||
| + | ?record prop:P2 entity:Q2 . | ||
| + | ?record prop:P5 ?locutor . | ||
| + | ?record prop:P4 ?lang . | ||
| + | #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] . | ||
| + | SERVICE wikibase:label { | ||
| + | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| + | ?locutor rdfs:label ?locutorLabel . | ||
| + | } | ||
| + | } | ||
| + | GROUP BY ?locutor ?locutorLabel | ||
| + | ORDER BY DESC(?nb) | ||
| + | LIMIT 50 | ||
| + | </query> | ||
| + | </div> | ||
select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | ||
where { | where { | ||
Revision as of 21:39, 10 October 2020
Global stats
Estatisticas mensuella
Number of records per languages
select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb) where {
?record prop:P2 entity:Q2 .
?record prop:P4 ?language .
OPTIONAL { ?language prop:P13 ?code }
OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "fr"). }
} GROUP BY ?language ?languageLabel ?code ORDER BY DESC(?nb) </query>
Locutors los mai prolifics
select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
where {
?record prop:P2 entity:Q2 .
?record prop:P5 ?locutor .
?record prop:P4 ?lang .
#extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
?locutor rdfs:label ?locutorLabel .
}
}
GROUP BY ?locutor ?locutorLabel
ORDER BY DESC(?nb)
LIMIT 50
</query>