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. – Meta Andrew T. Apr 10 '14 at 2:09
  • 4
    @AndrewT. Actually it's NULL until it gets incremented for the first time. ;) – animuson Apr 10 '14 at 2:12
  • @animuson And it's not null anymore even though I un-upvoted it. :P – hichris123 Apr 10 '14 at 2:13
  • How to upvote the comment? – Gerel tumen Apr 10 '14 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). – fllo Apr 10 '14 at 2:16
  • @Fllo: where's the spam option? – Qantas 94 Heavy Apr 10 '14 at 2:24
  • @Filo Invisible to low-reps. – bjb568 Apr 10 '14 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". – fllo Apr 10 '14 at 2:31
  • @Fllo: I know there's a popup, just wondered what you meant by the "spam" option. :) – Qantas 94 Heavy Apr 10 '14 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" – fllo Apr 10 '14 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 '14 at 3:35
  • @Qantas It's the same for every site. meta.stackoverflow.com/help/privileges – bjb568 Apr 10 '14 at 4:36
  • @bjb568: I thought it was when you were able to comment, my bad. – Qantas 94 Heavy Apr 10 '14 at 4:38

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 .