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.
(adding translate tags) |
|||
(29 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
− | + | <indicator name="stats"></indicator> | |
+ | {{#SUBTITLE: | ||
<translate> | <translate> | ||
− | LinguaLibre Alpha release was announced on August 2018. | + | <!--T:13--> |
− | + | 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. | |
− | + | </translate> | |
− | + | }} | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
<translate> | <translate> | ||
Line 22: | Line 14: | ||
<query records="Records" speakers="Speakers" languages="Languages"> | <query records="Records" speakers="Speakers" languages="Languages"> | ||
SELECT | SELECT | ||
+ | (COUNT(DISTINCT ?record) AS ?records) | ||
+ | (COUNT(DISTINCT ?speaker) AS ?speakers) | ||
+ | (COUNT(DISTINCT ?language) AS ?languages) | ||
+ | WHERE { | ||
+ | ?record prop:P2 entity:Q2 . | ||
+ | ?record prop:P5 ?speaker . | ||
+ | ?record prop:P4 ?language . | ||
+ | } | ||
+ | </query> | ||
+ | |||
+ | == Monthly activity == <!--T:25--> | ||
+ | |||
+ | <!--T:26--> | ||
+ | <query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages"> | ||
+ | SELECT | ||
+ | ?yearmonth | ||
(COUNT(DISTINCT ?record) AS ?records) | (COUNT(DISTINCT ?record) AS ?records) | ||
(COUNT(DISTINCT ?speaker) AS ?speakers) | (COUNT(DISTINCT ?speaker) AS ?speakers) | ||
Line 30: | Line 38: | ||
?record prop:P5 ?speaker . | ?record prop:P5 ?speaker . | ||
?record prop:P4 ?language . | ?record prop:P4 ?language . | ||
+ | BIND( SUBSTR(str(?date), 0, 8) as ?yearmonth ) | ||
} | } | ||
+ | GROUP BY ?yearmonth | ||
+ | ORDER BY ?yearmonth | ||
</query> | </query> | ||
Line 36: | Line 47: | ||
<!--T:6--> | <!--T:6--> | ||
− | <query _pagination="10" language="Item" | + | <!-- NEEDED IMPROVEMENT FOR READABILITY : --> |
− | select ?language | + | <!-- * add column with language name in English, ex: French, Cantonese --> |
+ | <!-- * add column with iso3 code, ex: fra, yue --> | ||
+ | <query _pagination="10" language="Item (Language Qid)" code="Code ISO 639-3" nb="Number of records"> | ||
+ | select ?language ?code (COUNT(DISTINCT ?record) as ?nb) | ||
where { | where { | ||
?record prop:P2 entity:Q2 . | ?record prop:P2 entity:Q2 . | ||
− | ?record prop:P4 | + | ?record prop:P4 ?language . |
− | + | OPTIONAL { ?language prop:P13 ?code } | |
− | |||
− | |||
− | |||
− | |||
− | |||
} | } | ||
− | GROUP BY ?language ? | + | GROUP BY ?language ?code |
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
</query> | </query> | ||
Line 55: | Line 64: | ||
<!--T:8--> | <!--T:8--> | ||
− | <query _pagination="10" locutor="Item" 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 | + | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) |
where { | where { | ||
?record prop:P2 entity:Q2 . | ?record prop:P2 entity:Q2 . | ||
Line 62: | Line 71: | ||
?record prop:P4 ?lang . | ?record prop:P4 ?lang . | ||
#extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] . | #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] . | ||
− | |||
− | |||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
− | |||
?locutor rdfs:label ?locutorLabel . | ?locutor rdfs:label ?locutorLabel . | ||
} | } | ||
Line 75: | Line 81: | ||
</query> | </query> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
</translate> | </translate> | ||
+ | __NOTOC__ |
Revision as of 14:43, 10 July 2020
Global stats
Monthly activity
Number of records per languages
The most prolific speakers