When I count my zero-scored accepted answer on SO I get 12, but running how unsung am I query on data.stackexchange gives me just 9. Why is that?

I have seen similar results with How many upvotes do I have for each tag query. For example for python tag, it shows score of 56 on my profile page, but query shows 57. Why is it like this?

The definition of "score" as shown in the tag info says score is number of upvotes minus number of downvotes. This definition agrees with my python upvotes/score values. But strangely, my java score is 39, whereas upvotes as shown in the query is 36. How is this possible?

  • 2
    SE Data Explorer only updates something like once a week if I'm not mistaken.
    – Alex A.
    Commented Apr 9, 2016 at 16:57
  • Every Sunday at around 3:00 UTC according to data.stackexchange.com/help Commented Apr 9, 2016 at 17:05
  • @Vogel612'sShadow Are you suggesting that on Sunday the results of data explorer will be in sync with manual count result? Commented Apr 9, 2016 at 17:09
  • they should be, yes Commented Apr 9, 2016 at 17:11
  • @Vogel612'sShadow then what about the issue inconsistent score/upvote counts, e.g. in java tag for me? Commented Apr 9, 2016 at 17:14

1 Answer 1


OK, I'll start with the obvious zero scored accepted answers that don't show in the query:

  1. This answer was posted only couple of hours ago, hence still doesn't exist in SEDE data.
  2. This answer from January is self accepted, hence doesn't count toward the badge and isn't included in the query on purpose.

This leaves us with one answer that has 0 score, posted before last Monday (when SEDE was updated) and is accepted. After comparing the results from SEDE with the live list, this is the answer: basic idea of a custom tooltip, using pure Javascript

Zero score, posted over two months ago, accepted. So why it doesn't appear in SEDE? Because:

As you see, it was accepted only three days ago, after SEDE was last updated, hence as far as SEDE is concerned, it's still not accepted.

  • 1
    Thank you for such a thorough answer, just like a wizard! :D So I think I can extrapolate this idea to my java tag score mismatch too. Commented Apr 10, 2016 at 5:32
  • 1
    Cheers @Sна and keep running faster than the wind! :-D Commented Apr 10, 2016 at 6:42

You must log in to answer this question.

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