10

I know that I can check this statistics for my profile by going to the "votes" tab. But for other users I can not do the same (it is hidden).

I want to see which users have cast the most number of close or reopen votes.

So, is it possible to create such queries?

0
6

What I have written here is to the best of my knowledge, but I am only a beginner at using the SE data explorer and corrections may be due. I did not write the queries mentioned but only slightly adjusted them. Others will certainly be able to improve them.

To some extent, votes are private. The public database mainly includes information that is somehow publicly accessible and excludes information that could compromise privacy. Close voters are listed under a closed post and permanently in the timeline. Reopen voters can also be seen in the timeline. Timeline information is in the data explorer, so it is possible to get a limited version of the information you want.

Close Voters

This query should return the top close voters.

Note that:

  • It uses the PostHistory table record for close stats. The relevant schema stores the fact that the post was closed. Unsuccessful close votes are not accessible as far as I know, so this is only a count of those votes that resulted in the post being closed.
  • Deleted posts are not included. This is a problem, because closing questions makes it much more likely that they will be deleted. But I do not think the PostsWithDeleted table has enough data to fix this because it has no user data.

Reopen Voters

This query should return the top reopen voters.

Note that:

  • It uses the PostHistory table record for reopen stats. The relevant schema stores the fact that the post was reopened. Unsuccessful reopen votes are not accessible as far as I know, so this is only a count of those votes that resulted in the post being reopened.
  • Deleted posts are not included.
4
  • I was also trying to modify this query but you posted first. I think its not working properly because I have also successfully re-opened some posts but its not showing. One example is this. – Triyugi Narayan Mani Dec 31 '18 at 9:37
  • @TriyugiNarayanMani I am very willing to believe it is not working properly, but the post you linked to was reopened very recently and the data only gets dumped once a week, sometimes less often, so may not include that one yet. According to my version you have participated in 52 successful votes to reopen... – Zanna Dec 31 '18 at 9:38
  • That was only one example. There are many posts to which I have voted to re-open and they have re-opened. Now, your changed query is showing correct info. – Triyugi Narayan Mani Dec 31 '18 at 9:41
  • 1
    @TriyugiNarayanMani oh! I am surprised that the small change I made fixed that. There may still be problems with it. Thanks a lot for reporting the inconsistency! Please feel free to post a better answer if you manage to improve the query more... – Zanna Dec 31 '18 at 9:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .