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.

(Marked this version for translation)
(46 intermediate revisions by 6 users not shown)
Line 1: Line 1:
 
<languages/>
 
<languages/>
 +
<indicator name="stats"></indicator>
 +
{{#SUBTITLE:
 +
<translate>
 +
<!--T:13-->
 +
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.
 +
</translate>
 +
}}
 +
 
<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-->
 +
 +
<!--T:26-->
 +
<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)
 +
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 == <!--T:1-->
 
== Number of records per languages == <!--T:1-->
−
</translate>
+
 
−
<query _pagination="10" language="Item" name="Language" nb="Number of records">
+
<!--T:6-->
−
     select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
+
<!-- NEEDED IMPROVEMENT FOR READABILITY : -->
 +
<!-- * 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="Code ISO 639-3" nb="Number of records">
 +
     select ?language ?code (COUNT(DISTINCT ?record) as ?nb)
 
     where {
 
     where {
 
         ?record prop:P2 entity:Q2 .
 
         ?record prop:P2 entity:Q2 .
−
         ?record prop:P4 ?lang .
+
         ?record prop:P4 ?language .
−
 
+
         OPTIONAL { ?language prop:P13 ?code }
−
      BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
 
−
     
 
−
         SERVICE wikibase:label {
 
−
            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
−
            ?language rdfs:label ?languageLabel.
 
−
        }
 
 
     }
 
     }
−
     GROUP BY ?language ?languageLabel
+
     GROUP BY ?language ?code
 
     ORDER BY DESC(?nb)
 
     ORDER BY DESC(?nb)
 
</query>
 
</query>
  
−
<translate>
+
== The most prolific speakers == <!--T:2-->
−
== The most prolific locutors == <!--T:2-->
+
 
−
</translate>
+
<!--T:8-->
−
<query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records">
+
<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 30: Line 71:
 
         ?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 .
 
         }
 
         }
 
     }
 
     }
Line 42: Line 81:
 
</query>
 
</query>
  
−
<translate>
 
−
== The most recorded words == <!--T:3-->
 
 
</translate>
 
</translate>
−
<query _pagination=10 transcription="Transcription" nb="Number of records" language="Languages">
+
__NOTOC__
−
    select ?transcription (COUNT(?record) as ?nb) (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:P7 ?transcription.
 
−
 
 
−
        SERVICE wikibase:label {
 
−
            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
−
            ?language  rdfs:label ?languageLabel.
 
−
        }
 
−
    }
 
−
    GROUP BY ?transcription
 
−
    ORDER BY DESC(?nb)
 
−
    LIMIT 50
 
−
</query>
 

Revision as of 14:43, 10 July 2020

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


Retrieved from "https://lingualibre.org/index.php?title=LinguaLibre:Stats&oldid=285498"