LinguaLibre

Difference between revisions of "Stats"

(il semble qu'il n'y ait pas le choix, il faut autoriser la traduction de toute la requête (pour ne traduire que les libellés))
(14 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
<languages/>
 
<languages/>
<translate>
 
  
== Global stats ==
+
<translate>
 +
<!--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">
 
<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 14: 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>
  
 
== Number of records per languages == <!--T:1-->
 
== Number of records per languages == <!--T:1-->
  
 +
<!--T:6-->
 
<query _pagination="10" language="Item" name="Language" nb="Number of records">
 
<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)
Line 24: Line 48:
 
         ?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 38: Line 61:
 
== The most prolific speakers == <!--T:2-->
 
== The most prolific speakers == <!--T:2-->
  
<query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records">
+
<!--T:8-->
     select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
+
<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 .
Line 45: Line 69:
 
         ?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 ).
      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" .
 +
            ?lang rdfs:label ?langLabel .
 +
            ?locutor rdfs:label ?locutorLabel .
 
         }
 
         }
 
     }
 
     }
Line 59: Line 84:
 
== The most recorded words == <!--T:3-->
 
== The most recorded words == <!--T:3-->
  
 +
<!--T:10-->
 
<query _pagination=10 transcription="Transcription" nb="Number of records" language="Languages">
 
<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)
 
     select ?transcription (COUNT(?record) as ?nb) (GROUP_CONCAT(DISTINCT (if( ?language = entity:Q4, '???', ?languageLabel )); SEPARATOR=", ") AS ?languages)
Line 67: Line 93:
 
        
 
        
 
         ?record prop:P7 ?transcription.
 
         ?record prop:P7 ?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.
 
             ?language  rdfs:label ?languageLabel.

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