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 )

  • 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, 2012 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, 2012 at 17:24
  • 1
    Also, for reference, getting the successful close votes for a particular user is rather trivial.
    – Tim Stone
    Dec 31, 2012 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, 2013 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, 2013 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, 2013 at 16:21
  • 3
    Can we have this? Right now there's not really any point in putting close votes in Votes at all, because it's useless.
    – Jason C
    Sep 19, 2016 at 6:03


You must log in to answer this question.