LinguaLibre
Difference between revisions of "Stats"
m |
|||
(10 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
− | <translate> | + | |
+ | <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--> | == Global stats == <!--T:4--> | ||
Line 7: | Line 10: | ||
<query records="Records" speakers="Speakers" languages="Languages"> | <query records="Records" speakers="Speakers" languages="Languages"> | ||
SELECT | 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 ?record) AS ?records) | ||
(COUNT(DISTINCT ?speaker) AS ?speakers) | (COUNT(DISTINCT ?speaker) AS ?speakers) | ||
Line 15: | Line 34: | ||
?record prop:P5 ?speaker . | ?record prop:P5 ?speaker . | ||
?record prop:P4 ?language . | ?record prop:P4 ?language . | ||
+ | BIND( SUBSTR(str(?date), 0, 8) as ?yearmonth ) | ||
} | } | ||
+ | GROUP BY ?yearmonth | ||
+ | ORDER BY ?yearmonth | ||
</query> | </query> | ||
Line 40: | Line 62: | ||
<!--T:8--> | <!--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 51: | Line 73: | ||
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 . | ||
} | } | ||
} | } |
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.