What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 130 Stack Exchange communities.

I'd like to view the total number of upvotes on my questions, upvotes on my answers, downvotes on my questions, and downvotes on my answers. Is there any way I can do this without manually counting?

share|improve this question
This information must be retrievable from the Data Explorer, but I'm not knowledgeable enough to construct the right query. –  M. Tibbits Jul 16 '11 at 16:29

2 Answers 2

If you check the listing from http://stackoverflow.com/reputation you can see this.

1   6681021 (15)
2   6681021 (10)
2    998675 (5)

The first column is the vote type, the second is the post id and the third is the reputation gained or lost.

So you can see that "1" is an acceptance - as it gives 15 reputation; "2" is an up-vote - you can see whether it's a question or answer from the amount of reputation you gain; "3" is a down-vote - in this case though you can't tell questions from answers.

There are other numbers which mean rep from edits to posts and tag-wikis, but I can't find that information right now.

share|improve this answer
But is there a quick way to count all the 3's or 2's? And I'd like to be able to separate question-votes from answer-votes, if possible. –  Daniel δ Jul 16 '11 at 16:56
@drm65 yes, excel. The value on the left is the #, the value on the right is the score, the value in the middle is the post id. Ergo, upvotes on Q's are +5 (so a (3) and a 15) and upvotes on answers are +10 (so a (2) and a 20) and accepts are +15 (giving (1) and 15). If you can't figure out how to conjure those summations out of Excel ... you might need to find a new career. If I had Excel on this laptop, I would conjure you a spreadsheet, but by Monday I will have forgotten this and lost interest. –  jcolebrand Jul 16 '11 at 19:48
@drm65 Download the /reputation page to a file, then run this command in a terminal: <reputation.html awk '$1=="1" && $3=="(15)" {++a} $1=="2" {++up} $1=="3" && $3=="(-2)" {++down} END {print up " upvotes, " down " downvotes, " a " accepted answers"}' (on Windows, you'll need to install a set of unix-like command-line tools such as Cygwin). –  Gilles Jul 16 '11 at 20:07
@Gilles: I'm sorry, but I'm not a programmer. I don't understand a thing you wrote. –  Daniel δ Jul 16 '11 at 20:10

I don't think there's anywhere in the main UI that shows that information. Your profile page shows the number of votes you've cast, but not the number you've received. I guess the idea here is that your reputation reflects that, albeit in a modified way.

You can get the raw numbers by doing a query on the Stack Exchange Data Explorer (linked as "data" in the footer of the SE sites). Note that it will be current as of the last monthly dump, not up-to-the-minute.

share|improve this answer
Something like this shows total answer upvotes received for user 2303, data.stackexchange.com/english/q/105684 –  hyperslug Jul 16 '11 at 17:02

You must log in to answer this question.

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