LinguaLibre

Difference between revisions of "Stats"

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.

m (forgot the month)
(46 intermediate revisions by 7 users not shown)
Line 1: Line 1:
 
<languages/>
 
<languages/>
 
+
<indicator name="stats"></indicator>
 +
{{#SUBTITLE:
 
<translate>  
 
<translate>  
 
<!--T:13-->
 
<!--T:13-->
LinguaLibre Alpha release was announced on August 2018. As of April 1st, 2019 (8 months), nearly 100,000 audios have been recorded in 46 languages, thanks to 128 variously active speakers.  
+
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.
 +
</translate>
 +
}}
  
 +
<translate>
 
== Global stats == <!--T:4-->
 
== Global stats == <!--T:4-->
 
+
</translate>
<!--T:5-->
+
<query records="<translate><!--T:30--> Records</translate>" speakers="<translate><!--T:31--> Speakers</translate>" languages="<translate><!--T:32--> Languages</translate>">
<query records="Records" speakers="Speakers" languages="Languages">
 
 
SELECT
 
SELECT
 
(COUNT(DISTINCT ?record) AS ?records)
 
(COUNT(DISTINCT ?record) AS ?records)
Line 19: Line 22:
 
}
 
}
 
</query>
 
</query>
 +
<translate>
 +
== Monthly activity == <!--T:25-->
 +
</translate>
  
== History == <!--T:25-->
+
<query yearmonth="<translate><!--T:33--> Date</translate>" records="<translate><!--T:34--> New records</translate>" speakers="<translate><!--T:35--> Active speakers</translate>" languages="<translate><!--T:36--> Active languages</translate>">
 
 
<!--T:26-->
 
<query yearmonth="Date" records="New records" speakers="New speakers" languages="New languages">
 
 
SELECT
 
SELECT
 
?yearmonth
 
?yearmonth
Line 39: Line 42:
 
ORDER BY ?yearmonth
 
ORDER BY ?yearmonth
 
</query>
 
</query>
 +
<translate>
 +
== Number of records per languages == <!--T:1-->
 +
</translate>
 +
 +
<query _pagination="10" language="<translate><!--T:37--> Item (Language Qid)</translate>" code="<translate><!--T:38--> ISO 639-3 code</translate>" nb="<translate><!--T:39--> Number of records</translate>">
 +
select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb)
 +
<translate>
 +
<!--T:7-->
 +
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" --></translate>
 +
<translate>
  
== Number of records per languages == <!--T:1-->
+
== The most prolific speakers == <!--T:2-->
 +
</translate>
  
<!--T:6-->
+
<query _pagination="10" locutor="<translate><!--T:40--> Item (locutor Qid)</translate>" locutorLabel="<translate><!--T:41--> Speaker</translate>" nb="<translate><!--T:42--> Number of records</translate>">
<query _pagination="10" language="Item" languageLabel="Language" nb="Number of records">
+
SELECT ?locutor ?locutorLabel ?nb WHERE {
     select ?language ?languageLabel (COUNT(?record) as ?nb)
+
  {
     where {
+
     SELECT ?locutor (COUNT(?record) as ?nb)
         ?record prop:P2 entity:Q2 .
+
     WHERE {
         ?record prop:P4 ?language .
+
         ?record prop:P2 entity:Q2 .        # Q2: record, P2: instance of.
     
+
         ?record prop:P5 ?locutor .         # Property:P5: speaker
        SERVICE wikibase:label {
 
            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
        }
 
 
     }
 
     }
     GROUP BY ?language ?languageLabel
+
     GROUP BY ?locutor ?locutorLabel
 
     ORDER BY DESC(?nb)
 
     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>
 
</query>
  
== The most prolific speakers == <!--T:2-->
+
<translate>
 +
== The most prolific speakers for the current month == <!--T:28-->
 +
</translate>
  
<!--T:8-->
+
<query _pagination="10" locutor="<translate><!--T:43--> Item (locutor Qid)</translate>" locutorLabel="<translate><!--T:44--> Speaker</translate>" nb="<translate><!--T:45--> Number of records for the current month</translate>">
<query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages">
+
SELECT ?locutor ?locutorLabel ?nb WHERE {
    select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
+
  {
     where {
+
    SELECT ?locutor (COUNT(?record) as ?nb)
         ?record prop:P2 entity:Q2 .
+
     WHERE {
         ?record prop:P5 ?locutor .
+
         ?record prop:P2 entity:Q2 .        # Q2: record, P2: instance of.
         ?record prop:P4 ?lang .
+
         ?record prop:P5 ?locutor .         # Property:P5: speaker
        #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
+
        ?record prop:P6 ?date .
        SERVICE wikibase:label {
+
      FILTER ( YEAR(?date) = YEAR(NOW()) && MONTH(?date) = MONTH(NOW()) )
            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
            ?locutor rdfs:label ?locutorLabel .
 
        }
 
 
     }
 
     }
 
     GROUP BY ?locutor ?locutorLabel
 
     GROUP BY ?locutor ?locutorLabel
 
     ORDER BY DESC(?nb)
 
     ORDER BY DESC(?nb)
 
     LIMIT 50
 
     LIMIT 50
 +
  }
 +
  SERVICE wikibase:label {
 +
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 +
    ?locutor rdfs:label ?locutorLabel .
 +
  }
 +
}
 +
ORDER BY DESC(?nb)
 
</query>
 
</query>
  
</translate>
+
__NOTOC__

Revision as of 15:36, 17 June 2021

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 • ‎македонски • ‎русский • ‎українська • ‎עברית • ‎বাংলা • ‎తెలుగు • ‎中文 • ‎日本語 • ‎ꯃꯤꯇꯩ ꯂꯣꯟ


Global stats

... Loading ...

Monthly activity

... Loading ...

Number of records per languages

... Loading ...

The most prolific speakers

... Loading ...

The most prolific speakers for the current month

... Loading ...