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

(Improvement required.)
(Optimisation de la requête)
(17 intermediate revisions by 5 users not shown)
Line 4: Line 4:
 
<translate>  
 
<translate>  
 
<!--T:13-->
 
<!--T:13-->
LinguaLibre Alpha release was announced on August 2018. As of April 1st 2019 (8 months): 100,000 audios have been recorded in 46 languages, thanks to 128 variously active speakers. In January 2020, more than 200,000 audios have already been recorded, in 82 languages and thanks to 268 different 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>
 
}}
 
}}
Line 10: Line 10:
 
<translate>
 
<translate>
 
== Global stats == <!--T:4-->
 
== Global stats == <!--T:4-->
 
+
</translate>
 +
<translate>
 
<!--T:5-->
 
<!--T:5-->
<query records="Records" speakers="Speakers" languages="Languages">
+
<query records="Records" speakers="Speakers" languages="Languages"></translate>
 
SELECT
 
SELECT
 
(COUNT(DISTINCT ?record) AS ?records)
 
(COUNT(DISTINCT ?record) AS ?records)
Line 23: Line 24:
 
}
 
}
 
</query>
 
</query>
 
+
<translate>
== 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"></translate>
 
SELECT
 
SELECT
 
?yearmonth
 
?yearmonth
Line 43: Line 44:
 
ORDER BY ?yearmonth
 
ORDER BY ?yearmonth
 
</query>
 
</query>
 
+
<translate>
 
== Number of records per languages == <!--T:1-->
 
== Number of records per languages == <!--T:1-->
 +
</translate>
  
<!--T:6-->
 
 
<!-- NEEDED IMPROVEMENT FOR READABILITY : -->
 
<!-- NEEDED IMPROVEMENT FOR READABILITY : -->
 
<!-- * add column with language name in English, ex: French, Cantonese -->
 
<!-- * add column with language name in English, ex: French, Cantonese -->
 
<!-- * add column with iso3 code, ex: fra, yue -->
 
<!-- * add column with iso3 code, ex: fra, yue -->
<query _pagination="10" language="Item (Language Qid)" languageLabel="Language" nb="Number of records">
+
<translate>
    select ?language (COUNT(DISTINCT ?record) as ?nb)
+
<!--T:6-->
    where {
+
<query _pagination="10" language="Item (Language Qid)" code="ISO 639-3 code" nb="Number of records"></translate>
        ?record prop:P2 entity:Q2 .
+
select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb)
        ?record prop:P4 ?language .
+
<translate>
     
+
<!--T:7-->
        SERVICE wikibase:label {
+
where {
            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
+
  ?record prop:P2 entity:Q2 .
        }
+
  ?record prop:P4 ?language .
    }
+
  OPTIONAL { ?language prop:P13 ?code }
    GROUP BY ?language ?languageLabel
+
  OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "en"). }
    ORDER BY DESC(?nb)
+
}
</query>
+
GROUP BY ?language ?languageLabel ?code
 +
ORDER BY DESC(?nb)
 +
</query><!-- Just insert corresponding language code instead of "en" --></translate>
 +
<translate>
 +
== The most prolific speakers == <!--T:2-->
  
== The most prolific speakers == <!--T:2-->
 
  
 
<!--T:8-->
 
<!--T:8-->
<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"></translate>
    select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
+
SELECT ?locutor ?locutorLabel ?nb WHERE {
     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 .
        ?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
 
     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>
  
</translate>
+
__NOTOC__

Revision as of 16:42, 14 November 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 ...