LinguaLibre
Difference between revisions of "Stats/oc"
m (FuzzyBot moved page DataViz:Stats/oc to LinguaLibre:Stats/oc without leaving a redirect: Part of translatable page "DataViz:Stats") |
(Updating to match new version of source page) |
||
| Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
| + | |||
| + | == Global stats == | ||
| + | |||
| + | <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 == | == Number of records per languages == | ||
| + | |||
<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 19: | Line 36: | ||
== Locutors los mai prolifics == | == Locutors los mai prolifics == | ||
| + | |||
<query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records"> | <query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records"> | ||
select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | ||
| Line 38: | Line 56: | ||
</query> | </query> | ||
| + | == Mots los mai enregistrats == | ||
| − | |||
<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) | ||