|
|
| (23 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| − | <languages/> | + | <languages/><indicator name="stats"></indicator>{{#SUBTITLE: <div class="mw-translate-fuzzy"> |
| − | <indicator name="stats"></indicator> | + | Альфа реліз LinguaLibre був анонсований у Серпні 2018. Станом на Квітень 2019, завдяки 128 мовцям були доступні 100,000 записів на 46 мовах. У Січні 2020, 200, 000 записів на 82 мовах завдяки 268 мовцям. У вересні 2020 платформа досягнула 300,000 записів на 91 мові (357 мовців) |
| − | {{#SUBTITLE: | + | </div>}}{{LinguaLibre:Stats/Menu}} |
| − |
| + | ==Глобальна статистика== |
| − | LinguaLibre Alpha release was announced on August 2018. By April 2019, 100,000 audios in 46 languages were available thanks to 128 variously active speakers. In January 2020, 200,000 audios in 82 languages thanks to 268 different speakers. In September 2020, the platform reached 300,000 recordings in 91 languages (357 speakers). | + | <query records="Записи" speakers="Мовці" languages="Мови"> |
| − | }} | |
| − | | |
| − | == Global stats == | |
| − | <query records="Records" speakers="Speakers" languages="Languages"> | |
| | SELECT | | SELECT |
| | (COUNT(DISTINCT ?record) AS ?records) | | (COUNT(DISTINCT ?record) AS ?records) |
| Line 17: |
Line 13: |
| | ?record prop:P4 ?language . | | ?record prop:P4 ?language . |
| | } | | } |
| − | </query>
| |
| − | ==Місячна активність==
| |
| − |
| |
| − | <query yearmonth="Дата" records="Нові записи" speakers="Активні мовці" 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>
| |
| − | ==Кількість записів на мову==
| |
| − |
| |
| − | <!-- NEEDED IMPROVEMENT FOR READABILITY : -->
| |
| − | <!-- * add column with language name in English, ex: French, Cantonese -->
| |
| − | <!-- * add column with iso3 code, ex: fra, yue -->
| |
| − | <query _pagination="10" language="Item (Language Qid)" code="ISO 639-3 code" nb="Number of records">
| |
| − | select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb)
| |
| − | where {
| |
| − | ?record prop:P2 entity:Q2 .
| |
| − | ?record prop:P4 ?language .
| |
| − | OPTIONAL { ?language prop:P13 ?code }
| |
| − | OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "en"). }
| |
| − | }
| |
| − | GROUP BY ?language ?languageLabel ?code
| |
| − | ORDER BY DESC(?nb)
| |
| − | </query><!-- Just insert corresponding language code instead of "en" -->
| |
| − | == The most prolific speakers ==
| |
| − |
| |
| − |
| |
| − | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages">
| |
| − | SELECT ?locutor ?locutorLabel ?nb WHERE {
| |
| − | {
| |
| − | SELECT ?locutor (COUNT(?record) as ?nb)
| |
| − | WHERE {
| |
| − | ?record prop:P2 entity:Q2 .
| |
| − | ?record prop:P5 ?locutor .
| |
| − | }
| |
| − | GROUP BY ?locutor ?locutorLabel
| |
| − | ORDER BY DESC(?nb)
| |
| − | LIMIT 50
| |
| − | }
| |
| − | SERVICE wikibase:label {
| |
| − | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
| |
| − | ?locutor rdfs:label ?locutorLabel .
| |
| − | }
| |
| − | }
| |
| − | ORDER BY DESC(?nb)
| |
| | </query> | | </query> |
| | | | |
| | __NOTOC__ | | __NOTOC__ |
