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

Any way to see a question's history of being closed and opened?

share|improve this question
    
I don't think they're duplicate questions. Greg seems to know much more about the data dump and is asking for specific things to be added. My question is whether it's possible or not, with an apparent answer of "no". –  Mark Harrison Jun 30 '10 at 4:46

2 Answers 2

up vote 1 down vote accepted

I think you are our of luck here,

We age out older than 3 days close votes. So there is no history kept in the data dump.

http://odata.stackexchange.com/stackoverflow/qt/5876/close-vote-stats

Perhaps, you should change this to a feature request for the data dump to add close and open counts to a Post.

share|improve this answer

Now that the PostHistory table is exposed in the Data Dump, yes!

I created a query to find the number of times a question has been closed and reopened:
http://data.stackexchange.com/stackoverflow/s/761/community-controversy

share|improve this answer
    
If you're modifying this query, be careful about running it -- it is very heavy because there isn't an index on PostHistory.PostId. The original query took 2 attempts to get results (timed out the first try). I will see if I can get an index on that column for next month's update. –  Jon Seigel Dec 29 '10 at 6:41

You must log in to answer this question.

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