project_strings Table

Overview

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.

Description of Fields

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.

Summary

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

Omitted Observations

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

Download Datasets

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