2
$\begingroup$

When you as a user get some sufficiently high reputation, you can see the up/down vote spread of any question/answer. Now suppose there's some user, X, you're interested in. On their page you can sort their questions (or answers) by score (= upvotes - downvotes). You can also do this using the Data Explorer.

Here's my question: can I run a query like that, but see the number of upvotes and the number of downvotes instead of just the score?

This would save me from having to go and open every one of X's questions, then click the score, and jot down the up/downvote count. The reason I ask is that I was recently having a discussion with another long time user and had an example in mind of a user who had a ton of both upvotes and downvotes, but it was a bit difficult to find examples of contributions by that user to serve as the example.

$\endgroup$
2
  • $\begingroup$ I changed the title, since as it was, it seemed to me ambiguous between what you intended, and asking to see a single users up/down votes across all questions they'd voted on. The first thing I thought of on reading the title was the latter. Clearly nuances like there not being a comma in a certain place means that it probably wasn't technically ambiguous, but more clarity doesn't hurt! :-) $\endgroup$
    – David Roberts Mod
    Jan 25 at 22:37
  • $\begingroup$ @DavidRoberts Ok, great, thanks! More clarity is always welcome. $\endgroup$ Jan 25 at 23:10

1 Answer 1

6
$\begingroup$

SEDE contains the table Votes which can be used for this, see also: Database schema documentation for the public data dump and SEDE.

  • Here is an example of such query - you can change userid to switch to another user and choose whether you want to see only questions, only answers or both. (Naturally you can run the same query on other sites, too. If you try some site different from MO or meta.MO, do not forget that your userid on that site is different.)
  • In your question you have linked to an example of a query for a deleted user - if this is what your interested in you can try a query like this.
  • You can easily get a query looking at anonymous feedback rather than votes from users with sufficient reputation to vote. For more info on anonymous feedback, see here.

Keep in mind that the data in SEDE is updated only once a week.

You mentioned in the question that you're looking into some users who have both many upvotes and many downvotes - here is a query listing users together with the number of upvotes and downvotes on their posts. Again, you can choose whether to count all posts, only questions or only answers.

If you want to look at some posts that have both many upvotes you can have a look at this question from Mathematics Meta: Which posts have a high value of $\min(\text{upvotes, downvotes})$? Here is a modification of a query I posted there which also shows some additional information about the post.


Unrelated to the original question - several questions which can be answered with a SEDE query have been asked recently. (Here are the graphs showing number of posts tagged per month and per year.) At least for some of those questions, the answers weren't difficult and probably anybody having some experience with SEDE and SQL would be able to answer them, I will point out that there are two chat rooms dedicated specifically to SEDE: Data Explorer (SEDE) (on MSE Chat) or SEDE - Stack Exchange Data Explorer (on SE Chat). I think that the main MathOverflow chatroom would be a reasonable place to ask about things like this, too. And you could contact me in my chatroom if needed - depending on how busy I am, I might at least try to answer. (I should add a caveat that my knowledge of SQL is rather limited - what I know I have learned from the queries I have seen in various discussions here on Stack Exchange.)

$\endgroup$
0

You must log in to answer this question.

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