LinguaLibre
Difference between revisions of "Stats/fr"
Lingua Libre alpha a été annoncé en août 2018. Au 1er avril 2019 (8 mois), près de 100000 enregistrements audio ont été enregistrés dans 46 langues, grâce à 128 locuteurs différents. En janvier 2020 (~18 mois), 200 000+ audios ont été enregistrés dans 82 langues, grâce à 268 locuteurs différents. En Septembre 2020, la plateforme a atteint 300 000 enregistrements, en 91 langues et grâce à 357 locuteurs.
WikiLucas00 (talk | contribs) |
(Updating to match new version of source page) |
||
Line 7: | Line 7: | ||
== Statistiques globales == | == Statistiques globales == | ||
− | + | <div class="mw-translate-fuzzy"> | |
<query records="Enregistrements" speakers="Locuteurs" languages="Langues"> | <query records="Enregistrements" speakers="Locuteurs" languages="Langues"> | ||
SELECT | SELECT | ||
Line 19: | Line 19: | ||
} | } | ||
</query> | </query> | ||
− | + | </div> | |
+ | 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> | ||
== Activité mensuelle == | == Activité mensuelle == | ||
+ | <div class="mw-translate-fuzzy"> | ||
<query yearmonth="Date" records="Nouveaux enregistrements" speakers="Locuteurs actifs" languages="Langues actives"> | <query yearmonth="Date" records="Nouveaux enregistrements" speakers="Locuteurs actifs" languages="Langues actives"> | ||
SELECT | SELECT | ||
Line 38: | Line 49: | ||
ORDER BY ?yearmonth | ORDER BY ?yearmonth | ||
</query> | </query> | ||
− | + | </div> | |
+ | 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> | ||
== Nombre d'enregistrements par langue == | == Nombre d'enregistrements par langue == | ||
+ | <!-- 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="Élément (Qid de la langue)" code="code ISO 639-3" nb="Nombre d'enregistrements"> | <query _pagination="10" language="Élément (Qid de la langue)" code="code ISO 639-3" nb="Nombre d'enregistrements"> | ||
select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb) | select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb) | ||
Line 52: | Line 82: | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
</query> | </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> | ||
+ | == Les locuteurs les plus prolifiques == | ||
− | |||
+ | <div class="mw-translate-fuzzy"> | ||
<query _pagination="10" locutor="Élément (Qid du locuteur ou de la locutrice)" locutorLabel="Locuteur ou locutrice" nb="Nombre d'enregistrements" languages="Langues parlées"> | <query _pagination="10" locutor="Élément (Qid du locuteur ou de la locutrice)" locutorLabel="Locuteur ou locutrice" nb="Nombre d'enregistrements" languages="Langues parlées"> | ||
+ | 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) | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | ||
where { | where { |
Revision as of 21:38, 10 October 2020
Statistiques globales
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>
Activité mensuelle
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>
Nombre d'enregistrements par langue
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>
Les locuteurs les plus prolifiques
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>