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.
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. |

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.
These data are access restricted. Details on gaining access are provided in the "Permission to Use Datasets" section of the overview page.