LinguaLibre

Difference between revisions of "Stats"

m
(22 intermediate revisions by 5 users not shown)
Line 1: Line 1:
 
<languages/>
 
<languages/>
<translate>
+
 
 +
<translate>  
 +
<!--T:13-->
 +
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 == <!--T:4-->
 
== Global stats == <!--T:4-->
Line 7: Line 10:
 
<query records="Records" speakers="Speakers" languages="Languages">
 
<query records="Records" speakers="Speakers" languages="Languages">
 
SELECT
 
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 ?record) AS ?records)
 
(COUNT(DISTINCT ?speaker) AS ?speakers)
 
(COUNT(DISTINCT ?speaker) AS ?speakers)
Line 15: Line 34:
 
   ?record prop:P5 ?speaker .
 
   ?record prop:P5 ?speaker .
 
   ?record prop:P4 ?language .
 
   ?record prop:P4 ?language .
 +
  BIND( SUBSTR(str(?date), 0, 8) as ?yearmonth )
 
}
 
}
 +
GROUP BY ?yearmonth
 +
ORDER BY ?yearmonth
 
</query>
 
</query>
  
Line 21: Line 43:
  
 
<!--T:6-->
 
<!--T:6-->
<query _pagination="10" language="Item" name="Language" nb="Number of records">
+
<query _pagination="10" language="Item (Language Qid)" languageLabel="Language" nb="Number of records">
     select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
+
     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 ).
 
 
        
 
        
 
         SERVICE wikibase:label {
 
         SERVICE wikibase:label {
 
             bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
             bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
            ?language  rdfs:label ?languageLabel.
 
 
         }
 
         }
 
     }
 
     }
Line 40: Line 60:
  
 
<!--T:8-->
 
<!--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 47: 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 .
 
         }
 
         }
 
     }
 
     }
Line 58: Line 77:
 
</query>
 
</query>
  
== The most recorded words == <!--T:3-->
 
 
<!--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 {
 
        ?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>
 
 
</translate>
 
</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 ...