Difference between revisions of "Stats/en"

Revision as of 00:10, 10 October 2020

Other languages:

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

Global stats

... Loading ...

Monthly activity

... Loading ...

Number of records per languages

... Loading ...

The most prolific speakers

... Loading ...

@@ Line 3: / Line 3: @@
 {{#SUBTITLE:
-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).
 }}
@@ Line 20: / Line 20: @@
 </query>
-== History ==
+== Monthly activity ==
-<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
 ?yearmonth
@@ Line 41: / Line 41: @@
 == Number of records per languages ==
-<query _pagination="10" language="Item (Language Qid)" languageLabel="Language" nb="Number of records">
+<!-- NEEDED IMPROVEMENT FOR READABILITY : -->
-    select ?language (COUNT(DISTINCT ?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 ?language .
+select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb)
+where {
-        SERVICE wikibase:label {
+  ?record prop:P2 entity:Q2 .
-            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
+  ?record prop:P4 ?language .
-        }
+  OPTIONAL { ?language prop:P13 ?code }
-    }
+  OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "fr"). }
-    GROUP BY ?language ?languageLabel
+}
-    ORDER BY DESC(?nb)
+GROUP BY ?language ?languageLabel ?code
+ORDER BY DESC(?nb)
 </query>
@@ Line 73: / Line 74: @@
      LIMIT 50
 </query>
+__NOTOC__