|
|
(41 intermediate revisions by 2 users not shown) |
Line 1: |
Line 1: |
− | <languages/> | + | __NOTOC__ |
− | <indicator name="stats"></indicator> | + | <languages/><indicator name="stats"></indicator>{{#SUBTITLE: LinguaLibre Alpha annonserades i augusti 2018. I april 2019 nådde LinugaLibre '''100,000''' ljudfiler på 46 språk tack vare 128 olika aktiva talare; '''200,000''' ljudfiler (82 språk, 268 olika talare) |
− | {{#SUBTITLE: | + | januari 2020; '''400,000''' inspelningar (107 språk, 481 talare) februari 2021 och '''500,000''' inspelningar (120 språk, 538 talare) juni 2021.}}{{LinguaLibre:Stats/Menu}} |
− |
| + | == Global statistik == |
− | LinguaLibre Alpha-utgåvan annonserades i augusti 2018. I april 2019 hade 100,000 ljudfiler skickats in på 46 språk tack vare 128 olika aktiva talare. I januari 2020 nådde plattformen 200,000 ljudfiler på 82 språk tack vare 268 olika talare. I september 2020 nådde plattformen 300,000 inspelningar på 91 språk (357 talare). | + | <query records="Inspelningar" speakers="Talare" languages="Språk"> |
− | }} | |
− | | |
− | == Global stats == | |
− | <query records="Records" speakers="Speakers" languages="Languages"> | |
| SELECT | | SELECT |
| (COUNT(DISTINCT ?record) AS ?records) | | (COUNT(DISTINCT ?record) AS ?records) |
Line 18: |
Line 14: |
| } | | } |
| </query> | | </query> |
− | == Monthly activity ==
| |
− |
| |
− | <query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active 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 ==
| |
− |
| |
− | <!-- 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>
| |
− |
| |
− | __NOTOC__
| |