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).

m (Label)
(27 intermediate revisions by 5 users not shown)
Line 1: Line 1:
 
<languages/>
 
<languages/>
 
+
<indicator name="stats"></indicator>
 +
{{#SUBTITLE:
 
<translate>  
 
<translate>  
 
<!--T:13-->
 
<!--T:13-->
LinguaLibre Alpha release was announced on August 2018. As of April 1st, 2019 (8 months), nearly 100,000 audios have been recorded in 46 languages, thanks to 128 variously active speakers.  
+
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).
 +
</translate>
 +
}}
  
 +
<translate>
 
== Global stats == <!--T:4-->
 
== Global stats == <!--T:4-->
  
Line 20: Line 24:
 
</query>
 
</query>
  
== History == <!--T:25-->
+
== Monthly activity == <!--T:25-->
  
 
<!--T:26-->
 
<!--T:26-->
<query yearmonth="Date" records="New records" speakers="New speakers" languages="New languages">
+
<query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages">
 
SELECT
 
SELECT
 
?yearmonth
 
?yearmonth
Line 43: Line 47:
  
 
<!--T:6-->
 
<!--T:6-->
<query _pagination="10" language="Item" name="Language" nb="Number of records">
+
<!-- NEEDED IMPROVEMENT FOR READABILITY : -->
    select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
+
<!-- * add column with language name in English, ex: French, Cantonese -->
    where {
+
<!-- * add column with iso3 code, ex: fra, yue -->
        ?record prop:P2 entity:Q2 .
+
<query _pagination="10" language="Item (Language Qid)" code="ISO 639-3 code" nb="Number of records">
        ?record prop:P4 ?lang .
+
select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb)
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
+
where {
     
+
  ?record prop:P2 entity:Q2 .
        SERVICE wikibase:label {
+
  ?record prop:P4 ?language .
            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
+
  OPTIONAL { ?language prop:P13 ?code }
            ?language rdfs:label ?languageLabel.
+
  OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "fr"). }
        }
+
}
    }
+
GROUP BY ?language ?languageLabel ?code
    GROUP BY ?language ?languageLabel
+
ORDER BY DESC(?nb)
    ORDER BY DESC(?nb)
 
 
</query>
 
</query>
  
Line 62: Line 65:
  
 
<!--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) (GROUP_CONCAT(DISTINCT ?langLabel;separator=", ") as ?languages)
+
     select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
 
     where {
 
     where {
 
         ?record prop:P2 entity:Q2 .
 
         ?record prop:P2 entity:Q2 .
Line 69: Line 72:
 
         ?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] .
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
 
     
 
 
         SERVICE wikibase:label {
 
         SERVICE wikibase:label {
 
             bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
             bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
            ?lang rdfs:label ?langLabel .
 
 
             ?locutor rdfs:label ?locutorLabel .
 
             ?locutor rdfs:label ?locutorLabel .
 
         }
 
         }
Line 82: Line 82:
 
</query>
 
</query>
  
== The most recorded words == <!--T:3-->
 
 
<!--T:10-->
 
<query _pagination=10 transcription="Transcription" nb="Number of records" language="Languages">
 
    select ?transcription (COUNT(?record) as ?nb) (GROUP_CONCAT(DISTINCT (if( ?language = entity:Q4, '???', ?languageLabel )); SEPARATOR=", ") AS ?languages)
 
    where {
 
        ?record prop:P2 entity:Q2 .
 
        ?record prop:P4 ?lang .
 
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
 
     
 
        ?record prop:P7 ?transcription.
 
SERVICE wikibase:label {
 
            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
            ?language  rdfs:label ?languageLabel.
 
        }
 
    }
 
    GROUP BY ?transcription
 
    ORDER BY DESC(?nb)
 
    LIMIT 50
 
</query>
 
 
</translate>
 
</translate>
 +
__NOTOC__

Revision as of 13:07, 10 September 2020

Other languages:
Bahasa Indonesia • ‎Bahasa Melayu • ‎Bali • ‎Bikol Central • ‎Deutsch • ‎English • ‎Esperanto • ‎Igbo • ‎Türkçe • ‎brezhoneg • ‎català • ‎español • ‎français • ‎lumbaart • ‎occitan • ‎polski • ‎română • ‎sicilianu • ‎svenska • ‎македонски • ‎русский • ‎українська • ‎עברית • ‎বাংলা • ‎తెలుగు • ‎中文 • ‎日本語 • ‎ꯃꯤꯇꯩ ꯂꯣꯟ


Global stats

... Loading ...

Monthly activity

... Loading ...

Number of records per languages

... Loading ...

The most prolific speakers

... Loading ...