LinguaLibre
Difference between revisions of "Stats"
(Marked this version for translation) |
(+ history query) |
||
| Line 5: | Line 5: | ||
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. | 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 23: | 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 == | ||
| + | <query yearmonth="Date" records="Records" speakers="Speakers" languages="Languages"> | ||
| + | SELECT | ||
| + | ?yearmonth | ||
(COUNT(DISTINCT ?record) AS ?records) | (COUNT(DISTINCT ?record) AS ?records) | ||
(COUNT(DISTINCT ?speaker) AS ?speakers) | (COUNT(DISTINCT ?speaker) AS ?speakers) | ||
| Line 31: | Line 32: | ||
?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> | ||
Revision as of 00:42, 2 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.