|
|
| (53 intermediate revisions by 5 users not shown) |
| Line 1: |
Line 1: |
| − | <languages/> | + | __NOTOC__ |
| − | | + | <languages/><indicator name="stats"></indicator>{{#SUBTITLE: Lingua Libre Alpha wurde im August 2018 angekündigt. Bis April 2019 erreichte ''LiLi'' dank 128 verschiedener Sprecher '''100.000''' Audioaufnahmen in 46 Sprachen, '''200.000''' Aufnahmen (82 Sprachen, 268 Sprecher) im Januar 2020 ; '''500.000''' Aufnahmen (120 Sprachen, 538 Sprecher) im Juni 2021 und '''1.000.000''' Aufnahmen (200 Sprachen, 1400 Sprecher) im Oktober 2023.}}{{LinguaLibre:Stats/Menu}} |
| − |
| + | == Globale Statistiken == |
| − | 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.
| + | <query records="Aufnahmen" speakers="Sprecher" languages="Sprachen"> |
| − | | |
| − | == Global stats == | |
| − | | |
| − | <query records="Records" speakers="Speakers" languages="Languages"> | |
| | SELECT | | SELECT |
| | (COUNT(DISTINCT ?record) AS ?records) | | (COUNT(DISTINCT ?record) AS ?records) |
| | (COUNT(DISTINCT ?speaker) AS ?speakers) | | (COUNT(DISTINCT ?speaker) AS ?speakers) |
| − | (COUNT(DISTINCT ?language) AS ?languages) | + | (COUNT(DISTINCT ?language) -2 AS ?languages) # Accounting for the 2 duplicata languages |
| | + | # see Help:SPARQL_for_maintenance#.E2.9C.85_Languages_.E2.86.92_list_of_values_used_including_redirects |
| | WHERE { | | WHERE { |
| | ?record prop:P2 entity:Q2 . | | ?record prop:P2 entity:Q2 . |
| Line 16: |
Line 13: |
| | ?record prop:P4 ?language . | | ?record prop:P4 ?language . |
| | } | | } |
| − | </query>
| |
| − |
| |
| − | == History ==
| |
| − |
| |
| − | <query yearmonth="Date" records="Records" speakers="Speakers" languages="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 ==
| |
| − |
| |
| − | <query _pagination="10" language="Item" name="Language" nb="Number of records">
| |
| − | select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
| |
| − | where {
| |
| − | ?record prop:P2 entity:Q2 .
| |
| − | ?record prop:P4 ?lang .
| |
| − | BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
| |
| − |
| |
| − | SERVICE wikibase:label {
| |
| − | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
| |
| − | ?language rdfs:label ?languageLabel.
| |
| − | }
| |
| − | }
| |
| − | GROUP BY ?language ?languageLabel
| |
| − | ORDER BY DESC(?nb)
| |
| − | </query>
| |
| − |
| |
| − | == The most prolific speakers ==
| |
| − |
| |
| − | <query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages">
| |
| − | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) (GROUP_CONCAT(DISTINCT ?langLabel;separator=", ") as ?languages)
| |
| − | 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] .
| |
| − | BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
| |
| − |
| |
| − | SERVICE wikibase:label {
| |
| − | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
| |
| − | ?lang rdfs:label ?langLabel .
| |
| − | ?locutor rdfs:label ?locutorLabel .
| |
| − | }
| |
| − | }
| |
| − | GROUP BY ?locutor ?locutorLabel
| |
| − | ORDER BY DESC(?nb)
| |
| − | LIMIT 50
| |
| − | </query>
| |
| − |
| |
| − | == The most recorded words ==
| |
| − |
| |
| − | <query _pagination=10 transcription="Transcription" nb="Number of records" language="Languages">
| |
| − | select ?transcription (COUNT(?record) as ?nb) (GROUP_CONCAT(DISTINCT (if( ?language = entity:Q4, '???', ?languageLabel )); SEPARATOR=", ") AS ?languages)
| |
| − | where {
| |
| − | ?record prop:P2 entity:Q2 .
| |
| − | ?record prop:P4 ?lang .
| |
| − | BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
| |
| − |
| |
| − | ?record prop:P7 ?transcription.
| |
| − | SERVICE wikibase:label {
| |
| − | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
| |
| − | ?language rdfs:label ?languageLabel.
| |
| − | }
| |
| − | }
| |
| − | GROUP BY ?transcription
| |
| − | ORDER BY DESC(?nb)
| |
| − | LIMIT 50
| |
| | </query> | | </query> |
