3

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
10

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.

| improve this answer | |
9
+500

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.

| improve this answer | |

You must log in to answer this question.

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