I don't understand here Database schema documentation for the public data dump and SEDE the meaning of comments.score. Because I don't see any comment that has a score. So this means it is trivial field?

  • 5
    Look on the left of this comment. It's the number of upvotes and it's called score. For comments without upvotes, it's score is 0 and is not displayed. Apr 10, 2014 at 2:09
  • 4
    @AndrewT. Actually it's NULL until it gets incremented for the first time. ;)
    – animuson StaffMod
    Apr 10, 2014 at 2:12
  • @animuson And it's not null anymore even though I un-upvoted it. :P
    – hichris123
    Apr 10, 2014 at 2:13
  • How to upvote the comment? Apr 10, 2014 at 2:13
  • On the left, on rollover, you have a top arrow (click to upvote) and a flag (to flag this comment as spam, offensive or unconstructive).
    – Blo
    Apr 10, 2014 at 2:16
  • @Fllo: where's the spam option? Apr 10, 2014 at 2:24
  • @Filo Invisible to low-reps.
    – bjb568
    Apr 10, 2014 at 2:26
  • @Qantas94Heavy the little flag below the arrow display a popup with options (as rude or offensive,not constructive,obsolete,too chatty and other). I think you can add a comment to say you find that as a "spam".
    – Blo
    Apr 10, 2014 at 2:31
  • @Fllo: I know there's a popup, just wondered what you meant by the "spam" option. :) Apr 10, 2014 at 2:34
  • @Qantas94Heavy Oh sorry (I meant a comment actually) :) - however, it's not from me, the title of the flag on rollover it's "flag this comment as unconstructive, offensive, or spam"
    – Blo
    Apr 10, 2014 at 2:40
  • 1
    You can't upvote a comment because you can't upvote anything yet. Earn 15 reputation somewhere, look for a comment and have fun!
    – Braiam
    Apr 10, 2014 at 3:35
  • @Qantas It's the same for every site. meta.stackoverflow.com/help/privileges
    – bjb568
    Apr 10, 2014 at 4:36
  • @bjb568: I thought it was when you were able to comment, my bad. Apr 10, 2014 at 4:38

2 Answers 2


It is the number of upvotes (if any) that the comment got. Most comments don't get any, so you'd see nothing in that field for them.


In this screenshot I indicated what Comments.Score is:

enter image description here

And you can verify with this query that the results match.

There are a lot of comments and there are also a heck of a lot of comments with no score. I've created this query with three result sets, one which produces a graph, because a picture says more than a thousands words. It shows on the x-axis the score and on the y-xis the Log10 of the count for that score, as well as the length and # days in the same scale.

3 series: count, length and days. score is on the x-axis, LOG10 on the Y-axis. 3 lines all are high (8 -10) at 0 score and drop quickly to 1-4 for a score of 200. Longtail ends at 1400

The second and third result set return the oldest zero-scored comment

That's true. serialize() can be pretty useful for that as well. I think the trick to coming up with a viable system is finding some way to index the data nodes without killing yourself with complexity.

and the highest scored comment:

I google this every time. Related comic: https://xkcd.com/1168/

(all on Stack Overflow)

Keep in mind SEDE is updated once a week on Sunday.
Use the neat SEDE Tutorial written by the awesome Monica Cellio.
Say "Hi" in SEDE chat.


You must log in to answer this question.

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