Each row in this table represents a text string — free-form text strings typed by users as part of their code — used in the most recent version of a project shared on the Scratch website at the point of data collection. These text strings include variable names, and messages that are, for example, printed on the screen via speech balloons. Some of these texts were visible when interacting with projects (e.g., speech balloons) while others are only visible by looking at the code itself (e.g. variable names).
This table includes text input directly from users. Due to technological error, data corruption, and intentional action by users, this table includes invalid UTF-8 data. For completeness sake, we have included these data. Using the find_fix_invalid_encoding_in_json.py program included in the example scripts to decode the JSON data, we found that there were 238,039 rows with text encoding issues.
This dataset includes 44,789,099 observations. Each row of this dataset corresponds to a single string of text associated with the code of a project's sprite. The row also indicates what part of the code the text is associated with, e.g., a variable name, a speech balloon, or a broadcast message.
| Variable | Type | Description |
|---|---|---|
| project_id | integer | Unique identifier for the project (see the projects table). |
| sprite_id | integer | Internal identifier for the sprite within the project (see the project_sprites table). |
| string | character | Actual text of the user generated strings. |
| string_type | factor | Type of user-generated text. The options are: variable_name, variable_value, say (for the speech balloon, broadcast (internal messaging between sprites), list_name, list_value, think, comment. |
The following table shows the distribution of string_type:
| String Type | Count |
|---|---|
| broadcast | 16155308 |
| comment | 231611 |
| list_name | 153749 |
| list_value | 18296556 |
| say | 3558455 |
| think | 212962 |
| variable_name | 3066379 |
| variable_value | 3114079 |
We omit 28,900,810 observations because they refer to observations in older, non-public, versions of projects that were replaced on the site. Additionally, we omit 16,954,772 observations from projects which are not included in our projects table (e.g., they were removed from the site by their creators).
These data are access restricted. Details on gaining access are provided in the "Permission to Use Datasets" section of the overview page.