5

Is there a way to see the entire history of up and down votes of a post? That is, not only the current aggregate number of votes, but rather distribution of how many up votes and how many down votes.

2

3 Answers 3

9

Every post has a hidden timeline to it, which has detailed info regarding the votes a post has aggregated each day, with links in the form of http://[sitename].stackexchange.com/posts/[postID]/timeline. (But obviously not the info about who voted)

For instance, the timeline link for this question is https://meta.stackexchange.com/posts/290708/timeline.

You need the established user privilege to see the breakdown of votes though, and without it, you will only see the total score (upvotes−downvotes) for each day.

As animuson points out in a comment, it's only a sum of votes a post has gained each day, but it's the analysis with the most details about votes that you can get.

1
  • 4
    You don't need any privilege to view the timeline, but it should be noted that the timeline only gives you day-by-day summaries of votes. You can't see what time those votes actually came in from there.
    – animuson StaffMod
    Feb 5, 2017 at 18:55
5

It is part of the Established User privilege.

You get this when you reach 1,000 reputation on launched sites - and when you get it, clicking on the score of a post you will see the breakdown.

5

You can use the Stack Exchange Data Explorer to query the votes table:

select creationdate
     , sum(case when votetypeid = 1 then 1 else 0 end) accept
     , sum(case when votetypeid = 2 then 1 else 0 end) upvote
     , sum(case when votetypeid = 3 then 1 else 0 end) downvote
from votes
where postid = ##postid##
group by creationdate
order by creationdate

You'll notice that you'll only get dates for the votes, not the exact time the vote was casted. This is done to ensure anonymity of voting

Keep in mind this data is refreshed weekly on sunday.

2
  • 3
    Just checking if you were still paying attention @Peter, you passed. ;) ... thanks.
    – rene
    Feb 6, 2017 at 7:36
  • I think the Stack Exchange Data Explorer should be called 'Dora'...
    – Penguin9
    Feb 6, 2017 at 8:34

You must log in to answer this question.

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