LinguaLibre

Difference between revisions of "Stats"

(41 intermediate revisions by 5 users not shown)
Line 1: Line 1:
== Number of records per languages ==
+
<languages/>
<query>
+
 
    select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
+
<translate>
    where {
+
<!--T:13-->
        ?record prop:P2 entity:Q2 .
+
LinguaLibre Alpha release was announced on August 2018. As of April 1st 2019 (8 months): 100,000 audios have been recorded in 46 languages, thanks to 128 variously active speakers. In January 2020, more than 200,000 audios have already been recorded, in 82 languages and thanks to 268 different speakers.
        ?record prop:P4 ?lang .
+
 
 +
== 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-->
  
      BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
+
<!--T:26-->
     
+
<query yearmonth="Date" records="New records" speakers="New speakers" languages="New 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)
+
<!--T:6-->
 +
<query _pagination="10" language="Item (Language Qid)" languageLabel="Language" nb="Number of records">
 +
     select ?language (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 .
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.
 
 
         }
 
         }
 
     }
 
     }
     GROUP BY ?transcription
+
     GROUP BY ?language ?languageLabel
 
     ORDER BY DESC(?nb)
 
     ORDER BY DESC(?nb)
    LIMIT 10
 
 
</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 67:
 
         ?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>

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


LinguaLibre Alpha release was announced on August 2018. As of April 1st 2019 (8 months): 100,000 audios have been recorded in 46 languages, thanks to 128 variously active speakers. In January 2020, more than 200,000 audios have already been recorded, in 82 languages and thanks to 268 different speakers.

Global stats

... Loading ...

History

... Loading ...

Number of records per languages

... Loading ...

The most prolific speakers

... Loading ...