Is there any way to click on these queries and get current results displayed, for those of us who are just idly wondering and don't want to spend time learning the query interface right now?
– keshlamMay 12 '16 at 1:43

@keshlam they are all current if you click the links to the data explorer.
– jmacMay 12 '16 at 1:44

HM. When I clicked one, I saw the query language. May have missed an execute button.
– keshlamMay 12 '16 at 1:45

I updated the query to include everyone with close vote privileges. It was set to 3k which is correct for graduated sites, but 500 for beta sites, so the list is significantly longer.
– jmacJan 16 '14 at 3:46

@enderland Naahh it just means you've been voting to close all the right things, since they've since been deleted! :) Don't forget there is a script which auto-deletes low scoring closed questions that meet a specific criteria.
– RachelJan 20 '14 at 23:40

2

I edited your query title slightly, as this query only pulls data from the PostHistory table and aggregates the users who closed a question. You're not actually able to query Close/Reopen votes directly since they expire and get removed from Data.SE.
– RachelJan 21 '14 at 15:52

@JimG. I notice you just edited this. If you are planning to update these statistics from time to time (which is not bad), I suggest also including the date the statistics were taken in the post. I don't think just depending on the last edited date is that reliable.
– David KMay 12 '16 at 12:46

Nice job guys! Editing + Reopening is part of what is making this site great :)

(It should be noted that you can't query Close/Reopen votes directly, which is why this query is based off the PostHistory table and successfully reopened questions only. There's a meta proposal here to change that.)

This could be useful for expanding the tag wikis that are empty or very close to it.

The cut-off of 40 characters for summary and 100 characters for full wiki were plucked out of thin air and adjusted slightly (there were a bunch of decent summaries between 40 and 49 characters), so feel free to tweak it as needed.

This will be used shortly for cleaning up some of those outliers. We have over 700 questions with over 5 answers. There is something wrong with that...

(This is a better query that polls questions that have never been closed, but leaves out those that were re-opened, if someone good at SQL could fiddle with it so it only shows the results for open questions, that'd be swell)