project_drums Table

Overview

Each row in this table represents a drum used in the most recent version of a project shared on the Scratch website at the point of data collection. Drums could be set either by selecting the type of drum from a list of available drums (each one identified by a number), or programmatically, for example, by reading a variable or the value of the horizontal position of the mouse. Mappings of numbers to instruments follow the General MIDI Level 1 Percussion Key Map.

Description of Fields

This table includes 259,663 observations. Each row of this table corresponds to a single drum.

Variable Type Description
project_id integer Unique identifier for the project (see the projects table).
drum factor Type of drum (given as a number that represents each type of drum, e.g., the number 1 for "snare drum"). This field is missing when the drum is set programmatically, in which case the variable_drum field is used.
variable_drum factor This value is defined when drum type is set programmatically, this value represents how it is being set. For example, it can be set with a random number generator block or linked to a variable.

Summary

The distribution (log-scale) of drum is as follows:

plot of chunk unnamed-chunk-2

The distribution (log-scale) of variable_drum is as follows:

plot of chunk unnamed-chunk-3

Like the MIDI specification, the official version of Scratch only supported drums numbered 35-81. We have included 1184 observations with drum set to a number outside this range. These are likely due to invalid or corrupt data.

Omitted Observations

We omit 74,804 observations because they refer to observations in older, non-public, versions of projects that were replaced on the site. Additionally, we omit 69,754 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.