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.

In the votes table, the field CreationDate in the votes table only contains the date, with all the times set to 12:00:00 AM.

For some purporses, this information is needed to determine if there are issues regarding accepted answers in particular, and perhaps other types of voting patterns.

  • Is this how SO internally stores the data, and if so can this be changed so the time is also recorded?
  • If this data is scrubbed during the dump (in order to prevent, for instance, matching up voting times with times people were seen on SO) can this be more finely grained so that some types of votes, such as AcceptedByOriginator, Close, Reopen, Deletion, Undeletion will have the actual vote times?

This can be useful for generating data that may show how changes to the system are likely to affect behavior, and to measure the effectiveness of new features/badges/etc. The five vote types I've specified above don't require anonymity since we know who voted to accept, and who votes to close and open questions already. However if it's still a risk, please at least let us see when answers are accepted, which has no risk of personally identifying information.

Similar to this question:

Omission of vote time in data dump

However, I'm asking that only a portion of the data be made available, data which is already public on the website, so there's no point in anonymizing it. The above question was asking that all voting times be made available.

share|improve this question
    
Duplicate: meta.stackexchange.com/questions/933/… –  Greg Hewgill Feb 6 '10 at 22:07
    
@Greg - While similar, this one is requesting only the data which does not require anonymization, rather than all the times for all the votes. –  Adam Davis Feb 7 '10 at 2:43
    
starts singing - Reputation wants to be freeeeeeeeeeeeeeeeee...! –  Adam Davis Mar 9 '10 at 3:03

2 Answers 2

up vote 6 down vote accepted
+275

Well, you should know that all ...

  • Close
  • Reopen
  • Deletion
  • Undeletion

... votes are automatically aged away and hard deleted 4 days after they've been cast. So there's no actual permanent record of these votes being cast, unless the threshold is reached on the question.

So all you'd really be getting is the acceptance vote date and time.

share|improve this answer
    
Ah, yes. Well, acceptance would still be nice for the reasons mentioned. –  Adam Davis Mar 10 '10 at 15:24

Yeah, this information would be really useful - it would be great to see it for all types of votes (useful for things like seeing how many upvotes a post receives after its been marked as accepted) but in particular its good for the "special" vote types (closing, accepting answers etc...)

share|improve this answer

You must log in to answer this question.

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