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__
-== Number of records per languages ==
+<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}}
-<query _pagination="10" language="Item" name="Language" nb="Number of records">
+== Global stats ==
-    select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
+<query records="Records" speakers="Speakers" languages="Languages">
-    where {
+SELECT
-        ?record prop:P2 entity:Q2 .
+(COUNT(DISTINCT ?record) AS ?records)
-        ?record prop:P4 ?lang .
+(COUNT(DISTINCT ?speaker) AS ?speakers)
+(COUNT(DISTINCT ?language) -2 AS ?languages) # Accounting for the 2 duplicata languages
-      	BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
+# see Help:SPARQL_for_maintenance#.E2.9C.85_Languages_.E2.86.92_list_of_values_used_including_redirects
+WHERE {
-        SERVICE wikibase:label {
+  ?record prop:P2 entity:Q2 .
-            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
+  ?record prop:P5 ?speaker .
-            ?language  rdfs:label ?languageLabel.
+  ?record prop:P4 ?language .
-        }
+}
-    }
-    GROUP BY ?language ?languageLabel
-    ORDER BY DESC(?nb)
-</query>
-== The most prolific speakers ==
-<query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records">
-    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 50
-</query>
-== The most recorded words ==
-<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>