To preface, I'm not asking for vote time to be exposed for upvotes or downvotes. I'm aware that that's bad because it allows voting history to be reconstructed.
However, certain other types of votes already have their times publicly exposed elsewhere but not in the Data Explorer. In particular:
- The time of an accept (VoteTypeId = 1) can be seen at
- The time of a bounty start or a bounty award (8, 9) is visible at
- The time at which an edit is approved (16) is also visible at
It would be awesome if the times at which these types of votes were cast could be added to the
Votes table. (By which I mean, instead of having
CreationDate always be
yyyy-mm-dd 00:00:00, have actual times for these types of votes.)
Motivation: mostly, I want to look at the duration of time between an answer being posted and it being accepted, and see how that correlates to other things about the question/answer. So I'm mostly interested in type 1 votes; the others I've included here just for completeness. Jeff mentions that adding accept times to the data dump would not be objectionable to him in a post from 2010, but it doesn't look like anything came of that.