0

I would like to know if it is possible to see a count of question closures and answer deletions that occurred by the normal queue vote process (where some number of community members all voted until the number was met and the action happened) and then another count of the same actions where the normal queue action was pre-empted by the vote of a ♦ moderator?

The counts of the first should go back at least one election cycle prior to the current, and then the count of the second would be maybe done twice, once for the previous cycle, and once for the current.

  • 4
    As a note, mods have often asked for the ability to cast non-immediate close votes and been refused that request. We are expected to know whether something is within scope or not and if we're unsure, wait to vote... but there's nothing about a close vote for mods that's binding... the userbase, if they disagree, can still reopen those questions, so if the moderator is doing something the community doesn't agree with, the questions won't stay closed. – Catija Feb 2 '18 at 19:53
  • I think the question is of broader interest to the network, so I wouldn't VTC as being about a single site. The back story may relate to a specific site, but that doesn't make the question single-site... – Catija Feb 2 '18 at 19:55
  • 3
    Your question will be better received if it doesn't include a jab at a moderator. It's sort of irrelevant why you're asking the question if you just want the data... Attempting to lodge a complaint in the form of a request for support seems somewhat duplicitous. If you have a concern about a mod, fill out the contact form and talk to the CMs... or take it to the per-site meta... but this question would be much better off without most of the body. – Catija Feb 2 '18 at 19:59
  • Fixed and please accept my apology. I do not want this question to be about issue with mods, but about a request for information. – CGCampbell Feb 2 '18 at 20:06
  • 1
    Sure :) I'm guessing that this is something that may be possible in SEDE but I've no clue how to query for it. Perhaps someone will be able to write a query for you. They can be changed to any site, so you can use them on whichever site you like even if it's written for a different site entirely :) It probably won't be based on election cycle dates and it won't include deleted posts but at the least it would include the ones currently available to view on the site. – Catija Feb 2 '18 at 20:09
  • for closure and deletion you could use this sede query. Not sure if that fits your needs. I picked on Martijn Pieters here, SO Mod, because he showed up in my first 100 results, and his overall awesomeness. – rene Feb 2 '18 at 20:13
  • @rene that's an interesting query, thanks for it. I'll have to play with it for a bit. – CGCampbell Feb 2 '18 at 20:41
  • 1
    Just out of curiosity, what would knowing the number of questions closed by a moderator tell you? Are you saying there’s something inherently wrong with moderators closing questions? – Cai Feb 2 '18 at 21:00
  • 1
  • 1
    @Cai Have you looked at the revision history of the question? As my earlier comment notes, the (now removed) content isn't really doing much of value to the question but there's no reason to not help someone compile data. Purely as a datapoint, I find it interesting, so... eh. I don't think the motivations are necessary. – Catija Feb 2 '18 at 21:22
  • @Catija that’s why I asked. I do think it’s an interesting metric, I’m just wondering what’s being inferred from it – Cai Feb 2 '18 at 22:28
  • @Cai I won't go into the why here or now. I should not have done so in the beginning. – CGCampbell Feb 5 '18 at 15:04
5

Here is a SEDE query which might help in analyzing how many questions are closed by a ♦ moderator and how many are not. Last December, 45 questions on Meta Stack Exchange were closed and in only 4 cases a ♦ moderator cast a binding vote. You can change the parameters to choose the date interval you need, and there's also an option to switch sites.

I've excluded duplicate questions; those can be closed single-handedly by gold tag badge holders and by the author of the question. Questions which are deleted (e.g. by Roomba) aren't included, but there's no reason to assume this shifts the statistics in one direction or another.

For reference, here is the complete query:

SELECT COUNT(*)
    AS 'Questions closed',
  SUM(CASE WHEN Text LIKE '%{%{%{%{%{%{%' THEN 0 ELSE 1 END)
    AS 'Questions closed by less than 5 users'
  FROM PostHistory
  WHERE PostHistoryTypeId = 10 -- Post Closed
    AND CreationDate BETWEEN ##DateFrom:string## AND ##DateTill:string##
    AND Comment != '101' -- not Duplicate, those can be closed by gold tag badge holders

Note that SEDE is updated once a week, on Sunday morning.

As for deleted answers, SEDE won't be of much help because only very limited information is stored about deleted posts.

  • To me, the amusing thing here is that the actual number is far higher, it's just that, here on MSE, many of the mod hammer closes are also deleted, so they don't show up. :D But, on most sites, this won't be the case... the questions, unless downvoted and roombaed, will probably still be around, even if closed. – Catija Feb 2 '18 at 20:22
  • PostHistoryTypeid =12 (delete) returned lots of rows for Martijn so it looks like Posthistory isn't sanitized for that. – rene Feb 2 '18 at 20:22
  • If it is dupe hammerd the text will contain {"GoldTagBadge" – rene Feb 2 '18 at 20:26
  • ... but I only see (on Meta Stack Exchange) posts which have been subsequently undeleted. – Glorfindel Feb 2 '18 at 20:26
  • Ah, didn't investigate further. That would make sense – rene Feb 2 '18 at 20:27
  • ... and by the OP themselves {"BindingApprovalByOP" or something like that. – Glorfindel Feb 2 '18 at 20:28
  • This gave me what I was looking for. I'm going to let the question remain unanswered for a couple days, though. – CGCampbell Feb 2 '18 at 20:31

You must log in to answer this question.

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