LinguaLibre
Difference between revisions of "Stats"
(32 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | < | + | <languages/> |
− | |||
− | |||
− | == Number of records per languages == | + | <translate> |
− | <query _pagination="10" language="Item" | + | <!--T:13--> |
− | select ?language | + | 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--> | ||
+ | |||
+ | <!--T:5--> | ||
+ | <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> | ||
+ | |||
+ | == History == <!--T:25--> | ||
+ | |||
+ | <!--T:26--> | ||
+ | <query yearmonth="Date" records="New records" speakers="New speakers" languages="New 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 == <!--T:1--> | ||
+ | |||
+ | <!--T:6--> | ||
+ | <query _pagination="10" language="Item" languageLabel="Language" nb="Number of records"> | ||
+ | select ?language ?languageLabel (COUNT(?record) as ?nb) | ||
where { | where { | ||
?record prop:P2 entity:Q2 . | ?record prop:P2 entity:Q2 . | ||
− | ?record prop:P4 | + | ?record prop:P4 ?language . |
− | |||
− | |||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
− | |||
} | } | ||
} | } | ||
Line 21: | Line 57: | ||
</query> | </query> | ||
− | == The most prolific | + | == The most prolific speakers == <!--T:2--> |
− | <query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records"> | + | |
+ | <!--T:8--> | ||
+ | <query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages"> | ||
select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | ||
where { | where { | ||
Line 29: | Line 67: | ||
?record prop:P4 ?lang . | ?record prop:P4 ?lang . | ||
#extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] . | #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] . | ||
− | |||
− | |||
− | |||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
+ | ?locutor rdfs:label ?locutorLabel . | ||
} | } | ||
} | } | ||
Line 41: | Line 77: | ||
</query> | </query> | ||
− | + | </translate> | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | </ |
Revision as of 20:39, 4 July 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.