gcomments Table

Overview

Each row in this table represents a comment left on a gallery. This table includes all comments that were publicly visible on every gallery page in the Scratch website at the time that these data were collected.

This table contains the metadata for these comments and includes who, when, and in which gallery each comment was posted.

Any user who was logged in could post comments on galleries. Comments were threaded in the sense that the website graphically reflected when comments were replies to other comments. Individual comments could be deleted by the creator of the gallery, administrators, or might be automatically censored.

The text or content of the comment is in the gcomments_text text table.

Description of Fields

The final includes 2,817,973 observations. Each row of this dataset corresponds to a single comment.

Variable Type Description
gcomment_id integer Unique identifier for each row in the gallery comments table, used internally, for every recorded comment as well as being displayed in URLs and links. This field is "autoincremented" and increases monotonically over time.
user_id integer Unique identifier of the user who left this comment on the gallery (see the users table).
gallery_id integer Unique identifier for the gallery that is the target of the comment , i.e., the gallery being commented on (see the galleries table).
reply_to_gcomment_id integer The unique identifier of the comment that was replied to. This is set to missing/NA if the comment is not a reply and takes a value corresponding to another 'gcomment_id' value otherwise.
date_created datetime The date that the comment was left.

Summary Statistics

plot of chunk unnamed-chunk-2

Omitted Observations

As with the pcomments table, in the MySQL database there is a comment_visibility field which includes the visibility status of comments as one of several options. Only comments marked as `visible' are included in this table. In the database, there is the following distribution of values for this field:

Status Count
censbyadmin 5038
censbycomm 509
delbyadmin 49464
delbyparentcomment 16756
delbyusr 72108
hiddenduetourl 1258
parentcommentcensored 1203
visible 3339099

There is a second Boolean field, visibility that almost always matches the comment_visibility field. Because it is the conservative course, we omit the 3 comments that are marked as visible in the comment_visibility field but marked as FALSE in the visibility field.

Second, we remove comments made by users whose profiles are not public or that are left on galleries that are not public. The distribution across these two possibilities is shown in following table:

Users Exists Gallery Exists Count
FALSE FALSE 49205
TRUE FALSE 468735
FALSE TRUE 3183
TRUE TRUE 2817973

We retain only the 2,817,973 that include all comments where both the user and galleries exists in our database.

Download Datasets

These data are access restricted. Details on gaining access are provided in the "Permission to Use Datasets" section of the overview page.