|
|
| (41 intermediate revisions by 3 users not shown) |
| Line 1: |
Line 1: |
| − | <languages/> | + | __NOTOC__ |
| − | <indicator name="stats"></indicator> | + | <languages/><indicator name="stats"></indicator>{{#SUBTITLE: Lingua Libre alpha espeliguèt en agost de 2018. Lo primièr d'abrial de 2019, "Lili" comptava pas mens de 100 000 enregistraments realizats dins 46 lengas, mercé a 128 locutors diferents. En genièr de 2020, i aviá mai de 200 000 enregistraments dins 82 lengas, mercé a 268 locutors.En junh de 2021, i aviá 500 000 enregistraments (dins 120 lengas, mercé a 538 locutors) e en octobre de 2023, 1 000 000 (dins 200 lengas, mercé a 1300 locutors).}}{{LinguaLibre:Stats/Menu}} |
| − | {{#SUBTITLE: | + | == Estatisticas globalas == |
| − |
| + | <query records="Enregistraments" speakers="Locutors" languages="Lengas"> |
| − | <div class="mw-translate-fuzzy">
| |
| − | Lingua Libre alpha foguèt anonciada en agost de 2018. Lo primièr d'abrial de 2019, pas mens de 100 000 enregistraments avián estat realizats dins 46 lengas, mercé a 128 locutors diferents. En genièr de 2020,sèm a mai de 200 000 enregistraments dins 82 lengas, mercé a 268 locutors. | |
| − | </div>
| |
| − | }}
| |
| − | | |
| − | == Global stats ==
| |
| − | <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>
| |
| − | <div class="mw-translate-fuzzy">
| |
| − | == Estatisticas mensuella == | |
| − | </div>
| |
| − | | |
| − | <query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages"> | |
| | SELECT | | SELECT |
| − | ?yearmonth
| |
| | (COUNT(DISTINCT ?record) AS ?records) | | (COUNT(DISTINCT ?record) AS ?records) |
| | (COUNT(DISTINCT ?speaker) AS ?speakers) | | (COUNT(DISTINCT ?speaker) AS ?speakers) |
| − | (COUNT(DISTINCT ?language) AS ?languages) | + | (COUNT(DISTINCT ?language) -2 AS ?languages) # Accounting for the 2 duplicata languages |
| | + | # see Help:SPARQL_for_maintenance#.E2.9C.85_Languages_.E2.86.92_list_of_values_used_including_redirects |
| | WHERE { | | WHERE { |
| | ?record prop:P2 entity:Q2 . | | ?record prop:P2 entity:Q2 . |
| − | ?record prop:P6 ?date .
| |
| | ?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> |
| − | == 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 -->
| |
| − | <div class="mw-translate-fuzzy">
| |
| − | <query _pagination="10" language="Item (Language Qid)" languageLabel="Language" nb="Number of records">
| |
| − | select ?language (COUNT(DISTINCT ?record) as ?nb)
| |
| − | where {
| |
| − | ?record prop:P2 entity:Q2 .
| |
| − | ?record prop:P4 ?language .
| |
| − |
| |
| − | SERVICE wikibase:label {
| |
| − | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
| |
| − | }
| |
| − | }
| |
| − | GROUP BY ?language ?languageLabel
| |
| − | ORDER BY DESC(?nb)
| |
| − | </query>
| |
| − | </div>
| |
| − | 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) = "fr"). }
| |
| − | }
| |
| − | GROUP BY ?language ?languageLabel ?code
| |
| − | ORDER BY DESC(?nb)
| |
| − | </query>
| |
| − | == Locutors los mai prolifics ==
| |
| − |
| |
| − |
| |
| − | <div class="mw-translate-fuzzy">
| |
| − | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages">
| |
| − | select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
| |
| − | where {
| |
| − | ?record prop:P2 entity:Q2 .
| |
| − | ?record prop:P5 ?locutor .
| |
| − | ?record prop:P4 ?lang .
| |
| − | #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
| |
| − | SERVICE wikibase:label {
| |
| − | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
| |
| − | ?locutor rdfs:label ?locutorLabel .
| |
| − | }
| |
| − | }
| |
| − | GROUP BY ?locutor ?locutorLabel
| |
| − | ORDER BY DESC(?nb)
| |
| − | LIMIT 50
| |
| − | </query>
| |
| − | </div>
| |
| − | select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
| |
| − | where {
| |
| − | ?record prop:P2 entity:Q2 .
| |
| − | ?record prop:P5 ?locutor .
| |
| − | ?record prop:P4 ?lang .
| |
| − | #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
| |
| − | SERVICE wikibase:label {
| |
| − | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
| |
| − | ?locutor rdfs:label ?locutorLabel .
| |
| − | }
| |
| − | }
| |
| − | GROUP BY ?locutor ?locutorLabel
| |
| − | ORDER BY DESC(?nb)
| |
| − | LIMIT 50
| |
| − | </query>
| |
| − |
| |
| − | __NOTOC__
| |
