LinguaLibre
Difference between revisions of "Stats"
LinguaLibre Alpha release was announced on August 2018. By April 2019, LiLi reached 100,000 audios in 46 languages thanks to 128 different speakers. The project reached 200,000 recordings (82 languages, 268 speakers) in January 2020, 400,000 recordings (107 languages, 481 speakers) in February 2021 and 500,000 recordings (120 languages, 538 speakers) in June 2021.
WikiLucas00 (talk | contribs) |
WikiLucas00 (talk | contribs) m (forgot the month) |
||
(23 intermediate revisions by 6 users not shown) | |||
Line 4: | Line 4: | ||
<translate> | <translate> | ||
<!--T:13--> | <!--T:13--> | ||
− | LinguaLibre Alpha release was announced on August 2018. By April 2019, 100,000 audios in 46 languages | + | LinguaLibre Alpha release was announced on August 2018. By April 2019, ''LiLi'' reached '''100,000''' audios in 46 languages thanks to 128 different speakers. The project reached '''200,000''' recordings (82 languages, 268 speakers) in January 2020, '''400,000''' recordings (107 languages, 481 speakers) in February 2021 and '''500,000''' recordings (120 languages, 538 speakers) in June 2021. |
</translate> | </translate> | ||
}} | }} | ||
Line 11: | Line 11: | ||
== Global stats == <!--T:4--> | == Global stats == <!--T:4--> | ||
</translate> | </translate> | ||
− | + | <query records="<translate><!--T:30--> Records</translate>" speakers="<translate><!--T:31--> Speakers</translate>" languages="<translate><!--T:32--> Languages</translate>"> | |
− | <query records="Records" speakers="Speakers" languages=" | ||
SELECT | SELECT | ||
(COUNT(DISTINCT ?record) AS ?records) | (COUNT(DISTINCT ?record) AS ?records) | ||
Line 25: | Line 24: | ||
<translate> | <translate> | ||
== Monthly activity == <!--T:25--> | == Monthly activity == <!--T:25--> | ||
+ | </translate> | ||
− | <query yearmonth="Date" records="New records" speakers="Active speakers" languages=" | + | <query yearmonth="<translate><!--T:33--> Date</translate>" records="<translate><!--T:34--> New records</translate>" speakers="<translate><!--T:35--> Active speakers</translate>" languages="<translate><!--T:36--> Active languages</translate>"> |
SELECT | SELECT | ||
?yearmonth | ?yearmonth | ||
Line 46: | Line 46: | ||
</translate> | </translate> | ||
− | <!-- | + | <query _pagination="10" language="<translate><!--T:37--> Item (Language Qid)</translate>" code="<translate><!--T:38--> ISO 639-3 code</translate>" nb="<translate><!--T:39--> Number of records</translate>"> |
− | <!-- | + | select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb) |
− | <!-- | ||
<translate> | <translate> | ||
− | + | <!--T:7--> | |
− | |||
where { | where { | ||
?record prop:P2 entity:Q2 . | ?record prop:P2 entity:Q2 . | ||
?record prop:P4 ?language . | ?record prop:P4 ?language . | ||
OPTIONAL { ?language prop:P13 ?code } | OPTIONAL { ?language prop:P13 ?code } | ||
− | OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = " | + | OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "en"). } |
} | } | ||
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--> | ||
+ | </translate> | ||
+ | <query _pagination="10" locutor="<translate><!--T:40--> Item (locutor Qid)</translate>" locutorLabel="<translate><!--T:41--> Speaker</translate>" nb="<translate><!--T:42--> Number of records</translate>"> | ||
+ | SELECT ?locutor ?locutorLabel ?nb WHERE { | ||
+ | { | ||
+ | SELECT ?locutor (COUNT(?record) as ?nb) | ||
+ | WHERE { | ||
+ | ?record prop:P2 entity:Q2 . # Q2: record, P2: instance of. | ||
+ | ?record prop:P5 ?locutor . # Property:P5: speaker | ||
+ | } | ||
+ | GROUP BY ?locutor ?locutorLabel | ||
+ | ORDER BY DESC(?nb) | ||
+ | LIMIT 50 | ||
+ | } | ||
+ | SERVICE wikibase:label { | ||
+ | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
+ | ?locutor rdfs:label ?locutorLabel . | ||
+ | } | ||
+ | } | ||
+ | ORDER BY DESC(?nb) | ||
+ | </query> | ||
− | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb=" | + | <translate> |
− | + | == The most prolific speakers for the current month == <!--T:28--> | |
− | + | </translate> | |
− | ?record prop:P2 entity:Q2 . | + | |
− | + | <query _pagination="10" locutor="<translate><!--T:43--> Item (locutor Qid)</translate>" locutorLabel="<translate><!--T:44--> Speaker</translate>" nb="<translate><!--T:45--> Number of records for the current month</translate>"> | |
− | ?record prop: | + | SELECT ?locutor ?locutorLabel ?nb WHERE { |
− | + | { | |
− | + | SELECT ?locutor (COUNT(?record) as ?nb) | |
− | + | WHERE { | |
− | + | ?record prop:P2 entity:Q2 . # Q2: record, P2: instance of. | |
− | + | ?record prop:P5 ?locutor . # Property:P5: speaker | |
+ | ?record prop:P6 ?date . | ||
+ | FILTER ( YEAR(?date) = YEAR(NOW()) && MONTH(?date) = MONTH(NOW()) ) | ||
} | } | ||
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 15:36, 17 June 2021
Global stats
Monthly activity
Number of records per languages
The most prolific speakers
The most prolific speakers for the current month