What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 133 Stack Exchange communities.

Are there any stats about the percentage of close reasons used to close questions

  • Successfully (preferably, based on the number of closed questions)
  • Unsuccessfully (alternatively, the total percentags of close votes cast by users)


Is there any way to get this from the query explorer?

share|improve this question
Probably not from SEDE, as close votes expire. –  waiwai933 Jan 9 '11 at 11:35
@waiwai ah, true. Hadn't thought of that. @Developers, is there a chance of getting that info? (Just if it isn't too much trouble, I'm just looking for background info for a feature suggestion) –  Pëkka Jan 9 '11 at 11:36

1 Answer 1

up vote 7 down vote accepted

Unsuccessfully -- no, when close votes disappear from the system, they are hard-deleted, so they physically don't exist anymore (except in backups, I suppose).

Successfully -- yes, the CloseReasonId is actually stuffed into the Comment field in PostHistory (I've updated the docs to reflect this). I created a query to summarize how frequently questions are closed by type of close. You can calculate the percentages from this quite easily.

Also, for the curious, I created another query to show how you have voted to close in successfully closed questions.

share|improve this answer
Sweet, exactly what I was looking for (well, minus the "Unsuccessfully" part, but I kind of expected that). Thank you very much! –  Pëkka Jan 9 '11 at 19:41
@Pekka: You're welcome! I was curious why there was no CloseReasonId column in PostHistory, so it was good to figure this out. –  Jon Seigel Jan 9 '11 at 19:45
@Jon, where is the vote close reason stored? Nothing makes it to the history table unless the post is closed. This info, however, must get stored somewhere. The most common close reason is noted if more than one reason is used. Does the votes table have extra columns not visible on SEDE? Like a closeReasonId or something? –  Mohamad Aug 11 '11 at 3:16
@Mohamad: meta.stackexchange.com/questions/99311/… –  Jon Seigel Aug 11 '11 at 4:28

You must log in to answer this question.

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