Difference between revisions of "Stats"

Revision as of 20:39, 4 July 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 ...

@@ Line 5: / Line 5: @@
 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.
-=== History === <!--T:14--></translate>
-{| class="wikitable"
-! <translate> <!--T:15--> Date </translate>  <!-- YYYY.MM.DD--> || <translate><!--T:16--> Items</translate> || <translate><!--T:17--> Speakers</translate> || <translate><!--T:18--> Languages</translate> || <translate><!--T:19--> Comment</translate>
-|-
-| <translate><!--T:20--> 2018.08</translate> || ? || ~10 || 5 || <translate><!--T:21--> Alpha release; Mainly tests.</translate>
-|-
-| <translate><!--T:22--> 2018.12</translate> || ? || ? || ? || <translate><!--T:23--> Beta release.</translate>
-|-
-| <translate><!--T:24--> 2019.04.01</translate> || 93173 || 128 || 46 ||
-|}
-<translate>
 == Global stats == <!--T:4-->
@@ Line 23: / Line 10: @@
 <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)
@@ Line 31: / Line 34: @@
    ?record prop:P5 ?speaker .
    ?record prop:P4 ?language .
+  BIND( SUBSTR(str(?date), 0, 8) as ?yearmonth )
 }
+GROUP BY ?yearmonth
+ORDER BY ?yearmonth
 </query>
@@ Line 37: / Line 43: @@
 <!--T:6-->
-<query _pagination="10" language="Item" name="Language" nb="Number of records">
+<query _pagination="10" language="Item" languageLabel="Language" nb="Number of records">
-     select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
+     select ?language ?languageLabel (COUNT(?record) as ?nb)
      where {
          ?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 {
              bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
-            ?language  rdfs:label ?languageLabel.
          }
      }
@@ Line 57: / Line 61: @@
 <!--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)
+     select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
      where {
          ?record prop:P2 entity:Q2 .
@@ Line 63: / Line 67: @@
          ?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 ).
          SERVICE wikibase:label {
              bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
-            ?lang rdfs:label ?langLabel .
              ?locutor rdfs:label ?locutorLabel .
          }
@@ Line 76: / Line 77: @@
 </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>