Each row in this table represents Scratch blocks that are never executed — i.e., those blocks that do not have an execution trigger or "hat block" on top. For more information on block execution refer to the project_block_stacks table.
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 0 rows with text encoding issues.
This dataset includes 2,774,865 observations. Each row of this dataset corresponds to a disconnected Scratch block associated with a sprite in a project.
| 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). |
| stack_squeak | character | Blocks that do not have any execution hat on top, and hence are never run. |
We omit 1,976,219 observations because they refer to observations in older, non-public, versions of projects that were replaced on the site. Additionally, we omit 872,414 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.