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?
-
5Look 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, 2014 at 2:09
-
4@AndrewT. Actually it's NULL until it gets incremented for the first time. ;)– animuson StaffModApr 10, 2014 at 2:12
-
@animuson And it's not null anymore even though I un-upvoted it. :P– hichris123Apr 10, 2014 at 2:13
-
How to upvote the comment?– Gerel tumenApr 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).– BloApr 10, 2014 at 2:16
-
@Fllo: where's the spam option?– Qantas 94 HeavyApr 10, 2014 at 2:24
-
@Filo Invisible to low-reps.– bjb568Apr 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".– BloApr 10, 2014 at 2:31
-
@Fllo: I know there's a popup, just wondered what you meant by the "spam" option. :)– Qantas 94 HeavyApr 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"– BloApr 10, 2014 at 2:40
-
Related: Database schema documentation for the public data dump and SEDE– WernerApr 10, 2014 at 3:29
-
1You can't upvote a comment because you can't upvote anything yet. Earn 15 reputation somewhere, look for a comment and have fun!– BraiamApr 10, 2014 at 3:35
-
@Qantas It's the same for every site. meta.stackoverflow.com/help/privileges– bjb568Apr 10, 2014 at 4:36
-
@bjb568: I thought it was when you were able to comment, my bad.– Qantas 94 HeavyApr 10, 2014 at 4:38
Add a comment
|
2 Answers
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.
answered Apr 10, 2014 at 3:24
In this screenshot I indicated what Comments.Score is:
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.
The second and third result set return the oldest zero-scored comment
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.
