LinguaLibre

Difference between revisions of "Stats"

(10 most recorded words)
Line 4: Line 4:
  
 
== Number of records per languages ==
 
== Number of records per languages ==
<query>
+
<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 {
Line 21: Line 21:
 
</query>
 
</query>
  
== 10 most recorded words ==
+
== The most prolific locutors ==
<query>
+
<query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records">
     select ?transcription (COUNT(?record) as ?nb) (GROUP_CONCAT(DISTINCT (if( ?language = entity:Q4, '???', ?languageLabel )); SEPARATOR=", ") AS ?languages)
+
     select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
 
     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.
 
 
         }
 
         }
 
     }
 
     }
     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 ==
<query>
+
<query _pagination=10 transcription="Transcription" nb="Number of records" language="Languages">
     select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
+
     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 ).
 +
     
 +
        ?record prop:P7 ?transcription.
  
      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.
 
         }
 
         }
 
     }
 
     }
     GROUP BY ?locutor ?locutorLabel
+
     GROUP BY ?transcription
 
     ORDER BY DESC(?nb)
 
     ORDER BY DESC(?nb)
     LIMIT 10
+
     LIMIT 50
 
</query>
 
</query>

Revision as of 19:20, 24 June 2018

During the beta, data shown here are refresh only once a day.

Number of records per languages

... Loading ...

The most prolific locutors

... Loading ...

The most recorded words

... Loading ...