LinguaLibre

Difference between revisions of "Stats/de"

Die Alpha-Version von LinguaLibre Alpha wurde im August 2018 bekannt gegeben. Bis zum 1. August 2018 : 10,000 Audiodateien. April 2019 (8 Monate), wurden fast 100,000 Audiodateien in 46 Sprachen, Dank 128 verschiedenen aktiven Sprechern aufgenommen. January 2020 (18 Monate), wurden fast 200,000+ Audiodateien in 82 Sprachen, Dank 268 verschiedenen aktiven Sprechern aufgenommen.

(Updating to match new version of source page)
(Updating to match new version of source page)
Line 12: Line 12:
  
 
== Globale Statistiken ==
 
== Globale Statistiken ==
−
 
+
<div class="mw-translate-fuzzy">
 
<query records="Aufnahmen" speakers="Sprecher" languages="Sprachen">
 
<query records="Aufnahmen" speakers="Sprecher" languages="Sprachen">
 
SELECT
 
SELECT
Line 24: Line 24:
 
}
 
}
 
</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">
 
== Monatliche Aktivität ==
 
== Monatliche Aktivität ==
Line 47: Line 57:
 
</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>
 
== Anzahl Aufnahmen pro Sprache ==
 
== Anzahl Aufnahmen pro Sprache ==
  
 +
<!-- 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="Wikidata-ID" name="Sprache" nb="Anzahl Aufnahmen">
 
<query _pagination="10" language="Wikidata-ID" name="Sprache" nb="Anzahl Aufnahmen">
Line 67: Line 94:
 
</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>
 +
== Aktivste Sprecher ==
  
−
== Aktivste Sprecher ==
 
  
 
<div class="mw-translate-fuzzy">
 
<div class="mw-translate-fuzzy">
Line 91: Line 128:
 
</query>
 
</query>
 
</div>
 
</div>
 +
    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>
  
 
__NOTOC__
 
__NOTOC__

Revision as of 21:39, 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 • ‎Ελληνικά • ‎башҡортса • ‎македонски • ‎русский • ‎українська • ‎עברית • ‎বাংলা • ‎తెలుగు • ‎中文 • ‎日本語 • ‎ꯃꯤꯇꯩ ꯂꯣꯟ


Globale Statistiken

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

Monatliche Aktivität

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

Anzahl Aufnahmen pro Sprache

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

Aktivste Sprecher

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


Retrieved from "https://lingualibre.org/index.php?title=LinguaLibre:Stats/de&oldid=342013"