project_sprites Table

Overview

Each row in this table represents a sprite used in the most recent version of a project shared on the Scratch website at the point of data collection.

Sprites reflect the first way that Scratch projects are organized and often represent characters in an animation (e.g., a cat, a dog, etc.), or objects in a game (e.g., a ball, a space ship, etc.). Each sprite has a set of images (called "costumes" in Scratch) that represent its various visual states; for example, a sprite of a bird flying could have many images, each representing the various positions of the wings. Sprites can also have sounds associated with them; these sounds can be either recorded with the microphone or imported from the hard creator’s hard drive. Finally, "scripts," stacks of visual programming blocks, control the sprites’ behavior. Sprite names are visible in the code and are indexed so that the scripts are associated to specific spites.

Description of Fields

This table includes 12,987,630 observations. Each row of this table corresponds to a single sprite in a project.

Variable Type Description
project_id integer Unique identifier for the project (see the projects table).
scripts integer Number of scripts in the sprite.
sounds integer Number of sounds in the sprite.
images integer Number of images in the sprite.

Summary

Summary statistics for the continuous variables are as follows:

Variable Mean SD Median Min Max NAs
scripts 2.45 10.21 1 0 3896 0
sounds 0.57 1.24 0 0 900 0
images 2.80 9.90 1 0 2424 0

Omitted Observations

We omit 4,862,239 observations because they refer to observations in older, non-public, versions of projects that were replaced on the site. Additionally, we omit 3,522,491 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.