LinguaLibre

Difference between revisions of "Stats/oc"

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).

(Created page with "Nombre d'enregistraments")
 
(20 intermediate revisions by 2 users not shown)
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 ==
 
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="Enregistraments" speakers="Locutors" languages="Lengas">
 
<query records="Enregistraments" speakers="Locutors" languages="Lengas">
 
SELECT
 
SELECT
 
(COUNT(DISTINCT ?record) AS ?records)
 
(COUNT(DISTINCT ?record) AS ?records)
 
(COUNT(DISTINCT ?speaker) AS ?speakers)
 
(COUNT(DISTINCT ?speaker) AS ?speakers)
(COUNT(DISTINCT ?language) AS ?languages)
+
(COUNT(DISTINCT ?language) -2 AS ?languages) # Accounting for the 2 duplicata languages
WHERE {
+
# see Help:SPARQL_for_maintenance#.E2.9C.85_Languages_.E2.86.92_list_of_values_used_including_redirects
  ?record prop:P2 entity:Q2 .
 
  ?record prop:P5 ?speaker .
 
  ?record prop:P4 ?language .
 
}
 
</query>
 
== Estatisticas mensuella ==
 
 
 
<query yearmonth="Data" records="Enregistraments novèls" speakers="Locutors actius" languages="Lengas activas">
 
SELECT
 
?yearmonth
 
(COUNT(DISTINCT ?record) AS ?records)
 
(COUNT(DISTINCT ?speaker) AS ?speakers)
 
(COUNT(DISTINCT ?language) AS ?languages)
 
 
WHERE {
 
WHERE {
 
   ?record prop:P2 entity:Q2 .
 
   ?record prop:P2 entity:Q2 .
  ?record prop:P6 ?date .
 
 
   ?record prop:P5 ?speaker .
 
   ?record prop:P5 ?speaker .
 
   ?record prop:P4 ?language .
 
   ?record prop:P4 ?language .
  BIND( SUBSTR(str(?date), 0, 8) as ?yearmonth )
 
 
}
 
}
GROUP BY ?yearmonth
 
ORDER BY ?yearmonth
 
 
</query>
 
</query>
== Nombre d'enregistraments per lenga ==
 
 
<query _pagination="10" language="Element (identificant de la lenga)" code="còdi ISO 639-3" nb="Nombre d'enregistraments">
 
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__
 

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:

Estatisticas globalas

... Loading ...