Difference between revisions of "Stats/Speakers"

Revision as of 18:06, 3 August 2021

... Loading ...

... Loading ...

@@ Line 1: / Line 1: @@
-== Monthly activity ==
-<query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active 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>
 == The most prolific speakers ==