LinguaLibre

Difference between revisions of "Stats/ja"

LinguaLibre のアルファリリースは2018年8月にアナウンスされました。2019年4月1日時点で、128人の様々にアクティブなスピーカーによって100,000件の音声が46の言語で録音されました。2020年1月には、268人の様々なスピーカーのおかげで200,000件の音声が82の言語で既に録音されています。

(Updating to match new version of source page)
(Updating to match new version of source page)
Line 9: Line 9:
  
 
== 世界の統計 ==
 
== 世界の統計 ==
 
+
<div class="mw-translate-fuzzy">
 
<query records="Records" speakers="Speakers" languages="Languages">
 
<query records="Records" speakers="Speakers" languages="Languages">
 
SELECT
 
SELECT
Line 21: Line 21:
 
}
 
}
 
</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">
 
<div class="mw-translate-fuzzy">
 
== 毎月の統計==
 
== 毎月の統計==
Line 44: Line 54:
 
</query>
 
</query>
 
</div>
 
</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">
 
<div class="mw-translate-fuzzy">
 
<query _pagination="10" language="Item (Language Qid)" languageLabel="Language" nb="Number of records">
 
<query _pagination="10" language="Item (Language Qid)" languageLabel="Language" nb="Number of records">
Line 62: Line 89:
 
</query>
 
</query>
 
</div>
 
</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

Other languages:
Bahasa Indonesia • ‎Bahasa Melayu • ‎Bali • ‎Bikol Central • ‎Deutsch • ‎English • ‎Esperanto • ‎Igbo • ‎Toki Pona • ‎Türkçe • ‎asturianu • ‎brezhoneg • ‎català • ‎español • ‎français • ‎galego • ‎lumbaart • ‎occitan • ‎polski • ‎română • ‎sicilianu • ‎svenska • ‎Ελληνικά • ‎башҡортса • ‎македонски • ‎русский • ‎українська • ‎עברית • ‎বাংলা • ‎తెలుగు • ‎中文 • ‎日本語 • ‎ꯃꯤꯇꯩ ꯂꯣꯟ


世界の統計

... Loading ...

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>

毎月の統計

... Loading ...

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>

言語ごとの録音数

... Loading ...

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>

最も投稿の多いスピーカー

... Loading ...
   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>