Difference between revisions of "Stats/en"

Latest revision as of 17:16, 8 October 2023

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 • ‎Ελληνικά • ‎башҡортса • ‎македонски • ‎русский • ‎українська • ‎עברית • ‎বাংলা • ‎తెలుగు • ‎中文 • ‎日本語 • ‎ꯃꯤꯇꯩ ꯂꯣꯟ

View statistics about:

Global stats Languages Speakers Chronological

Global stats

... Loading ...

@@ Line 1: / Line 1: @@
-<languages/>
+__NOTOC__
-<indicator name="stats"></indicator>
+<languages/><indicator name="stats"></indicator>{{#SUBTITLE: Lingua Libre Alpha was announced on August 2018. By April 2019, ''LiLi'' reached '''100,000''' audios recordings in 46 languages thanks to 128 different speakers, '''200,000''' recordings (82 languages, 268 speakers) in January 2020 ; '''500,000''' recordings (120 languages, 538 speakers) in June 2021 and '''1,000,000''' recordings (200 languages, 1400 speakers) in October 2023.}}{{LinguaLibre:Stats/Menu}}
-{{#SUBTITLE:
-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).
-}}
 == Global stats ==
 <query records="Records" speakers="Speakers" languages="Languages">
@@ Line 11: / Line 6: @@
 (COUNT(DISTINCT ?record) AS ?records)
 (COUNT(DISTINCT ?speaker) AS ?speakers)
-(COUNT(DISTINCT ?language) AS ?languages)
+(COUNT(DISTINCT ?language) -2 AS ?languages) # Accounting for the 2 duplicata languages
+# see Help:SPARQL_for_maintenance#.E2.9C.85_Languages_.E2.86.92_list_of_values_used_including_redirects
 WHERE {
    ?record prop:P2 entity:Q2 .
@@ Line 18: / Line 14: @@
 }
 </query>
-== Monthly activity ==
-<query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages">
-SELECT
-?yearmonth
-(COUNT(DISTINCT ?record) AS ?records)
-(COUNT(DISTINCT ?speaker) AS ?speakers)
-(COUNT(DISTINCT ?language) AS ?languages)
-WHERE {
-  ?record prop:P2 entity:Q2 .
-  ?record prop:P6 ?date .
-  ?record prop:P5 ?speaker .
-  ?record prop:P4 ?language .
-  BIND( SUBSTR(str(?date), 0, 8) as ?yearmonth )
-}
-GROUP BY ?yearmonth
-ORDER BY ?yearmonth
-</query>
-== Number of records per languages ==
-<!-- NEEDED IMPROVEMENT FOR READABILITY : -->
-<!-- * 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="ISO 639-3 code" nb="Number of records">
-select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb)
-where {
-  ?record prop:P2 entity:Q2 .
-  ?record prop:P4 ?language .
-  OPTIONAL { ?language prop:P13 ?code }
-  OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "en"). }
-}
-GROUP BY ?language ?languageLabel ?code
-ORDER BY DESC(?nb)
-</query><!-- Just insert corresponding language code instead of "en" -->
-== The most prolific speakers ==
-<query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages">
-    select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
-    where {
-        ?record prop:P2 entity:Q2 .
-        ?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
-    ORDER BY DESC(?nb)
-    LIMIT 50
-</query>
-__NOTOC__