LinguaLibre

Difference between revisions of "Stats"

LinguaLibre Alpha release was announced on August 2018. By April 2019, 100,000 audios in 46 languages were available thanks to 128 variously active speakers. In January 2020, 200,000 audios in 82 languages thanks to 268 different speakers. In September 2020, the platform reached 300,000 recordings in 91 languages (357 speakers).

m (Label)
 
(57 intermediate revisions by 6 users not shown)
Line 1: Line 1:
== Number of records per languages ==
+
<languages/>
<query>
+
<indicator name="stats"></indicator>
    select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
+
{{#SUBTITLE:
    where {
+
<translate>
        ?record prop:P2 entity:Q2 .
+
<!--T:13-->
        ?record prop:P4 ?lang .
+
LinguaLibre Alpha release was announced on August 2018. By April 2019, 100,000 audios in 46 languages were available thanks to 128 variously active speakers. In January 2020, 200,000 audios in 82 languages thanks to 268 different speakers. In September 2020, the platform reached 300,000 recordings in 91 languages (357 speakers).
 +
</translate>
 +
}}
 +
 
 +
<translate>
 +
== Global stats == <!--T:4-->
 +
 
 +
<!--T:5-->
 +
<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 == <!--T:25-->
  
      BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
+
<!--T:26-->
     
+
<query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages">
        SERVICE wikibase:label {
+
SELECT
            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
+
?yearmonth
            ?language  rdfs:label ?languageLabel.
+
(COUNT(DISTINCT ?record) AS ?records)
        }
+
(COUNT(DISTINCT ?speaker) AS ?speakers)
    }
+
(COUNT(DISTINCT ?language) AS ?languages)
    GROUP BY ?language ?languageLabel
+
WHERE {
    ORDER BY DESC(?nb)
+
  ?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>
 
</query>
  
== 10 most recorded words ==
+
== Number of records per languages == <!--T:1-->
<query>
 
    select ?transcription (COUNT(?record) as ?nb) (COUNT(DISTINCT ?language) as ?nbLanguages) (GROUP_CONCAT(DISTINCT (if( ?language = entity:Q4, '???', ?languageLabel )); SEPARATOR=", ") AS ?languages)
 
    where {
 
        ?record prop:P2 entity:Q2 .
 
        ?record prop:P4 ?lang .
 
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
 
     
 
        ?record prop:P8 ?transcription.
 
  
        SERVICE wikibase:label {
+
<!--T:6-->
            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
+
<!-- NEEDED IMPROVEMENT FOR READABILITY : -->
            ?language rdfs:label ?languageLabel.
+
<!-- * add column with language name in English, ex: French, Cantonese -->
        }
+
<!-- * add column with iso3 code, ex: fra, yue -->
    }
+
<query _pagination="10" language="Item (Language Qid)" code="ISO 639-3 code" nb="Number of records">
    GROUP BY ?transcription
+
select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb)
    ORDER BY DESC(?nb)
+
where {
    LIMIT 10
+
  ?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>
 
</query>
  
== 10 most prolific locutors ==
+
== The most prolific speakers == <!--T:2-->
<query>
+
 
 +
<!--T:8-->
 +
<query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages">
 
     select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
 
     select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
 
     where {
 
     where {
Line 45: Line 72:
 
         ?record prop:P4 ?lang .
 
         ?record prop:P4 ?lang .
 
         #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
 
         #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
 
      BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
 
     
 
 
         SERVICE wikibase:label {
 
         SERVICE wikibase:label {
 
             bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
             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 10
+
     LIMIT 50
 
</query>
 
</query>
 +
 +
</translate>
 +
__NOTOC__

Latest revision as of 13:07, 10 September 2020

Other languages:
বাংলা • ‎Deutsch • ‎English • ‎español • ‎français • ‎日本語 • ‎occitan


Global stats

... Loading ...

Monthly activity

... Loading ...

Number of records per languages

... Loading ...

The most prolific speakers

... Loading ...