LinguaLibre
Difference between revisions of "Stats"
LinguaLibre Alpha release was announced on August 2018. By April 2019, 100,000 audios in 46 languages were available thanks to 128 variously active speakers. In January 2020, 200,000 audios in 82 languages thanks to 268 different speakers. In September 2020, the platform reached 300,000 recordings in 91 languages (357 speakers).
(we do not use fr, bn could be ideal, but we do not have bn labels for a few, as of now let it be en) |
(Optimisation de la requête) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 55: | Line 55: | ||
<query _pagination="10" language="Item (Language Qid)" code="ISO 639-3 code" nb="Number of records"></translate> | <query _pagination="10" language="Item (Language Qid)" code="ISO 639-3 code" nb="Number of records"></translate> | ||
select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb) | select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb) | ||
| + | <translate> | ||
| + | <!--T:7--> | ||
where { | where { | ||
?record prop:P2 entity:Q2 . | ?record prop:P2 entity:Q2 . | ||
| Line 63: | Line 65: | ||
GROUP BY ?language ?languageLabel ?code | GROUP BY ?language ?languageLabel ?code | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
| − | </query> | + | </query><!-- Just insert corresponding language code instead of "en" --></translate> |
<translate> | <translate> | ||
| − | |||
== The most prolific speakers == <!--T:2--> | == The most prolific speakers == <!--T:2--> | ||
| Line 71: | Line 72: | ||
<!--T:8--> | <!--T:8--> | ||
<query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages"></translate> | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages"></translate> | ||
| − | + | SELECT ?locutor ?locutorLabel ?nb WHERE { | |
| − | + | { | |
| + | SELECT ?locutor (COUNT(?record) as ?nb) | ||
| + | WHERE { | ||
?record prop:P2 entity:Q2 . | ?record prop:P2 entity:Q2 . | ||
?record prop:P5 ?locutor . | ?record prop:P5 ?locutor . | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
} | } | ||
GROUP BY ?locutor ?locutorLabel | GROUP BY ?locutor ?locutorLabel | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
LIMIT 50 | LIMIT 50 | ||
| + | } | ||
| + | SERVICE wikibase:label { | ||
| + | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| + | ?locutor rdfs:label ?locutorLabel . | ||
| + | } | ||
| + | } | ||
| + | ORDER BY DESC(?nb) | ||
</query> | </query> | ||
__NOTOC__ | __NOTOC__ | ||
Revision as of 16:42, 14 November 2020
Global stats
Monthly activity
Number of records per languages
The most prolific speakers