LinguaLibre
Difference between revisions of "Stats/eo"
Alfa-eldono de la Lingva libro estis anoncita en aŭgusto 2018. Ĝis aprilo 2019 la Lingvalibro atingis 100 000 sonregistraĵojn en 46 lingvoj danke al 128 malsamaj parolantoj. La projekto atingis 200 000 registraĵojn (82 lingvojn, 268 parolantojn) en januaro 2020, 300 000 registraĵojn (91 lingvojn, 357 parolantojn) en septembro 2020 kaj 400 000 registraĵojn (107 lingvojn, 481 parolantojn) en februaro 2021.
(Updating to match new version of source page) |
|||
| Line 7: | Line 7: | ||
== Globala statistiko == | == Globala statistiko == | ||
| − | <query records=" | + | <query records="Records" speakers="Speakers" languages="Languages"> |
SELECT | SELECT | ||
(COUNT(DISTINCT ?record) AS ?records) | (COUNT(DISTINCT ?record) AS ?records) | ||
| Line 20: | Line 20: | ||
== Dummonata aktiveco == | == Dummonata aktiveco == | ||
| − | <query yearmonth=" | + | <query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages"> |
SELECT | SELECT | ||
?yearmonth | ?yearmonth | ||
| Line 38: | Line 38: | ||
== Nombro da registraĵoj po lingvoj == | == Nombro da registraĵoj po lingvoj == | ||
| − | <query _pagination="10" language=" | + | <query _pagination="10" language="Item (Language Qid)" code="ISO 639-3 code" nb="Number of records"> |
select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb) | select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb) | ||
where { | where { | ||
| Line 52: | Line 52: | ||
== La plej viglaj parolantoj == | == La plej viglaj parolantoj == | ||
| + | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records"> | ||
| + | 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> | ||
| + | |||
| + | == The most prolific speakers for the current month == | ||
| − | <query _pagination="10" locutor=" | + | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records for the current month"> |
SELECT ?locutor ?locutorLabel ?nb WHERE { | SELECT ?locutor ?locutorLabel ?nb WHERE { | ||
{ | { | ||
SELECT ?locutor (COUNT(?record) as ?nb) | SELECT ?locutor (COUNT(?record) as ?nb) | ||
WHERE { | WHERE { | ||
| − | ?record prop:P2 entity:Q2 . | + | ?record prop:P2 entity:Q2 . # Q2: record, P2: instance of. |
| − | ?record prop:P5 ?locutor . | + | ?record prop:P5 ?locutor . # Property:P5: speaker |
| + | ?record prop:P6 ?date . | ||
| + | FILTER ( YEAR(?date) = YEAR(NOW()) && MONTH(?date) = MONTH(NOW()) ) | ||
} | } | ||
GROUP BY ?locutor ?locutorLabel | GROUP BY ?locutor ?locutorLabel | ||
Revision as of 13:28, 5 May 2021
Globala statistiko
Dummonata aktiveco
Nombro da registraĵoj po lingvoj
La plej viglaj parolantoj
The most prolific speakers for the current month