12

I am curious to know how many posts (questions, in particular) have zero score because no one has ever voted on them versus posts with zero score because they have equal (non-zero) numbers of upvotes and downvotes.

Short of going through every post by hand and looking at the total upvotes and downvotes, I can't find a way to query for posts that have no votes of either kind.

I've looked at the search help page, Data Explorer, and the analytics page, and the information I want seems inaccessible.

Looking for confirmation of the unavailability of this data, or instructions for how to get it.

3
  • 1
    A related problem is sorting posts by the number of votes, up or down. A post with 10 up-votes and 8 down-votes is going to be far more interesting than a post with a score of 2, but there's no reasonable way of distinguishing between them. – Ray Butterworth Apr 30 at 0:39
  • 1
    This question really belongs on the main meta site; it isn't specific to music. – Ray Butterworth Apr 30 at 0:39
  • 1
    Here are all questions that have no up or downvotes: data.stackexchange.com/music/query/1404568 – rene May 4 at 8:49
6

Here is an attempt to break down all zero-scoring posts. The query does have a graph but it's not really informative. The first column says 'Votes' but it's actually the number of upvotes, which equals the number of downvotes. The vast majority are posts which haven't been voted on at all:

table

4
  • Music seems to be ok, but Stack Overflow has 691 posts where the zero score doesn't match the up/down votes data.stackexchange.com/stackoverflow/query/1404642/…. Dangers of denormalization I guess. – user852172 May 4 at 10:36
  • @852172 I guess those are due to a difference in when the Posts table was copied and when the Votes table was. – Glorfindel Mod May 4 at 10:44
  • It's possible but a lot of those posts are very old, and some of the differences are so large as to make that explanation unlikely, I think. – user852172 May 4 at 10:46
  • I've checked a couple of them and to all old posts happened something around the time of the snapshot: they were voted on, were deleted, etc. I'm pretty sure that explains the difference. – Glorfindel Mod May 4 at 11:31
2

Interesting question, and I found this discussion on Meta that's not exactly the same but similar. The answer (made over six years after the question was asked!) includes a Data Explorer query. You can access a Music version of this query here.

I'm not familiar enough with the code (and it's frankly too late for me to think about it now), but it seems one could easily adjust this to focus only on questions as opposed to answers, and in doing so also remove the "accepted" stipulation.

2
  • That code finds zero score posts, but not zero vote posts. – Aaron Apr 29 at 21:34
  • Oh, I guess so. Bummer...in my late-night doze, the questions I looked at all had +0/-0, but perhaps I just happened to click on the wrong ones. – Richard Apr 30 at 0:45

You must log in to answer this question.

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