|
|
(22 intermediate revisions by 4 users not shown) |
Line 1: |
Line 1: |
− | <languages/> | + | __NOTOC__ |
− | <indicator name="stats"></indicator> | + | <languages/><indicator name="stats"></indicator>{{#SUBTITLE:<translate> <!--T:13--> |
− | {{#SUBTITLE: | + | Lingua Libre Alpha was announced on August 2018. By April 2019, ''LiLi'' reached '''100,000''' audios recordings in 46 languages thanks to 128 different speakers, '''200,000''' recordings (82 languages, 268 speakers) in January 2020 ; '''500,000''' recordings (120 languages, 538 speakers) in June 2021 and '''1,000,000''' recordings (200 languages, 1400 speakers) in October 2023. By June 2024, there were 1,250,000 recordings (250 languages, 2050 speakers). |
− | <translate> | + | </translate>}}{{LinguaLibre:Stats/Menu}} |
− | <!--T:13--> | |
− | LinguaLibre Alpha release was announced on August 2018. By April 2019, ''LiLi'' reached '''100,000''' audios in 46 languages thanks to 128 different speakers. The project reached '''200,000''' recordings (82 languages, 268 speakers) in January 2020, '''300,000''' recordings (91 languages, 357 speakers) in September 2020, and '''400,000''' recordings (107 languages, 481 speakers) in February 2021.
| |
− | </translate> | |
− | }} | |
− | | |
| <translate> | | <translate> |
| == Global stats == <!--T:4--> | | == Global stats == <!--T:4--> |
Line 16: |
Line 11: |
| (COUNT(DISTINCT ?speaker) AS ?speakers) | | (COUNT(DISTINCT ?speaker) AS ?speakers) |
| (COUNT(DISTINCT ?language) AS ?languages) | | (COUNT(DISTINCT ?language) AS ?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 22: |
Line 18: |
| } | | } |
| </query> | | </query> |
− | <translate>
| |
− | == Monthly activity == <!--T:25-->
| |
− | </translate>
| |
− |
| |
− | <query yearmonth="<translate>Date</translate>" records="<translate>New records</translate>" speakers="<translate>Active speakers</translate>" languages="<translate>Active languages</translate>">
| |
− | 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>
| |
− | <translate>
| |
− | == Number of records per languages == <!--T:1-->
| |
− | </translate>
| |
− |
| |
− | <query _pagination="10" language="<translate>Item (Language Qid)</translate>" code="<translate>ISO 639-3 code</translate>" nb="<translate>Number of records</translate>">
| |
− | select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb)
| |
− | <translate>
| |
− | <!--T:7-->
| |
− | where {
| |
− | ?record prop:P2 entity:Q2 .
| |
− | ?record prop:P4 ?language .
| |
− | OPTIONAL { ?language prop:P13 ?code }
| |
− | OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "en"). }
| |
− | }
| |
− | GROUP BY ?language ?languageLabel ?code
| |
− | ORDER BY DESC(?nb)
| |
− | </query><!-- Just insert corresponding language code instead of "en" --></translate>
| |
− | <translate>
| |
− |
| |
− | == The most prolific speakers == <!--T:2-->
| |
− | </translate>
| |
− |
| |
− | <query _pagination="10" locutor="<translate>Item (locutor Qid)</translate>" locutorLabel="<translate>Speaker</translate>" nb="<translate>Number of records</translate>">
| |
− | 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>
| |
− |
| |
− | <translate>
| |
− | == The most prolific speakers for the current month == <!--T:28-->
| |
− | </translate>
| |
− |
| |
− | <query _pagination="10" locutor="<translate>Item (locutor Qid)</translate>" locutorLabel="<translate>Speaker</translate>" nb="<translate>Number of records for the current month</translate>">
| |
− | 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
| |
− | ?record prop:P6 ?date .
| |
− | FILTER ( YEAR(?date) = YEAR(NOW()) && MONTH(?date) = MONTH(NOW()) )
| |
− | }
| |
− | 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>
| |
− |
| |
− | __NOTOC__
| |