LinguaLibre

Difference between revisions of "Stats"

(27 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div style="color:red; text-align: center;">
+
<languages/>
During the beta, data shown here are refresh only once a day.
 
</div>
 
  
== Number of records per languages ==
+
<translate>
<query>
+
<!--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.
 +
 
 +
== 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>
 +
 
 +
== History == <!--T:25-->
 +
 
 +
<!--T:26-->
 +
<query yearmonth="Date" records="New records" speakers="New speakers" languages="New 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-->
 +
 
 +
<!--T:6-->
 +
<query _pagination="10" language="Item" name="Language" nb="Number of records">
 
     select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
 
     select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
 
     where {
 
     where {
 
         ?record prop:P2 entity:Q2 .
 
         ?record prop:P2 entity:Q2 .
 
         ?record prop:P4 ?lang .
 
         ?record prop:P4 ?lang .
 
+
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
      BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
 
 
        
 
        
 
         SERVICE wikibase:label {
 
         SERVICE wikibase:label {
Line 21: Line 59:
 
</query>
 
</query>
  
== 10 most recorded words ==
+
== The most prolific speakers == <!--T:2-->
<query>
+
 
     select ?transcription (COUNT(?record) as ?nb) (COUNT(DISTINCT ?language) as ?nbLanguages) (GROUP_CONCAT(DISTINCT (if( ?language = entity:Q4, '???', ?languageLabel )); SEPARATOR=", ") AS ?languages)
+
<!--T:8-->
 +
<query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages">
 +
     select ?locutor ?locutorLabel (COUNT(?record) as ?nb) (GROUP_CONCAT(DISTINCT ?langLabel;separator=", ") as ?languages)
 
     where {
 
     where {
 
         ?record prop:P2 entity:Q2 .
 
         ?record prop:P2 entity:Q2 .
 +
        ?record prop:P5 ?locutor .
 
         ?record prop:P4 ?lang .
 
         ?record prop:P4 ?lang .
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
+
        #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
 +
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
 
        
 
        
        ?record prop:P8 ?transcription.
 
 
 
         SERVICE wikibase:label {
 
         SERVICE wikibase:label {
 
             bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
             bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
             ?language  rdfs:label ?languageLabel.
+
             ?lang rdfs:label ?langLabel .
 +
            ?locutor rdfs:label ?locutorLabel .
 
         }
 
         }
 
     }
 
     }
     GROUP BY ?transcription
+
     GROUP BY ?locutor ?locutorLabel
 
     ORDER BY DESC(?nb)
 
     ORDER BY DESC(?nb)
     LIMIT 10
+
     LIMIT 50
 
</query>
 
</query>
  
== 10 most prolific locutors ==
+
== The most recorded words == <!--T:3-->
<query>
+
 
     select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
+
<!--T:10-->
 +
<query _pagination=10 transcription="Transcription" nb="Number of records" language="Languages">
 +
     select ?transcription (COUNT(?record) as ?nb) (GROUP_CONCAT(DISTINCT (if( ?language = entity:Q4, '???', ?languageLabel )); SEPARATOR=", ") AS ?languages)
 
     where {
 
     where {
 
         ?record prop:P2 entity:Q2 .
 
         ?record prop:P2 entity:Q2 .
        ?record prop:P5 ?locutor .
 
 
         ?record prop:P4 ?lang .
 
         ?record prop:P4 ?lang .
        #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
+
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
 
 
      BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
 
 
        
 
        
         SERVICE wikibase:label {
+
         ?record prop:P7 ?transcription.
 +
SERVICE wikibase:label {
 
             bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
             bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 +
            ?language  rdfs:label ?languageLabel.
 
         }
 
         }
 
     }
 
     }
     GROUP BY ?locutor ?locutorLabel
+
     GROUP BY ?transcription
 
     ORDER BY DESC(?nb)
 
     ORDER BY DESC(?nb)
     LIMIT 10
+
     LIMIT 50
 
</query>
 
</query>
 +
</translate>

Revision as of 10:30, 5 April 2019

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


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.

Global stats

... Loading ...

History

... Loading ...

Number of records per languages

... Loading ...

The most prolific speakers

... Loading ...

The most recorded words

... Loading ...