Counts of editcounts (live)

This query is marked as a draft This query has been published by Cryptic.

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 BETWEEN '2024' AND '202402'
    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;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...