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 • ‎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

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">
-Lingua Libre alpha foguèt anonciada 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, ne sèm a 500 000 enregistraments (dins 120  lengas, 538 locutors).
-}}
-== 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 ==
-<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" -->
-== Locutors los mai prolifics ==
-<query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records">
-SELECT ?locutor ?locutorLabel ?nb WHERE {
-  {
-    SELECT ?locutor (COUNT(?record) as ?nb)
-    WHERE {
-        ?record prop:P2 entity:Q2 .         # Q2: record, P2: instance of.
-        ?record prop:P5 ?locutor .          # Property:P5: speaker
-    }
-    GROUP BY ?locutor ?locutorLabel
-    ORDER BY DESC(?nb)
-    LIMIT 50
-  }
-  SERVICE wikibase:label {
-    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
-    ?locutor rdfs:label ?locutorLabel .
-  }
-}
-ORDER BY DESC(?nb)
-</query>
-== The most prolific speakers for the current month ==
-<query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records for the current month">
-SELECT ?locutor ?locutorLabel ?nb WHERE {
-  {
-    SELECT ?locutor (COUNT(?record) as ?nb)
-    WHERE {
-        ?record prop:P2 entity:Q2 .         # Q2: record, P2: instance of.
-        ?record prop:P5 ?locutor .          # Property:P5: speaker
-        ?record prop:P6 ?date .
-      FILTER ( YEAR(?date) = YEAR(NOW()) && MONTH(?date) = MONTH(NOW()) )
-    }
-    GROUP BY ?locutor ?locutorLabel
-    ORDER BY DESC(?nb)
-    LIMIT 50
-  }
-  SERVICE wikibase:label {
-    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
-    ?locutor rdfs:label ?locutorLabel .
-  }
-}
-ORDER BY DESC(?nb)
-</query>
-__NOTOC__