LinguaLibre

Difference between revisions of "Stats"

(+Languages)
(15 intermediate revisions by 2 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.
+
<translate>
</div>
 
  
== Number of records per languages ==
+
== Global stats == <!--T:4-->
<query>
+
 
 +
<!--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:P6 ?date .
 +
  ?record prop:P5 ?speaker .
 +
  ?record prop:P4 ?language .
 +
}
 +
</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 37:
 
</query>
 
</query>
  
== 10 most recorded words ==
+
== The most prolific speakers == <!--T:2-->
<query>
+
 
     select ?transcription (COUNT(?record) as ?nb) (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: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.
+
             ?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 09:27, 28 February 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 • ‎македонски • ‎русский • ‎українська • ‎עברית • ‎বাংলা • ‎తెలుగు • ‎中文 • ‎日本語 • ‎ꯃꯤꯇꯩ ꯂꯣꯟ

Global stats

... Loading ...

Number of records per languages

... Loading ...

The most prolific speakers

... Loading ...

The most recorded words

... Loading ...