Counts of editcounts (live)

Counts of registered users by (not currently deleted) edit count in 2024, grouped by powers of 10.  For example, users in cohort 1 had between 1 and 9 edits; users in cohort 1000 had between 1000 and 9999.

example_user is there because there was one in cohort 10000 when I ran this for just January 1 and I wanted to sanity-check (it turned out to be VulpesBot); I didn't think to remove it from the query. 

For [[WP:RAQ#Number of editors per year]] circa 5 January 2025.

SQL

WITH editcounts(ec_log10, ec_name) AS
(
  SELECT FLOOR(LOG10(COUNT(*))), actor_name
  FROM revision
  JOIN actor_revision ON actor_id = rev_actor
  WHERE rev_timestamp LIKE '2024%'
    AND actor_user IS NOT NULL
  GROUP BY rev_actor
)
SELECT RPAD('1', ec_log10 + 1, '0') AS cohort, COUNT(*), ec_name AS example_user
FROM editcounts
GROUP BY ec_log10;

​x
 
WITH editcounts(ec_log10, ec_name) AS(  SELECT FLOOR(LOG10(COUNT(*))), actor_name  FROM revision  JOIN actor_revision ON actor_id = rev_actor  WHERE rev_timestamp LIKE '2024%'    AND actor_user IS NOT NULL  GROUP BY rev_actor)SELECT RPAD('1', ec_log10 + 1, '0') AS cohort, COUNT(*), ec_name AS example_userFROM editcountsGROUP BY ec_log10;​

SQL

Checking query status...