LinguaLibre

Difference between revisions of "Stats/ban"

LinguaLibre Alpha wedar kapawarahang ring Agustus 2018. Ring April 2019, LiLi sampun 100,000 swara ring 46 basa olih128 pawicara maliyanan. Proyék ngantos 200,000 rekaman (82 basa, 268 pawicara) ring Januari 2020, 400,000 rekaman (107 basa, 481 pawicara) ring Pébruari 2021 miwah 500,000 rekaman (120 basa, 538 pawicara) ring Juni 2021.

(Created page with "LinguaLibré:Statistik")
 
(Updating to match new version of source page)
 
(29 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<languages/>
+
__NOTOC__
<indicator name="stats"></indicator>
+
<languages/><indicator name="stats"></indicator>{{#SUBTITLE: <div class="mw-translate-fuzzy">
{{#SUBTITLE:
+
LinguaLibre Alpha wedar  kapawarahang ring Agustus 2018. Ring April 2019, ''LiLi'' sampun '''100,000''' swara ring 46 basa olih128 pawicara maliyanan. Proyék ngantos '''200,000''' rekaman (82 basa, 268 pawicara) ring Januari 2020, '''400,000''' rekaman (107 basa, 481 pawicara) ring Pébruari 2021 miwah '''500,000''' rekaman (120 basa, 538 pawicara) ring Juni 2021.
+
</div>}}{{LinguaLibre:Stats/Menu}}
LinguaLibre Alpha release was announced on August 2018. By April 2019, ''LiLi'' reached '''100,000''' audios in 46 languages thanks to 128 different speakers. The project reached '''200,000''' recordings (82 languages, 268 speakers) in January 2020, '''400,000''' recordings (107 languages, 481 speakers) in February 2021 and '''500,000''' recordings (120 languages, 538 speakers) in June 2021.
+
== Statistik Global ==
}}
+
<query records="Rekaman" speakers="Pawicara" languages="Basa">
 
 
== Global stats ==
 
<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>
 
== Monthly activity ==
 
 
 
<query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages">
 
 
SELECT
 
SELECT
?yearmonth
 
 
(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
 +
# see Help:SPARQL_for_maintenance#.E2.9C.85_Languages_.E2.86.92_list_of_values_used_including_redirects
 
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>
== 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" -->
 
 
== The most prolific speakers ==
 
 
<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 15:47, 6 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:

Statistik Global

... Loading ...