LinguaLibre
Difference between revisions of "Stats/uk"
Альфа реліз LinguaLibre був анонсований у Серпні 2018. Станом на Квітень 2019, завдяки 128 мовцям були доступні 100,000 записів на 46 мовах. У Січні 2020, 200, 000 записів на 82 мовах завдяки 268 мовцям. У вересні 2020 платформа досягнула 300,000 записів на 91 мові (357 мовців)
(Updating to match new version of source page) |
(Updating to match new version of source page) |
||
Line 9: | Line 9: | ||
==Глобальна статистика== | ==Глобальна статистика== | ||
− | <query records=" | + | <query records="Records" speakers="Speakers" languages="Languages"> |
SELECT | SELECT | ||
(COUNT(DISTINCT ?record) AS ?records) | (COUNT(DISTINCT ?record) AS ?records) | ||
Line 22: | Line 22: | ||
==Місячна активність== | ==Місячна активність== | ||
− | <query yearmonth=" | + | <query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages"> |
SELECT | SELECT | ||
?yearmonth | ?yearmonth | ||
Line 40: | Line 40: | ||
==Кількість записів на мову== | ==Кількість записів на мову== | ||
− | <query _pagination="10" language=" | + | <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) | select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb) | ||
where { | where { | ||
Line 54: | Line 54: | ||
==Найактивніші мовці== | ==Найактивніші мовці== | ||
+ | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records"> | ||
+ | SELECT ?locutor ?locutorLabel ?nb WHERE { | ||
+ | { | ||
+ | SELECT ?locutor (COUNT(?record) as ?nb) | ||
+ | WHERE { | ||
+ | ?record prop:P2 entity:Q2 . # Q2: record, P2: instance of. | ||
+ | ?record prop:P5 ?locutor . # Property:P5: speaker | ||
+ | } | ||
+ | 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> | ||
+ | |||
+ | == The most prolific speakers for the current month == | ||
− | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records | + | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records for the current month"> |
SELECT ?locutor ?locutorLabel ?nb WHERE { | SELECT ?locutor ?locutorLabel ?nb WHERE { | ||
{ | { | ||
SELECT ?locutor (COUNT(?record) as ?nb) | SELECT ?locutor (COUNT(?record) as ?nb) | ||
WHERE { | WHERE { | ||
− | ?record prop:P2 entity:Q2 . | + | ?record prop:P2 entity:Q2 . # Q2: record, P2: instance of. |
− | ?record prop:P5 ?locutor . | + | ?record prop:P5 ?locutor . # Property:P5: speaker |
+ | ?record prop:P6 ?date . | ||
+ | FILTER ( YEAR(?date) = YEAR(NOW()) && MONTH(?date) = MONTH(NOW()) ) | ||
} | } | ||
GROUP BY ?locutor ?locutorLabel | GROUP BY ?locutor ?locutorLabel |
Revision as of 13:29, 5 May 2021
Глобальна статистика
Місячна активність
Кількість записів на мову
Найактивніші мовці
The most prolific speakers for the current month