Skip to main content
Meta Stack Exchange

Return to Answer

replaced http://data.stackexchange.com/ with https://data.stackexchange.com/
Source Link
Community Bot
Community Bot
  • 1

Statistics on voters is not possible via SEDE; votes are anonymized before they are made publicly accessible.

Editors might be possible. I'm not sure if edits to your own posts count for the 'league', but this querythis query is based on something that comes very close to the numbers I see for my own account (on other sites). Note that SEDE is refreshed once a week, on Sunday morning, so edits on most of December 31st are not included yet. Congratulations, you're the winner:

enter image description here

For reference, here is the complete query. Feel free to forkfork it if you need the data for the last week / last year instead.

SELECT UserId AS [User Link], COUNT(*) AS [Number of edits]
FROM

(
SELECT UserId, CreationDate
  FROM PostHistory
  WHERE PostHistoryTypeId IN (4, 5, 6)
    AND CreationDate BETWEEN '2017-12-01' AND '2017-12-31'
  GROUP BY UserId, CreationDate
) AS edits

GROUP BY UserId
ORDER BY COUNT(*) DESC

Statistics on voters is not possible via SEDE; votes are anonymized before they are made publicly accessible.

Editors might be possible. I'm not sure if edits to your own posts count for the 'league', but this query is based on something that comes very close to the numbers I see for my own account (on other sites). Note that SEDE is refreshed once a week, on Sunday morning, so edits on most of December 31st are not included yet. Congratulations, you're the winner:

enter image description here

For reference, here is the complete query. Feel free to fork it if you need the data for the last week / last year instead.

SELECT UserId AS [User Link], COUNT(*) AS [Number of edits]
FROM

(
SELECT UserId, CreationDate
  FROM PostHistory
  WHERE PostHistoryTypeId IN (4, 5, 6)
    AND CreationDate BETWEEN '2017-12-01' AND '2017-12-31'
  GROUP BY UserId, CreationDate
) AS edits

GROUP BY UserId
ORDER BY COUNT(*) DESC

Statistics on voters is not possible via SEDE; votes are anonymized before they are made publicly accessible.

Editors might be possible. I'm not sure if edits to your own posts count for the 'league', but this query is based on something that comes very close to the numbers I see for my own account (on other sites). Note that SEDE is refreshed once a week, on Sunday morning, so edits on most of December 31st are not included yet. Congratulations, you're the winner:

enter image description here

For reference, here is the complete query. Feel free to fork it if you need the data for the last week / last year instead.

SELECT UserId AS [User Link], COUNT(*) AS [Number of edits]
FROM

(
SELECT UserId, CreationDate
  FROM PostHistory
  WHERE PostHistoryTypeId IN (4, 5, 6)
    AND CreationDate BETWEEN '2017-12-01' AND '2017-12-31'
  GROUP BY UserId, CreationDate
) AS edits

GROUP BY UserId
ORDER BY COUNT(*) DESC
Source Link
Glorfindel Mod
Glorfindel Mod
  • 255.6k
  • 61
  • 638
  • 1.3k

Statistics on voters is not possible via SEDE; votes are anonymized before they are made publicly accessible.

Editors might be possible. I'm not sure if edits to your own posts count for the 'league', but this query is based on something that comes very close to the numbers I see for my own account (on other sites). Note that SEDE is refreshed once a week, on Sunday morning, so edits on most of December 31st are not included yet. Congratulations, you're the winner:

enter image description here

For reference, here is the complete query. Feel free to fork it if you need the data for the last week / last year instead.

SELECT UserId AS [User Link], COUNT(*) AS [Number of edits]
FROM

(
SELECT UserId, CreationDate
  FROM PostHistory
  WHERE PostHistoryTypeId IN (4, 5, 6)
    AND CreationDate BETWEEN '2017-12-01' AND '2017-12-31'
  GROUP BY UserId, CreationDate
) AS edits

GROUP BY UserId
ORDER BY COUNT(*) DESC