Difference between revisions of "Stats/fr"

Latest revision as of 17:14, 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

Statistiques globales

... Loading ...

@@ Line 1: / Line 1: @@
-<languages/>
+__NOTOC__
-== Number of records per languages ==
+<languages/><indicator name="stats"></indicator>{{#SUBTITLE: La version alpha de Lingua Libre a été lancée en août 2018. En avril 2019, ''LiLi'' a atteint un total de '''100.000''' enregistrements audio dans 46 langues, grâce à 128 locuteurs différents. Le projet a dépassé les '''200.000''' enregistrements (82 langues, 268 locuteurs) en janvier 2020, '''500.000''' enregistrements (120 langues, 538 locuteurs) en juin 2021 et '''1.000.000" enregistrements (200 langues, 1400 locuteurs et locutrices) en octobre 2023.}}{{LinguaLibre:Stats/Menu}}
-<query _pagination="10" language="Item" name="Language" nb="Number of records">
+== Statistiques globales ==
-    select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
+<query records="Enregistrements" speakers="Locuteurs" languages="Langues">
-    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 locutors ==
-<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>