I'm trying to calculate some year-end statistics and extracted some data from SEDE. However, it is not clear how to identify regular up-vote/down-vote retractions (typically called Unupvote/Undownvote). The vote types only list UpMod (2) and DownMod (3).

Are unupvote/undownvote votes captured in SEDE... anywhere? If not, can this be added as a vote type?


Ideally I'd like to recreate the community's activity on a day-to-day basis (the finest time-frame available since votes don't include a time-stamp). To that end one may be able to track how voting (or reputation) is bestowed (positive or negative) throughout the year, perhaps grouped by post. It would allow one to recreate the community state (so to speak) at any given day for analysis purposes and may highlight interesting communal tendencies.

As of now it is not possible without some form of reference to vote removal/reversal. One would only be able to approximate the community state for a given day, with varied accuracy.

  • 1
    I'd be surprised if they were even stored anywhere internally, let alone in the part of the dump that goes to SEDE. For what it's worth, I've been in SEDE quite a bit lately and am not aware of un-votes being captured anywhere.
    – senshin
    Dec 29, 2014 at 18:56
  • I suspect it's probably recorded as a deletion timestamp on the original vote (if the vote record is preserved at all), but Data Explorer never exposes any "deleted" data. It's definitely not in there now, but I can't comment on whether or not there's any chance of it being added.
    – Tim Stone
    Dec 29, 2014 at 19:52
  • 1
    @senshin it looks like they are stored somewhere internally; as an example, my rep history at Programmers shows me an answer undownvote I made on Dec 3, that is about 3 weeks ago
    – gnat
    Dec 29, 2014 at 20:13
  • @gnat: Yes, unvoting is allowed after an edit, and therefore can occur within the given time-limit (in which case it's not recorded at all) or after the time-limit given an edit to the post. Of course, this can occur on a completely different day and therefore is listed in a different per-day reputation group (since it could affect reputation-related badges like Mortarboard, Epic and Legendary).
    – Werner
    Dec 29, 2014 at 20:20

1 Answer 1


No, they are not. Unupvote and undownvote events only exist as informational entries in the reputation history. In the system itself, the original upvote or downvote gets changed to a "deleted" state so that the system knows it no longer applies to the post. These deleted votes are not available in Data Explorer, since the DeletionDate is not made available to the public and thus including them would make results inaccurate (since you wouldn't know if the vote is actually active or not).

As far as adding all those votes and making that DeletionDate visible, you'd have to convince Stack Exchange that the data would be useful for some reason. I can't comment as to why the information isn't available already.

  • I don't understand what you mean by "you wouldn't know if the vote is actually active or not". A non-null DeletionDate (or even DeletionDate > CreationDate) should suffice in deciding its activeness.
    – Werner
    Dec 29, 2014 at 21:23
  • @Werner Because the DeletionDate is not exposed currently. So if deleted votes were present in the system in the current state, you wouldn't be able to tell which ones were retracted.
    – animuson StaffMod
    Dec 29, 2014 at 21:24
  • How would I go about convincing StackExchange that such information is useful?
    – Werner
    Dec 29, 2014 at 21:24
  • @Werner Construct an argument for why you need it. An example of what you'd do with the information is usually a good starting place.
    – animuson StaffMod
    Dec 29, 2014 at 21:26
  • 1
    I'll add this to my question, since it's referenced as a feature-request.
    – Werner
    Dec 29, 2014 at 21:27

You must log in to answer this question.

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