Difference between revisions of "Stats/oc"

Latest revision as of 12:58, 8 October 2023

Other languages:

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

View statistics about:

Global stats Languages Speakers Chronological

Estatisticas globalas

... Loading ...

@@ Line 1: / Line 1: @@
-<languages/>
+__NOTOC__
-<indicator name="stats"></indicator>
+<languages/><indicator name="stats"></indicator>{{#SUBTITLE: Lingua Libre alpha espeliguèt en agost de 2018. Lo primièr d'abrial de 2019, "Lili" comptava  pas mens de 100 000 enregistraments   realizats dins 46 lengas, mercé a 128 locutors diferents. En genièr de 2020, i aviá mai de 200 000 enregistraments dins 82 lengas, mercé a 268 locutors.En junh de 2021,  i aviá 500 000 enregistraments (dins 120  lengas, mercé a 538 locutors) e en octobre de 2023, 1 000 000 (dins 200 lengas, mercé a 1300 locutors).}}{{LinguaLibre:Stats/Menu}}
-{{#SUBTITLE:
+== Estatisticas globalas ==
+<query records="Enregistraments" speakers="Locutors" languages="Lengas">
-<div class="mw-translate-fuzzy">
-Lingua Libre alpha foguèt anonciada en agost de 2018. Lo primièr d'abrial de 2019, pas mens de 100 000 enregistraments avián estat realizats dins 46 lengas, mercé a 128 locutors diferents. En genièr de 2020,sèm a mai de 200 000 enregistraments dins 82 lengas, mercé a 268 locutors.
-</div>
-}}
-== Estatisticas globales ==
-<query records="Records" speakers="Speakers" languages="Languages">
-SELECT
-(COUNT(DISTINCT ?record) AS ?records)
-(COUNT(DISTINCT ?speaker) AS ?speakers)
-(COUNT(DISTINCT ?language) AS ?languages)
-WHERE {
-  ?record prop:P2 entity:Q2 .
-  ?record prop:P5 ?speaker .
-  ?record prop:P4 ?language .
-}
-</query>
-== Estatisticas mensuella ==
-<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)
+(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 .
-  ?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 -->
-<div class="mw-translate-fuzzy">
-<query _pagination="10" language="Item (Language Qid)" languageLabel="Language" nb="Number of records">
-    select ?language (COUNT(DISTINCT ?record) as ?nb)
-    where {
-        ?record prop:P2 entity:Q2 .
-        ?record prop:P4 ?language .
-        SERVICE wikibase:label {
-            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
-        }
-    }
-    GROUP BY ?language ?languageLabel
-    ORDER BY DESC(?nb)
-</query>
-</div>
-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) = "fr"). }
-}
-GROUP BY ?language ?languageLabel ?code
-ORDER BY DESC(?nb)
-</query>
-== Locutors los mai prolifics ==
-<div class="mw-translate-fuzzy">
-<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>
-</div>
-    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__