project_block_stacks_disconnected Table

Overview

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.

Description of Fields

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.

Omitted Observations

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

Download Datasets

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