LinguaLibre
Difference between revisions of "Stats"
(22 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
− | <translate> | + | |
− | == Number of records per languages == | + | <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"> | ||
+ | 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) | ||
+ | (COUNT(DISTINCT ?language) AS ?languages) | ||
+ | WHERE { | ||
+ | ?record prop:P2 entity:Q2 . | ||
+ | ?record prop:P6 ?date . | ||
+ | ?record prop:P5 ?speaker . | ||
+ | ?record prop:P4 ?language . | ||
+ | BIND( SUBSTR(str(?date), 0, 8) as ?yearmonth ) | ||
+ | } | ||
+ | GROUP BY ?yearmonth | ||
+ | ORDER BY ?yearmonth | ||
+ | </query> | ||
+ | |||
+ | == 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 8: | 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 ). | |
− | |||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
Line 20: | Line 59: | ||
</query> | </query> | ||
− | + | == The most prolific speakers == <!--T:2--> | |
− | == The most prolific | + | |
− | < | + | <!--T:8--> |
− | <query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records"> | + | <query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages"> |
− | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | + | 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 30: | 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 ). | |
− | |||
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 42: | Line 82: | ||
</query> | </query> | ||
− | + | == The most recorded words == <!--T:3--> | |
− | == The most recorded words == | + | |
− | < | + | <!--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 53: | Line 93: | ||
?record prop:P7 ?transcription. | ?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. | ?language rdfs:label ?languageLabel. | ||
Line 63: | Line 102: | ||
LIMIT 50 | LIMIT 50 | ||
</query> | </query> | ||
+ | </translate> |
Revision as of 10:30, 5 April 2019
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.