Difference between revisions of "Stats"

Latest revision as of 16:32, 27 June 2024

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: @@
-<div style="color:red; text-align: center;">
+__NOTOC__
-The SPARQL endpoint isn't ready yet, come back in a few days :)
+<languages/><indicator name="stats"></indicator>{{#SUBTITLE:<translate> <!--T:13-->
-</div>
+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. By June 2024, there were 1,250,000 recordings (250 languages, 2050 speakers).
+</translate>}}{{LinguaLibre:Stats/Menu}}
-== Number of records per languages ==
+<translate>
-<query>
+== Global stats == <!--T:4-->
-    select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
+</translate>
-    where {
+<query records="<translate><!--T:30--> Records</translate>" speakers="<translate><!--T:31--> Speakers</translate>" languages="<translate><!--T:32--> Languages</translate>">
-        ?record prop:P2 entity:Q2 .
+SELECT
-        ?record prop:P4 ?lang .
+(COUNT(DISTINCT ?record) AS ?records)
+(COUNT(DISTINCT ?speaker) AS ?speakers)
-      	BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
+(COUNT(DISTINCT ?language) AS ?languages)
+# see Help:SPARQL_for_maintenance#.E2.9C.85_Languages_.E2.86.92_list_of_values_used_including_redirects
-        SERVICE wikibase:label {
+WHERE {
-            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
+  ?record prop:P2 entity:Q2 .
-            ?language  rdfs:label ?languageLabel.
+  ?record prop:P5 ?speaker .
-        }
+  ?record prop:P4 ?language .
-    }
+}
-    GROUP BY ?language ?languageLabel
-    ORDER BY DESC(?nb)
-</query>
-== 10 most recorded words ==
-<query>
-    select ?transcription (COUNT(?record) as ?nb) (COUNT(DISTINCT ?language) as ?nbLanguages) (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:P8 ?transcription.
-        SERVICE wikibase:label {
-            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
-            ?language  rdfs:label ?languageLabel.
-        }
-    }
-    GROUP BY ?transcription
-    ORDER BY DESC(?nb)
-    LIMIT 10
-</query>
-== 10 most prolific locutors ==
-<query>
-    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] .
-      	BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
-        SERVICE wikibase:label {
-            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
-        }
-    }
-    GROUP BY ?locutor ?locutorLabel
-    ORDER BY DESC(?nb)
-    LIMIT 10
 </query>