LinguaLibre
Difference between revisions of "Stats/bn"
লিঙ্গুয়ালিব্রে আলফা ২০১৮ সালের অগাস্ট মাসে প্রথম ঘোষিত হয়। ১ এপ্রিল ২০১৯ তারিখের হিসাবনুয়ায়ী (৮ মাস): ৪৬ টি ভাষায় ১ লক্ষ অডিও রেকর্ড করা হয়, thanks to 128 variously active speakers. In January 2020, more than 200,000 audios have already been recorded, in 82 languages and thanks to 268 different speakers.
(Updating to match new version of source page) |
|||
| Line 7: | Line 7: | ||
== বৈশ্বিক পরিসংখ্যান == | == বৈশ্বিক পরিসংখ্যান == | ||
| − | + | <div class="mw-translate-fuzzy"> | |
<query records="Records" speakers="Speakers" languages="Languages"> | <query records="Records" speakers="Speakers" languages="Languages"> | ||
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> | ||
== মাসিক পরিসংখ্যান == | == মাসিক পরিসংখ্যান == | ||
| + | <div class="mw-translate-fuzzy"> | ||
<query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages"> | <query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages"> | ||
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> | ||
== বিভিন্ন ভাষায় রেকর্ডের সংখ্যা == | == বিভিন্ন ভাষায় রেকর্ডের সংখ্যা == | ||
| + | <!-- 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"> | ||
<!-- NEEDED IMPROVEMENT FOR READABILITY : --> | <!-- NEEDED IMPROVEMENT FOR READABILITY : --> | ||
<!-- * add column with language name in English, ex: French, Cantonese --> | <!-- * add column with language name in English, ex: French, Cantonese --> | ||
| Line 55: | Line 85: | ||
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> | ||
| + | == সর্বোৎকৃষ্ট পাঠক/পাঠিকা == | ||
| − | |||
| + | <div class="mw-translate-fuzzy"> | ||
<query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages"> | <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) | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | ||
where { | where { | ||
Revision as of 21:38, 10 October 2020
বৈশ্বিক পরিসংখ্যান
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>
মাসিক পরিসংখ্যান
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>
বিভিন্ন ভাষায় রেকর্ডের সংখ্যা
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>
সর্বোৎকৃষ্ট পাঠক/পাঠিকা
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>