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.
-
Related: meta.stackexchange.com/questions/251805/….– Shadow Wizard Says No More WarFeb 6, 2017 at 8:29
-
1Isn't that just the 1k privilege?– Penguin9Feb 6, 2017 at 8:32
3 Answers
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.
-
4You 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. Feb 5, 2017 at 18:55
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.
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.
-
3Just checking if you were still paying attention @Peter, you passed. ;) ... thanks.– reneFeb 6, 2017 at 7:36
-