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

Currently Data.SE only show currently active close and reopen votes. Once these votes expire, they're removed from the Votes table. This makes them rather useless when trying to query anything related to close or reopen votes in Data.SE.

Can successful close and reopen votes get stored in Data.SE instead of only currently active votes?

(I would actually like to see unsuccessful close/reopen votes in Data.SE as well, however that proposal has been )

share|improve this question
2  
@Mat The information is already available in the revision history, it's just not very convenient to use. And as the request mentions, the votes table already includes this information for currently active close/reopen votes at the time the data is transferred, which is rather confusing since that information isn't actually available in the UI. –  Tim Stone Dec 31 '12 at 17:21
    
@Mat The only votes with a UserId attached to them in Data.SE is Favorites and Bounties. All other vote types, including Close/Reopen votes, have a blank UserId –  Rachel Dec 31 '12 at 17:24
1  
Also, for reference, getting the successful close votes for a particular user is rather trivial. –  Tim Stone Dec 31 '12 at 17:31
1  
@TimStone Interesting query, I wasn't aware you could do that. I was playing around with it a bit and discovered it's fairly easy to get a list of top close voters for a site –  Rachel Jan 4 '13 at 3:56
    
@Rachel as far as I can tell using PostHistory table is a workaround for this issue - is that correct? –  gnat Jan 10 '13 at 9:56
1  
@gnat That's a decent workaround if you're looking for a specific user's successful vote history, however if you're looking to run some queries on overall voting stats then you'll need to create a temp table and parse the PostHistory strings into your temp table, and that's a fairly expensive process. I'm not even sure if that would run at all on a big site like SO. –  Rachel Jan 10 '13 at 16:21

You must log in to answer this question.

Browse other questions tagged .